// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xbdfb=['isNaN','isNumber','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','replace','SystemRow','appendFileSync','emit','contact:import:','Abort\x20parser','abort','SystemError','step','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;',',\x20scheduledAt\x20=\x20NOW()','contact','contactTypeId','orderBy','DROP\x20TABLE\x20','each','finish','unlink','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','root','server/files/tmp','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','map','uncaughtException','path','lodash','papaparse','util','bluebird','moment','squel','ioredis','../../../mysqldb','../../../config/environment','import','redis','localhost','format','YYYY-MM-DD\x20HH:mm:ss','cm_contacts_temp_','YYYYMMDDHHmmss','select','field','phone','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','sequelize','query','select\x20*\x20from\x20','isNil','AdditionalPhones','push','then','catch','error','message','all','split','filter','length','CmContactHasItem','update','updated','create','PHONE','inserted','CmHopper','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','insert','cm_hopper','fromQuery','scheduledat','createdAt','updatedAt','priority','UserId','recallme','fields','from','join','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','.id\x20=\x20','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22always\x22','toString','cm_contacts.phone','cm_contacts.createdAt','cm_hopper_black','ContactId','ListId','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','into','cm_hopper_additional_phones','CmHopperId','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId','id\x20IN\x20?','MIN(id)','group','info','Received\x20SIGINT','exit','code','spread','stringify','send','start','binding','clone','socket_timestamp','body','findAll','name','_description','header','parse','rows','errors','data','find','trim','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)'];(function(_0x2b7aca,_0x1e1ae9){var _0x5c1eb8=function(_0x255a0c){while(--_0x255a0c){_0x2b7aca['push'](_0x2b7aca['shift']());}};_0x5c1eb8(++_0x1e1ae9);}(_0xbdfb,0x1ef));var _0xbbdf=function(_0x2023e1,_0xeca985){_0x2023e1=_0x2023e1-0x0;var _0x1fe133=_0xbdfb[_0x2023e1];return _0x1fe133;};'use strict';var fs=require('fs');var path=require(_0xbbdf('0x0'));var _=require(_0xbbdf('0x1'));var Papa=require(_0xbbdf('0x2'));var util=require(_0xbbdf('0x3'));var BPromise=require(_0xbbdf('0x4'));var moment=require(_0xbbdf('0x5'));var squel=require(_0xbbdf('0x6'));var Redis=require(_0xbbdf('0x7'));var db=require(_0xbbdf('0x8'))['db'];var config=require(_0xbbdf('0x9'));var logger=require('../../../config/logger')(_0xbbdf('0xa'));config[_0xbbdf('0xb')]=_['defaults'](config[_0xbbdf('0xb')],{'host':_0xbbdf('0xc'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xbbdf('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()[_0xbbdf('0xd')](_0xbbdf('0xe'));var tempTableName=_0xbbdf('0xf')+moment()['format'](_0xbbdf('0x10'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];function isEmail(_0x1fcd80){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'](_0x1fcd80);}function selectNotIn(_0x29cbcc,_0x607f2c,_0xcae62e,_0x2b7be5,_0x55da96){return squel[_0xbbdf('0x11')]()[_0xbbdf('0x12')](_0xbbdf('0x13'))['from'](_0x2b7be5)['join'](_0x607f2c,null,_0x607f2c+'.id\x20=\x20'+_0x2b7be5+'.'+_0xcae62e)['where'](_0x2b7be5+'.'+_0xcae62e+_0xbbdf('0x14')+_0x29cbcc+'.'+_0xcae62e)[_0xbbdf('0x15')](_0x607f2c+_0xbbdf('0x16')+_0x55da96['join']()+')');}function handleAdditionalPhones(){return new Promise(function(_0x215cba,_0x2022ba){promisesAdditionalPhones=[];promisesContact=[];return db[_0xbbdf('0x17')][_0xbbdf('0x18')](_0xbbdf('0x19')+tempTableName)['spread'](function(_0x41a6e2){if(_0x41a6e2!==null){var _0x46968e=[];for(var _0x1f1a7f=0x0;_0x1f1a7f<_0x41a6e2['length'];_0x1f1a7f++){var _0x56d015=_0x41a6e2[_0x1f1a7f];if(!_[_0xbbdf('0x1a')](_0x56d015[_0xbbdf('0x13')])){if(!_[_0xbbdf('0x1a')](_0x56d015[_0xbbdf('0x1b')]))_0x46968e[_0xbbdf('0x1c')](insertAdditionalPhones(_0x56d015));promisesContact['push']({'contact':_0x56d015});}}}Promise['all'](_0x46968e)[_0xbbdf('0x1d')](function(){_0x215cba({'val':0x1});});})[_0xbbdf('0x1e')](function(_0x3c1629){logger[_0xbbdf('0x1f')](_0x3c1629[_0xbbdf('0x20')]);});});}function insertAdditionalPhones(_0x2c668b){return new Promise(function(_0x36bc9b,_0x3e0929){var _0x2c7862=_0x2c668b[_0xbbdf('0x1b')];if(_[_0xbbdf('0x1a')](_0x2c7862))_0x3e0929({'val':0x0});else{var _0x31ed33=_0x2c7862['split'](';');var _0x585199=[];orderBy=0x0;for(var _0xb39b4b=0x0;_0xb39b4b<_0x31ed33['length'];_0xb39b4b++){_0x585199[_0xbbdf('0x1c')](splitAdditionalPhone(_0x2c668b['id'],_0x31ed33[_0xb39b4b]));}Promise[_0xbbdf('0x21')](_0x585199)[_0xbbdf('0x1d')](function(){_0x36bc9b({'val':_0x31ed33['length']});});}});}function splitAdditionalPhone(_0x440f2a,_0x1c9036){return new Promise(function(_0xbe39d4,_0x3a52ff){var _0x496522=_0x1c9036[_0xbbdf('0x22')](':');var _0x391c42=_0x496522[0x0];var _0x9d9067=_0x496522[0x1];if(_0x9d9067!==''){var _0x5c8824=_0x9d9067['split']('|');var _0x27709e=[];for(var _0x49b3f1=0x0;_0x49b3f1<_0x5c8824['length'];_0x49b3f1++){if(_0x5c8824[_0x49b3f1]!==''){var _0x3ff60d=_[_0xbbdf('0x23')](promisesAdditionalPhones,{'contactId':_0x440f2a,'phone':_0x5c8824[_0x49b3f1]});if(_0x3ff60d[_0xbbdf('0x24')]==0x0){orderBy++;promisesAdditionalPhones[_0xbbdf('0x1c')]({'contactId':_0x440f2a,'contactTypeId':_0x391c42,'phone':_0x5c8824[_0x49b3f1],'orderBy':orderBy});}}}_0xbe39d4({'ok':0x1});}else _0xbe39d4({'res':0x0});});}function createAdditionalPhone(_0x28c283,_0x436f58,_0x2b20bb,_0x57af55){var _0x2f5471='';var _0x392265='';var _0x392a04=_0x2b20bb[_0xbbdf('0x22')]('§');_0x2f5471=_0x392a04[0x0];if(_0x392a04[_0xbbdf('0x24')]==0x2)_0x392265=_0x392a04[0x1];return new Promise(function(_0x137999,_0x3f853f){return db['CmContactHasItem']['findOne']({'where':{'CmContactId':_0x28c283,'item':_0x2f5471}})[_0xbbdf('0x1d')](function(_0x568c87){if(_0x568c87){return db[_0xbbdf('0x25')][_0xbbdf('0x26')]({'ItemTypeId':_0x436f58,'description':_0x392265,'OrderBy':_0x57af55},{'where':{'CmContactId':_0x28c283,'item':_0x2f5471}})[_0xbbdf('0x1d')](function(_0x331999){_0x137999({'res':_0xbbdf('0x27')});});}else{return db[_0xbbdf('0x25')][_0xbbdf('0x28')]({'CmContactId':_0x28c283,'item':_0x2f5471,'ItemTypeId':_0x436f58,'description':_0x392265,'OrderBy':_0x57af55,'ItemClass':_0xbbdf('0x29')})[_0xbbdf('0x1d')](function(_0x438ed9){_0x137999({'res':_0xbbdf('0x2a')});});}});});}function updateContact(_0x5dc411){return new Promise(function(_0xe3a21d,_0x2fa9ee){var _0x2975fc=_0x5dc411['id'];delete _0x5dc411['id'];return db['CmContact'][_0xbbdf('0x26')](_0x5dc411,{'where':{'id':_0x2975fc}})[_0xbbdf('0x1d')](function(_0x3c697b){updatedRows+=0x1;return db[_0xbbdf('0x2b')][_0xbbdf('0x26')]({'phone':_0x5dc411[_0xbbdf('0x13')]},{'where':{'ContactId':_0x2975fc}})[_0xbbdf('0x1d')](function(_0x557bda){_0xe3a21d({'ret':'OK'});});});});}function insertCmHopper(_0x2df293,_0xb0d471,_0x2e40d2,_0x387b86,_0x46a6e1){var _0x27530f=['cm_contacts.phone',_0xbbdf('0x2c'),_0xbbdf('0x2d'),'cm_contacts.ListId',_0xb0d471+'.'+_0x387b86,'cm_contacts.createdAt',_0xbbdf('0x2e'),_0xbbdf('0x2f'),_0xbbdf('0x30'),'\x22'+_0x46a6e1+'\x22'];return squel[_0xbbdf('0x31')]()['into'](_0xbbdf('0x32'))[_0xbbdf('0x33')]([_0xbbdf('0x13'),_0xbbdf('0x34'),'ContactId','ListId',_0x387b86,_0xbbdf('0x35'),_0xbbdf('0x36'),_0xbbdf('0x37'),_0xbbdf('0x38'),_0xbbdf('0x39')],squel['select']()[_0xbbdf('0x3a')](_0x27530f)[_0xbbdf('0x3b')](_0xb0d471)[_0xbbdf('0x3c')](_0xbbdf('0x3d'),null,_0xbbdf('0x3e')+_0xb0d471+_0xbbdf('0x3f'))[_0xbbdf('0x3c')](_0x2e40d2,null,_0x2e40d2+_0xbbdf('0x40')+_0xb0d471+'.'+_0x387b86)[_0xbbdf('0x15')](_0xb0d471+_0xbbdf('0x41'),_0x2df293)[_0xbbdf('0x15')](_0xbbdf('0x42'),NOW)[_0xbbdf('0x15')](_0xbbdf('0x43'),selectNotIn(_0xb0d471,_0x2e40d2,_0x387b86,'cm_hopper',[_0xbbdf('0x44'),'\x22onlyIfOpen\x22']))[_0xbbdf('0x15')](_0xbbdf('0x43'),selectNotIn(_0xb0d471,_0x2e40d2,_0x387b86,_0xbbdf('0x32'),[_0xbbdf('0x44')])))[_0xbbdf('0x45')]();}function insertCmHopperBlack(_0x50f266,_0x18a8ec,_0x1b7b3d,_0x4595dd){var _0x2e6b5d=[_0xbbdf('0x46'),_0xbbdf('0x2d'),'cm_contacts.ListId',_0x18a8ec+'.'+_0x4595dd,_0xbbdf('0x47'),'cm_contacts.updatedAt'];return squel[_0xbbdf('0x31')]()['into'](_0xbbdf('0x48'))['fromQuery']([_0xbbdf('0x13'),_0xbbdf('0x49'),_0xbbdf('0x4a'),_0x4595dd,_0xbbdf('0x35'),_0xbbdf('0x36')],squel['select']()[_0xbbdf('0x3a')](_0x2e6b5d)[_0xbbdf('0x3b')](_0x18a8ec)[_0xbbdf('0x3c')]('cm_contacts',null,_0xbbdf('0x3e')+_0x18a8ec+_0xbbdf('0x3f'))[_0xbbdf('0x3c')](_0x1b7b3d,null,_0x1b7b3d+_0xbbdf('0x40')+_0x18a8ec+'.'+_0x4595dd)[_0xbbdf('0x15')](_0x18a8ec+'.CmListId\x20=\x20?',_0x50f266)[_0xbbdf('0x15')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0xbbdf('0x15')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel['select']()[_0xbbdf('0x12')](_0xbbdf('0x13'))[_0xbbdf('0x3b')]('cm_hopper_black')['where'](_0xbbdf('0x4b'),_0x50f266)['where'](_0x4595dd+'\x20=\x20?',_0x18a8ec+'.'+_0x4595dd)))[_0xbbdf('0x45')]();}function insertCmHopperAdditionalPhones(_0x3fb08c){var _0x15f2bc=[_0xbbdf('0x4c'),_0xbbdf('0x4d'),_0xbbdf('0x4e'),_0xbbdf('0x4f'),_0xbbdf('0x50')];return squel['insert']()[_0xbbdf('0x51')](_0xbbdf('0x52'))[_0xbbdf('0x33')]([_0xbbdf('0x53'),_0xbbdf('0x13'),'OrderBy',_0xbbdf('0x35'),_0xbbdf('0x36')],squel['select']()[_0xbbdf('0x3a')](_0x15f2bc)[_0xbbdf('0x3b')]('cm_hopper')[_0xbbdf('0x3c')](_0xbbdf('0x3d'),null,_0xbbdf('0x54'))[_0xbbdf('0x3c')]('cm_contact_has_items',null,_0xbbdf('0x55'))['where'](_0xbbdf('0x56'),_0x3fb08c)[_0xbbdf('0x15')](_0xbbdf('0x42'),NOW))['toString']();}function insertCmContact(_0x4a8f88,_0x4e5d6,_0x30d854,_0x4d7a14){var _0x350c91=_[_0xbbdf('0x57')](_[_0xbbdf('0x58')](_0x4d7a14),[_0xbbdf('0x4a'),_0xbbdf('0x59'),_0xbbdf('0x35'),_0xbbdf('0x36')]);return squel['insert']()[_0xbbdf('0x51')](_0xbbdf('0x3d'))[_0xbbdf('0x33')](_0x350c91,squel[_0xbbdf('0x11')]()[_0xbbdf('0x3a')](_0x350c91)[_0xbbdf('0x3b')](_0x4e5d6)[_0xbbdf('0x15')]('('+_0x30d854[_0xbbdf('0x3c')](',')+')\x20NOT\x20IN\x20?',squel[_0xbbdf('0x11')]()[_0xbbdf('0x3a')](_0x30d854)['from'](_0xbbdf('0x3d'))['where']('ListId\x20=\x20?',_0x4a8f88))['where'](_0xbbdf('0x5a'),squel[_0xbbdf('0x11')]()['field'](_0xbbdf('0x5b'),'min_id')['from'](_0x4e5d6)[_0xbbdf('0x5c')](_0x30d854[_0xbbdf('0x3c')](','))))[_0xbbdf('0x45')]();}function handleStop(){logger[_0xbbdf('0x5d')](_0xbbdf('0x5e'));stopped=!![];}function handleUncaughtException(_0x21b88e){logger[_0xbbdf('0x1f')](_0x21b88e[_0xbbdf('0x20')]);process[_0xbbdf('0x5f')](0x1);}function handleError(_0xd65d8d,_0x4c7227){stats['errors']['push']({'name':_0x4c7227[_0xbbdf('0x60')],'message':_0x4c7227[_0xbbdf('0x20')],'row':_0xd65d8d});}function handleQuery(_0x3b7b1d){logger[_0xbbdf('0x5d')](_0x3b7b1d);return db[_0xbbdf('0x17')]['query'](_0x3b7b1d)[_0xbbdf('0x61')](function(_0x28a47d){results[_0xbbdf('0x1c')](_0x28a47d);})[_0xbbdf('0x1e')](function(_0x3f6913){logger[_0xbbdf('0x1f')](_0x3f6913['message']);});}function main(_0x3e098b,_0x46d04b,_0x19b8d8,_0x4f1b2c){logger[_0xbbdf('0x5d')]('main',_0x3e098b,JSON[_0xbbdf('0x62')](_0x46d04b));process[_0xbbdf('0x63')](_0xbbdf('0x64'));var _0x55d261=_0x46d04b[_0xbbdf('0x65')];var _0x21f59b=_[_0xbbdf('0x66')](_0x55d261);var _0xecf8a4=_0x46d04b[_0xbbdf('0x67')];var _0x363e44=path[_0xbbdf('0x3c')](config['root'],'server/files/tmp',_0xecf8a4+'.csv');logger[_0xbbdf('0x5d')](_0xbbdf('0x68'),_0x46d04b);db['ContactItemType'][_0xbbdf('0x69')]({'raw':!![],'attributes':['id','name']})[_0xbbdf('0x1d')](function(_0x37db76){for(var _0xafad51=0x0;_0xafad51<_0x37db76[_0xbbdf('0x24')];_0xafad51++){if(_0x37db76[_0xafad51][_0xbbdf('0x6a')]in _0x55d261){contactItemTypes['push'](_0x37db76[_0xafad51]);delete _0x21f59b[_0x37db76[_0xafad51][_0xbbdf('0x6a')]];hasAdditionalPhones=!![];}for(var _0x217558 in _0x55d261){if(_0x37db76[_0xafad51][_0xbbdf('0x6a')]+_0xbbdf('0x6b')===_0x217558){phoneDescriptions[_0xbbdf('0x1c')]({'itemTypeId':_0x37db76[_0xafad51]['id'],'description':_0x217558});delete _0x21f59b[_0x217558];}}}if(hasAdditionalPhones)_0x21f59b[_0xbbdf('0x1b')]='';var _0x26596f=_[_0xbbdf('0x58')](_0x21f59b)[_0xbbdf('0x3c')]();logger[_0xbbdf('0x5d')](_0xbbdf('0x6c'),_0x26596f);fs['writeFileSync'](_0x363e44,_0x26596f+'\x0a');Papa[_0xbbdf('0x6d')](fs['createReadStream'](_0x3e098b),{'header':!![],'skipEmptyLines':!![],'step':function(_0x380e04,_0x1d0334){try{for(var _0x3ffd47=0x0,_0x411426=[];_0x3ffd47<_0x380e04['data'][_0xbbdf('0x24')];_0x3ffd47++){stats[_0xbbdf('0x6e')]+=0x1;if(_0x380e04[_0xbbdf('0x6f')][_0x3ffd47]){handleError(_0x380e04[_0xbbdf('0x70')][_0x3ffd47],_0x380e04[_0xbbdf('0x6f')][_0x3ffd47]);}else{var _0x4ad43e=[];var _0x43f8ac=[];var _0x485e5b={};for(var _0x481275 in _0x55d261){let _0x3aa2f5=contactItemTypes[_0xbbdf('0x71')](_0x374071=>_0x374071[_0xbbdf('0x6a')]===_0x481275);let _0x1085e4=contactItemTypes[_0xbbdf('0x71')](_0x1b9f78=>_0x1b9f78[_0xbbdf('0x6a')]+_0xbbdf('0x6b')===_0x481275);if(_[_0xbbdf('0x1a')](_0x3aa2f5)&&_[_0xbbdf('0x1a')](_0x1085e4)){if(_0x55d261['hasOwnProperty'](_0x481275)){if(_0x380e04['data'][_0x3ffd47][_0x55d261[_0x481275]]){var _0x13f1c2=_[_0xbbdf('0x72')](_0x380e04[_0xbbdf('0x70')][_0x3ffd47][_0x55d261[_0x481275]]['replace'](/"/g,'\x27'));switch(_0x481275){case'scheduledat':var _0x3b0f92=moment(_0x13f1c2,_0xbbdf('0xe'),!![]);if(_0x3b0f92[_0xbbdf('0x73')]()){_0x411426[_0xbbdf('0x1c')]('\x22'+_0x13f1c2+'\x22');}else{_0x4ad43e['push'](_0xbbdf('0x74'));}break;case'priority':var _0x5bd877=parseInt(_0x13f1c2);_0x13f1c2=_[_0xbbdf('0x75')](_0x5bd877)||_0x5bd877<0x0||_0x5bd877>0x4?_0x4f1b2c?0x3:0x2:_0x5bd877;_0x411426[_0xbbdf('0x1c')]('\x22'+_0x13f1c2+'\x22');break;case'UserId':var _0x1ccaaf=parseInt(_0x13f1c2);if(_[_0xbbdf('0x76')](_0x1ccaaf)&&_['includes'](_0x19b8d8,_0x1ccaaf)){_0x411426['push']('\x22'+_0x1ccaaf+'\x22');}else{_0x4ad43e[_0xbbdf('0x1c')]('agent\x20not\x20exists');}break;case'email':if(isEmail(_0x13f1c2)){_0x411426[_0xbbdf('0x1c')]('\x22'+_0x13f1c2+'\x22');}else{_0x4ad43e['push']('email\x20wrong\x20format');}break;case _0xbbdf('0x77'):var _0x3faa43=moment(_0x13f1c2,_0xbbdf('0x78'),!![]);if(_0x3faa43[_0xbbdf('0x73')]()){_0x411426['push']('\x22'+_0x13f1c2+'\x22');}else{_0x4ad43e[_0xbbdf('0x1c')](_0xbbdf('0x79'));}break;default:_0x411426['push']('\x22'+_0x13f1c2+'\x22');}}else{switch(_0x481275){case _0xbbdf('0x7a'):case _0xbbdf('0x13'):_0x4ad43e[_0xbbdf('0x1c')](_0x481275+'\x20not\x20specified');break;default:_0x411426[_0xbbdf('0x1c')]('\x22\x22');}}}}else{var _0x275895='';if(!_[_0xbbdf('0x1a')](_0x3aa2f5)){if(!_0x485e5b['hasOwnProperty'](_0x3aa2f5['id'])){for(var _0x327a51=0x0;_0x327a51<_0x55d261[_0x481275]['length'];_0x327a51++){var _0x13f1c2=_[_0xbbdf('0x72')](_0x380e04['data'][_0x3ffd47][_0x55d261[_0x481275][_0x327a51]][_0xbbdf('0x7b')](/"/g,'\x27'));var _0x5c2a22=phoneDescriptions[_0xbbdf('0x71')](_0xd733ba=>_0xd733ba['itemTypeId']===_0x3aa2f5['id']);if(!_[_0xbbdf('0x1a')](_0x5c2a22)){var _0x54cfd8=_[_0xbbdf('0x72')](_0x380e04[_0xbbdf('0x70')][_0x3ffd47][_0x55d261[_0x5c2a22['description']][0x0]][_0xbbdf('0x7b')](/"/g,'\x27'));if(!_[_0xbbdf('0x1a')](_0x54cfd8))_0x13f1c2=_0x13f1c2+'§'+_0x54cfd8;}if(_0x275895=='')_0x275895=_0x13f1c2;else _0x275895+='|'+_0x13f1c2;}_0x43f8ac[_0xbbdf('0x1c')](_0x3aa2f5['id']+':'+_0x275895);_0x485e5b[_0x3aa2f5['id']]=0x1;}}}}if(hasAdditionalPhones){_0x411426[_0xbbdf('0x1c')]('\x22'+_0x43f8ac[_0xbbdf('0x3c')](';')+'\x22');}if(_0x4ad43e[_0xbbdf('0x24')]){handleError(_0x380e04['data'][_0x3ffd47],{'code':_0xbbdf('0x7c'),'message':_0x4ad43e['join']()});}else{fs[_0xbbdf('0x7d')](_0x363e44,_0x411426[_0xbbdf('0x3c')]()+'\x0a');}_0x411426=[];}if(!(stats[_0xbbdf('0x6e')]%0xc8)){socket[_0xbbdf('0x7e')](_0xbbdf('0x7f')+_0xecf8a4,stats);stats[_0xbbdf('0x6f')]=[];}}if(stopped){logger[_0xbbdf('0x5d')](_0xbbdf('0x80'));_0x1d0334[_0xbbdf('0x81')]();}}catch(_0xc77b24){handleError(_0x380e04[_0xbbdf('0x70')][_0x3ffd47],{'code':_0xbbdf('0x82'),'message':_0xc77b24['message']});logger[_0xbbdf('0x1f')](_0xbbdf('0x83'),_0xc77b24['message']);}},'complete':function(){try{var _0x400084=[];var _0x203639=tempTableName;_0x400084['push'](_0xbbdf('0x84')+_0x203639+_0xbbdf('0x85'));logger[_0xbbdf('0x5d')]('CIS\x20len',contactItemTypes[_0xbbdf('0x24')]);var _0x4da445=util['format']('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',_0x363e44,_0x203639,_0x26596f,_0x46d04b['ListId'],_0x46d04b[_0xbbdf('0x59')]||null,NOW,NOW);if(_[_0xbbdf('0x1a')](_0x55d261[_0xbbdf('0x34')])){_0x4da445+=_0xbbdf('0x86');}_0x400084['push'](_0x4da445);BPromise['each'](_0x400084,handleQuery)[_0xbbdf('0x1d')](function(_0x5b625b){BPromise[_0xbbdf('0x21')]([handleAdditionalPhones()])[_0xbbdf('0x1d')](function(){_0x400084=[];for(var _0x234345=0x0;_0x234345<promisesContact[_0xbbdf('0x24')];_0x234345++){_0x400084[_0xbbdf('0x1c')](updateContact(promisesContact[_0x234345][_0xbbdf('0x87')]));}BPromise[_0xbbdf('0x21')](_0x400084)[_0xbbdf('0x1d')](function(){_0x400084=[];for(var _0x181533=0x0;_0x181533<promisesAdditionalPhones['length'];_0x181533++){_0x400084[_0xbbdf('0x1c')](createAdditionalPhone(promisesAdditionalPhones[_0x181533]['contactId'],promisesAdditionalPhones[_0x181533][_0xbbdf('0x88')],promisesAdditionalPhones[_0x181533][_0xbbdf('0x13')],promisesAdditionalPhones[_0x181533][_0xbbdf('0x89')]));}BPromise['all'](_0x400084)[_0xbbdf('0x1d')](function(){_0x400084=[];_0x400084[_0xbbdf('0x1c')](insertCmHopperAdditionalPhones(_0x46d04b[_0xbbdf('0x4a')]));_0x400084['push'](_0xbbdf('0x8a')+_0x203639+';');BPromise[_0xbbdf('0x8b')](_0x400084,handleQuery)[_0xbbdf('0x1d')](function(_0x35358a){stats[_0xbbdf('0x8c')]=!![];stats['affectedRows']=updatedRows;socket[_0xbbdf('0x7e')]('contact:import:'+_0xecf8a4,stats);fs[_0xbbdf('0x8d')](_0x3e098b);fs['unlink'](_0x363e44);process[_0xbbdf('0x5f')](0x0);})[_0xbbdf('0x1e')](function(_0x17bb07){logger['error'](_0x17bb07[_0xbbdf('0x20')]);process[_0xbbdf('0x5f')](0x1);});});});});})[_0xbbdf('0x1e')](function(_0x3c63d0){logger[_0xbbdf('0x1f')](_0x3c63d0[_0xbbdf('0x20')]);process[_0xbbdf('0x5f')](0x1);});}catch(_0x5ae44a){logger[_0xbbdf('0x1f')](_0xbbdf('0x8e'),_0x5ae44a[_0xbbdf('0x20')]);process[_0xbbdf('0x5f')](0x1);}},'error':function(_0x3b39df,_0x57a3d5,_0x637f01,_0x1c7bc9){throw new Error(_0x1c7bc9);}});});}function validate(){if(process[_0xbbdf('0x8f')]&&process[_0xbbdf('0x8f')][_0xbbdf('0x24')]<0x4){throw new Error(_0xbbdf('0x90'));}var _0x439ca2=path['join'](config[_0xbbdf('0x91')],_0xbbdf('0x92'),process[_0xbbdf('0x8f')][0x2]);if(!fs[_0xbbdf('0x93')](_0x439ca2)){throw new Error(_0xbbdf('0x94'));}var _0xc1118f={};try{_0xc1118f=JSON['parse'](process[_0xbbdf('0x8f')][0x3]);if(!_0xc1118f[_0xbbdf('0x65')]){throw new Error(_0xbbdf('0x95'));}var _0x1e31d=0x0;if(_0xc1118f[_0xbbdf('0x65')][_0xbbdf('0x38')]){_0x1e31d=0x1;}if(!_0xc1118f[_0xbbdf('0x4a')]){throw new Error(_0xbbdf('0x96'));}}catch(_0x44a393){throw new Error('body\x20id\x20mandatory');}var _0x3deefb=[];try{_0x3deefb=_[_0xbbdf('0x97')](JSON['parse'](process[_0xbbdf('0x8f')][0x4]),'id');}catch(_0x3074b5){logger[_0xbbdf('0x5d')]('No\x20agent\x20available');}main(_0x439ca2,_0xc1118f,_0x3deefb,_0x1e31d);}validate();process['on']('SIGINT',handleStop);process['on'](_0xbbdf('0x98'),handleUncaughtException);
\ No newline at end of file
+var _0xfd49=['from','join','.id\x20=\x20','where','\x20=\x20','.dialCheckDuplicateType\x20IN\x20(','sequelize','query','select\x20*\x20from\x20','spread','isNil','push','all','then','catch','error','AdditionalPhones','split','length','filter','CmContactHasItem','findOne','update','updated','create','PHONE','inserted','CmContact','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.priority','cm_contacts.UserId','insert','into','cm_hopper','fromQuery','scheduledat','ContactId','ListId','createdAt','updatedAt','priority','UserId','recallme','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22always\x22','\x22onlyIfOpen\x22','toString','cm_contacts.updatedAt','field','cm_hopper_black','cm_hopper.id','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','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','concat','keys','CompanyId',')\x20NOT\x20IN\x20?','ListId\x20=\x20?','min_id','group','info','Received\x20SIGINT','message','errors','code','main','stringify','send','start','clone','socket_timestamp','root','.csv','body','findAll','name','_description','createReadStream','rows','find','hasOwnProperty','data','trim','replace','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','includes','agent\x20not\x20exists','email','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','itemTypeId','description','appendFileSync','emit','contact:import:','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','each','contact','contactId','contactTypeId','orderBy','finish','unlink','exit','complete','argv','server/files/tmp','existsSync','file\x20doesn\x27t\x20exists','parse','binding','body\x20id\x20mandatory','map','No\x20agent\x20available','SIGINT','uncaughtException','path','lodash','papaparse','util','bluebird','moment','squel','../../../config/logger','redis','defaults','format','YYYY-MM-DD\x20HH:mm:ss','cm_contacts_temp_','select','phone'];(function(_0x20a584,_0xe384a5){var _0x4b41a8=function(_0x2127c6){while(--_0x2127c6){_0x20a584['push'](_0x20a584['shift']());}};_0x4b41a8(++_0xe384a5);}(_0xfd49,0x91));var _0x9fd4=function(_0x2483a9,_0x36a874){_0x2483a9=_0x2483a9-0x0;var _0x2545e0=_0xfd49[_0x2483a9];return _0x2545e0;};'use strict';var fs=require('fs');var path=require(_0x9fd4('0x0'));var _=require(_0x9fd4('0x1'));var Papa=require(_0x9fd4('0x2'));var util=require(_0x9fd4('0x3'));var BPromise=require(_0x9fd4('0x4'));var moment=require(_0x9fd4('0x5'));var squel=require(_0x9fd4('0x6'));var Redis=require('ioredis');var db=require('../../../mysqldb')['db'];var config=require('../../../config/environment');var logger=require(_0x9fd4('0x7'))('import');config[_0x9fd4('0x8')]=_[_0x9fd4('0x9')](config[_0x9fd4('0x8')],{'host':'localhost','port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x9fd4('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()[_0x9fd4('0xa')](_0x9fd4('0xb'));var tempTableName=_0x9fd4('0xc')+moment()[_0x9fd4('0xa')]('YYYYMMDDHHmmss');var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];function isEmail(_0x30baba){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'](_0x30baba);}function selectNotIn(_0x100dc9,_0x35d9e3,_0x20754f,_0x449176,_0x292a9f){return squel[_0x9fd4('0xd')]()['field'](_0x9fd4('0xe'))[_0x9fd4('0xf')](_0x449176)[_0x9fd4('0x10')](_0x35d9e3,null,_0x35d9e3+_0x9fd4('0x11')+_0x449176+'.'+_0x20754f)[_0x9fd4('0x12')](_0x449176+'.'+_0x20754f+_0x9fd4('0x13')+_0x100dc9+'.'+_0x20754f)['where'](_0x35d9e3+_0x9fd4('0x14')+_0x292a9f[_0x9fd4('0x10')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x3c1f2f,_0x120d0b){promisesAdditionalPhones=[];promisesContact=[];return db[_0x9fd4('0x15')][_0x9fd4('0x16')](_0x9fd4('0x17')+tempTableName)[_0x9fd4('0x18')](function(_0x27bd8c){if(_0x27bd8c!==null){var _0x21f559=[];for(var _0x43a2dd=0x0;_0x43a2dd<_0x27bd8c['length'];_0x43a2dd++){var _0x42fbc5=_0x27bd8c[_0x43a2dd];if(!_[_0x9fd4('0x19')](_0x42fbc5[_0x9fd4('0xe')])){if(!_[_0x9fd4('0x19')](_0x42fbc5['AdditionalPhones']))_0x21f559[_0x9fd4('0x1a')](insertAdditionalPhones(_0x42fbc5));promisesContact[_0x9fd4('0x1a')]({'contact':_0x42fbc5});}}}Promise[_0x9fd4('0x1b')](_0x21f559)[_0x9fd4('0x1c')](function(){_0x3c1f2f({'val':0x1});});})[_0x9fd4('0x1d')](function(_0x3bcd98){logger[_0x9fd4('0x1e')](_0x3bcd98['message']);});});}function insertAdditionalPhones(_0x5a8d81){return new Promise(function(_0x234261,_0x24df2f){var _0x420d44=_0x5a8d81[_0x9fd4('0x1f')];if(_[_0x9fd4('0x19')](_0x420d44))_0x24df2f({'val':0x0});else{var _0x2df74e=_0x420d44[_0x9fd4('0x20')](';');var _0x15c13e=[];orderBy=0x0;for(var _0xf6b2d3=0x0;_0xf6b2d3<_0x2df74e['length'];_0xf6b2d3++){_0x15c13e[_0x9fd4('0x1a')](splitAdditionalPhone(_0x5a8d81['id'],_0x2df74e[_0xf6b2d3]));}Promise[_0x9fd4('0x1b')](_0x15c13e)[_0x9fd4('0x1c')](function(){_0x234261({'val':_0x2df74e[_0x9fd4('0x21')]});});}});}function splitAdditionalPhone(_0x2eb06b,_0x28ec41){return new Promise(function(_0x48d31d,_0x1013f1){var _0x1cdb49=_0x28ec41['split'](':');var _0x229652=_0x1cdb49[0x0];var _0x5a7562=_0x1cdb49[0x1];if(_0x5a7562!==''){var _0x458e51=_0x5a7562[_0x9fd4('0x20')]('|');var _0x164bd3=[];for(var _0x51fa11=0x0;_0x51fa11<_0x458e51[_0x9fd4('0x21')];_0x51fa11++){if(_0x458e51[_0x51fa11]!==''){var _0x4179fe=_[_0x9fd4('0x22')](promisesAdditionalPhones,{'contactId':_0x2eb06b,'phone':_0x458e51[_0x51fa11]});if(_0x4179fe['length']==0x0){orderBy++;promisesAdditionalPhones['push']({'contactId':_0x2eb06b,'contactTypeId':_0x229652,'phone':_0x458e51[_0x51fa11],'orderBy':orderBy});}}}_0x48d31d({'ok':0x1});}else _0x48d31d({'res':0x0});});}function createAdditionalPhone(_0x359860,_0x1a88b9,_0xaa536,_0x47cb45){var _0x54135d='';var _0x5b33fd='';var _0x4575e5=_0xaa536[_0x9fd4('0x20')]('§');_0x54135d=_0x4575e5[0x0];if(_0x4575e5[_0x9fd4('0x21')]==0x2)_0x5b33fd=_0x4575e5[0x1];return new Promise(function(_0x590e24,_0x2e27be){return db[_0x9fd4('0x23')][_0x9fd4('0x24')]({'where':{'CmContactId':_0x359860,'item':_0x54135d}})[_0x9fd4('0x1c')](function(_0x745121){if(_0x745121){return db[_0x9fd4('0x23')][_0x9fd4('0x25')]({'ItemTypeId':_0x1a88b9,'description':_0x5b33fd,'OrderBy':_0x47cb45},{'where':{'CmContactId':_0x359860,'item':_0x54135d}})[_0x9fd4('0x1c')](function(_0x10e0c8){_0x590e24({'res':_0x9fd4('0x26')});});}else{return db[_0x9fd4('0x23')][_0x9fd4('0x27')]({'CmContactId':_0x359860,'item':_0x54135d,'ItemTypeId':_0x1a88b9,'description':_0x5b33fd,'OrderBy':_0x47cb45,'ItemClass':_0x9fd4('0x28')})['then'](function(_0x1e4ace){_0x590e24({'res':_0x9fd4('0x29')});});}});});}function updateContact(_0x513a8a){return new Promise(function(_0x59d9e6,_0x4b9353){var _0x4e3d07=_0x513a8a['id'];delete _0x513a8a['id'];return db[_0x9fd4('0x2a')][_0x9fd4('0x25')](_0x513a8a,{'where':{'id':_0x4e3d07}})[_0x9fd4('0x1c')](function(_0x32d149){updatedRows+=0x1;return db['CmHopper']['update']({'phone':_0x513a8a[_0x9fd4('0xe')]},{'where':{'ContactId':_0x4e3d07}})['then'](function(_0x3ed88d){_0x59d9e6({'ret':'OK'});});});});}function insertCmHopper(_0x717d44,_0x245dc5,_0x40279c,_0x596ae2,_0x4d9c3d){var _0x227fba=[_0x9fd4('0x2b'),_0x9fd4('0x2c'),_0x9fd4('0x2d'),_0x9fd4('0x2e'),_0x245dc5+'.'+_0x596ae2,_0x9fd4('0x2f'),'cm_contacts.updatedAt',_0x9fd4('0x30'),_0x9fd4('0x31'),'\x22'+_0x4d9c3d+'\x22'];return squel[_0x9fd4('0x32')]()[_0x9fd4('0x33')](_0x9fd4('0x34'))[_0x9fd4('0x35')](['phone',_0x9fd4('0x36'),_0x9fd4('0x37'),_0x9fd4('0x38'),_0x596ae2,_0x9fd4('0x39'),_0x9fd4('0x3a'),_0x9fd4('0x3b'),_0x9fd4('0x3c'),_0x9fd4('0x3d')],squel['select']()[_0x9fd4('0x3e')](_0x227fba)[_0x9fd4('0xf')](_0x245dc5)[_0x9fd4('0x10')](_0x9fd4('0x3f'),null,_0x9fd4('0x40')+_0x245dc5+_0x9fd4('0x41'))['join'](_0x40279c,null,_0x40279c+_0x9fd4('0x11')+_0x245dc5+'.'+_0x596ae2)[_0x9fd4('0x12')](_0x245dc5+_0x9fd4('0x42'),_0x717d44)[_0x9fd4('0x12')](_0x9fd4('0x43'),NOW)['where'](_0x9fd4('0x44'),selectNotIn(_0x245dc5,_0x40279c,_0x596ae2,_0x9fd4('0x34'),[_0x9fd4('0x45'),_0x9fd4('0x46')]))[_0x9fd4('0x12')](_0x9fd4('0x44'),selectNotIn(_0x245dc5,_0x40279c,_0x596ae2,_0x9fd4('0x34'),[_0x9fd4('0x45')])))[_0x9fd4('0x47')]();}function insertCmHopperBlack(_0x271c69,_0x3d93de,_0x8a6cf8,_0x2dc032){var _0x1ee372=['cm_contacts.phone',_0x9fd4('0x2d'),_0x9fd4('0x2e'),_0x3d93de+'.'+_0x2dc032,_0x9fd4('0x2f'),_0x9fd4('0x48')];return squel[_0x9fd4('0x32')]()['into']('cm_hopper_black')[_0x9fd4('0x35')]([_0x9fd4('0xe'),_0x9fd4('0x37'),_0x9fd4('0x38'),_0x2dc032,_0x9fd4('0x39'),_0x9fd4('0x3a')],squel[_0x9fd4('0xd')]()[_0x9fd4('0x3e')](_0x1ee372)['from'](_0x3d93de)['join']('cm_contacts',null,_0x9fd4('0x40')+_0x3d93de+'.CmListId')['join'](_0x8a6cf8,null,_0x8a6cf8+_0x9fd4('0x11')+_0x3d93de+'.'+_0x2dc032)['where'](_0x3d93de+_0x9fd4('0x42'),_0x271c69)[_0x9fd4('0x12')](_0x9fd4('0x43'),NOW)[_0x9fd4('0x12')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel['select']()[_0x9fd4('0x49')]('phone')[_0x9fd4('0xf')](_0x9fd4('0x4a'))['where']('ListId\x20=\x20?',_0x271c69)['where'](_0x2dc032+'\x20=\x20?',_0x3d93de+'.'+_0x2dc032)))[_0x9fd4('0x47')]();}function insertCmHopperAdditionalPhones(_0xbeaab3){var _0x4fbf3f=[_0x9fd4('0x4b'),'cm_contact_has_items.item',_0x9fd4('0x4c'),_0x9fd4('0x4d'),'cm_contact_has_items.updatedAt'];return squel[_0x9fd4('0x32')]()[_0x9fd4('0x33')](_0x9fd4('0x4e'))[_0x9fd4('0x35')]([_0x9fd4('0x4f'),_0x9fd4('0xe'),_0x9fd4('0x50'),_0x9fd4('0x39'),_0x9fd4('0x3a')],squel[_0x9fd4('0xd')]()['fields'](_0x4fbf3f)[_0x9fd4('0xf')](_0x9fd4('0x34'))[_0x9fd4('0x10')](_0x9fd4('0x3f'),null,_0x9fd4('0x51'))[_0x9fd4('0x10')](_0x9fd4('0x52'),null,_0x9fd4('0x53'))[_0x9fd4('0x12')]('cm_hopper.ListId\x20=\x20?',_0xbeaab3)[_0x9fd4('0x12')](_0x9fd4('0x43'),NOW))['toString']();}function insertCmContact(_0x1eb829,_0x3924b3,_0x5c294f,_0x2edc23){var _0x55e7bb=_[_0x9fd4('0x54')](_[_0x9fd4('0x55')](_0x2edc23),[_0x9fd4('0x38'),_0x9fd4('0x56'),_0x9fd4('0x39'),_0x9fd4('0x3a')]);return squel[_0x9fd4('0x32')]()['into'](_0x9fd4('0x3f'))[_0x9fd4('0x35')](_0x55e7bb,squel['select']()[_0x9fd4('0x3e')](_0x55e7bb)[_0x9fd4('0xf')](_0x3924b3)['where']('('+_0x5c294f['join'](',')+_0x9fd4('0x57'),squel[_0x9fd4('0xd')]()[_0x9fd4('0x3e')](_0x5c294f)[_0x9fd4('0xf')](_0x9fd4('0x3f'))[_0x9fd4('0x12')](_0x9fd4('0x58'),_0x1eb829))[_0x9fd4('0x12')]('id\x20IN\x20?',squel[_0x9fd4('0xd')]()[_0x9fd4('0x49')]('MIN(id)',_0x9fd4('0x59'))['from'](_0x3924b3)[_0x9fd4('0x5a')](_0x5c294f[_0x9fd4('0x10')](','))))[_0x9fd4('0x47')]();}function handleStop(){logger[_0x9fd4('0x5b')](_0x9fd4('0x5c'));stopped=!![];}function handleUncaughtException(_0x4cb8fd){logger[_0x9fd4('0x1e')](_0x4cb8fd[_0x9fd4('0x5d')]);process['exit'](0x1);}function handleError(_0x57fe39,_0x1223d7){stats[_0x9fd4('0x5e')][_0x9fd4('0x1a')]({'name':_0x1223d7[_0x9fd4('0x5f')],'message':_0x1223d7['message'],'row':_0x57fe39});}function handleQuery(_0x58de1f){logger['info'](_0x58de1f);return db[_0x9fd4('0x15')][_0x9fd4('0x16')](_0x58de1f)[_0x9fd4('0x18')](function(_0x551ca3){results[_0x9fd4('0x1a')](_0x551ca3);})[_0x9fd4('0x1d')](function(_0x4e595a){logger[_0x9fd4('0x1e')](_0x4e595a[_0x9fd4('0x5d')]);});}function main(_0x4c3d0e,_0x5abeca,_0xfc1e16,_0x516625){logger[_0x9fd4('0x5b')](_0x9fd4('0x60'),_0x4c3d0e,JSON[_0x9fd4('0x61')](_0x5abeca));process[_0x9fd4('0x62')](_0x9fd4('0x63'));var _0x332539=_0x5abeca['binding'];var _0x280921=_[_0x9fd4('0x64')](_0x332539);var _0xb7691e=_0x5abeca[_0x9fd4('0x65')];var _0x2571e1=path[_0x9fd4('0x10')](config[_0x9fd4('0x66')],'server/files/tmp',_0xb7691e+_0x9fd4('0x67'));logger[_0x9fd4('0x5b')](_0x9fd4('0x68'),_0x5abeca);db['ContactItemType'][_0x9fd4('0x69')]({'raw':!![],'attributes':['id',_0x9fd4('0x6a')]})['then'](function(_0x1a27b0){for(var _0xfd28ac=0x0;_0xfd28ac<_0x1a27b0[_0x9fd4('0x21')];_0xfd28ac++){if(_0x1a27b0[_0xfd28ac][_0x9fd4('0x6a')]in _0x332539){contactItemTypes[_0x9fd4('0x1a')](_0x1a27b0[_0xfd28ac]);delete _0x280921[_0x1a27b0[_0xfd28ac][_0x9fd4('0x6a')]];hasAdditionalPhones=!![];}for(var _0x466fe4 in _0x332539){if(_0x1a27b0[_0xfd28ac]['name']+_0x9fd4('0x6b')===_0x466fe4){phoneDescriptions['push']({'itemTypeId':_0x1a27b0[_0xfd28ac]['id'],'description':_0x466fe4});delete _0x280921[_0x466fe4];}}}if(hasAdditionalPhones)_0x280921[_0x9fd4('0x1f')]='';var _0x348285=_[_0x9fd4('0x55')](_0x280921)[_0x9fd4('0x10')]();logger['info']('header',_0x348285);fs['writeFileSync'](_0x2571e1,_0x348285+'\x0a');Papa['parse'](fs[_0x9fd4('0x6c')](_0x4c3d0e),{'header':!![],'skipEmptyLines':!![],'step':function(_0x33ed18,_0x110cde){try{for(var _0x7e516f=0x0,_0xdf60ce=[];_0x7e516f<_0x33ed18['data'][_0x9fd4('0x21')];_0x7e516f++){stats[_0x9fd4('0x6d')]+=0x1;if(_0x33ed18[_0x9fd4('0x5e')][_0x7e516f]){handleError(_0x33ed18['data'][_0x7e516f],_0x33ed18['errors'][_0x7e516f]);}else{var _0x229814=[];var _0x4a7c31=[];var _0x508dba={};for(var _0x2f5a46 in _0x332539){let _0x1f449e=contactItemTypes[_0x9fd4('0x6e')](_0x522058=>_0x522058[_0x9fd4('0x6a')]===_0x2f5a46);let _0x188886=contactItemTypes[_0x9fd4('0x6e')](_0x322dbe=>_0x322dbe[_0x9fd4('0x6a')]+_0x9fd4('0x6b')===_0x2f5a46);if(_[_0x9fd4('0x19')](_0x1f449e)&&_[_0x9fd4('0x19')](_0x188886)){if(_0x332539[_0x9fd4('0x6f')](_0x2f5a46)){if(_0x33ed18[_0x9fd4('0x70')][_0x7e516f][_0x332539[_0x2f5a46]]){var _0x479b94=_[_0x9fd4('0x71')](_0x33ed18[_0x9fd4('0x70')][_0x7e516f][_0x332539[_0x2f5a46]][_0x9fd4('0x72')](/"/g,'\x27'));switch(_0x2f5a46){case _0x9fd4('0x36'):var _0x1dd12c=moment(_0x479b94,_0x9fd4('0xb'),!![]);if(_0x1dd12c[_0x9fd4('0x73')]()){_0xdf60ce['push']('\x22'+_0x479b94+'\x22');}else{_0x229814[_0x9fd4('0x1a')](_0x9fd4('0x74'));}break;case'priority':var _0x39758f=parseInt(_0x479b94);_0x479b94=_[_0x9fd4('0x75')](_0x39758f)||_0x39758f<0x0||_0x39758f>0x4?_0x516625?0x3:0x2:_0x39758f;_0xdf60ce[_0x9fd4('0x1a')]('\x22'+_0x479b94+'\x22');break;case _0x9fd4('0x3c'):var _0x436d93=parseInt(_0x479b94);if(_[_0x9fd4('0x76')](_0x436d93)&&_[_0x9fd4('0x77')](_0xfc1e16,_0x436d93)){_0xdf60ce[_0x9fd4('0x1a')]('\x22'+_0x436d93+'\x22');}else{_0x229814[_0x9fd4('0x1a')](_0x9fd4('0x78'));}break;case _0x9fd4('0x79'):if(isEmail(_0x479b94)){_0xdf60ce[_0x9fd4('0x1a')]('\x22'+_0x479b94+'\x22');}else{_0x229814[_0x9fd4('0x1a')]('email\x20wrong\x20format');}break;case _0x9fd4('0x7a'):var _0x2ab43a=moment(_0x479b94,_0x9fd4('0x7b'),!![]);if(_0x2ab43a[_0x9fd4('0x73')]()){_0xdf60ce['push']('\x22'+_0x479b94+'\x22');}else{_0x229814[_0x9fd4('0x1a')](_0x9fd4('0x7c'));}break;default:_0xdf60ce[_0x9fd4('0x1a')]('\x22'+_0x479b94+'\x22');}}else{switch(_0x2f5a46){case _0x9fd4('0x7d'):case _0x9fd4('0xe'):_0x229814[_0x9fd4('0x1a')](_0x2f5a46+_0x9fd4('0x7e'));break;default:_0xdf60ce[_0x9fd4('0x1a')]('\x22\x22');}}}}else{var _0x3cca7b='';if(!_['isNil'](_0x1f449e)){if(!_0x508dba[_0x9fd4('0x6f')](_0x1f449e['id'])){for(var _0xa38b27=0x0;_0xa38b27<_0x332539[_0x2f5a46][_0x9fd4('0x21')];_0xa38b27++){var _0x479b94=_[_0x9fd4('0x71')](_0x33ed18[_0x9fd4('0x70')][_0x7e516f][_0x332539[_0x2f5a46][_0xa38b27]][_0x9fd4('0x72')](/"/g,'\x27'));var _0x41c42d=phoneDescriptions[_0x9fd4('0x6e')](_0x37eef4=>_0x37eef4[_0x9fd4('0x7f')]===_0x1f449e['id']);if(!_[_0x9fd4('0x19')](_0x41c42d)){var _0x477567=_['trim'](_0x33ed18['data'][_0x7e516f][_0x332539[_0x41c42d[_0x9fd4('0x80')]][0x0]][_0x9fd4('0x72')](/"/g,'\x27'));if(!_[_0x9fd4('0x19')](_0x477567))_0x479b94=_0x479b94+'§'+_0x477567;}if(_0x3cca7b=='')_0x3cca7b=_0x479b94;else _0x3cca7b+='|'+_0x479b94;}_0x4a7c31[_0x9fd4('0x1a')](_0x1f449e['id']+':'+_0x3cca7b);_0x508dba[_0x1f449e['id']]=0x1;}}}}if(hasAdditionalPhones){_0xdf60ce[_0x9fd4('0x1a')]('\x22'+_0x4a7c31[_0x9fd4('0x10')](';')+'\x22');}if(_0x229814[_0x9fd4('0x21')]){handleError(_0x33ed18[_0x9fd4('0x70')][_0x7e516f],{'code':'SystemRow','message':_0x229814[_0x9fd4('0x10')]()});}else{fs[_0x9fd4('0x81')](_0x2571e1,_0xdf60ce[_0x9fd4('0x10')]()+'\x0a');}_0xdf60ce=[];}if(!(stats[_0x9fd4('0x6d')]%0xc8)){socket[_0x9fd4('0x82')](_0x9fd4('0x83')+_0xb7691e,stats);stats[_0x9fd4('0x5e')]=[];}}if(stopped){logger[_0x9fd4('0x5b')](_0x9fd4('0x84'));_0x110cde[_0x9fd4('0x85')]();}}catch(_0x5de9fa){handleError(_0x33ed18[_0x9fd4('0x70')][_0x7e516f],{'code':_0x9fd4('0x86'),'message':_0x5de9fa[_0x9fd4('0x5d')]});logger[_0x9fd4('0x1e')](_0x9fd4('0x87'),_0x5de9fa['message']);}},'complete':function(){try{var _0x49dbd2=[];var _0x135791=tempTableName;_0x49dbd2[_0x9fd4('0x1a')](_0x9fd4('0x88')+_0x135791+_0x9fd4('0x89'));logger['info'](_0x9fd4('0x8a'),contactItemTypes[_0x9fd4('0x21')]);var _0x27998d=util[_0x9fd4('0xa')](_0x9fd4('0x8b'),_0x2571e1,_0x135791,_0x348285,_0x5abeca[_0x9fd4('0x38')],_0x5abeca[_0x9fd4('0x56')]||null,NOW,NOW);if(_['isNil'](_0x332539[_0x9fd4('0x36')])){_0x27998d+=',\x20scheduledAt\x20=\x20NOW()';}_0x49dbd2[_0x9fd4('0x1a')](_0x27998d);BPromise[_0x9fd4('0x8c')](_0x49dbd2,handleQuery)[_0x9fd4('0x1c')](function(_0x446271){BPromise[_0x9fd4('0x1b')]([handleAdditionalPhones()])['then'](function(){_0x49dbd2=[];for(var _0x56685c=0x0;_0x56685c<promisesContact[_0x9fd4('0x21')];_0x56685c++){_0x49dbd2[_0x9fd4('0x1a')](updateContact(promisesContact[_0x56685c][_0x9fd4('0x8d')]));}BPromise[_0x9fd4('0x1b')](_0x49dbd2)[_0x9fd4('0x1c')](function(){_0x49dbd2=[];for(var _0x16fd78=0x0;_0x16fd78<promisesAdditionalPhones[_0x9fd4('0x21')];_0x16fd78++){_0x49dbd2[_0x9fd4('0x1a')](createAdditionalPhone(promisesAdditionalPhones[_0x16fd78][_0x9fd4('0x8e')],promisesAdditionalPhones[_0x16fd78][_0x9fd4('0x8f')],promisesAdditionalPhones[_0x16fd78]['phone'],promisesAdditionalPhones[_0x16fd78][_0x9fd4('0x90')]));}BPromise[_0x9fd4('0x1b')](_0x49dbd2)['then'](function(){_0x49dbd2=[];_0x49dbd2['push'](insertCmHopperAdditionalPhones(_0x5abeca['ListId']));_0x49dbd2[_0x9fd4('0x1a')]('DROP\x20TABLE\x20'+_0x135791+';');BPromise['each'](_0x49dbd2,handleQuery)[_0x9fd4('0x1c')](function(_0x1f1421){stats[_0x9fd4('0x91')]=!![];stats['affectedRows']=updatedRows;socket['emit'](_0x9fd4('0x83')+_0xb7691e,stats);fs[_0x9fd4('0x92')](_0x4c3d0e);fs[_0x9fd4('0x92')](_0x2571e1);process['exit'](0x0);})[_0x9fd4('0x1d')](function(_0x40b14d){logger[_0x9fd4('0x1e')](_0x40b14d[_0x9fd4('0x5d')]);process[_0x9fd4('0x93')](0x1);});});});});})[_0x9fd4('0x1d')](function(_0x4ad509){logger[_0x9fd4('0x1e')](_0x4ad509[_0x9fd4('0x5d')]);process[_0x9fd4('0x93')](0x1);});}catch(_0x16fe24){logger['error'](_0x9fd4('0x94'),_0x16fe24[_0x9fd4('0x5d')]);process[_0x9fd4('0x93')](0x1);}},'error':function(_0xf89512,_0x3b97ba,_0x39da4a,_0x42a9f1){throw new Error(_0x42a9f1);}});});}function validate(){if(process[_0x9fd4('0x95')]&&process['argv'][_0x9fd4('0x21')]<0x4){throw new Error('arguments\x20<filename>\x20<parameters>\x20<agents>');}var _0x522891=path[_0x9fd4('0x10')](config[_0x9fd4('0x66')],_0x9fd4('0x96'),process[_0x9fd4('0x95')][0x2]);if(!fs[_0x9fd4('0x97')](_0x522891)){throw new Error(_0x9fd4('0x98'));}var _0x4eafff={};try{_0x4eafff=JSON[_0x9fd4('0x99')](process[_0x9fd4('0x95')][0x3]);if(!_0x4eafff[_0x9fd4('0x9a')]){throw new Error('binding\x20doesn\x27t\x20exists');}var _0x56b641=0x0;if(_0x4eafff[_0x9fd4('0x9a')][_0x9fd4('0x3c')]){_0x56b641=0x1;}if(!_0x4eafff[_0x9fd4('0x38')]){throw new Error('ListId\x20is\x20mandatory');}}catch(_0x39cd4d){throw new Error(_0x9fd4('0x9b'));}var _0x3d1da9=[];try{_0x3d1da9=_[_0x9fd4('0x9c')](JSON['parse'](process[_0x9fd4('0x95')][0x4]),'id');}catch(_0x40e0d9){logger[_0x9fd4('0x5b')](_0x9fd4('0x9d'));}main(_0x522891,_0x4eafff,_0x3d1da9,_0x56b641);}validate();process['on'](_0x9fd4('0x9e'),handleStop);process['on'](_0x9fd4('0x9f'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff