18 var _0xf06b=['from','.id\x20=\x20','\x20=\x20','where','join','sequelize','query','select\x20*\x20from\x20','length','isNil','AdditionalPhones','push','all','then','catch','message','split','filter','CmContactHasItem','findOne','update','updated','inserted','CmContact','CmHopper','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','insert','into','scheduledat','ContactId','ListId','createdAt','updatedAt','priority','UserId','recallme','cm_contacts','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_hopper','\x22always\x22','\x22onlyIfOpen\x22','cm_contacts.phone\x20NOT\x20IN\x20(?)','cm_contacts.id','cm_hopper_black','fields','cm_contacts.ListId\x20=\x20','.CmListId','ListId\x20=\x20?','\x20=\x20?','toString','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','fromQuery','CmHopperId','OrderBy','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','keys','CompanyId',')\x20NOT\x20IN\x20?','MIN(id)','info','Received\x20SIGINT','exit','errors','code','spread','error','main','stringify','send','binding','clone','socket_timestamp','root','server/files/tmp','.csv','ContactItemType','findAll','name','header','createReadStream','rows','data','hasOwnProperty','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','agent\x20not\x20exists','email','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','\x20not\x20specified','trim','replace','contact:import:','Abort\x20parser','abort','SystemError','step','\x20LIKE\x20cm_contacts;','format',',\x20scheduledAt\x20=\x20NOW()','each','contact','contactTypeId','orderBy','finish','affectedRows','unlink','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','parse','uncaughtException','path','papaparse','util','squel','ioredis','../../../config/environment','../../../config/logger','import','redis','localhost','socket.io-emitter','YYYY-MM-DD\x20HH:mm:ss','cm_contacts_temp_','YYYYMMDDHHmmss','select','field','phone'];(function(_0xae12e5,_0x53980b){var _0x532654=function(_0x56e9a0){while(--_0x56e9a0){_0xae12e5['push'](_0xae12e5['shift']());}};_0x532654(++_0x53980b);}(_0xf06b,0x84));var _0xbf06=function(_0x3d737b,_0x3d51af){_0x3d737b=_0x3d737b-0x0;var _0x443408=_0xf06b[_0x3d737b];return _0x443408;};'use strict';var fs=require('fs');var path=require(_0xbf06('0x0'));var _=require('lodash');var Papa=require(_0xbf06('0x1'));var util=require(_0xbf06('0x2'));var BPromise=require('bluebird');var moment=require('moment');var squel=require(_0xbf06('0x3'));var Redis=require(_0xbf06('0x4'));var db=require('../../../mysqldb')['db'];var config=require(_0xbf06('0x5'));var logger=require(_0xbf06('0x6'))(_0xbf06('0x7'));config[_0xbf06('0x8')]=_['defaults'](config[_0xbf06('0x8')],{'host':_0xbf06('0x9'),'port':0x18eb});var socket=require(_0xbf06('0xa'))(new Redis(config[_0xbf06('0x8')]));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'](_0xbf06('0xb'));var tempTableName=_0xbf06('0xc')+moment()['format'](_0xbf06('0xd'));var contactItemTypes=[];var hasAdditionalPhones=![];function isEmail(_0x581ce2){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'](_0x581ce2);}function selectNotIn(_0x4fce33,_0x3d278c,_0x52aa04,_0x131475,_0x3e3b18){return squel[_0xbf06('0xe')]()[_0xbf06('0xf')](_0xbf06('0x10'))[_0xbf06('0x11')](_0x131475)['join'](_0x3d278c,null,_0x3d278c+_0xbf06('0x12')+_0x131475+'.'+_0x52aa04)['where'](_0x131475+'.'+_0x52aa04+_0xbf06('0x13')+_0x4fce33+'.'+_0x52aa04)[_0xbf06('0x14')](_0x3d278c+'.dialCheckDuplicateType\x20IN\x20('+_0x3e3b18[_0xbf06('0x15')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x582b6e,_0x472862){promisesAdditionalPhones=[];promisesContact=[];return db[_0xbf06('0x16')][_0xbf06('0x17')](_0xbf06('0x18')+tempTableName)['spread'](function(_0x2a6e2a){if(_0x2a6e2a!==null){var _0xb5c5c7=[];for(var _0x4d45e5=0x0;_0x4d45e5<_0x2a6e2a[_0xbf06('0x19')];_0x4d45e5++){var _0x2ef719=_0x2a6e2a[_0x4d45e5];if(!_[_0xbf06('0x1a')](_0x2ef719[_0xbf06('0x10')])){if(!_[_0xbf06('0x1a')](_0x2ef719[_0xbf06('0x1b')]))_0xb5c5c7[_0xbf06('0x1c')](insertAdditionalPhones(_0x2ef719));promisesContact['push']({'contact':_0x2ef719});}}}Promise[_0xbf06('0x1d')](_0xb5c5c7)[_0xbf06('0x1e')](function(){_0x582b6e({'val':0x1});});})[_0xbf06('0x1f')](function(_0x4773c3){logger['error'](_0x4773c3[_0xbf06('0x20')]);});});}function insertAdditionalPhones(_0x4e138d){return new Promise(function(_0x4e16ad,_0x248451){var _0x198bfd=_0x4e138d['AdditionalPhones'];if(_[_0xbf06('0x1a')](_0x198bfd))_0x248451({'val':0x0});else{var _0x12276e=_0x198bfd[_0xbf06('0x21')](';');var _0x94e4a3=[];orderBy=0x0;for(var _0x57664f=0x0;_0x57664f<_0x12276e['length'];_0x57664f++){_0x94e4a3['push'](splitAdditionalPhone(_0x4e138d['id'],_0x12276e[_0x57664f]));}Promise[_0xbf06('0x1d')](_0x94e4a3)[_0xbf06('0x1e')](function(){_0x4e16ad({'val':_0x12276e[_0xbf06('0x19')]});});}});}function splitAdditionalPhone(_0x18844d,_0x30d044){return new Promise(function(_0x5c1f43,_0x37a24e){var _0x2975db=_0x30d044['split'](':');var _0x5eb75d=_0x2975db[0x0];var _0x22af7f=_0x2975db[0x1];if(_0x22af7f!==''){var _0x21c79a=_0x22af7f[_0xbf06('0x21')]('|');var _0x4cc239=[];for(var _0x18d584=0x0;_0x18d584<_0x21c79a[_0xbf06('0x19')];_0x18d584++){if(_0x21c79a[_0x18d584]!==''){var _0x3f25c5=_[_0xbf06('0x22')](promisesAdditionalPhones,{'contactId':_0x18844d,'phone':_0x21c79a[_0x18d584]});if(_0x3f25c5[_0xbf06('0x19')]==0x0){orderBy++;promisesAdditionalPhones[_0xbf06('0x1c')]({'contactId':_0x18844d,'contactTypeId':_0x5eb75d,'phone':_0x21c79a[_0x18d584],'orderBy':orderBy});}}}_0x5c1f43({'ok':0x1});}else _0x5c1f43({'res':0x0});});}function createAdditionalPhone(_0x5b2839,_0x2b15fb,_0xa95dc8,_0x584530){return new Promise(function(_0x3f1a7b,_0x4df1ab){return db[_0xbf06('0x23')][_0xbf06('0x24')]({'where':{'CmContactId':_0x5b2839,'item':_0xa95dc8}})[_0xbf06('0x1e')](function(_0xef6998){if(_0xef6998){return db[_0xbf06('0x23')][_0xbf06('0x25')]({'ItemTypeId':_0x2b15fb,'OrderBy':_0x584530},{'where':{'CmContactId':_0x5b2839,'item':_0xa95dc8}})['then'](function(_0x2f9a00){_0x3f1a7b({'res':_0xbf06('0x26')});});}else{return db[_0xbf06('0x23')]['create']({'CmContactId':_0x5b2839,'item':_0xa95dc8,'ItemTypeId':_0x2b15fb,'OrderBy':_0x584530,'ItemClass':'PHONE'})[_0xbf06('0x1e')](function(_0x1064ec){_0x3f1a7b({'res':_0xbf06('0x27')});});}});});}function updateContact(_0x63214a){return new Promise(function(_0x972f6d,_0x25990){var _0x27575b=_0x63214a['id'];delete _0x63214a['id'];return db[_0xbf06('0x28')]['update'](_0x63214a,{'where':{'id':_0x27575b}})[_0xbf06('0x1e')](function(_0x300136){updatedRows+=0x1;return db[_0xbf06('0x29')][_0xbf06('0x25')]({'phone':_0x63214a[_0xbf06('0x10')]},{'where':{'ContactId':_0x27575b}})[_0xbf06('0x1e')](function(_0x14146c){_0x972f6d({'ret':'OK'});});});});}function insertCmHopper(_0x40a922,_0x52ab22,_0x397516,_0x2f4fed,_0x19878c){var _0x41ae44=[_0xbf06('0x2a'),_0xbf06('0x2b'),'cm_contacts.id',_0xbf06('0x2c'),_0x52ab22+'.'+_0x2f4fed,_0xbf06('0x2d'),_0xbf06('0x2e'),_0xbf06('0x2f'),_0xbf06('0x30'),'\x22'+_0x19878c+'\x22'];return squel[_0xbf06('0x31')]()[_0xbf06('0x32')]('cm_hopper')['fromQuery']([_0xbf06('0x10'),_0xbf06('0x33'),_0xbf06('0x34'),_0xbf06('0x35'),_0x2f4fed,_0xbf06('0x36'),_0xbf06('0x37'),_0xbf06('0x38'),_0xbf06('0x39'),_0xbf06('0x3a')],squel[_0xbf06('0xe')]()['fields'](_0x41ae44)[_0xbf06('0x11')](_0x52ab22)[_0xbf06('0x15')](_0xbf06('0x3b'),null,'cm_contacts.ListId\x20=\x20'+_0x52ab22+'.CmListId')[_0xbf06('0x15')](_0x397516,null,_0x397516+_0xbf06('0x12')+_0x52ab22+'.'+_0x2f4fed)[_0xbf06('0x14')](_0x52ab22+_0xbf06('0x3c'),_0x40a922)[_0xbf06('0x14')](_0xbf06('0x3d'),NOW)[_0xbf06('0x14')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x52ab22,_0x397516,_0x2f4fed,_0xbf06('0x3e'),[_0xbf06('0x3f'),_0xbf06('0x40')]))['where'](_0xbf06('0x41'),selectNotIn(_0x52ab22,_0x397516,_0x2f4fed,'cm_hopper',['\x22always\x22'])))['toString']();}function insertCmHopperBlack(_0x37a66c,_0x4ddb05,_0x5385a1,_0x3b22ab){var _0xac75e3=[_0xbf06('0x2a'),_0xbf06('0x42'),'cm_contacts.ListId',_0x4ddb05+'.'+_0x3b22ab,_0xbf06('0x2d'),_0xbf06('0x2e')];return squel['insert']()[_0xbf06('0x32')](_0xbf06('0x43'))['fromQuery'](['phone',_0xbf06('0x34'),_0xbf06('0x35'),_0x3b22ab,_0xbf06('0x36'),'updatedAt'],squel[_0xbf06('0xe')]()[_0xbf06('0x44')](_0xac75e3)[_0xbf06('0x11')](_0x4ddb05)[_0xbf06('0x15')](_0xbf06('0x3b'),null,_0xbf06('0x45')+_0x4ddb05+_0xbf06('0x46'))[_0xbf06('0x15')](_0x5385a1,null,_0x5385a1+_0xbf06('0x12')+_0x4ddb05+'.'+_0x3b22ab)['where'](_0x4ddb05+'.CmListId\x20=\x20?',_0x37a66c)[_0xbf06('0x14')](_0xbf06('0x3d'),NOW)['where'](_0xbf06('0x41'),squel[_0xbf06('0xe')]()['field'](_0xbf06('0x10'))['from'](_0xbf06('0x43'))[_0xbf06('0x14')](_0xbf06('0x47'),_0x37a66c)['where'](_0x3b22ab+_0xbf06('0x48'),_0x4ddb05+'.'+_0x3b22ab)))[_0xbf06('0x49')]();}function insertCmHopperAdditionalPhones(_0x1d2856){var _0x48e528=['cm_hopper.id',_0xbf06('0x4a'),_0xbf06('0x4b'),_0xbf06('0x4c'),_0xbf06('0x4d')];return squel[_0xbf06('0x31')]()[_0xbf06('0x32')](_0xbf06('0x4e'))[_0xbf06('0x4f')]([_0xbf06('0x50'),'phone',_0xbf06('0x51'),_0xbf06('0x36'),_0xbf06('0x37')],squel['select']()[_0xbf06('0x44')](_0x48e528)[_0xbf06('0x11')](_0xbf06('0x3e'))[_0xbf06('0x15')](_0xbf06('0x3b'),null,_0xbf06('0x52'))[_0xbf06('0x15')]('cm_contact_has_items',null,_0xbf06('0x53'))[_0xbf06('0x14')](_0xbf06('0x54'),_0x1d2856)['where'](_0xbf06('0x3d'),NOW))[_0xbf06('0x49')]();}function insertCmContact(_0x4b3e1a,_0x5d5fcb,_0x20ef3e,_0x5733b){var _0x214abb=_['concat'](_[_0xbf06('0x55')](_0x5733b),[_0xbf06('0x35'),_0xbf06('0x56'),_0xbf06('0x36'),'updatedAt']);return squel[_0xbf06('0x31')]()[_0xbf06('0x32')](_0xbf06('0x3b'))[_0xbf06('0x4f')](_0x214abb,squel[_0xbf06('0xe')]()[_0xbf06('0x44')](_0x214abb)[_0xbf06('0x11')](_0x5d5fcb)[_0xbf06('0x14')]('('+_0x20ef3e[_0xbf06('0x15')](',')+_0xbf06('0x57'),squel[_0xbf06('0xe')]()[_0xbf06('0x44')](_0x20ef3e)[_0xbf06('0x11')](_0xbf06('0x3b'))[_0xbf06('0x14')]('ListId\x20=\x20?',_0x4b3e1a))[_0xbf06('0x14')]('id\x20IN\x20?',squel[_0xbf06('0xe')]()[_0xbf06('0xf')](_0xbf06('0x58'),'min_id')['from'](_0x5d5fcb)['group'](_0x20ef3e[_0xbf06('0x15')](','))))[_0xbf06('0x49')]();}function handleStop(){logger[_0xbf06('0x59')](_0xbf06('0x5a'));stopped=!![];}function handleUncaughtException(_0x3ccef5){logger['error'](_0x3ccef5[_0xbf06('0x20')]);process[_0xbf06('0x5b')](0x1);}function handleError(_0x19d27e,_0xac47a){stats[_0xbf06('0x5c')][_0xbf06('0x1c')]({'name':_0xac47a[_0xbf06('0x5d')],'message':_0xac47a['message'],'row':_0x19d27e});}function handleQuery(_0x3484e){logger['info'](_0x3484e);return db[_0xbf06('0x16')][_0xbf06('0x17')](_0x3484e)[_0xbf06('0x5e')](function(_0x270bbc){results[_0xbf06('0x1c')](_0x270bbc);})[_0xbf06('0x1f')](function(_0xc7c60){logger[_0xbf06('0x5f')](_0xc7c60[_0xbf06('0x20')]);});}function main(_0x4a8f77,_0xda5510,_0x18b4d0,_0x1b5a8b){logger[_0xbf06('0x59')](_0xbf06('0x60'),_0x4a8f77,JSON[_0xbf06('0x61')](_0xda5510));process[_0xbf06('0x62')]('start');var _0x2eb375=_0xda5510[_0xbf06('0x63')];var _0x2cae1c=_[_0xbf06('0x64')](_0x2eb375);var _0xbeed75=_0xda5510[_0xbf06('0x65')];var _0x5a591b=path[_0xbf06('0x15')](config[_0xbf06('0x66')],_0xbf06('0x67'),_0xbeed75+_0xbf06('0x68'));logger[_0xbf06('0x59')]('body',_0xda5510);db[_0xbf06('0x69')][_0xbf06('0x6a')]({'raw':!![],'attributes':['id','name']})[_0xbf06('0x1e')](function(_0x4c9de1){for(var _0x515336=0x0;_0x515336<_0x4c9de1[_0xbf06('0x19')];_0x515336++){if(_0x4c9de1[_0x515336][_0xbf06('0x6b')]in _0x2eb375){contactItemTypes['push'](_0x4c9de1[_0x515336]);delete _0x2cae1c[_0x4c9de1[_0x515336]['name']];hasAdditionalPhones=!![];}else{}}if(hasAdditionalPhones)_0x2cae1c[_0xbf06('0x1b')]='';var _0xb33283=_[_0xbf06('0x55')](_0x2cae1c)[_0xbf06('0x15')]();logger[_0xbf06('0x59')](_0xbf06('0x6c'),_0xb33283);fs['writeFileSync'](_0x5a591b,_0xb33283+'\x0a');Papa['parse'](fs[_0xbf06('0x6d')](_0x4a8f77),{'header':!![],'skipEmptyLines':!![],'step':function(_0x2bf6d4,_0x48cd80){try{for(var _0x3b8f1a=0x0,_0x23034b=[];_0x3b8f1a<_0x2bf6d4['data'][_0xbf06('0x19')];_0x3b8f1a++){stats[_0xbf06('0x6e')]+=0x1;if(_0x2bf6d4[_0xbf06('0x5c')][_0x3b8f1a]){handleError(_0x2bf6d4[_0xbf06('0x6f')][_0x3b8f1a],_0x2bf6d4[_0xbf06('0x5c')][_0x3b8f1a]);}else{var _0x1be725=[];var _0x8bf36a=[];for(var _0x1ce05d in _0x2eb375){let _0x1c3d9c=contactItemTypes['find'](_0x599f65=>_0x599f65[_0xbf06('0x6b')]===_0x1ce05d);if(_['isNil'](_0x1c3d9c)){if(_0x2eb375[_0xbf06('0x70')](_0x1ce05d)){if(_0x2bf6d4[_0xbf06('0x6f')][_0x3b8f1a][_0x2eb375[_0x1ce05d]]){var _0x37918a=_['trim'](_0x2bf6d4['data'][_0x3b8f1a][_0x2eb375[_0x1ce05d]]['replace'](/"/g,'\x27'));switch(_0x1ce05d){case'scheduledat':var _0x5d9579=moment(_0x37918a,_0xbf06('0xb'),!![]);if(_0x5d9579['isValid']()){_0x23034b[_0xbf06('0x1c')]('\x22'+_0x37918a+'\x22');}else{_0x1be725[_0xbf06('0x1c')](_0xbf06('0x71'));}break;case _0xbf06('0x38'):var _0x18dbb8=parseInt(_0x37918a);_0x37918a=_['isNaN'](_0x18dbb8)||_0x18dbb8<0x0||_0x18dbb8>0x4?_0x1b5a8b?0x3:0x2:_0x18dbb8;_0x23034b[_0xbf06('0x1c')]('\x22'+_0x37918a+'\x22');break;case _0xbf06('0x39'):var _0x4b823a=parseInt(_0x37918a);if(_['isNumber'](_0x4b823a)&&_['includes'](_0x18b4d0,_0x4b823a)){_0x23034b[_0xbf06('0x1c')]('\x22'+_0x4b823a+'\x22');}else{_0x1be725['push'](_0xbf06('0x72'));}break;case _0xbf06('0x73'):if(isEmail(_0x37918a)){_0x23034b['push']('\x22'+_0x37918a+'\x22');}else{_0x1be725[_0xbf06('0x1c')](_0xbf06('0x74'));}break;case _0xbf06('0x75'):var _0x570a33=moment(_0x37918a,_0xbf06('0x76'),!![]);if(_0x570a33['isValid']()){_0x23034b[_0xbf06('0x1c')]('\x22'+_0x37918a+'\x22');}else{_0x1be725[_0xbf06('0x1c')](_0xbf06('0x77'));}break;default:_0x23034b[_0xbf06('0x1c')]('\x22'+_0x37918a+'\x22');}}else{switch(_0x1ce05d){case'firstName':case _0xbf06('0x10'):_0x1be725[_0xbf06('0x1c')](_0x1ce05d+_0xbf06('0x78'));break;default:_0x23034b[_0xbf06('0x1c')]('\x22\x22');}}}}else{var _0x3a45c3='';for(var _0x4f1cd8=0x0;_0x4f1cd8<_0x2eb375[_0x1ce05d]['length'];_0x4f1cd8++){var _0x37918a=_[_0xbf06('0x79')](_0x2bf6d4[_0xbf06('0x6f')][_0x3b8f1a][_0x2eb375[_0x1ce05d][_0x4f1cd8]][_0xbf06('0x7a')](/"/g,'\x27'));if(_0x3a45c3=='')_0x3a45c3=_0x37918a;else _0x3a45c3+='|'+_0x37918a;}_0x8bf36a['push'](_0x1c3d9c['id']+':'+_0x3a45c3);}}if(hasAdditionalPhones){_0x23034b[_0xbf06('0x1c')]('\x22'+_0x8bf36a['join'](';')+'\x22');}if(_0x1be725[_0xbf06('0x19')]){handleError(_0x2bf6d4['data'][_0x3b8f1a],{'code':'SystemRow','message':_0x1be725[_0xbf06('0x15')]()});}else{fs['appendFileSync'](_0x5a591b,_0x23034b[_0xbf06('0x15')]()+'\x0a');}_0x23034b=[];}if(!(stats[_0xbf06('0x6e')]%0xc8)){socket['emit'](_0xbf06('0x7b')+_0xbeed75,stats);stats[_0xbf06('0x5c')]=[];}}if(stopped){logger[_0xbf06('0x59')](_0xbf06('0x7c'));_0x48cd80[_0xbf06('0x7d')]();}}catch(_0x2018f8){handleError(_0x2bf6d4[_0xbf06('0x6f')][_0x3b8f1a],{'code':_0xbf06('0x7e'),'message':_0x2018f8[_0xbf06('0x20')]});logger[_0xbf06('0x5f')](_0xbf06('0x7f'),_0x2018f8[_0xbf06('0x20')]);}},'complete':function(){try{var _0x19a8c1=[];var _0x19ce44=tempTableName;_0x19a8c1[_0xbf06('0x1c')]('CREATE\x20TABLE\x20'+_0x19ce44+_0xbf06('0x80'));logger['info']('CIS\x20len',contactItemTypes[_0xbf06('0x19')]);var _0x179d94=util[_0xbf06('0x81')]('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',_0x5a591b,_0x19ce44,_0xb33283,_0xda5510[_0xbf06('0x35')],_0xda5510['CompanyId']||null,NOW,NOW);if(_[_0xbf06('0x1a')](_0x2eb375[_0xbf06('0x33')])){_0x179d94+=_0xbf06('0x82');}_0x19a8c1['push'](_0x179d94);BPromise[_0xbf06('0x83')](_0x19a8c1,handleQuery)['then'](function(_0xdb5764){BPromise[_0xbf06('0x1d')]([handleAdditionalPhones()])[_0xbf06('0x1e')](function(){_0x19a8c1=[];for(var _0x2d80ed=0x0;_0x2d80ed<promisesContact[_0xbf06('0x19')];_0x2d80ed++){_0x19a8c1[_0xbf06('0x1c')](updateContact(promisesContact[_0x2d80ed][_0xbf06('0x84')]));}BPromise['all'](_0x19a8c1)[_0xbf06('0x1e')](function(){_0x19a8c1=[];for(var _0x46c2a6=0x0;_0x46c2a6<promisesAdditionalPhones[_0xbf06('0x19')];_0x46c2a6++){_0x19a8c1['push'](createAdditionalPhone(promisesAdditionalPhones[_0x46c2a6]['contactId'],promisesAdditionalPhones[_0x46c2a6][_0xbf06('0x85')],promisesAdditionalPhones[_0x46c2a6][_0xbf06('0x10')],promisesAdditionalPhones[_0x46c2a6][_0xbf06('0x86')]));}BPromise[_0xbf06('0x1d')](_0x19a8c1)['then'](function(){_0x19a8c1=[];_0x19a8c1[_0xbf06('0x1c')](insertCmHopperAdditionalPhones(_0xda5510['ListId']));_0x19a8c1['push']('DROP\x20TABLE\x20'+_0x19ce44+';');BPromise['each'](_0x19a8c1,handleQuery)[_0xbf06('0x1e')](function(_0x47ac92){stats[_0xbf06('0x87')]=!![];stats[_0xbf06('0x88')]=updatedRows;socket['emit'](_0xbf06('0x7b')+_0xbeed75,stats);fs[_0xbf06('0x89')](_0x4a8f77);fs['unlink'](_0x5a591b);process[_0xbf06('0x5b')](0x0);})[_0xbf06('0x1f')](function(_0x18d4a6){logger['error'](_0x18d4a6[_0xbf06('0x20')]);process[_0xbf06('0x5b')](0x1);});});});});})[_0xbf06('0x1f')](function(_0x1ff4bf){logger[_0xbf06('0x5f')](_0x1ff4bf[_0xbf06('0x20')]);process[_0xbf06('0x5b')](0x1);});}catch(_0x9de2df){logger[_0xbf06('0x5f')](_0xbf06('0x8a'),_0x9de2df[_0xbf06('0x20')]);process[_0xbf06('0x5b')](0x1);}},'error':function(_0x1a3831,_0xd61b98,_0xa50217,_0x384f47){throw new Error(_0x384f47);}});});}function validate(){if(process[_0xbf06('0x8b')]&&process[_0xbf06('0x8b')]['length']<0x4){throw new Error(_0xbf06('0x8c'));}var _0xd83c0e=path[_0xbf06('0x15')](config[_0xbf06('0x66')],_0xbf06('0x67'),process[_0xbf06('0x8b')][0x2]);if(!fs[_0xbf06('0x8d')](_0xd83c0e)){throw new Error(_0xbf06('0x8e'));}var _0x226dd0={};try{_0x226dd0=JSON['parse'](process[_0xbf06('0x8b')][0x3]);if(!_0x226dd0[_0xbf06('0x63')]){throw new Error(_0xbf06('0x8f'));}var _0xc46473=0x0;if(_0x226dd0['binding'][_0xbf06('0x39')]){_0xc46473=0x1;}if(!_0x226dd0['ListId']){throw new Error(_0xbf06('0x90'));}}catch(_0x5b6010){throw new Error(_0xbf06('0x91'));}var _0x40f3fb=[];try{_0x40f3fb=_[_0xbf06('0x92')](JSON[_0xbf06('0x93')](process[_0xbf06('0x8b')][0x4]),'id');}catch(_0x41959d){logger['info']('No\x20agent\x20available');}main(_0xd83c0e,_0x226dd0,_0x40f3fb,_0xc46473);}validate();process['on']('SIGINT',handleStop);process['on'](_0xbf06('0x94'),handleUncaughtException);
git://repos.xcallymotion.com / motion2.git / blob