// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xf1f5=['toString','cm_contacts.createdAt','cm_hopper_black','updatedAt','cm_contacts.ListId\x20=\x20','ListId\x20=\x20?','\x20=\x20?','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','CmHopperId','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contact_has_items','cm_hopper.ListId\x20=\x20?','keys','CompanyId',')\x20NOT\x20IN\x20?','MIN(id)','min_id','info','exit','errors','code','main','stringify','start','binding','socket_timestamp','root','server/files/tmp','.csv','body','ContactItemType','findAll','name','writeFileSync','parse','createReadStream','data','rows','find','trim','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','includes','email','email\x20wrong\x20format','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','\x20not\x20specified','replace','SystemRow','appendFileSync','emit','contact:import:','Abort\x20parser','abort','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','scheduledat',',\x20scheduledAt\x20=\x20NOW()','each','contactTypeId','orderBy','affectedRows','unlink','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','body\x20id\x20mandatory','No\x20agent\x20available','uncaughtException','path','lodash','papaparse','util','moment','ioredis','../../../config/environment','redis','defaults','localhost','socket.io-emitter','format','YYYY-MM-DD\x20HH:mm:ss','cm_contacts_temp_','YYYYMMDDHHmmss','test','select','field','phone','join','.id\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','sequelize','query','select\x20*\x20from\x20','spread','length','isNil','AdditionalPhones','push','all','then','catch','error','message','split','filter','CmContactHasItem','findOne','updated','PHONE','inserted','CmContact','update','CmHopper','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','insert','into','cm_hopper','fromQuery','ContactId','ListId','createdAt','priority','UserId','fields','from','cm_contacts','.CmListId','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22always\x22','\x22onlyIfOpen\x22'];(function(_0x2dea24,_0x2fc021){var _0x309d58=function(_0x2eb89f){while(--_0x2eb89f){_0x2dea24['push'](_0x2dea24['shift']());}};_0x309d58(++_0x2fc021);}(_0xf1f5,0xed));var _0x5f1f=function(_0x18b7f0,_0x403e49){_0x18b7f0=_0x18b7f0-0x0;var _0x38a953=_0xf1f5[_0x18b7f0];return _0x38a953;};'use strict';var fs=require('fs');var path=require(_0x5f1f('0x0'));var _=require(_0x5f1f('0x1'));var Papa=require(_0x5f1f('0x2'));var util=require(_0x5f1f('0x3'));var BPromise=require('bluebird');var moment=require(_0x5f1f('0x4'));var squel=require('squel');var Redis=require(_0x5f1f('0x5'));var db=require('../../../mysqldb')['db'];var config=require(_0x5f1f('0x6'));var logger=require('../../../config/logger')('import');config[_0x5f1f('0x7')]=_[_0x5f1f('0x8')](config['redis'],{'host':_0x5f1f('0x9'),'port':0x18eb});var socket=require(_0x5f1f('0xa'))(new Redis(config[_0x5f1f('0x7')]));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()[_0x5f1f('0xb')](_0x5f1f('0xc'));var tempTableName=_0x5f1f('0xd')+moment()['format'](_0x5f1f('0xe'));var contactItemTypes=[];var hasAdditionalPhones=![];function isEmail(_0x4fab19){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))*$/[_0x5f1f('0xf')](_0x4fab19);}function selectNotIn(_0x5089a0,_0x284073,_0x768176,_0x2e7730,_0x1e66fa){return squel[_0x5f1f('0x10')]()[_0x5f1f('0x11')](_0x5f1f('0x12'))['from'](_0x2e7730)[_0x5f1f('0x13')](_0x284073,null,_0x284073+_0x5f1f('0x14')+_0x2e7730+'.'+_0x768176)[_0x5f1f('0x15')](_0x2e7730+'.'+_0x768176+'\x20=\x20'+_0x5089a0+'.'+_0x768176)[_0x5f1f('0x15')](_0x284073+_0x5f1f('0x16')+_0x1e66fa[_0x5f1f('0x13')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x26bbfa,_0x38cdc2){promisesAdditionalPhones=[];promisesContact=[];return db[_0x5f1f('0x17')][_0x5f1f('0x18')](_0x5f1f('0x19')+tempTableName)[_0x5f1f('0x1a')](function(_0x4bb9fa){if(_0x4bb9fa!==null){var _0x99cf71=[];for(var _0x2e3c28=0x0;_0x2e3c28<_0x4bb9fa[_0x5f1f('0x1b')];_0x2e3c28++){var _0x409032=_0x4bb9fa[_0x2e3c28];if(!_[_0x5f1f('0x1c')](_0x409032[_0x5f1f('0x12')])){if(!_[_0x5f1f('0x1c')](_0x409032[_0x5f1f('0x1d')]))_0x99cf71[_0x5f1f('0x1e')](insertAdditionalPhones(_0x409032));promisesContact[_0x5f1f('0x1e')]({'contact':_0x409032});}}}Promise[_0x5f1f('0x1f')](_0x99cf71)[_0x5f1f('0x20')](function(){_0x26bbfa({'val':0x1});});})[_0x5f1f('0x21')](function(_0x43c0bf){logger[_0x5f1f('0x22')](_0x43c0bf[_0x5f1f('0x23')]);});});}function insertAdditionalPhones(_0x1bae8e){return new Promise(function(_0x12871a,_0x11f14d){var _0x3d0feb=_0x1bae8e['AdditionalPhones'];if(_[_0x5f1f('0x1c')](_0x3d0feb))_0x11f14d({'val':0x0});else{var _0x1d627b=_0x3d0feb[_0x5f1f('0x24')](';');var _0x1bac0c=[];orderBy=0x0;for(var _0x2a687f=0x0;_0x2a687f<_0x1d627b[_0x5f1f('0x1b')];_0x2a687f++){_0x1bac0c['push'](splitAdditionalPhone(_0x1bae8e['id'],_0x1d627b[_0x2a687f]));}Promise['all'](_0x1bac0c)['then'](function(){_0x12871a({'val':_0x1d627b['length']});});}});}function splitAdditionalPhone(_0x24adf3,_0x85cae){return new Promise(function(_0x583368,_0x3d69bf){var _0x1c447d=_0x85cae[_0x5f1f('0x24')](':');var _0x40f5c7=_0x1c447d[0x0];var _0x2cd9b4=_0x1c447d[0x1];if(_0x2cd9b4!==''){var _0x1ca8a5=_0x2cd9b4['split']('|');var _0xce263a=[];for(var _0x1a8bc8=0x0;_0x1a8bc8<_0x1ca8a5['length'];_0x1a8bc8++){if(_0x1ca8a5[_0x1a8bc8]!==''){var _0xcde996=_[_0x5f1f('0x25')](promisesAdditionalPhones,{'contactId':_0x24adf3,'phone':_0x1ca8a5[_0x1a8bc8]});if(_0xcde996[_0x5f1f('0x1b')]==0x0){orderBy++;promisesAdditionalPhones[_0x5f1f('0x1e')]({'contactId':_0x24adf3,'contactTypeId':_0x40f5c7,'phone':_0x1ca8a5[_0x1a8bc8],'orderBy':orderBy});}}}_0x583368({'ok':0x1});}else _0x583368({'res':0x0});});}function createAdditionalPhone(_0x584751,_0x4f8ccd,_0x49fc0b,_0x80b60d){return new Promise(function(_0x1c62c2,_0x29abe3){return db[_0x5f1f('0x26')][_0x5f1f('0x27')]({'where':{'CmContactId':_0x584751,'item':_0x49fc0b}})[_0x5f1f('0x20')](function(_0x3285bb){if(_0x3285bb){return db[_0x5f1f('0x26')]['update']({'ItemTypeId':_0x4f8ccd,'OrderBy':_0x80b60d},{'where':{'CmContactId':_0x584751,'item':_0x49fc0b}})[_0x5f1f('0x20')](function(_0x16dac5){_0x1c62c2({'res':_0x5f1f('0x28')});});}else{return db[_0x5f1f('0x26')]['create']({'CmContactId':_0x584751,'item':_0x49fc0b,'ItemTypeId':_0x4f8ccd,'OrderBy':_0x80b60d,'ItemClass':_0x5f1f('0x29')})[_0x5f1f('0x20')](function(_0x413ee5){_0x1c62c2({'res':_0x5f1f('0x2a')});});}});});}function updateContact(_0x14b60e){return new Promise(function(_0xb5ebc1,_0x422bfe){var _0x49989b=_0x14b60e['id'];delete _0x14b60e['id'];return db[_0x5f1f('0x2b')][_0x5f1f('0x2c')](_0x14b60e,{'where':{'id':_0x49989b}})['then'](function(_0x4e26f5){updatedRows+=0x1;return db[_0x5f1f('0x2d')][_0x5f1f('0x2c')]({'phone':_0x14b60e[_0x5f1f('0x12')]},{'where':{'ContactId':_0x49989b}})[_0x5f1f('0x20')](function(_0x204235){_0xb5ebc1({'ret':'OK'});});});});}function insertCmHopper(_0x5ee9fc,_0x2dc966,_0x9c6823,_0x39601f,_0x1d62f4){var _0x208d97=[_0x5f1f('0x2e'),_0x5f1f('0x2f'),_0x5f1f('0x30'),_0x5f1f('0x31'),_0x2dc966+'.'+_0x39601f,'cm_contacts.createdAt',_0x5f1f('0x32'),_0x5f1f('0x33'),_0x5f1f('0x34'),'\x22'+_0x1d62f4+'\x22'];return squel[_0x5f1f('0x35')]()[_0x5f1f('0x36')](_0x5f1f('0x37'))[_0x5f1f('0x38')]([_0x5f1f('0x12'),'scheduledat',_0x5f1f('0x39'),_0x5f1f('0x3a'),_0x39601f,_0x5f1f('0x3b'),'updatedAt',_0x5f1f('0x3c'),_0x5f1f('0x3d'),'recallme'],squel[_0x5f1f('0x10')]()[_0x5f1f('0x3e')](_0x208d97)[_0x5f1f('0x3f')](_0x2dc966)[_0x5f1f('0x13')](_0x5f1f('0x40'),null,'cm_contacts.ListId\x20=\x20'+_0x2dc966+_0x5f1f('0x41'))['join'](_0x9c6823,null,_0x9c6823+'.id\x20=\x20'+_0x2dc966+'.'+_0x39601f)[_0x5f1f('0x15')](_0x2dc966+_0x5f1f('0x42'),_0x5ee9fc)[_0x5f1f('0x15')](_0x5f1f('0x43'),NOW)['where'](_0x5f1f('0x44'),selectNotIn(_0x2dc966,_0x9c6823,_0x39601f,'cm_hopper',[_0x5f1f('0x45'),_0x5f1f('0x46')]))[_0x5f1f('0x15')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x2dc966,_0x9c6823,_0x39601f,_0x5f1f('0x37'),[_0x5f1f('0x45')])))[_0x5f1f('0x47')]();}function insertCmHopperBlack(_0x1badb8,_0x1bda93,_0x1fb024,_0x4e121d){var _0x34b85f=['cm_contacts.phone',_0x5f1f('0x30'),_0x5f1f('0x31'),_0x1bda93+'.'+_0x4e121d,_0x5f1f('0x48'),_0x5f1f('0x32')];return squel[_0x5f1f('0x35')]()['into'](_0x5f1f('0x49'))[_0x5f1f('0x38')]([_0x5f1f('0x12'),'ContactId',_0x5f1f('0x3a'),_0x4e121d,_0x5f1f('0x3b'),_0x5f1f('0x4a')],squel[_0x5f1f('0x10')]()[_0x5f1f('0x3e')](_0x34b85f)[_0x5f1f('0x3f')](_0x1bda93)['join'](_0x5f1f('0x40'),null,_0x5f1f('0x4b')+_0x1bda93+'.CmListId')[_0x5f1f('0x13')](_0x1fb024,null,_0x1fb024+'.id\x20=\x20'+_0x1bda93+'.'+_0x4e121d)[_0x5f1f('0x15')](_0x1bda93+_0x5f1f('0x42'),_0x1badb8)[_0x5f1f('0x15')](_0x5f1f('0x43'),NOW)[_0x5f1f('0x15')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel['select']()[_0x5f1f('0x11')](_0x5f1f('0x12'))[_0x5f1f('0x3f')](_0x5f1f('0x49'))[_0x5f1f('0x15')](_0x5f1f('0x4c'),_0x1badb8)['where'](_0x4e121d+_0x5f1f('0x4d'),_0x1bda93+'.'+_0x4e121d)))[_0x5f1f('0x47')]();}function insertCmHopperAdditionalPhones(_0x190246){var _0x197ac9=[_0x5f1f('0x4e'),_0x5f1f('0x4f'),_0x5f1f('0x50'),_0x5f1f('0x51'),_0x5f1f('0x52')];return squel[_0x5f1f('0x35')]()[_0x5f1f('0x36')](_0x5f1f('0x53'))[_0x5f1f('0x38')]([_0x5f1f('0x54'),_0x5f1f('0x12'),'OrderBy',_0x5f1f('0x3b'),_0x5f1f('0x4a')],squel[_0x5f1f('0x10')]()['fields'](_0x197ac9)[_0x5f1f('0x3f')](_0x5f1f('0x37'))[_0x5f1f('0x13')](_0x5f1f('0x40'),null,_0x5f1f('0x55'))['join'](_0x5f1f('0x56'),null,'cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId')[_0x5f1f('0x15')](_0x5f1f('0x57'),_0x190246)[_0x5f1f('0x15')]('cm_contacts.createdAt\x20=\x20?',NOW))[_0x5f1f('0x47')]();}function insertCmContact(_0x42933b,_0x34d93e,_0x5f4282,_0x20f444){var _0x3ac2b0=_['concat'](_[_0x5f1f('0x58')](_0x20f444),[_0x5f1f('0x3a'),_0x5f1f('0x59'),_0x5f1f('0x3b'),'updatedAt']);return squel[_0x5f1f('0x35')]()['into']('cm_contacts')['fromQuery'](_0x3ac2b0,squel['select']()[_0x5f1f('0x3e')](_0x3ac2b0)[_0x5f1f('0x3f')](_0x34d93e)['where']('('+_0x5f4282['join'](',')+_0x5f1f('0x5a'),squel[_0x5f1f('0x10')]()[_0x5f1f('0x3e')](_0x5f4282)['from'](_0x5f1f('0x40'))[_0x5f1f('0x15')](_0x5f1f('0x4c'),_0x42933b))[_0x5f1f('0x15')]('id\x20IN\x20?',squel[_0x5f1f('0x10')]()[_0x5f1f('0x11')](_0x5f1f('0x5b'),_0x5f1f('0x5c'))[_0x5f1f('0x3f')](_0x34d93e)['group'](_0x5f4282[_0x5f1f('0x13')](','))))[_0x5f1f('0x47')]();}function handleStop(){logger[_0x5f1f('0x5d')]('Received\x20SIGINT');stopped=!![];}function handleUncaughtException(_0x340305){logger[_0x5f1f('0x22')](_0x340305[_0x5f1f('0x23')]);process[_0x5f1f('0x5e')](0x1);}function handleError(_0x132fb4,_0x49eb86){stats[_0x5f1f('0x5f')][_0x5f1f('0x1e')]({'name':_0x49eb86[_0x5f1f('0x60')],'message':_0x49eb86[_0x5f1f('0x23')],'row':_0x132fb4});}function handleQuery(_0x5defbb){logger['info'](_0x5defbb);return db[_0x5f1f('0x17')]['query'](_0x5defbb)[_0x5f1f('0x1a')](function(_0x4eff5a){results[_0x5f1f('0x1e')](_0x4eff5a);})[_0x5f1f('0x21')](function(_0x544874){logger[_0x5f1f('0x22')](_0x544874[_0x5f1f('0x23')]);});}function main(_0x348c1a,_0x597f26,_0x804d33,_0x11cfca){logger[_0x5f1f('0x5d')](_0x5f1f('0x61'),_0x348c1a,JSON[_0x5f1f('0x62')](_0x597f26));process['send'](_0x5f1f('0x63'));var _0x29f4db=_0x597f26[_0x5f1f('0x64')];var _0x992d36=_['clone'](_0x29f4db);var _0x54223d=_0x597f26[_0x5f1f('0x65')];var _0x41defd=path['join'](config[_0x5f1f('0x66')],_0x5f1f('0x67'),_0x54223d+_0x5f1f('0x68'));logger[_0x5f1f('0x5d')](_0x5f1f('0x69'),_0x597f26);db[_0x5f1f('0x6a')][_0x5f1f('0x6b')]({'raw':!![],'attributes':['id','name']})[_0x5f1f('0x20')](function(_0x3028cd){for(var _0x108759=0x0;_0x108759<_0x3028cd['length'];_0x108759++){if(_0x3028cd[_0x108759][_0x5f1f('0x6c')]in _0x29f4db){contactItemTypes[_0x5f1f('0x1e')](_0x3028cd[_0x108759]);delete _0x992d36[_0x3028cd[_0x108759][_0x5f1f('0x6c')]];hasAdditionalPhones=!![];}else{}}if(hasAdditionalPhones)_0x992d36[_0x5f1f('0x1d')]='';var _0x52ede0=_[_0x5f1f('0x58')](_0x992d36)['join']();logger[_0x5f1f('0x5d')]('header',_0x52ede0);fs[_0x5f1f('0x6d')](_0x41defd,_0x52ede0+'\x0a');Papa[_0x5f1f('0x6e')](fs[_0x5f1f('0x6f')](_0x348c1a),{'header':!![],'skipEmptyLines':!![],'step':function(_0x576958,_0x127b24){try{for(var _0x328b82=0x0,_0x4f3576=[];_0x328b82<_0x576958[_0x5f1f('0x70')]['length'];_0x328b82++){stats[_0x5f1f('0x71')]+=0x1;if(_0x576958[_0x5f1f('0x5f')][_0x328b82]){handleError(_0x576958[_0x5f1f('0x70')][_0x328b82],_0x576958[_0x5f1f('0x5f')][_0x328b82]);}else{var _0x157c97=[];var _0xb6d910=[];for(var _0x249c9c in _0x29f4db){let _0x40f178=contactItemTypes[_0x5f1f('0x72')](_0x26be71=>_0x26be71[_0x5f1f('0x6c')]===_0x249c9c);if(_[_0x5f1f('0x1c')](_0x40f178)){if(_0x29f4db['hasOwnProperty'](_0x249c9c)){if(_0x576958['data'][_0x328b82][_0x29f4db[_0x249c9c]]){var _0x2f8f1b=_[_0x5f1f('0x73')](_0x576958[_0x5f1f('0x70')][_0x328b82][_0x29f4db[_0x249c9c]]['replace'](/"/g,'\x27'));switch(_0x249c9c){case'scheduledat':var _0x36f580=moment(_0x2f8f1b,_0x5f1f('0xc'),!![]);if(_0x36f580[_0x5f1f('0x74')]()){_0x4f3576[_0x5f1f('0x1e')]('\x22'+_0x2f8f1b+'\x22');}else{_0x157c97[_0x5f1f('0x1e')](_0x5f1f('0x75'));}break;case'priority':var _0x42295f=parseInt(_0x2f8f1b);_0x2f8f1b=_[_0x5f1f('0x76')](_0x42295f)||_0x42295f<0x0||_0x42295f>0x4?_0x11cfca?0x3:0x2:_0x42295f;_0x4f3576[_0x5f1f('0x1e')]('\x22'+_0x2f8f1b+'\x22');break;case _0x5f1f('0x3d'):var _0x57a3dd=parseInt(_0x2f8f1b);if(_[_0x5f1f('0x77')](_0x57a3dd)&&_[_0x5f1f('0x78')](_0x804d33,_0x57a3dd)){_0x4f3576[_0x5f1f('0x1e')]('\x22'+_0x57a3dd+'\x22');}else{_0x157c97['push']('agent\x20not\x20exists');}break;case _0x5f1f('0x79'):if(isEmail(_0x2f8f1b)){_0x4f3576[_0x5f1f('0x1e')]('\x22'+_0x2f8f1b+'\x22');}else{_0x157c97[_0x5f1f('0x1e')](_0x5f1f('0x7a'));}break;case'dateOfBirth':var _0x2e8bc1=moment(_0x2f8f1b,_0x5f1f('0x7b'),!![]);if(_0x2e8bc1[_0x5f1f('0x74')]()){_0x4f3576[_0x5f1f('0x1e')]('\x22'+_0x2f8f1b+'\x22');}else{_0x157c97[_0x5f1f('0x1e')](_0x5f1f('0x7c'));}break;default:_0x4f3576['push']('\x22'+_0x2f8f1b+'\x22');}}else{switch(_0x249c9c){case'firstName':case'phone':_0x157c97[_0x5f1f('0x1e')](_0x249c9c+_0x5f1f('0x7d'));break;default:_0x4f3576[_0x5f1f('0x1e')]('\x22\x22');}}}}else{var _0x4ced16='';for(var _0x41e0ec=0x0;_0x41e0ec<_0x29f4db[_0x249c9c]['length'];_0x41e0ec++){var _0x2f8f1b=_[_0x5f1f('0x73')](_0x576958[_0x5f1f('0x70')][_0x328b82][_0x29f4db[_0x249c9c][_0x41e0ec]][_0x5f1f('0x7e')](/"/g,'\x27'));if(_0x4ced16=='')_0x4ced16=_0x2f8f1b;else _0x4ced16+='|'+_0x2f8f1b;}_0xb6d910[_0x5f1f('0x1e')](_0x40f178['id']+':'+_0x4ced16);}}if(hasAdditionalPhones){_0x4f3576[_0x5f1f('0x1e')]('\x22'+_0xb6d910['join'](';')+'\x22');}if(_0x157c97[_0x5f1f('0x1b')]){handleError(_0x576958['data'][_0x328b82],{'code':_0x5f1f('0x7f'),'message':_0x157c97[_0x5f1f('0x13')]()});}else{fs[_0x5f1f('0x80')](_0x41defd,_0x4f3576[_0x5f1f('0x13')]()+'\x0a');}_0x4f3576=[];}if(!(stats[_0x5f1f('0x71')]%0xc8)){socket[_0x5f1f('0x81')](_0x5f1f('0x82')+_0x54223d,stats);stats[_0x5f1f('0x5f')]=[];}}if(stopped){logger[_0x5f1f('0x5d')](_0x5f1f('0x83'));_0x127b24[_0x5f1f('0x84')]();}}catch(_0x3a783d){handleError(_0x576958[_0x5f1f('0x70')][_0x328b82],{'code':'SystemError','message':_0x3a783d[_0x5f1f('0x23')]});logger[_0x5f1f('0x22')](_0x5f1f('0x85'),_0x3a783d[_0x5f1f('0x23')]);}},'complete':function(){try{var _0x37144d=[];var _0x1d1441=tempTableName;_0x37144d[_0x5f1f('0x1e')](_0x5f1f('0x86')+_0x1d1441+_0x5f1f('0x87'));logger[_0x5f1f('0x5d')](_0x5f1f('0x88'),contactItemTypes[_0x5f1f('0x1b')]);var _0x42ba20=util[_0x5f1f('0xb')](_0x5f1f('0x89'),_0x41defd,_0x1d1441,_0x52ede0,_0x597f26['ListId'],_0x597f26[_0x5f1f('0x59')]||null,NOW,NOW);if(_['isNil'](_0x29f4db[_0x5f1f('0x8a')])){_0x42ba20+=_0x5f1f('0x8b');}_0x37144d[_0x5f1f('0x1e')](_0x42ba20);BPromise[_0x5f1f('0x8c')](_0x37144d,handleQuery)[_0x5f1f('0x20')](function(_0x2f3feb){BPromise[_0x5f1f('0x1f')]([handleAdditionalPhones()])[_0x5f1f('0x20')](function(){_0x37144d=[];for(var _0x2d767f=0x0;_0x2d767f<promisesContact['length'];_0x2d767f++){_0x37144d[_0x5f1f('0x1e')](updateContact(promisesContact[_0x2d767f]['contact']));}BPromise[_0x5f1f('0x1f')](_0x37144d)[_0x5f1f('0x20')](function(){_0x37144d=[];for(var _0x2ca116=0x0;_0x2ca116<promisesAdditionalPhones['length'];_0x2ca116++){_0x37144d[_0x5f1f('0x1e')](createAdditionalPhone(promisesAdditionalPhones[_0x2ca116]['contactId'],promisesAdditionalPhones[_0x2ca116][_0x5f1f('0x8d')],promisesAdditionalPhones[_0x2ca116][_0x5f1f('0x12')],promisesAdditionalPhones[_0x2ca116][_0x5f1f('0x8e')]));}BPromise[_0x5f1f('0x1f')](_0x37144d)[_0x5f1f('0x20')](function(){_0x37144d=[];_0x37144d['push'](insertCmHopperAdditionalPhones(_0x597f26[_0x5f1f('0x3a')]));_0x37144d[_0x5f1f('0x1e')]('DROP\x20TABLE\x20'+_0x1d1441+';');BPromise[_0x5f1f('0x8c')](_0x37144d,handleQuery)[_0x5f1f('0x20')](function(_0x14bf71){stats['finish']=!![];stats[_0x5f1f('0x8f')]=updatedRows;socket[_0x5f1f('0x81')](_0x5f1f('0x82')+_0x54223d,stats);fs[_0x5f1f('0x90')](_0x348c1a);fs['unlink'](_0x41defd);process[_0x5f1f('0x5e')](0x0);})[_0x5f1f('0x21')](function(_0x5ecdb7){logger['error'](_0x5ecdb7['message']);process[_0x5f1f('0x5e')](0x1);});});});});})['catch'](function(_0x1e35ca){logger[_0x5f1f('0x22')](_0x1e35ca[_0x5f1f('0x23')]);process[_0x5f1f('0x5e')](0x1);});}catch(_0x4b73d4){logger[_0x5f1f('0x22')]('complete',_0x4b73d4['message']);process[_0x5f1f('0x5e')](0x1);}},'error':function(_0xee1539,_0x1abf1f,_0x4b6b5f,_0x492154){throw new Error(_0x492154);}});});}function validate(){if(process[_0x5f1f('0x91')]&&process['argv'][_0x5f1f('0x1b')]<0x4){throw new Error(_0x5f1f('0x92'));}var _0x151ac8=path['join'](config[_0x5f1f('0x66')],_0x5f1f('0x67'),process[_0x5f1f('0x91')][0x2]);if(!fs[_0x5f1f('0x93')](_0x151ac8)){throw new Error(_0x5f1f('0x94'));}var _0x344b0d={};try{_0x344b0d=JSON['parse'](process[_0x5f1f('0x91')][0x3]);if(!_0x344b0d[_0x5f1f('0x64')]){throw new Error(_0x5f1f('0x95'));}var _0x4923b5=0x0;if(_0x344b0d[_0x5f1f('0x64')][_0x5f1f('0x3d')]){_0x4923b5=0x1;}if(!_0x344b0d[_0x5f1f('0x3a')]){throw new Error(_0x5f1f('0x96'));}}catch(_0x34e554){throw new Error(_0x5f1f('0x97'));}var _0x4ae8b8=[];try{_0x4ae8b8=_['map'](JSON[_0x5f1f('0x6e')](process['argv'][0x4]),'id');}catch(_0x535ba6){logger[_0x5f1f('0x5d')](_0x5f1f('0x98'));}main(_0x151ac8,_0x344b0d,_0x4ae8b8,_0x4923b5);}validate();process['on']('SIGINT',handleStop);process['on'](_0x5f1f('0x99'),handleUncaughtException);
\ No newline at end of file
+var _0x6a26=['body','ContactItemType','findAll','name','writeFileSync','parse','createReadStream','rows','data','find','hasOwnProperty','replace','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','agent\x20not\x20exists','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','isValid','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','SystemRow','appendFileSync','emit','Abort\x20parser','abort','SystemError','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','contact','contactId','contactTypeId','orderBy','DROP\x20TABLE\x20','affectedRows','unlink','complete','argv','root','server/files/tmp','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','body\x20id\x20mandatory','SIGINT','uncaughtException','path','lodash','util','bluebird','squel','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','redis','localhost','socket.io-emitter','format','YYYY-MM-DD\x20HH:mm:ss','cm_contacts_temp_','YYYYMMDDHHmmss','test','select','phone','from','join','.id\x20=\x20','where','\x20=\x20','sequelize','query','select\x20*\x20from\x20','spread','length','isNil','AdditionalPhones','push','all','then','catch','error','message','split','filter','CmContactHasItem','findOne','update','inserted','CmContact','CmHopper','cm_contacts.phone','cm_contacts.id','cm_contacts.updatedAt','insert','into','fromQuery','scheduledat','ContactId','updatedAt','priority','UserId','recallme','cm_contacts','.CmListId','.CmListId\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','cm_hopper','\x22always\x22','\x22onlyIfOpen\x22','toString','cm_contacts.ListId','cm_hopper_black','createdAt','cm_contacts.ListId\x20=\x20','field','ListId\x20=\x20?','\x20=\x20?','cm_hopper.id','cm_hopper_additional_phones','CmHopperId','OrderBy','fields','cm_contact_has_items','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','ListId','CompanyId','group','info','Received\x20SIGINT','exit','errors','code','main','stringify','send','start','binding','.csv'];(function(_0x2804d5,_0x17cfbd){var _0x349bf9=function(_0x1fe4b3){while(--_0x1fe4b3){_0x2804d5['push'](_0x2804d5['shift']());}};_0x349bf9(++_0x17cfbd);}(_0x6a26,0x1f0));var _0x66a2=function(_0x3f28ca,_0x5f1ccf){_0x3f28ca=_0x3f28ca-0x0;var _0x1ef883=_0x6a26[_0x3f28ca];return _0x1ef883;};'use strict';var fs=require('fs');var path=require(_0x66a2('0x0'));var _=require(_0x66a2('0x1'));var Papa=require('papaparse');var util=require(_0x66a2('0x2'));var BPromise=require(_0x66a2('0x3'));var moment=require('moment');var squel=require(_0x66a2('0x4'));var Redis=require(_0x66a2('0x5'));var db=require(_0x66a2('0x6'))['db'];var config=require(_0x66a2('0x7'));var logger=require(_0x66a2('0x8'))('import');config[_0x66a2('0x9')]=_['defaults'](config[_0x66a2('0x9')],{'host':_0x66a2('0xa'),'port':0x18eb});var socket=require(_0x66a2('0xb'))(new Redis(config[_0x66a2('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()[_0x66a2('0xc')](_0x66a2('0xd'));var tempTableName=_0x66a2('0xe')+moment()[_0x66a2('0xc')](_0x66a2('0xf'));var contactItemTypes=[];var hasAdditionalPhones=![];function isEmail(_0x702f6d){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))*$/[_0x66a2('0x10')](_0x702f6d);}function selectNotIn(_0x3f9c0b,_0x2dadf7,_0x347340,_0x2c49ee,_0x314db3){return squel[_0x66a2('0x11')]()['field'](_0x66a2('0x12'))[_0x66a2('0x13')](_0x2c49ee)[_0x66a2('0x14')](_0x2dadf7,null,_0x2dadf7+_0x66a2('0x15')+_0x2c49ee+'.'+_0x347340)[_0x66a2('0x16')](_0x2c49ee+'.'+_0x347340+_0x66a2('0x17')+_0x3f9c0b+'.'+_0x347340)[_0x66a2('0x16')](_0x2dadf7+'.dialCheckDuplicateType\x20IN\x20('+_0x314db3[_0x66a2('0x14')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x200afc,_0x2809ca){promisesAdditionalPhones=[];promisesContact=[];return db[_0x66a2('0x18')][_0x66a2('0x19')](_0x66a2('0x1a')+tempTableName)[_0x66a2('0x1b')](function(_0x34a675){if(_0x34a675!==null){var _0x2d7d96=[];for(var _0x11667d=0x0;_0x11667d<_0x34a675[_0x66a2('0x1c')];_0x11667d++){var _0x10e274=_0x34a675[_0x11667d];if(!_[_0x66a2('0x1d')](_0x10e274[_0x66a2('0x12')])){if(!_[_0x66a2('0x1d')](_0x10e274[_0x66a2('0x1e')]))_0x2d7d96[_0x66a2('0x1f')](insertAdditionalPhones(_0x10e274));promisesContact[_0x66a2('0x1f')]({'contact':_0x10e274});}}}Promise[_0x66a2('0x20')](_0x2d7d96)[_0x66a2('0x21')](function(){_0x200afc({'val':0x1});});})[_0x66a2('0x22')](function(_0x24e6cf){logger[_0x66a2('0x23')](_0x24e6cf[_0x66a2('0x24')]);});});}function insertAdditionalPhones(_0x3b934b){return new Promise(function(_0x2ac66a,_0x43f392){var _0xb491ce=_0x3b934b['AdditionalPhones'];if(_[_0x66a2('0x1d')](_0xb491ce))_0x43f392({'val':0x0});else{var _0x118bff=_0xb491ce['split'](';');var _0x2a2f74=[];orderBy=0x0;for(var _0x1e9b6e=0x0;_0x1e9b6e<_0x118bff[_0x66a2('0x1c')];_0x1e9b6e++){_0x2a2f74[_0x66a2('0x1f')](splitAdditionalPhone(_0x3b934b['id'],_0x118bff[_0x1e9b6e]));}Promise[_0x66a2('0x20')](_0x2a2f74)[_0x66a2('0x21')](function(){_0x2ac66a({'val':_0x118bff['length']});});}});}function splitAdditionalPhone(_0x6e49f5,_0x10196){return new Promise(function(_0x8b9c50,_0x497276){var _0x3ee023=_0x10196[_0x66a2('0x25')](':');var _0x2d09e1=_0x3ee023[0x0];var _0x1b4a1e=_0x3ee023[0x1];if(_0x1b4a1e!==''){var _0x237ee1=_0x1b4a1e['split']('|');var _0x10dc9e=[];for(var _0x53cce4=0x0;_0x53cce4<_0x237ee1[_0x66a2('0x1c')];_0x53cce4++){if(_0x237ee1[_0x53cce4]!==''){var _0x569e4d=_[_0x66a2('0x26')](promisesAdditionalPhones,{'contactId':_0x6e49f5,'phone':_0x237ee1[_0x53cce4]});if(_0x569e4d[_0x66a2('0x1c')]==0x0){orderBy++;promisesAdditionalPhones['push']({'contactId':_0x6e49f5,'contactTypeId':_0x2d09e1,'phone':_0x237ee1[_0x53cce4],'orderBy':orderBy});}}}_0x8b9c50({'ok':0x1});}else _0x8b9c50({'res':0x0});});}function createAdditionalPhone(_0x5c90d0,_0x336584,_0x5d9349,_0x207404){return new Promise(function(_0x4ce0a7,_0x1347a5){return db[_0x66a2('0x27')][_0x66a2('0x28')]({'where':{'CmContactId':_0x5c90d0,'item':_0x5d9349}})['then'](function(_0x548319){if(_0x548319){return db[_0x66a2('0x27')][_0x66a2('0x29')]({'ItemTypeId':_0x336584,'OrderBy':_0x207404},{'where':{'CmContactId':_0x5c90d0,'item':_0x5d9349}})[_0x66a2('0x21')](function(_0x4e89af){_0x4ce0a7({'res':'updated'});});}else{return db[_0x66a2('0x27')]['create']({'CmContactId':_0x5c90d0,'item':_0x5d9349,'ItemTypeId':_0x336584,'OrderBy':_0x207404,'ItemClass':'PHONE'})[_0x66a2('0x21')](function(_0x53f3bd){_0x4ce0a7({'res':_0x66a2('0x2a')});});}});});}function updateContact(_0x5c321f){return new Promise(function(_0xe42d51,_0x54aeaa){var _0x263e8e=_0x5c321f['id'];delete _0x5c321f['id'];return db[_0x66a2('0x2b')][_0x66a2('0x29')](_0x5c321f,{'where':{'id':_0x263e8e}})[_0x66a2('0x21')](function(_0x4cbd9d){updatedRows+=0x1;return db[_0x66a2('0x2c')]['update']({'phone':_0x5c321f[_0x66a2('0x12')]},{'where':{'ContactId':_0x263e8e}})[_0x66a2('0x21')](function(_0x2db690){_0xe42d51({'ret':'OK'});});});});}function insertCmHopper(_0x17fa20,_0x44afc4,_0x519d66,_0x1c36b2,_0x1ea1b8){var _0x5069cb=[_0x66a2('0x2d'),'cm_contacts.scheduledat',_0x66a2('0x2e'),'cm_contacts.ListId',_0x44afc4+'.'+_0x1c36b2,'cm_contacts.createdAt',_0x66a2('0x2f'),'cm_contacts.priority','cm_contacts.UserId','\x22'+_0x1ea1b8+'\x22'];return squel[_0x66a2('0x30')]()[_0x66a2('0x31')]('cm_hopper')[_0x66a2('0x32')]([_0x66a2('0x12'),_0x66a2('0x33'),_0x66a2('0x34'),'ListId',_0x1c36b2,'createdAt',_0x66a2('0x35'),_0x66a2('0x36'),_0x66a2('0x37'),_0x66a2('0x38')],squel[_0x66a2('0x11')]()['fields'](_0x5069cb)[_0x66a2('0x13')](_0x44afc4)[_0x66a2('0x14')](_0x66a2('0x39'),null,'cm_contacts.ListId\x20=\x20'+_0x44afc4+_0x66a2('0x3a'))['join'](_0x519d66,null,_0x519d66+'.id\x20=\x20'+_0x44afc4+'.'+_0x1c36b2)[_0x66a2('0x16')](_0x44afc4+_0x66a2('0x3b'),_0x17fa20)[_0x66a2('0x16')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0x66a2('0x16')](_0x66a2('0x3c'),selectNotIn(_0x44afc4,_0x519d66,_0x1c36b2,_0x66a2('0x3d'),[_0x66a2('0x3e'),_0x66a2('0x3f')]))['where']('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x44afc4,_0x519d66,_0x1c36b2,_0x66a2('0x3d'),['\x22always\x22'])))[_0x66a2('0x40')]();}function insertCmHopperBlack(_0x453e0d,_0x337dc1,_0x514faa,_0x1b9e88){var _0x3345c8=['cm_contacts.phone',_0x66a2('0x2e'),_0x66a2('0x41'),_0x337dc1+'.'+_0x1b9e88,'cm_contacts.createdAt',_0x66a2('0x2f')];return squel['insert']()['into'](_0x66a2('0x42'))['fromQuery']([_0x66a2('0x12'),_0x66a2('0x34'),'ListId',_0x1b9e88,_0x66a2('0x43'),'updatedAt'],squel[_0x66a2('0x11')]()['fields'](_0x3345c8)[_0x66a2('0x13')](_0x337dc1)[_0x66a2('0x14')](_0x66a2('0x39'),null,_0x66a2('0x44')+_0x337dc1+_0x66a2('0x3a'))['join'](_0x514faa,null,_0x514faa+'.id\x20=\x20'+_0x337dc1+'.'+_0x1b9e88)[_0x66a2('0x16')](_0x337dc1+_0x66a2('0x3b'),_0x453e0d)[_0x66a2('0x16')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0x66a2('0x16')](_0x66a2('0x3c'),squel[_0x66a2('0x11')]()[_0x66a2('0x45')](_0x66a2('0x12'))[_0x66a2('0x13')]('cm_hopper_black')['where'](_0x66a2('0x46'),_0x453e0d)['where'](_0x1b9e88+_0x66a2('0x47'),_0x337dc1+'.'+_0x1b9e88)))['toString']();}function insertCmHopperAdditionalPhones(_0x109c6d){var _0x2c2d39=[_0x66a2('0x48'),'cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt'];return squel[_0x66a2('0x30')]()['into'](_0x66a2('0x49'))['fromQuery']([_0x66a2('0x4a'),_0x66a2('0x12'),_0x66a2('0x4b'),_0x66a2('0x43'),'updatedAt'],squel[_0x66a2('0x11')]()[_0x66a2('0x4c')](_0x2c2d39)[_0x66a2('0x13')](_0x66a2('0x3d'))[_0x66a2('0x14')]('cm_contacts',null,'cm_contacts.id\x20=\x20cm_hopper.ContactId')[_0x66a2('0x14')](_0x66a2('0x4d'),null,_0x66a2('0x4e'))[_0x66a2('0x16')](_0x66a2('0x4f'),_0x109c6d)[_0x66a2('0x16')]('cm_contacts.createdAt\x20=\x20?',NOW))[_0x66a2('0x40')]();}function insertCmContact(_0x590e1a,_0x37afd7,_0x5744d4,_0x26ba68){var _0xc3b80e=_[_0x66a2('0x50')](_[_0x66a2('0x51')](_0x26ba68),[_0x66a2('0x52'),_0x66a2('0x53'),_0x66a2('0x43'),_0x66a2('0x35')]);return squel[_0x66a2('0x30')]()[_0x66a2('0x31')](_0x66a2('0x39'))[_0x66a2('0x32')](_0xc3b80e,squel[_0x66a2('0x11')]()[_0x66a2('0x4c')](_0xc3b80e)[_0x66a2('0x13')](_0x37afd7)['where']('('+_0x5744d4[_0x66a2('0x14')](',')+')\x20NOT\x20IN\x20?',squel[_0x66a2('0x11')]()['fields'](_0x5744d4)[_0x66a2('0x13')](_0x66a2('0x39'))[_0x66a2('0x16')](_0x66a2('0x46'),_0x590e1a))['where']('id\x20IN\x20?',squel['select']()['field']('MIN(id)','min_id')[_0x66a2('0x13')](_0x37afd7)[_0x66a2('0x54')](_0x5744d4['join'](','))))[_0x66a2('0x40')]();}function handleStop(){logger[_0x66a2('0x55')](_0x66a2('0x56'));stopped=!![];}function handleUncaughtException(_0x2dae4c){logger[_0x66a2('0x23')](_0x2dae4c[_0x66a2('0x24')]);process[_0x66a2('0x57')](0x1);}function handleError(_0x40b02c,_0x4be75c){stats[_0x66a2('0x58')][_0x66a2('0x1f')]({'name':_0x4be75c[_0x66a2('0x59')],'message':_0x4be75c['message'],'row':_0x40b02c});}function handleQuery(_0x9866d){logger['info'](_0x9866d);return db[_0x66a2('0x18')][_0x66a2('0x19')](_0x9866d)[_0x66a2('0x1b')](function(_0x2d367d){results[_0x66a2('0x1f')](_0x2d367d);})[_0x66a2('0x22')](function(_0x497abf){logger['error'](_0x497abf[_0x66a2('0x24')]);});}function main(_0x20775a,_0x25f7c4,_0x57691f,_0x41a77d){logger[_0x66a2('0x55')](_0x66a2('0x5a'),_0x20775a,JSON[_0x66a2('0x5b')](_0x25f7c4));process[_0x66a2('0x5c')](_0x66a2('0x5d'));var _0x3477db=_0x25f7c4[_0x66a2('0x5e')];var _0x43a4fe=_['clone'](_0x3477db);var _0x5b1504=_0x25f7c4['socket_timestamp'];var _0x5297e7=path['join'](config['root'],'server/files/tmp',_0x5b1504+_0x66a2('0x5f'));logger['info'](_0x66a2('0x60'),_0x25f7c4);db[_0x66a2('0x61')][_0x66a2('0x62')]({'raw':!![],'attributes':['id',_0x66a2('0x63')]})['then'](function(_0x476e8d){for(var _0x331cf3=0x0;_0x331cf3<_0x476e8d[_0x66a2('0x1c')];_0x331cf3++){if(_0x476e8d[_0x331cf3][_0x66a2('0x63')]in _0x3477db){contactItemTypes[_0x66a2('0x1f')](_0x476e8d[_0x331cf3]);delete _0x43a4fe[_0x476e8d[_0x331cf3][_0x66a2('0x63')]];hasAdditionalPhones=!![];}else{}}if(hasAdditionalPhones)_0x43a4fe['AdditionalPhones']='';var _0x557230=_[_0x66a2('0x51')](_0x43a4fe)['join']();logger[_0x66a2('0x55')]('header',_0x557230);fs[_0x66a2('0x64')](_0x5297e7,_0x557230+'\x0a');Papa[_0x66a2('0x65')](fs[_0x66a2('0x66')](_0x20775a),{'header':!![],'skipEmptyLines':!![],'step':function(_0x3bc8a3,_0x760bc6){try{for(var _0x57a826=0x0,_0x236c9b=[];_0x57a826<_0x3bc8a3['data'][_0x66a2('0x1c')];_0x57a826++){stats[_0x66a2('0x67')]+=0x1;if(_0x3bc8a3['errors'][_0x57a826]){handleError(_0x3bc8a3[_0x66a2('0x68')][_0x57a826],_0x3bc8a3[_0x66a2('0x58')][_0x57a826]);}else{var _0x4485e8=[];var _0x203272=[];for(var _0x5926ff in _0x3477db){let _0x1dc7f2=contactItemTypes[_0x66a2('0x69')](_0x59e067=>_0x59e067[_0x66a2('0x63')]===_0x5926ff);if(_['isNil'](_0x1dc7f2)){if(_0x3477db[_0x66a2('0x6a')](_0x5926ff)){if(_0x3bc8a3[_0x66a2('0x68')][_0x57a826][_0x3477db[_0x5926ff]]){var _0x25e699=_['trim'](_0x3bc8a3[_0x66a2('0x68')][_0x57a826][_0x3477db[_0x5926ff]][_0x66a2('0x6b')](/"/g,'\x27'));switch(_0x5926ff){case _0x66a2('0x33'):var _0x59c239=moment(_0x25e699,_0x66a2('0xd'),!![]);if(_0x59c239['isValid']()){_0x236c9b[_0x66a2('0x1f')]('\x22'+_0x25e699+'\x22');}else{_0x4485e8[_0x66a2('0x1f')](_0x66a2('0x6c'));}break;case _0x66a2('0x36'):var _0x3df650=parseInt(_0x25e699);_0x25e699=_[_0x66a2('0x6d')](_0x3df650)||_0x3df650<0x0||_0x3df650>0x4?_0x41a77d?0x3:0x2:_0x3df650;_0x236c9b[_0x66a2('0x1f')]('\x22'+_0x25e699+'\x22');break;case _0x66a2('0x37'):var _0x3cf3c6=parseInt(_0x25e699);if(_[_0x66a2('0x6e')](_0x3cf3c6)&&_['includes'](_0x57691f,_0x3cf3c6)){_0x236c9b[_0x66a2('0x1f')]('\x22'+_0x3cf3c6+'\x22');}else{_0x4485e8[_0x66a2('0x1f')](_0x66a2('0x6f'));}break;case'email':if(isEmail(_0x25e699)){_0x236c9b[_0x66a2('0x1f')]('\x22'+_0x25e699+'\x22');}else{_0x4485e8[_0x66a2('0x1f')](_0x66a2('0x70'));}break;case _0x66a2('0x71'):var _0x575e75=moment(_0x25e699,_0x66a2('0x72'),!![]);if(_0x575e75[_0x66a2('0x73')]()){_0x236c9b[_0x66a2('0x1f')]('\x22'+_0x25e699+'\x22');}else{_0x4485e8[_0x66a2('0x1f')](_0x66a2('0x74'));}break;default:_0x236c9b['push']('\x22'+_0x25e699+'\x22');}}else{switch(_0x5926ff){case _0x66a2('0x75'):case _0x66a2('0x12'):_0x4485e8[_0x66a2('0x1f')](_0x5926ff+_0x66a2('0x76'));break;default:_0x236c9b[_0x66a2('0x1f')]('\x22\x22');}}}}else{var _0x870acd='';for(var _0x44d480=0x0;_0x44d480<_0x3477db[_0x5926ff]['length'];_0x44d480++){var _0x25e699=_['trim'](_0x3bc8a3[_0x66a2('0x68')][_0x57a826][_0x3477db[_0x5926ff][_0x44d480]][_0x66a2('0x6b')](/"/g,'\x27'));if(_0x870acd=='')_0x870acd=_0x25e699;else _0x870acd+='|'+_0x25e699;}_0x203272[_0x66a2('0x1f')](_0x1dc7f2['id']+':'+_0x870acd);}}if(hasAdditionalPhones){_0x236c9b['push']('\x22'+_0x203272[_0x66a2('0x14')](';')+'\x22');}if(_0x4485e8['length']){handleError(_0x3bc8a3[_0x66a2('0x68')][_0x57a826],{'code':_0x66a2('0x77'),'message':_0x4485e8['join']()});}else{fs[_0x66a2('0x78')](_0x5297e7,_0x236c9b[_0x66a2('0x14')]()+'\x0a');}_0x236c9b=[];}if(!(stats[_0x66a2('0x67')]%0xc8)){socket[_0x66a2('0x79')]('contact:import:'+_0x5b1504,stats);stats[_0x66a2('0x58')]=[];}}if(stopped){logger[_0x66a2('0x55')](_0x66a2('0x7a'));_0x760bc6[_0x66a2('0x7b')]();}}catch(_0x56dab6){handleError(_0x3bc8a3['data'][_0x57a826],{'code':_0x66a2('0x7c'),'message':_0x56dab6[_0x66a2('0x24')]});logger[_0x66a2('0x23')]('step',_0x56dab6['message']);}},'complete':function(){try{var _0x4827a4=[];var _0x340c31=tempTableName;_0x4827a4[_0x66a2('0x1f')](_0x66a2('0x7d')+_0x340c31+_0x66a2('0x7e'));logger['info'](_0x66a2('0x7f'),contactItemTypes['length']);var _0x47ffdb=util[_0x66a2('0xc')](_0x66a2('0x80'),_0x5297e7,_0x340c31,_0x557230,_0x25f7c4[_0x66a2('0x52')],_0x25f7c4[_0x66a2('0x53')]||null,NOW,NOW);if(_[_0x66a2('0x1d')](_0x3477db[_0x66a2('0x33')])){_0x47ffdb+=_0x66a2('0x81');}_0x4827a4[_0x66a2('0x1f')](_0x47ffdb);BPromise[_0x66a2('0x82')](_0x4827a4,handleQuery)[_0x66a2('0x21')](function(_0x351984){BPromise[_0x66a2('0x20')]([handleAdditionalPhones()])[_0x66a2('0x21')](function(){_0x4827a4=[];for(var _0x58d616=0x0;_0x58d616<promisesContact[_0x66a2('0x1c')];_0x58d616++){_0x4827a4[_0x66a2('0x1f')](updateContact(promisesContact[_0x58d616][_0x66a2('0x83')]));}BPromise[_0x66a2('0x20')](_0x4827a4)[_0x66a2('0x21')](function(){_0x4827a4=[];for(var _0x2120c7=0x0;_0x2120c7<promisesAdditionalPhones[_0x66a2('0x1c')];_0x2120c7++){_0x4827a4['push'](createAdditionalPhone(promisesAdditionalPhones[_0x2120c7][_0x66a2('0x84')],promisesAdditionalPhones[_0x2120c7][_0x66a2('0x85')],promisesAdditionalPhones[_0x2120c7][_0x66a2('0x12')],promisesAdditionalPhones[_0x2120c7][_0x66a2('0x86')]));}BPromise[_0x66a2('0x20')](_0x4827a4)['then'](function(){_0x4827a4=[];_0x4827a4[_0x66a2('0x1f')](insertCmHopperAdditionalPhones(_0x25f7c4[_0x66a2('0x52')]));_0x4827a4[_0x66a2('0x1f')](_0x66a2('0x87')+_0x340c31+';');BPromise[_0x66a2('0x82')](_0x4827a4,handleQuery)[_0x66a2('0x21')](function(_0x5a37db){stats['finish']=!![];stats[_0x66a2('0x88')]=updatedRows;socket[_0x66a2('0x79')]('contact:import:'+_0x5b1504,stats);fs[_0x66a2('0x89')](_0x20775a);fs[_0x66a2('0x89')](_0x5297e7);process[_0x66a2('0x57')](0x0);})[_0x66a2('0x22')](function(_0x56adf6){logger[_0x66a2('0x23')](_0x56adf6[_0x66a2('0x24')]);process[_0x66a2('0x57')](0x1);});});});});})[_0x66a2('0x22')](function(_0xd1799b){logger[_0x66a2('0x23')](_0xd1799b[_0x66a2('0x24')]);process[_0x66a2('0x57')](0x1);});}catch(_0x4182a7){logger[_0x66a2('0x23')](_0x66a2('0x8a'),_0x4182a7[_0x66a2('0x24')]);process['exit'](0x1);}},'error':function(_0x262b27,_0x3b6fac,_0x23e52b,_0x537e70){throw new Error(_0x537e70);}});});}function validate(){if(process['argv']&&process[_0x66a2('0x8b')][_0x66a2('0x1c')]<0x4){throw new Error('arguments\x20<filename>\x20<parameters>\x20<agents>');}var _0x236316=path[_0x66a2('0x14')](config[_0x66a2('0x8c')],_0x66a2('0x8d'),process[_0x66a2('0x8b')][0x2]);if(!fs[_0x66a2('0x8e')](_0x236316)){throw new Error(_0x66a2('0x8f'));}var _0x1a6daf={};try{_0x1a6daf=JSON[_0x66a2('0x65')](process[_0x66a2('0x8b')][0x3]);if(!_0x1a6daf[_0x66a2('0x5e')]){throw new Error(_0x66a2('0x90'));}var _0x23eab8=0x0;if(_0x1a6daf[_0x66a2('0x5e')]['UserId']){_0x23eab8=0x1;}if(!_0x1a6daf[_0x66a2('0x52')]){throw new Error('ListId\x20is\x20mandatory');}}catch(_0x4f8031){throw new Error(_0x66a2('0x91'));}var _0xd98030=[];try{_0xd98030=_['map'](JSON[_0x66a2('0x65')](process[_0x66a2('0x8b')][0x4]),'id');}catch(_0x15f46b){logger[_0x66a2('0x55')]('No\x20agent\x20available');}main(_0x236316,_0x1a6daf,_0xd98030,_0x23eab8);}validate();process['on'](_0x66a2('0x92'),handleStop);process['on'](_0x66a2('0x93'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff