// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x16e4=['util','bluebird','moment','ioredis','../../../config/environment','../../../config/logger','redis','defaults','localhost','socket.io-emitter','format','YYYY-MM-DD\x20HH:mm:ss','field','phone','from','.id\x20=\x20','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','join','CmContact','findAll','AdditionalPhones','then','length','push','all','split','filter','CmContactHasItem','findOne','update','updated','PHONE','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','into','cm_hopper','fromQuery','scheduledat','ContactId','createdAt','UserId','recallme','select','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','.CmListId\x20=\x20?','\x22always\x22','cm_contacts.phone\x20NOT\x20IN\x20(?)','cm_contacts.createdAt','insert','ListId','updatedAt','cm_contacts.createdAt\x20=\x20?','cm_hopper_black','ListId\x20=\x20?','toString','cm_hopper.id','cm_contact_has_items.OrderBy','cm_contact_has_items.updatedAt','CmHopperId','OrderBy','cm_contact_has_items','concat','keys',')\x20NOT\x20IN\x20?','deletedAt\x20IS\x20NULL','id\x20IN\x20?','MIN(id)','min_id','group','info','Received\x20SIGINT','error','message','exit','errors','code','sequelize','catch','main','send','start','binding','socket_timestamp','.csv','body','ContactItemType','name','header','writeFileSync','parse','createReadStream','data','rows','_description','isNil','hasOwnProperty','trim','replace','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','priority','isNaN','isNumber','agent\x20not\x20exists','email','dateOfBirth','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','\x20not\x20specified','find','itemTypeId','description','SystemRow','emit','contact:import:','Abort\x20parser','abort','SystemError','duplicates','cm_contacts_','\x20LIKE\x20cm_contacts;','LOAD\x20DATA\x20LOCAL\x20INFILE\x20\x27%s\x27\x20INTO\x20TABLE\x20%s\x20CHARACTER\x20SET\x20UTF8\x20FIELDS\x20TERMINATED\x20BY\x20\x27,\x27\x20ENCLOSED\x20BY\x20\x27\x22\x27\x20LINES\x20TERMINATED\x20BY\x20\x27\x0a\x27\x20IGNORE\x201\x20ROWS\x20(%s)\x20SET\x20id\x20=\x20NULL,\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27','CompanyId','contactTypeId','orderBy','voice_queues','voice_queues_has_cm_blacklists','VoiceQueueId','campaigns_has_cm_blacklists','campaigns','CampaignId','each','affectedRows','unlink','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','file\x20doesn\x27t\x20exists','phone\x20is\x20mandatory','firstName\x20is\x20mandatory','ListId\x20is\x20mandatory','map','SIGINT','path','lodash','papaparse'];(function(_0x310c2a,_0x107e39){var _0x12fb8f=function(_0xa79051){while(--_0xa79051){_0x310c2a['push'](_0x310c2a['shift']());}};_0x12fb8f(++_0x107e39);}(_0x16e4,0x97));var _0x416e=function(_0x34d15d,_0x2ff211){_0x34d15d=_0x34d15d-0x0;var _0x34f1fc=_0x16e4[_0x34d15d];return _0x34f1fc;};'use strict';var fs=require('fs');var path=require(_0x416e('0x0'));var _=require(_0x416e('0x1'));var Papa=require(_0x416e('0x2'));var util=require(_0x416e('0x3'));var BPromise=require(_0x416e('0x4'));var moment=require(_0x416e('0x5'));var squel=require('squel');var Redis=require(_0x416e('0x6'));var db=require('../../../mysqldb')['db'];var config=require(_0x416e('0x7'));var logger=require(_0x416e('0x8'))('import');config[_0x416e('0x9')]=_[_0x416e('0xa')](config[_0x416e('0x9')],{'host':_0x416e('0xb'),'port':0x18eb});var socket=require(_0x416e('0xc'))(new Redis(config[_0x416e('0x9')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()[_0x416e('0xd')](_0x416e('0xe'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];function isEmail(_0x3b5877){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'](_0x3b5877);}function selectNotIn(_0x86c7f2,_0x541e74,_0x286d17,_0x14bbf6,_0x13bcd0){return squel['select']()[_0x416e('0xf')](_0x416e('0x10'))[_0x416e('0x11')](_0x14bbf6)['join'](_0x541e74,null,_0x541e74+_0x416e('0x12')+_0x14bbf6+'.'+_0x286d17)['where'](_0x14bbf6+'.'+_0x286d17+_0x416e('0x13')+_0x86c7f2+'.'+_0x286d17)[_0x416e('0x14')](_0x541e74+_0x416e('0x15')+_0x13bcd0[_0x416e('0x16')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x507d36,_0x2684d0){promisesAdditionalPhones=[];return db[_0x416e('0x17')][_0x416e('0x18')]({'raw':!![],'attributes':['id',_0x416e('0x19')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})[_0x416e('0x1a')](function(_0x253c30){if(_0x253c30!==null){var _0x30ead5=[];for(var _0x162420=0x0;_0x162420<_0x253c30[_0x416e('0x1b')];_0x162420++){var _0x5624ab=_0x253c30[_0x162420];_0x30ead5['push'](insertAdditionalPhones(_0x5624ab));}}Promise['all'](_0x30ead5)[_0x416e('0x1a')](function(){_0x507d36({'val':0x1});});});});}function insertAdditionalPhones(_0x3f8b53){return new Promise(function(_0x268ad1,_0x467e88){var _0x4ed9fc=_0x3f8b53[_0x416e('0x19')];var _0x27d249=_0x4ed9fc['split'](';');var _0x2ce23e=[];orderBy=0x0;for(var _0x41a9a8=0x0;_0x41a9a8<_0x27d249[_0x416e('0x1b')];_0x41a9a8++){_0x2ce23e[_0x416e('0x1c')](splitAdditionalPhone(_0x3f8b53['id'],_0x27d249[_0x41a9a8]));}Promise[_0x416e('0x1d')](_0x2ce23e)[_0x416e('0x1a')](function(){_0x268ad1({'val':_0x27d249[_0x416e('0x1b')]});});});}function splitAdditionalPhone(_0x1134ee,_0x3f6c1d){return new Promise(function(_0x1aea5e,_0x61de2b){var _0x5442bc=_0x3f6c1d[_0x416e('0x1e')](':');var _0x1f062f=_0x5442bc[0x0];var _0x3d197c=_0x5442bc[0x1];if(_0x3d197c!==''){var _0x41e5e8=_0x3d197c[_0x416e('0x1e')]('|');var _0x6392f3=[];for(var _0x4a2e9c=0x0;_0x4a2e9c<_0x41e5e8[_0x416e('0x1b')];_0x4a2e9c++){if(_0x41e5e8[_0x4a2e9c]!==''){var _0x3bbbad=_[_0x416e('0x1f')](promisesAdditionalPhones,{'contactId':_0x1134ee,'phone':_0x41e5e8[_0x4a2e9c]});if(_0x3bbbad['length']==0x0){orderBy++;promisesAdditionalPhones[_0x416e('0x1c')]({'contactId':_0x1134ee,'contactTypeId':_0x1f062f,'phone':_0x41e5e8[_0x4a2e9c],'orderBy':orderBy});}}}_0x1aea5e({'ok':0x1});}else _0x1aea5e({'res':0x0});});}function createAdditionalPhone(_0x11af15,_0x47679a,_0x6cb20a,_0x4ab2f2){var _0x17fe69='';var _0x3fa936='';var _0x3ab2fd=_0x6cb20a[_0x416e('0x1e')]('§');_0x17fe69=_0x3ab2fd[0x0];if(_0x3ab2fd[_0x416e('0x1b')]==0x2)_0x3fa936=_0x3ab2fd[0x1];return new Promise(function(_0x13a953,_0x117e11){return db[_0x416e('0x20')][_0x416e('0x21')]({'where':{'CmContactId':_0x11af15,'item':_0x17fe69}})['then'](function(_0x8b147f){if(_0x8b147f){return db[_0x416e('0x20')][_0x416e('0x22')]({'ItemTypeId':_0x47679a,'description':_0x3fa936,'OrderBy':_0x4ab2f2},{'where':{'CmContactId':_0x11af15,'item':_0x17fe69}})[_0x416e('0x1a')](function(_0x2ce7ea){_0x13a953({'res':_0x416e('0x23')});});}else{return db[_0x416e('0x20')]['create']({'CmContactId':_0x11af15,'item':_0x17fe69,'description':_0x3fa936,'ItemTypeId':_0x47679a,'OrderBy':_0x4ab2f2,'ItemClass':_0x416e('0x24')})[_0x416e('0x1a')](function(_0x415c25){_0x13a953({'res':'inserted'});});}});});}function insertCmHopper(_0x429f9a,_0x1c0888,_0x183213,_0x310702,_0x4206b6){var _0x3a0c55=[_0x416e('0x25'),_0x416e('0x26'),_0x416e('0x27'),_0x416e('0x28'),_0x1c0888+'.'+_0x310702,'cm_contacts.createdAt',_0x416e('0x29'),_0x416e('0x2a'),_0x416e('0x2b'),'\x22'+_0x4206b6+'\x22'];return squel['insert']()[_0x416e('0x2c')](_0x416e('0x2d'))[_0x416e('0x2e')](['phone',_0x416e('0x2f'),_0x416e('0x30'),'ListId',_0x310702,_0x416e('0x31'),'updatedAt','priority',_0x416e('0x32'),_0x416e('0x33')],squel[_0x416e('0x34')]()[_0x416e('0x35')](_0x3a0c55)[_0x416e('0x11')](_0x1c0888)[_0x416e('0x16')](_0x416e('0x36'),null,_0x416e('0x37')+_0x1c0888+_0x416e('0x38'))['join'](_0x183213,null,_0x183213+_0x416e('0x12')+_0x1c0888+'.'+_0x310702)['where'](_0x1c0888+_0x416e('0x39'),_0x429f9a)[_0x416e('0x14')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0x416e('0x14')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x1c0888,_0x183213,_0x310702,_0x416e('0x2d'),[_0x416e('0x3a'),'\x22onlyIfOpen\x22']))[_0x416e('0x14')](_0x416e('0x3b'),selectNotIn(_0x1c0888,_0x183213,_0x310702,_0x416e('0x2d'),['\x22always\x22'])))['toString']();}function insertCmHopperBlack(_0x4e6f26,_0x41630f,_0x28e709,_0x379990){var _0x3805c6=[_0x416e('0x25'),_0x416e('0x27'),_0x416e('0x28'),_0x41630f+'.'+_0x379990,_0x416e('0x3c'),_0x416e('0x29')];return squel[_0x416e('0x3d')]()[_0x416e('0x2c')]('cm_hopper_black')[_0x416e('0x2e')](['phone','ContactId',_0x416e('0x3e'),_0x379990,_0x416e('0x31'),_0x416e('0x3f')],squel[_0x416e('0x34')]()[_0x416e('0x35')](_0x3805c6)[_0x416e('0x11')](_0x41630f)['join']('cm_contacts',null,_0x416e('0x37')+_0x41630f+_0x416e('0x38'))['join'](_0x28e709,null,_0x28e709+'.id\x20=\x20'+_0x41630f+'.'+_0x379990)[_0x416e('0x14')](_0x41630f+_0x416e('0x39'),_0x4e6f26)[_0x416e('0x14')](_0x416e('0x40'),NOW)[_0x416e('0x14')](_0x416e('0x3b'),squel[_0x416e('0x34')]()[_0x416e('0xf')](_0x416e('0x10'))[_0x416e('0x11')](_0x416e('0x41'))[_0x416e('0x14')](_0x416e('0x42'),_0x4e6f26)[_0x416e('0x14')](_0x379990+'\x20=\x20?',_0x41630f+'.'+_0x379990)))[_0x416e('0x43')]();}function insertCmHopperAdditionalPhones(_0x123b0d){var _0x5ed9bb=[_0x416e('0x44'),'cm_contact_has_items.item',_0x416e('0x45'),'cm_contact_has_items.createdAt',_0x416e('0x46')];return squel['insert']()['into']('cm_hopper_additional_phones')[_0x416e('0x2e')]([_0x416e('0x47'),_0x416e('0x10'),_0x416e('0x48'),_0x416e('0x31'),_0x416e('0x3f')],squel[_0x416e('0x34')]()['fields'](_0x5ed9bb)[_0x416e('0x11')](_0x416e('0x2d'))['join'](_0x416e('0x36'),null,'cm_contacts.id\x20=\x20cm_hopper.ContactId')[_0x416e('0x16')](_0x416e('0x49'),null,'cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId')[_0x416e('0x14')]('cm_hopper.ListId\x20=\x20?',_0x123b0d)['where'](_0x416e('0x40'),NOW))[_0x416e('0x43')]();}function insertCmContact(_0x14d8c6,_0x40f42e,_0x138cce,_0x83a3ed){var _0x577bfd=_[_0x416e('0x4a')](_[_0x416e('0x4b')](_0x83a3ed),[_0x416e('0x3e'),'CompanyId',_0x416e('0x31'),_0x416e('0x3f')]);return squel['insert']()[_0x416e('0x2c')]('cm_contacts')['fromQuery'](_0x577bfd,squel['select']()[_0x416e('0x35')](_0x577bfd)['from'](_0x40f42e)[_0x416e('0x14')]('('+_0x138cce[_0x416e('0x16')](',')+_0x416e('0x4c'),squel[_0x416e('0x34')]()[_0x416e('0x35')](_0x138cce)['from'](_0x416e('0x36'))[_0x416e('0x14')](_0x416e('0x42'),_0x14d8c6)[_0x416e('0x14')](_0x416e('0x4d')))['where'](_0x416e('0x4e'),squel[_0x416e('0x34')]()[_0x416e('0xf')](_0x416e('0x4f'),_0x416e('0x50'))[_0x416e('0x11')](_0x40f42e)[_0x416e('0x51')](_0x138cce[_0x416e('0x16')](','))))[_0x416e('0x43')]();}function handleStop(){logger[_0x416e('0x52')](_0x416e('0x53'));stopped=!![];}function handleUncaughtException(_0x287a44){logger[_0x416e('0x54')](_0x287a44[_0x416e('0x55')]);process[_0x416e('0x56')](0x1);}function handleError(_0x3406e4,_0x4acf9c){stats[_0x416e('0x57')][_0x416e('0x1c')]({'name':_0x4acf9c[_0x416e('0x58')],'message':_0x4acf9c[_0x416e('0x55')],'row':_0x3406e4});}function handleQuery(_0x13c62b){logger[_0x416e('0x52')](_0x13c62b);return db[_0x416e('0x59')]['query'](_0x13c62b)['spread'](function(_0x2bd9b4){results['push'](_0x2bd9b4);})[_0x416e('0x5a')](function(_0x4dd6c5){logger['error'](_0x4dd6c5[_0x416e('0x55')]);});}function main(_0x331a97,_0x5518f5,_0x371527,_0x37c1e9){logger[_0x416e('0x52')](_0x416e('0x5b'),_0x331a97,JSON['stringify'](_0x5518f5));process[_0x416e('0x5c')](_0x416e('0x5d'));var _0x58efb0=_0x5518f5[_0x416e('0x5e')];var _0x5c7fef=_['clone'](_0x58efb0);var _0x81eb29=_0x5518f5[_0x416e('0x5f')];var _0x2b998e=path[_0x416e('0x16')](config['root'],'server/files/tmp',_0x81eb29+_0x416e('0x60'));logger['info'](_0x416e('0x61'),_0x5518f5);db[_0x416e('0x62')]['findAll']({'raw':!![],'attributes':['id',_0x416e('0x63')]})[_0x416e('0x1a')](function(_0x4bec6b){for(var _0x1d48f0=0x0;_0x1d48f0<_0x4bec6b[_0x416e('0x1b')];_0x1d48f0++){if(_0x4bec6b[_0x1d48f0][_0x416e('0x63')]in _0x58efb0){contactItemTypes[_0x416e('0x1c')](_0x4bec6b[_0x1d48f0]);delete _0x5c7fef[_0x4bec6b[_0x1d48f0][_0x416e('0x63')]];hasAdditionalPhones=!![];}for(var _0x323745 in _0x58efb0){if(_0x4bec6b[_0x1d48f0]['name']+'_description'===_0x323745){phoneDescriptions[_0x416e('0x1c')]({'itemTypeId':_0x4bec6b[_0x1d48f0]['id'],'description':_0x323745});delete _0x5c7fef[_0x323745];}}}if(hasAdditionalPhones)_0x5c7fef['AdditionalPhones']='';var _0x289272=_[_0x416e('0x4b')](_0x5c7fef)['join']();logger[_0x416e('0x52')](_0x416e('0x64'),_0x289272);fs[_0x416e('0x65')](_0x2b998e,_0x289272+'\x0a');Papa[_0x416e('0x66')](fs[_0x416e('0x67')](_0x331a97),{'header':!![],'skipEmptyLines':!![],'step':function(_0x41ddfa,_0x325570){try{for(var _0x11763b=0x0,_0x14e475=[];_0x11763b<_0x41ddfa[_0x416e('0x68')][_0x416e('0x1b')];_0x11763b++){stats[_0x416e('0x69')]+=0x1;if(_0x41ddfa[_0x416e('0x57')][_0x11763b]){handleError(_0x41ddfa[_0x416e('0x68')][_0x11763b],_0x41ddfa['errors'][_0x11763b]);}else{var _0x319268=[];var _0x10e17a=[];var _0x3e1692={};for(var _0x4b4e7a in _0x58efb0){let _0x599b73=contactItemTypes['find'](_0x4f9046=>_0x4f9046[_0x416e('0x63')]===_0x4b4e7a);let _0x50d516=contactItemTypes['find'](_0x27f3db=>_0x27f3db[_0x416e('0x63')]+_0x416e('0x6a')===_0x4b4e7a);if(_[_0x416e('0x6b')](_0x599b73)&&_['isNil'](_0x50d516)){if(_0x58efb0[_0x416e('0x6c')](_0x4b4e7a)){if(_0x41ddfa[_0x416e('0x68')][_0x11763b][_0x58efb0[_0x4b4e7a]]){var _0x143960=_[_0x416e('0x6d')](_0x41ddfa[_0x416e('0x68')][_0x11763b][_0x58efb0[_0x4b4e7a]][_0x416e('0x6e')](/"/g,'\x27'));switch(_0x4b4e7a){case _0x416e('0x2f'):var _0x2e5e0b=moment(_0x143960,_0x416e('0xe'),!![]);if(_0x2e5e0b[_0x416e('0x6f')]()){_0x14e475[_0x416e('0x1c')]('\x22'+_0x143960+'\x22');}else{_0x319268[_0x416e('0x1c')](_0x416e('0x70'));}break;case _0x416e('0x71'):var _0xb1f753=parseInt(_0x143960);_0x143960=_[_0x416e('0x72')](_0xb1f753)||_0xb1f753<0x0||_0xb1f753>0x4?_0x37c1e9?0x3:0x2:_0xb1f753;_0x14e475[_0x416e('0x1c')]('\x22'+_0x143960+'\x22');break;case _0x416e('0x32'):var _0x3e8552=parseInt(_0x143960);if(_[_0x416e('0x73')](_0x3e8552)&&_['includes'](_0x371527,_0x3e8552)){_0x14e475[_0x416e('0x1c')]('\x22'+_0x3e8552+'\x22');}else{_0x319268[_0x416e('0x1c')](_0x416e('0x74'));}break;case _0x416e('0x75'):if(isEmail(_0x143960)){_0x14e475[_0x416e('0x1c')]('\x22'+_0x143960+'\x22');}else{_0x319268[_0x416e('0x1c')]('email\x20wrong\x20format');}break;case _0x416e('0x76'):var _0x20491e=moment(_0x143960,'YYYY-MM-DD',!![]);if(_0x20491e[_0x416e('0x6f')]()){_0x14e475[_0x416e('0x1c')]('\x22'+_0x143960+'\x22');}else{_0x319268[_0x416e('0x1c')](_0x416e('0x77'));}break;default:_0x14e475[_0x416e('0x1c')]('\x22'+_0x143960+'\x22');}}else{switch(_0x4b4e7a){case'firstName':case _0x416e('0x10'):_0x319268[_0x416e('0x1c')](_0x4b4e7a+_0x416e('0x78'));break;default:_0x14e475[_0x416e('0x1c')]('\x22\x22');}}}}else{var _0x695fd0='';if(!_[_0x416e('0x6b')](_0x599b73)){if(!_0x3e1692[_0x416e('0x6c')](_0x599b73['id'])){for(var _0xe4c98f=0x0;_0xe4c98f<_0x58efb0[_0x4b4e7a]['length'];_0xe4c98f++){var _0x143960=_[_0x416e('0x6d')](_0x41ddfa[_0x416e('0x68')][_0x11763b][_0x58efb0[_0x4b4e7a][_0xe4c98f]][_0x416e('0x6e')](/"/g,'\x27'));var _0x52a099=phoneDescriptions[_0x416e('0x79')](_0x386cc2=>_0x386cc2[_0x416e('0x7a')]===_0x599b73['id']);if(!_[_0x416e('0x6b')](_0x52a099)){var _0x590456=_[_0x416e('0x6d')](_0x41ddfa[_0x416e('0x68')][_0x11763b][_0x58efb0[_0x52a099[_0x416e('0x7b')]][0x0]][_0x416e('0x6e')](/"/g,'\x27'));if(!_[_0x416e('0x6b')](_0x590456))_0x143960=_0x143960+'§'+_0x590456;}if(_0x695fd0=='')_0x695fd0=_0x143960;else _0x695fd0+='|'+_0x143960;}_0x10e17a[_0x416e('0x1c')](_0x599b73['id']+':'+_0x695fd0);_0x3e1692[_0x599b73['id']]=0x1;}}}}if(hasAdditionalPhones){_0x14e475['push']('\x22'+_0x10e17a[_0x416e('0x16')](';')+'\x22');}if(_0x319268[_0x416e('0x1b')]){handleError(_0x41ddfa[_0x416e('0x68')][_0x11763b],{'code':_0x416e('0x7c'),'message':_0x319268[_0x416e('0x16')]()});}else{fs['appendFileSync'](_0x2b998e,_0x14e475[_0x416e('0x16')]()+'\x0a');}_0x14e475=[];}if(!(stats[_0x416e('0x69')]%0xc8)){socket[_0x416e('0x7d')](_0x416e('0x7e')+_0x81eb29,stats);stats[_0x416e('0x57')]=[];}}if(stopped){logger['info'](_0x416e('0x7f'));_0x325570[_0x416e('0x80')]();}}catch(_0x5ada69){handleError(_0x41ddfa[_0x416e('0x68')][_0x11763b],{'code':_0x416e('0x81'),'message':_0x5ada69[_0x416e('0x55')]});logger[_0x416e('0x54')]('step',_0x5ada69['message']);}},'complete':function(){try{var _0x3d2f6e=[];var _0x3eda52=_0x416e('0x36');if(_0x5518f5[_0x416e('0x82')]&&_0x5518f5['duplicates'][_0x416e('0x1b')]){_0x3eda52=_0x416e('0x83')+_0x81eb29;_0x3d2f6e[_0x416e('0x1c')]('CREATE\x20TABLE\x20'+_0x3eda52+_0x416e('0x84'));}logger[_0x416e('0x52')]('CIS\x20len',contactItemTypes[_0x416e('0x1b')]);var _0x20a603=util[_0x416e('0xd')](_0x416e('0x85'),_0x2b998e,_0x3eda52,_0x289272,_0x5518f5['ListId'],_0x5518f5[_0x416e('0x86')]||null,NOW,NOW);if(_[_0x416e('0x6b')](_0x58efb0[_0x416e('0x2f')])){_0x20a603+=',\x20scheduledAt\x20=\x20NOW()';}_0x3d2f6e[_0x416e('0x1c')](_0x20a603);if(_0x5518f5[_0x416e('0x82')]&&_0x5518f5[_0x416e('0x82')][_0x416e('0x1b')]){_0x3d2f6e['push'](insertCmContact(_0x5518f5[_0x416e('0x3e')],_0x3eda52,_0x5518f5[_0x416e('0x82')],_0x58efb0));_0x3d2f6e[_0x416e('0x1c')]('DROP\x20TABLE\x20'+_0x3eda52+';');}BPromise['each'](_0x3d2f6e,handleQuery)[_0x416e('0x1a')](function(_0xde63b){BPromise[_0x416e('0x1d')]([handleAdditionalPhones()])[_0x416e('0x1a')](function(){_0x3d2f6e=[];for(var _0x30820c=0x0;_0x30820c<promisesAdditionalPhones[_0x416e('0x1b')];_0x30820c++){_0x3d2f6e['push'](createAdditionalPhone(promisesAdditionalPhones[_0x30820c]['contactId'],promisesAdditionalPhones[_0x30820c][_0x416e('0x87')],promisesAdditionalPhones[_0x30820c][_0x416e('0x10')],promisesAdditionalPhones[_0x30820c][_0x416e('0x88')]));}BPromise[_0x416e('0x1d')](_0x3d2f6e)[_0x416e('0x1a')](function(){_0x3d2f6e=[];_0x3d2f6e[_0x416e('0x1c')](insertCmHopper(_0x5518f5[_0x416e('0x3e')],'voice_queues_has_cm_lists',_0x416e('0x89'),'VoiceQueueId',_0x37c1e9));_0x3d2f6e['push'](insertCmHopperBlack(_0x5518f5[_0x416e('0x3e')],_0x416e('0x8a'),_0x416e('0x89'),_0x416e('0x8b')));_0x3d2f6e['push'](insertCmHopper(_0x5518f5[_0x416e('0x3e')],'campaigns_has_cm_lists','campaigns','CampaignId',_0x37c1e9));_0x3d2f6e[_0x416e('0x1c')](insertCmHopperBlack(_0x5518f5[_0x416e('0x3e')],_0x416e('0x8c'),_0x416e('0x8d'),_0x416e('0x8e')));_0x3d2f6e['push'](insertCmHopperAdditionalPhones(_0x5518f5[_0x416e('0x3e')]));BPromise[_0x416e('0x8f')](_0x3d2f6e,handleQuery)['then'](function(_0x42f262){stats['finish']=!![];stats['affectedRows']=_0x5518f5['duplicates']&&_0x5518f5[_0x416e('0x82')]['length']?results[0x2]['affectedRows']:results[0x0][_0x416e('0x90')];socket['emit'](_0x416e('0x7e')+_0x81eb29,stats);fs['unlink'](_0x331a97);fs[_0x416e('0x91')](_0x2b998e);process[_0x416e('0x56')](0x0);})[_0x416e('0x5a')](function(_0x9de708){logger['error'](_0x9de708[_0x416e('0x55')]);process[_0x416e('0x56')](0x1);});});});})[_0x416e('0x5a')](function(_0x1c50f1){logger[_0x416e('0x54')](_0x1c50f1['message']);process[_0x416e('0x56')](0x1);});}catch(_0x54b4ce){logger[_0x416e('0x54')]('complete',_0x54b4ce[_0x416e('0x55')]);process[_0x416e('0x56')](0x1);}},'error':function(_0x15e11d,_0x500574,_0x3b4a53,_0x4eb737){throw new Error(_0x4eb737);}});});}function validate(){if(process[_0x416e('0x92')]&&process[_0x416e('0x92')][_0x416e('0x1b')]<0x4){throw new Error(_0x416e('0x93'));}var _0x40e5c8=path[_0x416e('0x16')](config['root'],'server/files/tmp',process['argv'][0x2]);if(!fs['existsSync'](_0x40e5c8)){throw new Error(_0x416e('0x94'));}var _0x1e5425={};try{_0x1e5425=JSON[_0x416e('0x66')](process[_0x416e('0x92')][0x3]);if(!_0x1e5425[_0x416e('0x5e')]){throw new Error('binding\x20doesn\x27t\x20exists');}if(!_0x1e5425[_0x416e('0x5e')]['phone']){throw new Error(_0x416e('0x95'));}if(!_0x1e5425[_0x416e('0x5e')]['firstName']){throw new Error(_0x416e('0x96'));}var _0x2a8bbf=0x0;if(_0x1e5425['binding'][_0x416e('0x32')]){_0x2a8bbf=0x1;}if(!_0x1e5425[_0x416e('0x3e')]){throw new Error(_0x416e('0x97'));}}catch(_0x318170){throw new Error('body\x20id\x20mandatory');}var _0x50f4ff=[];try{_0x50f4ff=_[_0x416e('0x98')](JSON['parse'](process['argv'][0x4]),'id');}catch(_0x39407d){logger[_0x416e('0x52')]('No\x20agent\x20available');}main(_0x40e5c8,_0x1e5425,_0x50f4ff,_0x2a8bbf);}validate();process['on'](_0x416e('0x99'),handleStop);process['on']('uncaughtException',handleUncaughtException);
\ No newline at end of file
+var _0xe79a=['recallme','cm_contacts','.CmListId','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','cm_hopper','\x22onlyIfOpen\x22','\x22always\x22','toString','cm_contacts.phone','cm_hopper_black','ContactId','ListId','fields','cm_contacts.ListId\x20=\x20','field','ListId\x20=\x20?','\x20=\x20?','cm_hopper.id','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','CmHopperId','cm_contact_has_items','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId',')\x20NOT\x20IN\x20?','deletedAt\x20IS\x20NULL','id\x20IN\x20?','MIN(id)','min_id','group','info','message','errors','query','error','send','binding','clone','socket_timestamp','root','server/files/tmp','ContactItemType','name','_description','writeFileSync','parse','createReadStream','data','find','isNil','hasOwnProperty','trim','replace','YYYY-MM-DD\x20HH:mm:ss','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','UserId','isNumber','agent\x20not\x20exists','email','email\x20wrong\x20format','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','itemTypeId','rows','emit','contact:import:','Abort\x20parser','abort','step','duplicates','cm_contacts_','CREATE\x20TABLE\x20','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\x20id\x20=\x20NULL,\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27',',\x20scheduledAt\x20=\x20NOW()','DROP\x20TABLE\x20','all','contactId','contactTypeId','voice_queues_has_cm_lists','voice_queues','VoiceQueueId','voice_queues_has_cm_blacklists','campaigns_has_cm_lists','campaigns','CampaignId','campaigns_has_cm_blacklists','finish','affectedRows','unlink','exit','catch','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','phone\x20is\x20mandatory','firstName\x20is\x20mandatory','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','SIGINT','uncaughtException','papaparse','bluebird','moment','squel','ioredis','../../../config/environment','../../../config/logger','import','defaults','redis','format','select','phone','from','join','.id\x20=\x20','where','\x20=\x20','.dialCheckDuplicateType\x20IN\x20(','CmContact','findAll','AdditionalPhones','then','length','push','split','filter','findOne','update','updated','CmContactHasItem','create','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','insert','into','fromQuery','scheduledat','createdAt','updatedAt','priority'];(function(_0x224dda,_0x16d0f9){var _0x2987ac=function(_0x3b1033){while(--_0x3b1033){_0x224dda['push'](_0x224dda['shift']());}};_0x2987ac(++_0x16d0f9);}(_0xe79a,0x70));var _0xae79=function(_0x17fd65,_0x556d01){_0x17fd65=_0x17fd65-0x0;var _0x27d033=_0xe79a[_0x17fd65];return _0x27d033;};'use strict';var fs=require('fs');var path=require('path');var _=require('lodash');var Papa=require(_0xae79('0x0'));var util=require('util');var BPromise=require(_0xae79('0x1'));var moment=require(_0xae79('0x2'));var squel=require(_0xae79('0x3'));var Redis=require(_0xae79('0x4'));var db=require('../../../mysqldb')['db'];var config=require(_0xae79('0x5'));var logger=require(_0xae79('0x6'))(_0xae79('0x7'));config['redis']=_[_0xae79('0x8')](config[_0xae79('0x9')],{'host':'localhost','port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xae79('0x9')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()[_0xae79('0xa')]('YYYY-MM-DD\x20HH:mm:ss');var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];function isEmail(_0x4043ff){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'](_0x4043ff);}function selectNotIn(_0x29307a,_0x5dce36,_0x4f4678,_0x8c0bf9,_0x3ab34b){return squel[_0xae79('0xb')]()['field'](_0xae79('0xc'))[_0xae79('0xd')](_0x8c0bf9)[_0xae79('0xe')](_0x5dce36,null,_0x5dce36+_0xae79('0xf')+_0x8c0bf9+'.'+_0x4f4678)[_0xae79('0x10')](_0x8c0bf9+'.'+_0x4f4678+_0xae79('0x11')+_0x29307a+'.'+_0x4f4678)[_0xae79('0x10')](_0x5dce36+_0xae79('0x12')+_0x3ab34b[_0xae79('0xe')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x471fbf,_0x478937){promisesAdditionalPhones=[];return db[_0xae79('0x13')][_0xae79('0x14')]({'raw':!![],'attributes':['id',_0xae79('0x15')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})[_0xae79('0x16')](function(_0x4c8f9a){if(_0x4c8f9a!==null){var _0x4e4615=[];for(var _0x101327=0x0;_0x101327<_0x4c8f9a[_0xae79('0x17')];_0x101327++){var _0x4c8a59=_0x4c8f9a[_0x101327];_0x4e4615[_0xae79('0x18')](insertAdditionalPhones(_0x4c8a59));}}Promise['all'](_0x4e4615)[_0xae79('0x16')](function(){_0x471fbf({'val':0x1});});});});}function insertAdditionalPhones(_0x44f55e){return new Promise(function(_0x124745,_0x371944){var _0x3474a0=_0x44f55e['AdditionalPhones'];var _0x432f0d=_0x3474a0[_0xae79('0x19')](';');var _0x348044=[];orderBy=0x0;for(var _0x23fd7d=0x0;_0x23fd7d<_0x432f0d[_0xae79('0x17')];_0x23fd7d++){_0x348044[_0xae79('0x18')](splitAdditionalPhone(_0x44f55e['id'],_0x432f0d[_0x23fd7d]));}Promise['all'](_0x348044)[_0xae79('0x16')](function(){_0x124745({'val':_0x432f0d[_0xae79('0x17')]});});});}function splitAdditionalPhone(_0x27b5fe,_0x533e63){return new Promise(function(_0xb0d047,_0x158ea2){var _0x5b6a8d=_0x533e63[_0xae79('0x19')](':');var _0x2d006d=_0x5b6a8d[0x0];var _0x173ded=_0x5b6a8d[0x1];if(_0x173ded!==''){var _0x3f8409=_0x173ded['split']('|');var _0x42fbbc=[];for(var _0x33f0c5=0x0;_0x33f0c5<_0x3f8409['length'];_0x33f0c5++){if(_0x3f8409[_0x33f0c5]!==''){var _0x5d4a57=_[_0xae79('0x1a')](promisesAdditionalPhones,{'contactId':_0x27b5fe,'phone':_0x3f8409[_0x33f0c5]});if(_0x5d4a57[_0xae79('0x17')]==0x0){orderBy++;promisesAdditionalPhones['push']({'contactId':_0x27b5fe,'contactTypeId':_0x2d006d,'phone':_0x3f8409[_0x33f0c5],'orderBy':orderBy});}}}_0xb0d047({'ok':0x1});}else _0xb0d047({'res':0x0});});}function createAdditionalPhone(_0x1e5101,_0x6a289b,_0x819255,_0x1621e0){var _0x5783e8='';var _0x1e8618='';var _0x504d65=_0x819255[_0xae79('0x19')]('§');_0x5783e8=_0x504d65[0x0];if(_0x504d65['length']==0x2)_0x1e8618=_0x504d65[0x1];return new Promise(function(_0x560e01,_0x43d306){return db['CmContactHasItem'][_0xae79('0x1b')]({'where':{'CmContactId':_0x1e5101,'item':_0x5783e8}})[_0xae79('0x16')](function(_0x480e7a){if(_0x480e7a){return db['CmContactHasItem'][_0xae79('0x1c')]({'ItemTypeId':_0x6a289b,'description':_0x1e8618,'OrderBy':_0x1621e0},{'where':{'CmContactId':_0x1e5101,'item':_0x5783e8}})[_0xae79('0x16')](function(_0x7281ce){_0x560e01({'res':_0xae79('0x1d')});});}else{return db[_0xae79('0x1e')][_0xae79('0x1f')]({'CmContactId':_0x1e5101,'item':_0x5783e8,'description':_0x1e8618,'ItemTypeId':_0x6a289b,'OrderBy':_0x1621e0,'ItemClass':'PHONE'})['then'](function(_0x36a0cf){_0x560e01({'res':'inserted'});});}});});}function insertCmHopper(_0x4693be,_0x34596b,_0x45e222,_0x271a78,_0x2b79ca){var _0x3eaca4=['cm_contacts.phone',_0xae79('0x20'),_0xae79('0x21'),_0xae79('0x22'),_0x34596b+'.'+_0x271a78,'cm_contacts.createdAt',_0xae79('0x23'),_0xae79('0x24'),_0xae79('0x25'),'\x22'+_0x2b79ca+'\x22'];return squel[_0xae79('0x26')]()[_0xae79('0x27')]('cm_hopper')[_0xae79('0x28')]([_0xae79('0xc'),_0xae79('0x29'),'ContactId','ListId',_0x271a78,_0xae79('0x2a'),_0xae79('0x2b'),_0xae79('0x2c'),'UserId',_0xae79('0x2d')],squel[_0xae79('0xb')]()['fields'](_0x3eaca4)[_0xae79('0xd')](_0x34596b)[_0xae79('0xe')](_0xae79('0x2e'),null,'cm_contacts.ListId\x20=\x20'+_0x34596b+_0xae79('0x2f'))[_0xae79('0xe')](_0x45e222,null,_0x45e222+_0xae79('0xf')+_0x34596b+'.'+_0x271a78)[_0xae79('0x10')](_0x34596b+_0xae79('0x30'),_0x4693be)['where'](_0xae79('0x31'),NOW)[_0xae79('0x10')](_0xae79('0x32'),selectNotIn(_0x34596b,_0x45e222,_0x271a78,_0xae79('0x33'),['\x22always\x22',_0xae79('0x34')]))[_0xae79('0x10')](_0xae79('0x32'),selectNotIn(_0x34596b,_0x45e222,_0x271a78,'cm_hopper',[_0xae79('0x35')])))[_0xae79('0x36')]();}function insertCmHopperBlack(_0x39fbce,_0x57658f,_0x19d6f1,_0xa6879){var _0x4d4de3=[_0xae79('0x37'),_0xae79('0x21'),_0xae79('0x22'),_0x57658f+'.'+_0xa6879,'cm_contacts.createdAt',_0xae79('0x23')];return squel[_0xae79('0x26')]()[_0xae79('0x27')](_0xae79('0x38'))[_0xae79('0x28')]([_0xae79('0xc'),_0xae79('0x39'),_0xae79('0x3a'),_0xa6879,'createdAt',_0xae79('0x2b')],squel['select']()[_0xae79('0x3b')](_0x4d4de3)[_0xae79('0xd')](_0x57658f)[_0xae79('0xe')](_0xae79('0x2e'),null,_0xae79('0x3c')+_0x57658f+_0xae79('0x2f'))['join'](_0x19d6f1,null,_0x19d6f1+_0xae79('0xf')+_0x57658f+'.'+_0xa6879)[_0xae79('0x10')](_0x57658f+_0xae79('0x30'),_0x39fbce)['where'](_0xae79('0x31'),NOW)['where'](_0xae79('0x32'),squel[_0xae79('0xb')]()[_0xae79('0x3d')](_0xae79('0xc'))[_0xae79('0xd')]('cm_hopper_black')[_0xae79('0x10')](_0xae79('0x3e'),_0x39fbce)[_0xae79('0x10')](_0xa6879+_0xae79('0x3f'),_0x57658f+'.'+_0xa6879)))[_0xae79('0x36')]();}function insertCmHopperAdditionalPhones(_0x205850){var _0x4edb81=[_0xae79('0x40'),'cm_contact_has_items.item',_0xae79('0x41'),_0xae79('0x42'),'cm_contact_has_items.updatedAt'];return squel[_0xae79('0x26')]()[_0xae79('0x27')]('cm_hopper_additional_phones')['fromQuery']([_0xae79('0x43'),_0xae79('0xc'),'OrderBy','createdAt',_0xae79('0x2b')],squel[_0xae79('0xb')]()[_0xae79('0x3b')](_0x4edb81)[_0xae79('0xd')]('cm_hopper')['join']('cm_contacts',null,'cm_contacts.id\x20=\x20cm_hopper.ContactId')[_0xae79('0xe')](_0xae79('0x44'),null,_0xae79('0x45'))[_0xae79('0x10')](_0xae79('0x46'),_0x205850)[_0xae79('0x10')](_0xae79('0x31'),NOW))[_0xae79('0x36')]();}function insertCmContact(_0x4fb503,_0x232654,_0x18f618,_0x552b48){var _0x17c561=_[_0xae79('0x47')](_[_0xae79('0x48')](_0x552b48),['ListId',_0xae79('0x49'),_0xae79('0x2a'),_0xae79('0x2b')]);return squel[_0xae79('0x26')]()['into']('cm_contacts')[_0xae79('0x28')](_0x17c561,squel[_0xae79('0xb')]()['fields'](_0x17c561)[_0xae79('0xd')](_0x232654)['where']('('+_0x18f618[_0xae79('0xe')](',')+_0xae79('0x4a'),squel[_0xae79('0xb')]()[_0xae79('0x3b')](_0x18f618)['from'](_0xae79('0x2e'))[_0xae79('0x10')]('ListId\x20=\x20?',_0x4fb503)[_0xae79('0x10')](_0xae79('0x4b')))[_0xae79('0x10')](_0xae79('0x4c'),squel['select']()[_0xae79('0x3d')](_0xae79('0x4d'),_0xae79('0x4e'))['from'](_0x232654)[_0xae79('0x4f')](_0x18f618['join'](','))))[_0xae79('0x36')]();}function handleStop(){logger[_0xae79('0x50')]('Received\x20SIGINT');stopped=!![];}function handleUncaughtException(_0x5913c3){logger['error'](_0x5913c3[_0xae79('0x51')]);process['exit'](0x1);}function handleError(_0x22a1cf,_0xfa8720){stats[_0xae79('0x52')][_0xae79('0x18')]({'name':_0xfa8720['code'],'message':_0xfa8720[_0xae79('0x51')],'row':_0x22a1cf});}function handleQuery(_0x49b890){logger[_0xae79('0x50')](_0x49b890);return db['sequelize'][_0xae79('0x53')](_0x49b890)['spread'](function(_0x55ca9b){results[_0xae79('0x18')](_0x55ca9b);})['catch'](function(_0x36ff25){logger[_0xae79('0x54')](_0x36ff25['message']);});}function main(_0x5923a0,_0x3f86bf,_0x4cfb05,_0x29ce2e){logger[_0xae79('0x50')]('main',_0x5923a0,JSON['stringify'](_0x3f86bf));process[_0xae79('0x55')]('start');var _0x2d372c=_0x3f86bf[_0xae79('0x56')];var _0x3b49ed=_[_0xae79('0x57')](_0x2d372c);var _0x38403a=_0x3f86bf[_0xae79('0x58')];var _0x113144=path[_0xae79('0xe')](config[_0xae79('0x59')],_0xae79('0x5a'),_0x38403a+'.csv');logger['info']('body',_0x3f86bf);db[_0xae79('0x5b')][_0xae79('0x14')]({'raw':!![],'attributes':['id','name']})['then'](function(_0x10ad25){for(var _0x2e004c=0x0;_0x2e004c<_0x10ad25['length'];_0x2e004c++){if(_0x10ad25[_0x2e004c][_0xae79('0x5c')]in _0x2d372c){contactItemTypes[_0xae79('0x18')](_0x10ad25[_0x2e004c]);delete _0x3b49ed[_0x10ad25[_0x2e004c]['name']];hasAdditionalPhones=!![];}for(var _0x48ba34 in _0x2d372c){if(_0x10ad25[_0x2e004c]['name']+_0xae79('0x5d')===_0x48ba34){phoneDescriptions[_0xae79('0x18')]({'itemTypeId':_0x10ad25[_0x2e004c]['id'],'description':_0x48ba34});delete _0x3b49ed[_0x48ba34];}}}if(hasAdditionalPhones)_0x3b49ed[_0xae79('0x15')]='';var _0xdf0f68=_[_0xae79('0x48')](_0x3b49ed)[_0xae79('0xe')]();logger[_0xae79('0x50')]('header',_0xdf0f68);fs[_0xae79('0x5e')](_0x113144,_0xdf0f68+'\x0a');Papa[_0xae79('0x5f')](fs[_0xae79('0x60')](_0x5923a0),{'header':!![],'skipEmptyLines':!![],'step':function(_0x132f09,_0x47b289){try{for(var _0x10d34d=0x0,_0x53454a=[];_0x10d34d<_0x132f09[_0xae79('0x61')]['length'];_0x10d34d++){stats['rows']+=0x1;if(_0x132f09[_0xae79('0x52')][_0x10d34d]){handleError(_0x132f09[_0xae79('0x61')][_0x10d34d],_0x132f09[_0xae79('0x52')][_0x10d34d]);}else{var _0x486f37=[];var _0x39204d=[];var _0x43d3be={};for(var _0x3a4daa in _0x2d372c){let _0x4e271b=contactItemTypes[_0xae79('0x62')](_0x4259ac=>_0x4259ac[_0xae79('0x5c')]===_0x3a4daa);let _0xcfe968=contactItemTypes[_0xae79('0x62')](_0x1c28e6=>_0x1c28e6['name']+'_description'===_0x3a4daa);if(_[_0xae79('0x63')](_0x4e271b)&&_['isNil'](_0xcfe968)){if(_0x2d372c[_0xae79('0x64')](_0x3a4daa)){if(_0x132f09[_0xae79('0x61')][_0x10d34d][_0x2d372c[_0x3a4daa]]){var _0x2dc106=_[_0xae79('0x65')](_0x132f09['data'][_0x10d34d][_0x2d372c[_0x3a4daa]][_0xae79('0x66')](/"/g,'\x27'));switch(_0x3a4daa){case _0xae79('0x29'):var _0x544f8b=moment(_0x2dc106,_0xae79('0x67'),!![]);if(_0x544f8b[_0xae79('0x68')]()){_0x53454a['push']('\x22'+_0x2dc106+'\x22');}else{_0x486f37[_0xae79('0x18')](_0xae79('0x69'));}break;case _0xae79('0x2c'):var _0x47e754=parseInt(_0x2dc106);_0x2dc106=_['isNaN'](_0x47e754)||_0x47e754<0x0||_0x47e754>0x4?_0x29ce2e?0x3:0x2:_0x47e754;_0x53454a[_0xae79('0x18')]('\x22'+_0x2dc106+'\x22');break;case _0xae79('0x6a'):var _0x1f015e=parseInt(_0x2dc106);if(_[_0xae79('0x6b')](_0x1f015e)&&_['includes'](_0x4cfb05,_0x1f015e)){_0x53454a[_0xae79('0x18')]('\x22'+_0x1f015e+'\x22');}else{_0x486f37['push'](_0xae79('0x6c'));}break;case _0xae79('0x6d'):if(isEmail(_0x2dc106)){_0x53454a['push']('\x22'+_0x2dc106+'\x22');}else{_0x486f37[_0xae79('0x18')](_0xae79('0x6e'));}break;case'dateOfBirth':var _0x2b99a3=moment(_0x2dc106,_0xae79('0x6f'),!![]);if(_0x2b99a3[_0xae79('0x68')]()){_0x53454a[_0xae79('0x18')]('\x22'+_0x2dc106+'\x22');}else{_0x486f37[_0xae79('0x18')](_0xae79('0x70'));}break;default:_0x53454a[_0xae79('0x18')]('\x22'+_0x2dc106+'\x22');}}else{switch(_0x3a4daa){case _0xae79('0x71'):case _0xae79('0xc'):_0x486f37[_0xae79('0x18')](_0x3a4daa+_0xae79('0x72'));break;default:_0x53454a[_0xae79('0x18')]('\x22\x22');}}}}else{var _0x587ffd='';if(!_['isNil'](_0x4e271b)){if(!_0x43d3be[_0xae79('0x64')](_0x4e271b['id'])){for(var _0x3977ac=0x0;_0x3977ac<_0x2d372c[_0x3a4daa][_0xae79('0x17')];_0x3977ac++){var _0x2dc106=_[_0xae79('0x65')](_0x132f09[_0xae79('0x61')][_0x10d34d][_0x2d372c[_0x3a4daa][_0x3977ac]]['replace'](/"/g,'\x27'));var _0x4d1c87=phoneDescriptions[_0xae79('0x62')](_0xa4ca14=>_0xa4ca14[_0xae79('0x73')]===_0x4e271b['id']);if(!_[_0xae79('0x63')](_0x4d1c87)){var _0x272d84=_[_0xae79('0x65')](_0x132f09[_0xae79('0x61')][_0x10d34d][_0x2d372c[_0x4d1c87['description']][0x0]][_0xae79('0x66')](/"/g,'\x27'));if(!_[_0xae79('0x63')](_0x272d84))_0x2dc106=_0x2dc106+'§'+_0x272d84;}if(_0x587ffd=='')_0x587ffd=_0x2dc106;else _0x587ffd+='|'+_0x2dc106;}_0x39204d[_0xae79('0x18')](_0x4e271b['id']+':'+_0x587ffd);_0x43d3be[_0x4e271b['id']]=0x1;}}}}if(hasAdditionalPhones){_0x53454a[_0xae79('0x18')]('\x22'+_0x39204d[_0xae79('0xe')](';')+'\x22');}if(_0x486f37[_0xae79('0x17')]){handleError(_0x132f09[_0xae79('0x61')][_0x10d34d],{'code':'SystemRow','message':_0x486f37[_0xae79('0xe')]()});}else{fs['appendFileSync'](_0x113144,_0x53454a[_0xae79('0xe')]()+'\x0a');}_0x53454a=[];}if(!(stats[_0xae79('0x74')]%0xc8)){socket[_0xae79('0x75')](_0xae79('0x76')+_0x38403a,stats);stats[_0xae79('0x52')]=[];}}if(stopped){logger[_0xae79('0x50')](_0xae79('0x77'));_0x47b289[_0xae79('0x78')]();}}catch(_0x538569){handleError(_0x132f09[_0xae79('0x61')][_0x10d34d],{'code':'SystemError','message':_0x538569[_0xae79('0x51')]});logger[_0xae79('0x54')](_0xae79('0x79'),_0x538569[_0xae79('0x51')]);}},'complete':function(){try{var _0x4f2921=[];var _0x479b5f=_0xae79('0x2e');if(_0x3f86bf[_0xae79('0x7a')]&&_0x3f86bf[_0xae79('0x7a')]['length']){_0x479b5f=_0xae79('0x7b')+_0x38403a;_0x4f2921[_0xae79('0x18')](_0xae79('0x7c')+_0x479b5f+'\x20LIKE\x20cm_contacts;');}logger[_0xae79('0x50')](_0xae79('0x7d'),contactItemTypes[_0xae79('0x17')]);var _0x707284=util['format'](_0xae79('0x7e'),_0x113144,_0x479b5f,_0xdf0f68,_0x3f86bf[_0xae79('0x3a')],_0x3f86bf[_0xae79('0x49')]||null,NOW,NOW);if(_[_0xae79('0x63')](_0x2d372c[_0xae79('0x29')])){_0x707284+=_0xae79('0x7f');}_0x4f2921[_0xae79('0x18')](_0x707284);if(_0x3f86bf[_0xae79('0x7a')]&&_0x3f86bf[_0xae79('0x7a')][_0xae79('0x17')]){_0x4f2921['push'](insertCmContact(_0x3f86bf[_0xae79('0x3a')],_0x479b5f,_0x3f86bf['duplicates'],_0x2d372c));_0x4f2921['push'](_0xae79('0x80')+_0x479b5f+';');}BPromise['each'](_0x4f2921,handleQuery)['then'](function(_0x317b7d){BPromise[_0xae79('0x81')]([handleAdditionalPhones()])[_0xae79('0x16')](function(){_0x4f2921=[];for(var _0x1c03e8=0x0;_0x1c03e8<promisesAdditionalPhones['length'];_0x1c03e8++){_0x4f2921[_0xae79('0x18')](createAdditionalPhone(promisesAdditionalPhones[_0x1c03e8][_0xae79('0x82')],promisesAdditionalPhones[_0x1c03e8][_0xae79('0x83')],promisesAdditionalPhones[_0x1c03e8]['phone'],promisesAdditionalPhones[_0x1c03e8]['orderBy']));}BPromise[_0xae79('0x81')](_0x4f2921)[_0xae79('0x16')](function(){_0x4f2921=[];_0x4f2921[_0xae79('0x18')](insertCmHopper(_0x3f86bf['ListId'],_0xae79('0x84'),_0xae79('0x85'),_0xae79('0x86'),_0x29ce2e));_0x4f2921['push'](insertCmHopperBlack(_0x3f86bf['ListId'],_0xae79('0x87'),_0xae79('0x85'),_0xae79('0x86')));_0x4f2921['push'](insertCmHopper(_0x3f86bf[_0xae79('0x3a')],_0xae79('0x88'),_0xae79('0x89'),_0xae79('0x8a'),_0x29ce2e));_0x4f2921['push'](insertCmHopperBlack(_0x3f86bf[_0xae79('0x3a')],_0xae79('0x8b'),'campaigns',_0xae79('0x8a')));_0x4f2921[_0xae79('0x18')](insertCmHopperAdditionalPhones(_0x3f86bf[_0xae79('0x3a')]));BPromise['each'](_0x4f2921,handleQuery)[_0xae79('0x16')](function(_0x2cb87c){stats[_0xae79('0x8c')]=!![];stats[_0xae79('0x8d')]=_0x3f86bf[_0xae79('0x7a')]&&_0x3f86bf[_0xae79('0x7a')]['length']?results[0x2][_0xae79('0x8d')]:results[0x0]['affectedRows'];socket[_0xae79('0x75')](_0xae79('0x76')+_0x38403a,stats);fs[_0xae79('0x8e')](_0x5923a0);fs[_0xae79('0x8e')](_0x113144);process[_0xae79('0x8f')](0x0);})[_0xae79('0x90')](function(_0x1ae837){logger[_0xae79('0x54')](_0x1ae837[_0xae79('0x51')]);process[_0xae79('0x8f')](0x1);});});});})[_0xae79('0x90')](function(_0x2b3b95){logger[_0xae79('0x54')](_0x2b3b95[_0xae79('0x51')]);process[_0xae79('0x8f')](0x1);});}catch(_0x5bc8ad){logger[_0xae79('0x54')]('complete',_0x5bc8ad[_0xae79('0x51')]);process[_0xae79('0x8f')](0x1);}},'error':function(_0x5957f0,_0x216f7e,_0x16135b,_0x5dfe03){throw new Error(_0x5dfe03);}});});}function validate(){if(process[_0xae79('0x91')]&&process[_0xae79('0x91')][_0xae79('0x17')]<0x4){throw new Error(_0xae79('0x92'));}var _0x19d6a6=path[_0xae79('0xe')](config[_0xae79('0x59')],_0xae79('0x5a'),process[_0xae79('0x91')][0x2]);if(!fs[_0xae79('0x93')](_0x19d6a6)){throw new Error(_0xae79('0x94'));}var _0x51d4a9={};try{_0x51d4a9=JSON[_0xae79('0x5f')](process['argv'][0x3]);if(!_0x51d4a9[_0xae79('0x56')]){throw new Error(_0xae79('0x95'));}if(!_0x51d4a9[_0xae79('0x56')][_0xae79('0xc')]){throw new Error(_0xae79('0x96'));}if(!_0x51d4a9[_0xae79('0x56')][_0xae79('0x71')]){throw new Error(_0xae79('0x97'));}var _0xf83d91=0x0;if(_0x51d4a9[_0xae79('0x56')]['UserId']){_0xf83d91=0x1;}if(!_0x51d4a9[_0xae79('0x3a')]){throw new Error(_0xae79('0x98'));}}catch(_0xb42ad3){throw new Error(_0xae79('0x99'));}var _0x4e638e=[];try{_0x4e638e=_[_0xae79('0x9a')](JSON[_0xae79('0x5f')](process[_0xae79('0x91')][0x4]),'id');}catch(_0x44b656){logger['info']('No\x20agent\x20available');}main(_0x19d6a6,_0x51d4a9,_0x4e638e,_0xf83d91);}validate();process['on'](_0xae79('0x9b'),handleStop);process['on'](_0xae79('0x9c'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff