// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x46bb=['CompanyId',')\x20NOT\x20IN\x20?','id\x20IN\x20?','MIN(id)','min_id','group','toString','info','Received\x20SIGINT','error','spread','main','stringify','send','start','clone','socket_timestamp','root','server/files/tmp','.csv','body','ContactItemType','findAll','name','AdditionalPhones','header','writeFileSync','parse','data','rows','errors','find','hasOwnProperty','trim','replace','YYYY-MM-DD\x20HH:mm:ss','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','includes','dateOfBirth','firstName','\x20not\x20specified','SystemRow','appendFileSync','emit','contact:import:','abort','step','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','CIS\x20len','LOAD\x20DATA\x20LOCAL\x20INFILE\x20\x27%s\x27\x20INTO\x20TABLE\x20%s\x20CHARACTER\x20SET\x20UTF8\x20FIELDS\x20TERMINATED\x20BY\x20\x27,\x27\x20ENCLOSED\x20BY\x20\x27\x22\x27\x20LINES\x20TERMINATED\x20BY\x20\x27\x0a\x27\x20IGNORE\x201\x20ROWS\x20(%s)\x20SET\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27',',\x20scheduledAt\x20=\x20NOW()','each','all','contact','contactTypeId','orderBy','DROP\x20TABLE\x20','finish','unlink','exit','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists','binding','binding\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','No\x20agent\x20available','SIGINT','uncaughtException','path','papaparse','util','bluebird','ioredis','../../../config/logger','import','redis','defaults','localhost','socket.io-emitter','cm_contacts_temp_','format','test','select','field','phone','from','join','.id\x20=\x20','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','sequelize','query','select\x20*\x20from\x20','length','isNil','push','then','catch','message','split','findOne','CmContactHasItem','update','create','PHONE','inserted','CmHopper','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','insert','fromQuery','scheduledat','ListId','createdAt','updatedAt','priority','UserId','recallme','fields','cm_contacts.ListId\x20=\x20','.CmListId','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_hopper','\x22onlyIfOpen\x22','\x22always\x22','cm_contacts.ListId','cm_contacts.createdAt','into','cm_hopper_black','cm_contacts','cm_contacts.phone\x20NOT\x20IN\x20(?)','ListId\x20=\x20?','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','CmHopperId','OrderBy','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contact_has_items','cm_hopper.ListId\x20=\x20?','keys'];(function(_0x382ff3,_0x1a8673){var _0x322de4=function(_0x30d611){while(--_0x30d611){_0x382ff3['push'](_0x382ff3['shift']());}};_0x322de4(++_0x1a8673);}(_0x46bb,0x186));var _0xb46b=function(_0x58c239,_0x1788bc){_0x58c239=_0x58c239-0x0;var _0x1cd7cb=_0x46bb[_0x58c239];return _0x1cd7cb;};'use strict';var fs=require('fs');var path=require(_0xb46b('0x0'));var _=require('lodash');var Papa=require(_0xb46b('0x1'));var util=require(_0xb46b('0x2'));var BPromise=require(_0xb46b('0x3'));var moment=require('moment');var squel=require('squel');var Redis=require(_0xb46b('0x4'));var db=require('../../../mysqldb')['db'];var config=require('../../../config/environment');var logger=require(_0xb46b('0x5'))(_0xb46b('0x6'));config[_0xb46b('0x7')]=_[_0xb46b('0x8')](config[_0xb46b('0x7')],{'host':_0xb46b('0x9'),'port':0x18eb});var socket=require(_0xb46b('0xa'))(new Redis(config[_0xb46b('0x7')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var promisesContact=[];var orderBy=0x0;var updatedRows=0x0;var stopped=![];var NOW=moment()['format']('YYYY-MM-DD\x20HH:mm:ss');var tempTableName=_0xb46b('0xb')+moment()[_0xb46b('0xc')]('YYYYMMDDHHmmss');var contactItemTypes=[];var hasAdditionalPhones=![];function isEmail(_0x43f066){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))*$/[_0xb46b('0xd')](_0x43f066);}function selectNotIn(_0x2263a9,_0x4e0b34,_0x185af2,_0x31f514,_0x2c73fe){return squel[_0xb46b('0xe')]()[_0xb46b('0xf')](_0xb46b('0x10'))[_0xb46b('0x11')](_0x31f514)[_0xb46b('0x12')](_0x4e0b34,null,_0x4e0b34+_0xb46b('0x13')+_0x31f514+'.'+_0x185af2)['where'](_0x31f514+'.'+_0x185af2+_0xb46b('0x14')+_0x2263a9+'.'+_0x185af2)[_0xb46b('0x15')](_0x4e0b34+_0xb46b('0x16')+_0x2c73fe['join']()+')');}function handleAdditionalPhones(){return new Promise(function(_0x557b75,_0x22e16f){promisesAdditionalPhones=[];promisesContact=[];return db[_0xb46b('0x17')][_0xb46b('0x18')](_0xb46b('0x19')+tempTableName)['spread'](function(_0x320d0f){if(_0x320d0f!==null){var _0x2501a7=[];for(var _0x27977d=0x0;_0x27977d<_0x320d0f[_0xb46b('0x1a')];_0x27977d++){var _0x3b45a6=_0x320d0f[_0x27977d];if(!_[_0xb46b('0x1b')](_0x3b45a6[_0xb46b('0x10')])){if(!_[_0xb46b('0x1b')](_0x3b45a6['AdditionalPhones']))_0x2501a7[_0xb46b('0x1c')](insertAdditionalPhones(_0x3b45a6));promisesContact[_0xb46b('0x1c')]({'contact':_0x3b45a6});}}}Promise['all'](_0x2501a7)[_0xb46b('0x1d')](function(){_0x557b75({'val':0x1});});})[_0xb46b('0x1e')](function(_0x236b39){logger['error'](_0x236b39[_0xb46b('0x1f')]);});});}function insertAdditionalPhones(_0x133bb0){return new Promise(function(_0x393a69,_0x1af559){var _0x28dce0=_0x133bb0['AdditionalPhones'];if(_['isNil'](_0x28dce0))_0x1af559({'val':0x0});else{var _0x2a3969=_0x28dce0[_0xb46b('0x20')](';');var _0x3e5126=[];orderBy=0x0;for(var _0x3df386=0x0;_0x3df386<_0x2a3969['length'];_0x3df386++){_0x3e5126[_0xb46b('0x1c')](splitAdditionalPhone(_0x133bb0['id'],_0x2a3969[_0x3df386]));}Promise['all'](_0x3e5126)[_0xb46b('0x1d')](function(){_0x393a69({'val':_0x2a3969[_0xb46b('0x1a')]});});}});}function splitAdditionalPhone(_0x3a64a0,_0x5c080a){return new Promise(function(_0x3f48e7,_0x51f8f4){var _0x5f5a2e=_0x5c080a[_0xb46b('0x20')](':');var _0x37fd88=_0x5f5a2e[0x0];var _0x3a2ad6=_0x5f5a2e[0x1];if(_0x3a2ad6!==''){var _0x2451cd=_0x3a2ad6[_0xb46b('0x20')]('|');var _0x1102bb=[];for(var _0x5a7f5a=0x0;_0x5a7f5a<_0x2451cd[_0xb46b('0x1a')];_0x5a7f5a++){if(_0x2451cd[_0x5a7f5a]!==''){var _0x389334=_['filter'](promisesAdditionalPhones,{'contactId':_0x3a64a0,'phone':_0x2451cd[_0x5a7f5a]});if(_0x389334['length']==0x0){orderBy++;promisesAdditionalPhones[_0xb46b('0x1c')]({'contactId':_0x3a64a0,'contactTypeId':_0x37fd88,'phone':_0x2451cd[_0x5a7f5a],'orderBy':orderBy});}}}_0x3f48e7({'ok':0x1});}else _0x3f48e7({'res':0x0});});}function createAdditionalPhone(_0x54e843,_0x4771b4,_0x2e30de,_0x12feea){return new Promise(function(_0x4d6207,_0x303268){return db['CmContactHasItem'][_0xb46b('0x21')]({'where':{'CmContactId':_0x54e843,'item':_0x2e30de}})['then'](function(_0x1f874c){if(_0x1f874c){return db[_0xb46b('0x22')][_0xb46b('0x23')]({'ItemTypeId':_0x4771b4,'OrderBy':_0x12feea},{'where':{'CmContactId':_0x54e843,'item':_0x2e30de}})[_0xb46b('0x1d')](function(_0x227d2a){_0x4d6207({'res':'updated'});});}else{return db[_0xb46b('0x22')][_0xb46b('0x24')]({'CmContactId':_0x54e843,'item':_0x2e30de,'ItemTypeId':_0x4771b4,'OrderBy':_0x12feea,'ItemClass':_0xb46b('0x25')})[_0xb46b('0x1d')](function(_0x75f2bc){_0x4d6207({'res':_0xb46b('0x26')});});}});});}function updateContact(_0x38d676){return new Promise(function(_0x20f233,_0x4ad807){var _0x3b312c=_0x38d676['id'];delete _0x38d676['id'];return db['CmContact'][_0xb46b('0x23')](_0x38d676,{'where':{'id':_0x3b312c}})[_0xb46b('0x1d')](function(_0x42f83b){updatedRows+=0x1;return db[_0xb46b('0x27')][_0xb46b('0x23')]({'phone':_0x38d676['phone']},{'where':{'ContactId':_0x3b312c}})[_0xb46b('0x1d')](function(_0x475d74){_0x20f233({'ret':'OK'});});});});}function insertCmHopper(_0x30fed7,_0x215d0f,_0x35eb26,_0x30ea3b,_0x2c0889){var _0x3f18ce=[_0xb46b('0x28'),_0xb46b('0x29'),_0xb46b('0x2a'),'cm_contacts.ListId',_0x215d0f+'.'+_0x30ea3b,'cm_contacts.createdAt',_0xb46b('0x2b'),_0xb46b('0x2c'),_0xb46b('0x2d'),'\x22'+_0x2c0889+'\x22'];return squel[_0xb46b('0x2e')]()['into']('cm_hopper')[_0xb46b('0x2f')]([_0xb46b('0x10'),_0xb46b('0x30'),'ContactId',_0xb46b('0x31'),_0x30ea3b,_0xb46b('0x32'),_0xb46b('0x33'),_0xb46b('0x34'),_0xb46b('0x35'),_0xb46b('0x36')],squel['select']()[_0xb46b('0x37')](_0x3f18ce)[_0xb46b('0x11')](_0x215d0f)[_0xb46b('0x12')]('cm_contacts',null,_0xb46b('0x38')+_0x215d0f+_0xb46b('0x39'))['join'](_0x35eb26,null,_0x35eb26+_0xb46b('0x13')+_0x215d0f+'.'+_0x30ea3b)[_0xb46b('0x15')](_0x215d0f+_0xb46b('0x3a'),_0x30fed7)['where'](_0xb46b('0x3b'),NOW)['where']('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x215d0f,_0x35eb26,_0x30ea3b,_0xb46b('0x3c'),['\x22always\x22',_0xb46b('0x3d')]))[_0xb46b('0x15')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x215d0f,_0x35eb26,_0x30ea3b,_0xb46b('0x3c'),[_0xb46b('0x3e')])))['toString']();}function insertCmHopperBlack(_0x327d7c,_0x3df353,_0x1ccded,_0x2f81f3){var _0x1b415b=[_0xb46b('0x28'),'cm_contacts.id',_0xb46b('0x3f'),_0x3df353+'.'+_0x2f81f3,_0xb46b('0x40'),_0xb46b('0x2b')];return squel[_0xb46b('0x2e')]()[_0xb46b('0x41')](_0xb46b('0x42'))[_0xb46b('0x2f')]([_0xb46b('0x10'),'ContactId',_0xb46b('0x31'),_0x2f81f3,_0xb46b('0x32'),'updatedAt'],squel['select']()[_0xb46b('0x37')](_0x1b415b)[_0xb46b('0x11')](_0x3df353)['join'](_0xb46b('0x43'),null,_0xb46b('0x38')+_0x3df353+_0xb46b('0x39'))['join'](_0x1ccded,null,_0x1ccded+'.id\x20=\x20'+_0x3df353+'.'+_0x2f81f3)[_0xb46b('0x15')](_0x3df353+_0xb46b('0x3a'),_0x327d7c)[_0xb46b('0x15')](_0xb46b('0x3b'),NOW)[_0xb46b('0x15')](_0xb46b('0x44'),squel['select']()[_0xb46b('0xf')](_0xb46b('0x10'))[_0xb46b('0x11')](_0xb46b('0x42'))[_0xb46b('0x15')](_0xb46b('0x45'),_0x327d7c)[_0xb46b('0x15')](_0x2f81f3+'\x20=\x20?',_0x3df353+'.'+_0x2f81f3)))['toString']();}function insertCmHopperAdditionalPhones(_0x2bc28d){var _0x3d2999=[_0xb46b('0x46'),_0xb46b('0x47'),_0xb46b('0x48'),_0xb46b('0x49'),_0xb46b('0x4a')];return squel[_0xb46b('0x2e')]()[_0xb46b('0x41')]('cm_hopper_additional_phones')[_0xb46b('0x2f')]([_0xb46b('0x4b'),_0xb46b('0x10'),_0xb46b('0x4c'),'createdAt',_0xb46b('0x33')],squel[_0xb46b('0xe')]()[_0xb46b('0x37')](_0x3d2999)[_0xb46b('0x11')]('cm_hopper')[_0xb46b('0x12')](_0xb46b('0x43'),null,_0xb46b('0x4d'))[_0xb46b('0x12')](_0xb46b('0x4e'),null,'cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId')[_0xb46b('0x15')](_0xb46b('0x4f'),_0x2bc28d)[_0xb46b('0x15')]('cm_contacts.createdAt\x20=\x20?',NOW))['toString']();}function insertCmContact(_0x59da66,_0x3edc49,_0x1c5384,_0x3ea2d1){var _0x2df2ff=_['concat'](_[_0xb46b('0x50')](_0x3ea2d1),[_0xb46b('0x31'),_0xb46b('0x51'),_0xb46b('0x32'),_0xb46b('0x33')]);return squel[_0xb46b('0x2e')]()[_0xb46b('0x41')]('cm_contacts')['fromQuery'](_0x2df2ff,squel[_0xb46b('0xe')]()[_0xb46b('0x37')](_0x2df2ff)[_0xb46b('0x11')](_0x3edc49)['where']('('+_0x1c5384['join'](',')+_0xb46b('0x52'),squel[_0xb46b('0xe')]()['fields'](_0x1c5384)[_0xb46b('0x11')]('cm_contacts')[_0xb46b('0x15')](_0xb46b('0x45'),_0x59da66))[_0xb46b('0x15')](_0xb46b('0x53'),squel[_0xb46b('0xe')]()[_0xb46b('0xf')](_0xb46b('0x54'),_0xb46b('0x55'))['from'](_0x3edc49)[_0xb46b('0x56')](_0x1c5384[_0xb46b('0x12')](','))))[_0xb46b('0x57')]();}function handleStop(){logger[_0xb46b('0x58')](_0xb46b('0x59'));stopped=!![];}function handleUncaughtException(_0x40359d){logger[_0xb46b('0x5a')](_0x40359d[_0xb46b('0x1f')]);process['exit'](0x1);}function handleError(_0x41c99f,_0x434b82){stats['errors'][_0xb46b('0x1c')]({'name':_0x434b82['code'],'message':_0x434b82[_0xb46b('0x1f')],'row':_0x41c99f});}function handleQuery(_0x106fbd){logger[_0xb46b('0x58')](_0x106fbd);return db['sequelize']['query'](_0x106fbd)[_0xb46b('0x5b')](function(_0x1cc540){results['push'](_0x1cc540);})[_0xb46b('0x1e')](function(_0x14f331){logger['error'](_0x14f331[_0xb46b('0x1f')]);});}function main(_0x4d10c9,_0x3c8282,_0x5d2b90,_0x1b2d93){logger['info'](_0xb46b('0x5c'),_0x4d10c9,JSON[_0xb46b('0x5d')](_0x3c8282));process[_0xb46b('0x5e')](_0xb46b('0x5f'));var _0xe61fab=_0x3c8282['binding'];var _0xa6d5b1=_[_0xb46b('0x60')](_0xe61fab);var _0x13a42f=_0x3c8282[_0xb46b('0x61')];var _0x336a70=path[_0xb46b('0x12')](config[_0xb46b('0x62')],_0xb46b('0x63'),_0x13a42f+_0xb46b('0x64'));logger[_0xb46b('0x58')](_0xb46b('0x65'),_0x3c8282);db[_0xb46b('0x66')][_0xb46b('0x67')]({'raw':!![],'attributes':['id','name']})[_0xb46b('0x1d')](function(_0x451102){for(var _0x15f6b3=0x0;_0x15f6b3<_0x451102[_0xb46b('0x1a')];_0x15f6b3++){if(_0x451102[_0x15f6b3]['name']in _0xe61fab){contactItemTypes[_0xb46b('0x1c')](_0x451102[_0x15f6b3]);delete _0xa6d5b1[_0x451102[_0x15f6b3][_0xb46b('0x68')]];hasAdditionalPhones=!![];}else{}}if(hasAdditionalPhones)_0xa6d5b1[_0xb46b('0x69')]='';var _0x675633=_[_0xb46b('0x50')](_0xa6d5b1)[_0xb46b('0x12')]();logger['info'](_0xb46b('0x6a'),_0x675633);fs[_0xb46b('0x6b')](_0x336a70,_0x675633+'\x0a');Papa[_0xb46b('0x6c')](fs['createReadStream'](_0x4d10c9),{'header':!![],'skipEmptyLines':!![],'step':function(_0x3ec07d,_0x350943){try{for(var _0x474f39=0x0,_0x2972bc=[];_0x474f39<_0x3ec07d[_0xb46b('0x6d')]['length'];_0x474f39++){stats[_0xb46b('0x6e')]+=0x1;if(_0x3ec07d[_0xb46b('0x6f')][_0x474f39]){handleError(_0x3ec07d[_0xb46b('0x6d')][_0x474f39],_0x3ec07d[_0xb46b('0x6f')][_0x474f39]);}else{var _0x2eec76=[];var _0x4e5352=[];for(var _0x43ef1 in _0xe61fab){let _0x5399b0=contactItemTypes[_0xb46b('0x70')](_0x566663=>_0x566663[_0xb46b('0x68')]===_0x43ef1);if(_[_0xb46b('0x1b')](_0x5399b0)){if(_0xe61fab[_0xb46b('0x71')](_0x43ef1)){if(_0x3ec07d[_0xb46b('0x6d')][_0x474f39][_0xe61fab[_0x43ef1]]){var _0x48edd2=_[_0xb46b('0x72')](_0x3ec07d[_0xb46b('0x6d')][_0x474f39][_0xe61fab[_0x43ef1]][_0xb46b('0x73')](/"/g,'\x27'));switch(_0x43ef1){case _0xb46b('0x30'):var _0x567bf2=moment(_0x48edd2,_0xb46b('0x74'),!![]);if(_0x567bf2[_0xb46b('0x75')]()){_0x2972bc[_0xb46b('0x1c')]('\x22'+_0x48edd2+'\x22');}else{_0x2eec76[_0xb46b('0x1c')](_0xb46b('0x76'));}break;case _0xb46b('0x34'):var _0x767a49=parseInt(_0x48edd2);_0x48edd2=_[_0xb46b('0x77')](_0x767a49)||_0x767a49<0x0||_0x767a49>0x4?_0x1b2d93?0x3:0x2:_0x767a49;_0x2972bc[_0xb46b('0x1c')]('\x22'+_0x48edd2+'\x22');break;case _0xb46b('0x35'):var _0x349ecc=parseInt(_0x48edd2);if(_[_0xb46b('0x78')](_0x349ecc)&&_[_0xb46b('0x79')](_0x5d2b90,_0x349ecc)){_0x2972bc[_0xb46b('0x1c')]('\x22'+_0x349ecc+'\x22');}else{_0x2eec76[_0xb46b('0x1c')]('agent\x20not\x20exists');}break;case'email':if(isEmail(_0x48edd2)){_0x2972bc['push']('\x22'+_0x48edd2+'\x22');}else{_0x2eec76['push']('email\x20wrong\x20format');}break;case _0xb46b('0x7a'):var _0x2fa4f4=moment(_0x48edd2,'YYYY-MM-DD',!![]);if(_0x2fa4f4['isValid']()){_0x2972bc[_0xb46b('0x1c')]('\x22'+_0x48edd2+'\x22');}else{_0x2eec76[_0xb46b('0x1c')]('dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)');}break;default:_0x2972bc[_0xb46b('0x1c')]('\x22'+_0x48edd2+'\x22');}}else{switch(_0x43ef1){case _0xb46b('0x7b'):case _0xb46b('0x10'):_0x2eec76[_0xb46b('0x1c')](_0x43ef1+_0xb46b('0x7c'));break;default:_0x2972bc[_0xb46b('0x1c')]('\x22\x22');}}}}else{var _0x4833bf='';for(var _0x45e9b4=0x0;_0x45e9b4<_0xe61fab[_0x43ef1]['length'];_0x45e9b4++){var _0x48edd2=_[_0xb46b('0x72')](_0x3ec07d[_0xb46b('0x6d')][_0x474f39][_0xe61fab[_0x43ef1][_0x45e9b4]][_0xb46b('0x73')](/"/g,'\x27'));if(_0x4833bf=='')_0x4833bf=_0x48edd2;else _0x4833bf+='|'+_0x48edd2;}_0x4e5352[_0xb46b('0x1c')](_0x5399b0['id']+':'+_0x4833bf);}}if(hasAdditionalPhones){_0x2972bc['push']('\x22'+_0x4e5352[_0xb46b('0x12')](';')+'\x22');}if(_0x2eec76[_0xb46b('0x1a')]){handleError(_0x3ec07d[_0xb46b('0x6d')][_0x474f39],{'code':_0xb46b('0x7d'),'message':_0x2eec76[_0xb46b('0x12')]()});}else{fs[_0xb46b('0x7e')](_0x336a70,_0x2972bc['join']()+'\x0a');}_0x2972bc=[];}if(!(stats[_0xb46b('0x6e')]%0xc8)){socket[_0xb46b('0x7f')](_0xb46b('0x80')+_0x13a42f,stats);stats[_0xb46b('0x6f')]=[];}}if(stopped){logger[_0xb46b('0x58')]('Abort\x20parser');_0x350943[_0xb46b('0x81')]();}}catch(_0x5edb5d){handleError(_0x3ec07d[_0xb46b('0x6d')][_0x474f39],{'code':'SystemError','message':_0x5edb5d[_0xb46b('0x1f')]});logger[_0xb46b('0x5a')](_0xb46b('0x82'),_0x5edb5d[_0xb46b('0x1f')]);}},'complete':function(){try{var _0x463f63=[];var _0x1264c2=tempTableName;_0x463f63['push'](_0xb46b('0x83')+_0x1264c2+_0xb46b('0x84'));logger[_0xb46b('0x58')](_0xb46b('0x85'),contactItemTypes[_0xb46b('0x1a')]);var _0x3226f0=util[_0xb46b('0xc')](_0xb46b('0x86'),_0x336a70,_0x1264c2,_0x675633,_0x3c8282['ListId'],_0x3c8282[_0xb46b('0x51')]||null,NOW,NOW);if(_[_0xb46b('0x1b')](_0xe61fab['scheduledat'])){_0x3226f0+=_0xb46b('0x87');}_0x463f63[_0xb46b('0x1c')](_0x3226f0);BPromise[_0xb46b('0x88')](_0x463f63,handleQuery)['then'](function(_0x1d1790){BPromise[_0xb46b('0x89')]([handleAdditionalPhones()])[_0xb46b('0x1d')](function(){_0x463f63=[];for(var _0x349467=0x0;_0x349467<promisesContact[_0xb46b('0x1a')];_0x349467++){_0x463f63[_0xb46b('0x1c')](updateContact(promisesContact[_0x349467][_0xb46b('0x8a')]));}BPromise[_0xb46b('0x89')](_0x463f63)[_0xb46b('0x1d')](function(){_0x463f63=[];for(var _0x44b66a=0x0;_0x44b66a<promisesAdditionalPhones['length'];_0x44b66a++){_0x463f63['push'](createAdditionalPhone(promisesAdditionalPhones[_0x44b66a]['contactId'],promisesAdditionalPhones[_0x44b66a][_0xb46b('0x8b')],promisesAdditionalPhones[_0x44b66a][_0xb46b('0x10')],promisesAdditionalPhones[_0x44b66a][_0xb46b('0x8c')]));}BPromise[_0xb46b('0x89')](_0x463f63)[_0xb46b('0x1d')](function(){_0x463f63=[];_0x463f63[_0xb46b('0x1c')](insertCmHopperAdditionalPhones(_0x3c8282[_0xb46b('0x31')]));_0x463f63[_0xb46b('0x1c')](_0xb46b('0x8d')+_0x1264c2+';');BPromise[_0xb46b('0x88')](_0x463f63,handleQuery)['then'](function(_0x49c851){stats[_0xb46b('0x8e')]=!![];stats['affectedRows']=updatedRows;socket[_0xb46b('0x7f')](_0xb46b('0x80')+_0x13a42f,stats);fs['unlink'](_0x4d10c9);fs[_0xb46b('0x8f')](_0x336a70);process['exit'](0x0);})['catch'](function(_0x471402){logger['error'](_0x471402[_0xb46b('0x1f')]);process[_0xb46b('0x90')](0x1);});});});});})['catch'](function(_0x452dde){logger['error'](_0x452dde[_0xb46b('0x1f')]);process['exit'](0x1);});}catch(_0x35b2d0){logger['error']('complete',_0x35b2d0[_0xb46b('0x1f')]);process[_0xb46b('0x90')](0x1);}},'error':function(_0x9c8e5c,_0x213315,_0x55ceaf,_0x5b6fc4){throw new Error(_0x5b6fc4);}});});}function validate(){if(process[_0xb46b('0x91')]&&process[_0xb46b('0x91')][_0xb46b('0x1a')]<0x4){throw new Error(_0xb46b('0x92'));}var _0x37fe42=path['join'](config['root'],_0xb46b('0x63'),process[_0xb46b('0x91')][0x2]);if(!fs[_0xb46b('0x93')](_0x37fe42)){throw new Error(_0xb46b('0x94'));}var _0x3ee1f3={};try{_0x3ee1f3=JSON['parse'](process[_0xb46b('0x91')][0x3]);if(!_0x3ee1f3[_0xb46b('0x95')]){throw new Error(_0xb46b('0x96'));}var _0x500d1b=0x0;if(_0x3ee1f3['binding'][_0xb46b('0x35')]){_0x500d1b=0x1;}if(!_0x3ee1f3[_0xb46b('0x31')]){throw new Error(_0xb46b('0x97'));}}catch(_0x30fdcd){throw new Error(_0xb46b('0x98'));}var _0x556623=[];try{_0x556623=_[_0xb46b('0x99')](JSON[_0xb46b('0x6c')](process[_0xb46b('0x91')][0x4]),'id');}catch(_0x23025d){logger[_0xb46b('0x58')](_0xb46b('0x9a'));}main(_0x37fe42,_0x3ee1f3,_0x556623,_0x500d1b);}validate();process['on'](_0xb46b('0x9b'),handleStop);process['on'](_0xb46b('0x9c'),handleUncaughtException);
\ No newline at end of file
+var _0x1f08=['\x22onlyIfOpen\x22','toString','insert','cm_hopper_black','createdAt','.CmListId','ListId\x20=\x20?','\x20=\x20?','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','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','keys','CompanyId',')\x20NOT\x20IN\x20?','id\x20IN\x20?','MIN(id)','min_id','exit','errors','code','info','send','binding','clone','root','server/files/tmp','.csv','ContactItemType','findAll','name','header','data','rows','find','hasOwnProperty','trim','replace','scheduledat','YYYY-MM-DD\x20HH:mm:ss','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','priority','isNaN','isNumber','agent\x20not\x20exists','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','SystemRow','appendFileSync','Abort\x20parser','abort','SystemError','step','\x20LIKE\x20cm_contacts;','CIS\x20len','each','contact','contactTypeId','orderBy','DROP\x20TABLE\x20','finish','affectedRows','emit','contact:import:','unlink','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','parse','binding\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','SIGINT','uncaughtException','path','lodash','papaparse','util','bluebird','moment','squel','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','import','redis','defaults','localhost','socket.io-emitter','format','YYYYMMDDHHmmss','test','select','field','phone','from','join','.id\x20=\x20','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','sequelize','query','spread','length','isNil','AdditionalPhones','push','all','catch','error','message','split','then','filter','CmContactHasItem','findOne','updated','PHONE','CmContact','update','CmHopper','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.updatedAt','into','cm_hopper','fromQuery','ContactId','ListId','updatedAt','UserId','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22always\x22'];(function(_0x1892c2,_0x30f95b){var _0x2c722a=function(_0x4a804d){while(--_0x4a804d){_0x1892c2['push'](_0x1892c2['shift']());}};_0x2c722a(++_0x30f95b);}(_0x1f08,0x192));var _0x81f0=function(_0x4a78a0,_0x2e6435){_0x4a78a0=_0x4a78a0-0x0;var _0x5d672c=_0x1f08[_0x4a78a0];return _0x5d672c;};'use strict';var fs=require('fs');var path=require(_0x81f0('0x0'));var _=require(_0x81f0('0x1'));var Papa=require(_0x81f0('0x2'));var util=require(_0x81f0('0x3'));var BPromise=require(_0x81f0('0x4'));var moment=require(_0x81f0('0x5'));var squel=require(_0x81f0('0x6'));var Redis=require(_0x81f0('0x7'));var db=require(_0x81f0('0x8'))['db'];var config=require(_0x81f0('0x9'));var logger=require(_0x81f0('0xa'))(_0x81f0('0xb'));config[_0x81f0('0xc')]=_[_0x81f0('0xd')](config['redis'],{'host':_0x81f0('0xe'),'port':0x18eb});var socket=require(_0x81f0('0xf'))(new Redis(config[_0x81f0('0xc')]));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()[_0x81f0('0x10')]('YYYY-MM-DD\x20HH:mm:ss');var tempTableName='cm_contacts_temp_'+moment()[_0x81f0('0x10')](_0x81f0('0x11'));var contactItemTypes=[];var hasAdditionalPhones=![];function isEmail(_0x582902){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))*$/[_0x81f0('0x12')](_0x582902);}function selectNotIn(_0x4e139c,_0x1ffee2,_0x39d46c,_0xaff63f,_0x34f279){return squel[_0x81f0('0x13')]()[_0x81f0('0x14')](_0x81f0('0x15'))[_0x81f0('0x16')](_0xaff63f)[_0x81f0('0x17')](_0x1ffee2,null,_0x1ffee2+_0x81f0('0x18')+_0xaff63f+'.'+_0x39d46c)['where'](_0xaff63f+'.'+_0x39d46c+_0x81f0('0x19')+_0x4e139c+'.'+_0x39d46c)[_0x81f0('0x1a')](_0x1ffee2+_0x81f0('0x1b')+_0x34f279[_0x81f0('0x17')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x3d866d,_0x31826c){promisesAdditionalPhones=[];promisesContact=[];return db[_0x81f0('0x1c')][_0x81f0('0x1d')]('select\x20*\x20from\x20'+tempTableName)[_0x81f0('0x1e')](function(_0x8d7404){if(_0x8d7404!==null){var _0x1c7205=[];for(var _0x2ab933=0x0;_0x2ab933<_0x8d7404[_0x81f0('0x1f')];_0x2ab933++){var _0x38cc15=_0x8d7404[_0x2ab933];if(!_[_0x81f0('0x20')](_0x38cc15[_0x81f0('0x15')])){if(!_[_0x81f0('0x20')](_0x38cc15[_0x81f0('0x21')]))_0x1c7205[_0x81f0('0x22')](insertAdditionalPhones(_0x38cc15));promisesContact[_0x81f0('0x22')]({'contact':_0x38cc15});}}}Promise[_0x81f0('0x23')](_0x1c7205)['then'](function(){_0x3d866d({'val':0x1});});})[_0x81f0('0x24')](function(_0x43b4a3){logger[_0x81f0('0x25')](_0x43b4a3[_0x81f0('0x26')]);});});}function insertAdditionalPhones(_0x4f2051){return new Promise(function(_0x58c463,_0x2e9af3){var _0x2c35c5=_0x4f2051[_0x81f0('0x21')];if(_[_0x81f0('0x20')](_0x2c35c5))_0x2e9af3({'val':0x0});else{var _0x779e35=_0x2c35c5[_0x81f0('0x27')](';');var _0x147667=[];orderBy=0x0;for(var _0x1b6b6c=0x0;_0x1b6b6c<_0x779e35[_0x81f0('0x1f')];_0x1b6b6c++){_0x147667[_0x81f0('0x22')](splitAdditionalPhone(_0x4f2051['id'],_0x779e35[_0x1b6b6c]));}Promise[_0x81f0('0x23')](_0x147667)[_0x81f0('0x28')](function(){_0x58c463({'val':_0x779e35[_0x81f0('0x1f')]});});}});}function splitAdditionalPhone(_0x34e0db,_0x279701){return new Promise(function(_0x32ff5c,_0x4a4c57){var _0x5ef11f=_0x279701[_0x81f0('0x27')](':');var _0x4363a8=_0x5ef11f[0x0];var _0x37edc7=_0x5ef11f[0x1];if(_0x37edc7!==''){var _0x50de6e=_0x37edc7[_0x81f0('0x27')]('|');var _0x1ba549=[];for(var _0x1dac9c=0x0;_0x1dac9c<_0x50de6e[_0x81f0('0x1f')];_0x1dac9c++){if(_0x50de6e[_0x1dac9c]!==''){var _0x56573a=_[_0x81f0('0x29')](promisesAdditionalPhones,{'contactId':_0x34e0db,'phone':_0x50de6e[_0x1dac9c]});if(_0x56573a['length']==0x0){orderBy++;promisesAdditionalPhones[_0x81f0('0x22')]({'contactId':_0x34e0db,'contactTypeId':_0x4363a8,'phone':_0x50de6e[_0x1dac9c],'orderBy':orderBy});}}}_0x32ff5c({'ok':0x1});}else _0x32ff5c({'res':0x0});});}function createAdditionalPhone(_0x188c9a,_0x5f2713,_0x1e2ba6,_0x1435d5){return new Promise(function(_0x23684d,_0x291fc3){return db[_0x81f0('0x2a')][_0x81f0('0x2b')]({'where':{'CmContactId':_0x188c9a,'item':_0x1e2ba6}})[_0x81f0('0x28')](function(_0x11996c){if(_0x11996c){return db[_0x81f0('0x2a')]['update']({'ItemTypeId':_0x5f2713,'OrderBy':_0x1435d5},{'where':{'CmContactId':_0x188c9a,'item':_0x1e2ba6}})[_0x81f0('0x28')](function(_0x117411){_0x23684d({'res':_0x81f0('0x2c')});});}else{return db[_0x81f0('0x2a')]['create']({'CmContactId':_0x188c9a,'item':_0x1e2ba6,'ItemTypeId':_0x5f2713,'OrderBy':_0x1435d5,'ItemClass':_0x81f0('0x2d')})[_0x81f0('0x28')](function(_0x49d7e5){_0x23684d({'res':'inserted'});});}});});}function updateContact(_0x7b2a04){return new Promise(function(_0x5220b1,_0x3e8f16){var _0x280502=_0x7b2a04['id'];delete _0x7b2a04['id'];return db[_0x81f0('0x2e')][_0x81f0('0x2f')](_0x7b2a04,{'where':{'id':_0x280502}})[_0x81f0('0x28')](function(_0x3770c5){updatedRows+=0x1;return db[_0x81f0('0x30')][_0x81f0('0x2f')]({'phone':_0x7b2a04['phone']},{'where':{'ContactId':_0x280502}})['then'](function(_0x3e42d9){_0x5220b1({'ret':'OK'});});});});}function insertCmHopper(_0x5d54a3,_0x5e6dc6,_0x5c55cd,_0x16d9b6,_0x3df272){var _0x5ca3b6=[_0x81f0('0x31'),_0x81f0('0x32'),_0x81f0('0x33'),_0x81f0('0x34'),_0x5e6dc6+'.'+_0x16d9b6,_0x81f0('0x35'),_0x81f0('0x36'),'cm_contacts.priority','cm_contacts.UserId','\x22'+_0x3df272+'\x22'];return squel['insert']()[_0x81f0('0x37')](_0x81f0('0x38'))[_0x81f0('0x39')]([_0x81f0('0x15'),'scheduledat',_0x81f0('0x3a'),_0x81f0('0x3b'),_0x16d9b6,'createdAt',_0x81f0('0x3c'),'priority',_0x81f0('0x3d'),'recallme'],squel[_0x81f0('0x13')]()[_0x81f0('0x3e')](_0x5ca3b6)[_0x81f0('0x16')](_0x5e6dc6)[_0x81f0('0x17')](_0x81f0('0x3f'),null,_0x81f0('0x40')+_0x5e6dc6+'.CmListId')[_0x81f0('0x17')](_0x5c55cd,null,_0x5c55cd+_0x81f0('0x18')+_0x5e6dc6+'.'+_0x16d9b6)[_0x81f0('0x1a')](_0x5e6dc6+_0x81f0('0x41'),_0x5d54a3)[_0x81f0('0x1a')](_0x81f0('0x42'),NOW)['where'](_0x81f0('0x43'),selectNotIn(_0x5e6dc6,_0x5c55cd,_0x16d9b6,_0x81f0('0x38'),[_0x81f0('0x44'),_0x81f0('0x45')]))[_0x81f0('0x1a')](_0x81f0('0x43'),selectNotIn(_0x5e6dc6,_0x5c55cd,_0x16d9b6,'cm_hopper',[_0x81f0('0x44')])))[_0x81f0('0x46')]();}function insertCmHopperBlack(_0x4922d5,_0x308f89,_0x55c5e9,_0x5cdef9){var _0x5b5f9c=[_0x81f0('0x31'),_0x81f0('0x33'),_0x81f0('0x34'),_0x308f89+'.'+_0x5cdef9,_0x81f0('0x35'),_0x81f0('0x36')];return squel[_0x81f0('0x47')]()[_0x81f0('0x37')](_0x81f0('0x48'))[_0x81f0('0x39')]([_0x81f0('0x15'),_0x81f0('0x3a'),'ListId',_0x5cdef9,_0x81f0('0x49'),_0x81f0('0x3c')],squel['select']()[_0x81f0('0x3e')](_0x5b5f9c)[_0x81f0('0x16')](_0x308f89)['join'](_0x81f0('0x3f'),null,'cm_contacts.ListId\x20=\x20'+_0x308f89+_0x81f0('0x4a'))[_0x81f0('0x17')](_0x55c5e9,null,_0x55c5e9+_0x81f0('0x18')+_0x308f89+'.'+_0x5cdef9)[_0x81f0('0x1a')](_0x308f89+'.CmListId\x20=\x20?',_0x4922d5)[_0x81f0('0x1a')](_0x81f0('0x42'),NOW)[_0x81f0('0x1a')](_0x81f0('0x43'),squel[_0x81f0('0x13')]()['field'](_0x81f0('0x15'))['from'](_0x81f0('0x48'))['where'](_0x81f0('0x4b'),_0x4922d5)[_0x81f0('0x1a')](_0x5cdef9+_0x81f0('0x4c'),_0x308f89+'.'+_0x5cdef9)))['toString']();}function insertCmHopperAdditionalPhones(_0x39f9b9){var _0x2bab20=[_0x81f0('0x4d'),_0x81f0('0x4e'),'cm_contact_has_items.OrderBy',_0x81f0('0x4f'),_0x81f0('0x50')];return squel['insert']()[_0x81f0('0x37')](_0x81f0('0x51'))['fromQuery']([_0x81f0('0x52'),_0x81f0('0x15'),_0x81f0('0x53'),_0x81f0('0x49'),_0x81f0('0x3c')],squel[_0x81f0('0x13')]()[_0x81f0('0x3e')](_0x2bab20)['from'](_0x81f0('0x38'))['join'](_0x81f0('0x3f'),null,_0x81f0('0x54'))[_0x81f0('0x17')](_0x81f0('0x55'),null,_0x81f0('0x56'))['where'](_0x81f0('0x57'),_0x39f9b9)['where'](_0x81f0('0x42'),NOW))['toString']();}function insertCmContact(_0x347fd3,_0x365735,_0xf7b6af,_0x9fd766){var _0x43dc9a=_[_0x81f0('0x58')](_[_0x81f0('0x59')](_0x9fd766),['ListId',_0x81f0('0x5a'),'createdAt',_0x81f0('0x3c')]);return squel[_0x81f0('0x47')]()[_0x81f0('0x37')](_0x81f0('0x3f'))['fromQuery'](_0x43dc9a,squel[_0x81f0('0x13')]()[_0x81f0('0x3e')](_0x43dc9a)[_0x81f0('0x16')](_0x365735)['where']('('+_0xf7b6af[_0x81f0('0x17')](',')+_0x81f0('0x5b'),squel[_0x81f0('0x13')]()['fields'](_0xf7b6af)[_0x81f0('0x16')](_0x81f0('0x3f'))['where'](_0x81f0('0x4b'),_0x347fd3))[_0x81f0('0x1a')](_0x81f0('0x5c'),squel['select']()[_0x81f0('0x14')](_0x81f0('0x5d'),_0x81f0('0x5e'))[_0x81f0('0x16')](_0x365735)['group'](_0xf7b6af[_0x81f0('0x17')](','))))[_0x81f0('0x46')]();}function handleStop(){logger['info']('Received\x20SIGINT');stopped=!![];}function handleUncaughtException(_0x40bfef){logger[_0x81f0('0x25')](_0x40bfef[_0x81f0('0x26')]);process[_0x81f0('0x5f')](0x1);}function handleError(_0x132c2d,_0x2ccd25){stats[_0x81f0('0x60')]['push']({'name':_0x2ccd25[_0x81f0('0x61')],'message':_0x2ccd25[_0x81f0('0x26')],'row':_0x132c2d});}function handleQuery(_0x5ac4d6){logger['info'](_0x5ac4d6);return db[_0x81f0('0x1c')]['query'](_0x5ac4d6)[_0x81f0('0x1e')](function(_0x239d0f){results[_0x81f0('0x22')](_0x239d0f);})['catch'](function(_0x43335b){logger[_0x81f0('0x25')](_0x43335b[_0x81f0('0x26')]);});}function main(_0x57966b,_0x11493c,_0x87dd7a,_0x7d38c3){logger[_0x81f0('0x62')]('main',_0x57966b,JSON['stringify'](_0x11493c));process[_0x81f0('0x63')]('start');var _0x1cb1df=_0x11493c[_0x81f0('0x64')];var _0x1bab4e=_[_0x81f0('0x65')](_0x1cb1df);var _0xa02fe7=_0x11493c['socket_timestamp'];var _0x4065b2=path[_0x81f0('0x17')](config[_0x81f0('0x66')],_0x81f0('0x67'),_0xa02fe7+_0x81f0('0x68'));logger['info']('body',_0x11493c);db[_0x81f0('0x69')][_0x81f0('0x6a')]({'raw':!![],'attributes':['id','name']})['then'](function(_0x554515){for(var _0x22f620=0x0;_0x22f620<_0x554515[_0x81f0('0x1f')];_0x22f620++){if(_0x554515[_0x22f620][_0x81f0('0x6b')]in _0x1cb1df){contactItemTypes[_0x81f0('0x22')](_0x554515[_0x22f620]);delete _0x1bab4e[_0x554515[_0x22f620]['name']];hasAdditionalPhones=!![];}else{}}if(hasAdditionalPhones)_0x1bab4e[_0x81f0('0x21')]='';var _0xf5e8b7=_[_0x81f0('0x59')](_0x1bab4e)[_0x81f0('0x17')]();logger[_0x81f0('0x62')](_0x81f0('0x6c'),_0xf5e8b7);fs['writeFileSync'](_0x4065b2,_0xf5e8b7+'\x0a');Papa['parse'](fs['createReadStream'](_0x57966b),{'header':!![],'skipEmptyLines':!![],'step':function(_0xce1313,_0xe08521){try{for(var _0x3d8edc=0x0,_0x1f0374=[];_0x3d8edc<_0xce1313[_0x81f0('0x6d')]['length'];_0x3d8edc++){stats[_0x81f0('0x6e')]+=0x1;if(_0xce1313[_0x81f0('0x60')][_0x3d8edc]){handleError(_0xce1313[_0x81f0('0x6d')][_0x3d8edc],_0xce1313['errors'][_0x3d8edc]);}else{var _0x4a55d0=[];var _0x407164=[];for(var _0x56f797 in _0x1cb1df){let _0x293233=contactItemTypes[_0x81f0('0x6f')](_0x30d70c=>_0x30d70c[_0x81f0('0x6b')]===_0x56f797);if(_[_0x81f0('0x20')](_0x293233)){if(_0x1cb1df[_0x81f0('0x70')](_0x56f797)){if(_0xce1313['data'][_0x3d8edc][_0x1cb1df[_0x56f797]]){var _0x56f45b=_[_0x81f0('0x71')](_0xce1313[_0x81f0('0x6d')][_0x3d8edc][_0x1cb1df[_0x56f797]][_0x81f0('0x72')](/"/g,'\x27'));switch(_0x56f797){case _0x81f0('0x73'):var _0x3d159b=moment(_0x56f45b,_0x81f0('0x74'),!![]);if(_0x3d159b[_0x81f0('0x75')]()){_0x1f0374[_0x81f0('0x22')]('\x22'+_0x56f45b+'\x22');}else{_0x4a55d0[_0x81f0('0x22')](_0x81f0('0x76'));}break;case _0x81f0('0x77'):var _0x39f484=parseInt(_0x56f45b);_0x56f45b=_[_0x81f0('0x78')](_0x39f484)||_0x39f484<0x0||_0x39f484>0x4?_0x7d38c3?0x3:0x2:_0x39f484;_0x1f0374[_0x81f0('0x22')]('\x22'+_0x56f45b+'\x22');break;case _0x81f0('0x3d'):var _0x4b3e83=parseInt(_0x56f45b);if(_[_0x81f0('0x79')](_0x4b3e83)&&_['includes'](_0x87dd7a,_0x4b3e83)){_0x1f0374['push']('\x22'+_0x4b3e83+'\x22');}else{_0x4a55d0['push'](_0x81f0('0x7a'));}break;case'email':if(isEmail(_0x56f45b)){_0x1f0374[_0x81f0('0x22')]('\x22'+_0x56f45b+'\x22');}else{_0x4a55d0['push'](_0x81f0('0x7b'));}break;case _0x81f0('0x7c'):var _0x4439f1=moment(_0x56f45b,_0x81f0('0x7d'),!![]);if(_0x4439f1[_0x81f0('0x75')]()){_0x1f0374['push']('\x22'+_0x56f45b+'\x22');}else{_0x4a55d0['push'](_0x81f0('0x7e'));}break;default:_0x1f0374[_0x81f0('0x22')]('\x22'+_0x56f45b+'\x22');}}else{switch(_0x56f797){case _0x81f0('0x7f'):case'phone':_0x4a55d0[_0x81f0('0x22')](_0x56f797+_0x81f0('0x80'));break;default:_0x1f0374['push']('\x22\x22');}}}}else{var _0x46e6a3='';for(var _0x7cf270=0x0;_0x7cf270<_0x1cb1df[_0x56f797][_0x81f0('0x1f')];_0x7cf270++){var _0x56f45b=_[_0x81f0('0x71')](_0xce1313[_0x81f0('0x6d')][_0x3d8edc][_0x1cb1df[_0x56f797][_0x7cf270]]['replace'](/"/g,'\x27'));if(_0x46e6a3=='')_0x46e6a3=_0x56f45b;else _0x46e6a3+='|'+_0x56f45b;}_0x407164[_0x81f0('0x22')](_0x293233['id']+':'+_0x46e6a3);}}if(hasAdditionalPhones){_0x1f0374[_0x81f0('0x22')]('\x22'+_0x407164[_0x81f0('0x17')](';')+'\x22');}if(_0x4a55d0[_0x81f0('0x1f')]){handleError(_0xce1313[_0x81f0('0x6d')][_0x3d8edc],{'code':_0x81f0('0x81'),'message':_0x4a55d0[_0x81f0('0x17')]()});}else{fs[_0x81f0('0x82')](_0x4065b2,_0x1f0374[_0x81f0('0x17')]()+'\x0a');}_0x1f0374=[];}if(!(stats[_0x81f0('0x6e')]%0xc8)){socket['emit']('contact:import:'+_0xa02fe7,stats);stats[_0x81f0('0x60')]=[];}}if(stopped){logger[_0x81f0('0x62')](_0x81f0('0x83'));_0xe08521[_0x81f0('0x84')]();}}catch(_0x17ff7e){handleError(_0xce1313['data'][_0x3d8edc],{'code':_0x81f0('0x85'),'message':_0x17ff7e['message']});logger[_0x81f0('0x25')](_0x81f0('0x86'),_0x17ff7e[_0x81f0('0x26')]);}},'complete':function(){try{var _0x2b0760=[];var _0x447f57=tempTableName;_0x2b0760['push']('CREATE\x20TABLE\x20'+_0x447f57+_0x81f0('0x87'));logger[_0x81f0('0x62')](_0x81f0('0x88'),contactItemTypes[_0x81f0('0x1f')]);var _0x2caa51=util[_0x81f0('0x10')]('LOAD\x20DATA\x20LOCAL\x20INFILE\x20\x27%s\x27\x20INTO\x20TABLE\x20%s\x20CHARACTER\x20SET\x20UTF8\x20FIELDS\x20TERMINATED\x20BY\x20\x27,\x27\x20ENCLOSED\x20BY\x20\x27\x22\x27\x20LINES\x20TERMINATED\x20BY\x20\x27\x0a\x27\x20IGNORE\x201\x20ROWS\x20(%s)\x20SET\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27',_0x4065b2,_0x447f57,_0xf5e8b7,_0x11493c[_0x81f0('0x3b')],_0x11493c[_0x81f0('0x5a')]||null,NOW,NOW);if(_['isNil'](_0x1cb1df['scheduledat'])){_0x2caa51+=',\x20scheduledAt\x20=\x20NOW()';}_0x2b0760[_0x81f0('0x22')](_0x2caa51);BPromise[_0x81f0('0x89')](_0x2b0760,handleQuery)[_0x81f0('0x28')](function(_0x1b01ed){BPromise[_0x81f0('0x23')]([handleAdditionalPhones()])[_0x81f0('0x28')](function(){_0x2b0760=[];for(var _0x52d1cd=0x0;_0x52d1cd<promisesContact[_0x81f0('0x1f')];_0x52d1cd++){_0x2b0760['push'](updateContact(promisesContact[_0x52d1cd][_0x81f0('0x8a')]));}BPromise[_0x81f0('0x23')](_0x2b0760)[_0x81f0('0x28')](function(){_0x2b0760=[];for(var _0x2afc15=0x0;_0x2afc15<promisesAdditionalPhones['length'];_0x2afc15++){_0x2b0760['push'](createAdditionalPhone(promisesAdditionalPhones[_0x2afc15]['contactId'],promisesAdditionalPhones[_0x2afc15][_0x81f0('0x8b')],promisesAdditionalPhones[_0x2afc15][_0x81f0('0x15')],promisesAdditionalPhones[_0x2afc15][_0x81f0('0x8c')]));}BPromise[_0x81f0('0x23')](_0x2b0760)[_0x81f0('0x28')](function(){_0x2b0760=[];_0x2b0760[_0x81f0('0x22')](insertCmHopperAdditionalPhones(_0x11493c[_0x81f0('0x3b')]));_0x2b0760[_0x81f0('0x22')](_0x81f0('0x8d')+_0x447f57+';');BPromise[_0x81f0('0x89')](_0x2b0760,handleQuery)[_0x81f0('0x28')](function(_0x3a88be){stats[_0x81f0('0x8e')]=!![];stats[_0x81f0('0x8f')]=updatedRows;socket[_0x81f0('0x90')](_0x81f0('0x91')+_0xa02fe7,stats);fs[_0x81f0('0x92')](_0x57966b);fs[_0x81f0('0x92')](_0x4065b2);process[_0x81f0('0x5f')](0x0);})[_0x81f0('0x24')](function(_0x4eb51d){logger[_0x81f0('0x25')](_0x4eb51d['message']);process['exit'](0x1);});});});});})[_0x81f0('0x24')](function(_0x3db73f){logger[_0x81f0('0x25')](_0x3db73f[_0x81f0('0x26')]);process[_0x81f0('0x5f')](0x1);});}catch(_0xcf2d6){logger['error']('complete',_0xcf2d6['message']);process[_0x81f0('0x5f')](0x1);}},'error':function(_0x51486e,_0xad5c2b,_0x4b0f03,_0x537de8){throw new Error(_0x537de8);}});});}function validate(){if(process[_0x81f0('0x93')]&&process[_0x81f0('0x93')][_0x81f0('0x1f')]<0x4){throw new Error(_0x81f0('0x94'));}var _0xa08dde=path[_0x81f0('0x17')](config[_0x81f0('0x66')],_0x81f0('0x67'),process[_0x81f0('0x93')][0x2]);if(!fs[_0x81f0('0x95')](_0xa08dde)){throw new Error('file\x20doesn\x27t\x20exists');}var _0xf7e4a8={};try{_0xf7e4a8=JSON[_0x81f0('0x96')](process[_0x81f0('0x93')][0x3]);if(!_0xf7e4a8[_0x81f0('0x64')]){throw new Error(_0x81f0('0x97'));}var _0x139c0e=0x0;if(_0xf7e4a8['binding'][_0x81f0('0x3d')]){_0x139c0e=0x1;}if(!_0xf7e4a8[_0x81f0('0x3b')]){throw new Error(_0x81f0('0x98'));}}catch(_0x3cc747){throw new Error(_0x81f0('0x99'));}var _0xf70596=[];try{_0xf70596=_[_0x81f0('0x9a')](JSON[_0x81f0('0x96')](process[_0x81f0('0x93')][0x4]),'id');}catch(_0x564d36){logger['info']('No\x20agent\x20available');}main(_0xa08dde,_0xf7e4a8,_0xf70596,_0x139c0e);}validate();process['on'](_0x81f0('0x9b'),handleStop);process['on'](_0x81f0('0x9c'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff