// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x4910=['each','unlink','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','binding\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','SIGINT','path','lodash','papaparse','bluebird','moment','squel','ioredis','../../../mysqldb','../../../config/logger','import','redis','defaults','socket.io-emitter','format','YYYY-MM-DD\x20HH:mm:ss','cm_contacts_temp_','YYYYMMDDHHmmss','test','select','field','phone','from','.id\x20=\x20','\x20=\x20','join','sequelize','query','select\x20*\x20from\x20','spread','isNil','AdditionalPhones','push','all','then','error','length','split','filter','CmContactHasItem','findOne','update','updated','create','inserted','CmContact','CmHopper','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.createdAt','cm_contacts.updatedAt','cm_contacts.priority','insert','cm_hopper','scheduledat','ContactId','updatedAt','priority','UserId','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','where','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22always\x22','toString','cm_contacts.id','ListId','createdAt','cm_hopper_black','ListId\x20=\x20?','\x20=\x20?','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','into','cm_hopper_additional_phones','CmHopperId','OrderBy','cm_contact_has_items','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId','fromQuery',')\x20NOT\x20IN\x20?','id\x20IN\x20?','group','info','Received\x20SIGINT','message','exit','catch','main','stringify','start','binding','clone','root','server/files/tmp','body','ContactItemType','findAll','name','_description','header','parse','createReadStream','data','errors','find','hasOwnProperty','trim','replace','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','includes','agent\x20not\x20exists','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','itemTypeId','description','SystemRow','appendFileSync','rows','emit','contact:import:','Abort\x20parser','abort','SystemError','CIS\x20len',',\x20scheduledAt\x20=\x20NOW()','contactId','orderBy'];(function(_0x749c41,_0x814a97){var _0x193046=function(_0x5ba05c){while(--_0x5ba05c){_0x749c41['push'](_0x749c41['shift']());}};_0x193046(++_0x814a97);}(_0x4910,0x1d9));var _0x0491=function(_0x502c7d,_0x2f1285){_0x502c7d=_0x502c7d-0x0;var _0x30b7ed=_0x4910[_0x502c7d];return _0x30b7ed;};'use strict';var fs=require('fs');var path=require(_0x0491('0x0'));var _=require(_0x0491('0x1'));var Papa=require(_0x0491('0x2'));var util=require('util');var BPromise=require(_0x0491('0x3'));var moment=require(_0x0491('0x4'));var squel=require(_0x0491('0x5'));var Redis=require(_0x0491('0x6'));var db=require(_0x0491('0x7'))['db'];var config=require('../../../config/environment');var logger=require(_0x0491('0x8'))(_0x0491('0x9'));config[_0x0491('0xa')]=_[_0x0491('0xb')](config[_0x0491('0xa')],{'host':'localhost','port':0x18eb});var socket=require(_0x0491('0xc'))(new Redis(config[_0x0491('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()[_0x0491('0xd')](_0x0491('0xe'));var tempTableName=_0x0491('0xf')+moment()['format'](_0x0491('0x10'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];function isEmail(_0x51bd65){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))*$/[_0x0491('0x11')](_0x51bd65);}function selectNotIn(_0x1b57a1,_0x3ff9c6,_0x108308,_0x3b8318,_0x12ab48){return squel[_0x0491('0x12')]()[_0x0491('0x13')](_0x0491('0x14'))[_0x0491('0x15')](_0x3b8318)['join'](_0x3ff9c6,null,_0x3ff9c6+_0x0491('0x16')+_0x3b8318+'.'+_0x108308)['where'](_0x3b8318+'.'+_0x108308+_0x0491('0x17')+_0x1b57a1+'.'+_0x108308)['where'](_0x3ff9c6+'.dialCheckDuplicateType\x20IN\x20('+_0x12ab48[_0x0491('0x18')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x7ba36,_0x439f5c){promisesAdditionalPhones=[];promisesContact=[];return db[_0x0491('0x19')][_0x0491('0x1a')](_0x0491('0x1b')+tempTableName)[_0x0491('0x1c')](function(_0xbd94bd){if(_0xbd94bd!==null){var _0xf12423=[];for(var _0x1411a6=0x0;_0x1411a6<_0xbd94bd['length'];_0x1411a6++){var _0x410548=_0xbd94bd[_0x1411a6];if(!_[_0x0491('0x1d')](_0x410548[_0x0491('0x14')])){if(!_[_0x0491('0x1d')](_0x410548[_0x0491('0x1e')]))_0xf12423[_0x0491('0x1f')](insertAdditionalPhones(_0x410548));promisesContact['push']({'contact':_0x410548});}}}Promise[_0x0491('0x20')](_0xf12423)[_0x0491('0x21')](function(){_0x7ba36({'val':0x1});});})['catch'](function(_0x54be7f){logger[_0x0491('0x22')](_0x54be7f['message']);});});}function insertAdditionalPhones(_0x6f8139){return new Promise(function(_0x431782,_0x55dcb3){var _0x6141b9=_0x6f8139[_0x0491('0x1e')];if(_[_0x0491('0x1d')](_0x6141b9))_0x55dcb3({'val':0x0});else{var _0x291d40=_0x6141b9['split'](';');var _0x23146d=[];orderBy=0x0;for(var _0x358117=0x0;_0x358117<_0x291d40[_0x0491('0x23')];_0x358117++){_0x23146d['push'](splitAdditionalPhone(_0x6f8139['id'],_0x291d40[_0x358117]));}Promise[_0x0491('0x20')](_0x23146d)[_0x0491('0x21')](function(){_0x431782({'val':_0x291d40[_0x0491('0x23')]});});}});}function splitAdditionalPhone(_0x1934a0,_0x30ad41){return new Promise(function(_0xdda718,_0x207ff9){var _0x4ab232=_0x30ad41[_0x0491('0x24')](':');var _0x4a39f0=_0x4ab232[0x0];var _0xc0c021=_0x4ab232[0x1];if(_0xc0c021!==''){var _0x93bc14=_0xc0c021[_0x0491('0x24')]('|');var _0x54571a=[];for(var _0x12ebdb=0x0;_0x12ebdb<_0x93bc14[_0x0491('0x23')];_0x12ebdb++){if(_0x93bc14[_0x12ebdb]!==''){var _0x59beec=_[_0x0491('0x25')](promisesAdditionalPhones,{'contactId':_0x1934a0,'phone':_0x93bc14[_0x12ebdb]});if(_0x59beec[_0x0491('0x23')]==0x0){orderBy++;promisesAdditionalPhones[_0x0491('0x1f')]({'contactId':_0x1934a0,'contactTypeId':_0x4a39f0,'phone':_0x93bc14[_0x12ebdb],'orderBy':orderBy});}}}_0xdda718({'ok':0x1});}else _0xdda718({'res':0x0});});}function createAdditionalPhone(_0x2c3f39,_0x3ec059,_0x38b4b8,_0x15b80d){var _0x5c9ee2='';var _0x4fbeb8='';var _0x5daa56=_0x38b4b8['split']('§');_0x5c9ee2=_0x5daa56[0x0];if(_0x5daa56[_0x0491('0x23')]==0x2)_0x4fbeb8=_0x5daa56[0x1];return new Promise(function(_0x53f923,_0x46d432){return db[_0x0491('0x26')][_0x0491('0x27')]({'where':{'CmContactId':_0x2c3f39,'item':_0x5c9ee2}})[_0x0491('0x21')](function(_0x2e3223){if(_0x2e3223){return db[_0x0491('0x26')][_0x0491('0x28')]({'ItemTypeId':_0x3ec059,'description':_0x4fbeb8,'OrderBy':_0x15b80d},{'where':{'CmContactId':_0x2c3f39,'item':_0x5c9ee2}})['then'](function(_0x712f33){_0x53f923({'res':_0x0491('0x29')});});}else{return db[_0x0491('0x26')][_0x0491('0x2a')]({'CmContactId':_0x2c3f39,'item':_0x5c9ee2,'ItemTypeId':_0x3ec059,'description':_0x4fbeb8,'OrderBy':_0x15b80d,'ItemClass':'PHONE'})['then'](function(_0x58a20b){_0x53f923({'res':_0x0491('0x2b')});});}});});}function updateContact(_0x5ebccf){return new Promise(function(_0x2ad8b2,_0x434c1c){var _0x20d728=_0x5ebccf['id'];delete _0x5ebccf['id'];return db[_0x0491('0x2c')][_0x0491('0x28')](_0x5ebccf,{'where':{'id':_0x20d728}})[_0x0491('0x21')](function(_0x17b4ee){updatedRows+=0x1;return db[_0x0491('0x2d')]['update']({'phone':_0x5ebccf[_0x0491('0x14')]},{'where':{'ContactId':_0x20d728}})['then'](function(_0x1f24e9){_0x2ad8b2({'ret':'OK'});});});});}function insertCmHopper(_0x16ef85,_0x4bbffc,_0x20e036,_0x5a946c,_0x1d7460){var _0x2a6425=[_0x0491('0x2e'),_0x0491('0x2f'),'cm_contacts.id','cm_contacts.ListId',_0x4bbffc+'.'+_0x5a946c,_0x0491('0x30'),_0x0491('0x31'),_0x0491('0x32'),'cm_contacts.UserId','\x22'+_0x1d7460+'\x22'];return squel[_0x0491('0x33')]()['into'](_0x0491('0x34'))['fromQuery']([_0x0491('0x14'),_0x0491('0x35'),_0x0491('0x36'),'ListId',_0x5a946c,'createdAt',_0x0491('0x37'),_0x0491('0x38'),_0x0491('0x39'),'recallme'],squel['select']()[_0x0491('0x3a')](_0x2a6425)[_0x0491('0x15')](_0x4bbffc)[_0x0491('0x18')](_0x0491('0x3b'),null,_0x0491('0x3c')+_0x4bbffc+_0x0491('0x3d'))[_0x0491('0x18')](_0x20e036,null,_0x20e036+'.id\x20=\x20'+_0x4bbffc+'.'+_0x5a946c)[_0x0491('0x3e')](_0x4bbffc+_0x0491('0x3f'),_0x16ef85)['where'](_0x0491('0x40'),NOW)[_0x0491('0x3e')](_0x0491('0x41'),selectNotIn(_0x4bbffc,_0x20e036,_0x5a946c,_0x0491('0x34'),[_0x0491('0x42'),'\x22onlyIfOpen\x22']))[_0x0491('0x3e')](_0x0491('0x41'),selectNotIn(_0x4bbffc,_0x20e036,_0x5a946c,_0x0491('0x34'),[_0x0491('0x42')])))[_0x0491('0x43')]();}function insertCmHopperBlack(_0x6ef0a0,_0x49cf9,_0x1b6571,_0x20ead0){var _0x20adae=[_0x0491('0x2e'),_0x0491('0x44'),'cm_contacts.ListId',_0x49cf9+'.'+_0x20ead0,'cm_contacts.createdAt',_0x0491('0x31')];return squel['insert']()['into']('cm_hopper_black')['fromQuery']([_0x0491('0x14'),'ContactId',_0x0491('0x45'),_0x20ead0,_0x0491('0x46'),_0x0491('0x37')],squel['select']()[_0x0491('0x3a')](_0x20adae)['from'](_0x49cf9)[_0x0491('0x18')]('cm_contacts',null,_0x0491('0x3c')+_0x49cf9+_0x0491('0x3d'))[_0x0491('0x18')](_0x1b6571,null,_0x1b6571+_0x0491('0x16')+_0x49cf9+'.'+_0x20ead0)[_0x0491('0x3e')](_0x49cf9+_0x0491('0x3f'),_0x6ef0a0)[_0x0491('0x3e')](_0x0491('0x40'),NOW)[_0x0491('0x3e')](_0x0491('0x41'),squel[_0x0491('0x12')]()[_0x0491('0x13')](_0x0491('0x14'))['from'](_0x0491('0x47'))[_0x0491('0x3e')](_0x0491('0x48'),_0x6ef0a0)[_0x0491('0x3e')](_0x20ead0+_0x0491('0x49'),_0x49cf9+'.'+_0x20ead0)))[_0x0491('0x43')]();}function insertCmHopperAdditionalPhones(_0x48d193){var _0xdc7140=[_0x0491('0x4a'),_0x0491('0x4b'),_0x0491('0x4c'),'cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt'];return squel[_0x0491('0x33')]()[_0x0491('0x4d')](_0x0491('0x4e'))['fromQuery']([_0x0491('0x4f'),'phone',_0x0491('0x50'),'createdAt',_0x0491('0x37')],squel[_0x0491('0x12')]()[_0x0491('0x3a')](_0xdc7140)[_0x0491('0x15')](_0x0491('0x34'))['join'](_0x0491('0x3b'),null,'cm_contacts.id\x20=\x20cm_hopper.ContactId')['join'](_0x0491('0x51'),null,_0x0491('0x52'))[_0x0491('0x3e')](_0x0491('0x53'),_0x48d193)[_0x0491('0x3e')](_0x0491('0x40'),NOW))[_0x0491('0x43')]();}function insertCmContact(_0x3add97,_0x47fe72,_0xec5404,_0x31791c){var _0x276c4e=_[_0x0491('0x54')](_[_0x0491('0x55')](_0x31791c),['ListId',_0x0491('0x56'),_0x0491('0x46'),_0x0491('0x37')]);return squel[_0x0491('0x33')]()[_0x0491('0x4d')](_0x0491('0x3b'))[_0x0491('0x57')](_0x276c4e,squel[_0x0491('0x12')]()['fields'](_0x276c4e)[_0x0491('0x15')](_0x47fe72)[_0x0491('0x3e')]('('+_0xec5404[_0x0491('0x18')](',')+_0x0491('0x58'),squel[_0x0491('0x12')]()[_0x0491('0x3a')](_0xec5404)[_0x0491('0x15')](_0x0491('0x3b'))[_0x0491('0x3e')]('ListId\x20=\x20?',_0x3add97))[_0x0491('0x3e')](_0x0491('0x59'),squel[_0x0491('0x12')]()[_0x0491('0x13')]('MIN(id)','min_id')['from'](_0x47fe72)[_0x0491('0x5a')](_0xec5404[_0x0491('0x18')](','))))['toString']();}function handleStop(){logger[_0x0491('0x5b')](_0x0491('0x5c'));stopped=!![];}function handleUncaughtException(_0x4bb695){logger[_0x0491('0x22')](_0x4bb695[_0x0491('0x5d')]);process[_0x0491('0x5e')](0x1);}function handleError(_0x12dc2c,_0x1af724){stats['errors'][_0x0491('0x1f')]({'name':_0x1af724['code'],'message':_0x1af724['message'],'row':_0x12dc2c});}function handleQuery(_0x2ca08b){logger[_0x0491('0x5b')](_0x2ca08b);return db[_0x0491('0x19')]['query'](_0x2ca08b)[_0x0491('0x1c')](function(_0x185a20){results['push'](_0x185a20);})[_0x0491('0x5f')](function(_0x4c97b){logger[_0x0491('0x22')](_0x4c97b[_0x0491('0x5d')]);});}function main(_0x27e04c,_0x4c12e0,_0x41da4a,_0x4a93a5){logger['info'](_0x0491('0x60'),_0x27e04c,JSON[_0x0491('0x61')](_0x4c12e0));process['send'](_0x0491('0x62'));var _0x19b2da=_0x4c12e0[_0x0491('0x63')];var _0x3f41b1=_[_0x0491('0x64')](_0x19b2da);var _0x430e37=_0x4c12e0['socket_timestamp'];var _0x2c41ec=path[_0x0491('0x18')](config[_0x0491('0x65')],_0x0491('0x66'),_0x430e37+'.csv');logger[_0x0491('0x5b')](_0x0491('0x67'),_0x4c12e0);db[_0x0491('0x68')][_0x0491('0x69')]({'raw':!![],'attributes':['id','name']})[_0x0491('0x21')](function(_0x442a97){for(var _0x2652d9=0x0;_0x2652d9<_0x442a97[_0x0491('0x23')];_0x2652d9++){if(_0x442a97[_0x2652d9][_0x0491('0x6a')]in _0x19b2da){contactItemTypes['push'](_0x442a97[_0x2652d9]);delete _0x3f41b1[_0x442a97[_0x2652d9]['name']];hasAdditionalPhones=!![];}for(var _0x526798 in _0x19b2da){if(_0x442a97[_0x2652d9][_0x0491('0x6a')]+_0x0491('0x6b')===_0x526798){phoneDescriptions[_0x0491('0x1f')]({'itemTypeId':_0x442a97[_0x2652d9]['id'],'description':_0x526798});delete _0x3f41b1[_0x526798];}}}if(hasAdditionalPhones)_0x3f41b1[_0x0491('0x1e')]='';var _0x4236e5=_[_0x0491('0x55')](_0x3f41b1)[_0x0491('0x18')]();logger['info'](_0x0491('0x6c'),_0x4236e5);fs['writeFileSync'](_0x2c41ec,_0x4236e5+'\x0a');Papa[_0x0491('0x6d')](fs[_0x0491('0x6e')](_0x27e04c),{'header':!![],'skipEmptyLines':!![],'step':function(_0x6f2731,_0xe4af61){try{for(var _0x35d4c0=0x0,_0x537256=[];_0x35d4c0<_0x6f2731[_0x0491('0x6f')][_0x0491('0x23')];_0x35d4c0++){stats['rows']+=0x1;if(_0x6f2731['errors'][_0x35d4c0]){handleError(_0x6f2731[_0x0491('0x6f')][_0x35d4c0],_0x6f2731[_0x0491('0x70')][_0x35d4c0]);}else{var _0x544d84=[];var _0x1cf948=[];var _0x55b92f={};for(var _0x395c23 in _0x19b2da){let _0x275224=contactItemTypes[_0x0491('0x71')](_0xd5aed4=>_0xd5aed4[_0x0491('0x6a')]===_0x395c23);let _0x50067b=contactItemTypes[_0x0491('0x71')](_0xe7f058=>_0xe7f058[_0x0491('0x6a')]+_0x0491('0x6b')===_0x395c23);if(_[_0x0491('0x1d')](_0x275224)&&_[_0x0491('0x1d')](_0x50067b)){if(_0x19b2da[_0x0491('0x72')](_0x395c23)){if(_0x6f2731[_0x0491('0x6f')][_0x35d4c0][_0x19b2da[_0x395c23]]){var _0x5afb42=_[_0x0491('0x73')](_0x6f2731[_0x0491('0x6f')][_0x35d4c0][_0x19b2da[_0x395c23]][_0x0491('0x74')](/"/g,'\x27'));switch(_0x395c23){case'scheduledat':var _0x3e0903=moment(_0x5afb42,_0x0491('0xe'),!![]);if(_0x3e0903[_0x0491('0x75')]()){_0x537256[_0x0491('0x1f')]('\x22'+_0x5afb42+'\x22');}else{_0x544d84[_0x0491('0x1f')](_0x0491('0x76'));}break;case _0x0491('0x38'):var _0x2aa4b3=parseInt(_0x5afb42);_0x5afb42=_[_0x0491('0x77')](_0x2aa4b3)||_0x2aa4b3<0x0||_0x2aa4b3>0x4?_0x4a93a5?0x3:0x2:_0x2aa4b3;_0x537256['push']('\x22'+_0x5afb42+'\x22');break;case _0x0491('0x39'):var _0x24899e=parseInt(_0x5afb42);if(_[_0x0491('0x78')](_0x24899e)&&_[_0x0491('0x79')](_0x41da4a,_0x24899e)){_0x537256[_0x0491('0x1f')]('\x22'+_0x24899e+'\x22');}else{_0x544d84[_0x0491('0x1f')](_0x0491('0x7a'));}break;case'email':if(isEmail(_0x5afb42)){_0x537256[_0x0491('0x1f')]('\x22'+_0x5afb42+'\x22');}else{_0x544d84[_0x0491('0x1f')](_0x0491('0x7b'));}break;case _0x0491('0x7c'):var _0x56d062=moment(_0x5afb42,_0x0491('0x7d'),!![]);if(_0x56d062[_0x0491('0x75')]()){_0x537256[_0x0491('0x1f')]('\x22'+_0x5afb42+'\x22');}else{_0x544d84['push'](_0x0491('0x7e'));}break;default:_0x537256['push']('\x22'+_0x5afb42+'\x22');}}else{switch(_0x395c23){case _0x0491('0x7f'):case _0x0491('0x14'):_0x544d84[_0x0491('0x1f')](_0x395c23+_0x0491('0x80'));break;default:_0x537256[_0x0491('0x1f')]('\x22\x22');}}}}else{var _0x4f8c61='';if(!_['isNil'](_0x275224)){if(!_0x55b92f['hasOwnProperty'](_0x275224['id'])){for(var _0x499671=0x0;_0x499671<_0x19b2da[_0x395c23][_0x0491('0x23')];_0x499671++){var _0x5afb42=_[_0x0491('0x73')](_0x6f2731['data'][_0x35d4c0][_0x19b2da[_0x395c23][_0x499671]][_0x0491('0x74')](/"/g,'\x27'));var _0x562ae9=phoneDescriptions[_0x0491('0x71')](_0x52feb7=>_0x52feb7[_0x0491('0x81')]===_0x275224['id']);if(!_[_0x0491('0x1d')](_0x562ae9)){var _0x21d22b=_[_0x0491('0x73')](_0x6f2731['data'][_0x35d4c0][_0x19b2da[_0x562ae9[_0x0491('0x82')]][0x0]][_0x0491('0x74')](/"/g,'\x27'));if(!_[_0x0491('0x1d')](_0x21d22b))_0x5afb42=_0x5afb42+'§'+_0x21d22b;}if(_0x4f8c61=='')_0x4f8c61=_0x5afb42;else _0x4f8c61+='|'+_0x5afb42;}_0x1cf948['push'](_0x275224['id']+':'+_0x4f8c61);_0x55b92f[_0x275224['id']]=0x1;}}}}if(hasAdditionalPhones){_0x537256[_0x0491('0x1f')]('\x22'+_0x1cf948[_0x0491('0x18')](';')+'\x22');}if(_0x544d84[_0x0491('0x23')]){handleError(_0x6f2731[_0x0491('0x6f')][_0x35d4c0],{'code':_0x0491('0x83'),'message':_0x544d84['join']()});}else{fs[_0x0491('0x84')](_0x2c41ec,_0x537256['join']()+'\x0a');}_0x537256=[];}if(!(stats[_0x0491('0x85')]%0xc8)){socket[_0x0491('0x86')](_0x0491('0x87')+_0x430e37,stats);stats['errors']=[];}}if(stopped){logger[_0x0491('0x5b')](_0x0491('0x88'));_0xe4af61[_0x0491('0x89')]();}}catch(_0x45acfb){handleError(_0x6f2731[_0x0491('0x6f')][_0x35d4c0],{'code':_0x0491('0x8a'),'message':_0x45acfb[_0x0491('0x5d')]});logger[_0x0491('0x22')]('step',_0x45acfb[_0x0491('0x5d')]);}},'complete':function(){try{var _0x393832=[];var _0x53a88b=tempTableName;_0x393832[_0x0491('0x1f')]('CREATE\x20TABLE\x20'+_0x53a88b+'\x20LIKE\x20cm_contacts;');logger['info'](_0x0491('0x8b'),contactItemTypes[_0x0491('0x23')]);var _0x3b07c2=util[_0x0491('0xd')]('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',_0x2c41ec,_0x53a88b,_0x4236e5,_0x4c12e0['ListId'],_0x4c12e0[_0x0491('0x56')]||null,NOW,NOW);if(_[_0x0491('0x1d')](_0x19b2da[_0x0491('0x35')])){_0x3b07c2+=_0x0491('0x8c');}_0x393832[_0x0491('0x1f')](_0x3b07c2);BPromise['each'](_0x393832,handleQuery)[_0x0491('0x21')](function(_0xf52e3b){BPromise[_0x0491('0x20')]([handleAdditionalPhones()])[_0x0491('0x21')](function(){_0x393832=[];for(var _0x52ea4d=0x0;_0x52ea4d<promisesContact[_0x0491('0x23')];_0x52ea4d++){_0x393832['push'](updateContact(promisesContact[_0x52ea4d]['contact']));}BPromise['all'](_0x393832)['then'](function(){_0x393832=[];for(var _0x5b91f5=0x0;_0x5b91f5<promisesAdditionalPhones[_0x0491('0x23')];_0x5b91f5++){_0x393832[_0x0491('0x1f')](createAdditionalPhone(promisesAdditionalPhones[_0x5b91f5][_0x0491('0x8d')],promisesAdditionalPhones[_0x5b91f5]['contactTypeId'],promisesAdditionalPhones[_0x5b91f5][_0x0491('0x14')],promisesAdditionalPhones[_0x5b91f5][_0x0491('0x8e')]));}BPromise[_0x0491('0x20')](_0x393832)[_0x0491('0x21')](function(){_0x393832=[];_0x393832[_0x0491('0x1f')](insertCmHopperAdditionalPhones(_0x4c12e0['ListId']));_0x393832['push']('DROP\x20TABLE\x20'+_0x53a88b+';');BPromise[_0x0491('0x8f')](_0x393832,handleQuery)['then'](function(_0x22309b){stats['finish']=!![];stats['affectedRows']=updatedRows;socket[_0x0491('0x86')]('contact:import:'+_0x430e37,stats);fs[_0x0491('0x90')](_0x27e04c);fs[_0x0491('0x90')](_0x2c41ec);process['exit'](0x0);})['catch'](function(_0x437a50){logger[_0x0491('0x22')](_0x437a50['message']);process[_0x0491('0x5e')](0x1);});});});});})['catch'](function(_0x4cd686){logger[_0x0491('0x22')](_0x4cd686[_0x0491('0x5d')]);process['exit'](0x1);});}catch(_0xde2860){logger['error'](_0x0491('0x91'),_0xde2860['message']);process[_0x0491('0x5e')](0x1);}},'error':function(_0x37aa1c,_0x35fd25,_0x276896,_0x46320a){throw new Error(_0x46320a);}});});}function validate(){if(process[_0x0491('0x92')]&&process[_0x0491('0x92')]['length']<0x4){throw new Error(_0x0491('0x93'));}var _0x3e51d9=path[_0x0491('0x18')](config['root'],'server/files/tmp',process[_0x0491('0x92')][0x2]);if(!fs[_0x0491('0x94')](_0x3e51d9)){throw new Error('file\x20doesn\x27t\x20exists');}var _0x4e0007={};try{_0x4e0007=JSON[_0x0491('0x6d')](process['argv'][0x3]);if(!_0x4e0007[_0x0491('0x63')]){throw new Error(_0x0491('0x95'));}var _0x58881e=0x0;if(_0x4e0007[_0x0491('0x63')][_0x0491('0x39')]){_0x58881e=0x1;}if(!_0x4e0007[_0x0491('0x45')]){throw new Error(_0x0491('0x96'));}}catch(_0x3a3cea){throw new Error(_0x0491('0x97'));}var _0x58613d=[];try{_0x58613d=_[_0x0491('0x98')](JSON[_0x0491('0x6d')](process[_0x0491('0x92')][0x4]),'id');}catch(_0xc74738){logger[_0x0491('0x5b')]('No\x20agent\x20available');}main(_0x3e51d9,_0x4e0007,_0x58613d,_0x58881e);}validate();process['on'](_0x0491('0x99'),handleStop);process['on']('uncaughtException',handleUncaughtException);
\ No newline at end of file
+var _0x45c2=['cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','cm_hopper','\x22always\x22','\x22onlyIfOpen\x22','cm_contacts.createdAt','insert','cm_hopper_black','field','\x20=\x20?','toString','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','fromQuery','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',')\x20NOT\x20IN\x20?','ListId\x20=\x20?','MIN(id)','min_id','group','Received\x20SIGINT','exit','errors','code','info','query','stringify','send','start','binding','socket_timestamp','root','server/files/tmp','.csv','body','findAll','name','_description','header','parse','createReadStream','data','rows','find','hasOwnProperty','trim','replace','isValid','priority','isNaN','UserId','isNumber','includes','agent\x20not\x20exists','email','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','itemTypeId','description','SystemRow','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','CompanyId',',\x20scheduledAt\x20=\x20NOW()','contact','contactId','contactTypeId','orderBy','DROP\x20TABLE\x20','each','affectedRows','unlink','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','body\x20id\x20mandatory','No\x20agent\x20available','SIGINT','uncaughtException','path','lodash','papaparse','util','moment','squel','ioredis','../../../config/environment','../../../config/logger','import','redis','defaults','localhost','socket.io-emitter','format','YYYY-MM-DD\x20HH:mm:ss','cm_contacts_temp_','YYYYMMDDHHmmss','test','select','phone','from','join','.id\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','sequelize','select\x20*\x20from\x20','spread','length','isNil','AdditionalPhones','push','all','catch','error','message','then','split','CmContactHasItem','updated','create','PHONE','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.updatedAt','cm_contacts.priority','into','scheduledat','ContactId','ListId','createdAt','updatedAt','recallme','fields'];(function(_0x1a61c1,_0x2f064d){var _0x2240bf=function(_0x52c173){while(--_0x52c173){_0x1a61c1['push'](_0x1a61c1['shift']());}};_0x2240bf(++_0x2f064d);}(_0x45c2,0x68));var _0x245c=function(_0x250f95,_0x5a5728){_0x250f95=_0x250f95-0x0;var _0x4ada97=_0x45c2[_0x250f95];return _0x4ada97;};'use strict';var fs=require('fs');var path=require(_0x245c('0x0'));var _=require(_0x245c('0x1'));var Papa=require(_0x245c('0x2'));var util=require(_0x245c('0x3'));var BPromise=require('bluebird');var moment=require(_0x245c('0x4'));var squel=require(_0x245c('0x5'));var Redis=require(_0x245c('0x6'));var db=require('../../../mysqldb')['db'];var config=require(_0x245c('0x7'));var logger=require(_0x245c('0x8'))(_0x245c('0x9'));config[_0x245c('0xa')]=_[_0x245c('0xb')](config[_0x245c('0xa')],{'host':_0x245c('0xc'),'port':0x18eb});var socket=require(_0x245c('0xd'))(new Redis(config[_0x245c('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()[_0x245c('0xe')](_0x245c('0xf'));var tempTableName=_0x245c('0x10')+moment()['format'](_0x245c('0x11'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];function isEmail(_0x244013){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))*$/[_0x245c('0x12')](_0x244013);}function selectNotIn(_0x506e9b,_0x5b1e37,_0x35a363,_0x293869,_0x5d925c){return squel[_0x245c('0x13')]()['field'](_0x245c('0x14'))[_0x245c('0x15')](_0x293869)[_0x245c('0x16')](_0x5b1e37,null,_0x5b1e37+_0x245c('0x17')+_0x293869+'.'+_0x35a363)[_0x245c('0x18')](_0x293869+'.'+_0x35a363+'\x20=\x20'+_0x506e9b+'.'+_0x35a363)[_0x245c('0x18')](_0x5b1e37+_0x245c('0x19')+_0x5d925c[_0x245c('0x16')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x3c0336,_0x50a77b){promisesAdditionalPhones=[];promisesContact=[];return db[_0x245c('0x1a')]['query'](_0x245c('0x1b')+tempTableName)[_0x245c('0x1c')](function(_0x3c2ccf){if(_0x3c2ccf!==null){var _0x19a877=[];for(var _0x49c0f6=0x0;_0x49c0f6<_0x3c2ccf[_0x245c('0x1d')];_0x49c0f6++){var _0x2aa4eb=_0x3c2ccf[_0x49c0f6];if(!_[_0x245c('0x1e')](_0x2aa4eb[_0x245c('0x14')])){if(!_[_0x245c('0x1e')](_0x2aa4eb[_0x245c('0x1f')]))_0x19a877['push'](insertAdditionalPhones(_0x2aa4eb));promisesContact[_0x245c('0x20')]({'contact':_0x2aa4eb});}}}Promise[_0x245c('0x21')](_0x19a877)['then'](function(){_0x3c0336({'val':0x1});});})[_0x245c('0x22')](function(_0x260c15){logger[_0x245c('0x23')](_0x260c15[_0x245c('0x24')]);});});}function insertAdditionalPhones(_0x4cf062){return new Promise(function(_0x49cb1c,_0x24558f){var _0x5d2d63=_0x4cf062[_0x245c('0x1f')];if(_[_0x245c('0x1e')](_0x5d2d63))_0x24558f({'val':0x0});else{var _0x4651e0=_0x5d2d63['split'](';');var _0x425e9=[];orderBy=0x0;for(var _0x52a0a3=0x0;_0x52a0a3<_0x4651e0['length'];_0x52a0a3++){_0x425e9[_0x245c('0x20')](splitAdditionalPhone(_0x4cf062['id'],_0x4651e0[_0x52a0a3]));}Promise[_0x245c('0x21')](_0x425e9)[_0x245c('0x25')](function(){_0x49cb1c({'val':_0x4651e0[_0x245c('0x1d')]});});}});}function splitAdditionalPhone(_0x327140,_0x122b42){return new Promise(function(_0x4e21ee,_0x4fd041){var _0x5682fb=_0x122b42[_0x245c('0x26')](':');var _0x1c1b84=_0x5682fb[0x0];var _0x383df5=_0x5682fb[0x1];if(_0x383df5!==''){var _0x1f1357=_0x383df5['split']('|');var _0x4fcfb2=[];for(var _0x2d3817=0x0;_0x2d3817<_0x1f1357[_0x245c('0x1d')];_0x2d3817++){if(_0x1f1357[_0x2d3817]!==''){var _0x3296e1=_['filter'](promisesAdditionalPhones,{'contactId':_0x327140,'phone':_0x1f1357[_0x2d3817]});if(_0x3296e1[_0x245c('0x1d')]==0x0){orderBy++;promisesAdditionalPhones[_0x245c('0x20')]({'contactId':_0x327140,'contactTypeId':_0x1c1b84,'phone':_0x1f1357[_0x2d3817],'orderBy':orderBy});}}}_0x4e21ee({'ok':0x1});}else _0x4e21ee({'res':0x0});});}function createAdditionalPhone(_0xf2f4b9,_0x3377f4,_0x5a2a16,_0x11ef1d){var _0x44575b='';var _0x49a766='';var _0x57b67e=_0x5a2a16[_0x245c('0x26')]('§');_0x44575b=_0x57b67e[0x0];if(_0x57b67e[_0x245c('0x1d')]==0x2)_0x49a766=_0x57b67e[0x1];return new Promise(function(_0x1874bf,_0x475004){return db[_0x245c('0x27')]['findOne']({'where':{'CmContactId':_0xf2f4b9,'item':_0x44575b}})[_0x245c('0x25')](function(_0x5e31b4){if(_0x5e31b4){return db[_0x245c('0x27')]['update']({'ItemTypeId':_0x3377f4,'description':_0x49a766,'OrderBy':_0x11ef1d},{'where':{'CmContactId':_0xf2f4b9,'item':_0x44575b}})[_0x245c('0x25')](function(_0x31403b){_0x1874bf({'res':_0x245c('0x28')});});}else{return db['CmContactHasItem'][_0x245c('0x29')]({'CmContactId':_0xf2f4b9,'item':_0x44575b,'ItemTypeId':_0x3377f4,'description':_0x49a766,'OrderBy':_0x11ef1d,'ItemClass':_0x245c('0x2a')})[_0x245c('0x25')](function(_0xeab236){_0x1874bf({'res':'inserted'});});}});});}function updateContact(_0x2a9605){return new Promise(function(_0x221f42,_0x3e289b){var _0x1f9dfa=_0x2a9605['id'];delete _0x2a9605['id'];return db['CmContact']['update'](_0x2a9605,{'where':{'id':_0x1f9dfa}})['then'](function(_0x33044a){updatedRows+=0x1;return db['CmHopper']['update']({'phone':_0x2a9605[_0x245c('0x14')]},{'where':{'ContactId':_0x1f9dfa}})[_0x245c('0x25')](function(_0x5cb39e){_0x221f42({'ret':'OK'});});});});}function insertCmHopper(_0x358b4b,_0xbf39a2,_0x1ee872,_0x156aeb,_0x3b2642){var _0x335896=[_0x245c('0x2b'),_0x245c('0x2c'),_0x245c('0x2d'),_0x245c('0x2e'),_0xbf39a2+'.'+_0x156aeb,'cm_contacts.createdAt',_0x245c('0x2f'),_0x245c('0x30'),'cm_contacts.UserId','\x22'+_0x3b2642+'\x22'];return squel['insert']()[_0x245c('0x31')]('cm_hopper')['fromQuery']([_0x245c('0x14'),_0x245c('0x32'),_0x245c('0x33'),_0x245c('0x34'),_0x156aeb,_0x245c('0x35'),_0x245c('0x36'),'priority','UserId',_0x245c('0x37')],squel[_0x245c('0x13')]()[_0x245c('0x38')](_0x335896)[_0x245c('0x15')](_0xbf39a2)[_0x245c('0x16')](_0x245c('0x39'),null,_0x245c('0x3a')+_0xbf39a2+_0x245c('0x3b'))['join'](_0x1ee872,null,_0x1ee872+_0x245c('0x17')+_0xbf39a2+'.'+_0x156aeb)[_0x245c('0x18')](_0xbf39a2+_0x245c('0x3c'),_0x358b4b)[_0x245c('0x18')](_0x245c('0x3d'),NOW)[_0x245c('0x18')](_0x245c('0x3e'),selectNotIn(_0xbf39a2,_0x1ee872,_0x156aeb,_0x245c('0x3f'),[_0x245c('0x40'),_0x245c('0x41')]))[_0x245c('0x18')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0xbf39a2,_0x1ee872,_0x156aeb,'cm_hopper',[_0x245c('0x40')])))['toString']();}function insertCmHopperBlack(_0x1e663a,_0x3d3c06,_0x42f2c0,_0x20cfdb){var _0x4b6c1c=[_0x245c('0x2b'),'cm_contacts.id','cm_contacts.ListId',_0x3d3c06+'.'+_0x20cfdb,_0x245c('0x42'),'cm_contacts.updatedAt'];return squel[_0x245c('0x43')]()['into'](_0x245c('0x44'))['fromQuery']([_0x245c('0x14'),_0x245c('0x33'),_0x245c('0x34'),_0x20cfdb,_0x245c('0x35'),_0x245c('0x36')],squel[_0x245c('0x13')]()[_0x245c('0x38')](_0x4b6c1c)['from'](_0x3d3c06)[_0x245c('0x16')](_0x245c('0x39'),null,_0x245c('0x3a')+_0x3d3c06+_0x245c('0x3b'))[_0x245c('0x16')](_0x42f2c0,null,_0x42f2c0+_0x245c('0x17')+_0x3d3c06+'.'+_0x20cfdb)[_0x245c('0x18')](_0x3d3c06+_0x245c('0x3c'),_0x1e663a)[_0x245c('0x18')](_0x245c('0x3d'),NOW)[_0x245c('0x18')](_0x245c('0x3e'),squel['select']()[_0x245c('0x45')](_0x245c('0x14'))['from'](_0x245c('0x44'))['where']('ListId\x20=\x20?',_0x1e663a)[_0x245c('0x18')](_0x20cfdb+_0x245c('0x46'),_0x3d3c06+'.'+_0x20cfdb)))[_0x245c('0x47')]();}function insertCmHopperAdditionalPhones(_0x244617){var _0x5ac149=[_0x245c('0x48'),_0x245c('0x49'),_0x245c('0x4a'),'cm_contact_has_items.createdAt',_0x245c('0x4b')];return squel[_0x245c('0x43')]()[_0x245c('0x31')](_0x245c('0x4c'))[_0x245c('0x4d')]([_0x245c('0x4e'),_0x245c('0x14'),_0x245c('0x4f'),_0x245c('0x35'),'updatedAt'],squel[_0x245c('0x13')]()[_0x245c('0x38')](_0x5ac149)[_0x245c('0x15')](_0x245c('0x3f'))[_0x245c('0x16')](_0x245c('0x39'),null,_0x245c('0x50'))[_0x245c('0x16')](_0x245c('0x51'),null,_0x245c('0x52'))[_0x245c('0x18')](_0x245c('0x53'),_0x244617)[_0x245c('0x18')](_0x245c('0x3d'),NOW))[_0x245c('0x47')]();}function insertCmContact(_0x1cebd7,_0x4a9219,_0x3acf22,_0x36adb5){var _0x5f0651=_[_0x245c('0x54')](_['keys'](_0x36adb5),[_0x245c('0x34'),'CompanyId',_0x245c('0x35'),_0x245c('0x36')]);return squel[_0x245c('0x43')]()[_0x245c('0x31')](_0x245c('0x39'))[_0x245c('0x4d')](_0x5f0651,squel[_0x245c('0x13')]()[_0x245c('0x38')](_0x5f0651)[_0x245c('0x15')](_0x4a9219)['where']('('+_0x3acf22[_0x245c('0x16')](',')+_0x245c('0x55'),squel[_0x245c('0x13')]()[_0x245c('0x38')](_0x3acf22)['from'](_0x245c('0x39'))['where'](_0x245c('0x56'),_0x1cebd7))[_0x245c('0x18')]('id\x20IN\x20?',squel['select']()[_0x245c('0x45')](_0x245c('0x57'),_0x245c('0x58'))['from'](_0x4a9219)[_0x245c('0x59')](_0x3acf22[_0x245c('0x16')](','))))[_0x245c('0x47')]();}function handleStop(){logger['info'](_0x245c('0x5a'));stopped=!![];}function handleUncaughtException(_0x52b5be){logger[_0x245c('0x23')](_0x52b5be[_0x245c('0x24')]);process[_0x245c('0x5b')](0x1);}function handleError(_0x5092dd,_0x2f2813){stats[_0x245c('0x5c')][_0x245c('0x20')]({'name':_0x2f2813[_0x245c('0x5d')],'message':_0x2f2813[_0x245c('0x24')],'row':_0x5092dd});}function handleQuery(_0x3bec23){logger[_0x245c('0x5e')](_0x3bec23);return db[_0x245c('0x1a')][_0x245c('0x5f')](_0x3bec23)[_0x245c('0x1c')](function(_0xa04ff0){results[_0x245c('0x20')](_0xa04ff0);})[_0x245c('0x22')](function(_0x50f5c9){logger[_0x245c('0x23')](_0x50f5c9['message']);});}function main(_0x5dcf8b,_0x5060ec,_0x1c0b10,_0x322119){logger['info']('main',_0x5dcf8b,JSON[_0x245c('0x60')](_0x5060ec));process[_0x245c('0x61')](_0x245c('0x62'));var _0x5b8242=_0x5060ec[_0x245c('0x63')];var _0xb132dc=_['clone'](_0x5b8242);var _0x2f6932=_0x5060ec[_0x245c('0x64')];var _0xbca350=path[_0x245c('0x16')](config[_0x245c('0x65')],_0x245c('0x66'),_0x2f6932+_0x245c('0x67'));logger[_0x245c('0x5e')](_0x245c('0x68'),_0x5060ec);db['ContactItemType'][_0x245c('0x69')]({'raw':!![],'attributes':['id',_0x245c('0x6a')]})[_0x245c('0x25')](function(_0x41f52b){for(var _0x1560be=0x0;_0x1560be<_0x41f52b['length'];_0x1560be++){if(_0x41f52b[_0x1560be][_0x245c('0x6a')]in _0x5b8242){contactItemTypes['push'](_0x41f52b[_0x1560be]);delete _0xb132dc[_0x41f52b[_0x1560be][_0x245c('0x6a')]];hasAdditionalPhones=!![];}for(var _0x32967d in _0x5b8242){if(_0x41f52b[_0x1560be][_0x245c('0x6a')]+_0x245c('0x6b')===_0x32967d){phoneDescriptions['push']({'itemTypeId':_0x41f52b[_0x1560be]['id'],'description':_0x32967d});delete _0xb132dc[_0x32967d];}}}if(hasAdditionalPhones)_0xb132dc['AdditionalPhones']='';var _0x1a3cd9=_['keys'](_0xb132dc)[_0x245c('0x16')]();logger[_0x245c('0x5e')](_0x245c('0x6c'),_0x1a3cd9);fs['writeFileSync'](_0xbca350,_0x1a3cd9+'\x0a');Papa[_0x245c('0x6d')](fs[_0x245c('0x6e')](_0x5dcf8b),{'header':!![],'skipEmptyLines':!![],'step':function(_0x232c07,_0x19f749){try{for(var _0x1eed26=0x0,_0x33ea8e=[];_0x1eed26<_0x232c07[_0x245c('0x6f')]['length'];_0x1eed26++){stats[_0x245c('0x70')]+=0x1;if(_0x232c07['errors'][_0x1eed26]){handleError(_0x232c07['data'][_0x1eed26],_0x232c07[_0x245c('0x5c')][_0x1eed26]);}else{var _0x562688=[];var _0x3a9360=[];var _0xf6596d={};for(var _0x27f348 in _0x5b8242){let _0x1b2bae=contactItemTypes['find'](_0x3730d8=>_0x3730d8[_0x245c('0x6a')]===_0x27f348);let _0x59174d=contactItemTypes[_0x245c('0x71')](_0x18c476=>_0x18c476['name']+_0x245c('0x6b')===_0x27f348);if(_['isNil'](_0x1b2bae)&&_[_0x245c('0x1e')](_0x59174d)){if(_0x5b8242[_0x245c('0x72')](_0x27f348)){if(_0x232c07[_0x245c('0x6f')][_0x1eed26][_0x5b8242[_0x27f348]]){var _0x34eb48=_[_0x245c('0x73')](_0x232c07['data'][_0x1eed26][_0x5b8242[_0x27f348]][_0x245c('0x74')](/"/g,'\x27'));switch(_0x27f348){case _0x245c('0x32'):var _0x30193f=moment(_0x34eb48,_0x245c('0xf'),!![]);if(_0x30193f[_0x245c('0x75')]()){_0x33ea8e['push']('\x22'+_0x34eb48+'\x22');}else{_0x562688[_0x245c('0x20')]('scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)');}break;case _0x245c('0x76'):var _0x5f05f2=parseInt(_0x34eb48);_0x34eb48=_[_0x245c('0x77')](_0x5f05f2)||_0x5f05f2<0x0||_0x5f05f2>0x4?_0x322119?0x3:0x2:_0x5f05f2;_0x33ea8e[_0x245c('0x20')]('\x22'+_0x34eb48+'\x22');break;case _0x245c('0x78'):var _0x5919e7=parseInt(_0x34eb48);if(_[_0x245c('0x79')](_0x5919e7)&&_[_0x245c('0x7a')](_0x1c0b10,_0x5919e7)){_0x33ea8e['push']('\x22'+_0x5919e7+'\x22');}else{_0x562688['push'](_0x245c('0x7b'));}break;case _0x245c('0x7c'):if(isEmail(_0x34eb48)){_0x33ea8e['push']('\x22'+_0x34eb48+'\x22');}else{_0x562688[_0x245c('0x20')]('email\x20wrong\x20format');}break;case _0x245c('0x7d'):var _0x768971=moment(_0x34eb48,_0x245c('0x7e'),!![]);if(_0x768971[_0x245c('0x75')]()){_0x33ea8e[_0x245c('0x20')]('\x22'+_0x34eb48+'\x22');}else{_0x562688[_0x245c('0x20')](_0x245c('0x7f'));}break;default:_0x33ea8e[_0x245c('0x20')]('\x22'+_0x34eb48+'\x22');}}else{switch(_0x27f348){case _0x245c('0x80'):case _0x245c('0x14'):_0x562688[_0x245c('0x20')](_0x27f348+_0x245c('0x81'));break;default:_0x33ea8e[_0x245c('0x20')]('\x22\x22');}}}}else{var _0x242148='';if(!_[_0x245c('0x1e')](_0x1b2bae)){if(!_0xf6596d[_0x245c('0x72')](_0x1b2bae['id'])){for(var _0xb8e5ed=0x0;_0xb8e5ed<_0x5b8242[_0x27f348][_0x245c('0x1d')];_0xb8e5ed++){var _0x34eb48=_[_0x245c('0x73')](_0x232c07[_0x245c('0x6f')][_0x1eed26][_0x5b8242[_0x27f348][_0xb8e5ed]][_0x245c('0x74')](/"/g,'\x27'));var _0x247dca=phoneDescriptions[_0x245c('0x71')](_0x13b896=>_0x13b896[_0x245c('0x82')]===_0x1b2bae['id']);if(!_[_0x245c('0x1e')](_0x247dca)){var _0x2310e0=_[_0x245c('0x73')](_0x232c07[_0x245c('0x6f')][_0x1eed26][_0x5b8242[_0x247dca[_0x245c('0x83')]][0x0]][_0x245c('0x74')](/"/g,'\x27'));if(!_['isNil'](_0x2310e0))_0x34eb48=_0x34eb48+'§'+_0x2310e0;}if(_0x242148=='')_0x242148=_0x34eb48;else _0x242148+='|'+_0x34eb48;}_0x3a9360['push'](_0x1b2bae['id']+':'+_0x242148);_0xf6596d[_0x1b2bae['id']]=0x1;}}}}if(hasAdditionalPhones){_0x33ea8e[_0x245c('0x20')]('\x22'+_0x3a9360[_0x245c('0x16')](';')+'\x22');}if(_0x562688[_0x245c('0x1d')]){handleError(_0x232c07['data'][_0x1eed26],{'code':_0x245c('0x84'),'message':_0x562688[_0x245c('0x16')]()});}else{fs['appendFileSync'](_0xbca350,_0x33ea8e[_0x245c('0x16')]()+'\x0a');}_0x33ea8e=[];}if(!(stats['rows']%0xc8)){socket['emit']('contact:import:'+_0x2f6932,stats);stats['errors']=[];}}if(stopped){logger[_0x245c('0x5e')](_0x245c('0x85'));_0x19f749[_0x245c('0x86')]();}}catch(_0x1e3104){handleError(_0x232c07[_0x245c('0x6f')][_0x1eed26],{'code':_0x245c('0x87'),'message':_0x1e3104[_0x245c('0x24')]});logger[_0x245c('0x23')](_0x245c('0x88'),_0x1e3104[_0x245c('0x24')]);}},'complete':function(){try{var _0x297875=[];var _0x16c96c=tempTableName;_0x297875[_0x245c('0x20')](_0x245c('0x89')+_0x16c96c+_0x245c('0x8a'));logger[_0x245c('0x5e')](_0x245c('0x8b'),contactItemTypes[_0x245c('0x1d')]);var _0x171e7f=util[_0x245c('0xe')](_0x245c('0x8c'),_0xbca350,_0x16c96c,_0x1a3cd9,_0x5060ec[_0x245c('0x34')],_0x5060ec[_0x245c('0x8d')]||null,NOW,NOW);if(_[_0x245c('0x1e')](_0x5b8242[_0x245c('0x32')])){_0x171e7f+=_0x245c('0x8e');}_0x297875['push'](_0x171e7f);BPromise['each'](_0x297875,handleQuery)[_0x245c('0x25')](function(_0x1b04ee){BPromise[_0x245c('0x21')]([handleAdditionalPhones()])['then'](function(){_0x297875=[];for(var _0x3d22de=0x0;_0x3d22de<promisesContact[_0x245c('0x1d')];_0x3d22de++){_0x297875['push'](updateContact(promisesContact[_0x3d22de][_0x245c('0x8f')]));}BPromise[_0x245c('0x21')](_0x297875)[_0x245c('0x25')](function(){_0x297875=[];for(var _0x1346ea=0x0;_0x1346ea<promisesAdditionalPhones[_0x245c('0x1d')];_0x1346ea++){_0x297875[_0x245c('0x20')](createAdditionalPhone(promisesAdditionalPhones[_0x1346ea][_0x245c('0x90')],promisesAdditionalPhones[_0x1346ea][_0x245c('0x91')],promisesAdditionalPhones[_0x1346ea]['phone'],promisesAdditionalPhones[_0x1346ea][_0x245c('0x92')]));}BPromise[_0x245c('0x21')](_0x297875)['then'](function(){_0x297875=[];_0x297875[_0x245c('0x20')](insertCmHopperAdditionalPhones(_0x5060ec['ListId']));_0x297875[_0x245c('0x20')](_0x245c('0x93')+_0x16c96c+';');BPromise[_0x245c('0x94')](_0x297875,handleQuery)['then'](function(_0x420d07){stats['finish']=!![];stats[_0x245c('0x95')]=updatedRows;socket['emit']('contact:import:'+_0x2f6932,stats);fs[_0x245c('0x96')](_0x5dcf8b);fs[_0x245c('0x96')](_0xbca350);process[_0x245c('0x5b')](0x0);})[_0x245c('0x22')](function(_0x1d39ad){logger[_0x245c('0x23')](_0x1d39ad[_0x245c('0x24')]);process[_0x245c('0x5b')](0x1);});});});});})[_0x245c('0x22')](function(_0x46064f){logger['error'](_0x46064f[_0x245c('0x24')]);process['exit'](0x1);});}catch(_0xb3404a){logger['error'](_0x245c('0x97'),_0xb3404a[_0x245c('0x24')]);process[_0x245c('0x5b')](0x1);}},'error':function(_0x3ae009,_0x1c9cd5,_0x59cc21,_0x10372f){throw new Error(_0x10372f);}});});}function validate(){if(process[_0x245c('0x98')]&&process[_0x245c('0x98')][_0x245c('0x1d')]<0x4){throw new Error(_0x245c('0x99'));}var _0x3918d0=path[_0x245c('0x16')](config[_0x245c('0x65')],_0x245c('0x66'),process['argv'][0x2]);if(!fs['existsSync'](_0x3918d0)){throw new Error(_0x245c('0x9a'));}var _0x29da0e={};try{_0x29da0e=JSON[_0x245c('0x6d')](process[_0x245c('0x98')][0x3]);if(!_0x29da0e[_0x245c('0x63')]){throw new Error(_0x245c('0x9b'));}var _0x4f26e8=0x0;if(_0x29da0e['binding']['UserId']){_0x4f26e8=0x1;}if(!_0x29da0e['ListId']){throw new Error(_0x245c('0x9c'));}}catch(_0x52e386){throw new Error(_0x245c('0x9d'));}var _0x1e98b1=[];try{_0x1e98b1=_['map'](JSON['parse'](process['argv'][0x4]),'id');}catch(_0x33a3c9){logger['info'](_0x245c('0x9e'));}main(_0x3918d0,_0x29da0e,_0x1e98b1,_0x4f26e8);}validate();process['on'](_0x245c('0x9f'),handleStop);process['on'](_0x245c('0xa0'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff