18 var _0x23d8=['resolve','unlinkSync','exit','CSV\x20import\x20process\x20stopped!','createReadStream','parse','info','CSV\x20parsed\x20correctly!','squel','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','api','redis','../../../api/cmContact/cmContact.socket','register','argv','undefined','null','Missing\x20filepath\x20parameter!','Missing\x20binding\x20parameters!','zipObject','split','Missing\x20ListId\x20parameter!','Missing\x20socket_timestamp\x20parameter!','index','test','error','The\x20row\x20is\x20empty\x20or\x20the\x20number\x20of\x20parameters\x20does\x20not\x20match\x20the\x20columns!','errors','length','message','hasOwnProperty','data','firstName','firstName\x20not\x20specified!','phone','phone\x20not\x20specified!','YYYY-MM-DD','isValid','email','email\x20format\x20is\x20not\x20valid!','ListId','find','duplicate','Duplicate\x20Contact','CmContact','keys','then','push','catch','Error\x20while\x20creating\x20contact:\x20','stringify','cmContact','checkHopper','inspect','into','cm_hopper','fromQuery','scheduledAt','ContactId','createdAt','updatedAt','field','NOW()','toString','from','cm_contacts','where','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','select','\x20=\x20?','insert','id\x20IN\x20?','str','calleridnum','cm_hopper_final','cm_hopper_black','VoiceQueue','CmList','Lists','get','dialCheckDuplicateType','always','query','VoiceQueueId','onlyIfOpen','sequelize','all','Campaign','findAll','CampaignId','BlackLists','cmContact,\x20%s,\x20%s','generalCheckHopper','Error\x20processing\x20rows\x20block:','emit','resume'];(function(_0x3ab51d,_0x2fa01d){var _0x29a04e=function(_0x7807b0){while(--_0x7807b0){_0x3ab51d['push'](_0x3ab51d['shift']());}};_0x29a04e(++_0x2fa01d);}(_0x23d8,0x13a));var _0x823d=function(_0x14add3,_0x13ce8d){_0x14add3=_0x14add3-0x0;var _0x4a174f=_0x23d8[_0x14add3];return _0x4a174f;};'use strict';var BPromise=require('bluebird');var util=require('util');var _=require('lodash');var fs=require('fs');var squel=require(_0x823d('0x0'));var Papa=require('papaparse');var Redis=require(_0x823d('0x1'));var db=require(_0x823d('0x2'))['db'];var config=require(_0x823d('0x3'));var logger=require(_0x823d('0x4'))(_0x823d('0x5'));config[_0x823d('0x6')]=_['defaults'](config['redis'],{'host':'localhost','port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x823d('0x6')]));require(_0x823d('0x7'))[_0x823d('0x8')](socket);try{if(!process[_0x823d('0x9')][0x2]||process['argv'][0x2]===_0x823d('0xa')||process[_0x823d('0x9')][0x2]===_0x823d('0xb')){throw new Error(_0x823d('0xc'));}var FILEPATH=process['argv'][0x2];if(!process[_0x823d('0x9')][0x3]||process[_0x823d('0x9')][0x3]===_0x823d('0xa')||process[_0x823d('0x9')][0x3]==='null'||!process[_0x823d('0x9')][0x4]||process[_0x823d('0x9')][0x4]===_0x823d('0xa')||process[_0x823d('0x9')][0x4]==='null'){throw new Error(_0x823d('0xd'));}var FIELDS=_[_0x823d('0xe')](process[_0x823d('0x9')][0x3][_0x823d('0xf')](','),process[_0x823d('0x9')][0x4][_0x823d('0xf')](','));if(!process[_0x823d('0x9')][0x5]||process['argv'][0x5]==='undefined'||process[_0x823d('0x9')][0x5]===_0x823d('0xb')){throw new Error(_0x823d('0x10'));}var LISTID=process['argv'][0x5];var COMPANYID=process[_0x823d('0x9')][0x6]&&process[_0x823d('0x9')][0x6]!=='undefined'&&process[_0x823d('0x9')][0x6]!==_0x823d('0xb')?process['argv'][0x6]:null;var DUPLICATES=process[_0x823d('0x9')][0x7]&&process[_0x823d('0x9')][0x7]!==_0x823d('0xa')&&process[_0x823d('0x9')][0x7]!==_0x823d('0xb')?process[_0x823d('0x9')][0x7]:null;if(!process['argv'][0x8]||process[_0x823d('0x9')][0x8]===_0x823d('0xa')||process[_0x823d('0x9')][0x8]===_0x823d('0xb')){throw new Error(_0x823d('0x11'));}var SOCKET_TIMESTAMP=process[_0x823d('0x9')][0x8];}catch(_0x5b5024){logger['error'](_0x5b5024);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(_0x4d8833,_0x5cc445,_0x5a7362,_0x373c28){var _0x484736={'message':_0x5cc445};_0x484736[_0x4d8833]=!![];if(_0x5a7362){_0x484736['contact']=_0x5a7362;}if(_0x373c28){_0x484736[_0x823d('0x12')]=_0x373c28;}return _0x484736;}function isEmail(_0xfaabc8){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))*$/[_0x823d('0x13')](_0xfaabc8);}function checkRow(_0x11bc21,_0x15c253,_0x2db370){return new BPromise(function(_0x3b87f8,_0x4f1d6b){if(_['isNil'](_0x11bc21)){return _0x4f1d6b(handleCheckRowError(_0x823d('0x14'),_0x823d('0x15'),null,_0x2db370));}if(_0x11bc21['errors']&&_0x11bc21[_0x823d('0x16')][_0x823d('0x17')]){var _0x1c1ee4=_['map'](_0x11bc21[_0x823d('0x16')],_0x823d('0x18'))['join'](';');return _0x4f1d6b(handleCheckRowError(_0x823d('0x14'),_0x1c1ee4,null,_0x2db370));}var _0x412068={};for(var _0x140f45 in FIELDS){if(FIELDS[_0x823d('0x19')](_0x140f45)&&FIELDS[_0x140f45]){_0x412068[_0x140f45]=_0x11bc21[_0x823d('0x1a')][0x0][FIELDS[_0x140f45]]||_0x11bc21[_0x823d('0x1a')][0x0]['\ufeff'+FIELDS[_0x140f45]];}}if(!_0x412068[_0x823d('0x1b')]){return _0x4f1d6b(handleCheckRowError(_0x823d('0x14'),_0x823d('0x1c'),null,_0x2db370));}if(!_0x412068[_0x823d('0x1d')]){return _0x4f1d6b(handleCheckRowError('error',_0x823d('0x1e'),null,_0x2db370));}if(_0x412068['birthDate']){var _0x30aec2=moment(_0x412068['birthDate'],_0x823d('0x1f'));if(!_0x30aec2[_0x823d('0x20')]()){return _0x4f1d6b(handleCheckRowError(_0x823d('0x14'),'birthDate\x20format\x20is\x20invalid,\x20YYYY-MM-DD\x20format\x20is\x20supported!',null,_0x2db370));}}if(_0x412068[_0x823d('0x21')]){if(!isEmail(_0x412068[_0x823d('0x21')])){return _0x4f1d6b(handleCheckRowError('error',_0x823d('0x22'),null,_0x2db370));}}_0x412068[_0x823d('0x23')]=LISTID;_0x412068['CompanyId']=COMPANYID||undefined;if(DUPLICATES&&DUPLICATES[_0x823d('0x17')]&&_0x15c253){var _0x470146={};for(var _0xc1c923=0x0,_0x51044e=DUPLICATES[_0x823d('0x17')];_0xc1c923<_0x51044e;_0xc1c923+=0x1){_0x470146[DUPLICATES[_0xc1c923]]=_0x412068[DUPLICATES[_0xc1c923]];}var _0x4c6cad=_[_0x823d('0x24')](_0x15c253,_0x470146);if(_0x4c6cad){return _0x4f1d6b(handleCheckRowError(_0x823d('0x25'),_0x823d('0x26'),_0x4c6cad,_0x2db370));}}return db[_0x823d('0x27')]['create'](_0x412068,{'raw':!![],'hooks':![],'fields':_[_0x823d('0x28')](_0x412068)})[_0x823d('0x29')](function(_0x2da0a3){if(DUPLICATES&&DUPLICATES[_0x823d('0x17')]&&_0x15c253){_0x15c253[_0x823d('0x2a')](_['pick'](_0x412068,DUPLICATES));}hopperContacts+=(hopperContacts?',':'')+_0x2da0a3['id'];return _0x3b87f8();})[_0x823d('0x2b')](function(_0x9f9041){return _0x4f1d6b(handleCheckRowError(_0x823d('0x14'),_0x823d('0x2c')+(_0x9f9041[_0x823d('0x18')]||JSON[_0x823d('0x2d')](_0x9f9041)),null,_0x2db370));});});}function checkHopper(){function _0x363f29(){return function(_0x5f5ddc){logger['error'](_0x823d('0x2e'),_0x823d('0x2f'),util[_0x823d('0x30')](_0x5f5ddc,{'showHidden':![],'depth':null}));};}var _0x39c2ec=function(_0x574ee1,_0x11c04b){var _0x7a05e=squel['insert']()[_0x823d('0x31')](_0x823d('0x32'))[_0x823d('0x33')](['phone',_0x823d('0x34'),_0x823d('0x35'),'ListId',_0x11c04b,_0x823d('0x36'),_0x823d('0x37')],squel['select']()[_0x823d('0x38')](_0x823d('0x1d'),_0x823d('0x1d'))['field'](_0x823d('0x39'),_0x823d('0x34'))[_0x823d('0x38')]('id','ContactId')[_0x823d('0x38')](LISTID[_0x823d('0x3a')](),'ListId')['field'](_0x574ee1['id'][_0x823d('0x3a')](),_0x11c04b)[_0x823d('0x38')](_0x823d('0x39'),'createdAt')[_0x823d('0x38')](_0x823d('0x39'),_0x823d('0x37'))[_0x823d('0x3b')](_0x823d('0x3c'))[_0x823d('0x3d')](_0x823d('0x3e'))[_0x823d('0x3d')](_0x823d('0x3f'),LISTID[_0x823d('0x3a')]())['where'](_0x823d('0x40'))[_0x823d('0x3d')](_0x823d('0x41'),squel[_0x823d('0x42')]()[_0x823d('0x38')](_0x823d('0x1d'))['from'](_0x823d('0x32'))[_0x823d('0x3d')](_0x11c04b+_0x823d('0x43'),_0x574ee1['id']['toString']())))[_0x823d('0x3a')]();return _0x7a05e;};var _0x3a6c47=function(_0x2d2315,_0x26cecd){var _0x580759=squel[_0x823d('0x44')]()[_0x823d('0x31')](_0x823d('0x32'))['fromQuery'](['phone','scheduledAt',_0x823d('0x35'),_0x823d('0x23'),_0x26cecd,_0x823d('0x36'),'updatedAt'],squel['select']()[_0x823d('0x38')]('phone',_0x823d('0x1d'))[_0x823d('0x38')](_0x823d('0x39'),_0x823d('0x34'))[_0x823d('0x38')]('id','ContactId')['field'](LISTID[_0x823d('0x3a')](),_0x823d('0x23'))['field'](_0x2d2315['id'][_0x823d('0x3a')](),_0x26cecd)[_0x823d('0x38')](_0x823d('0x39'),_0x823d('0x36'))['field'](_0x823d('0x39'),_0x823d('0x37'))['from'](_0x823d('0x3c'))[_0x823d('0x3d')](_0x823d('0x3e'))[_0x823d('0x3d')](_0x823d('0x3f'),LISTID[_0x823d('0x3a')]())[_0x823d('0x3d')](_0x823d('0x45'),squel[_0x823d('0x46')](hopperContacts))['where'](_0x823d('0x40'))[_0x823d('0x3d')](_0x823d('0x41'),squel[_0x823d('0x42')]()[_0x823d('0x38')](_0x823d('0x47'))[_0x823d('0x3b')](_0x823d('0x48'))['where'](_0x26cecd+'\x20=\x20?',_0x2d2315['id']['toString']()))[_0x823d('0x3d')](_0x823d('0x41'),squel[_0x823d('0x42')]()[_0x823d('0x38')](_0x823d('0x1d'))[_0x823d('0x3b')](_0x823d('0x32'))[_0x823d('0x3d')](_0x26cecd+_0x823d('0x43'),_0x2d2315['id'][_0x823d('0x3a')]())))['toString']();return _0x580759;};function _0x17f4cd(_0x40d495,_0x39b175){var _0x3c6f40=squel[_0x823d('0x44')]()[_0x823d('0x31')](_0x823d('0x32'))[_0x823d('0x33')]([_0x823d('0x1d'),'scheduledAt',_0x823d('0x35'),_0x823d('0x23'),_0x39b175,_0x823d('0x36'),'updatedAt'],squel[_0x823d('0x42')]()[_0x823d('0x38')](_0x823d('0x1d'),_0x823d('0x1d'))['field'](_0x823d('0x39'),'scheduledAt')[_0x823d('0x38')]('id',_0x823d('0x35'))['field'](LISTID[_0x823d('0x3a')](),_0x823d('0x23'))['field'](_0x40d495['id']['toString'](),_0x39b175)[_0x823d('0x38')]('NOW()',_0x823d('0x36'))['field'](_0x823d('0x39'),'updatedAt')[_0x823d('0x3b')](_0x823d('0x3c'))[_0x823d('0x3d')](_0x823d('0x3e'))[_0x823d('0x3d')](_0x823d('0x3f'),LISTID[_0x823d('0x3a')]())[_0x823d('0x3d')]('id\x20IN\x20?',squel[_0x823d('0x46')](hopperContacts))['where']('phone\x20IS\x20NOT\x20NULL'))['toString']();return _0x3c6f40;}function _0x360400(_0x51bbd5,_0x17786b){var _0x562010=squel[_0x823d('0x44')]()[_0x823d('0x31')](_0x823d('0x49'))['fromQuery']([_0x823d('0x1d'),_0x823d('0x35'),_0x823d('0x23'),_0x17786b,'createdAt',_0x823d('0x37')],squel[_0x823d('0x42')]()['field']('phone',_0x823d('0x1d'))[_0x823d('0x38')]('id',_0x823d('0x35'))[_0x823d('0x38')](LISTID[_0x823d('0x3a')](),'ListId')[_0x823d('0x38')](_0x51bbd5['id'][_0x823d('0x3a')](),_0x17786b)[_0x823d('0x38')](_0x823d('0x39'),_0x823d('0x36'))[_0x823d('0x38')](_0x823d('0x39'),_0x823d('0x37'))[_0x823d('0x3b')](_0x823d('0x3c'))[_0x823d('0x3d')](_0x823d('0x3e'))['where'](_0x823d('0x3f'),LISTID[_0x823d('0x3a')]())[_0x823d('0x3d')]('id\x20IN\x20?',squel[_0x823d('0x46')](hopperContacts))[_0x823d('0x3d')](_0x823d('0x40')))['toString']();return _0x562010;}return db[_0x823d('0x4a')]['findAll']({'where':{'type':'outbound'},'attributes':['id','dialCheckDuplicateType'],'include':[{'model':db[_0x823d('0x4b')],'as':_0x823d('0x4c'),'where':{'id':LISTID}}]})[_0x823d('0x29')](function(_0xe21c29){var _0x19af1d=[];if(_0xe21c29){var _0x57dd12;for(var _0x3b684f=0x0,_0x6de809;_0x3b684f<_0xe21c29[_0x823d('0x17')];_0x3b684f+=0x1){_0x6de809=_0xe21c29[_0x3b684f][_0x823d('0x4d')]({'plain':!![]});switch(_0x6de809[_0x823d('0x4e')]){case _0x823d('0x4f'):_0x19af1d[_0x823d('0x2a')](db['sequelize'][_0x823d('0x50')](_0x3a6c47(_0x6de809,_0x823d('0x51')))[_0x823d('0x29')](function(){})[_0x823d('0x2b')](_0x363f29()));break;case _0x823d('0x52'):_0x19af1d['push'](db[_0x823d('0x53')]['query'](_0x39c2ec(_0x6de809,'VoiceQueueId'))[_0x823d('0x29')](function(){})['catch'](_0x363f29()));break;default:_0x19af1d['push'](db[_0x823d('0x53')][_0x823d('0x50')](_0x17f4cd(_0x6de809,_0x823d('0x51')))[_0x823d('0x29')](function(){})['catch'](_0x363f29()));}}}return _0x19af1d;})[_0x823d('0x54')]()[_0x823d('0x29')](function(){return db[_0x823d('0x4a')]['findAll']({'where':{'type':'outbound'},'attributes':['id'],'include':[{'model':db[_0x823d('0x4b')],'as':'BlackLists','where':{'id':LISTID}}]})[_0x823d('0x29')](function(_0x336173){var _0x503f18=[];if(_0x336173){var _0x11cacb;for(var _0x116c6e=0x0,_0x1653a5;_0x116c6e<_0x336173[_0x823d('0x17')];_0x116c6e+=0x1){_0x1653a5=_0x336173[_0x116c6e]['get']({'plain':!![]});_0x503f18['push'](db[_0x823d('0x53')][_0x823d('0x50')](_0x360400(_0x1653a5,_0x823d('0x51')))[_0x823d('0x29')](function(){})[_0x823d('0x2b')](_0x363f29()));}}return _0x503f18;})[_0x823d('0x54')]();})[_0x823d('0x29')](function(){return db[_0x823d('0x55')][_0x823d('0x56')]({'attributes':['id',_0x823d('0x4e')],'include':[{'model':db[_0x823d('0x4b')],'as':_0x823d('0x4c'),'where':{'id':LISTID}}]})[_0x823d('0x29')](function(_0x5b8d72){var _0x3734f2=[];if(_0x5b8d72){for(var _0x2d58e3=0x0,_0x1fb447;_0x2d58e3<_0x5b8d72[_0x823d('0x17')];_0x2d58e3+=0x1){_0x1fb447=_0x5b8d72[_0x2d58e3]['get']({'plain':!![]});switch(_0x1fb447[_0x823d('0x4e')]){case _0x823d('0x4f'):_0x3734f2[_0x823d('0x2a')](db['sequelize'][_0x823d('0x50')](_0x3a6c47(_0x1fb447,_0x823d('0x57')))[_0x823d('0x29')](function(){})[_0x823d('0x2b')](_0x363f29()));break;case _0x823d('0x52'):_0x3734f2[_0x823d('0x2a')](db[_0x823d('0x53')][_0x823d('0x50')](_0x39c2ec(_0x1fb447,_0x823d('0x57')))[_0x823d('0x29')](function(){})[_0x823d('0x2b')](_0x363f29()));break;default:_0x3734f2[_0x823d('0x2a')](db['sequelize']['query'](_0x17f4cd(_0x1fb447,_0x823d('0x57')))[_0x823d('0x29')](function(){})[_0x823d('0x2b')](_0x363f29()));}}}return _0x3734f2;})['all']();})[_0x823d('0x29')](function(){return db[_0x823d('0x55')][_0x823d('0x56')]({'attributes':['id'],'include':[{'model':db[_0x823d('0x4b')],'as':_0x823d('0x58'),'where':{'id':LISTID}}]})[_0x823d('0x29')](function(_0x38cc45){var _0x287c48=[];if(_0x38cc45){for(var _0x5f1ab6=0x0,_0x5de3fa;_0x5f1ab6<_0x38cc45[_0x823d('0x17')];_0x5f1ab6+=0x1){_0x5de3fa=_0x38cc45[_0x5f1ab6][_0x823d('0x4d')]({'plain':!![]});_0x287c48[_0x823d('0x2a')](db[_0x823d('0x53')][_0x823d('0x50')](_0x360400(_0x5de3fa,_0x823d('0x57')))[_0x823d('0x29')](function(){})[_0x823d('0x2b')](_0x363f29()));}}return _0x287c48;})['all']();})[_0x823d('0x2b')](function(_0x1f8609){logger['error'](_0x823d('0x59'),_0x823d('0x5a'),_0x1f8609[_0x823d('0x18')]);});}var processPromises=function(_0x5383c2){return BPromise[_0x823d('0x54')](promises)['then'](function(_0x5af3fc){})[_0x823d('0x2b')](function(_0x5be4e2){logger[_0x823d('0x14')](_0x823d('0x5b'),JSON[_0x823d('0x2d')](_0x5be4e2));})['finally'](function(){socket[_0x823d('0x5c')]('contact:csv_'+SOCKET_TIMESTAMP,{'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});promises=[];success=0x0;errors=0x0;duplicates=0x0;rows=[];if(_0x5383c2){return _0x5383c2[_0x823d('0x5d')]();}});};var endCsv=function(){return BPromise[_0x823d('0x5e')]()[_0x823d('0x29')](function(){if(hopperContacts){return checkHopper();}})['then'](function(){socket[_0x823d('0x5c')]('contact:csv_'+SOCKET_TIMESTAMP,{'finished':!![],'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});try{fs[_0x823d('0x5f')](FILEPATH);}catch(_0x2b22fd){logger['error']('Unable\x20to\x20delete\x20temp\x20file:',JSON[_0x823d('0x2d')](_0x2b22fd));}finally{process[_0x823d('0x60')](0x0);}});};process['on']('SIGINT',function(){logger['info'](_0x823d('0x61'));endCsv();});function main(){return BPromise[_0x823d('0x5e')]()[_0x823d('0x29')](function(){if(DUPLICATES){DUPLICATES=DUPLICATES[_0x823d('0xf')](',');return db[_0x823d('0x27')][_0x823d('0x56')]({'where':{'ListId':LISTID},'attributes':DUPLICATES,'raw':!![]});}})[_0x823d('0x29')](function(_0x39b82b){var _0x4a0e46=fs[_0x823d('0x62')](FILEPATH,{'highWaterMark':0xf*0x400*0x400});Papa[_0x823d('0x63')](_0x4a0e46,{'header':!![],'skipEmptyLines':!![],'step':function(_0x479a1a,_0x175997){total+=0x1;var _0xa8eb1d=total;promises[_0x823d('0x2a')](checkRow(_0x479a1a,_0x39b82b,_0xa8eb1d)[_0x823d('0x29')](function(){success+=0x1;})['catch'](function(_0x3f6b3d){if(_0x3f6b3d['error']){errors+=0x1;delete _0x3f6b3d['error'];}else if(_0x3f6b3d['duplicate']){duplicates+=0x1;delete _0x3f6b3d['duplicate'];}rows[_0x823d('0x2a')](_0x3f6b3d);}));if(total%0xc8===0x0){_0x175997['pause']();return processPromises(_0x175997);}},'complete':function(){return processPromises()['then'](function(){logger[_0x823d('0x64')](_0x823d('0x65'));endCsv();});},'error':function(_0x224c99,_0x4d7b4f){logger['info']('CSV\x20parse\x20error',JSON[_0x823d('0x2d')](_0x224c99));endCsv();}});})[_0x823d('0x2b')](function(_0x4dda10){logger[_0x823d('0x14')]('Error\x20executing\x20contact\x20csv\x20import:',JSON['stringify'](_0x4dda10));});}main();
git://repos.xcallymotion.com / motion2.git / blob