Built motion from commit 616d3211.|2.6.4
[motion2.git] / server / components / import / cm / csv.js
index 29fc0a2..a4167d3 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xf5f7=['squel','papaparse','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','redis','defaults','localhost','register','argv','undefined','null','Missing\x20filepath\x20parameter!','Missing\x20binding\x20parameters!','split','Missing\x20ListId\x20parameter!','error','contact','index','test','isNil','errors','length','map','message','join','data','firstName','firstName\x20not\x20specified!','phone','birthDate','YYYY-MM-DD','isValid','birthDate\x20format\x20is\x20invalid,\x20YYYY-MM-DD\x20format\x20is\x20supported!','email','email\x20format\x20is\x20not\x20valid!','ListId','CompanyId','find','duplicate','CmContact','create','keys','then','push','catch','Error\x20while\x20creating\x20contact:\x20','stringify','cmContact','checkHopper','inspect','into','cm_hopper','fromQuery','scheduledAt','ContactId','updatedAt','select','field','NOW()','toString','from','where','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','\x20=\x20?','insert','createdAt','cm_contacts','id\x20IN\x20?','str','VoiceQueue','findAll','dialCheckDuplicateType','Lists','get','always','sequelize','query','onlyIfOpen','VoiceQueueId','all','outbound','CmList','Campaign','CampaignId','BlackLists','cmContact,\x20%s,\x20%s','generalCheckHopper','contact:csv_','resume','resolve','emit','Unable\x20to\x20delete\x20temp\x20file:','exit','SIGINT','info','CSV\x20import\x20process\x20stopped!','createReadStream','parse','pause','CSV\x20parse\x20error','Error\x20executing\x20contact\x20csv\x20import:','bluebird','util','lodash'];(function(_0xe4b9a8,_0x149fac){var _0x2c5904=function(_0x2c091a){while(--_0x2c091a){_0xe4b9a8['push'](_0xe4b9a8['shift']());}};_0x2c5904(++_0x149fac);}(_0xf5f7,0x6a));var _0x7f5f=function(_0x3e3725,_0x574046){_0x3e3725=_0x3e3725-0x0;var _0x57d8dd=_0xf5f7[_0x3e3725];return _0x57d8dd;};'use strict';var BPromise=require(_0x7f5f('0x0'));var util=require(_0x7f5f('0x1'));var _=require(_0x7f5f('0x2'));var fs=require('fs');var squel=require(_0x7f5f('0x3'));var Papa=require(_0x7f5f('0x4'));var Redis=require(_0x7f5f('0x5'));var db=require(_0x7f5f('0x6'))['db'];var config=require(_0x7f5f('0x7'));var logger=require(_0x7f5f('0x8'))('api');config[_0x7f5f('0x9')]=_[_0x7f5f('0xa')](config[_0x7f5f('0x9')],{'host':_0x7f5f('0xb'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require('../../../api/cmContact/cmContact.socket')[_0x7f5f('0xc')](socket);try{if(!process['argv'][0x2]||process[_0x7f5f('0xd')][0x2]===_0x7f5f('0xe')||process[_0x7f5f('0xd')][0x2]===_0x7f5f('0xf')){throw new Error(_0x7f5f('0x10'));}var FILEPATH=process['argv'][0x2];if(!process[_0x7f5f('0xd')][0x3]||process[_0x7f5f('0xd')][0x3]===_0x7f5f('0xe')||process[_0x7f5f('0xd')][0x3]===_0x7f5f('0xf')||!process[_0x7f5f('0xd')][0x4]||process[_0x7f5f('0xd')][0x4]==='undefined'||process['argv'][0x4]===_0x7f5f('0xf')){throw new Error(_0x7f5f('0x11'));}var FIELDS=_['zipObject'](process[_0x7f5f('0xd')][0x3][_0x7f5f('0x12')](','),process[_0x7f5f('0xd')][0x4]['split'](','));if(!process[_0x7f5f('0xd')][0x5]||process[_0x7f5f('0xd')][0x5]===_0x7f5f('0xe')||process[_0x7f5f('0xd')][0x5]===_0x7f5f('0xf')){throw new Error(_0x7f5f('0x13'));}var LISTID=process[_0x7f5f('0xd')][0x5];var COMPANYID=process[_0x7f5f('0xd')][0x6]&&process[_0x7f5f('0xd')][0x6]!=='undefined'&&process[_0x7f5f('0xd')][0x6]!==_0x7f5f('0xf')?process['argv'][0x6]:null;var DUPLICATES=process[_0x7f5f('0xd')][0x7]&&process['argv'][0x7]!==_0x7f5f('0xe')&&process[_0x7f5f('0xd')][0x7]!==_0x7f5f('0xf')?process['argv'][0x7]:null;if(!process['argv'][0x8]||process['argv'][0x8]==='undefined'||process[_0x7f5f('0xd')][0x8]==='null'){throw new Error('Missing\x20socket_timestamp\x20parameter!');}var SOCKET_TIMESTAMP=process['argv'][0x8];}catch(_0x5756c7){logger[_0x7f5f('0x14')](_0x5756c7);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(_0x384072,_0x10bd6b,_0x117b4b,_0x1f9751){var _0x238c2b={'message':_0x10bd6b};_0x238c2b[_0x384072]=!![];if(_0x117b4b){_0x238c2b[_0x7f5f('0x15')]=_0x117b4b;}if(_0x1f9751){_0x238c2b[_0x7f5f('0x16')]=_0x1f9751;}return _0x238c2b;}function isEmail(_0x11c7ff){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))*$/[_0x7f5f('0x17')](_0x11c7ff);}function checkRow(_0xa1cee7,_0x5b4f16,_0x621ceb){return new BPromise(function(_0x32752d,_0x2d6f4e){if(_[_0x7f5f('0x18')](_0xa1cee7)){return _0x2d6f4e(handleCheckRowError('error','The\x20row\x20is\x20empty\x20or\x20the\x20number\x20of\x20parameters\x20does\x20not\x20match\x20the\x20columns!',null,_0x621ceb));}if(_0xa1cee7[_0x7f5f('0x19')]&&_0xa1cee7['errors'][_0x7f5f('0x1a')]){var _0x41b49b=_[_0x7f5f('0x1b')](_0xa1cee7[_0x7f5f('0x19')],_0x7f5f('0x1c'))[_0x7f5f('0x1d')](';');return _0x2d6f4e(handleCheckRowError('error',_0x41b49b,null,_0x621ceb));}var _0x33fec3={};for(var _0x109852 in FIELDS){if(FIELDS['hasOwnProperty'](_0x109852)&&FIELDS[_0x109852]){_0x33fec3[_0x109852]=_0xa1cee7['data'][0x0][FIELDS[_0x109852]]||_0xa1cee7[_0x7f5f('0x1e')][0x0]['\ufeff'+FIELDS[_0x109852]];}}if(!_0x33fec3[_0x7f5f('0x1f')]){return _0x2d6f4e(handleCheckRowError('error',_0x7f5f('0x20'),null,_0x621ceb));}if(!_0x33fec3[_0x7f5f('0x21')]){return _0x2d6f4e(handleCheckRowError(_0x7f5f('0x14'),'phone\x20not\x20specified!',null,_0x621ceb));}if(_0x33fec3[_0x7f5f('0x22')]){var _0x51735d=moment(_0x33fec3['birthDate'],_0x7f5f('0x23'));if(!_0x51735d[_0x7f5f('0x24')]()){return _0x2d6f4e(handleCheckRowError(_0x7f5f('0x14'),_0x7f5f('0x25'),null,_0x621ceb));}}if(_0x33fec3[_0x7f5f('0x26')]){if(!isEmail(_0x33fec3['email'])){return _0x2d6f4e(handleCheckRowError(_0x7f5f('0x14'),_0x7f5f('0x27'),null,_0x621ceb));}}_0x33fec3[_0x7f5f('0x28')]=LISTID;_0x33fec3[_0x7f5f('0x29')]=COMPANYID||undefined;if(DUPLICATES&&DUPLICATES['length']&&_0x5b4f16){var _0xe235e6={};for(var _0x29ac24=0x0,_0x36c357=DUPLICATES['length'];_0x29ac24<_0x36c357;_0x29ac24+=0x1){_0xe235e6[DUPLICATES[_0x29ac24]]=_0x33fec3[DUPLICATES[_0x29ac24]];}var _0x295f09=_[_0x7f5f('0x2a')](_0x5b4f16,_0xe235e6);if(_0x295f09){return _0x2d6f4e(handleCheckRowError(_0x7f5f('0x2b'),'Duplicate\x20Contact',_0x295f09,_0x621ceb));}}return db[_0x7f5f('0x2c')][_0x7f5f('0x2d')](_0x33fec3,{'raw':!![],'hooks':![],'fields':_[_0x7f5f('0x2e')](_0x33fec3)})[_0x7f5f('0x2f')](function(_0x1c5957){if(DUPLICATES&&DUPLICATES['length']&&_0x5b4f16){_0x5b4f16[_0x7f5f('0x30')](_['pick'](_0x33fec3,DUPLICATES));}hopperContacts+=(hopperContacts?',':'')+_0x1c5957['id'];return _0x32752d();})[_0x7f5f('0x31')](function(_0x362aa7){return _0x2d6f4e(handleCheckRowError(_0x7f5f('0x14'),_0x7f5f('0x32')+(_0x362aa7[_0x7f5f('0x1c')]||JSON[_0x7f5f('0x33')](_0x362aa7)),null,_0x621ceb));});});}function checkHopper(){function _0x1d21c8(){return function(_0x386042){logger[_0x7f5f('0x14')](_0x7f5f('0x34'),_0x7f5f('0x35'),util[_0x7f5f('0x36')](_0x386042,{'showHidden':![],'depth':null}));};}var _0x4c1d1f=function(_0x1c3b73,_0x3d0ca9){var _0x171f0c=squel['insert']()[_0x7f5f('0x37')](_0x7f5f('0x38'))[_0x7f5f('0x39')]([_0x7f5f('0x21'),_0x7f5f('0x3a'),_0x7f5f('0x3b'),_0x7f5f('0x28'),_0x3d0ca9,'createdAt',_0x7f5f('0x3c')],squel[_0x7f5f('0x3d')]()[_0x7f5f('0x3e')](_0x7f5f('0x21'),'phone')['field'](_0x7f5f('0x3f'),_0x7f5f('0x3a'))[_0x7f5f('0x3e')]('id',_0x7f5f('0x3b'))['field'](LISTID['toString'](),_0x7f5f('0x28'))[_0x7f5f('0x3e')](_0x1c3b73['id'][_0x7f5f('0x40')](),_0x3d0ca9)[_0x7f5f('0x3e')]('NOW()','createdAt')[_0x7f5f('0x3e')](_0x7f5f('0x3f'),_0x7f5f('0x3c'))[_0x7f5f('0x41')]('cm_contacts')[_0x7f5f('0x42')](_0x7f5f('0x43'))[_0x7f5f('0x42')](_0x7f5f('0x44'),LISTID[_0x7f5f('0x40')]())[_0x7f5f('0x42')](_0x7f5f('0x45'))[_0x7f5f('0x42')](_0x7f5f('0x46'),squel[_0x7f5f('0x3d')]()[_0x7f5f('0x3e')]('phone')['from'](_0x7f5f('0x38'))['where'](_0x3d0ca9+_0x7f5f('0x47'),_0x1c3b73['id'][_0x7f5f('0x40')]())))[_0x7f5f('0x40')]();return _0x171f0c;};var _0x1f1760=function(_0x93f4f,_0x4ad7ac){var _0x47cd60=squel[_0x7f5f('0x48')]()[_0x7f5f('0x37')]('cm_hopper')['fromQuery']([_0x7f5f('0x21'),'scheduledAt',_0x7f5f('0x3b'),_0x7f5f('0x28'),_0x4ad7ac,_0x7f5f('0x49'),_0x7f5f('0x3c')],squel[_0x7f5f('0x3d')]()[_0x7f5f('0x3e')](_0x7f5f('0x21'),'phone')['field'](_0x7f5f('0x3f'),'scheduledAt')[_0x7f5f('0x3e')]('id',_0x7f5f('0x3b'))[_0x7f5f('0x3e')](LISTID[_0x7f5f('0x40')](),_0x7f5f('0x28'))[_0x7f5f('0x3e')](_0x93f4f['id'][_0x7f5f('0x40')](),_0x4ad7ac)[_0x7f5f('0x3e')](_0x7f5f('0x3f'),_0x7f5f('0x49'))[_0x7f5f('0x3e')](_0x7f5f('0x3f'),_0x7f5f('0x3c'))[_0x7f5f('0x41')](_0x7f5f('0x4a'))['where'](_0x7f5f('0x43'))[_0x7f5f('0x42')]('ListId\x20=\x20?',LISTID[_0x7f5f('0x40')]())[_0x7f5f('0x42')](_0x7f5f('0x4b'),squel[_0x7f5f('0x4c')](hopperContacts))[_0x7f5f('0x42')](_0x7f5f('0x45'))['where'](_0x7f5f('0x46'),squel[_0x7f5f('0x3d')]()[_0x7f5f('0x3e')]('calleridnum')[_0x7f5f('0x41')]('cm_hopper_final')['where'](_0x4ad7ac+_0x7f5f('0x47'),_0x93f4f['id'][_0x7f5f('0x40')]()))[_0x7f5f('0x42')](_0x7f5f('0x46'),squel[_0x7f5f('0x3d')]()[_0x7f5f('0x3e')]('phone')[_0x7f5f('0x41')](_0x7f5f('0x38'))['where'](_0x4ad7ac+_0x7f5f('0x47'),_0x93f4f['id'][_0x7f5f('0x40')]())))[_0x7f5f('0x40')]();return _0x47cd60;};function _0x282163(_0x4c77e5,_0x117238){var _0x2546a0=squel[_0x7f5f('0x48')]()[_0x7f5f('0x37')](_0x7f5f('0x38'))[_0x7f5f('0x39')](['phone','scheduledAt',_0x7f5f('0x3b'),_0x7f5f('0x28'),_0x117238,'createdAt',_0x7f5f('0x3c')],squel[_0x7f5f('0x3d')]()[_0x7f5f('0x3e')](_0x7f5f('0x21'),_0x7f5f('0x21'))[_0x7f5f('0x3e')]('NOW()','scheduledAt')['field']('id',_0x7f5f('0x3b'))[_0x7f5f('0x3e')](LISTID[_0x7f5f('0x40')](),'ListId')['field'](_0x4c77e5['id'][_0x7f5f('0x40')](),_0x117238)[_0x7f5f('0x3e')](_0x7f5f('0x3f'),_0x7f5f('0x49'))[_0x7f5f('0x3e')](_0x7f5f('0x3f'),_0x7f5f('0x3c'))['from']('cm_contacts')[_0x7f5f('0x42')](_0x7f5f('0x43'))[_0x7f5f('0x42')](_0x7f5f('0x44'),LISTID[_0x7f5f('0x40')]())[_0x7f5f('0x42')]('id\x20IN\x20?',squel[_0x7f5f('0x4c')](hopperContacts))[_0x7f5f('0x42')](_0x7f5f('0x45')))[_0x7f5f('0x40')]();return _0x2546a0;}function _0x56af9c(_0x5ec11b,_0x17b3f1){var _0xf240b2=squel[_0x7f5f('0x48')]()[_0x7f5f('0x37')]('cm_hopper_black')[_0x7f5f('0x39')]([_0x7f5f('0x21'),_0x7f5f('0x3b'),_0x7f5f('0x28'),_0x17b3f1,_0x7f5f('0x49'),_0x7f5f('0x3c')],squel['select']()[_0x7f5f('0x3e')](_0x7f5f('0x21'),_0x7f5f('0x21'))[_0x7f5f('0x3e')]('id','ContactId')[_0x7f5f('0x3e')](LISTID[_0x7f5f('0x40')](),_0x7f5f('0x28'))[_0x7f5f('0x3e')](_0x5ec11b['id'][_0x7f5f('0x40')](),_0x17b3f1)[_0x7f5f('0x3e')](_0x7f5f('0x3f'),'createdAt')['field'](_0x7f5f('0x3f'),_0x7f5f('0x3c'))[_0x7f5f('0x41')](_0x7f5f('0x4a'))[_0x7f5f('0x42')](_0x7f5f('0x43'))['where'](_0x7f5f('0x44'),LISTID[_0x7f5f('0x40')]())['where'](_0x7f5f('0x4b'),squel[_0x7f5f('0x4c')](hopperContacts))['where'](_0x7f5f('0x45')))[_0x7f5f('0x40')]();return _0xf240b2;}return db[_0x7f5f('0x4d')][_0x7f5f('0x4e')]({'where':{'type':'outbound'},'attributes':['id',_0x7f5f('0x4f')],'include':[{'model':db['CmList'],'as':_0x7f5f('0x50'),'where':{'id':LISTID}}]})[_0x7f5f('0x2f')](function(_0x10943d){var _0x3767fa=[];if(_0x10943d){var _0x162ce1;for(var _0x2330f7=0x0,_0x599cdb;_0x2330f7<_0x10943d[_0x7f5f('0x1a')];_0x2330f7+=0x1){_0x599cdb=_0x10943d[_0x2330f7][_0x7f5f('0x51')]({'plain':!![]});switch(_0x599cdb[_0x7f5f('0x4f')]){case _0x7f5f('0x52'):_0x3767fa[_0x7f5f('0x30')](db[_0x7f5f('0x53')][_0x7f5f('0x54')](_0x1f1760(_0x599cdb,'VoiceQueueId'))[_0x7f5f('0x2f')](function(){})[_0x7f5f('0x31')](_0x1d21c8()));break;case _0x7f5f('0x55'):_0x3767fa[_0x7f5f('0x30')](db[_0x7f5f('0x53')]['query'](_0x4c1d1f(_0x599cdb,_0x7f5f('0x56')))['then'](function(){})[_0x7f5f('0x31')](_0x1d21c8()));break;default:_0x3767fa[_0x7f5f('0x30')](db[_0x7f5f('0x53')][_0x7f5f('0x54')](_0x282163(_0x599cdb,_0x7f5f('0x56')))[_0x7f5f('0x2f')](function(){})['catch'](_0x1d21c8()));}}}return _0x3767fa;})[_0x7f5f('0x57')]()['then'](function(){return db[_0x7f5f('0x4d')][_0x7f5f('0x4e')]({'where':{'type':_0x7f5f('0x58')},'attributes':['id'],'include':[{'model':db[_0x7f5f('0x59')],'as':'BlackLists','where':{'id':LISTID}}]})[_0x7f5f('0x2f')](function(_0x24647a){var _0x34308b=[];if(_0x24647a){var _0x496ce6;for(var _0x554c54=0x0,_0x4a0086;_0x554c54<_0x24647a[_0x7f5f('0x1a')];_0x554c54+=0x1){_0x4a0086=_0x24647a[_0x554c54][_0x7f5f('0x51')]({'plain':!![]});_0x34308b[_0x7f5f('0x30')](db[_0x7f5f('0x53')][_0x7f5f('0x54')](_0x56af9c(_0x4a0086,'VoiceQueueId'))[_0x7f5f('0x2f')](function(){})[_0x7f5f('0x31')](_0x1d21c8()));}}return _0x34308b;})['all']();})['then'](function(){return db[_0x7f5f('0x5a')]['findAll']({'attributes':['id',_0x7f5f('0x4f')],'include':[{'model':db[_0x7f5f('0x59')],'as':_0x7f5f('0x50'),'where':{'id':LISTID}}]})['then'](function(_0x4a0634){var _0x3fba38=[];if(_0x4a0634){for(var _0x50b4fb=0x0,_0x2225b7;_0x50b4fb<_0x4a0634[_0x7f5f('0x1a')];_0x50b4fb+=0x1){_0x2225b7=_0x4a0634[_0x50b4fb]['get']({'plain':!![]});switch(_0x2225b7['dialCheckDuplicateType']){case _0x7f5f('0x52'):_0x3fba38[_0x7f5f('0x30')](db['sequelize'][_0x7f5f('0x54')](_0x1f1760(_0x2225b7,_0x7f5f('0x5b')))[_0x7f5f('0x2f')](function(){})[_0x7f5f('0x31')](_0x1d21c8()));break;case _0x7f5f('0x55'):_0x3fba38[_0x7f5f('0x30')](db[_0x7f5f('0x53')]['query'](_0x4c1d1f(_0x2225b7,'CampaignId'))[_0x7f5f('0x2f')](function(){})[_0x7f5f('0x31')](_0x1d21c8()));break;default:_0x3fba38[_0x7f5f('0x30')](db['sequelize'][_0x7f5f('0x54')](_0x282163(_0x2225b7,'CampaignId'))['then'](function(){})['catch'](_0x1d21c8()));}}}return _0x3fba38;})['all']();})[_0x7f5f('0x2f')](function(){return db[_0x7f5f('0x5a')][_0x7f5f('0x4e')]({'attributes':['id'],'include':[{'model':db[_0x7f5f('0x59')],'as':_0x7f5f('0x5c'),'where':{'id':LISTID}}]})[_0x7f5f('0x2f')](function(_0x2bd6d7){var _0x4a8b74=[];if(_0x2bd6d7){for(var _0x768102=0x0,_0x262324;_0x768102<_0x2bd6d7['length'];_0x768102+=0x1){_0x262324=_0x2bd6d7[_0x768102]['get']({'plain':!![]});_0x4a8b74[_0x7f5f('0x30')](db[_0x7f5f('0x53')][_0x7f5f('0x54')](_0x56af9c(_0x262324,_0x7f5f('0x5b')))[_0x7f5f('0x2f')](function(){})['catch'](_0x1d21c8()));}}return _0x4a8b74;})['all']();})['catch'](function(_0x5e84d6){logger[_0x7f5f('0x14')](_0x7f5f('0x5d'),_0x7f5f('0x5e'),_0x5e84d6[_0x7f5f('0x1c')]);});}var processPromises=function(_0x1824f1){return BPromise['all'](promises)[_0x7f5f('0x2f')](function(_0x5973fe){})['catch'](function(_0x3b327f){logger[_0x7f5f('0x14')]('Error\x20processing\x20rows\x20block:',JSON[_0x7f5f('0x33')](_0x3b327f));})['finally'](function(){socket['emit'](_0x7f5f('0x5f')+SOCKET_TIMESTAMP,{'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});promises=[];success=0x0;errors=0x0;duplicates=0x0;rows=[];if(_0x1824f1){return _0x1824f1[_0x7f5f('0x60')]();}});};var endCsv=function(){return BPromise[_0x7f5f('0x61')]()[_0x7f5f('0x2f')](function(){if(hopperContacts){return checkHopper();}})[_0x7f5f('0x2f')](function(){socket[_0x7f5f('0x62')]('contact:csv_'+SOCKET_TIMESTAMP,{'finished':!![],'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});try{fs['unlinkSync'](FILEPATH);}catch(_0x3ba9e3){logger[_0x7f5f('0x14')](_0x7f5f('0x63'),JSON['stringify'](_0x3ba9e3));}finally{process[_0x7f5f('0x64')](0x0);}});};process['on'](_0x7f5f('0x65'),function(){logger[_0x7f5f('0x66')](_0x7f5f('0x67'));endCsv();});function main(){return BPromise[_0x7f5f('0x61')]()[_0x7f5f('0x2f')](function(){if(DUPLICATES){DUPLICATES=DUPLICATES[_0x7f5f('0x12')](',');return db[_0x7f5f('0x2c')][_0x7f5f('0x4e')]({'where':{'ListId':LISTID},'attributes':DUPLICATES,'raw':!![]});}})[_0x7f5f('0x2f')](function(_0x5e6533){var _0x73f5fe=fs[_0x7f5f('0x68')](FILEPATH,{'highWaterMark':0xf*0x400*0x400});Papa[_0x7f5f('0x69')](_0x73f5fe,{'header':!![],'skipEmptyLines':!![],'step':function(_0x112424,_0x3f4238){total+=0x1;var _0x5d9b1b=total;promises[_0x7f5f('0x30')](checkRow(_0x112424,_0x5e6533,_0x5d9b1b)[_0x7f5f('0x2f')](function(){success+=0x1;})[_0x7f5f('0x31')](function(_0x3e65e2){if(_0x3e65e2[_0x7f5f('0x14')]){errors+=0x1;delete _0x3e65e2[_0x7f5f('0x14')];}else if(_0x3e65e2[_0x7f5f('0x2b')]){duplicates+=0x1;delete _0x3e65e2[_0x7f5f('0x2b')];}rows['push'](_0x3e65e2);}));if(total%0xc8===0x0){_0x3f4238[_0x7f5f('0x6a')]();return processPromises(_0x3f4238);}},'complete':function(){return processPromises()[_0x7f5f('0x2f')](function(){logger[_0x7f5f('0x66')]('CSV\x20parsed\x20correctly!');endCsv();});},'error':function(_0x58b87a,_0x36abc6){logger['info'](_0x7f5f('0x6b'),JSON[_0x7f5f('0x33')](_0x58b87a));endCsv();}});})[_0x7f5f('0x31')](function(_0x1f8883){logger[_0x7f5f('0x14')](_0x7f5f('0x6c'),JSON[_0x7f5f('0x33')](_0x1f8883));});}main();
\ No newline at end of file
+var _0xaf54=['phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','select','\x20=\x20?','id\x20IN\x20?','calleridnum','cm_hopper_final','str','cm_hopper_black','VoiceQueue','findAll','outbound','dialCheckDuplicateType','CmList','Lists','get','always','sequelize','query','VoiceQueueId','onlyIfOpen','all','BlackLists','Campaign','CampaignId','cmContact,\x20%s,\x20%s','generalCheckHopper','Error\x20processing\x20rows\x20block:','emit','contact:csv_','resume','resolve','unlinkSync','Unable\x20to\x20delete\x20temp\x20file:','exit','SIGINT','info','CSV\x20import\x20process\x20stopped!','createReadStream','parse','pause','CSV\x20parsed\x20correctly!','CSV\x20parse\x20error','bluebird','squel','papaparse','../../../mysqldb','../../../config/environment','../../../config/logger','api','defaults','redis','localhost','../../../api/cmContact/cmContact.socket','register','argv','undefined','null','Missing\x20filepath\x20parameter!','Missing\x20binding\x20parameters!','zipObject','split','Missing\x20ListId\x20parameter!','Missing\x20socket_timestamp\x20parameter!','error','index','test','The\x20row\x20is\x20empty\x20or\x20the\x20number\x20of\x20parameters\x20does\x20not\x20match\x20the\x20columns!','errors','message','join','hasOwnProperty','data','firstName','firstName\x20not\x20specified!','phone\x20not\x20specified!','birthDate','isValid','birthDate\x20format\x20is\x20invalid,\x20YYYY-MM-DD\x20format\x20is\x20supported!','email','ListId','CompanyId','duplicate','Duplicate\x20Contact','CmContact','create','keys','then','length','push','pick','catch','Error\x20while\x20creating\x20contact:\x20','stringify','cmContact','inspect','insert','into','cm_hopper','fromQuery','phone','ContactId','createdAt','updatedAt','field','NOW()','scheduledAt','toString','from','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','where'];(function(_0x52136b,_0x524a19){var _0x3b5838=function(_0x301a6a){while(--_0x301a6a){_0x52136b['push'](_0x52136b['shift']());}};_0x3b5838(++_0x524a19);}(_0xaf54,0x9c));var _0x4af5=function(_0x21b36c,_0x543483){_0x21b36c=_0x21b36c-0x0;var _0x236627=_0xaf54[_0x21b36c];return _0x236627;};'use strict';var BPromise=require(_0x4af5('0x0'));var util=require('util');var _=require('lodash');var fs=require('fs');var squel=require(_0x4af5('0x1'));var Papa=require(_0x4af5('0x2'));var Redis=require('ioredis');var db=require(_0x4af5('0x3'))['db'];var config=require(_0x4af5('0x4'));var logger=require(_0x4af5('0x5'))(_0x4af5('0x6'));config['redis']=_[_0x4af5('0x7')](config[_0x4af5('0x8')],{'host':_0x4af5('0x9'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0x4af5('0xa'))[_0x4af5('0xb')](socket);try{if(!process[_0x4af5('0xc')][0x2]||process[_0x4af5('0xc')][0x2]===_0x4af5('0xd')||process[_0x4af5('0xc')][0x2]===_0x4af5('0xe')){throw new Error(_0x4af5('0xf'));}var FILEPATH=process[_0x4af5('0xc')][0x2];if(!process[_0x4af5('0xc')][0x3]||process[_0x4af5('0xc')][0x3]===_0x4af5('0xd')||process[_0x4af5('0xc')][0x3]===_0x4af5('0xe')||!process['argv'][0x4]||process[_0x4af5('0xc')][0x4]===_0x4af5('0xd')||process['argv'][0x4]===_0x4af5('0xe')){throw new Error(_0x4af5('0x10'));}var FIELDS=_[_0x4af5('0x11')](process[_0x4af5('0xc')][0x3][_0x4af5('0x12')](','),process['argv'][0x4][_0x4af5('0x12')](','));if(!process[_0x4af5('0xc')][0x5]||process[_0x4af5('0xc')][0x5]===_0x4af5('0xd')||process[_0x4af5('0xc')][0x5]===_0x4af5('0xe')){throw new Error(_0x4af5('0x13'));}var LISTID=process[_0x4af5('0xc')][0x5];var COMPANYID=process[_0x4af5('0xc')][0x6]&&process['argv'][0x6]!=='undefined'&&process[_0x4af5('0xc')][0x6]!==_0x4af5('0xe')?process['argv'][0x6]:null;var DUPLICATES=process['argv'][0x7]&&process[_0x4af5('0xc')][0x7]!==_0x4af5('0xd')&&process['argv'][0x7]!==_0x4af5('0xe')?process[_0x4af5('0xc')][0x7]:null;if(!process[_0x4af5('0xc')][0x8]||process['argv'][0x8]===_0x4af5('0xd')||process[_0x4af5('0xc')][0x8]===_0x4af5('0xe')){throw new Error(_0x4af5('0x14'));}var SOCKET_TIMESTAMP=process['argv'][0x8];}catch(_0x5a18e2){logger[_0x4af5('0x15')](_0x5a18e2);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(_0x507483,_0x41c572,_0x20a403,_0x1cbb24){var _0x405638={'message':_0x41c572};_0x405638[_0x507483]=!![];if(_0x20a403){_0x405638['contact']=_0x20a403;}if(_0x1cbb24){_0x405638[_0x4af5('0x16')]=_0x1cbb24;}return _0x405638;}function isEmail(_0x25f767){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))*$/[_0x4af5('0x17')](_0x25f767);}function checkRow(_0x340f68,_0x6ecefb,_0x510e33){return new BPromise(function(_0x17c6b5,_0x333ef4){if(_['isNil'](_0x340f68)){return _0x333ef4(handleCheckRowError(_0x4af5('0x15'),_0x4af5('0x18'),null,_0x510e33));}if(_0x340f68[_0x4af5('0x19')]&&_0x340f68[_0x4af5('0x19')]['length']){var _0x1ea135=_['map'](_0x340f68[_0x4af5('0x19')],_0x4af5('0x1a'))[_0x4af5('0x1b')](';');return _0x333ef4(handleCheckRowError(_0x4af5('0x15'),_0x1ea135,null,_0x510e33));}var _0x4cd7f9={};for(var _0x350c78 in FIELDS){if(FIELDS[_0x4af5('0x1c')](_0x350c78)&&FIELDS[_0x350c78]){_0x4cd7f9[_0x350c78]=_0x340f68['data'][0x0][FIELDS[_0x350c78]]||_0x340f68[_0x4af5('0x1d')][0x0]['\ufeff'+FIELDS[_0x350c78]];}}if(!_0x4cd7f9[_0x4af5('0x1e')]){return _0x333ef4(handleCheckRowError(_0x4af5('0x15'),_0x4af5('0x1f'),null,_0x510e33));}if(!_0x4cd7f9['phone']){return _0x333ef4(handleCheckRowError(_0x4af5('0x15'),_0x4af5('0x20'),null,_0x510e33));}if(_0x4cd7f9[_0x4af5('0x21')]){var _0x1fe93e=moment(_0x4cd7f9[_0x4af5('0x21')],'YYYY-MM-DD');if(!_0x1fe93e[_0x4af5('0x22')]()){return _0x333ef4(handleCheckRowError(_0x4af5('0x15'),_0x4af5('0x23'),null,_0x510e33));}}if(_0x4cd7f9[_0x4af5('0x24')]){if(!isEmail(_0x4cd7f9[_0x4af5('0x24')])){return _0x333ef4(handleCheckRowError(_0x4af5('0x15'),'email\x20format\x20is\x20not\x20valid!',null,_0x510e33));}}_0x4cd7f9[_0x4af5('0x25')]=LISTID;_0x4cd7f9[_0x4af5('0x26')]=COMPANYID||undefined;if(DUPLICATES&&DUPLICATES['length']&&_0x6ecefb){var _0x2728b2={};for(var _0x3f72ca=0x0,_0x20cec8=DUPLICATES['length'];_0x3f72ca<_0x20cec8;_0x3f72ca+=0x1){_0x2728b2[DUPLICATES[_0x3f72ca]]=_0x4cd7f9[DUPLICATES[_0x3f72ca]];}var _0x509a86=_['find'](_0x6ecefb,_0x2728b2);if(_0x509a86){return _0x333ef4(handleCheckRowError(_0x4af5('0x27'),_0x4af5('0x28'),_0x509a86,_0x510e33));}}return db[_0x4af5('0x29')][_0x4af5('0x2a')](_0x4cd7f9,{'raw':!![],'hooks':![],'fields':_[_0x4af5('0x2b')](_0x4cd7f9)})[_0x4af5('0x2c')](function(_0x46f081){if(DUPLICATES&&DUPLICATES[_0x4af5('0x2d')]&&_0x6ecefb){_0x6ecefb[_0x4af5('0x2e')](_[_0x4af5('0x2f')](_0x4cd7f9,DUPLICATES));}hopperContacts+=(hopperContacts?',':'')+_0x46f081['id'];return _0x17c6b5();})[_0x4af5('0x30')](function(_0x4845fe){return _0x333ef4(handleCheckRowError(_0x4af5('0x15'),_0x4af5('0x31')+(_0x4845fe[_0x4af5('0x1a')]||JSON[_0x4af5('0x32')](_0x4845fe)),null,_0x510e33));});});}function checkHopper(){function _0x5a37c1(){return function(_0x2bf524){logger[_0x4af5('0x15')](_0x4af5('0x33'),'checkHopper',util[_0x4af5('0x34')](_0x2bf524,{'showHidden':![],'depth':null}));};}var _0x5a0606=function(_0x39164c,_0x2116de){var _0x257664=squel[_0x4af5('0x35')]()[_0x4af5('0x36')](_0x4af5('0x37'))[_0x4af5('0x38')]([_0x4af5('0x39'),'scheduledAt',_0x4af5('0x3a'),_0x4af5('0x25'),_0x2116de,_0x4af5('0x3b'),_0x4af5('0x3c')],squel['select']()[_0x4af5('0x3d')](_0x4af5('0x39'),_0x4af5('0x39'))[_0x4af5('0x3d')](_0x4af5('0x3e'),_0x4af5('0x3f'))['field']('id','ContactId')[_0x4af5('0x3d')](LISTID[_0x4af5('0x40')](),_0x4af5('0x25'))[_0x4af5('0x3d')](_0x39164c['id'][_0x4af5('0x40')](),_0x2116de)[_0x4af5('0x3d')](_0x4af5('0x3e'),_0x4af5('0x3b'))[_0x4af5('0x3d')]('NOW()','updatedAt')[_0x4af5('0x41')](_0x4af5('0x42'))['where'](_0x4af5('0x43'))['where'](_0x4af5('0x44'),LISTID[_0x4af5('0x40')]())[_0x4af5('0x45')](_0x4af5('0x46'))[_0x4af5('0x45')](_0x4af5('0x47'),squel[_0x4af5('0x48')]()[_0x4af5('0x3d')](_0x4af5('0x39'))[_0x4af5('0x41')](_0x4af5('0x37'))[_0x4af5('0x45')](_0x2116de+_0x4af5('0x49'),_0x39164c['id'][_0x4af5('0x40')]())))['toString']();return _0x257664;};var _0x2f9ba3=function(_0x5cdce0,_0x24527e){var _0x463aab=squel['insert']()[_0x4af5('0x36')](_0x4af5('0x37'))['fromQuery'](['phone',_0x4af5('0x3f'),_0x4af5('0x3a'),'ListId',_0x24527e,_0x4af5('0x3b'),_0x4af5('0x3c')],squel[_0x4af5('0x48')]()[_0x4af5('0x3d')](_0x4af5('0x39'),_0x4af5('0x39'))[_0x4af5('0x3d')](_0x4af5('0x3e'),_0x4af5('0x3f'))['field']('id',_0x4af5('0x3a'))['field'](LISTID[_0x4af5('0x40')](),_0x4af5('0x25'))[_0x4af5('0x3d')](_0x5cdce0['id'][_0x4af5('0x40')](),_0x24527e)[_0x4af5('0x3d')](_0x4af5('0x3e'),_0x4af5('0x3b'))[_0x4af5('0x3d')](_0x4af5('0x3e'),_0x4af5('0x3c'))[_0x4af5('0x41')]('cm_contacts')['where'](_0x4af5('0x43'))[_0x4af5('0x45')](_0x4af5('0x44'),LISTID[_0x4af5('0x40')]())[_0x4af5('0x45')](_0x4af5('0x4a'),squel['str'](hopperContacts))['where'](_0x4af5('0x46'))[_0x4af5('0x45')]('phone\x20NOT\x20IN\x20(?)',squel[_0x4af5('0x48')]()[_0x4af5('0x3d')](_0x4af5('0x4b'))['from'](_0x4af5('0x4c'))[_0x4af5('0x45')](_0x24527e+_0x4af5('0x49'),_0x5cdce0['id'][_0x4af5('0x40')]()))[_0x4af5('0x45')](_0x4af5('0x47'),squel[_0x4af5('0x48')]()[_0x4af5('0x3d')](_0x4af5('0x39'))[_0x4af5('0x41')](_0x4af5('0x37'))[_0x4af5('0x45')](_0x24527e+_0x4af5('0x49'),_0x5cdce0['id'][_0x4af5('0x40')]())))[_0x4af5('0x40')]();return _0x463aab;};function _0x2c7c00(_0x131d27,_0x5353c2){var _0x599d7b=squel[_0x4af5('0x35')]()['into'](_0x4af5('0x37'))[_0x4af5('0x38')]([_0x4af5('0x39'),_0x4af5('0x3f'),_0x4af5('0x3a'),'ListId',_0x5353c2,_0x4af5('0x3b'),'updatedAt'],squel['select']()[_0x4af5('0x3d')](_0x4af5('0x39'),'phone')['field']('NOW()',_0x4af5('0x3f'))['field']('id',_0x4af5('0x3a'))['field'](LISTID[_0x4af5('0x40')](),_0x4af5('0x25'))[_0x4af5('0x3d')](_0x131d27['id'][_0x4af5('0x40')](),_0x5353c2)['field']('NOW()','createdAt')[_0x4af5('0x3d')]('NOW()',_0x4af5('0x3c'))[_0x4af5('0x41')](_0x4af5('0x42'))[_0x4af5('0x45')]('deletedAt\x20IS\x20NULL')['where'](_0x4af5('0x44'),LISTID[_0x4af5('0x40')]())[_0x4af5('0x45')](_0x4af5('0x4a'),squel[_0x4af5('0x4d')](hopperContacts))[_0x4af5('0x45')](_0x4af5('0x46')))[_0x4af5('0x40')]();return _0x599d7b;}function _0x7c3147(_0x90692f,_0x239287){var _0x272f40=squel[_0x4af5('0x35')]()[_0x4af5('0x36')](_0x4af5('0x4e'))[_0x4af5('0x38')](['phone',_0x4af5('0x3a'),_0x4af5('0x25'),_0x239287,_0x4af5('0x3b'),_0x4af5('0x3c')],squel[_0x4af5('0x48')]()['field'](_0x4af5('0x39'),_0x4af5('0x39'))[_0x4af5('0x3d')]('id','ContactId')['field'](LISTID[_0x4af5('0x40')](),_0x4af5('0x25'))[_0x4af5('0x3d')](_0x90692f['id']['toString'](),_0x239287)[_0x4af5('0x3d')]('NOW()',_0x4af5('0x3b'))[_0x4af5('0x3d')]('NOW()','updatedAt')['from'](_0x4af5('0x42'))[_0x4af5('0x45')]('deletedAt\x20IS\x20NULL')[_0x4af5('0x45')](_0x4af5('0x44'),LISTID[_0x4af5('0x40')]())[_0x4af5('0x45')](_0x4af5('0x4a'),squel[_0x4af5('0x4d')](hopperContacts))['where'](_0x4af5('0x46')))[_0x4af5('0x40')]();return _0x272f40;}return db[_0x4af5('0x4f')][_0x4af5('0x50')]({'where':{'type':_0x4af5('0x51')},'attributes':['id',_0x4af5('0x52')],'include':[{'model':db[_0x4af5('0x53')],'as':_0x4af5('0x54'),'where':{'id':LISTID}}]})[_0x4af5('0x2c')](function(_0x5b1f99){var _0x6a852e=[];if(_0x5b1f99){var _0x1c9971;for(var _0x336ce0=0x0,_0xc40721;_0x336ce0<_0x5b1f99['length'];_0x336ce0+=0x1){_0xc40721=_0x5b1f99[_0x336ce0][_0x4af5('0x55')]({'plain':!![]});switch(_0xc40721[_0x4af5('0x52')]){case _0x4af5('0x56'):_0x6a852e[_0x4af5('0x2e')](db[_0x4af5('0x57')][_0x4af5('0x58')](_0x2f9ba3(_0xc40721,_0x4af5('0x59')))[_0x4af5('0x2c')](function(){})[_0x4af5('0x30')](_0x5a37c1()));break;case _0x4af5('0x5a'):_0x6a852e['push'](db[_0x4af5('0x57')][_0x4af5('0x58')](_0x5a0606(_0xc40721,'VoiceQueueId'))[_0x4af5('0x2c')](function(){})['catch'](_0x5a37c1()));break;default:_0x6a852e['push'](db['sequelize']['query'](_0x2c7c00(_0xc40721,'VoiceQueueId'))['then'](function(){})[_0x4af5('0x30')](_0x5a37c1()));}}}return _0x6a852e;})[_0x4af5('0x5b')]()[_0x4af5('0x2c')](function(){return db[_0x4af5('0x4f')][_0x4af5('0x50')]({'where':{'type':_0x4af5('0x51')},'attributes':['id'],'include':[{'model':db[_0x4af5('0x53')],'as':_0x4af5('0x5c'),'where':{'id':LISTID}}]})['then'](function(_0x3e86da){var _0xf0da23=[];if(_0x3e86da){var _0xa84158;for(var _0x1b26f2=0x0,_0x3e3af7;_0x1b26f2<_0x3e86da[_0x4af5('0x2d')];_0x1b26f2+=0x1){_0x3e3af7=_0x3e86da[_0x1b26f2][_0x4af5('0x55')]({'plain':!![]});_0xf0da23[_0x4af5('0x2e')](db['sequelize'][_0x4af5('0x58')](_0x7c3147(_0x3e3af7,_0x4af5('0x59')))[_0x4af5('0x2c')](function(){})['catch'](_0x5a37c1()));}}return _0xf0da23;})[_0x4af5('0x5b')]();})[_0x4af5('0x2c')](function(){return db[_0x4af5('0x5d')][_0x4af5('0x50')]({'attributes':['id','dialCheckDuplicateType'],'include':[{'model':db[_0x4af5('0x53')],'as':_0x4af5('0x54'),'where':{'id':LISTID}}]})[_0x4af5('0x2c')](function(_0x16161b){var _0x3735e0=[];if(_0x16161b){for(var _0x5c5a4c=0x0,_0x317a19;_0x5c5a4c<_0x16161b[_0x4af5('0x2d')];_0x5c5a4c+=0x1){_0x317a19=_0x16161b[_0x5c5a4c][_0x4af5('0x55')]({'plain':!![]});switch(_0x317a19[_0x4af5('0x52')]){case _0x4af5('0x56'):_0x3735e0[_0x4af5('0x2e')](db[_0x4af5('0x57')][_0x4af5('0x58')](_0x2f9ba3(_0x317a19,_0x4af5('0x5e')))[_0x4af5('0x2c')](function(){})['catch'](_0x5a37c1()));break;case _0x4af5('0x5a'):_0x3735e0[_0x4af5('0x2e')](db[_0x4af5('0x57')]['query'](_0x5a0606(_0x317a19,_0x4af5('0x5e')))[_0x4af5('0x2c')](function(){})[_0x4af5('0x30')](_0x5a37c1()));break;default:_0x3735e0[_0x4af5('0x2e')](db[_0x4af5('0x57')][_0x4af5('0x58')](_0x2c7c00(_0x317a19,_0x4af5('0x5e')))['then'](function(){})[_0x4af5('0x30')](_0x5a37c1()));}}}return _0x3735e0;})[_0x4af5('0x5b')]();})['then'](function(){return db[_0x4af5('0x5d')]['findAll']({'attributes':['id'],'include':[{'model':db['CmList'],'as':_0x4af5('0x5c'),'where':{'id':LISTID}}]})['then'](function(_0x2afa40){var _0x41cc0b=[];if(_0x2afa40){for(var _0x4ac39b=0x0,_0x3b3cc2;_0x4ac39b<_0x2afa40[_0x4af5('0x2d')];_0x4ac39b+=0x1){_0x3b3cc2=_0x2afa40[_0x4ac39b][_0x4af5('0x55')]({'plain':!![]});_0x41cc0b[_0x4af5('0x2e')](db[_0x4af5('0x57')][_0x4af5('0x58')](_0x7c3147(_0x3b3cc2,_0x4af5('0x5e')))[_0x4af5('0x2c')](function(){})[_0x4af5('0x30')](_0x5a37c1()));}}return _0x41cc0b;})['all']();})[_0x4af5('0x30')](function(_0x49cdfe){logger[_0x4af5('0x15')](_0x4af5('0x5f'),_0x4af5('0x60'),_0x49cdfe[_0x4af5('0x1a')]);});}var processPromises=function(_0x3d49ef){return BPromise[_0x4af5('0x5b')](promises)[_0x4af5('0x2c')](function(_0x2b0f41){})[_0x4af5('0x30')](function(_0x5e83d2){logger[_0x4af5('0x15')](_0x4af5('0x61'),JSON[_0x4af5('0x32')](_0x5e83d2));})['finally'](function(){socket[_0x4af5('0x62')](_0x4af5('0x63')+SOCKET_TIMESTAMP,{'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});promises=[];success=0x0;errors=0x0;duplicates=0x0;rows=[];if(_0x3d49ef){return _0x3d49ef[_0x4af5('0x64')]();}});};var endCsv=function(){return BPromise[_0x4af5('0x65')]()[_0x4af5('0x2c')](function(){if(hopperContacts){return checkHopper();}})[_0x4af5('0x2c')](function(){socket[_0x4af5('0x62')](_0x4af5('0x63')+SOCKET_TIMESTAMP,{'finished':!![],'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});try{fs[_0x4af5('0x66')](FILEPATH);}catch(_0x273720){logger[_0x4af5('0x15')](_0x4af5('0x67'),JSON[_0x4af5('0x32')](_0x273720));}finally{process[_0x4af5('0x68')](0x0);}});};process['on'](_0x4af5('0x69'),function(){logger[_0x4af5('0x6a')](_0x4af5('0x6b'));endCsv();});function main(){return BPromise[_0x4af5('0x65')]()[_0x4af5('0x2c')](function(){if(DUPLICATES){DUPLICATES=DUPLICATES['split'](',');return db[_0x4af5('0x29')][_0x4af5('0x50')]({'where':{'ListId':LISTID},'attributes':DUPLICATES,'raw':!![]});}})[_0x4af5('0x2c')](function(_0x258302){var _0xaa5651=fs[_0x4af5('0x6c')](FILEPATH,{'highWaterMark':0xf*0x400*0x400});Papa[_0x4af5('0x6d')](_0xaa5651,{'header':!![],'skipEmptyLines':!![],'step':function(_0x44b53a,_0x4f35bd){total+=0x1;var _0x1b5cd9=total;promises[_0x4af5('0x2e')](checkRow(_0x44b53a,_0x258302,_0x1b5cd9)['then'](function(){success+=0x1;})[_0x4af5('0x30')](function(_0x170724){if(_0x170724['error']){errors+=0x1;delete _0x170724[_0x4af5('0x15')];}else if(_0x170724[_0x4af5('0x27')]){duplicates+=0x1;delete _0x170724[_0x4af5('0x27')];}rows[_0x4af5('0x2e')](_0x170724);}));if(total%0xc8===0x0){_0x4f35bd[_0x4af5('0x6e')]();return processPromises(_0x4f35bd);}},'complete':function(){return processPromises()[_0x4af5('0x2c')](function(){logger[_0x4af5('0x6a')](_0x4af5('0x6f'));endCsv();});},'error':function(_0x11f3a4,_0x488360){logger[_0x4af5('0x6a')](_0x4af5('0x70'),JSON[_0x4af5('0x32')](_0x11f3a4));endCsv();}});})['catch'](function(_0x588857){logger[_0x4af5('0x15')]('Error\x20executing\x20contact\x20csv\x20import:',JSON['stringify'](_0x588857));});}main();
\ No newline at end of file