// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xc19f=['data','rows','errors','find','hasOwnProperty','trim','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','UserId','isNumber','includes','agent\x20not\x20exists','email','email\x20wrong\x20format','dateOfBirth','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','replace','itemTypeId','description','SystemRow','appendFileSync','emit','Abort\x20parser','abort','SystemError','step','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','CIS\x20len','LOAD\x20DATA\x20LOCAL\x20INFILE\x20\x27%s\x27\x20INTO\x20TABLE\x20%s\x20CHARACTER\x20SET\x20UTF8\x20FIELDS\x20TERMINATED\x20BY\x20\x27,\x27\x20ENCLOSED\x20BY\x20\x27\x22\x27\x20LINES\x20TERMINATED\x20BY\x20\x27\x0a\x27\x20IGNORE\x201\x20ROWS\x20(%s)\x20SET\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27','CompanyId','each','contact','contactId','DROP\x20TABLE\x20','finish','contact:import:','unlink','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','binding\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','No\x20agent\x20available','SIGINT','uncaughtException','papaparse','util','squel','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','import','redis','socket.io-emitter','format','YYYY-MM-DD\x20HH:mm:ss','cm_contacts_temp_','YYYYMMDDHHmmss','field','phone','join','.id\x20=\x20','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','sequelize','query','select\x20*\x20from\x20','spread','length','isNil','AdditionalPhones','push','all','then','catch','error','message','split','filter','findOne','CmContactHasItem','updated','create','PHONE','CmContact','update','CmHopper','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','insert','cm_hopper','fromQuery','scheduledat','ListId','createdAt','updatedAt','priority','from','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22onlyIfOpen\x22','\x22always\x22','toString','cm_contacts.createdAt','into','cm_hopper_black','ContactId','fields','ListId\x20=\x20?','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','CmHopperId','select','cm_contact_has_items','cm_hopper.ListId\x20=\x20?','concat','id\x20IN\x20?','min_id','group','Received\x20SIGINT','exit','info','main','stringify','send','start','binding','clone','socket_timestamp','root','body','ContactItemType','findAll','name','_description','header','writeFileSync','parse','createReadStream'];(function(_0x21e034,_0x59fc14){var _0x1faab3=function(_0x2bd3ba){while(--_0x2bd3ba){_0x21e034['push'](_0x21e034['shift']());}};_0x1faab3(++_0x59fc14);}(_0xc19f,0x164));var _0xfc19=function(_0x585481,_0x16e775){_0x585481=_0x585481-0x0;var _0x2ac3b7=_0xc19f[_0x585481];return _0x2ac3b7;};'use strict';var fs=require('fs');var path=require('path');var _=require('lodash');var Papa=require(_0xfc19('0x0'));var util=require(_0xfc19('0x1'));var BPromise=require('bluebird');var moment=require('moment');var squel=require(_0xfc19('0x2'));var Redis=require(_0xfc19('0x3'));var db=require(_0xfc19('0x4'))['db'];var config=require(_0xfc19('0x5'));var logger=require(_0xfc19('0x6'))(_0xfc19('0x7'));config[_0xfc19('0x8')]=_['defaults'](config['redis'],{'host':'localhost','port':0x18eb});var socket=require(_0xfc19('0x9'))(new Redis(config[_0xfc19('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()[_0xfc19('0xa')](_0xfc19('0xb'));var tempTableName=_0xfc19('0xc')+moment()[_0xfc19('0xa')](_0xfc19('0xd'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];function isEmail(_0x2b1a67){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'](_0x2b1a67);}function selectNotIn(_0x4da686,_0x3ba4c4,_0x3b78cf,_0x49776d,_0x45791b){return squel['select']()[_0xfc19('0xe')](_0xfc19('0xf'))['from'](_0x49776d)[_0xfc19('0x10')](_0x3ba4c4,null,_0x3ba4c4+_0xfc19('0x11')+_0x49776d+'.'+_0x3b78cf)['where'](_0x49776d+'.'+_0x3b78cf+_0xfc19('0x12')+_0x4da686+'.'+_0x3b78cf)[_0xfc19('0x13')](_0x3ba4c4+_0xfc19('0x14')+_0x45791b[_0xfc19('0x10')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x158b36,_0x4f4b84){promisesAdditionalPhones=[];promisesContact=[];return db[_0xfc19('0x15')][_0xfc19('0x16')](_0xfc19('0x17')+tempTableName)[_0xfc19('0x18')](function(_0x414011){if(_0x414011!==null){var _0x3201b2=[];for(var _0x30a3af=0x0;_0x30a3af<_0x414011[_0xfc19('0x19')];_0x30a3af++){var _0x4186fe=_0x414011[_0x30a3af];if(!_[_0xfc19('0x1a')](_0x4186fe[_0xfc19('0xf')])){if(!_[_0xfc19('0x1a')](_0x4186fe[_0xfc19('0x1b')]))_0x3201b2[_0xfc19('0x1c')](insertAdditionalPhones(_0x4186fe));promisesContact[_0xfc19('0x1c')]({'contact':_0x4186fe});}}}Promise[_0xfc19('0x1d')](_0x3201b2)[_0xfc19('0x1e')](function(){_0x158b36({'val':0x1});});})[_0xfc19('0x1f')](function(_0x41c0db){logger[_0xfc19('0x20')](_0x41c0db[_0xfc19('0x21')]);});});}function insertAdditionalPhones(_0x539a4d){return new Promise(function(_0x2a4d18,_0x58b64e){var _0xef1dbd=_0x539a4d[_0xfc19('0x1b')];if(_[_0xfc19('0x1a')](_0xef1dbd))_0x58b64e({'val':0x0});else{var _0x47f21c=_0xef1dbd[_0xfc19('0x22')](';');var _0x1e31df=[];orderBy=0x0;for(var _0x4f8fef=0x0;_0x4f8fef<_0x47f21c[_0xfc19('0x19')];_0x4f8fef++){_0x1e31df[_0xfc19('0x1c')](splitAdditionalPhone(_0x539a4d['id'],_0x47f21c[_0x4f8fef]));}Promise['all'](_0x1e31df)['then'](function(){_0x2a4d18({'val':_0x47f21c[_0xfc19('0x19')]});});}});}function splitAdditionalPhone(_0x4e7c72,_0x2f9b20){return new Promise(function(_0x479756,_0x1cb08f){var _0x45e020=_0x2f9b20[_0xfc19('0x22')](':');var _0x4883f1=_0x45e020[0x0];var _0xe77f34=_0x45e020[0x1];if(_0xe77f34!==''){var _0xc302a8=_0xe77f34[_0xfc19('0x22')]('|');var _0x3e6b53=[];for(var _0xbec1bc=0x0;_0xbec1bc<_0xc302a8[_0xfc19('0x19')];_0xbec1bc++){if(_0xc302a8[_0xbec1bc]!==''){var _0x40c66d=_[_0xfc19('0x23')](promisesAdditionalPhones,{'contactId':_0x4e7c72,'phone':_0xc302a8[_0xbec1bc]});if(_0x40c66d[_0xfc19('0x19')]==0x0){orderBy++;promisesAdditionalPhones['push']({'contactId':_0x4e7c72,'contactTypeId':_0x4883f1,'phone':_0xc302a8[_0xbec1bc],'orderBy':orderBy});}}}_0x479756({'ok':0x1});}else _0x479756({'res':0x0});});}function createAdditionalPhone(_0x3eac40,_0x126a5b,_0x55803d,_0x10f5d5){var _0x2bc6b4='';var _0x39a706='';var _0xe36510=_0x55803d['split']('§');_0x2bc6b4=_0xe36510[0x0];if(_0xe36510[_0xfc19('0x19')]==0x2)_0x39a706=_0xe36510[0x1];return new Promise(function(_0x220abd,_0x2932bd){return db['CmContactHasItem'][_0xfc19('0x24')]({'where':{'CmContactId':_0x3eac40,'item':_0x2bc6b4}})[_0xfc19('0x1e')](function(_0x54a8d9){if(_0x54a8d9){return db[_0xfc19('0x25')]['update']({'ItemTypeId':_0x126a5b,'description':_0x39a706,'OrderBy':_0x10f5d5},{'where':{'CmContactId':_0x3eac40,'item':_0x2bc6b4}})[_0xfc19('0x1e')](function(_0x513e50){_0x220abd({'res':_0xfc19('0x26')});});}else{return db[_0xfc19('0x25')][_0xfc19('0x27')]({'CmContactId':_0x3eac40,'item':_0x2bc6b4,'ItemTypeId':_0x126a5b,'description':_0x39a706,'OrderBy':_0x10f5d5,'ItemClass':_0xfc19('0x28')})[_0xfc19('0x1e')](function(_0x4f8faa){_0x220abd({'res':'inserted'});});}});});}function updateContact(_0x13806d){return new Promise(function(_0x553a59,_0x2d8e2e){var _0x2906da=_0x13806d['id'];delete _0x13806d['id'];return db[_0xfc19('0x29')][_0xfc19('0x2a')](_0x13806d,{'where':{'id':_0x2906da}})[_0xfc19('0x1e')](function(_0x269014){updatedRows+=0x1;return db[_0xfc19('0x2b')][_0xfc19('0x2a')]({'phone':_0x13806d[_0xfc19('0xf')]},{'where':{'ContactId':_0x2906da}})[_0xfc19('0x1e')](function(_0xf34e73){_0x553a59({'ret':'OK'});});});});}function insertCmHopper(_0xfb3c0,_0x3ef069,_0x3b24bc,_0x3b8844,_0x2dfea5){var _0xc55bf6=[_0xfc19('0x2c'),_0xfc19('0x2d'),_0xfc19('0x2e'),'cm_contacts.ListId',_0x3ef069+'.'+_0x3b8844,'cm_contacts.createdAt',_0xfc19('0x2f'),_0xfc19('0x30'),_0xfc19('0x31'),'\x22'+_0x2dfea5+'\x22'];return squel[_0xfc19('0x32')]()['into'](_0xfc19('0x33'))[_0xfc19('0x34')]([_0xfc19('0xf'),_0xfc19('0x35'),'ContactId',_0xfc19('0x36'),_0x3b8844,_0xfc19('0x37'),_0xfc19('0x38'),_0xfc19('0x39'),'UserId','recallme'],squel['select']()['fields'](_0xc55bf6)[_0xfc19('0x3a')](_0x3ef069)[_0xfc19('0x10')](_0xfc19('0x3b'),null,_0xfc19('0x3c')+_0x3ef069+_0xfc19('0x3d'))[_0xfc19('0x10')](_0x3b24bc,null,_0x3b24bc+_0xfc19('0x11')+_0x3ef069+'.'+_0x3b8844)[_0xfc19('0x13')](_0x3ef069+_0xfc19('0x3e'),_0xfb3c0)[_0xfc19('0x13')](_0xfc19('0x3f'),NOW)[_0xfc19('0x13')](_0xfc19('0x40'),selectNotIn(_0x3ef069,_0x3b24bc,_0x3b8844,_0xfc19('0x33'),['\x22always\x22',_0xfc19('0x41')]))[_0xfc19('0x13')](_0xfc19('0x40'),selectNotIn(_0x3ef069,_0x3b24bc,_0x3b8844,_0xfc19('0x33'),[_0xfc19('0x42')])))[_0xfc19('0x43')]();}function insertCmHopperBlack(_0x1d4b9b,_0x3bb022,_0x27caad,_0x2594c5){var _0x34cc70=[_0xfc19('0x2c'),_0xfc19('0x2e'),'cm_contacts.ListId',_0x3bb022+'.'+_0x2594c5,_0xfc19('0x44'),'cm_contacts.updatedAt'];return squel[_0xfc19('0x32')]()[_0xfc19('0x45')](_0xfc19('0x46'))[_0xfc19('0x34')]([_0xfc19('0xf'),_0xfc19('0x47'),_0xfc19('0x36'),_0x2594c5,_0xfc19('0x37'),_0xfc19('0x38')],squel['select']()[_0xfc19('0x48')](_0x34cc70)[_0xfc19('0x3a')](_0x3bb022)['join'](_0xfc19('0x3b'),null,'cm_contacts.ListId\x20=\x20'+_0x3bb022+_0xfc19('0x3d'))[_0xfc19('0x10')](_0x27caad,null,_0x27caad+_0xfc19('0x11')+_0x3bb022+'.'+_0x2594c5)[_0xfc19('0x13')](_0x3bb022+_0xfc19('0x3e'),_0x1d4b9b)[_0xfc19('0x13')](_0xfc19('0x3f'),NOW)[_0xfc19('0x13')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel['select']()[_0xfc19('0xe')](_0xfc19('0xf'))[_0xfc19('0x3a')](_0xfc19('0x46'))[_0xfc19('0x13')](_0xfc19('0x49'),_0x1d4b9b)[_0xfc19('0x13')](_0x2594c5+'\x20=\x20?',_0x3bb022+'.'+_0x2594c5)))[_0xfc19('0x43')]();}function insertCmHopperAdditionalPhones(_0x8c8178){var _0x718df4=['cm_hopper.id','cm_contact_has_items.item',_0xfc19('0x4a'),_0xfc19('0x4b'),_0xfc19('0x4c')];return squel[_0xfc19('0x32')]()[_0xfc19('0x45')](_0xfc19('0x4d'))[_0xfc19('0x34')]([_0xfc19('0x4e'),'phone','OrderBy',_0xfc19('0x37'),'updatedAt'],squel[_0xfc19('0x4f')]()[_0xfc19('0x48')](_0x718df4)['from'](_0xfc19('0x33'))[_0xfc19('0x10')](_0xfc19('0x3b'),null,'cm_contacts.id\x20=\x20cm_hopper.ContactId')[_0xfc19('0x10')](_0xfc19('0x50'),null,'cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId')['where'](_0xfc19('0x51'),_0x8c8178)[_0xfc19('0x13')](_0xfc19('0x3f'),NOW))[_0xfc19('0x43')]();}function insertCmContact(_0x16ab97,_0x873e99,_0x168ffb,_0x2a9806){var _0x37ac16=_[_0xfc19('0x52')](_['keys'](_0x2a9806),[_0xfc19('0x36'),'CompanyId',_0xfc19('0x37'),_0xfc19('0x38')]);return squel[_0xfc19('0x32')]()[_0xfc19('0x45')](_0xfc19('0x3b'))[_0xfc19('0x34')](_0x37ac16,squel[_0xfc19('0x4f')]()[_0xfc19('0x48')](_0x37ac16)[_0xfc19('0x3a')](_0x873e99)[_0xfc19('0x13')]('('+_0x168ffb[_0xfc19('0x10')](',')+')\x20NOT\x20IN\x20?',squel['select']()['fields'](_0x168ffb)[_0xfc19('0x3a')]('cm_contacts')[_0xfc19('0x13')](_0xfc19('0x49'),_0x16ab97))[_0xfc19('0x13')](_0xfc19('0x53'),squel[_0xfc19('0x4f')]()['field']('MIN(id)',_0xfc19('0x54'))[_0xfc19('0x3a')](_0x873e99)[_0xfc19('0x55')](_0x168ffb[_0xfc19('0x10')](','))))[_0xfc19('0x43')]();}function handleStop(){logger['info'](_0xfc19('0x56'));stopped=!![];}function handleUncaughtException(_0x446f0a){logger['error'](_0x446f0a['message']);process[_0xfc19('0x57')](0x1);}function handleError(_0xeeca4d,_0x5c4ebd){stats['errors'][_0xfc19('0x1c')]({'name':_0x5c4ebd['code'],'message':_0x5c4ebd[_0xfc19('0x21')],'row':_0xeeca4d});}function handleQuery(_0x42fe5d){logger['info'](_0x42fe5d);return db[_0xfc19('0x15')]['query'](_0x42fe5d)[_0xfc19('0x18')](function(_0x13a436){results[_0xfc19('0x1c')](_0x13a436);})['catch'](function(_0x23dcae){logger[_0xfc19('0x20')](_0x23dcae['message']);});}function main(_0x520dc0,_0x385f40,_0x2979ab,_0x47125b){logger[_0xfc19('0x58')](_0xfc19('0x59'),_0x520dc0,JSON[_0xfc19('0x5a')](_0x385f40));process[_0xfc19('0x5b')](_0xfc19('0x5c'));var _0x341d8b=_0x385f40[_0xfc19('0x5d')];var _0x3860fb=_[_0xfc19('0x5e')](_0x341d8b);var _0xcbec62=_0x385f40[_0xfc19('0x5f')];var _0x1c21a5=path[_0xfc19('0x10')](config[_0xfc19('0x60')],'server/files/tmp',_0xcbec62+'.csv');logger[_0xfc19('0x58')](_0xfc19('0x61'),_0x385f40);db[_0xfc19('0x62')][_0xfc19('0x63')]({'raw':!![],'attributes':['id',_0xfc19('0x64')]})[_0xfc19('0x1e')](function(_0x154056){for(var _0x70799a=0x0;_0x70799a<_0x154056[_0xfc19('0x19')];_0x70799a++){if(_0x154056[_0x70799a][_0xfc19('0x64')]in _0x341d8b){contactItemTypes[_0xfc19('0x1c')](_0x154056[_0x70799a]);delete _0x3860fb[_0x154056[_0x70799a][_0xfc19('0x64')]];hasAdditionalPhones=!![];}for(var _0x225b73 in _0x341d8b){if(_0x154056[_0x70799a]['name']+_0xfc19('0x65')===_0x225b73){phoneDescriptions['push']({'itemTypeId':_0x154056[_0x70799a]['id'],'description':_0x225b73});delete _0x3860fb[_0x225b73];}}}if(hasAdditionalPhones)_0x3860fb[_0xfc19('0x1b')]='';var _0x243b88=_['keys'](_0x3860fb)['join']();logger[_0xfc19('0x58')](_0xfc19('0x66'),_0x243b88);fs[_0xfc19('0x67')](_0x1c21a5,_0x243b88+'\x0a');Papa[_0xfc19('0x68')](fs[_0xfc19('0x69')](_0x520dc0),{'header':!![],'skipEmptyLines':!![],'step':function(_0x7e0a6d,_0x51de0b){try{for(var _0x57b6a7=0x0,_0x5ed3af=[];_0x57b6a7<_0x7e0a6d[_0xfc19('0x6a')][_0xfc19('0x19')];_0x57b6a7++){stats[_0xfc19('0x6b')]+=0x1;if(_0x7e0a6d[_0xfc19('0x6c')][_0x57b6a7]){handleError(_0x7e0a6d[_0xfc19('0x6a')][_0x57b6a7],_0x7e0a6d['errors'][_0x57b6a7]);}else{var _0x3493ed=[];var _0x47fb9e=[];var _0x1f2e46={};for(var _0x1e47ad in _0x341d8b){let _0x24613e=contactItemTypes[_0xfc19('0x6d')](_0x4f1c53=>_0x4f1c53['name']===_0x1e47ad);let _0x3cd487=contactItemTypes[_0xfc19('0x6d')](_0x188a62=>_0x188a62[_0xfc19('0x64')]+_0xfc19('0x65')===_0x1e47ad);if(_[_0xfc19('0x1a')](_0x24613e)&&_['isNil'](_0x3cd487)){if(_0x341d8b[_0xfc19('0x6e')](_0x1e47ad)){if(_0x7e0a6d[_0xfc19('0x6a')][_0x57b6a7][_0x341d8b[_0x1e47ad]]){var _0x338e3c=_[_0xfc19('0x6f')](_0x7e0a6d[_0xfc19('0x6a')][_0x57b6a7][_0x341d8b[_0x1e47ad]]['replace'](/"/g,'\x27'));switch(_0x1e47ad){case'scheduledat':var _0xadf8f1=moment(_0x338e3c,'YYYY-MM-DD\x20HH:mm:ss',!![]);if(_0xadf8f1[_0xfc19('0x70')]()){_0x5ed3af[_0xfc19('0x1c')]('\x22'+_0x338e3c+'\x22');}else{_0x3493ed[_0xfc19('0x1c')](_0xfc19('0x71'));}break;case _0xfc19('0x39'):var _0x4d5768=parseInt(_0x338e3c);_0x338e3c=_['isNaN'](_0x4d5768)||_0x4d5768<0x0||_0x4d5768>0x4?_0x47125b?0x3:0x2:_0x4d5768;_0x5ed3af[_0xfc19('0x1c')]('\x22'+_0x338e3c+'\x22');break;case _0xfc19('0x72'):var _0x7af69a=parseInt(_0x338e3c);if(_[_0xfc19('0x73')](_0x7af69a)&&_[_0xfc19('0x74')](_0x2979ab,_0x7af69a)){_0x5ed3af[_0xfc19('0x1c')]('\x22'+_0x7af69a+'\x22');}else{_0x3493ed[_0xfc19('0x1c')](_0xfc19('0x75'));}break;case _0xfc19('0x76'):if(isEmail(_0x338e3c)){_0x5ed3af['push']('\x22'+_0x338e3c+'\x22');}else{_0x3493ed[_0xfc19('0x1c')](_0xfc19('0x77'));}break;case _0xfc19('0x78'):var _0x251a25=moment(_0x338e3c,'YYYY-MM-DD',!![]);if(_0x251a25[_0xfc19('0x70')]()){_0x5ed3af[_0xfc19('0x1c')]('\x22'+_0x338e3c+'\x22');}else{_0x3493ed[_0xfc19('0x1c')](_0xfc19('0x79'));}break;default:_0x5ed3af[_0xfc19('0x1c')]('\x22'+_0x338e3c+'\x22');}}else{switch(_0x1e47ad){case'firstName':case _0xfc19('0xf'):_0x3493ed[_0xfc19('0x1c')](_0x1e47ad+'\x20not\x20specified');break;default:_0x5ed3af[_0xfc19('0x1c')]('\x22\x22');}}}}else{var _0x32e55b='';if(!_['isNil'](_0x24613e)){if(!_0x1f2e46[_0xfc19('0x6e')](_0x24613e['id'])){for(var _0x516f2c=0x0;_0x516f2c<_0x341d8b[_0x1e47ad][_0xfc19('0x19')];_0x516f2c++){var _0x338e3c=_[_0xfc19('0x6f')](_0x7e0a6d['data'][_0x57b6a7][_0x341d8b[_0x1e47ad][_0x516f2c]][_0xfc19('0x7a')](/"/g,'\x27'));var _0x42eab0=phoneDescriptions[_0xfc19('0x6d')](_0x4c1326=>_0x4c1326[_0xfc19('0x7b')]===_0x24613e['id']);if(!_[_0xfc19('0x1a')](_0x42eab0)){var _0x14810b=_[_0xfc19('0x6f')](_0x7e0a6d[_0xfc19('0x6a')][_0x57b6a7][_0x341d8b[_0x42eab0[_0xfc19('0x7c')]][0x0]][_0xfc19('0x7a')](/"/g,'\x27'));if(!_['isNil'](_0x14810b))_0x338e3c=_0x338e3c+'§'+_0x14810b;}if(_0x32e55b=='')_0x32e55b=_0x338e3c;else _0x32e55b+='|'+_0x338e3c;}_0x47fb9e['push'](_0x24613e['id']+':'+_0x32e55b);_0x1f2e46[_0x24613e['id']]=0x1;}}}}if(hasAdditionalPhones){_0x5ed3af['push']('\x22'+_0x47fb9e[_0xfc19('0x10')](';')+'\x22');}if(_0x3493ed[_0xfc19('0x19')]){handleError(_0x7e0a6d['data'][_0x57b6a7],{'code':_0xfc19('0x7d'),'message':_0x3493ed['join']()});}else{fs[_0xfc19('0x7e')](_0x1c21a5,_0x5ed3af[_0xfc19('0x10')]()+'\x0a');}_0x5ed3af=[];}if(!(stats[_0xfc19('0x6b')]%0xc8)){socket[_0xfc19('0x7f')]('contact:import:'+_0xcbec62,stats);stats['errors']=[];}}if(stopped){logger[_0xfc19('0x58')](_0xfc19('0x80'));_0x51de0b[_0xfc19('0x81')]();}}catch(_0x3368f1){handleError(_0x7e0a6d[_0xfc19('0x6a')][_0x57b6a7],{'code':_0xfc19('0x82'),'message':_0x3368f1['message']});logger['error'](_0xfc19('0x83'),_0x3368f1[_0xfc19('0x21')]);}},'complete':function(){try{var _0x25d313=[];var _0x22983d=tempTableName;_0x25d313[_0xfc19('0x1c')](_0xfc19('0x84')+_0x22983d+_0xfc19('0x85'));logger[_0xfc19('0x58')](_0xfc19('0x86'),contactItemTypes[_0xfc19('0x19')]);var _0x50bd1e=util[_0xfc19('0xa')](_0xfc19('0x87'),_0x1c21a5,_0x22983d,_0x243b88,_0x385f40[_0xfc19('0x36')],_0x385f40[_0xfc19('0x88')]||null,NOW,NOW);if(_[_0xfc19('0x1a')](_0x341d8b[_0xfc19('0x35')])){_0x50bd1e+=',\x20scheduledAt\x20=\x20NOW()';}_0x25d313[_0xfc19('0x1c')](_0x50bd1e);BPromise[_0xfc19('0x89')](_0x25d313,handleQuery)[_0xfc19('0x1e')](function(_0xeacfb5){BPromise[_0xfc19('0x1d')]([handleAdditionalPhones()])[_0xfc19('0x1e')](function(){_0x25d313=[];for(var _0xe7b0c6=0x0;_0xe7b0c6<promisesContact['length'];_0xe7b0c6++){_0x25d313[_0xfc19('0x1c')](updateContact(promisesContact[_0xe7b0c6][_0xfc19('0x8a')]));}BPromise['all'](_0x25d313)[_0xfc19('0x1e')](function(){_0x25d313=[];for(var _0x1e9241=0x0;_0x1e9241<promisesAdditionalPhones['length'];_0x1e9241++){_0x25d313[_0xfc19('0x1c')](createAdditionalPhone(promisesAdditionalPhones[_0x1e9241][_0xfc19('0x8b')],promisesAdditionalPhones[_0x1e9241]['contactTypeId'],promisesAdditionalPhones[_0x1e9241]['phone'],promisesAdditionalPhones[_0x1e9241]['orderBy']));}BPromise[_0xfc19('0x1d')](_0x25d313)[_0xfc19('0x1e')](function(){_0x25d313=[];_0x25d313[_0xfc19('0x1c')](insertCmHopperAdditionalPhones(_0x385f40['ListId']));_0x25d313[_0xfc19('0x1c')](_0xfc19('0x8c')+_0x22983d+';');BPromise[_0xfc19('0x89')](_0x25d313,handleQuery)[_0xfc19('0x1e')](function(_0x139cb5){stats[_0xfc19('0x8d')]=!![];stats['affectedRows']=updatedRows;socket[_0xfc19('0x7f')](_0xfc19('0x8e')+_0xcbec62,stats);fs[_0xfc19('0x8f')](_0x520dc0);fs[_0xfc19('0x8f')](_0x1c21a5);process[_0xfc19('0x57')](0x0);})[_0xfc19('0x1f')](function(_0x2d2bf3){logger[_0xfc19('0x20')](_0x2d2bf3['message']);process[_0xfc19('0x57')](0x1);});});});});})[_0xfc19('0x1f')](function(_0x3a87ca){logger[_0xfc19('0x20')](_0x3a87ca['message']);process[_0xfc19('0x57')](0x1);});}catch(_0x151942){logger['error']('complete',_0x151942[_0xfc19('0x21')]);process[_0xfc19('0x57')](0x1);}},'error':function(_0x4c512c,_0x4d5da3,_0x4e2f74,_0x2c4d56){throw new Error(_0x2c4d56);}});});}function validate(){if(process['argv']&&process[_0xfc19('0x90')][_0xfc19('0x19')]<0x4){throw new Error(_0xfc19('0x91'));}var _0x16193d=path[_0xfc19('0x10')](config[_0xfc19('0x60')],'server/files/tmp',process[_0xfc19('0x90')][0x2]);if(!fs[_0xfc19('0x92')](_0x16193d)){throw new Error('file\x20doesn\x27t\x20exists');}var _0x5a58ad={};try{_0x5a58ad=JSON[_0xfc19('0x68')](process[_0xfc19('0x90')][0x3]);if(!_0x5a58ad[_0xfc19('0x5d')]){throw new Error(_0xfc19('0x93'));}var _0x56e9d5=0x0;if(_0x5a58ad[_0xfc19('0x5d')]['UserId']){_0x56e9d5=0x1;}if(!_0x5a58ad[_0xfc19('0x36')]){throw new Error(_0xfc19('0x94'));}}catch(_0x5402f9){throw new Error(_0xfc19('0x95'));}var _0xc37073=[];try{_0xc37073=_[_0xfc19('0x96')](JSON[_0xfc19('0x68')](process[_0xfc19('0x90')][0x4]),'id');}catch(_0xfda412){logger[_0xfc19('0x58')](_0xfc19('0x97'));}main(_0x16193d,_0x5a58ad,_0xc37073,_0x56e9d5);}validate();process['on'](_0xfc19('0x98'),handleStop);process['on'](_0xfc19('0x99'),handleUncaughtException);
\ No newline at end of file
+var _0xeca8=['\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','contactId','contactTypeId','orderBy','DROP\x20TABLE\x20','finish','contact:import:','unlink','complete','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','path','lodash','papaparse','util','bluebird','moment','ioredis','../../../config/environment','../../../config/logger','import','defaults','redis','localhost','socket.io-emitter','format','cm_contacts_temp_','YYYYMMDDHHmmss','test','field','from','join','where','sequelize','query','select\x20*\x20from\x20','spread','isNil','AdditionalPhones','push','all','then','catch','error','split','length','filter','findOne','CmContactHasItem','update','updated','inserted','CmContact','phone','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.priority','insert','into','fromQuery','scheduledat','ContactId','ListId','createdAt','updatedAt','priority','UserId','recallme','select','fields','cm_contacts','.CmListId','.id\x20=\x20','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','\x22always\x22','cm_contacts.phone\x20NOT\x20IN\x20(?)','cm_contacts.updatedAt','cm_contacts.ListId\x20=\x20','cm_hopper_black','ListId\x20=\x20?','\x20=\x20?','toString','cm_contact_has_items.item','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','CmHopperId','OrderBy','cm_hopper','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys',')\x20NOT\x20IN\x20?','id\x20IN\x20?','MIN(id)','group','info','message','exit','code','stringify','start','clone','socket_timestamp','root','server/files/tmp','.csv','ContactItemType','findAll','name','_description','header','writeFileSync','parse','createReadStream','errors','data','find','trim','replace','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','includes','agent\x20not\x20exists','email','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','itemTypeId','description','SystemRow','appendFileSync','rows','emit','Abort\x20parser','abort','CREATE\x20TABLE\x20'];(function(_0x4d6e5d,_0x4cf785){var _0x51c166=function(_0x30ef09){while(--_0x30ef09){_0x4d6e5d['push'](_0x4d6e5d['shift']());}};_0x51c166(++_0x4cf785);}(_0xeca8,0x1f2));var _0x8eca=function(_0x258f0b,_0x4833e3){_0x258f0b=_0x258f0b-0x0;var _0x10af40=_0xeca8[_0x258f0b];return _0x10af40;};'use strict';var fs=require('fs');var path=require(_0x8eca('0x0'));var _=require(_0x8eca('0x1'));var Papa=require(_0x8eca('0x2'));var util=require(_0x8eca('0x3'));var BPromise=require(_0x8eca('0x4'));var moment=require(_0x8eca('0x5'));var squel=require('squel');var Redis=require(_0x8eca('0x6'));var db=require('../../../mysqldb')['db'];var config=require(_0x8eca('0x7'));var logger=require(_0x8eca('0x8'))(_0x8eca('0x9'));config['redis']=_[_0x8eca('0xa')](config[_0x8eca('0xb')],{'host':_0x8eca('0xc'),'port':0x18eb});var socket=require(_0x8eca('0xd'))(new Redis(config[_0x8eca('0xb')]));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()[_0x8eca('0xe')]('YYYY-MM-DD\x20HH:mm:ss');var tempTableName=_0x8eca('0xf')+moment()[_0x8eca('0xe')](_0x8eca('0x10'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];function isEmail(_0x10184f){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))*$/[_0x8eca('0x11')](_0x10184f);}function selectNotIn(_0x24b0ca,_0x40e285,_0x2653b7,_0x220093,_0x38301b){return squel['select']()[_0x8eca('0x12')]('phone')[_0x8eca('0x13')](_0x220093)[_0x8eca('0x14')](_0x40e285,null,_0x40e285+'.id\x20=\x20'+_0x220093+'.'+_0x2653b7)[_0x8eca('0x15')](_0x220093+'.'+_0x2653b7+'\x20=\x20'+_0x24b0ca+'.'+_0x2653b7)['where'](_0x40e285+'.dialCheckDuplicateType\x20IN\x20('+_0x38301b[_0x8eca('0x14')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x36b8f1,_0x2b901f){promisesAdditionalPhones=[];promisesContact=[];return db[_0x8eca('0x16')][_0x8eca('0x17')](_0x8eca('0x18')+tempTableName)[_0x8eca('0x19')](function(_0x4e390c){if(_0x4e390c!==null){var _0x15be36=[];for(var _0x1f7012=0x0;_0x1f7012<_0x4e390c['length'];_0x1f7012++){var _0x41ca2d=_0x4e390c[_0x1f7012];if(!_[_0x8eca('0x1a')](_0x41ca2d['phone'])){if(!_['isNil'](_0x41ca2d[_0x8eca('0x1b')]))_0x15be36['push'](insertAdditionalPhones(_0x41ca2d));promisesContact[_0x8eca('0x1c')]({'contact':_0x41ca2d});}}}Promise[_0x8eca('0x1d')](_0x15be36)[_0x8eca('0x1e')](function(){_0x36b8f1({'val':0x1});});})[_0x8eca('0x1f')](function(_0x5180c8){logger[_0x8eca('0x20')](_0x5180c8['message']);});});}function insertAdditionalPhones(_0x449434){return new Promise(function(_0x536d40,_0x373117){var _0x14af03=_0x449434[_0x8eca('0x1b')];if(_[_0x8eca('0x1a')](_0x14af03))_0x373117({'val':0x0});else{var _0x1cf97a=_0x14af03[_0x8eca('0x21')](';');var _0x4cecf6=[];orderBy=0x0;for(var _0xacfa9c=0x0;_0xacfa9c<_0x1cf97a['length'];_0xacfa9c++){_0x4cecf6['push'](splitAdditionalPhone(_0x449434['id'],_0x1cf97a[_0xacfa9c]));}Promise[_0x8eca('0x1d')](_0x4cecf6)[_0x8eca('0x1e')](function(){_0x536d40({'val':_0x1cf97a[_0x8eca('0x22')]});});}});}function splitAdditionalPhone(_0x14d9c9,_0x271179){return new Promise(function(_0x5ac424,_0x472c54){var _0x5484aa=_0x271179[_0x8eca('0x21')](':');var _0x15823b=_0x5484aa[0x0];var _0x18ae97=_0x5484aa[0x1];if(_0x18ae97!==''){var _0x3e1f66=_0x18ae97[_0x8eca('0x21')]('|');var _0xb3ffd7=[];for(var _0x33e4db=0x0;_0x33e4db<_0x3e1f66[_0x8eca('0x22')];_0x33e4db++){if(_0x3e1f66[_0x33e4db]!==''){var _0x4e524f=_[_0x8eca('0x23')](promisesAdditionalPhones,{'contactId':_0x14d9c9,'phone':_0x3e1f66[_0x33e4db]});if(_0x4e524f[_0x8eca('0x22')]==0x0){orderBy++;promisesAdditionalPhones[_0x8eca('0x1c')]({'contactId':_0x14d9c9,'contactTypeId':_0x15823b,'phone':_0x3e1f66[_0x33e4db],'orderBy':orderBy});}}}_0x5ac424({'ok':0x1});}else _0x5ac424({'res':0x0});});}function createAdditionalPhone(_0x205b0d,_0x1b3e41,_0x8b406b,_0x39e04f){var _0x189ecf='';var _0x36b286='';var _0x497122=_0x8b406b[_0x8eca('0x21')]('§');_0x189ecf=_0x497122[0x0];if(_0x497122[_0x8eca('0x22')]==0x2)_0x36b286=_0x497122[0x1];return new Promise(function(_0x372f13,_0x1f6ed5){return db['CmContactHasItem'][_0x8eca('0x24')]({'where':{'CmContactId':_0x205b0d,'item':_0x189ecf}})[_0x8eca('0x1e')](function(_0x3701f6){if(_0x3701f6){return db[_0x8eca('0x25')][_0x8eca('0x26')]({'ItemTypeId':_0x1b3e41,'description':_0x36b286,'OrderBy':_0x39e04f},{'where':{'CmContactId':_0x205b0d,'item':_0x189ecf}})[_0x8eca('0x1e')](function(_0x20e7ba){_0x372f13({'res':_0x8eca('0x27')});});}else{return db[_0x8eca('0x25')]['create']({'CmContactId':_0x205b0d,'item':_0x189ecf,'ItemTypeId':_0x1b3e41,'description':_0x36b286,'OrderBy':_0x39e04f,'ItemClass':'PHONE'})[_0x8eca('0x1e')](function(_0x8abf4d){_0x372f13({'res':_0x8eca('0x28')});});}});});}function updateContact(_0xe283b1){return new Promise(function(_0x3a1175,_0x194eed){var _0x220e33=_0xe283b1['id'];delete _0xe283b1['id'];return db[_0x8eca('0x29')][_0x8eca('0x26')](_0xe283b1,{'where':{'id':_0x220e33}})[_0x8eca('0x1e')](function(_0x49cee8){updatedRows+=0x1;return db['CmHopper']['update']({'phone':_0xe283b1[_0x8eca('0x2a')]},{'where':{'ContactId':_0x220e33}})[_0x8eca('0x1e')](function(_0xfaaf1f){_0x3a1175({'ret':'OK'});});});});}function insertCmHopper(_0x1d680c,_0x2fe644,_0x35b2bc,_0x2f6df4,_0xa0a7f5){var _0x35b57e=[_0x8eca('0x2b'),_0x8eca('0x2c'),_0x8eca('0x2d'),_0x8eca('0x2e'),_0x2fe644+'.'+_0x2f6df4,_0x8eca('0x2f'),'cm_contacts.updatedAt',_0x8eca('0x30'),'cm_contacts.UserId','\x22'+_0xa0a7f5+'\x22'];return squel[_0x8eca('0x31')]()[_0x8eca('0x32')]('cm_hopper')[_0x8eca('0x33')](['phone',_0x8eca('0x34'),_0x8eca('0x35'),_0x8eca('0x36'),_0x2f6df4,_0x8eca('0x37'),_0x8eca('0x38'),_0x8eca('0x39'),_0x8eca('0x3a'),_0x8eca('0x3b')],squel[_0x8eca('0x3c')]()[_0x8eca('0x3d')](_0x35b57e)[_0x8eca('0x13')](_0x2fe644)[_0x8eca('0x14')](_0x8eca('0x3e'),null,'cm_contacts.ListId\x20=\x20'+_0x2fe644+_0x8eca('0x3f'))[_0x8eca('0x14')](_0x35b2bc,null,_0x35b2bc+_0x8eca('0x40')+_0x2fe644+'.'+_0x2f6df4)['where'](_0x2fe644+_0x8eca('0x41'),_0x1d680c)['where'](_0x8eca('0x42'),NOW)['where']('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x2fe644,_0x35b2bc,_0x2f6df4,'cm_hopper',[_0x8eca('0x43'),'\x22onlyIfOpen\x22']))[_0x8eca('0x15')](_0x8eca('0x44'),selectNotIn(_0x2fe644,_0x35b2bc,_0x2f6df4,'cm_hopper',[_0x8eca('0x43')])))['toString']();}function insertCmHopperBlack(_0x489666,_0x4bdcc5,_0x569b60,_0x29f030){var _0x5135e8=[_0x8eca('0x2b'),_0x8eca('0x2d'),'cm_contacts.ListId',_0x4bdcc5+'.'+_0x29f030,_0x8eca('0x2f'),_0x8eca('0x45')];return squel[_0x8eca('0x31')]()[_0x8eca('0x32')]('cm_hopper_black')[_0x8eca('0x33')]([_0x8eca('0x2a'),_0x8eca('0x35'),'ListId',_0x29f030,_0x8eca('0x37'),_0x8eca('0x38')],squel[_0x8eca('0x3c')]()[_0x8eca('0x3d')](_0x5135e8)[_0x8eca('0x13')](_0x4bdcc5)['join'](_0x8eca('0x3e'),null,_0x8eca('0x46')+_0x4bdcc5+_0x8eca('0x3f'))[_0x8eca('0x14')](_0x569b60,null,_0x569b60+'.id\x20=\x20'+_0x4bdcc5+'.'+_0x29f030)['where'](_0x4bdcc5+'.CmListId\x20=\x20?',_0x489666)[_0x8eca('0x15')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0x8eca('0x15')](_0x8eca('0x44'),squel['select']()[_0x8eca('0x12')](_0x8eca('0x2a'))['from'](_0x8eca('0x47'))['where'](_0x8eca('0x48'),_0x489666)[_0x8eca('0x15')](_0x29f030+_0x8eca('0x49'),_0x4bdcc5+'.'+_0x29f030)))[_0x8eca('0x4a')]();}function insertCmHopperAdditionalPhones(_0x5dd642){var _0x5cea41=['cm_hopper.id',_0x8eca('0x4b'),'cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt',_0x8eca('0x4c')];return squel[_0x8eca('0x31')]()[_0x8eca('0x32')](_0x8eca('0x4d'))[_0x8eca('0x33')]([_0x8eca('0x4e'),'phone',_0x8eca('0x4f'),_0x8eca('0x37'),'updatedAt'],squel[_0x8eca('0x3c')]()[_0x8eca('0x3d')](_0x5cea41)['from'](_0x8eca('0x50'))[_0x8eca('0x14')](_0x8eca('0x3e'),null,_0x8eca('0x51'))['join']('cm_contact_has_items',null,_0x8eca('0x52'))['where'](_0x8eca('0x53'),_0x5dd642)[_0x8eca('0x15')](_0x8eca('0x42'),NOW))[_0x8eca('0x4a')]();}function insertCmContact(_0x1af9fb,_0x45da41,_0x3f5a85,_0x5eed95){var _0xfdd3ab=_[_0x8eca('0x54')](_[_0x8eca('0x55')](_0x5eed95),[_0x8eca('0x36'),'CompanyId',_0x8eca('0x37'),_0x8eca('0x38')]);return squel[_0x8eca('0x31')]()['into'](_0x8eca('0x3e'))['fromQuery'](_0xfdd3ab,squel[_0x8eca('0x3c')]()[_0x8eca('0x3d')](_0xfdd3ab)[_0x8eca('0x13')](_0x45da41)[_0x8eca('0x15')]('('+_0x3f5a85[_0x8eca('0x14')](',')+_0x8eca('0x56'),squel[_0x8eca('0x3c')]()[_0x8eca('0x3d')](_0x3f5a85)[_0x8eca('0x13')](_0x8eca('0x3e'))[_0x8eca('0x15')](_0x8eca('0x48'),_0x1af9fb))['where'](_0x8eca('0x57'),squel[_0x8eca('0x3c')]()['field'](_0x8eca('0x58'),'min_id')[_0x8eca('0x13')](_0x45da41)[_0x8eca('0x59')](_0x3f5a85[_0x8eca('0x14')](','))))['toString']();}function handleStop(){logger[_0x8eca('0x5a')]('Received\x20SIGINT');stopped=!![];}function handleUncaughtException(_0x9ef9e9){logger[_0x8eca('0x20')](_0x9ef9e9[_0x8eca('0x5b')]);process[_0x8eca('0x5c')](0x1);}function handleError(_0x61d452,_0x480713){stats['errors'][_0x8eca('0x1c')]({'name':_0x480713[_0x8eca('0x5d')],'message':_0x480713[_0x8eca('0x5b')],'row':_0x61d452});}function handleQuery(_0x380eac){logger[_0x8eca('0x5a')](_0x380eac);return db['sequelize'][_0x8eca('0x17')](_0x380eac)[_0x8eca('0x19')](function(_0x4366a0){results[_0x8eca('0x1c')](_0x4366a0);})[_0x8eca('0x1f')](function(_0x3f5274){logger[_0x8eca('0x20')](_0x3f5274['message']);});}function main(_0xb86773,_0x35e24e,_0x54ef41,_0x163541){logger['info']('main',_0xb86773,JSON[_0x8eca('0x5e')](_0x35e24e));process['send'](_0x8eca('0x5f'));var _0x20ab07=_0x35e24e['binding'];var _0x1178a2=_[_0x8eca('0x60')](_0x20ab07);var _0xcd593a=_0x35e24e[_0x8eca('0x61')];var _0x8e61a5=path[_0x8eca('0x14')](config[_0x8eca('0x62')],_0x8eca('0x63'),_0xcd593a+_0x8eca('0x64'));logger[_0x8eca('0x5a')]('body',_0x35e24e);db[_0x8eca('0x65')][_0x8eca('0x66')]({'raw':!![],'attributes':['id',_0x8eca('0x67')]})[_0x8eca('0x1e')](function(_0x4921e2){for(var _0x57d28d=0x0;_0x57d28d<_0x4921e2['length'];_0x57d28d++){if(_0x4921e2[_0x57d28d][_0x8eca('0x67')]in _0x20ab07){contactItemTypes[_0x8eca('0x1c')](_0x4921e2[_0x57d28d]);delete _0x1178a2[_0x4921e2[_0x57d28d][_0x8eca('0x67')]];hasAdditionalPhones=!![];}for(var _0x528df7 in _0x20ab07){if(_0x4921e2[_0x57d28d][_0x8eca('0x67')]+_0x8eca('0x68')===_0x528df7){phoneDescriptions[_0x8eca('0x1c')]({'itemTypeId':_0x4921e2[_0x57d28d]['id'],'description':_0x528df7});delete _0x1178a2[_0x528df7];}}}if(hasAdditionalPhones)_0x1178a2['AdditionalPhones']='';var _0x3a0025=_['keys'](_0x1178a2)[_0x8eca('0x14')]();logger[_0x8eca('0x5a')](_0x8eca('0x69'),_0x3a0025);fs[_0x8eca('0x6a')](_0x8e61a5,_0x3a0025+'\x0a');Papa[_0x8eca('0x6b')](fs[_0x8eca('0x6c')](_0xb86773),{'header':!![],'skipEmptyLines':!![],'step':function(_0x2c0631,_0x11cfb6){try{for(var _0x3d9df4=0x0,_0x5b71bc=[];_0x3d9df4<_0x2c0631['data'][_0x8eca('0x22')];_0x3d9df4++){stats['rows']+=0x1;if(_0x2c0631[_0x8eca('0x6d')][_0x3d9df4]){handleError(_0x2c0631[_0x8eca('0x6e')][_0x3d9df4],_0x2c0631[_0x8eca('0x6d')][_0x3d9df4]);}else{var _0x2e7991=[];var _0x166f21=[];var _0x1f9ecb={};for(var _0x28f71a in _0x20ab07){let _0x191d34=contactItemTypes[_0x8eca('0x6f')](_0x395497=>_0x395497[_0x8eca('0x67')]===_0x28f71a);let _0x52fa88=contactItemTypes[_0x8eca('0x6f')](_0x3cae49=>_0x3cae49[_0x8eca('0x67')]+'_description'===_0x28f71a);if(_[_0x8eca('0x1a')](_0x191d34)&&_[_0x8eca('0x1a')](_0x52fa88)){if(_0x20ab07['hasOwnProperty'](_0x28f71a)){if(_0x2c0631['data'][_0x3d9df4][_0x20ab07[_0x28f71a]]){var _0x3e725e=_[_0x8eca('0x70')](_0x2c0631['data'][_0x3d9df4][_0x20ab07[_0x28f71a]][_0x8eca('0x71')](/"/g,'\x27'));switch(_0x28f71a){case _0x8eca('0x34'):var _0x5d1841=moment(_0x3e725e,'YYYY-MM-DD\x20HH:mm:ss',!![]);if(_0x5d1841['isValid']()){_0x5b71bc[_0x8eca('0x1c')]('\x22'+_0x3e725e+'\x22');}else{_0x2e7991[_0x8eca('0x1c')](_0x8eca('0x72'));}break;case _0x8eca('0x39'):var _0x184cdc=parseInt(_0x3e725e);_0x3e725e=_[_0x8eca('0x73')](_0x184cdc)||_0x184cdc<0x0||_0x184cdc>0x4?_0x163541?0x3:0x2:_0x184cdc;_0x5b71bc[_0x8eca('0x1c')]('\x22'+_0x3e725e+'\x22');break;case _0x8eca('0x3a'):var _0xd74de7=parseInt(_0x3e725e);if(_['isNumber'](_0xd74de7)&&_[_0x8eca('0x74')](_0x54ef41,_0xd74de7)){_0x5b71bc['push']('\x22'+_0xd74de7+'\x22');}else{_0x2e7991['push'](_0x8eca('0x75'));}break;case _0x8eca('0x76'):if(isEmail(_0x3e725e)){_0x5b71bc[_0x8eca('0x1c')]('\x22'+_0x3e725e+'\x22');}else{_0x2e7991[_0x8eca('0x1c')](_0x8eca('0x77'));}break;case _0x8eca('0x78'):var _0x13c7ec=moment(_0x3e725e,_0x8eca('0x79'),!![]);if(_0x13c7ec['isValid']()){_0x5b71bc[_0x8eca('0x1c')]('\x22'+_0x3e725e+'\x22');}else{_0x2e7991['push'](_0x8eca('0x7a'));}break;default:_0x5b71bc[_0x8eca('0x1c')]('\x22'+_0x3e725e+'\x22');}}else{switch(_0x28f71a){case _0x8eca('0x7b'):case _0x8eca('0x2a'):_0x2e7991[_0x8eca('0x1c')](_0x28f71a+_0x8eca('0x7c'));break;default:_0x5b71bc['push']('\x22\x22');}}}}else{var _0x273dfc='';if(!_[_0x8eca('0x1a')](_0x191d34)){if(!_0x1f9ecb['hasOwnProperty'](_0x191d34['id'])){for(var _0x33da06=0x0;_0x33da06<_0x20ab07[_0x28f71a][_0x8eca('0x22')];_0x33da06++){var _0x3e725e=_[_0x8eca('0x70')](_0x2c0631['data'][_0x3d9df4][_0x20ab07[_0x28f71a][_0x33da06]][_0x8eca('0x71')](/"/g,'\x27'));var _0x1ffa2e=phoneDescriptions[_0x8eca('0x6f')](_0x13a4d4=>_0x13a4d4[_0x8eca('0x7d')]===_0x191d34['id']);if(!_[_0x8eca('0x1a')](_0x1ffa2e)){var _0xa22072=_[_0x8eca('0x70')](_0x2c0631[_0x8eca('0x6e')][_0x3d9df4][_0x20ab07[_0x1ffa2e[_0x8eca('0x7e')]][0x0]][_0x8eca('0x71')](/"/g,'\x27'));if(!_['isNil'](_0xa22072))_0x3e725e=_0x3e725e+'§'+_0xa22072;}if(_0x273dfc=='')_0x273dfc=_0x3e725e;else _0x273dfc+='|'+_0x3e725e;}_0x166f21[_0x8eca('0x1c')](_0x191d34['id']+':'+_0x273dfc);_0x1f9ecb[_0x191d34['id']]=0x1;}}}}if(hasAdditionalPhones){_0x5b71bc['push']('\x22'+_0x166f21[_0x8eca('0x14')](';')+'\x22');}if(_0x2e7991[_0x8eca('0x22')]){handleError(_0x2c0631[_0x8eca('0x6e')][_0x3d9df4],{'code':_0x8eca('0x7f'),'message':_0x2e7991[_0x8eca('0x14')]()});}else{fs[_0x8eca('0x80')](_0x8e61a5,_0x5b71bc[_0x8eca('0x14')]()+'\x0a');}_0x5b71bc=[];}if(!(stats[_0x8eca('0x81')]%0xc8)){socket[_0x8eca('0x82')]('contact:import:'+_0xcd593a,stats);stats[_0x8eca('0x6d')]=[];}}if(stopped){logger[_0x8eca('0x5a')](_0x8eca('0x83'));_0x11cfb6[_0x8eca('0x84')]();}}catch(_0x1c1ab5){handleError(_0x2c0631[_0x8eca('0x6e')][_0x3d9df4],{'code':'SystemError','message':_0x1c1ab5['message']});logger[_0x8eca('0x20')]('step',_0x1c1ab5[_0x8eca('0x5b')]);}},'complete':function(){try{var _0x501642=[];var _0x3a4c9e=tempTableName;_0x501642['push'](_0x8eca('0x85')+_0x3a4c9e+_0x8eca('0x86'));logger['info'](_0x8eca('0x87'),contactItemTypes[_0x8eca('0x22')]);var _0x2d1898=util[_0x8eca('0xe')](_0x8eca('0x88'),_0x8e61a5,_0x3a4c9e,_0x3a0025,_0x35e24e['ListId'],_0x35e24e['CompanyId']||null,NOW,NOW);if(_[_0x8eca('0x1a')](_0x20ab07['scheduledat'])){_0x2d1898+=_0x8eca('0x89');}_0x501642[_0x8eca('0x1c')](_0x2d1898);BPromise[_0x8eca('0x8a')](_0x501642,handleQuery)[_0x8eca('0x1e')](function(_0x109f1e){BPromise['all']([handleAdditionalPhones()])[_0x8eca('0x1e')](function(){_0x501642=[];for(var _0x26099d=0x0;_0x26099d<promisesContact[_0x8eca('0x22')];_0x26099d++){_0x501642['push'](updateContact(promisesContact[_0x26099d]['contact']));}BPromise[_0x8eca('0x1d')](_0x501642)[_0x8eca('0x1e')](function(){_0x501642=[];for(var _0x5497ad=0x0;_0x5497ad<promisesAdditionalPhones[_0x8eca('0x22')];_0x5497ad++){_0x501642[_0x8eca('0x1c')](createAdditionalPhone(promisesAdditionalPhones[_0x5497ad][_0x8eca('0x8b')],promisesAdditionalPhones[_0x5497ad][_0x8eca('0x8c')],promisesAdditionalPhones[_0x5497ad][_0x8eca('0x2a')],promisesAdditionalPhones[_0x5497ad][_0x8eca('0x8d')]));}BPromise[_0x8eca('0x1d')](_0x501642)[_0x8eca('0x1e')](function(){_0x501642=[];_0x501642[_0x8eca('0x1c')](insertCmHopperAdditionalPhones(_0x35e24e['ListId']));_0x501642[_0x8eca('0x1c')](_0x8eca('0x8e')+_0x3a4c9e+';');BPromise[_0x8eca('0x8a')](_0x501642,handleQuery)[_0x8eca('0x1e')](function(_0x5e33ac){stats[_0x8eca('0x8f')]=!![];stats['affectedRows']=updatedRows;socket[_0x8eca('0x82')](_0x8eca('0x90')+_0xcd593a,stats);fs[_0x8eca('0x91')](_0xb86773);fs[_0x8eca('0x91')](_0x8e61a5);process[_0x8eca('0x5c')](0x0);})[_0x8eca('0x1f')](function(_0x2899ea){logger['error'](_0x2899ea[_0x8eca('0x5b')]);process[_0x8eca('0x5c')](0x1);});});});});})[_0x8eca('0x1f')](function(_0x22b8fc){logger['error'](_0x22b8fc[_0x8eca('0x5b')]);process['exit'](0x1);});}catch(_0x56f69e){logger[_0x8eca('0x20')](_0x8eca('0x92'),_0x56f69e[_0x8eca('0x5b')]);process['exit'](0x1);}},'error':function(_0x918fae,_0x1a64e3,_0x2f261f,_0x546089){throw new Error(_0x546089);}});});}function validate(){if(process[_0x8eca('0x93')]&&process['argv'][_0x8eca('0x22')]<0x4){throw new Error(_0x8eca('0x94'));}var _0x21df43=path['join'](config[_0x8eca('0x62')],_0x8eca('0x63'),process['argv'][0x2]);if(!fs[_0x8eca('0x95')](_0x21df43)){throw new Error(_0x8eca('0x96'));}var _0x5e362d={};try{_0x5e362d=JSON['parse'](process['argv'][0x3]);if(!_0x5e362d[_0x8eca('0x97')]){throw new Error(_0x8eca('0x98'));}var _0x34630e=0x0;if(_0x5e362d[_0x8eca('0x97')]['UserId']){_0x34630e=0x1;}if(!_0x5e362d[_0x8eca('0x36')]){throw new Error(_0x8eca('0x99'));}}catch(_0xc56af0){throw new Error(_0x8eca('0x9a'));}var _0x2433d2=[];try{_0x2433d2=_[_0x8eca('0x9b')](JSON[_0x8eca('0x6b')](process['argv'][0x4]),'id');}catch(_0x5c018e){logger['info'](_0x8eca('0x9c'));}main(_0x21df43,_0x5e362d,_0x2433d2,_0x34630e);}validate();process['on'](_0x8eca('0x9d'),handleStop);process['on']('uncaughtException',handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff