// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xbb95=['file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','No\x20agent\x20available','uncaughtException','path','lodash','papaparse','util','bluebird','moment','squel','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','import','redis','defaults','localhost','socket.io-emitter','format','cm_contacts_temp_','select','field','phone','.id\x20=\x20','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','join','sequelize','query','select\x20*\x20from\x20','spread','length','isNil','AdditionalPhones','push','all','then','catch','error','message','split','filter','findOne','CmContactHasItem','update','updated','create','inserted','CmContact','CmHopper','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.priority','cm_contacts.UserId','into','cm_hopper','scheduledat','ContactId','ListId','createdAt','updatedAt','priority','UserId','recallme','cm_contacts','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22always\x22','\x22onlyIfOpen\x22','toString','cm_contacts.updatedAt','insert','cm_hopper_black','fromQuery','fields','.CmListId','from','ListId\x20=\x20?','\x20=\x20?','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId',')\x20NOT\x20IN\x20?','id\x20IN\x20?','MIN(id)','min_id','group','info','Received\x20SIGINT','code','stringify','send','start','binding','root','server/files/tmp','.csv','body','ContactItemType','findAll','name','header','parse','createReadStream','rows','errors','data','find','trim','replace','YYYY-MM-DD\x20HH:mm:ss','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','email\x20wrong\x20format','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','SystemRow','appendFileSync','Abort\x20parser','SystemError','step','CREATE\x20TABLE\x20',',\x20scheduledAt\x20=\x20NOW()','each','contact','contactTypeId','orderBy','DROP\x20TABLE\x20','finish','affectedRows','exit','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync'];(function(_0x5443ca,_0x5ad082){var _0x505ade=function(_0x24b1b7){while(--_0x24b1b7){_0x5443ca['push'](_0x5443ca['shift']());}};_0x505ade(++_0x5ad082);}(_0xbb95,0x1d8));var _0x5bb9=function(_0x2625ee,_0x44821d){_0x2625ee=_0x2625ee-0x0;var _0x5db885=_0xbb95[_0x2625ee];return _0x5db885;};'use strict';var fs=require('fs');var path=require(_0x5bb9('0x0'));var _=require(_0x5bb9('0x1'));var Papa=require(_0x5bb9('0x2'));var util=require(_0x5bb9('0x3'));var BPromise=require(_0x5bb9('0x4'));var moment=require(_0x5bb9('0x5'));var squel=require(_0x5bb9('0x6'));var Redis=require(_0x5bb9('0x7'));var db=require(_0x5bb9('0x8'))['db'];var config=require(_0x5bb9('0x9'));var logger=require(_0x5bb9('0xa'))(_0x5bb9('0xb'));config[_0x5bb9('0xc')]=_[_0x5bb9('0xd')](config['redis'],{'host':_0x5bb9('0xe'),'port':0x18eb});var socket=require(_0x5bb9('0xf'))(new Redis(config['redis']));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()[_0x5bb9('0x10')]('YYYY-MM-DD\x20HH:mm:ss');var tempTableName=_0x5bb9('0x11')+moment()[_0x5bb9('0x10')]('YYYYMMDDHHmmss');var contactItemTypes=[];var hasAdditionalPhones=![];function isEmail(_0x562055){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'](_0x562055);}function selectNotIn(_0xb5ad59,_0x221d84,_0x27d542,_0x5b1e55,_0x3c93b2){return squel[_0x5bb9('0x12')]()[_0x5bb9('0x13')](_0x5bb9('0x14'))['from'](_0x5b1e55)['join'](_0x221d84,null,_0x221d84+_0x5bb9('0x15')+_0x5b1e55+'.'+_0x27d542)['where'](_0x5b1e55+'.'+_0x27d542+_0x5bb9('0x16')+_0xb5ad59+'.'+_0x27d542)[_0x5bb9('0x17')](_0x221d84+_0x5bb9('0x18')+_0x3c93b2[_0x5bb9('0x19')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x5b7274,_0x32f2ee){promisesAdditionalPhones=[];promisesContact=[];return db[_0x5bb9('0x1a')][_0x5bb9('0x1b')](_0x5bb9('0x1c')+tempTableName)[_0x5bb9('0x1d')](function(_0x35c808){if(_0x35c808!==null){var _0x5bd733=[];for(var _0x2073e7=0x0;_0x2073e7<_0x35c808[_0x5bb9('0x1e')];_0x2073e7++){var _0x11d47e=_0x35c808[_0x2073e7];if(!_[_0x5bb9('0x1f')](_0x11d47e[_0x5bb9('0x14')])){if(!_['isNil'](_0x11d47e[_0x5bb9('0x20')]))_0x5bd733[_0x5bb9('0x21')](insertAdditionalPhones(_0x11d47e));promisesContact['push']({'contact':_0x11d47e});}}}Promise[_0x5bb9('0x22')](_0x5bd733)[_0x5bb9('0x23')](function(){_0x5b7274({'val':0x1});});})[_0x5bb9('0x24')](function(_0x307386){logger[_0x5bb9('0x25')](_0x307386[_0x5bb9('0x26')]);});});}function insertAdditionalPhones(_0x5a1d78){return new Promise(function(_0x83e79f,_0x30dbd3){var _0x4242bc=_0x5a1d78[_0x5bb9('0x20')];if(_[_0x5bb9('0x1f')](_0x4242bc))_0x30dbd3({'val':0x0});else{var _0x51de9a=_0x4242bc['split'](';');var _0x47907f=[];orderBy=0x0;for(var _0x217ff7=0x0;_0x217ff7<_0x51de9a[_0x5bb9('0x1e')];_0x217ff7++){_0x47907f[_0x5bb9('0x21')](splitAdditionalPhone(_0x5a1d78['id'],_0x51de9a[_0x217ff7]));}Promise[_0x5bb9('0x22')](_0x47907f)[_0x5bb9('0x23')](function(){_0x83e79f({'val':_0x51de9a['length']});});}});}function splitAdditionalPhone(_0x1566eb,_0x4c87c5){return new Promise(function(_0x4d9858,_0x4ac4d2){var _0x532af1=_0x4c87c5['split'](':');var _0x56933a=_0x532af1[0x0];var _0x257224=_0x532af1[0x1];if(_0x257224!==''){var _0x3e9dcb=_0x257224[_0x5bb9('0x27')]('|');var _0x5f4153=[];for(var _0x51d477=0x0;_0x51d477<_0x3e9dcb[_0x5bb9('0x1e')];_0x51d477++){if(_0x3e9dcb[_0x51d477]!==''){var _0x3941ec=_[_0x5bb9('0x28')](promisesAdditionalPhones,{'contactId':_0x1566eb,'phone':_0x3e9dcb[_0x51d477]});if(_0x3941ec['length']==0x0){orderBy++;promisesAdditionalPhones['push']({'contactId':_0x1566eb,'contactTypeId':_0x56933a,'phone':_0x3e9dcb[_0x51d477],'orderBy':orderBy});}}}_0x4d9858({'ok':0x1});}else _0x4d9858({'res':0x0});});}function createAdditionalPhone(_0xb5e8f9,_0x549fac,_0x4e1041,_0x41bc6b){return new Promise(function(_0x3b64b6,_0x569af0){return db['CmContactHasItem'][_0x5bb9('0x29')]({'where':{'CmContactId':_0xb5e8f9,'item':_0x4e1041}})[_0x5bb9('0x23')](function(_0x58a6c7){if(_0x58a6c7){return db[_0x5bb9('0x2a')][_0x5bb9('0x2b')]({'ItemTypeId':_0x549fac,'OrderBy':_0x41bc6b},{'where':{'CmContactId':_0xb5e8f9,'item':_0x4e1041}})['then'](function(_0x43360e){_0x3b64b6({'res':_0x5bb9('0x2c')});});}else{return db['CmContactHasItem'][_0x5bb9('0x2d')]({'CmContactId':_0xb5e8f9,'item':_0x4e1041,'ItemTypeId':_0x549fac,'OrderBy':_0x41bc6b,'ItemClass':'PHONE'})[_0x5bb9('0x23')](function(_0x540e1e){_0x3b64b6({'res':_0x5bb9('0x2e')});});}});});}function updateContact(_0x5d9f9c){return new Promise(function(_0x33015a,_0x434953){var _0x4062cc=_0x5d9f9c['id'];delete _0x5d9f9c['id'];return db[_0x5bb9('0x2f')][_0x5bb9('0x2b')](_0x5d9f9c,{'where':{'id':_0x4062cc}})[_0x5bb9('0x23')](function(_0x1bdb4f){updatedRows+=0x1;return db[_0x5bb9('0x30')]['update']({'phone':_0x5d9f9c['phone']},{'where':{'ContactId':_0x4062cc}})[_0x5bb9('0x23')](function(_0x47fb8e){_0x33015a({'ret':'OK'});});});});}function insertCmHopper(_0x5b864a,_0xc22745,_0x3987dd,_0x32aa39,_0x296624){var _0x300a7a=[_0x5bb9('0x31'),_0x5bb9('0x32'),_0x5bb9('0x33'),_0x5bb9('0x34'),_0xc22745+'.'+_0x32aa39,_0x5bb9('0x35'),'cm_contacts.updatedAt',_0x5bb9('0x36'),_0x5bb9('0x37'),'\x22'+_0x296624+'\x22'];return squel['insert']()[_0x5bb9('0x38')](_0x5bb9('0x39'))['fromQuery']([_0x5bb9('0x14'),_0x5bb9('0x3a'),_0x5bb9('0x3b'),_0x5bb9('0x3c'),_0x32aa39,_0x5bb9('0x3d'),_0x5bb9('0x3e'),_0x5bb9('0x3f'),_0x5bb9('0x40'),_0x5bb9('0x41')],squel['select']()['fields'](_0x300a7a)['from'](_0xc22745)[_0x5bb9('0x19')](_0x5bb9('0x42'),null,'cm_contacts.ListId\x20=\x20'+_0xc22745+'.CmListId')[_0x5bb9('0x19')](_0x3987dd,null,_0x3987dd+_0x5bb9('0x15')+_0xc22745+'.'+_0x32aa39)['where'](_0xc22745+_0x5bb9('0x43'),_0x5b864a)['where'](_0x5bb9('0x44'),NOW)[_0x5bb9('0x17')](_0x5bb9('0x45'),selectNotIn(_0xc22745,_0x3987dd,_0x32aa39,_0x5bb9('0x39'),[_0x5bb9('0x46'),_0x5bb9('0x47')]))['where']('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0xc22745,_0x3987dd,_0x32aa39,_0x5bb9('0x39'),[_0x5bb9('0x46')])))[_0x5bb9('0x48')]();}function insertCmHopperBlack(_0x4617a3,_0x6504ab,_0x5a6102,_0x483520){var _0x1c209c=[_0x5bb9('0x31'),_0x5bb9('0x33'),_0x5bb9('0x34'),_0x6504ab+'.'+_0x483520,'cm_contacts.createdAt',_0x5bb9('0x49')];return squel[_0x5bb9('0x4a')]()[_0x5bb9('0x38')](_0x5bb9('0x4b'))[_0x5bb9('0x4c')](['phone',_0x5bb9('0x3b'),_0x5bb9('0x3c'),_0x483520,_0x5bb9('0x3d'),_0x5bb9('0x3e')],squel[_0x5bb9('0x12')]()[_0x5bb9('0x4d')](_0x1c209c)['from'](_0x6504ab)[_0x5bb9('0x19')](_0x5bb9('0x42'),null,'cm_contacts.ListId\x20=\x20'+_0x6504ab+_0x5bb9('0x4e'))[_0x5bb9('0x19')](_0x5a6102,null,_0x5a6102+_0x5bb9('0x15')+_0x6504ab+'.'+_0x483520)[_0x5bb9('0x17')](_0x6504ab+_0x5bb9('0x43'),_0x4617a3)[_0x5bb9('0x17')](_0x5bb9('0x44'),NOW)[_0x5bb9('0x17')](_0x5bb9('0x45'),squel['select']()[_0x5bb9('0x13')]('phone')[_0x5bb9('0x4f')](_0x5bb9('0x4b'))[_0x5bb9('0x17')](_0x5bb9('0x50'),_0x4617a3)[_0x5bb9('0x17')](_0x483520+_0x5bb9('0x51'),_0x6504ab+'.'+_0x483520)))[_0x5bb9('0x48')]();}function insertCmHopperAdditionalPhones(_0x294404){var _0x290c68=[_0x5bb9('0x52'),_0x5bb9('0x53'),_0x5bb9('0x54'),'cm_contact_has_items.createdAt',_0x5bb9('0x55')];return squel[_0x5bb9('0x4a')]()[_0x5bb9('0x38')](_0x5bb9('0x56'))['fromQuery'](['CmHopperId',_0x5bb9('0x14'),'OrderBy',_0x5bb9('0x3d'),_0x5bb9('0x3e')],squel[_0x5bb9('0x12')]()[_0x5bb9('0x4d')](_0x290c68)[_0x5bb9('0x4f')]('cm_hopper')[_0x5bb9('0x19')]('cm_contacts',null,_0x5bb9('0x57'))[_0x5bb9('0x19')]('cm_contact_has_items',null,_0x5bb9('0x58'))[_0x5bb9('0x17')](_0x5bb9('0x59'),_0x294404)[_0x5bb9('0x17')](_0x5bb9('0x44'),NOW))['toString']();}function insertCmContact(_0xef0166,_0x39aab5,_0x307ebf,_0x47c1d0){var _0x253e47=_[_0x5bb9('0x5a')](_[_0x5bb9('0x5b')](_0x47c1d0),['ListId',_0x5bb9('0x5c'),_0x5bb9('0x3d'),'updatedAt']);return squel[_0x5bb9('0x4a')]()[_0x5bb9('0x38')](_0x5bb9('0x42'))[_0x5bb9('0x4c')](_0x253e47,squel[_0x5bb9('0x12')]()[_0x5bb9('0x4d')](_0x253e47)[_0x5bb9('0x4f')](_0x39aab5)['where']('('+_0x307ebf[_0x5bb9('0x19')](',')+_0x5bb9('0x5d'),squel[_0x5bb9('0x12')]()[_0x5bb9('0x4d')](_0x307ebf)[_0x5bb9('0x4f')](_0x5bb9('0x42'))[_0x5bb9('0x17')]('ListId\x20=\x20?',_0xef0166))['where'](_0x5bb9('0x5e'),squel[_0x5bb9('0x12')]()[_0x5bb9('0x13')](_0x5bb9('0x5f'),_0x5bb9('0x60'))[_0x5bb9('0x4f')](_0x39aab5)[_0x5bb9('0x61')](_0x307ebf[_0x5bb9('0x19')](','))))['toString']();}function handleStop(){logger[_0x5bb9('0x62')](_0x5bb9('0x63'));stopped=!![];}function handleUncaughtException(_0x54f5b1){logger['error'](_0x54f5b1['message']);process['exit'](0x1);}function handleError(_0x42c2a0,_0x1d1fa1){stats['errors'][_0x5bb9('0x21')]({'name':_0x1d1fa1[_0x5bb9('0x64')],'message':_0x1d1fa1[_0x5bb9('0x26')],'row':_0x42c2a0});}function handleQuery(_0x41a7fe){logger[_0x5bb9('0x62')](_0x41a7fe);return db[_0x5bb9('0x1a')][_0x5bb9('0x1b')](_0x41a7fe)['spread'](function(_0x3c86a3){results[_0x5bb9('0x21')](_0x3c86a3);})['catch'](function(_0x8c0c7c){logger[_0x5bb9('0x25')](_0x8c0c7c[_0x5bb9('0x26')]);});}function main(_0x10200b,_0x48f006,_0x4b9b6e,_0x1986eb){logger[_0x5bb9('0x62')]('main',_0x10200b,JSON[_0x5bb9('0x65')](_0x48f006));process[_0x5bb9('0x66')](_0x5bb9('0x67'));var _0x273643=_0x48f006[_0x5bb9('0x68')];var _0x2c6c93=_['clone'](_0x273643);var _0x4237d5=_0x48f006['socket_timestamp'];var _0x4c1eee=path[_0x5bb9('0x19')](config[_0x5bb9('0x69')],_0x5bb9('0x6a'),_0x4237d5+_0x5bb9('0x6b'));logger[_0x5bb9('0x62')](_0x5bb9('0x6c'),_0x48f006);db[_0x5bb9('0x6d')][_0x5bb9('0x6e')]({'raw':!![],'attributes':['id','name']})[_0x5bb9('0x23')](function(_0x1dbf4a){for(var _0x24d99b=0x0;_0x24d99b<_0x1dbf4a['length'];_0x24d99b++){if(_0x1dbf4a[_0x24d99b][_0x5bb9('0x6f')]in _0x273643){contactItemTypes[_0x5bb9('0x21')](_0x1dbf4a[_0x24d99b]);delete _0x2c6c93[_0x1dbf4a[_0x24d99b][_0x5bb9('0x6f')]];hasAdditionalPhones=!![];}else{}}if(hasAdditionalPhones)_0x2c6c93[_0x5bb9('0x20')]='';var _0x2ee1b4=_[_0x5bb9('0x5b')](_0x2c6c93)[_0x5bb9('0x19')]();logger[_0x5bb9('0x62')](_0x5bb9('0x70'),_0x2ee1b4);fs['writeFileSync'](_0x4c1eee,_0x2ee1b4+'\x0a');Papa[_0x5bb9('0x71')](fs[_0x5bb9('0x72')](_0x10200b),{'header':!![],'skipEmptyLines':!![],'step':function(_0x1b8cbf,_0x48d269){try{for(var _0x516dcc=0x0,_0x31b83e=[];_0x516dcc<_0x1b8cbf['data'][_0x5bb9('0x1e')];_0x516dcc++){stats[_0x5bb9('0x73')]+=0x1;if(_0x1b8cbf[_0x5bb9('0x74')][_0x516dcc]){handleError(_0x1b8cbf[_0x5bb9('0x75')][_0x516dcc],_0x1b8cbf[_0x5bb9('0x74')][_0x516dcc]);}else{var _0x4e4bf2=[];var _0x28fc39=[];for(var _0x15c739 in _0x273643){let _0x514f6e=contactItemTypes[_0x5bb9('0x76')](_0x1ac97e=>_0x1ac97e['name']===_0x15c739);if(_[_0x5bb9('0x1f')](_0x514f6e)){if(_0x273643['hasOwnProperty'](_0x15c739)){if(_0x1b8cbf[_0x5bb9('0x75')][_0x516dcc][_0x273643[_0x15c739]]){var _0x3943a6=_[_0x5bb9('0x77')](_0x1b8cbf[_0x5bb9('0x75')][_0x516dcc][_0x273643[_0x15c739]][_0x5bb9('0x78')](/"/g,'\x27'));switch(_0x15c739){case _0x5bb9('0x3a'):var _0x54dc8b=moment(_0x3943a6,_0x5bb9('0x79'),!![]);if(_0x54dc8b[_0x5bb9('0x7a')]()){_0x31b83e[_0x5bb9('0x21')]('\x22'+_0x3943a6+'\x22');}else{_0x4e4bf2['push'](_0x5bb9('0x7b'));}break;case'priority':var _0x372883=parseInt(_0x3943a6);_0x3943a6=_[_0x5bb9('0x7c')](_0x372883)||_0x372883<0x0||_0x372883>0x4?_0x1986eb?0x3:0x2:_0x372883;_0x31b83e[_0x5bb9('0x21')]('\x22'+_0x3943a6+'\x22');break;case'UserId':var _0x557efc=parseInt(_0x3943a6);if(_['isNumber'](_0x557efc)&&_['includes'](_0x4b9b6e,_0x557efc)){_0x31b83e[_0x5bb9('0x21')]('\x22'+_0x557efc+'\x22');}else{_0x4e4bf2[_0x5bb9('0x21')]('agent\x20not\x20exists');}break;case'email':if(isEmail(_0x3943a6)){_0x31b83e[_0x5bb9('0x21')]('\x22'+_0x3943a6+'\x22');}else{_0x4e4bf2[_0x5bb9('0x21')](_0x5bb9('0x7d'));}break;case'dateOfBirth':var _0x364bcf=moment(_0x3943a6,_0x5bb9('0x7e'),!![]);if(_0x364bcf[_0x5bb9('0x7a')]()){_0x31b83e[_0x5bb9('0x21')]('\x22'+_0x3943a6+'\x22');}else{_0x4e4bf2[_0x5bb9('0x21')](_0x5bb9('0x7f'));}break;default:_0x31b83e['push']('\x22'+_0x3943a6+'\x22');}}else{switch(_0x15c739){case _0x5bb9('0x80'):case'phone':_0x4e4bf2[_0x5bb9('0x21')](_0x15c739+_0x5bb9('0x81'));break;default:_0x31b83e[_0x5bb9('0x21')]('\x22\x22');}}}}else{var _0x2ad967='';for(var _0x4f37cd=0x0;_0x4f37cd<_0x273643[_0x15c739][_0x5bb9('0x1e')];_0x4f37cd++){var _0x3943a6=_[_0x5bb9('0x77')](_0x1b8cbf['data'][_0x516dcc][_0x273643[_0x15c739][_0x4f37cd]][_0x5bb9('0x78')](/"/g,'\x27'));if(_0x2ad967=='')_0x2ad967=_0x3943a6;else _0x2ad967+='|'+_0x3943a6;}_0x28fc39['push'](_0x514f6e['id']+':'+_0x2ad967);}}if(hasAdditionalPhones){_0x31b83e[_0x5bb9('0x21')]('\x22'+_0x28fc39[_0x5bb9('0x19')](';')+'\x22');}if(_0x4e4bf2['length']){handleError(_0x1b8cbf[_0x5bb9('0x75')][_0x516dcc],{'code':_0x5bb9('0x82'),'message':_0x4e4bf2[_0x5bb9('0x19')]()});}else{fs[_0x5bb9('0x83')](_0x4c1eee,_0x31b83e[_0x5bb9('0x19')]()+'\x0a');}_0x31b83e=[];}if(!(stats[_0x5bb9('0x73')]%0xc8)){socket['emit']('contact:import:'+_0x4237d5,stats);stats[_0x5bb9('0x74')]=[];}}if(stopped){logger[_0x5bb9('0x62')](_0x5bb9('0x84'));_0x48d269['abort']();}}catch(_0x11fe4d){handleError(_0x1b8cbf[_0x5bb9('0x75')][_0x516dcc],{'code':_0x5bb9('0x85'),'message':_0x11fe4d[_0x5bb9('0x26')]});logger[_0x5bb9('0x25')](_0x5bb9('0x86'),_0x11fe4d[_0x5bb9('0x26')]);}},'complete':function(){try{var _0x3c46f4=[];var _0x46fbec=tempTableName;_0x3c46f4[_0x5bb9('0x21')](_0x5bb9('0x87')+_0x46fbec+'\x20LIKE\x20cm_contacts;');logger[_0x5bb9('0x62')]('CIS\x20len',contactItemTypes[_0x5bb9('0x1e')]);var _0x1df321=util[_0x5bb9('0x10')]('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',_0x4c1eee,_0x46fbec,_0x2ee1b4,_0x48f006[_0x5bb9('0x3c')],_0x48f006[_0x5bb9('0x5c')]||null,NOW,NOW);if(_['isNil'](_0x273643['scheduledat'])){_0x1df321+=_0x5bb9('0x88');}_0x3c46f4['push'](_0x1df321);BPromise[_0x5bb9('0x89')](_0x3c46f4,handleQuery)['then'](function(_0x198ac4){BPromise[_0x5bb9('0x22')]([handleAdditionalPhones()])[_0x5bb9('0x23')](function(){_0x3c46f4=[];for(var _0x3c616e=0x0;_0x3c616e<promisesContact[_0x5bb9('0x1e')];_0x3c616e++){_0x3c46f4['push'](updateContact(promisesContact[_0x3c616e][_0x5bb9('0x8a')]));}BPromise['all'](_0x3c46f4)[_0x5bb9('0x23')](function(){_0x3c46f4=[];for(var _0x55b36f=0x0;_0x55b36f<promisesAdditionalPhones[_0x5bb9('0x1e')];_0x55b36f++){_0x3c46f4['push'](createAdditionalPhone(promisesAdditionalPhones[_0x55b36f]['contactId'],promisesAdditionalPhones[_0x55b36f][_0x5bb9('0x8b')],promisesAdditionalPhones[_0x55b36f][_0x5bb9('0x14')],promisesAdditionalPhones[_0x55b36f][_0x5bb9('0x8c')]));}BPromise['all'](_0x3c46f4)[_0x5bb9('0x23')](function(){_0x3c46f4=[];_0x3c46f4[_0x5bb9('0x21')](insertCmHopperAdditionalPhones(_0x48f006[_0x5bb9('0x3c')]));_0x3c46f4[_0x5bb9('0x21')](_0x5bb9('0x8d')+_0x46fbec+';');BPromise['each'](_0x3c46f4,handleQuery)['then'](function(_0x3bf429){stats[_0x5bb9('0x8e')]=!![];stats[_0x5bb9('0x8f')]=updatedRows;socket['emit']('contact:import:'+_0x4237d5,stats);fs['unlink'](_0x10200b);fs['unlink'](_0x4c1eee);process[_0x5bb9('0x90')](0x0);})[_0x5bb9('0x24')](function(_0x1fdedd){logger['error'](_0x1fdedd[_0x5bb9('0x26')]);process['exit'](0x1);});});});});})['catch'](function(_0x248d90){logger[_0x5bb9('0x25')](_0x248d90['message']);process[_0x5bb9('0x90')](0x1);});}catch(_0x22af5){logger[_0x5bb9('0x25')]('complete',_0x22af5[_0x5bb9('0x26')]);process[_0x5bb9('0x90')](0x1);}},'error':function(_0x50cb05,_0x4e84ce,_0x3c0784,_0x59b3e9){throw new Error(_0x59b3e9);}});});}function validate(){if(process[_0x5bb9('0x91')]&&process[_0x5bb9('0x91')][_0x5bb9('0x1e')]<0x4){throw new Error(_0x5bb9('0x92'));}var _0x2b2415=path[_0x5bb9('0x19')](config['root'],'server/files/tmp',process[_0x5bb9('0x91')][0x2]);if(!fs[_0x5bb9('0x93')](_0x2b2415)){throw new Error(_0x5bb9('0x94'));}var _0x4a9d44={};try{_0x4a9d44=JSON[_0x5bb9('0x71')](process[_0x5bb9('0x91')][0x3]);if(!_0x4a9d44[_0x5bb9('0x68')]){throw new Error(_0x5bb9('0x95'));}var _0x48d32d=0x0;if(_0x4a9d44[_0x5bb9('0x68')][_0x5bb9('0x40')]){_0x48d32d=0x1;}if(!_0x4a9d44[_0x5bb9('0x3c')]){throw new Error(_0x5bb9('0x96'));}}catch(_0x39e142){throw new Error(_0x5bb9('0x97'));}var _0x3b5f7f=[];try{_0x3b5f7f=_[_0x5bb9('0x98')](JSON[_0x5bb9('0x71')](process['argv'][0x4]),'id');}catch(_0x34a46a){logger[_0x5bb9('0x62')](_0x5bb9('0x99'));}main(_0x2b2415,_0x4a9d44,_0x3b5f7f,_0x48d32d);}validate();process['on']('SIGINT',handleStop);process['on'](_0x5bb9('0x9a'),handleUncaughtException);
\ No newline at end of file
+var _0x2854=['arguments\x20<filename>\x20<parameters>\x20<agents>','root','existsSync','file\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','No\x20agent\x20available','uncaughtException','path','lodash','papaparse','util','moment','../../../mysqldb','../../../config/environment','../../../config/logger','import','redis','defaults','localhost','socket.io-emitter','YYYY-MM-DD\x20HH:mm:ss','test','select','field','phone','from','\x20=\x20','where','join','sequelize','query','select\x20*\x20from\x20','isNil','AdditionalPhones','push','all','then','catch','error','message','length','split','findOne','CmContactHasItem','update','create','PHONE','inserted','CmContact','CmHopper','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.updatedAt','cm_contacts.UserId','insert','cm_hopper','fromQuery','scheduledat','ContactId','ListId','createdAt','updatedAt','priority','UserId','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.id\x20=\x20','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','\x22always\x22','\x22onlyIfOpen\x22','into','cm_hopper_black','.CmListId','cm_contacts.phone\x20NOT\x20IN\x20(?)','ListId\x20=\x20?','\x20=\x20?','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_hopper_additional_phones','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?','toString','keys','CompanyId',')\x20NOT\x20IN\x20?','min_id','group','Received\x20SIGINT','errors','code','info','main','stringify','start','binding','clone','socket_timestamp','server/files/tmp','body','ContactItemType','findAll','name','writeFileSync','parse','createReadStream','rows','data','find','hasOwnProperty','trim','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','includes','agent\x20not\x20exists','email','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','replace','appendFileSync','Abort\x20parser','abort','SystemError','step','\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','contact','contactId','contactTypeId','orderBy','DROP\x20TABLE\x20','finish','affectedRows','emit','contact:import:','unlink','exit','complete','argv'];(function(_0x143ce6,_0x46e089){var _0x33ed64=function(_0x5a6856){while(--_0x5a6856){_0x143ce6['push'](_0x143ce6['shift']());}};_0x33ed64(++_0x46e089);}(_0x2854,0x1d7));var _0x4285=function(_0x27d41d,_0x1959aa){_0x27d41d=_0x27d41d-0x0;var _0x58ac6d=_0x2854[_0x27d41d];return _0x58ac6d;};'use strict';var fs=require('fs');var path=require(_0x4285('0x0'));var _=require(_0x4285('0x1'));var Papa=require(_0x4285('0x2'));var util=require(_0x4285('0x3'));var BPromise=require('bluebird');var moment=require(_0x4285('0x4'));var squel=require('squel');var Redis=require('ioredis');var db=require(_0x4285('0x5'))['db'];var config=require(_0x4285('0x6'));var logger=require(_0x4285('0x7'))(_0x4285('0x8'));config[_0x4285('0x9')]=_[_0x4285('0xa')](config[_0x4285('0x9')],{'host':_0x4285('0xb'),'port':0x18eb});var socket=require(_0x4285('0xc'))(new Redis(config[_0x4285('0x9')]));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'](_0x4285('0xd'));var tempTableName='cm_contacts_temp_'+moment()['format']('YYYYMMDDHHmmss');var contactItemTypes=[];var hasAdditionalPhones=![];function isEmail(_0x217d66){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))*$/[_0x4285('0xe')](_0x217d66);}function selectNotIn(_0x566b36,_0xe25368,_0xb3e1bb,_0x21048b,_0x5c899c){return squel[_0x4285('0xf')]()[_0x4285('0x10')](_0x4285('0x11'))[_0x4285('0x12')](_0x21048b)['join'](_0xe25368,null,_0xe25368+'.id\x20=\x20'+_0x21048b+'.'+_0xb3e1bb)['where'](_0x21048b+'.'+_0xb3e1bb+_0x4285('0x13')+_0x566b36+'.'+_0xb3e1bb)[_0x4285('0x14')](_0xe25368+'.dialCheckDuplicateType\x20IN\x20('+_0x5c899c[_0x4285('0x15')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x52f37a,_0x4b343b){promisesAdditionalPhones=[];promisesContact=[];return db[_0x4285('0x16')][_0x4285('0x17')](_0x4285('0x18')+tempTableName)['spread'](function(_0x553c18){if(_0x553c18!==null){var _0x40de3c=[];for(var _0x4b6846=0x0;_0x4b6846<_0x553c18['length'];_0x4b6846++){var _0x2f79ab=_0x553c18[_0x4b6846];if(!_[_0x4285('0x19')](_0x2f79ab[_0x4285('0x11')])){if(!_[_0x4285('0x19')](_0x2f79ab[_0x4285('0x1a')]))_0x40de3c[_0x4285('0x1b')](insertAdditionalPhones(_0x2f79ab));promisesContact[_0x4285('0x1b')]({'contact':_0x2f79ab});}}}Promise[_0x4285('0x1c')](_0x40de3c)[_0x4285('0x1d')](function(){_0x52f37a({'val':0x1});});})[_0x4285('0x1e')](function(_0x3d8437){logger[_0x4285('0x1f')](_0x3d8437[_0x4285('0x20')]);});});}function insertAdditionalPhones(_0x3a0a60){return new Promise(function(_0x5648dd,_0xa5041e){var _0x13463d=_0x3a0a60[_0x4285('0x1a')];if(_['isNil'](_0x13463d))_0xa5041e({'val':0x0});else{var _0x248606=_0x13463d['split'](';');var _0x535713=[];orderBy=0x0;for(var _0x264d25=0x0;_0x264d25<_0x248606[_0x4285('0x21')];_0x264d25++){_0x535713[_0x4285('0x1b')](splitAdditionalPhone(_0x3a0a60['id'],_0x248606[_0x264d25]));}Promise['all'](_0x535713)[_0x4285('0x1d')](function(){_0x5648dd({'val':_0x248606['length']});});}});}function splitAdditionalPhone(_0x1ea5e3,_0x3be92f){return new Promise(function(_0x3162b4,_0x4b240e){var _0x48385e=_0x3be92f[_0x4285('0x22')](':');var _0x376187=_0x48385e[0x0];var _0x4585a0=_0x48385e[0x1];if(_0x4585a0!==''){var _0x255366=_0x4585a0[_0x4285('0x22')]('|');var _0x46c6e0=[];for(var _0x43eb2b=0x0;_0x43eb2b<_0x255366[_0x4285('0x21')];_0x43eb2b++){if(_0x255366[_0x43eb2b]!==''){var _0x2336dc=_['filter'](promisesAdditionalPhones,{'contactId':_0x1ea5e3,'phone':_0x255366[_0x43eb2b]});if(_0x2336dc[_0x4285('0x21')]==0x0){orderBy++;promisesAdditionalPhones[_0x4285('0x1b')]({'contactId':_0x1ea5e3,'contactTypeId':_0x376187,'phone':_0x255366[_0x43eb2b],'orderBy':orderBy});}}}_0x3162b4({'ok':0x1});}else _0x3162b4({'res':0x0});});}function createAdditionalPhone(_0x158f3f,_0x48a44c,_0x56f743,_0xc5663){return new Promise(function(_0x48ffcc,_0x1e18c9){return db['CmContactHasItem'][_0x4285('0x23')]({'where':{'CmContactId':_0x158f3f,'item':_0x56f743}})[_0x4285('0x1d')](function(_0x40369f){if(_0x40369f){return db[_0x4285('0x24')][_0x4285('0x25')]({'ItemTypeId':_0x48a44c,'OrderBy':_0xc5663},{'where':{'CmContactId':_0x158f3f,'item':_0x56f743}})['then'](function(_0x11e1cc){_0x48ffcc({'res':'updated'});});}else{return db[_0x4285('0x24')][_0x4285('0x26')]({'CmContactId':_0x158f3f,'item':_0x56f743,'ItemTypeId':_0x48a44c,'OrderBy':_0xc5663,'ItemClass':_0x4285('0x27')})['then'](function(_0x25ee03){_0x48ffcc({'res':_0x4285('0x28')});});}});});}function updateContact(_0x100c5c){return new Promise(function(_0x2e1679,_0x861d46){var _0x5c8d66=_0x100c5c['id'];delete _0x100c5c['id'];return db[_0x4285('0x29')]['update'](_0x100c5c,{'where':{'id':_0x5c8d66}})['then'](function(_0x123830){updatedRows+=0x1;return db[_0x4285('0x2a')][_0x4285('0x25')]({'phone':_0x100c5c[_0x4285('0x11')]},{'where':{'ContactId':_0x5c8d66}})[_0x4285('0x1d')](function(_0xae08a9){_0x2e1679({'ret':'OK'});});});});}function insertCmHopper(_0x403a35,_0x17c289,_0x45eecd,_0x419b6c,_0x2dae0c){var _0x2d301f=[_0x4285('0x2b'),_0x4285('0x2c'),_0x4285('0x2d'),_0x4285('0x2e'),_0x17c289+'.'+_0x419b6c,'cm_contacts.createdAt',_0x4285('0x2f'),'cm_contacts.priority',_0x4285('0x30'),'\x22'+_0x2dae0c+'\x22'];return squel[_0x4285('0x31')]()['into'](_0x4285('0x32'))[_0x4285('0x33')]([_0x4285('0x11'),_0x4285('0x34'),_0x4285('0x35'),_0x4285('0x36'),_0x419b6c,_0x4285('0x37'),_0x4285('0x38'),_0x4285('0x39'),_0x4285('0x3a'),'recallme'],squel[_0x4285('0xf')]()[_0x4285('0x3b')](_0x2d301f)[_0x4285('0x12')](_0x17c289)[_0x4285('0x15')](_0x4285('0x3c'),null,_0x4285('0x3d')+_0x17c289+'.CmListId')[_0x4285('0x15')](_0x45eecd,null,_0x45eecd+_0x4285('0x3e')+_0x17c289+'.'+_0x419b6c)[_0x4285('0x14')](_0x17c289+_0x4285('0x3f'),_0x403a35)[_0x4285('0x14')](_0x4285('0x40'),NOW)[_0x4285('0x14')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x17c289,_0x45eecd,_0x419b6c,_0x4285('0x32'),[_0x4285('0x41'),_0x4285('0x42')]))[_0x4285('0x14')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x17c289,_0x45eecd,_0x419b6c,_0x4285('0x32'),['\x22always\x22'])))['toString']();}function insertCmHopperBlack(_0xa66869,_0x6a4c2d,_0x47fc37,_0x5c6df7){var _0x12695c=[_0x4285('0x2b'),_0x4285('0x2d'),_0x4285('0x2e'),_0x6a4c2d+'.'+_0x5c6df7,'cm_contacts.createdAt','cm_contacts.updatedAt'];return squel[_0x4285('0x31')]()[_0x4285('0x43')](_0x4285('0x44'))['fromQuery'](['phone','ContactId','ListId',_0x5c6df7,_0x4285('0x37'),_0x4285('0x38')],squel[_0x4285('0xf')]()[_0x4285('0x3b')](_0x12695c)[_0x4285('0x12')](_0x6a4c2d)[_0x4285('0x15')](_0x4285('0x3c'),null,_0x4285('0x3d')+_0x6a4c2d+_0x4285('0x45'))['join'](_0x47fc37,null,_0x47fc37+_0x4285('0x3e')+_0x6a4c2d+'.'+_0x5c6df7)[_0x4285('0x14')](_0x6a4c2d+_0x4285('0x3f'),_0xa66869)[_0x4285('0x14')](_0x4285('0x40'),NOW)[_0x4285('0x14')](_0x4285('0x46'),squel[_0x4285('0xf')]()[_0x4285('0x10')](_0x4285('0x11'))[_0x4285('0x12')]('cm_hopper_black')[_0x4285('0x14')](_0x4285('0x47'),_0xa66869)[_0x4285('0x14')](_0x5c6df7+_0x4285('0x48'),_0x6a4c2d+'.'+_0x5c6df7)))['toString']();}function insertCmHopperAdditionalPhones(_0x2bd89b){var _0x6febb0=[_0x4285('0x49'),_0x4285('0x4a'),_0x4285('0x4b'),'cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt'];return squel['insert']()[_0x4285('0x43')](_0x4285('0x4c'))['fromQuery'](['CmHopperId',_0x4285('0x11'),'OrderBy',_0x4285('0x37'),_0x4285('0x38')],squel[_0x4285('0xf')]()['fields'](_0x6febb0)[_0x4285('0x12')](_0x4285('0x32'))[_0x4285('0x15')](_0x4285('0x3c'),null,_0x4285('0x4d'))[_0x4285('0x15')](_0x4285('0x4e'),null,_0x4285('0x4f'))['where'](_0x4285('0x50'),_0x2bd89b)[_0x4285('0x14')](_0x4285('0x40'),NOW))[_0x4285('0x51')]();}function insertCmContact(_0x4393bd,_0x521f3c,_0x444a33,_0x2011ba){var _0x1eeb3b=_['concat'](_[_0x4285('0x52')](_0x2011ba),['ListId',_0x4285('0x53'),'createdAt','updatedAt']);return squel[_0x4285('0x31')]()[_0x4285('0x43')](_0x4285('0x3c'))[_0x4285('0x33')](_0x1eeb3b,squel[_0x4285('0xf')]()[_0x4285('0x3b')](_0x1eeb3b)[_0x4285('0x12')](_0x521f3c)[_0x4285('0x14')]('('+_0x444a33[_0x4285('0x15')](',')+_0x4285('0x54'),squel[_0x4285('0xf')]()['fields'](_0x444a33)['from'](_0x4285('0x3c'))[_0x4285('0x14')](_0x4285('0x47'),_0x4393bd))[_0x4285('0x14')]('id\x20IN\x20?',squel[_0x4285('0xf')]()['field']('MIN(id)',_0x4285('0x55'))[_0x4285('0x12')](_0x521f3c)[_0x4285('0x56')](_0x444a33[_0x4285('0x15')](','))))[_0x4285('0x51')]();}function handleStop(){logger['info'](_0x4285('0x57'));stopped=!![];}function handleUncaughtException(_0x18c861){logger[_0x4285('0x1f')](_0x18c861['message']);process['exit'](0x1);}function handleError(_0x5a41a4,_0x27ac38){stats[_0x4285('0x58')][_0x4285('0x1b')]({'name':_0x27ac38[_0x4285('0x59')],'message':_0x27ac38[_0x4285('0x20')],'row':_0x5a41a4});}function handleQuery(_0x10c621){logger[_0x4285('0x5a')](_0x10c621);return db[_0x4285('0x16')][_0x4285('0x17')](_0x10c621)['spread'](function(_0xdd4ff3){results[_0x4285('0x1b')](_0xdd4ff3);})[_0x4285('0x1e')](function(_0x17d807){logger[_0x4285('0x1f')](_0x17d807['message']);});}function main(_0x51b781,_0x2f4b55,_0x19bebd,_0x38e3b0){logger[_0x4285('0x5a')](_0x4285('0x5b'),_0x51b781,JSON[_0x4285('0x5c')](_0x2f4b55));process['send'](_0x4285('0x5d'));var _0xc56e11=_0x2f4b55[_0x4285('0x5e')];var _0x5e4bdb=_[_0x4285('0x5f')](_0xc56e11);var _0x2fc5be=_0x2f4b55[_0x4285('0x60')];var _0x53929b=path['join'](config['root'],_0x4285('0x61'),_0x2fc5be+'.csv');logger[_0x4285('0x5a')](_0x4285('0x62'),_0x2f4b55);db[_0x4285('0x63')][_0x4285('0x64')]({'raw':!![],'attributes':['id',_0x4285('0x65')]})[_0x4285('0x1d')](function(_0x48b270){for(var _0x3f2521=0x0;_0x3f2521<_0x48b270['length'];_0x3f2521++){if(_0x48b270[_0x3f2521][_0x4285('0x65')]in _0xc56e11){contactItemTypes[_0x4285('0x1b')](_0x48b270[_0x3f2521]);delete _0x5e4bdb[_0x48b270[_0x3f2521][_0x4285('0x65')]];hasAdditionalPhones=!![];}else{}}if(hasAdditionalPhones)_0x5e4bdb[_0x4285('0x1a')]='';var _0x3bde62=_[_0x4285('0x52')](_0x5e4bdb)[_0x4285('0x15')]();logger[_0x4285('0x5a')]('header',_0x3bde62);fs[_0x4285('0x66')](_0x53929b,_0x3bde62+'\x0a');Papa[_0x4285('0x67')](fs[_0x4285('0x68')](_0x51b781),{'header':!![],'skipEmptyLines':!![],'step':function(_0x1a1754,_0x46fe41){try{for(var _0x6a6c65=0x0,_0x3a9901=[];_0x6a6c65<_0x1a1754['data'][_0x4285('0x21')];_0x6a6c65++){stats[_0x4285('0x69')]+=0x1;if(_0x1a1754['errors'][_0x6a6c65]){handleError(_0x1a1754[_0x4285('0x6a')][_0x6a6c65],_0x1a1754[_0x4285('0x58')][_0x6a6c65]);}else{var _0xb6383=[];var _0x36cf0d=[];for(var _0x2bfd9e in _0xc56e11){let _0x51546c=contactItemTypes[_0x4285('0x6b')](_0x384c12=>_0x384c12[_0x4285('0x65')]===_0x2bfd9e);if(_[_0x4285('0x19')](_0x51546c)){if(_0xc56e11[_0x4285('0x6c')](_0x2bfd9e)){if(_0x1a1754[_0x4285('0x6a')][_0x6a6c65][_0xc56e11[_0x2bfd9e]]){var _0xb2a9db=_[_0x4285('0x6d')](_0x1a1754[_0x4285('0x6a')][_0x6a6c65][_0xc56e11[_0x2bfd9e]]['replace'](/"/g,'\x27'));switch(_0x2bfd9e){case _0x4285('0x34'):var _0x942bc1=moment(_0xb2a9db,'YYYY-MM-DD\x20HH:mm:ss',!![]);if(_0x942bc1[_0x4285('0x6e')]()){_0x3a9901['push']('\x22'+_0xb2a9db+'\x22');}else{_0xb6383[_0x4285('0x1b')](_0x4285('0x6f'));}break;case'priority':var _0x336741=parseInt(_0xb2a9db);_0xb2a9db=_[_0x4285('0x70')](_0x336741)||_0x336741<0x0||_0x336741>0x4?_0x38e3b0?0x3:0x2:_0x336741;_0x3a9901[_0x4285('0x1b')]('\x22'+_0xb2a9db+'\x22');break;case'UserId':var _0x4676de=parseInt(_0xb2a9db);if(_[_0x4285('0x71')](_0x4676de)&&_[_0x4285('0x72')](_0x19bebd,_0x4676de)){_0x3a9901['push']('\x22'+_0x4676de+'\x22');}else{_0xb6383[_0x4285('0x1b')](_0x4285('0x73'));}break;case _0x4285('0x74'):if(isEmail(_0xb2a9db)){_0x3a9901[_0x4285('0x1b')]('\x22'+_0xb2a9db+'\x22');}else{_0xb6383[_0x4285('0x1b')]('email\x20wrong\x20format');}break;case'dateOfBirth':var _0x2af330=moment(_0xb2a9db,_0x4285('0x75'),!![]);if(_0x2af330[_0x4285('0x6e')]()){_0x3a9901[_0x4285('0x1b')]('\x22'+_0xb2a9db+'\x22');}else{_0xb6383[_0x4285('0x1b')](_0x4285('0x76'));}break;default:_0x3a9901[_0x4285('0x1b')]('\x22'+_0xb2a9db+'\x22');}}else{switch(_0x2bfd9e){case _0x4285('0x77'):case'phone':_0xb6383[_0x4285('0x1b')](_0x2bfd9e+_0x4285('0x78'));break;default:_0x3a9901[_0x4285('0x1b')]('\x22\x22');}}}}else{var _0x2f4657='';for(var _0x274424=0x0;_0x274424<_0xc56e11[_0x2bfd9e][_0x4285('0x21')];_0x274424++){var _0xb2a9db=_['trim'](_0x1a1754[_0x4285('0x6a')][_0x6a6c65][_0xc56e11[_0x2bfd9e][_0x274424]][_0x4285('0x79')](/"/g,'\x27'));if(_0x2f4657=='')_0x2f4657=_0xb2a9db;else _0x2f4657+='|'+_0xb2a9db;}_0x36cf0d['push'](_0x51546c['id']+':'+_0x2f4657);}}if(hasAdditionalPhones){_0x3a9901[_0x4285('0x1b')]('\x22'+_0x36cf0d[_0x4285('0x15')](';')+'\x22');}if(_0xb6383[_0x4285('0x21')]){handleError(_0x1a1754[_0x4285('0x6a')][_0x6a6c65],{'code':'SystemRow','message':_0xb6383[_0x4285('0x15')]()});}else{fs[_0x4285('0x7a')](_0x53929b,_0x3a9901[_0x4285('0x15')]()+'\x0a');}_0x3a9901=[];}if(!(stats[_0x4285('0x69')]%0xc8)){socket['emit']('contact:import:'+_0x2fc5be,stats);stats[_0x4285('0x58')]=[];}}if(stopped){logger[_0x4285('0x5a')](_0x4285('0x7b'));_0x46fe41[_0x4285('0x7c')]();}}catch(_0x5bce08){handleError(_0x1a1754[_0x4285('0x6a')][_0x6a6c65],{'code':_0x4285('0x7d'),'message':_0x5bce08['message']});logger[_0x4285('0x1f')](_0x4285('0x7e'),_0x5bce08['message']);}},'complete':function(){try{var _0x4ca5dc=[];var _0x5eb346=tempTableName;_0x4ca5dc[_0x4285('0x1b')]('CREATE\x20TABLE\x20'+_0x5eb346+_0x4285('0x7f'));logger['info'](_0x4285('0x80'),contactItemTypes['length']);var _0xbe9fe1=util['format'](_0x4285('0x81'),_0x53929b,_0x5eb346,_0x3bde62,_0x2f4b55[_0x4285('0x36')],_0x2f4b55[_0x4285('0x53')]||null,NOW,NOW);if(_[_0x4285('0x19')](_0xc56e11[_0x4285('0x34')])){_0xbe9fe1+=_0x4285('0x82');}_0x4ca5dc[_0x4285('0x1b')](_0xbe9fe1);BPromise[_0x4285('0x83')](_0x4ca5dc,handleQuery)[_0x4285('0x1d')](function(_0x86b658){BPromise[_0x4285('0x1c')]([handleAdditionalPhones()])['then'](function(){_0x4ca5dc=[];for(var _0x13b983=0x0;_0x13b983<promisesContact[_0x4285('0x21')];_0x13b983++){_0x4ca5dc[_0x4285('0x1b')](updateContact(promisesContact[_0x13b983][_0x4285('0x84')]));}BPromise[_0x4285('0x1c')](_0x4ca5dc)[_0x4285('0x1d')](function(){_0x4ca5dc=[];for(var _0x5a5e2b=0x0;_0x5a5e2b<promisesAdditionalPhones['length'];_0x5a5e2b++){_0x4ca5dc['push'](createAdditionalPhone(promisesAdditionalPhones[_0x5a5e2b][_0x4285('0x85')],promisesAdditionalPhones[_0x5a5e2b][_0x4285('0x86')],promisesAdditionalPhones[_0x5a5e2b]['phone'],promisesAdditionalPhones[_0x5a5e2b][_0x4285('0x87')]));}BPromise['all'](_0x4ca5dc)[_0x4285('0x1d')](function(){_0x4ca5dc=[];_0x4ca5dc[_0x4285('0x1b')](insertCmHopperAdditionalPhones(_0x2f4b55['ListId']));_0x4ca5dc[_0x4285('0x1b')](_0x4285('0x88')+_0x5eb346+';');BPromise[_0x4285('0x83')](_0x4ca5dc,handleQuery)['then'](function(_0x27f33d){stats[_0x4285('0x89')]=!![];stats[_0x4285('0x8a')]=updatedRows;socket[_0x4285('0x8b')](_0x4285('0x8c')+_0x2fc5be,stats);fs[_0x4285('0x8d')](_0x51b781);fs['unlink'](_0x53929b);process[_0x4285('0x8e')](0x0);})[_0x4285('0x1e')](function(_0x3f7bd1){logger[_0x4285('0x1f')](_0x3f7bd1[_0x4285('0x20')]);process[_0x4285('0x8e')](0x1);});});});});})[_0x4285('0x1e')](function(_0x183a8a){logger[_0x4285('0x1f')](_0x183a8a[_0x4285('0x20')]);process['exit'](0x1);});}catch(_0x46294f){logger[_0x4285('0x1f')](_0x4285('0x8f'),_0x46294f[_0x4285('0x20')]);process['exit'](0x1);}},'error':function(_0x458c2c,_0x59a360,_0x497939,_0x6d13e1){throw new Error(_0x6d13e1);}});});}function validate(){if(process[_0x4285('0x90')]&&process[_0x4285('0x90')][_0x4285('0x21')]<0x4){throw new Error(_0x4285('0x91'));}var _0x1a0dc2=path['join'](config[_0x4285('0x92')],_0x4285('0x61'),process[_0x4285('0x90')][0x2]);if(!fs[_0x4285('0x93')](_0x1a0dc2)){throw new Error(_0x4285('0x94'));}var _0x757702={};try{_0x757702=JSON['parse'](process[_0x4285('0x90')][0x3]);if(!_0x757702['binding']){throw new Error('binding\x20doesn\x27t\x20exists');}var _0x318a35=0x0;if(_0x757702[_0x4285('0x5e')][_0x4285('0x3a')]){_0x318a35=0x1;}if(!_0x757702['ListId']){throw new Error(_0x4285('0x95'));}}catch(_0x5a6527){throw new Error(_0x4285('0x96'));}var _0x34a5d3=[];try{_0x34a5d3=_[_0x4285('0x97')](JSON[_0x4285('0x67')](process[_0x4285('0x90')][0x4]),'id');}catch(_0x1f63dc){logger[_0x4285('0x5a')](_0x4285('0x98'));}main(_0x1a0dc2,_0x757702,_0x34a5d3,_0x318a35);}validate();process['on']('SIGINT',handleStop);process['on'](_0x4285('0x99'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff