// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x68f8=['ListId\x20=\x20?','\x20=\x20?','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.updatedAt','CmHopperId','OrderBy','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys',')\x20NOT\x20IN\x20?','id\x20IN\x20?','MIN(id)','min_id','group','exit','code','info','main','send','start','binding','clone','server/files/tmp','.csv','body','ContactItemType','name','AdditionalPhones','writeFileSync','parse','errors','data','hasOwnProperty','trim','replace','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','priority','isNaN','isNumber','agent\x20not\x20exists','email','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','appendFileSync','rows','emit','contact:import:','Abort\x20parser','abort','SystemError','step','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','CIS\x20len','LOAD\x20DATA\x20LOCAL\x20INFILE\x20\x27%s\x27\x20INTO\x20TABLE\x20%s\x20CHARACTER\x20SET\x20UTF8\x20FIELDS\x20TERMINATED\x20BY\x20\x27,\x27\x20ENCLOSED\x20BY\x20\x27\x22\x27\x20LINES\x20TERMINATED\x20BY\x20\x27\x0a\x27\x20IGNORE\x201\x20ROWS\x20(%s)\x20SET\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27',',\x20scheduledAt\x20=\x20NOW()','each','all','contactTypeId','orderBy','DROP\x20TABLE\x20','affectedRows','unlink','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','root','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','map','No\x20agent\x20available','uncaughtException','path','papaparse','util','bluebird','moment','squel','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','import','redis','localhost','socket.io-emitter','YYYY-MM-DD\x20HH:mm:ss','format','test','field','phone','from','join','\x20=\x20','where','sequelize','query','select\x20*\x20from\x20','spread','length','isNil','push','then','catch','error','message','split','filter','findOne','CmContactHasItem','update','updated','create','inserted','CmContact','CmHopper','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.priority','into','cm_hopper','fromQuery','scheduledat','ContactId','ListId','createdAt','UserId','recallme','select','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','.id\x20=\x20','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','\x22always\x22','cm_contacts.phone\x20NOT\x20IN\x20(?)','toString','cm_contacts.id','insert','cm_hopper_black','updatedAt'];(function(_0x5af587,_0x3a7377){var _0x14d879=function(_0x24f9b6){while(--_0x24f9b6){_0x5af587['push'](_0x5af587['shift']());}};_0x14d879(++_0x3a7377);}(_0x68f8,0x17f));var _0x868f=function(_0x416f83,_0x448f3a){_0x416f83=_0x416f83-0x0;var _0x463967=_0x68f8[_0x416f83];return _0x463967;};'use strict';var fs=require('fs');var path=require(_0x868f('0x0'));var _=require('lodash');var Papa=require(_0x868f('0x1'));var util=require(_0x868f('0x2'));var BPromise=require(_0x868f('0x3'));var moment=require(_0x868f('0x4'));var squel=require(_0x868f('0x5'));var Redis=require(_0x868f('0x6'));var db=require(_0x868f('0x7'))['db'];var config=require(_0x868f('0x8'));var logger=require(_0x868f('0x9'))(_0x868f('0xa'));config[_0x868f('0xb')]=_['defaults'](config[_0x868f('0xb')],{'host':_0x868f('0xc'),'port':0x18eb});var socket=require(_0x868f('0xd'))(new Redis(config[_0x868f('0xb')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var promisesContact=[];var orderBy=0x0;var updatedRows=0x0;var stopped=![];var NOW=moment()['format'](_0x868f('0xe'));var tempTableName='cm_contacts_temp_'+moment()[_0x868f('0xf')]('YYYYMMDDHHmmss');var contactItemTypes=[];var hasAdditionalPhones=![];function isEmail(_0x21573c){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))*$/[_0x868f('0x10')](_0x21573c);}function selectNotIn(_0xa20d71,_0x1c57c5,_0x4a3c91,_0x200132,_0xcf7981){return squel['select']()[_0x868f('0x11')](_0x868f('0x12'))[_0x868f('0x13')](_0x200132)[_0x868f('0x14')](_0x1c57c5,null,_0x1c57c5+'.id\x20=\x20'+_0x200132+'.'+_0x4a3c91)['where'](_0x200132+'.'+_0x4a3c91+_0x868f('0x15')+_0xa20d71+'.'+_0x4a3c91)[_0x868f('0x16')](_0x1c57c5+'.dialCheckDuplicateType\x20IN\x20('+_0xcf7981[_0x868f('0x14')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x351c0d,_0x4c47fe){promisesAdditionalPhones=[];promisesContact=[];return db[_0x868f('0x17')][_0x868f('0x18')](_0x868f('0x19')+tempTableName)[_0x868f('0x1a')](function(_0x3ac559){if(_0x3ac559!==null){var _0x333c8b=[];for(var _0x58f787=0x0;_0x58f787<_0x3ac559[_0x868f('0x1b')];_0x58f787++){var _0x3acbe0=_0x3ac559[_0x58f787];if(!_[_0x868f('0x1c')](_0x3acbe0[_0x868f('0x12')])){if(!_[_0x868f('0x1c')](_0x3acbe0['AdditionalPhones']))_0x333c8b[_0x868f('0x1d')](insertAdditionalPhones(_0x3acbe0));promisesContact[_0x868f('0x1d')]({'contact':_0x3acbe0});}}}Promise['all'](_0x333c8b)[_0x868f('0x1e')](function(){_0x351c0d({'val':0x1});});})[_0x868f('0x1f')](function(_0x40e35d){logger[_0x868f('0x20')](_0x40e35d[_0x868f('0x21')]);});});}function insertAdditionalPhones(_0x58f440){return new Promise(function(_0x20639f,_0x21fc7e){var _0x361237=_0x58f440['AdditionalPhones'];if(_[_0x868f('0x1c')](_0x361237))_0x21fc7e({'val':0x0});else{var _0x46ac35=_0x361237['split'](';');var _0x2c78f5=[];orderBy=0x0;for(var _0x113475=0x0;_0x113475<_0x46ac35['length'];_0x113475++){_0x2c78f5[_0x868f('0x1d')](splitAdditionalPhone(_0x58f440['id'],_0x46ac35[_0x113475]));}Promise['all'](_0x2c78f5)[_0x868f('0x1e')](function(){_0x20639f({'val':_0x46ac35[_0x868f('0x1b')]});});}});}function splitAdditionalPhone(_0x2f0ff7,_0x395142){return new Promise(function(_0x3633e6,_0x1cff6b){var _0x1d3a15=_0x395142[_0x868f('0x22')](':');var _0x4c2987=_0x1d3a15[0x0];var _0x3e7460=_0x1d3a15[0x1];if(_0x3e7460!==''){var _0x38aeb5=_0x3e7460[_0x868f('0x22')]('|');var _0x32c180=[];for(var _0x487b87=0x0;_0x487b87<_0x38aeb5[_0x868f('0x1b')];_0x487b87++){if(_0x38aeb5[_0x487b87]!==''){var _0x16973e=_[_0x868f('0x23')](promisesAdditionalPhones,{'contactId':_0x2f0ff7,'phone':_0x38aeb5[_0x487b87]});if(_0x16973e[_0x868f('0x1b')]==0x0){orderBy++;promisesAdditionalPhones[_0x868f('0x1d')]({'contactId':_0x2f0ff7,'contactTypeId':_0x4c2987,'phone':_0x38aeb5[_0x487b87],'orderBy':orderBy});}}}_0x3633e6({'ok':0x1});}else _0x3633e6({'res':0x0});});}function createAdditionalPhone(_0x5a7a8a,_0x1ba98e,_0x31751e,_0x197ba5){return new Promise(function(_0x5d99ef,_0x5c1204){return db['CmContactHasItem'][_0x868f('0x24')]({'where':{'CmContactId':_0x5a7a8a,'item':_0x31751e}})[_0x868f('0x1e')](function(_0x58d02a){if(_0x58d02a){return db[_0x868f('0x25')][_0x868f('0x26')]({'ItemTypeId':_0x1ba98e,'OrderBy':_0x197ba5},{'where':{'CmContactId':_0x5a7a8a,'item':_0x31751e}})[_0x868f('0x1e')](function(_0x5cb97e){_0x5d99ef({'res':_0x868f('0x27')});});}else{return db['CmContactHasItem'][_0x868f('0x28')]({'CmContactId':_0x5a7a8a,'item':_0x31751e,'ItemTypeId':_0x1ba98e,'OrderBy':_0x197ba5,'ItemClass':'PHONE'})[_0x868f('0x1e')](function(_0x26cd93){_0x5d99ef({'res':_0x868f('0x29')});});}});});}function updateContact(_0x44a2d4){return new Promise(function(_0x2e5e2e,_0x11b65b){var _0x38dc54=_0x44a2d4['id'];delete _0x44a2d4['id'];return db[_0x868f('0x2a')][_0x868f('0x26')](_0x44a2d4,{'where':{'id':_0x38dc54}})[_0x868f('0x1e')](function(_0x37ef63){updatedRows+=0x1;return db[_0x868f('0x2b')][_0x868f('0x26')]({'phone':_0x44a2d4[_0x868f('0x12')]},{'where':{'ContactId':_0x38dc54}})[_0x868f('0x1e')](function(_0x17f245){_0x2e5e2e({'ret':'OK'});});});});}function insertCmHopper(_0x159e4e,_0x5d995b,_0x1904ea,_0x499a79,_0x3c6438){var _0x47bc20=[_0x868f('0x2c'),_0x868f('0x2d'),'cm_contacts.id',_0x868f('0x2e'),_0x5d995b+'.'+_0x499a79,_0x868f('0x2f'),'cm_contacts.updatedAt',_0x868f('0x30'),'cm_contacts.UserId','\x22'+_0x3c6438+'\x22'];return squel['insert']()[_0x868f('0x31')](_0x868f('0x32'))[_0x868f('0x33')](['phone',_0x868f('0x34'),_0x868f('0x35'),_0x868f('0x36'),_0x499a79,_0x868f('0x37'),'updatedAt','priority',_0x868f('0x38'),_0x868f('0x39')],squel[_0x868f('0x3a')]()[_0x868f('0x3b')](_0x47bc20)['from'](_0x5d995b)[_0x868f('0x14')](_0x868f('0x3c'),null,_0x868f('0x3d')+_0x5d995b+_0x868f('0x3e'))[_0x868f('0x14')](_0x1904ea,null,_0x1904ea+_0x868f('0x3f')+_0x5d995b+'.'+_0x499a79)[_0x868f('0x16')](_0x5d995b+_0x868f('0x40'),_0x159e4e)[_0x868f('0x16')](_0x868f('0x41'),NOW)[_0x868f('0x16')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x5d995b,_0x1904ea,_0x499a79,_0x868f('0x32'),[_0x868f('0x42'),'\x22onlyIfOpen\x22']))[_0x868f('0x16')](_0x868f('0x43'),selectNotIn(_0x5d995b,_0x1904ea,_0x499a79,'cm_hopper',[_0x868f('0x42')])))[_0x868f('0x44')]();}function insertCmHopperBlack(_0x2301af,_0x53060e,_0x495302,_0x1dd251){var _0x797011=[_0x868f('0x2c'),_0x868f('0x45'),_0x868f('0x2e'),_0x53060e+'.'+_0x1dd251,_0x868f('0x2f'),'cm_contacts.updatedAt'];return squel[_0x868f('0x46')]()[_0x868f('0x31')](_0x868f('0x47'))[_0x868f('0x33')]([_0x868f('0x12'),'ContactId','ListId',_0x1dd251,_0x868f('0x37'),_0x868f('0x48')],squel[_0x868f('0x3a')]()['fields'](_0x797011)[_0x868f('0x13')](_0x53060e)[_0x868f('0x14')](_0x868f('0x3c'),null,_0x868f('0x3d')+_0x53060e+_0x868f('0x3e'))[_0x868f('0x14')](_0x495302,null,_0x495302+_0x868f('0x3f')+_0x53060e+'.'+_0x1dd251)[_0x868f('0x16')](_0x53060e+_0x868f('0x40'),_0x2301af)[_0x868f('0x16')](_0x868f('0x41'),NOW)[_0x868f('0x16')](_0x868f('0x43'),squel[_0x868f('0x3a')]()[_0x868f('0x11')]('phone')[_0x868f('0x13')](_0x868f('0x47'))[_0x868f('0x16')](_0x868f('0x49'),_0x2301af)['where'](_0x1dd251+_0x868f('0x4a'),_0x53060e+'.'+_0x1dd251)))['toString']();}function insertCmHopperAdditionalPhones(_0x1339e1){var _0x107859=['cm_hopper.id',_0x868f('0x4b'),_0x868f('0x4c'),'cm_contact_has_items.createdAt',_0x868f('0x4d')];return squel[_0x868f('0x46')]()[_0x868f('0x31')]('cm_hopper_additional_phones')[_0x868f('0x33')]([_0x868f('0x4e'),'phone',_0x868f('0x4f'),_0x868f('0x37'),'updatedAt'],squel[_0x868f('0x3a')]()[_0x868f('0x3b')](_0x107859)[_0x868f('0x13')](_0x868f('0x32'))[_0x868f('0x14')](_0x868f('0x3c'),null,_0x868f('0x50'))[_0x868f('0x14')]('cm_contact_has_items',null,_0x868f('0x51'))['where'](_0x868f('0x52'),_0x1339e1)[_0x868f('0x16')]('cm_contacts.createdAt\x20=\x20?',NOW))[_0x868f('0x44')]();}function insertCmContact(_0x1eff7b,_0x38f32e,_0x175e2e,_0x2d9a1c){var _0x1bbe4d=_[_0x868f('0x53')](_[_0x868f('0x54')](_0x2d9a1c),[_0x868f('0x36'),'CompanyId',_0x868f('0x37'),_0x868f('0x48')]);return squel[_0x868f('0x46')]()[_0x868f('0x31')](_0x868f('0x3c'))['fromQuery'](_0x1bbe4d,squel[_0x868f('0x3a')]()[_0x868f('0x3b')](_0x1bbe4d)[_0x868f('0x13')](_0x38f32e)['where']('('+_0x175e2e[_0x868f('0x14')](',')+_0x868f('0x55'),squel['select']()[_0x868f('0x3b')](_0x175e2e)[_0x868f('0x13')](_0x868f('0x3c'))[_0x868f('0x16')](_0x868f('0x49'),_0x1eff7b))[_0x868f('0x16')](_0x868f('0x56'),squel[_0x868f('0x3a')]()[_0x868f('0x11')](_0x868f('0x57'),_0x868f('0x58'))[_0x868f('0x13')](_0x38f32e)[_0x868f('0x59')](_0x175e2e[_0x868f('0x14')](','))))[_0x868f('0x44')]();}function handleStop(){logger['info']('Received\x20SIGINT');stopped=!![];}function handleUncaughtException(_0x291f8f){logger[_0x868f('0x20')](_0x291f8f[_0x868f('0x21')]);process[_0x868f('0x5a')](0x1);}function handleError(_0x39a8c6,_0x1d972d){stats['errors'][_0x868f('0x1d')]({'name':_0x1d972d[_0x868f('0x5b')],'message':_0x1d972d[_0x868f('0x21')],'row':_0x39a8c6});}function handleQuery(_0x163056){logger[_0x868f('0x5c')](_0x163056);return db['sequelize']['query'](_0x163056)[_0x868f('0x1a')](function(_0x3e57d6){results[_0x868f('0x1d')](_0x3e57d6);})[_0x868f('0x1f')](function(_0x539eb6){logger['error'](_0x539eb6[_0x868f('0x21')]);});}function main(_0x125699,_0x2786aa,_0x4495d9,_0x1f888b){logger['info'](_0x868f('0x5d'),_0x125699,JSON['stringify'](_0x2786aa));process[_0x868f('0x5e')](_0x868f('0x5f'));var _0x454e07=_0x2786aa[_0x868f('0x60')];var _0x495e5e=_[_0x868f('0x61')](_0x454e07);var _0x39338e=_0x2786aa['socket_timestamp'];var _0x42a22e=path[_0x868f('0x14')](config['root'],_0x868f('0x62'),_0x39338e+_0x868f('0x63'));logger[_0x868f('0x5c')](_0x868f('0x64'),_0x2786aa);db[_0x868f('0x65')]['findAll']({'raw':!![],'attributes':['id',_0x868f('0x66')]})[_0x868f('0x1e')](function(_0x53aa9c){for(var _0xb6f8c7=0x0;_0xb6f8c7<_0x53aa9c[_0x868f('0x1b')];_0xb6f8c7++){if(_0x53aa9c[_0xb6f8c7][_0x868f('0x66')]in _0x454e07){contactItemTypes['push'](_0x53aa9c[_0xb6f8c7]);delete _0x495e5e[_0x53aa9c[_0xb6f8c7][_0x868f('0x66')]];hasAdditionalPhones=!![];}else{}}if(hasAdditionalPhones)_0x495e5e[_0x868f('0x67')]='';var _0x3f2581=_[_0x868f('0x54')](_0x495e5e)[_0x868f('0x14')]();logger[_0x868f('0x5c')]('header',_0x3f2581);fs[_0x868f('0x68')](_0x42a22e,_0x3f2581+'\x0a');Papa[_0x868f('0x69')](fs['createReadStream'](_0x125699),{'header':!![],'skipEmptyLines':!![],'step':function(_0x58d519,_0x539e2f){try{for(var _0xfbd75f=0x0,_0x48de58=[];_0xfbd75f<_0x58d519['data']['length'];_0xfbd75f++){stats['rows']+=0x1;if(_0x58d519[_0x868f('0x6a')][_0xfbd75f]){handleError(_0x58d519[_0x868f('0x6b')][_0xfbd75f],_0x58d519['errors'][_0xfbd75f]);}else{var _0x54525c=[];var _0x2d24fd=[];for(var _0x48c61f in _0x454e07){let _0x133154=contactItemTypes['find'](_0x42cbdc=>_0x42cbdc['name']===_0x48c61f);if(_['isNil'](_0x133154)){if(_0x454e07[_0x868f('0x6c')](_0x48c61f)){if(_0x58d519[_0x868f('0x6b')][_0xfbd75f][_0x454e07[_0x48c61f]]){var _0x112f2d=_[_0x868f('0x6d')](_0x58d519[_0x868f('0x6b')][_0xfbd75f][_0x454e07[_0x48c61f]][_0x868f('0x6e')](/"/g,'\x27'));switch(_0x48c61f){case _0x868f('0x34'):var _0x55382e=moment(_0x112f2d,_0x868f('0xe'),!![]);if(_0x55382e[_0x868f('0x6f')]()){_0x48de58[_0x868f('0x1d')]('\x22'+_0x112f2d+'\x22');}else{_0x54525c[_0x868f('0x1d')](_0x868f('0x70'));}break;case _0x868f('0x71'):var _0x1c44fd=parseInt(_0x112f2d);_0x112f2d=_[_0x868f('0x72')](_0x1c44fd)||_0x1c44fd<0x0||_0x1c44fd>0x4?_0x1f888b?0x3:0x2:_0x1c44fd;_0x48de58[_0x868f('0x1d')]('\x22'+_0x112f2d+'\x22');break;case'UserId':var _0x5a97ae=parseInt(_0x112f2d);if(_[_0x868f('0x73')](_0x5a97ae)&&_['includes'](_0x4495d9,_0x5a97ae)){_0x48de58['push']('\x22'+_0x5a97ae+'\x22');}else{_0x54525c[_0x868f('0x1d')](_0x868f('0x74'));}break;case _0x868f('0x75'):if(isEmail(_0x112f2d)){_0x48de58[_0x868f('0x1d')]('\x22'+_0x112f2d+'\x22');}else{_0x54525c[_0x868f('0x1d')]('email\x20wrong\x20format');}break;case _0x868f('0x76'):var _0x27e2dd=moment(_0x112f2d,_0x868f('0x77'),!![]);if(_0x27e2dd['isValid']()){_0x48de58[_0x868f('0x1d')]('\x22'+_0x112f2d+'\x22');}else{_0x54525c[_0x868f('0x1d')](_0x868f('0x78'));}break;default:_0x48de58[_0x868f('0x1d')]('\x22'+_0x112f2d+'\x22');}}else{switch(_0x48c61f){case _0x868f('0x79'):case _0x868f('0x12'):_0x54525c[_0x868f('0x1d')](_0x48c61f+'\x20not\x20specified');break;default:_0x48de58[_0x868f('0x1d')]('\x22\x22');}}}}else{var _0x371619='';for(var _0x4a12b3=0x0;_0x4a12b3<_0x454e07[_0x48c61f][_0x868f('0x1b')];_0x4a12b3++){var _0x112f2d=_['trim'](_0x58d519[_0x868f('0x6b')][_0xfbd75f][_0x454e07[_0x48c61f][_0x4a12b3]][_0x868f('0x6e')](/"/g,'\x27'));if(_0x371619=='')_0x371619=_0x112f2d;else _0x371619+='|'+_0x112f2d;}_0x2d24fd[_0x868f('0x1d')](_0x133154['id']+':'+_0x371619);}}if(hasAdditionalPhones){_0x48de58[_0x868f('0x1d')]('\x22'+_0x2d24fd[_0x868f('0x14')](';')+'\x22');}if(_0x54525c[_0x868f('0x1b')]){handleError(_0x58d519[_0x868f('0x6b')][_0xfbd75f],{'code':'SystemRow','message':_0x54525c[_0x868f('0x14')]()});}else{fs[_0x868f('0x7a')](_0x42a22e,_0x48de58['join']()+'\x0a');}_0x48de58=[];}if(!(stats[_0x868f('0x7b')]%0xc8)){socket[_0x868f('0x7c')](_0x868f('0x7d')+_0x39338e,stats);stats[_0x868f('0x6a')]=[];}}if(stopped){logger[_0x868f('0x5c')](_0x868f('0x7e'));_0x539e2f[_0x868f('0x7f')]();}}catch(_0x165203){handleError(_0x58d519[_0x868f('0x6b')][_0xfbd75f],{'code':_0x868f('0x80'),'message':_0x165203[_0x868f('0x21')]});logger[_0x868f('0x20')](_0x868f('0x81'),_0x165203[_0x868f('0x21')]);}},'complete':function(){try{var _0xecd678=[];var _0x3fb388=tempTableName;_0xecd678['push'](_0x868f('0x82')+_0x3fb388+_0x868f('0x83'));logger[_0x868f('0x5c')](_0x868f('0x84'),contactItemTypes[_0x868f('0x1b')]);var _0x362d5=util['format'](_0x868f('0x85'),_0x42a22e,_0x3fb388,_0x3f2581,_0x2786aa[_0x868f('0x36')],_0x2786aa['CompanyId']||null,NOW,NOW);if(_[_0x868f('0x1c')](_0x454e07['scheduledat'])){_0x362d5+=_0x868f('0x86');}_0xecd678[_0x868f('0x1d')](_0x362d5);BPromise[_0x868f('0x87')](_0xecd678,handleQuery)[_0x868f('0x1e')](function(_0xdd8749){BPromise['all']([handleAdditionalPhones()])['then'](function(){_0xecd678=[];for(var _0x5496e4=0x0;_0x5496e4<promisesContact['length'];_0x5496e4++){_0xecd678['push'](updateContact(promisesContact[_0x5496e4]['contact']));}BPromise[_0x868f('0x88')](_0xecd678)[_0x868f('0x1e')](function(){_0xecd678=[];for(var _0x417972=0x0;_0x417972<promisesAdditionalPhones[_0x868f('0x1b')];_0x417972++){_0xecd678['push'](createAdditionalPhone(promisesAdditionalPhones[_0x417972]['contactId'],promisesAdditionalPhones[_0x417972][_0x868f('0x89')],promisesAdditionalPhones[_0x417972]['phone'],promisesAdditionalPhones[_0x417972][_0x868f('0x8a')]));}BPromise[_0x868f('0x88')](_0xecd678)['then'](function(){_0xecd678=[];_0xecd678[_0x868f('0x1d')](insertCmHopperAdditionalPhones(_0x2786aa[_0x868f('0x36')]));_0xecd678[_0x868f('0x1d')](_0x868f('0x8b')+_0x3fb388+';');BPromise[_0x868f('0x87')](_0xecd678,handleQuery)[_0x868f('0x1e')](function(_0x572f62){stats['finish']=!![];stats[_0x868f('0x8c')]=updatedRows;socket[_0x868f('0x7c')](_0x868f('0x7d')+_0x39338e,stats);fs[_0x868f('0x8d')](_0x125699);fs[_0x868f('0x8d')](_0x42a22e);process[_0x868f('0x5a')](0x0);})[_0x868f('0x1f')](function(_0x50fd32){logger[_0x868f('0x20')](_0x50fd32[_0x868f('0x21')]);process[_0x868f('0x5a')](0x1);});});});});})[_0x868f('0x1f')](function(_0x1f3075){logger[_0x868f('0x20')](_0x1f3075[_0x868f('0x21')]);process[_0x868f('0x5a')](0x1);});}catch(_0x459935){logger[_0x868f('0x20')](_0x868f('0x8e'),_0x459935[_0x868f('0x21')]);process[_0x868f('0x5a')](0x1);}},'error':function(_0x16ea13,_0x322dba,_0x45138a,_0x586261){throw new Error(_0x586261);}});});}function validate(){if(process[_0x868f('0x8f')]&&process[_0x868f('0x8f')][_0x868f('0x1b')]<0x4){throw new Error(_0x868f('0x90'));}var _0x5d9d65=path[_0x868f('0x14')](config[_0x868f('0x91')],'server/files/tmp',process[_0x868f('0x8f')][0x2]);if(!fs[_0x868f('0x92')](_0x5d9d65)){throw new Error(_0x868f('0x93'));}var _0x456d2f={};try{_0x456d2f=JSON[_0x868f('0x69')](process['argv'][0x3]);if(!_0x456d2f[_0x868f('0x60')]){throw new Error(_0x868f('0x94'));}var _0x2cb097=0x0;if(_0x456d2f[_0x868f('0x60')]['UserId']){_0x2cb097=0x1;}if(!_0x456d2f[_0x868f('0x36')]){throw new Error('ListId\x20is\x20mandatory');}}catch(_0x134021){throw new Error('body\x20id\x20mandatory');}var _0x1ea67f=[];try{_0x1ea67f=_[_0x868f('0x95')](JSON['parse'](process['argv'][0x4]),'id');}catch(_0x5e566c){logger['info'](_0x868f('0x96'));}main(_0x5d9d65,_0x456d2f,_0x1ea67f,_0x2cb097);}validate();process['on']('SIGINT',handleStop);process['on'](_0x868f('0x97'),handleUncaughtException);
\ No newline at end of file
+var _0x583d=['step','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','LOAD\x20DATA\x20LOCAL\x20INFILE\x20\x27%s\x27\x20INTO\x20TABLE\x20%s\x20CHARACTER\x20SET\x20UTF8\x20FIELDS\x20TERMINATED\x20BY\x20\x27,\x27\x20ENCLOSED\x20BY\x20\x27\x22\x27\x20LINES\x20TERMINATED\x20BY\x20\x27\x0a\x27\x20IGNORE\x201\x20ROWS\x20(%s)\x20SET\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27','scheduledat','contact','contactId','contactTypeId','orderBy','DROP\x20TABLE\x20','each','finish','affectedRows','unlink','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','body\x20id\x20mandatory','No\x20agent\x20available','SIGINT','uncaughtException','path','papaparse','util','bluebird','moment','squel','ioredis','../../../config/environment','../../../config/logger','defaults','redis','localhost','socket.io-emitter','format','cm_contacts_temp_','YYYYMMDDHHmmss','test','select','phone','from','join','.id\x20=\x20','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','sequelize','query','select\x20*\x20from\x20','spread','isNil','AdditionalPhones','push','then','error','message','split','all','length','filter','findOne','CmContactHasItem','update','updated','create','PHONE','inserted','CmContact','CmHopper','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.priority','cm_contacts.UserId','insert','into','cm_hopper','fromQuery','ContactId','createdAt','updatedAt','priority','recallme','cm_contacts.ListId\x20=\x20','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','\x22always\x22','cm_contacts.phone\x20NOT\x20IN\x20(?)','toString','cm_contacts.updatedAt','cm_hopper_black','ListId','fields','cm_contacts','.CmListId','field','ListId\x20=\x20?','\x20=\x20?','cm_hopper.id','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','CmHopperId','OrderBy','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contact_has_items','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId',')\x20NOT\x20IN\x20?','MIN(id)','min_id','group','info','Received\x20SIGINT','exit','errors','code','catch','main','stringify','start','binding','clone','socket_timestamp','root','server/files/tmp','.csv','body','ContactItemType','name','header','writeFileSync','parse','createReadStream','data','find','trim','replace','YYYY-MM-DD\x20HH:mm:ss','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','UserId','isNumber','includes','agent\x20not\x20exists','email','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','firstName','\x20not\x20specified','SystemRow','appendFileSync','emit','contact:import:','Abort\x20parser','abort'];(function(_0x506d83,_0x1899e9){var _0x335e8b=function(_0x4a7044){while(--_0x4a7044){_0x506d83['push'](_0x506d83['shift']());}};_0x335e8b(++_0x1899e9);}(_0x583d,0x164));var _0xd583=function(_0x128d8e,_0xdf3c7b){_0x128d8e=_0x128d8e-0x0;var _0x5a1306=_0x583d[_0x128d8e];return _0x5a1306;};'use strict';var fs=require('fs');var path=require(_0xd583('0x0'));var _=require('lodash');var Papa=require(_0xd583('0x1'));var util=require(_0xd583('0x2'));var BPromise=require(_0xd583('0x3'));var moment=require(_0xd583('0x4'));var squel=require(_0xd583('0x5'));var Redis=require(_0xd583('0x6'));var db=require('../../../mysqldb')['db'];var config=require(_0xd583('0x7'));var logger=require(_0xd583('0x8'))('import');config['redis']=_[_0xd583('0x9')](config[_0xd583('0xa')],{'host':_0xd583('0xb'),'port':0x18eb});var socket=require(_0xd583('0xc'))(new Redis(config[_0xd583('0xa')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var promisesContact=[];var orderBy=0x0;var updatedRows=0x0;var stopped=![];var NOW=moment()[_0xd583('0xd')]('YYYY-MM-DD\x20HH:mm:ss');var tempTableName=_0xd583('0xe')+moment()[_0xd583('0xd')](_0xd583('0xf'));var contactItemTypes=[];var hasAdditionalPhones=![];function isEmail(_0x500e4c){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))*$/[_0xd583('0x10')](_0x500e4c);}function selectNotIn(_0x2faa5e,_0x3c1d25,_0x13ba22,_0x26adb9,_0x13828b){return squel[_0xd583('0x11')]()['field'](_0xd583('0x12'))[_0xd583('0x13')](_0x26adb9)[_0xd583('0x14')](_0x3c1d25,null,_0x3c1d25+_0xd583('0x15')+_0x26adb9+'.'+_0x13ba22)['where'](_0x26adb9+'.'+_0x13ba22+_0xd583('0x16')+_0x2faa5e+'.'+_0x13ba22)[_0xd583('0x17')](_0x3c1d25+_0xd583('0x18')+_0x13828b[_0xd583('0x14')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x5283df,_0x24cb83){promisesAdditionalPhones=[];promisesContact=[];return db[_0xd583('0x19')][_0xd583('0x1a')](_0xd583('0x1b')+tempTableName)[_0xd583('0x1c')](function(_0x2c1c18){if(_0x2c1c18!==null){var _0x5c8679=[];for(var _0x31918c=0x0;_0x31918c<_0x2c1c18['length'];_0x31918c++){var _0x534c03=_0x2c1c18[_0x31918c];if(!_[_0xd583('0x1d')](_0x534c03['phone'])){if(!_[_0xd583('0x1d')](_0x534c03[_0xd583('0x1e')]))_0x5c8679[_0xd583('0x1f')](insertAdditionalPhones(_0x534c03));promisesContact[_0xd583('0x1f')]({'contact':_0x534c03});}}}Promise['all'](_0x5c8679)[_0xd583('0x20')](function(){_0x5283df({'val':0x1});});})['catch'](function(_0x147876){logger[_0xd583('0x21')](_0x147876[_0xd583('0x22')]);});});}function insertAdditionalPhones(_0x1b3302){return new Promise(function(_0x42ff7e,_0x4db3ed){var _0x257e7d=_0x1b3302['AdditionalPhones'];if(_['isNil'](_0x257e7d))_0x4db3ed({'val':0x0});else{var _0x110612=_0x257e7d[_0xd583('0x23')](';');var _0x35264d=[];orderBy=0x0;for(var _0x84ad11=0x0;_0x84ad11<_0x110612['length'];_0x84ad11++){_0x35264d[_0xd583('0x1f')](splitAdditionalPhone(_0x1b3302['id'],_0x110612[_0x84ad11]));}Promise[_0xd583('0x24')](_0x35264d)[_0xd583('0x20')](function(){_0x42ff7e({'val':_0x110612[_0xd583('0x25')]});});}});}function splitAdditionalPhone(_0x394226,_0x2f6466){return new Promise(function(_0x31c48f,_0x47c7b3){var _0x55fa9a=_0x2f6466['split'](':');var _0xfa2641=_0x55fa9a[0x0];var _0xb1a0a2=_0x55fa9a[0x1];if(_0xb1a0a2!==''){var _0x20cb66=_0xb1a0a2[_0xd583('0x23')]('|');var _0x2c0a6f=[];for(var _0x903dd8=0x0;_0x903dd8<_0x20cb66[_0xd583('0x25')];_0x903dd8++){if(_0x20cb66[_0x903dd8]!==''){var _0x2c7c45=_[_0xd583('0x26')](promisesAdditionalPhones,{'contactId':_0x394226,'phone':_0x20cb66[_0x903dd8]});if(_0x2c7c45['length']==0x0){orderBy++;promisesAdditionalPhones[_0xd583('0x1f')]({'contactId':_0x394226,'contactTypeId':_0xfa2641,'phone':_0x20cb66[_0x903dd8],'orderBy':orderBy});}}}_0x31c48f({'ok':0x1});}else _0x31c48f({'res':0x0});});}function createAdditionalPhone(_0x4f7add,_0x2fe292,_0x4f1e7d,_0x40b34e){return new Promise(function(_0x310833,_0x3d1ab0){return db['CmContactHasItem'][_0xd583('0x27')]({'where':{'CmContactId':_0x4f7add,'item':_0x4f1e7d}})[_0xd583('0x20')](function(_0x461f9e){if(_0x461f9e){return db[_0xd583('0x28')][_0xd583('0x29')]({'ItemTypeId':_0x2fe292,'OrderBy':_0x40b34e},{'where':{'CmContactId':_0x4f7add,'item':_0x4f1e7d}})['then'](function(_0xadc32b){_0x310833({'res':_0xd583('0x2a')});});}else{return db[_0xd583('0x28')][_0xd583('0x2b')]({'CmContactId':_0x4f7add,'item':_0x4f1e7d,'ItemTypeId':_0x2fe292,'OrderBy':_0x40b34e,'ItemClass':_0xd583('0x2c')})[_0xd583('0x20')](function(_0x590bc3){_0x310833({'res':_0xd583('0x2d')});});}});});}function updateContact(_0x1dae85){return new Promise(function(_0x1e7258,_0x302df7){var _0x2a7e31=_0x1dae85['id'];delete _0x1dae85['id'];return db[_0xd583('0x2e')]['update'](_0x1dae85,{'where':{'id':_0x2a7e31}})[_0xd583('0x20')](function(_0x17a0eb){updatedRows+=0x1;return db[_0xd583('0x2f')][_0xd583('0x29')]({'phone':_0x1dae85['phone']},{'where':{'ContactId':_0x2a7e31}})[_0xd583('0x20')](function(_0x2595c2){_0x1e7258({'ret':'OK'});});});});}function insertCmHopper(_0x4d7069,_0x52861f,_0x243ddf,_0x171c27,_0x400914){var _0x19a834=[_0xd583('0x30'),_0xd583('0x31'),_0xd583('0x32'),_0xd583('0x33'),_0x52861f+'.'+_0x171c27,_0xd583('0x34'),'cm_contacts.updatedAt',_0xd583('0x35'),_0xd583('0x36'),'\x22'+_0x400914+'\x22'];return squel[_0xd583('0x37')]()[_0xd583('0x38')](_0xd583('0x39'))[_0xd583('0x3a')]([_0xd583('0x12'),'scheduledat',_0xd583('0x3b'),'ListId',_0x171c27,_0xd583('0x3c'),_0xd583('0x3d'),_0xd583('0x3e'),'UserId',_0xd583('0x3f')],squel[_0xd583('0x11')]()['fields'](_0x19a834)[_0xd583('0x13')](_0x52861f)[_0xd583('0x14')]('cm_contacts',null,_0xd583('0x40')+_0x52861f+'.CmListId')[_0xd583('0x14')](_0x243ddf,null,_0x243ddf+'.id\x20=\x20'+_0x52861f+'.'+_0x171c27)[_0xd583('0x17')](_0x52861f+_0xd583('0x41'),_0x4d7069)[_0xd583('0x17')](_0xd583('0x42'),NOW)[_0xd583('0x17')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x52861f,_0x243ddf,_0x171c27,'cm_hopper',[_0xd583('0x43'),'\x22onlyIfOpen\x22']))[_0xd583('0x17')](_0xd583('0x44'),selectNotIn(_0x52861f,_0x243ddf,_0x171c27,_0xd583('0x39'),['\x22always\x22'])))[_0xd583('0x45')]();}function insertCmHopperBlack(_0x20fb24,_0x324d78,_0x26bd7d,_0x12b283){var _0x11215c=[_0xd583('0x30'),_0xd583('0x32'),'cm_contacts.ListId',_0x324d78+'.'+_0x12b283,_0xd583('0x34'),_0xd583('0x46')];return squel[_0xd583('0x37')]()[_0xd583('0x38')](_0xd583('0x47'))[_0xd583('0x3a')]([_0xd583('0x12'),_0xd583('0x3b'),_0xd583('0x48'),_0x12b283,_0xd583('0x3c'),_0xd583('0x3d')],squel['select']()[_0xd583('0x49')](_0x11215c)['from'](_0x324d78)['join'](_0xd583('0x4a'),null,_0xd583('0x40')+_0x324d78+_0xd583('0x4b'))[_0xd583('0x14')](_0x26bd7d,null,_0x26bd7d+_0xd583('0x15')+_0x324d78+'.'+_0x12b283)[_0xd583('0x17')](_0x324d78+_0xd583('0x41'),_0x20fb24)[_0xd583('0x17')](_0xd583('0x42'),NOW)[_0xd583('0x17')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel[_0xd583('0x11')]()[_0xd583('0x4c')]('phone')[_0xd583('0x13')](_0xd583('0x47'))['where'](_0xd583('0x4d'),_0x20fb24)[_0xd583('0x17')](_0x12b283+_0xd583('0x4e'),_0x324d78+'.'+_0x12b283)))[_0xd583('0x45')]();}function insertCmHopperAdditionalPhones(_0x4d524e){var _0x14a3b1=[_0xd583('0x4f'),'cm_contact_has_items.item',_0xd583('0x50'),_0xd583('0x51'),_0xd583('0x52')];return squel['insert']()[_0xd583('0x38')]('cm_hopper_additional_phones')[_0xd583('0x3a')]([_0xd583('0x53'),_0xd583('0x12'),_0xd583('0x54'),_0xd583('0x3c'),_0xd583('0x3d')],squel['select']()[_0xd583('0x49')](_0x14a3b1)['from'](_0xd583('0x39'))[_0xd583('0x14')](_0xd583('0x4a'),null,_0xd583('0x55'))[_0xd583('0x14')](_0xd583('0x56'),null,_0xd583('0x57'))['where'](_0xd583('0x58'),_0x4d524e)['where'](_0xd583('0x42'),NOW))[_0xd583('0x45')]();}function insertCmContact(_0x4fd324,_0x49219e,_0x224958,_0x5b3c49){var _0x4e7657=_[_0xd583('0x59')](_[_0xd583('0x5a')](_0x5b3c49),['ListId',_0xd583('0x5b'),_0xd583('0x3c'),_0xd583('0x3d')]);return squel[_0xd583('0x37')]()[_0xd583('0x38')](_0xd583('0x4a'))[_0xd583('0x3a')](_0x4e7657,squel['select']()['fields'](_0x4e7657)['from'](_0x49219e)[_0xd583('0x17')]('('+_0x224958[_0xd583('0x14')](',')+_0xd583('0x5c'),squel[_0xd583('0x11')]()[_0xd583('0x49')](_0x224958)[_0xd583('0x13')](_0xd583('0x4a'))[_0xd583('0x17')](_0xd583('0x4d'),_0x4fd324))['where']('id\x20IN\x20?',squel[_0xd583('0x11')]()[_0xd583('0x4c')](_0xd583('0x5d'),_0xd583('0x5e'))['from'](_0x49219e)[_0xd583('0x5f')](_0x224958[_0xd583('0x14')](','))))[_0xd583('0x45')]();}function handleStop(){logger[_0xd583('0x60')](_0xd583('0x61'));stopped=!![];}function handleUncaughtException(_0xeb9187){logger[_0xd583('0x21')](_0xeb9187[_0xd583('0x22')]);process[_0xd583('0x62')](0x1);}function handleError(_0x1e5ddf,_0x3aee59){stats[_0xd583('0x63')][_0xd583('0x1f')]({'name':_0x3aee59[_0xd583('0x64')],'message':_0x3aee59[_0xd583('0x22')],'row':_0x1e5ddf});}function handleQuery(_0x572811){logger[_0xd583('0x60')](_0x572811);return db[_0xd583('0x19')][_0xd583('0x1a')](_0x572811)[_0xd583('0x1c')](function(_0x35ab7e){results[_0xd583('0x1f')](_0x35ab7e);})[_0xd583('0x65')](function(_0x3181e3){logger[_0xd583('0x21')](_0x3181e3[_0xd583('0x22')]);});}function main(_0x2ab1a6,_0x15cae9,_0x115f62,_0x3bf6dc){logger[_0xd583('0x60')](_0xd583('0x66'),_0x2ab1a6,JSON[_0xd583('0x67')](_0x15cae9));process['send'](_0xd583('0x68'));var _0x551a2d=_0x15cae9[_0xd583('0x69')];var _0x51fbc3=_[_0xd583('0x6a')](_0x551a2d);var _0x546dab=_0x15cae9[_0xd583('0x6b')];var _0x1e3e4e=path[_0xd583('0x14')](config[_0xd583('0x6c')],_0xd583('0x6d'),_0x546dab+_0xd583('0x6e'));logger[_0xd583('0x60')](_0xd583('0x6f'),_0x15cae9);db[_0xd583('0x70')]['findAll']({'raw':!![],'attributes':['id',_0xd583('0x71')]})[_0xd583('0x20')](function(_0x40ee30){for(var _0x4389e3=0x0;_0x4389e3<_0x40ee30[_0xd583('0x25')];_0x4389e3++){if(_0x40ee30[_0x4389e3][_0xd583('0x71')]in _0x551a2d){contactItemTypes[_0xd583('0x1f')](_0x40ee30[_0x4389e3]);delete _0x51fbc3[_0x40ee30[_0x4389e3][_0xd583('0x71')]];hasAdditionalPhones=!![];}else{}}if(hasAdditionalPhones)_0x51fbc3[_0xd583('0x1e')]='';var _0xdaddc4=_[_0xd583('0x5a')](_0x51fbc3)[_0xd583('0x14')]();logger[_0xd583('0x60')](_0xd583('0x72'),_0xdaddc4);fs[_0xd583('0x73')](_0x1e3e4e,_0xdaddc4+'\x0a');Papa[_0xd583('0x74')](fs[_0xd583('0x75')](_0x2ab1a6),{'header':!![],'skipEmptyLines':!![],'step':function(_0x43f9ef,_0x4d251e){try{for(var _0x226724=0x0,_0x11c549=[];_0x226724<_0x43f9ef['data'][_0xd583('0x25')];_0x226724++){stats['rows']+=0x1;if(_0x43f9ef[_0xd583('0x63')][_0x226724]){handleError(_0x43f9ef[_0xd583('0x76')][_0x226724],_0x43f9ef[_0xd583('0x63')][_0x226724]);}else{var _0x244ebf=[];var _0xceb24b=[];for(var _0x282038 in _0x551a2d){let _0x38e118=contactItemTypes[_0xd583('0x77')](_0x4e8830=>_0x4e8830[_0xd583('0x71')]===_0x282038);if(_[_0xd583('0x1d')](_0x38e118)){if(_0x551a2d['hasOwnProperty'](_0x282038)){if(_0x43f9ef[_0xd583('0x76')][_0x226724][_0x551a2d[_0x282038]]){var _0x43dd38=_[_0xd583('0x78')](_0x43f9ef['data'][_0x226724][_0x551a2d[_0x282038]][_0xd583('0x79')](/"/g,'\x27'));switch(_0x282038){case'scheduledat':var _0x3ad9a0=moment(_0x43dd38,_0xd583('0x7a'),!![]);if(_0x3ad9a0[_0xd583('0x7b')]()){_0x11c549[_0xd583('0x1f')]('\x22'+_0x43dd38+'\x22');}else{_0x244ebf[_0xd583('0x1f')](_0xd583('0x7c'));}break;case _0xd583('0x3e'):var _0x537ef5=parseInt(_0x43dd38);_0x43dd38=_[_0xd583('0x7d')](_0x537ef5)||_0x537ef5<0x0||_0x537ef5>0x4?_0x3bf6dc?0x3:0x2:_0x537ef5;_0x11c549[_0xd583('0x1f')]('\x22'+_0x43dd38+'\x22');break;case _0xd583('0x7e'):var _0x3cda59=parseInt(_0x43dd38);if(_[_0xd583('0x7f')](_0x3cda59)&&_[_0xd583('0x80')](_0x115f62,_0x3cda59)){_0x11c549[_0xd583('0x1f')]('\x22'+_0x3cda59+'\x22');}else{_0x244ebf[_0xd583('0x1f')](_0xd583('0x81'));}break;case _0xd583('0x82'):if(isEmail(_0x43dd38)){_0x11c549[_0xd583('0x1f')]('\x22'+_0x43dd38+'\x22');}else{_0x244ebf[_0xd583('0x1f')](_0xd583('0x83'));}break;case _0xd583('0x84'):var _0xb772f4=moment(_0x43dd38,_0xd583('0x85'),!![]);if(_0xb772f4['isValid']()){_0x11c549[_0xd583('0x1f')]('\x22'+_0x43dd38+'\x22');}else{_0x244ebf[_0xd583('0x1f')]('dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)');}break;default:_0x11c549[_0xd583('0x1f')]('\x22'+_0x43dd38+'\x22');}}else{switch(_0x282038){case _0xd583('0x86'):case'phone':_0x244ebf[_0xd583('0x1f')](_0x282038+_0xd583('0x87'));break;default:_0x11c549[_0xd583('0x1f')]('\x22\x22');}}}}else{var _0x5e9c23='';for(var _0x3b42f2=0x0;_0x3b42f2<_0x551a2d[_0x282038]['length'];_0x3b42f2++){var _0x43dd38=_['trim'](_0x43f9ef[_0xd583('0x76')][_0x226724][_0x551a2d[_0x282038][_0x3b42f2]][_0xd583('0x79')](/"/g,'\x27'));if(_0x5e9c23=='')_0x5e9c23=_0x43dd38;else _0x5e9c23+='|'+_0x43dd38;}_0xceb24b[_0xd583('0x1f')](_0x38e118['id']+':'+_0x5e9c23);}}if(hasAdditionalPhones){_0x11c549['push']('\x22'+_0xceb24b[_0xd583('0x14')](';')+'\x22');}if(_0x244ebf[_0xd583('0x25')]){handleError(_0x43f9ef['data'][_0x226724],{'code':_0xd583('0x88'),'message':_0x244ebf[_0xd583('0x14')]()});}else{fs[_0xd583('0x89')](_0x1e3e4e,_0x11c549['join']()+'\x0a');}_0x11c549=[];}if(!(stats['rows']%0xc8)){socket[_0xd583('0x8a')](_0xd583('0x8b')+_0x546dab,stats);stats[_0xd583('0x63')]=[];}}if(stopped){logger[_0xd583('0x60')](_0xd583('0x8c'));_0x4d251e[_0xd583('0x8d')]();}}catch(_0x2588ee){handleError(_0x43f9ef[_0xd583('0x76')][_0x226724],{'code':'SystemError','message':_0x2588ee[_0xd583('0x22')]});logger['error'](_0xd583('0x8e'),_0x2588ee[_0xd583('0x22')]);}},'complete':function(){try{var _0x32f450=[];var _0x3cde5c=tempTableName;_0x32f450[_0xd583('0x1f')](_0xd583('0x8f')+_0x3cde5c+_0xd583('0x90'));logger['info']('CIS\x20len',contactItemTypes['length']);var _0x25c322=util[_0xd583('0xd')](_0xd583('0x91'),_0x1e3e4e,_0x3cde5c,_0xdaddc4,_0x15cae9[_0xd583('0x48')],_0x15cae9[_0xd583('0x5b')]||null,NOW,NOW);if(_[_0xd583('0x1d')](_0x551a2d[_0xd583('0x92')])){_0x25c322+=',\x20scheduledAt\x20=\x20NOW()';}_0x32f450['push'](_0x25c322);BPromise['each'](_0x32f450,handleQuery)[_0xd583('0x20')](function(_0x4ef3f8){BPromise[_0xd583('0x24')]([handleAdditionalPhones()])[_0xd583('0x20')](function(){_0x32f450=[];for(var _0x142980=0x0;_0x142980<promisesContact[_0xd583('0x25')];_0x142980++){_0x32f450['push'](updateContact(promisesContact[_0x142980][_0xd583('0x93')]));}BPromise[_0xd583('0x24')](_0x32f450)['then'](function(){_0x32f450=[];for(var _0x845925=0x0;_0x845925<promisesAdditionalPhones[_0xd583('0x25')];_0x845925++){_0x32f450[_0xd583('0x1f')](createAdditionalPhone(promisesAdditionalPhones[_0x845925][_0xd583('0x94')],promisesAdditionalPhones[_0x845925][_0xd583('0x95')],promisesAdditionalPhones[_0x845925]['phone'],promisesAdditionalPhones[_0x845925][_0xd583('0x96')]));}BPromise[_0xd583('0x24')](_0x32f450)[_0xd583('0x20')](function(){_0x32f450=[];_0x32f450[_0xd583('0x1f')](insertCmHopperAdditionalPhones(_0x15cae9[_0xd583('0x48')]));_0x32f450['push'](_0xd583('0x97')+_0x3cde5c+';');BPromise[_0xd583('0x98')](_0x32f450,handleQuery)[_0xd583('0x20')](function(_0x411d05){stats[_0xd583('0x99')]=!![];stats[_0xd583('0x9a')]=updatedRows;socket[_0xd583('0x8a')]('contact:import:'+_0x546dab,stats);fs[_0xd583('0x9b')](_0x2ab1a6);fs[_0xd583('0x9b')](_0x1e3e4e);process[_0xd583('0x62')](0x0);})[_0xd583('0x65')](function(_0x103797){logger['error'](_0x103797[_0xd583('0x22')]);process['exit'](0x1);});});});});})[_0xd583('0x65')](function(_0x161f7a){logger[_0xd583('0x21')](_0x161f7a[_0xd583('0x22')]);process['exit'](0x1);});}catch(_0x4ffb30){logger[_0xd583('0x21')](_0xd583('0x9c'),_0x4ffb30['message']);process[_0xd583('0x62')](0x1);}},'error':function(_0x1d2bda,_0x1b7a53,_0x399d9a,_0x5af727){throw new Error(_0x5af727);}});});}function validate(){if(process['argv']&&process[_0xd583('0x9d')][_0xd583('0x25')]<0x4){throw new Error(_0xd583('0x9e'));}var _0x21b612=path['join'](config[_0xd583('0x6c')],_0xd583('0x6d'),process['argv'][0x2]);if(!fs[_0xd583('0x9f')](_0x21b612)){throw new Error(_0xd583('0xa0'));}var _0x2ea94b={};try{_0x2ea94b=JSON[_0xd583('0x74')](process['argv'][0x3]);if(!_0x2ea94b[_0xd583('0x69')]){throw new Error(_0xd583('0xa1'));}var _0x48ffea=0x0;if(_0x2ea94b[_0xd583('0x69')][_0xd583('0x7e')]){_0x48ffea=0x1;}if(!_0x2ea94b[_0xd583('0x48')]){throw new Error('ListId\x20is\x20mandatory');}}catch(_0xfa692){throw new Error(_0xd583('0xa2'));}var _0x2cd84a=[];try{_0x2cd84a=_['map'](JSON[_0xd583('0x74')](process[_0xd583('0x9d')][0x4]),'id');}catch(_0xd0eb31){logger['info'](_0xd583('0xa3'));}main(_0x21b612,_0x2ea94b,_0x2cd84a,_0x48ffea);}validate();process['on'](_0xd583('0xa4'),handleStop);process['on'](_0xd583('0xa5'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff