Built motion from commit (unavailable).|2.0.80
[motion2.git] / server / components / import / cm / csv.js
index 11f333c..e444508 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x68fc=['phone','scheduledAt','ContactId','select','field','NOW()','toString','createdAt','updatedAt','from','cm_contacts','where','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','\x20=\x20?','deletedAt\x20IS\x20NULL','id\x20IN\x20?','calleridnum','cm_hopper_final','str','cm_hopper_black','VoiceQueue','dialCheckDuplicateType','CmList','Lists','get','always','sequelize','query','VoiceQueueId','catch','all','findAll','outbound','BlackLists','CampaignId','onlyIfOpen','Campaign','cmContact,\x20%s,\x20%s','generalCheckHopper','Error\x20processing\x20rows\x20block:','finally','emit','contact:csv_','resume','resolve','unlinkSync','exit','SIGINT','info','CSV\x20import\x20process\x20stopped!','createReadStream','parse','pause','CSV\x20parsed\x20correctly!','CSV\x20parse\x20error','bluebird','../../../mysqldb','../../../config/logger','lodash','papaparse','../../../api/cmContact/cmContact.socket','register','argv','null','Missing\x20filepath\x20parameter!','undefined','Missing\x20binding\x20parameters!','zipObject','split','Missing\x20ListId\x20parameter!','Missing\x20socket_timestamp\x20parameter!','error','contact','test','The\x20row\x20is\x20empty\x20or\x20the\x20number\x20of\x20parameters\x20does\x20not\x20match\x20the\x20columns!','errors','length','map','join','hasOwnProperty','data','firstName','firstName\x20not\x20specified!','phone\x20not\x20specified!','birthDate','YYYY-MM-DD','isValid','email','email\x20format\x20is\x20not\x20valid!','ListId','CompanyId','find','duplicate','Duplicate\x20Contact','CmContact','then','push','pick','message','stringify','cmContact','checkHopper','insert','into','cm_hopper','fromQuery'];(function(_0x37daeb,_0x14a927){var _0x3829bb=function(_0x3362ef){while(--_0x3362ef){_0x37daeb['push'](_0x37daeb['shift']());}};_0x3829bb(++_0x14a927);}(_0x68fc,0xa5));var _0xc68f=function(_0x1adbd7,_0x154b58){_0x1adbd7=_0x1adbd7-0x0;var _0x33b81b=_0x68fc[_0x1adbd7];return _0x33b81b;};'use strict';var BPromise=require(_0xc68f('0x0'));var db=require(_0xc68f('0x1'))['db'];var logger=require(_0xc68f('0x2'))('api');var util=require('util');var _=require(_0xc68f('0x3'));var fs=require('fs');var squel=require('squel');var Papa=require(_0xc68f('0x4'));var socket=require('socket.io-emitter')({'host':'localhost','port':0x18eb});require(_0xc68f('0x5'))[_0xc68f('0x6')](socket);try{if(!process[_0xc68f('0x7')][0x2]||process[_0xc68f('0x7')][0x2]==='undefined'||process['argv'][0x2]===_0xc68f('0x8')){throw new Error(_0xc68f('0x9'));}var FILEPATH=process[_0xc68f('0x7')][0x2];if(!process[_0xc68f('0x7')][0x3]||process[_0xc68f('0x7')][0x3]===_0xc68f('0xa')||process[_0xc68f('0x7')][0x3]===_0xc68f('0x8')||!process[_0xc68f('0x7')][0x4]||process[_0xc68f('0x7')][0x4]==='undefined'||process[_0xc68f('0x7')][0x4]===_0xc68f('0x8')){throw new Error(_0xc68f('0xb'));}var FIELDS=_[_0xc68f('0xc')](process[_0xc68f('0x7')][0x3][_0xc68f('0xd')](','),process[_0xc68f('0x7')][0x4][_0xc68f('0xd')](','));if(!process[_0xc68f('0x7')][0x5]||process[_0xc68f('0x7')][0x5]===_0xc68f('0xa')||process['argv'][0x5]===_0xc68f('0x8')){throw new Error(_0xc68f('0xe'));}var LISTID=process[_0xc68f('0x7')][0x5];var COMPANYID=process[_0xc68f('0x7')][0x6]&&process[_0xc68f('0x7')][0x6]!==_0xc68f('0xa')&&process[_0xc68f('0x7')][0x6]!==_0xc68f('0x8')?process[_0xc68f('0x7')][0x6]:null;var DUPLICATES=process['argv'][0x7]&&process['argv'][0x7]!==_0xc68f('0xa')&&process[_0xc68f('0x7')][0x7]!==_0xc68f('0x8')?process[_0xc68f('0x7')][0x7]:null;if(!process[_0xc68f('0x7')][0x8]||process[_0xc68f('0x7')][0x8]==='undefined'||process[_0xc68f('0x7')][0x8]===_0xc68f('0x8')){throw new Error(_0xc68f('0xf'));}var SOCKET_TIMESTAMP=process[_0xc68f('0x7')][0x8];}catch(_0x5068fd){logger[_0xc68f('0x10')](_0x5068fd);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(_0xa58c8d,_0x3c32c8,_0x582301,_0xcc11a3){var _0x2b48b7={'message':_0x3c32c8};_0x2b48b7[_0xa58c8d]=!![];if(_0x582301){_0x2b48b7[_0xc68f('0x11')]=_0x582301;}if(_0xcc11a3){_0x2b48b7['index']=_0xcc11a3;}return _0x2b48b7;}function isEmail(_0x1dad07){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))*$/[_0xc68f('0x12')](_0x1dad07);}function checkRow(_0x116203,_0x2064db,_0x2f6785){return new BPromise(function(_0x3da6d9,_0x2412a9){if(_['isNil'](_0x116203)){return _0x2412a9(handleCheckRowError(_0xc68f('0x10'),_0xc68f('0x13'),null,_0x2f6785));}if(_0x116203['errors']&&_0x116203[_0xc68f('0x14')][_0xc68f('0x15')]){var _0x35945b=_[_0xc68f('0x16')](_0x116203[_0xc68f('0x14')],'message')[_0xc68f('0x17')](';');return _0x2412a9(handleCheckRowError(_0xc68f('0x10'),_0x35945b,null,_0x2f6785));}var _0x5d4632={};for(var _0x38b935 in FIELDS){if(FIELDS[_0xc68f('0x18')](_0x38b935)&&FIELDS[_0x38b935]){_0x5d4632[_0x38b935]=_0x116203['data'][0x0][FIELDS[_0x38b935]]||_0x116203[_0xc68f('0x19')][0x0]['\ufeff'+FIELDS[_0x38b935]];}}if(!_0x5d4632[_0xc68f('0x1a')]){return _0x2412a9(handleCheckRowError(_0xc68f('0x10'),_0xc68f('0x1b'),null,_0x2f6785));}if(!_0x5d4632['phone']){return _0x2412a9(handleCheckRowError(_0xc68f('0x10'),_0xc68f('0x1c'),null,_0x2f6785));}if(_0x5d4632[_0xc68f('0x1d')]){var _0x435482=moment(_0x5d4632[_0xc68f('0x1d')],_0xc68f('0x1e'));if(!_0x435482[_0xc68f('0x1f')]()){return _0x2412a9(handleCheckRowError(_0xc68f('0x10'),'birthDate\x20format\x20is\x20invalid,\x20YYYY-MM-DD\x20format\x20is\x20supported!',null,_0x2f6785));}}if(_0x5d4632[_0xc68f('0x20')]){if(!isEmail(_0x5d4632[_0xc68f('0x20')])){return _0x2412a9(handleCheckRowError('error',_0xc68f('0x21'),null,_0x2f6785));}}_0x5d4632[_0xc68f('0x22')]=LISTID;_0x5d4632[_0xc68f('0x23')]=COMPANYID||undefined;if(DUPLICATES&&DUPLICATES[_0xc68f('0x15')]&&_0x2064db){var _0x51e82c={};for(var _0x1deee7=0x0,_0x16e1d0=DUPLICATES['length'];_0x1deee7<_0x16e1d0;_0x1deee7+=0x1){_0x51e82c[DUPLICATES[_0x1deee7]]=_0x5d4632[DUPLICATES[_0x1deee7]];}var _0x6f3af7=_[_0xc68f('0x24')](_0x2064db,_0x51e82c);if(_0x6f3af7){return _0x2412a9(handleCheckRowError(_0xc68f('0x25'),_0xc68f('0x26'),_0x6f3af7,_0x2f6785));}}return db[_0xc68f('0x27')]['create'](_0x5d4632,{'raw':!![],'hooks':![],'fields':_['keys'](_0x5d4632)})[_0xc68f('0x28')](function(_0x346b05){if(DUPLICATES&&DUPLICATES[_0xc68f('0x15')]&&_0x2064db){_0x2064db[_0xc68f('0x29')](_[_0xc68f('0x2a')](_0x5d4632,DUPLICATES));}hopperContacts+=(hopperContacts?',':'')+_0x346b05['id'];return _0x3da6d9();})['catch'](function(_0x4aa4fb){return _0x2412a9(handleCheckRowError(_0xc68f('0x10'),'Error\x20while\x20creating\x20contact:\x20'+(_0x4aa4fb[_0xc68f('0x2b')]||JSON[_0xc68f('0x2c')](_0x4aa4fb)),null,_0x2f6785));});});}function checkHopper(){function _0x3ce5b5(){return function(_0x3eee68){logger[_0xc68f('0x10')](_0xc68f('0x2d'),_0xc68f('0x2e'),util['inspect'](_0x3eee68,{'showHidden':![],'depth':null}));};}var _0x4282b7=function(_0x3e4aac,_0x8ce922){var _0x360810=squel[_0xc68f('0x2f')]()[_0xc68f('0x30')](_0xc68f('0x31'))[_0xc68f('0x32')]([_0xc68f('0x33'),_0xc68f('0x34'),_0xc68f('0x35'),'ListId',_0x8ce922,'createdAt','updatedAt'],squel[_0xc68f('0x36')]()[_0xc68f('0x37')](_0xc68f('0x33'),_0xc68f('0x33'))['field'](_0xc68f('0x38'),_0xc68f('0x34'))[_0xc68f('0x37')]('id','ContactId')[_0xc68f('0x37')](LISTID[_0xc68f('0x39')](),'ListId')[_0xc68f('0x37')](_0x3e4aac['id'][_0xc68f('0x39')](),_0x8ce922)[_0xc68f('0x37')]('NOW()',_0xc68f('0x3a'))[_0xc68f('0x37')](_0xc68f('0x38'),_0xc68f('0x3b'))[_0xc68f('0x3c')](_0xc68f('0x3d'))[_0xc68f('0x3e')]('deletedAt\x20IS\x20NULL')[_0xc68f('0x3e')](_0xc68f('0x3f'),LISTID[_0xc68f('0x39')]())[_0xc68f('0x3e')](_0xc68f('0x40'))[_0xc68f('0x3e')](_0xc68f('0x41'),squel[_0xc68f('0x36')]()[_0xc68f('0x37')]('phone')[_0xc68f('0x3c')](_0xc68f('0x31'))[_0xc68f('0x3e')](_0x8ce922+_0xc68f('0x42'),_0x3e4aac['id'][_0xc68f('0x39')]())))[_0xc68f('0x39')]();return _0x360810;};var _0x3e7b43=function(_0x58e0f8,_0x43d804){var _0x5d0afa=squel['insert']()[_0xc68f('0x30')](_0xc68f('0x31'))['fromQuery'](['phone',_0xc68f('0x34'),_0xc68f('0x35'),_0xc68f('0x22'),_0x43d804,_0xc68f('0x3a'),_0xc68f('0x3b')],squel[_0xc68f('0x36')]()[_0xc68f('0x37')](_0xc68f('0x33'),_0xc68f('0x33'))[_0xc68f('0x37')](_0xc68f('0x38'),'scheduledAt')[_0xc68f('0x37')]('id','ContactId')[_0xc68f('0x37')](LISTID[_0xc68f('0x39')](),'ListId')[_0xc68f('0x37')](_0x58e0f8['id'][_0xc68f('0x39')](),_0x43d804)[_0xc68f('0x37')](_0xc68f('0x38'),_0xc68f('0x3a'))[_0xc68f('0x37')](_0xc68f('0x38'),_0xc68f('0x3b'))['from'](_0xc68f('0x3d'))[_0xc68f('0x3e')](_0xc68f('0x43'))['where']('ListId\x20=\x20?',LISTID['toString']())[_0xc68f('0x3e')](_0xc68f('0x44'),squel['str'](hopperContacts))[_0xc68f('0x3e')]('phone\x20IS\x20NOT\x20NULL')[_0xc68f('0x3e')](_0xc68f('0x41'),squel[_0xc68f('0x36')]()[_0xc68f('0x37')](_0xc68f('0x45'))[_0xc68f('0x3c')](_0xc68f('0x46'))[_0xc68f('0x3e')](_0x43d804+_0xc68f('0x42'),_0x58e0f8['id'][_0xc68f('0x39')]()))[_0xc68f('0x3e')]('phone\x20NOT\x20IN\x20(?)',squel[_0xc68f('0x36')]()[_0xc68f('0x37')]('phone')['from'](_0xc68f('0x31'))[_0xc68f('0x3e')](_0x43d804+_0xc68f('0x42'),_0x58e0f8['id']['toString']())))[_0xc68f('0x39')]();return _0x5d0afa;};function _0x929873(_0x55f099,_0x497615){var _0x2eb1e8=squel[_0xc68f('0x2f')]()[_0xc68f('0x30')](_0xc68f('0x31'))[_0xc68f('0x32')]([_0xc68f('0x33'),_0xc68f('0x34'),_0xc68f('0x35'),_0xc68f('0x22'),_0x497615,_0xc68f('0x3a'),_0xc68f('0x3b')],squel[_0xc68f('0x36')]()[_0xc68f('0x37')](_0xc68f('0x33'),_0xc68f('0x33'))[_0xc68f('0x37')](_0xc68f('0x38'),_0xc68f('0x34'))[_0xc68f('0x37')]('id',_0xc68f('0x35'))[_0xc68f('0x37')](LISTID['toString'](),'ListId')[_0xc68f('0x37')](_0x55f099['id'][_0xc68f('0x39')](),_0x497615)[_0xc68f('0x37')](_0xc68f('0x38'),_0xc68f('0x3a'))[_0xc68f('0x37')]('NOW()',_0xc68f('0x3b'))[_0xc68f('0x3c')](_0xc68f('0x3d'))['where'](_0xc68f('0x43'))['where'](_0xc68f('0x3f'),LISTID[_0xc68f('0x39')]())[_0xc68f('0x3e')](_0xc68f('0x44'),squel[_0xc68f('0x47')](hopperContacts))['where'](_0xc68f('0x40')))['toString']();return _0x2eb1e8;}function _0x432ff0(_0x213756,_0x3b2eef){var _0x24b269=squel['insert']()['into'](_0xc68f('0x48'))[_0xc68f('0x32')](['phone',_0xc68f('0x35'),'ListId',_0x3b2eef,_0xc68f('0x3a'),_0xc68f('0x3b')],squel[_0xc68f('0x36')]()[_0xc68f('0x37')](_0xc68f('0x33'),'phone')['field']('id',_0xc68f('0x35'))[_0xc68f('0x37')](LISTID[_0xc68f('0x39')](),_0xc68f('0x22'))['field'](_0x213756['id'][_0xc68f('0x39')](),_0x3b2eef)[_0xc68f('0x37')](_0xc68f('0x38'),_0xc68f('0x3a'))[_0xc68f('0x37')](_0xc68f('0x38'),'updatedAt')[_0xc68f('0x3c')](_0xc68f('0x3d'))['where'](_0xc68f('0x43'))[_0xc68f('0x3e')]('ListId\x20=\x20?',LISTID[_0xc68f('0x39')]())['where'](_0xc68f('0x44'),squel[_0xc68f('0x47')](hopperContacts))[_0xc68f('0x3e')](_0xc68f('0x40')))['toString']();return _0x24b269;}return db[_0xc68f('0x49')]['findAll']({'where':{'type':'outbound'},'attributes':['id',_0xc68f('0x4a')],'include':[{'model':db[_0xc68f('0x4b')],'as':_0xc68f('0x4c'),'where':{'id':LISTID}}]})[_0xc68f('0x28')](function(_0x55562c){var _0x5895e4=[];if(_0x55562c){var _0x4edf26;for(var _0x485db5=0x0,_0xabbfa9;_0x485db5<_0x55562c[_0xc68f('0x15')];_0x485db5+=0x1){_0xabbfa9=_0x55562c[_0x485db5][_0xc68f('0x4d')]({'plain':!![]});switch(_0xabbfa9[_0xc68f('0x4a')]){case _0xc68f('0x4e'):_0x5895e4[_0xc68f('0x29')](db[_0xc68f('0x4f')][_0xc68f('0x50')](_0x3e7b43(_0xabbfa9,_0xc68f('0x51')))['then'](function(){})['catch'](_0x3ce5b5()));break;case'onlyIfOpen':_0x5895e4[_0xc68f('0x29')](db[_0xc68f('0x4f')][_0xc68f('0x50')](_0x4282b7(_0xabbfa9,'VoiceQueueId'))['then'](function(){})[_0xc68f('0x52')](_0x3ce5b5()));break;default:_0x5895e4['push'](db[_0xc68f('0x4f')]['query'](_0x929873(_0xabbfa9,'VoiceQueueId'))[_0xc68f('0x28')](function(){})[_0xc68f('0x52')](_0x3ce5b5()));}}}return _0x5895e4;})[_0xc68f('0x53')]()[_0xc68f('0x28')](function(){return db[_0xc68f('0x49')][_0xc68f('0x54')]({'where':{'type':_0xc68f('0x55')},'attributes':['id'],'include':[{'model':db['CmList'],'as':_0xc68f('0x56'),'where':{'id':LISTID}}]})[_0xc68f('0x28')](function(_0x458cd3){var _0x1243bc=[];if(_0x458cd3){var _0x7809d9;for(var _0x53d3c6=0x0,_0x237d8d;_0x53d3c6<_0x458cd3[_0xc68f('0x15')];_0x53d3c6+=0x1){_0x237d8d=_0x458cd3[_0x53d3c6][_0xc68f('0x4d')]({'plain':!![]});_0x1243bc[_0xc68f('0x29')](db[_0xc68f('0x4f')]['query'](_0x432ff0(_0x237d8d,_0xc68f('0x51')))[_0xc68f('0x28')](function(){})[_0xc68f('0x52')](_0x3ce5b5()));}}return _0x1243bc;})['all']();})['then'](function(){return db['Campaign'][_0xc68f('0x54')]({'attributes':['id',_0xc68f('0x4a')],'include':[{'model':db[_0xc68f('0x4b')],'as':_0xc68f('0x4c'),'where':{'id':LISTID}}]})['then'](function(_0x57016e){var _0xc069e=[];if(_0x57016e){for(var _0x2e7b6a=0x0,_0x30d1ba;_0x2e7b6a<_0x57016e[_0xc68f('0x15')];_0x2e7b6a+=0x1){_0x30d1ba=_0x57016e[_0x2e7b6a][_0xc68f('0x4d')]({'plain':!![]});switch(_0x30d1ba[_0xc68f('0x4a')]){case'always':_0xc069e[_0xc68f('0x29')](db[_0xc68f('0x4f')][_0xc68f('0x50')](_0x3e7b43(_0x30d1ba,_0xc68f('0x57')))[_0xc68f('0x28')](function(){})['catch'](_0x3ce5b5()));break;case _0xc68f('0x58'):_0xc069e[_0xc68f('0x29')](db[_0xc68f('0x4f')][_0xc68f('0x50')](_0x4282b7(_0x30d1ba,_0xc68f('0x57')))[_0xc68f('0x28')](function(){})[_0xc68f('0x52')](_0x3ce5b5()));break;default:_0xc069e['push'](db['sequelize'][_0xc68f('0x50')](_0x929873(_0x30d1ba,_0xc68f('0x57')))[_0xc68f('0x28')](function(){})[_0xc68f('0x52')](_0x3ce5b5()));}}}return _0xc069e;})[_0xc68f('0x53')]();})[_0xc68f('0x28')](function(){return db[_0xc68f('0x59')][_0xc68f('0x54')]({'attributes':['id'],'include':[{'model':db[_0xc68f('0x4b')],'as':_0xc68f('0x56'),'where':{'id':LISTID}}]})[_0xc68f('0x28')](function(_0x5622eb){var _0xc01692=[];if(_0x5622eb){for(var _0x4e7b8f=0x0,_0x2a14ff;_0x4e7b8f<_0x5622eb[_0xc68f('0x15')];_0x4e7b8f+=0x1){_0x2a14ff=_0x5622eb[_0x4e7b8f][_0xc68f('0x4d')]({'plain':!![]});_0xc01692['push'](db[_0xc68f('0x4f')][_0xc68f('0x50')](_0x432ff0(_0x2a14ff,_0xc68f('0x57')))[_0xc68f('0x28')](function(){})[_0xc68f('0x52')](_0x3ce5b5()));}}return _0xc01692;})[_0xc68f('0x53')]();})[_0xc68f('0x52')](function(_0x4d8243){logger[_0xc68f('0x10')](_0xc68f('0x5a'),_0xc68f('0x5b'),_0x4d8243[_0xc68f('0x2b')]);});}var processPromises=function(_0x237e81){return BPromise['all'](promises)[_0xc68f('0x28')](function(_0x3103a1){})['catch'](function(_0x50118e){logger['error'](_0xc68f('0x5c'),JSON[_0xc68f('0x2c')](_0x50118e));})[_0xc68f('0x5d')](function(){socket[_0xc68f('0x5e')](_0xc68f('0x5f')+SOCKET_TIMESTAMP,{'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});promises=[];success=0x0;errors=0x0;duplicates=0x0;rows=[];if(_0x237e81){return _0x237e81[_0xc68f('0x60')]();}});};var endCsv=function(){return BPromise[_0xc68f('0x61')]()['then'](function(){if(hopperContacts){return checkHopper();}})[_0xc68f('0x28')](function(){socket['emit'](_0xc68f('0x5f')+SOCKET_TIMESTAMP,{'finished':!![],'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});try{fs[_0xc68f('0x62')](FILEPATH);}catch(_0x3c66e6){logger[_0xc68f('0x10')]('Unable\x20to\x20delete\x20temp\x20file:',JSON['stringify'](_0x3c66e6));}finally{process[_0xc68f('0x63')](0x0);}});};process['on'](_0xc68f('0x64'),function(){logger[_0xc68f('0x65')](_0xc68f('0x66'));endCsv();});function main(){return BPromise['resolve']()[_0xc68f('0x28')](function(){if(DUPLICATES){DUPLICATES=DUPLICATES[_0xc68f('0xd')](',');return db[_0xc68f('0x27')][_0xc68f('0x54')]({'where':{'ListId':LISTID},'attributes':DUPLICATES,'raw':!![]});}})[_0xc68f('0x28')](function(_0x379e80){var _0x5720f7=fs[_0xc68f('0x67')](FILEPATH,{'highWaterMark':0xf*0x400*0x400});Papa[_0xc68f('0x68')](_0x5720f7,{'header':!![],'skipEmptyLines':!![],'step':function(_0xdc0981,_0x4feebd){total+=0x1;var _0x4a55d2=total;promises[_0xc68f('0x29')](checkRow(_0xdc0981,_0x379e80,_0x4a55d2)[_0xc68f('0x28')](function(){success+=0x1;})[_0xc68f('0x52')](function(_0x1b8bd5){if(_0x1b8bd5[_0xc68f('0x10')]){errors+=0x1;delete _0x1b8bd5[_0xc68f('0x10')];}else if(_0x1b8bd5[_0xc68f('0x25')]){duplicates+=0x1;delete _0x1b8bd5[_0xc68f('0x25')];}rows[_0xc68f('0x29')](_0x1b8bd5);}));if(total%0xc8===0x0){_0x4feebd[_0xc68f('0x69')]();return processPromises(_0x4feebd);}},'complete':function(){return processPromises()[_0xc68f('0x28')](function(){logger['info'](_0xc68f('0x6a'));endCsv();});},'error':function(_0x1f58f8,_0x5d5052){logger['info'](_0xc68f('0x6b'),JSON[_0xc68f('0x2c')](_0x1f58f8));endCsv();}});})[_0xc68f('0x52')](function(_0x5bc2e6){logger[_0xc68f('0x10')]('Error\x20executing\x20contact\x20csv\x20import:',JSON[_0xc68f('0x2c')](_0x5bc2e6));});}main();
\ No newline at end of file
+var _0x4ea3=['resolve','unlinkSync','Unable\x20to\x20delete\x20temp\x20file:','exit','SIGINT','info','createReadStream','duplicate','CSV\x20parsed\x20correctly!','CSV\x20parse\x20error','Error\x20executing\x20contact\x20csv\x20import:','bluebird','../../../mysqldb','../../../config/logger','api','lodash','papaparse','../../../api/cmContact/cmContact.socket','register','argv','undefined','null','zipObject','split','Missing\x20ListId\x20parameter!','Missing\x20socket_timestamp\x20parameter!','error','contact','index','isNil','errors','length','join','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','CmContact','keys','then','push','pick','catch','message','stringify','checkHopper','inspect','insert','into','cm_hopper','phone','scheduledAt','ContactId','ListId','select','field','toString','NOW()','createdAt','updatedAt','from','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','where','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','\x20=\x20?','fromQuery','id\x20IN\x20?','str','calleridnum','cm_hopper_final','findAll','outbound','dialCheckDuplicateType','Lists','get','always','sequelize','query','VoiceQueueId','onlyIfOpen','all','VoiceQueue','BlackLists','CampaignId','Campaign','CmList','cmContact,\x20%s,\x20%s','generalCheckHopper','Error\x20processing\x20rows\x20block:','finally','contact:csv_','resume'];(function(_0x4f1789,_0x37fda7){var _0x5bb8fe=function(_0x4d1d04){while(--_0x4d1d04){_0x4f1789['push'](_0x4f1789['shift']());}};_0x5bb8fe(++_0x37fda7);}(_0x4ea3,0x70));var _0x34ea=function(_0x2dafbe,_0x5d04de){_0x2dafbe=_0x2dafbe-0x0;var _0x58a45a=_0x4ea3[_0x2dafbe];return _0x58a45a;};'use strict';var BPromise=require(_0x34ea('0x0'));var db=require(_0x34ea('0x1'))['db'];var logger=require(_0x34ea('0x2'))(_0x34ea('0x3'));var util=require('util');var _=require(_0x34ea('0x4'));var fs=require('fs');var squel=require('squel');var Papa=require(_0x34ea('0x5'));var socket=require('socket.io-emitter')({'host':'localhost','port':0x18eb});require(_0x34ea('0x6'))[_0x34ea('0x7')](socket);try{if(!process[_0x34ea('0x8')][0x2]||process[_0x34ea('0x8')][0x2]===_0x34ea('0x9')||process[_0x34ea('0x8')][0x2]===_0x34ea('0xa')){throw new Error('Missing\x20filepath\x20parameter!');}var FILEPATH=process[_0x34ea('0x8')][0x2];if(!process[_0x34ea('0x8')][0x3]||process[_0x34ea('0x8')][0x3]==='undefined'||process[_0x34ea('0x8')][0x3]===_0x34ea('0xa')||!process['argv'][0x4]||process['argv'][0x4]===_0x34ea('0x9')||process[_0x34ea('0x8')][0x4]===_0x34ea('0xa')){throw new Error('Missing\x20binding\x20parameters!');}var FIELDS=_[_0x34ea('0xb')](process[_0x34ea('0x8')][0x3][_0x34ea('0xc')](','),process[_0x34ea('0x8')][0x4][_0x34ea('0xc')](','));if(!process[_0x34ea('0x8')][0x5]||process[_0x34ea('0x8')][0x5]===_0x34ea('0x9')||process[_0x34ea('0x8')][0x5]===_0x34ea('0xa')){throw new Error(_0x34ea('0xd'));}var LISTID=process['argv'][0x5];var COMPANYID=process[_0x34ea('0x8')][0x6]&&process[_0x34ea('0x8')][0x6]!==_0x34ea('0x9')&&process[_0x34ea('0x8')][0x6]!==_0x34ea('0xa')?process['argv'][0x6]:null;var DUPLICATES=process[_0x34ea('0x8')][0x7]&&process[_0x34ea('0x8')][0x7]!==_0x34ea('0x9')&&process[_0x34ea('0x8')][0x7]!=='null'?process[_0x34ea('0x8')][0x7]:null;if(!process[_0x34ea('0x8')][0x8]||process[_0x34ea('0x8')][0x8]==='undefined'||process[_0x34ea('0x8')][0x8]===_0x34ea('0xa')){throw new Error(_0x34ea('0xe'));}var SOCKET_TIMESTAMP=process[_0x34ea('0x8')][0x8];}catch(_0x52af16){logger[_0x34ea('0xf')](_0x52af16);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(_0x35328c,_0x287aaa,_0x247ee7,_0x4fc1a2){var _0x55277a={'message':_0x287aaa};_0x55277a[_0x35328c]=!![];if(_0x247ee7){_0x55277a[_0x34ea('0x10')]=_0x247ee7;}if(_0x4fc1a2){_0x55277a[_0x34ea('0x11')]=_0x4fc1a2;}return _0x55277a;}function isEmail(_0x151fae){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'](_0x151fae);}function checkRow(_0x5197a2,_0x2eafc6,_0x3ff80e){return new BPromise(function(_0x2a0ec2,_0x30c4b0){if(_[_0x34ea('0x12')](_0x5197a2)){return _0x30c4b0(handleCheckRowError(_0x34ea('0xf'),'The\x20row\x20is\x20empty\x20or\x20the\x20number\x20of\x20parameters\x20does\x20not\x20match\x20the\x20columns!',null,_0x3ff80e));}if(_0x5197a2[_0x34ea('0x13')]&&_0x5197a2[_0x34ea('0x13')][_0x34ea('0x14')]){var _0x332f75=_['map'](_0x5197a2['errors'],'message')[_0x34ea('0x15')](';');return _0x30c4b0(handleCheckRowError(_0x34ea('0xf'),_0x332f75,null,_0x3ff80e));}var _0x37c214={};for(var _0x4204d7 in FIELDS){if(FIELDS['hasOwnProperty'](_0x4204d7)&&FIELDS[_0x4204d7]){_0x37c214[_0x4204d7]=_0x5197a2[_0x34ea('0x16')][0x0][FIELDS[_0x4204d7]]||_0x5197a2[_0x34ea('0x16')][0x0]['\ufeff'+FIELDS[_0x4204d7]];}}if(!_0x37c214[_0x34ea('0x17')]){return _0x30c4b0(handleCheckRowError('error','firstName\x20not\x20specified!',null,_0x3ff80e));}if(!_0x37c214['phone']){return _0x30c4b0(handleCheckRowError('error',_0x34ea('0x18'),null,_0x3ff80e));}if(_0x37c214[_0x34ea('0x19')]){var _0x859b7e=moment(_0x37c214[_0x34ea('0x19')],'YYYY-MM-DD');if(!_0x859b7e[_0x34ea('0x1a')]()){return _0x30c4b0(handleCheckRowError('error',_0x34ea('0x1b'),null,_0x3ff80e));}}if(_0x37c214['email']){if(!isEmail(_0x37c214[_0x34ea('0x1c')])){return _0x30c4b0(handleCheckRowError(_0x34ea('0xf'),_0x34ea('0x1d'),null,_0x3ff80e));}}_0x37c214['ListId']=LISTID;_0x37c214[_0x34ea('0x1e')]=COMPANYID||undefined;if(DUPLICATES&&DUPLICATES[_0x34ea('0x14')]&&_0x2eafc6){var _0x55c8ba={};for(var _0x10bcfe=0x0,_0x5717e6=DUPLICATES[_0x34ea('0x14')];_0x10bcfe<_0x5717e6;_0x10bcfe+=0x1){_0x55c8ba[DUPLICATES[_0x10bcfe]]=_0x37c214[DUPLICATES[_0x10bcfe]];}var _0x2806b3=_[_0x34ea('0x1f')](_0x2eafc6,_0x55c8ba);if(_0x2806b3){return _0x30c4b0(handleCheckRowError('duplicate','Duplicate\x20Contact',_0x2806b3,_0x3ff80e));}}return db[_0x34ea('0x20')]['create'](_0x37c214,{'raw':!![],'hooks':![],'fields':_[_0x34ea('0x21')](_0x37c214)})[_0x34ea('0x22')](function(_0x58d31c){if(DUPLICATES&&DUPLICATES[_0x34ea('0x14')]&&_0x2eafc6){_0x2eafc6[_0x34ea('0x23')](_[_0x34ea('0x24')](_0x37c214,DUPLICATES));}hopperContacts+=(hopperContacts?',':'')+_0x58d31c['id'];return _0x2a0ec2();})[_0x34ea('0x25')](function(_0x4d43ca){return _0x30c4b0(handleCheckRowError('error','Error\x20while\x20creating\x20contact:\x20'+(_0x4d43ca[_0x34ea('0x26')]||JSON[_0x34ea('0x27')](_0x4d43ca)),null,_0x3ff80e));});});}function checkHopper(){function _0x24e8cc(){return function(_0x584e54){logger['error']('cmContact',_0x34ea('0x28'),util[_0x34ea('0x29')](_0x584e54,{'showHidden':![],'depth':null}));};}var _0x583e2d=function(_0x4e6310,_0x240c77){var _0x2db107=squel[_0x34ea('0x2a')]()[_0x34ea('0x2b')](_0x34ea('0x2c'))['fromQuery']([_0x34ea('0x2d'),_0x34ea('0x2e'),_0x34ea('0x2f'),_0x34ea('0x30'),_0x240c77,'createdAt','updatedAt'],squel[_0x34ea('0x31')]()[_0x34ea('0x32')](_0x34ea('0x2d'),_0x34ea('0x2d'))[_0x34ea('0x32')]('NOW()',_0x34ea('0x2e'))[_0x34ea('0x32')]('id',_0x34ea('0x2f'))[_0x34ea('0x32')](LISTID[_0x34ea('0x33')](),_0x34ea('0x30'))[_0x34ea('0x32')](_0x4e6310['id'][_0x34ea('0x33')](),_0x240c77)[_0x34ea('0x32')](_0x34ea('0x34'),_0x34ea('0x35'))[_0x34ea('0x32')](_0x34ea('0x34'),_0x34ea('0x36'))[_0x34ea('0x37')](_0x34ea('0x38'))['where'](_0x34ea('0x39'))['where'](_0x34ea('0x3a'),LISTID[_0x34ea('0x33')]())[_0x34ea('0x3b')](_0x34ea('0x3c'))[_0x34ea('0x3b')](_0x34ea('0x3d'),squel[_0x34ea('0x31')]()[_0x34ea('0x32')](_0x34ea('0x2d'))['from'](_0x34ea('0x2c'))['where'](_0x240c77+_0x34ea('0x3e'),_0x4e6310['id'][_0x34ea('0x33')]())))[_0x34ea('0x33')]();return _0x2db107;};var _0x379282=function(_0x19ded9,_0x168e28){var _0x5621df=squel[_0x34ea('0x2a')]()[_0x34ea('0x2b')]('cm_hopper')[_0x34ea('0x3f')]([_0x34ea('0x2d'),_0x34ea('0x2e'),_0x34ea('0x2f'),_0x34ea('0x30'),_0x168e28,'createdAt',_0x34ea('0x36')],squel[_0x34ea('0x31')]()[_0x34ea('0x32')](_0x34ea('0x2d'),_0x34ea('0x2d'))[_0x34ea('0x32')]('NOW()','scheduledAt')[_0x34ea('0x32')]('id',_0x34ea('0x2f'))[_0x34ea('0x32')](LISTID['toString'](),_0x34ea('0x30'))['field'](_0x19ded9['id'][_0x34ea('0x33')](),_0x168e28)['field'](_0x34ea('0x34'),_0x34ea('0x35'))[_0x34ea('0x32')]('NOW()',_0x34ea('0x36'))['from'](_0x34ea('0x38'))[_0x34ea('0x3b')](_0x34ea('0x39'))[_0x34ea('0x3b')]('ListId\x20=\x20?',LISTID[_0x34ea('0x33')]())[_0x34ea('0x3b')](_0x34ea('0x40'),squel[_0x34ea('0x41')](hopperContacts))[_0x34ea('0x3b')](_0x34ea('0x3c'))[_0x34ea('0x3b')]('phone\x20NOT\x20IN\x20(?)',squel[_0x34ea('0x31')]()[_0x34ea('0x32')](_0x34ea('0x42'))[_0x34ea('0x37')](_0x34ea('0x43'))[_0x34ea('0x3b')](_0x168e28+_0x34ea('0x3e'),_0x19ded9['id'][_0x34ea('0x33')]()))[_0x34ea('0x3b')](_0x34ea('0x3d'),squel[_0x34ea('0x31')]()[_0x34ea('0x32')](_0x34ea('0x2d'))['from'](_0x34ea('0x2c'))[_0x34ea('0x3b')](_0x168e28+_0x34ea('0x3e'),_0x19ded9['id']['toString']())))[_0x34ea('0x33')]();return _0x5621df;};function _0x4f00f0(_0x16497b,_0x1b0629){var _0x47aab6=squel[_0x34ea('0x2a')]()[_0x34ea('0x2b')](_0x34ea('0x2c'))['fromQuery'](['phone',_0x34ea('0x2e'),'ContactId','ListId',_0x1b0629,_0x34ea('0x35'),'updatedAt'],squel[_0x34ea('0x31')]()[_0x34ea('0x32')](_0x34ea('0x2d'),_0x34ea('0x2d'))[_0x34ea('0x32')](_0x34ea('0x34'),_0x34ea('0x2e'))[_0x34ea('0x32')]('id',_0x34ea('0x2f'))[_0x34ea('0x32')](LISTID[_0x34ea('0x33')](),_0x34ea('0x30'))[_0x34ea('0x32')](_0x16497b['id'][_0x34ea('0x33')](),_0x1b0629)[_0x34ea('0x32')](_0x34ea('0x34'),'createdAt')[_0x34ea('0x32')]('NOW()',_0x34ea('0x36'))[_0x34ea('0x37')](_0x34ea('0x38'))[_0x34ea('0x3b')](_0x34ea('0x39'))[_0x34ea('0x3b')]('ListId\x20=\x20?',LISTID[_0x34ea('0x33')]())[_0x34ea('0x3b')](_0x34ea('0x40'),squel[_0x34ea('0x41')](hopperContacts))[_0x34ea('0x3b')]('phone\x20IS\x20NOT\x20NULL'))[_0x34ea('0x33')]();return _0x47aab6;}function _0x5814ef(_0x58b428,_0x54dc5e){var _0x3247f0=squel['insert']()[_0x34ea('0x2b')]('cm_hopper_black')[_0x34ea('0x3f')](['phone',_0x34ea('0x2f'),'ListId',_0x54dc5e,_0x34ea('0x35'),_0x34ea('0x36')],squel[_0x34ea('0x31')]()[_0x34ea('0x32')](_0x34ea('0x2d'),'phone')['field']('id',_0x34ea('0x2f'))[_0x34ea('0x32')](LISTID[_0x34ea('0x33')](),_0x34ea('0x30'))[_0x34ea('0x32')](_0x58b428['id'][_0x34ea('0x33')](),_0x54dc5e)[_0x34ea('0x32')](_0x34ea('0x34'),_0x34ea('0x35'))['field'](_0x34ea('0x34'),_0x34ea('0x36'))[_0x34ea('0x37')]('cm_contacts')['where'](_0x34ea('0x39'))[_0x34ea('0x3b')](_0x34ea('0x3a'),LISTID['toString']())[_0x34ea('0x3b')](_0x34ea('0x40'),squel[_0x34ea('0x41')](hopperContacts))['where'](_0x34ea('0x3c')))[_0x34ea('0x33')]();return _0x3247f0;}return db['VoiceQueue'][_0x34ea('0x44')]({'where':{'type':_0x34ea('0x45')},'attributes':['id',_0x34ea('0x46')],'include':[{'model':db['CmList'],'as':_0x34ea('0x47'),'where':{'id':LISTID}}]})['then'](function(_0x2ec42b){var _0x42c838=[];if(_0x2ec42b){var _0x1a08d5;for(var _0x34966f=0x0,_0x5f5037;_0x34966f<_0x2ec42b[_0x34ea('0x14')];_0x34966f+=0x1){_0x5f5037=_0x2ec42b[_0x34966f][_0x34ea('0x48')]({'plain':!![]});switch(_0x5f5037['dialCheckDuplicateType']){case _0x34ea('0x49'):_0x42c838['push'](db[_0x34ea('0x4a')][_0x34ea('0x4b')](_0x379282(_0x5f5037,_0x34ea('0x4c')))['then'](function(){})[_0x34ea('0x25')](_0x24e8cc()));break;case _0x34ea('0x4d'):_0x42c838[_0x34ea('0x23')](db[_0x34ea('0x4a')]['query'](_0x583e2d(_0x5f5037,_0x34ea('0x4c')))[_0x34ea('0x22')](function(){})[_0x34ea('0x25')](_0x24e8cc()));break;default:_0x42c838[_0x34ea('0x23')](db['sequelize']['query'](_0x4f00f0(_0x5f5037,_0x34ea('0x4c')))[_0x34ea('0x22')](function(){})['catch'](_0x24e8cc()));}}}return _0x42c838;})[_0x34ea('0x4e')]()[_0x34ea('0x22')](function(){return db[_0x34ea('0x4f')]['findAll']({'where':{'type':'outbound'},'attributes':['id'],'include':[{'model':db['CmList'],'as':_0x34ea('0x50'),'where':{'id':LISTID}}]})['then'](function(_0x2429a4){var _0x55c787=[];if(_0x2429a4){var _0x5850f0;for(var _0x58accc=0x0,_0xdd4f39;_0x58accc<_0x2429a4[_0x34ea('0x14')];_0x58accc+=0x1){_0xdd4f39=_0x2429a4[_0x58accc][_0x34ea('0x48')]({'plain':!![]});_0x55c787[_0x34ea('0x23')](db[_0x34ea('0x4a')][_0x34ea('0x4b')](_0x5814ef(_0xdd4f39,_0x34ea('0x4c')))[_0x34ea('0x22')](function(){})[_0x34ea('0x25')](_0x24e8cc()));}}return _0x55c787;})['all']();})[_0x34ea('0x22')](function(){return db['Campaign']['findAll']({'attributes':['id',_0x34ea('0x46')],'include':[{'model':db['CmList'],'as':_0x34ea('0x47'),'where':{'id':LISTID}}]})[_0x34ea('0x22')](function(_0x3bdb7b){var _0x517dcb=[];if(_0x3bdb7b){for(var _0xddd2ac=0x0,_0x4fbac1;_0xddd2ac<_0x3bdb7b[_0x34ea('0x14')];_0xddd2ac+=0x1){_0x4fbac1=_0x3bdb7b[_0xddd2ac][_0x34ea('0x48')]({'plain':!![]});switch(_0x4fbac1[_0x34ea('0x46')]){case _0x34ea('0x49'):_0x517dcb[_0x34ea('0x23')](db[_0x34ea('0x4a')][_0x34ea('0x4b')](_0x379282(_0x4fbac1,_0x34ea('0x51')))['then'](function(){})[_0x34ea('0x25')](_0x24e8cc()));break;case _0x34ea('0x4d'):_0x517dcb[_0x34ea('0x23')](db[_0x34ea('0x4a')][_0x34ea('0x4b')](_0x583e2d(_0x4fbac1,'CampaignId'))[_0x34ea('0x22')](function(){})['catch'](_0x24e8cc()));break;default:_0x517dcb[_0x34ea('0x23')](db['sequelize']['query'](_0x4f00f0(_0x4fbac1,'CampaignId'))[_0x34ea('0x22')](function(){})[_0x34ea('0x25')](_0x24e8cc()));}}}return _0x517dcb;})[_0x34ea('0x4e')]();})['then'](function(){return db[_0x34ea('0x52')]['findAll']({'attributes':['id'],'include':[{'model':db[_0x34ea('0x53')],'as':'BlackLists','where':{'id':LISTID}}]})['then'](function(_0x412dbc){var _0x147e5f=[];if(_0x412dbc){for(var _0x2eebcf=0x0,_0x3194cf;_0x2eebcf<_0x412dbc[_0x34ea('0x14')];_0x2eebcf+=0x1){_0x3194cf=_0x412dbc[_0x2eebcf]['get']({'plain':!![]});_0x147e5f[_0x34ea('0x23')](db['sequelize']['query'](_0x5814ef(_0x3194cf,_0x34ea('0x51')))[_0x34ea('0x22')](function(){})[_0x34ea('0x25')](_0x24e8cc()));}}return _0x147e5f;})[_0x34ea('0x4e')]();})['catch'](function(_0x2e9c89){logger[_0x34ea('0xf')](_0x34ea('0x54'),_0x34ea('0x55'),_0x2e9c89[_0x34ea('0x26')]);});}var processPromises=function(_0xce309a){return BPromise[_0x34ea('0x4e')](promises)[_0x34ea('0x22')](function(_0x228cdc){})[_0x34ea('0x25')](function(_0x18fbf9){logger[_0x34ea('0xf')](_0x34ea('0x56'),JSON[_0x34ea('0x27')](_0x18fbf9));})[_0x34ea('0x57')](function(){socket['emit'](_0x34ea('0x58')+SOCKET_TIMESTAMP,{'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});promises=[];success=0x0;errors=0x0;duplicates=0x0;rows=[];if(_0xce309a){return _0xce309a[_0x34ea('0x59')]();}});};var endCsv=function(){return BPromise[_0x34ea('0x5a')]()['then'](function(){if(hopperContacts){return checkHopper();}})[_0x34ea('0x22')](function(){socket['emit'](_0x34ea('0x58')+SOCKET_TIMESTAMP,{'finished':!![],'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});try{fs[_0x34ea('0x5b')](FILEPATH);}catch(_0x1ac18b){logger[_0x34ea('0xf')](_0x34ea('0x5c'),JSON[_0x34ea('0x27')](_0x1ac18b));}finally{process[_0x34ea('0x5d')](0x0);}});};process['on'](_0x34ea('0x5e'),function(){logger[_0x34ea('0x5f')]('CSV\x20import\x20process\x20stopped!');endCsv();});function main(){return BPromise[_0x34ea('0x5a')]()['then'](function(){if(DUPLICATES){DUPLICATES=DUPLICATES[_0x34ea('0xc')](',');return db[_0x34ea('0x20')][_0x34ea('0x44')]({'where':{'ListId':LISTID},'attributes':DUPLICATES,'raw':!![]});}})[_0x34ea('0x22')](function(_0x439df8){var _0x57a067=fs[_0x34ea('0x60')](FILEPATH,{'highWaterMark':0xf*0x400*0x400});Papa['parse'](_0x57a067,{'header':!![],'skipEmptyLines':!![],'step':function(_0x4b571b,_0x58d4d2){total+=0x1;var _0x4b22d9=total;promises[_0x34ea('0x23')](checkRow(_0x4b571b,_0x439df8,_0x4b22d9)[_0x34ea('0x22')](function(){success+=0x1;})[_0x34ea('0x25')](function(_0x4d5eb8){if(_0x4d5eb8[_0x34ea('0xf')]){errors+=0x1;delete _0x4d5eb8[_0x34ea('0xf')];}else if(_0x4d5eb8[_0x34ea('0x61')]){duplicates+=0x1;delete _0x4d5eb8[_0x34ea('0x61')];}rows[_0x34ea('0x23')](_0x4d5eb8);}));if(total%0xc8===0x0){_0x58d4d2['pause']();return processPromises(_0x58d4d2);}},'complete':function(){return processPromises()[_0x34ea('0x22')](function(){logger['info'](_0x34ea('0x62'));endCsv();});},'error':function(_0xb3738a,_0x1e3648){logger[_0x34ea('0x5f')](_0x34ea('0x63'),JSON[_0x34ea('0x27')](_0xb3738a));endCsv();}});})['catch'](function(_0x425226){logger[_0x34ea('0xf')](_0x34ea('0x64'),JSON[_0x34ea('0x27')](_0x425226));});}main();
\ No newline at end of file