18 var _0x1f20=['findOne','updated','create','PHONE','CmContact','update','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','into','cm_hopper','fromQuery','scheduledat','ContactId','ListId','createdAt','UserId','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','insert','cm_hopper_black','updatedAt','fields','\x20=\x20?','toString','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','CmHopperId','OrderBy','cm_contact_has_items','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId',')\x20NOT\x20IN\x20?','ListId\x20=\x20?','id\x20IN\x20?','MIN(id)','group','info','Received\x20SIGINT','message','exit','errors','code','stringify','send','start','binding','clone','socket_timestamp','root','server/files/tmp','body','ContactItemType','name','_description','header','writeFileSync','parse','createReadStream','rows','data','find','trim','replace','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','priority','isNaN','isNumber','includes','agent\x20not\x20exists','email','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','hasOwnProperty','itemTypeId','description','SystemRow','appendFileSync','contact:import:','Abort\x20parser','abort','SystemError','step','CREATE\x20TABLE\x20','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','finish','affectedRows','emit','unlink','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','body\x20id\x20mandatory','map','SIGINT','uncaughtException','path','lodash','util','moment','squel','../../../mysqldb','import','redis','defaults','localhost','socket.io-emitter','format','YYYY-MM-DD\x20HH:mm:ss','cm_contacts_temp_','YYYYMMDDHHmmss','select','field','from','join','.id\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','query','select\x20*\x20from\x20','spread','isNil','phone','AdditionalPhones','push','all','then','catch','error','split','length','CmContactHasItem'];(function(_0x1facfa,_0x1acf7d){var _0x9ec701=function(_0x115e37){while(--_0x115e37){_0x1facfa['push'](_0x1facfa['shift']());}};_0x9ec701(++_0x1acf7d);}(_0x1f20,0x11c));var _0x01f2=function(_0x19950b,_0x53d0d7){_0x19950b=_0x19950b-0x0;var _0x3c6b41=_0x1f20[_0x19950b];return _0x3c6b41;};'use strict';var fs=require('fs');var path=require(_0x01f2('0x0'));var _=require(_0x01f2('0x1'));var Papa=require('papaparse');var util=require(_0x01f2('0x2'));var BPromise=require('bluebird');var moment=require(_0x01f2('0x3'));var squel=require(_0x01f2('0x4'));var Redis=require('ioredis');var db=require(_0x01f2('0x5'))['db'];var config=require('../../../config/environment');var logger=require('../../../config/logger')(_0x01f2('0x6'));config[_0x01f2('0x7')]=_[_0x01f2('0x8')](config[_0x01f2('0x7')],{'host':_0x01f2('0x9'),'port':0x18eb});var socket=require(_0x01f2('0xa'))(new Redis(config[_0x01f2('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()[_0x01f2('0xb')](_0x01f2('0xc'));var tempTableName=_0x01f2('0xd')+moment()[_0x01f2('0xb')](_0x01f2('0xe'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];function isEmail(_0x33fd40){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'](_0x33fd40);}function selectNotIn(_0x30abe8,_0x4a56a5,_0x5b37e9,_0x425729,_0xe57cbe){return squel[_0x01f2('0xf')]()[_0x01f2('0x10')]('phone')[_0x01f2('0x11')](_0x425729)[_0x01f2('0x12')](_0x4a56a5,null,_0x4a56a5+_0x01f2('0x13')+_0x425729+'.'+_0x5b37e9)[_0x01f2('0x14')](_0x425729+'.'+_0x5b37e9+'\x20=\x20'+_0x30abe8+'.'+_0x5b37e9)[_0x01f2('0x14')](_0x4a56a5+_0x01f2('0x15')+_0xe57cbe[_0x01f2('0x12')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x5c9443,_0xb80ef4){promisesAdditionalPhones=[];promisesContact=[];return db['sequelize'][_0x01f2('0x16')](_0x01f2('0x17')+tempTableName)[_0x01f2('0x18')](function(_0x5e4eb4){if(_0x5e4eb4!==null){var _0x14ebac=[];for(var _0x56ded9=0x0;_0x56ded9<_0x5e4eb4['length'];_0x56ded9++){var _0x276182=_0x5e4eb4[_0x56ded9];if(!_[_0x01f2('0x19')](_0x276182[_0x01f2('0x1a')])){if(!_[_0x01f2('0x19')](_0x276182[_0x01f2('0x1b')]))_0x14ebac['push'](insertAdditionalPhones(_0x276182));promisesContact[_0x01f2('0x1c')]({'contact':_0x276182});}}}Promise[_0x01f2('0x1d')](_0x14ebac)[_0x01f2('0x1e')](function(){_0x5c9443({'val':0x1});});})[_0x01f2('0x1f')](function(_0x1d40c3){logger[_0x01f2('0x20')](_0x1d40c3['message']);});});}function insertAdditionalPhones(_0x3cac5a){return new Promise(function(_0xf56702,_0x13be73){var _0x29e20c=_0x3cac5a[_0x01f2('0x1b')];if(_[_0x01f2('0x19')](_0x29e20c))_0x13be73({'val':0x0});else{var _0x3addff=_0x29e20c[_0x01f2('0x21')](';');var _0x274f6f=[];orderBy=0x0;for(var _0x454d38=0x0;_0x454d38<_0x3addff[_0x01f2('0x22')];_0x454d38++){_0x274f6f[_0x01f2('0x1c')](splitAdditionalPhone(_0x3cac5a['id'],_0x3addff[_0x454d38]));}Promise[_0x01f2('0x1d')](_0x274f6f)['then'](function(){_0xf56702({'val':_0x3addff['length']});});}});}function splitAdditionalPhone(_0x4c9c3d,_0x5aea70){return new Promise(function(_0x5869ca,_0x36dc7b){var _0x4f2201=_0x5aea70[_0x01f2('0x21')](':');var _0x86a9a2=_0x4f2201[0x0];var _0x4b4958=_0x4f2201[0x1];if(_0x4b4958!==''){var _0x33e696=_0x4b4958['split']('|');var _0x1ab57f=[];for(var _0x5966f9=0x0;_0x5966f9<_0x33e696[_0x01f2('0x22')];_0x5966f9++){if(_0x33e696[_0x5966f9]!==''){var _0x510bdb=_['filter'](promisesAdditionalPhones,{'contactId':_0x4c9c3d,'phone':_0x33e696[_0x5966f9]});if(_0x510bdb[_0x01f2('0x22')]==0x0){orderBy++;promisesAdditionalPhones[_0x01f2('0x1c')]({'contactId':_0x4c9c3d,'contactTypeId':_0x86a9a2,'phone':_0x33e696[_0x5966f9],'orderBy':orderBy});}}}_0x5869ca({'ok':0x1});}else _0x5869ca({'res':0x0});});}function createAdditionalPhone(_0x47acff,_0x17540b,_0x3c2e83,_0x433749){var _0x126b5e='';var _0xb51673='';var _0x13c51a=_0x3c2e83['split']('§');_0x126b5e=_0x13c51a[0x0];if(_0x13c51a[_0x01f2('0x22')]==0x2)_0xb51673=_0x13c51a[0x1];return new Promise(function(_0xb81e25,_0x3fabc0){return db[_0x01f2('0x23')][_0x01f2('0x24')]({'where':{'CmContactId':_0x47acff,'item':_0x126b5e}})['then'](function(_0x4d34cc){if(_0x4d34cc){return db[_0x01f2('0x23')]['update']({'ItemTypeId':_0x17540b,'description':_0xb51673,'OrderBy':_0x433749},{'where':{'CmContactId':_0x47acff,'item':_0x126b5e}})['then'](function(_0x36cda7){_0xb81e25({'res':_0x01f2('0x25')});});}else{return db[_0x01f2('0x23')][_0x01f2('0x26')]({'CmContactId':_0x47acff,'item':_0x126b5e,'ItemTypeId':_0x17540b,'description':_0xb51673,'OrderBy':_0x433749,'ItemClass':_0x01f2('0x27')})['then'](function(_0x3eeab2){_0xb81e25({'res':'inserted'});});}});});}function updateContact(_0x7af09e){return new Promise(function(_0x23a32f,_0x18d523){var _0x11293b=_0x7af09e['id'];delete _0x7af09e['id'];return db[_0x01f2('0x28')][_0x01f2('0x29')](_0x7af09e,{'where':{'id':_0x11293b}})['then'](function(_0x19758e){updatedRows+=0x1;return db['CmHopper'][_0x01f2('0x29')]({'phone':_0x7af09e[_0x01f2('0x1a')]},{'where':{'ContactId':_0x11293b}})[_0x01f2('0x1e')](function(_0x1f1368){_0x23a32f({'ret':'OK'});});});});}function insertCmHopper(_0x3eefc3,_0x1115d8,_0x201dc4,_0x244d8a,_0x3e250f){var _0x3dccfb=[_0x01f2('0x2a'),_0x01f2('0x2b'),_0x01f2('0x2c'),_0x01f2('0x2d'),_0x1115d8+'.'+_0x244d8a,'cm_contacts.createdAt',_0x01f2('0x2e'),_0x01f2('0x2f'),_0x01f2('0x30'),'\x22'+_0x3e250f+'\x22'];return squel['insert']()[_0x01f2('0x31')](_0x01f2('0x32'))[_0x01f2('0x33')]([_0x01f2('0x1a'),_0x01f2('0x34'),_0x01f2('0x35'),_0x01f2('0x36'),_0x244d8a,_0x01f2('0x37'),'updatedAt','priority',_0x01f2('0x38'),'recallme'],squel[_0x01f2('0xf')]()['fields'](_0x3dccfb)[_0x01f2('0x11')](_0x1115d8)[_0x01f2('0x12')](_0x01f2('0x39'),null,_0x01f2('0x3a')+_0x1115d8+_0x01f2('0x3b'))[_0x01f2('0x12')](_0x201dc4,null,_0x201dc4+'.id\x20=\x20'+_0x1115d8+'.'+_0x244d8a)[_0x01f2('0x14')](_0x1115d8+_0x01f2('0x3c'),_0x3eefc3)[_0x01f2('0x14')](_0x01f2('0x3d'),NOW)[_0x01f2('0x14')](_0x01f2('0x3e'),selectNotIn(_0x1115d8,_0x201dc4,_0x244d8a,_0x01f2('0x32'),[_0x01f2('0x3f'),_0x01f2('0x40')]))[_0x01f2('0x14')](_0x01f2('0x3e'),selectNotIn(_0x1115d8,_0x201dc4,_0x244d8a,'cm_hopper',['\x22always\x22'])))['toString']();}function insertCmHopperBlack(_0x1aea8e,_0x3bc208,_0x5d7188,_0x5d0f15){var _0xc89fdc=[_0x01f2('0x2a'),'cm_contacts.id','cm_contacts.ListId',_0x3bc208+'.'+_0x5d0f15,'cm_contacts.createdAt',_0x01f2('0x2e')];return squel[_0x01f2('0x41')]()[_0x01f2('0x31')](_0x01f2('0x42'))[_0x01f2('0x33')]([_0x01f2('0x1a'),_0x01f2('0x35'),_0x01f2('0x36'),_0x5d0f15,'createdAt',_0x01f2('0x43')],squel[_0x01f2('0xf')]()[_0x01f2('0x44')](_0xc89fdc)['from'](_0x3bc208)[_0x01f2('0x12')](_0x01f2('0x39'),null,'cm_contacts.ListId\x20=\x20'+_0x3bc208+_0x01f2('0x3b'))['join'](_0x5d7188,null,_0x5d7188+_0x01f2('0x13')+_0x3bc208+'.'+_0x5d0f15)[_0x01f2('0x14')](_0x3bc208+'.CmListId\x20=\x20?',_0x1aea8e)[_0x01f2('0x14')](_0x01f2('0x3d'),NOW)[_0x01f2('0x14')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel[_0x01f2('0xf')]()[_0x01f2('0x10')](_0x01f2('0x1a'))[_0x01f2('0x11')]('cm_hopper_black')['where']('ListId\x20=\x20?',_0x1aea8e)[_0x01f2('0x14')](_0x5d0f15+_0x01f2('0x45'),_0x3bc208+'.'+_0x5d0f15)))[_0x01f2('0x46')]();}function insertCmHopperAdditionalPhones(_0x8d16a4){var _0x293960=['cm_hopper.id',_0x01f2('0x47'),_0x01f2('0x48'),'cm_contact_has_items.createdAt',_0x01f2('0x49')];return squel[_0x01f2('0x41')]()[_0x01f2('0x31')](_0x01f2('0x4a'))['fromQuery']([_0x01f2('0x4b'),_0x01f2('0x1a'),_0x01f2('0x4c'),_0x01f2('0x37'),'updatedAt'],squel[_0x01f2('0xf')]()['fields'](_0x293960)[_0x01f2('0x11')](_0x01f2('0x32'))[_0x01f2('0x12')]('cm_contacts',null,'cm_contacts.id\x20=\x20cm_hopper.ContactId')['join'](_0x01f2('0x4d'),null,_0x01f2('0x4e'))['where'](_0x01f2('0x4f'),_0x8d16a4)[_0x01f2('0x14')](_0x01f2('0x3d'),NOW))['toString']();}function insertCmContact(_0x9d92bc,_0x54a5c7,_0x10752a,_0x12dc9f){var _0x506a25=_[_0x01f2('0x50')](_[_0x01f2('0x51')](_0x12dc9f),[_0x01f2('0x36'),_0x01f2('0x52'),_0x01f2('0x37'),_0x01f2('0x43')]);return squel['insert']()[_0x01f2('0x31')](_0x01f2('0x39'))[_0x01f2('0x33')](_0x506a25,squel[_0x01f2('0xf')]()['fields'](_0x506a25)['from'](_0x54a5c7)['where']('('+_0x10752a[_0x01f2('0x12')](',')+_0x01f2('0x53'),squel['select']()['fields'](_0x10752a)[_0x01f2('0x11')](_0x01f2('0x39'))[_0x01f2('0x14')](_0x01f2('0x54'),_0x9d92bc))[_0x01f2('0x14')](_0x01f2('0x55'),squel['select']()[_0x01f2('0x10')](_0x01f2('0x56'),'min_id')[_0x01f2('0x11')](_0x54a5c7)[_0x01f2('0x57')](_0x10752a[_0x01f2('0x12')](','))))[_0x01f2('0x46')]();}function handleStop(){logger[_0x01f2('0x58')](_0x01f2('0x59'));stopped=!![];}function handleUncaughtException(_0x4b4153){logger[_0x01f2('0x20')](_0x4b4153[_0x01f2('0x5a')]);process[_0x01f2('0x5b')](0x1);}function handleError(_0x137b5e,_0x50d8e8){stats[_0x01f2('0x5c')][_0x01f2('0x1c')]({'name':_0x50d8e8[_0x01f2('0x5d')],'message':_0x50d8e8[_0x01f2('0x5a')],'row':_0x137b5e});}function handleQuery(_0x4b2906){logger[_0x01f2('0x58')](_0x4b2906);return db['sequelize'][_0x01f2('0x16')](_0x4b2906)[_0x01f2('0x18')](function(_0x5db932){results[_0x01f2('0x1c')](_0x5db932);})[_0x01f2('0x1f')](function(_0x241b5b){logger[_0x01f2('0x20')](_0x241b5b[_0x01f2('0x5a')]);});}function main(_0x7ccd04,_0x20d8ae,_0x482b24,_0x49c141){logger[_0x01f2('0x58')]('main',_0x7ccd04,JSON[_0x01f2('0x5e')](_0x20d8ae));process[_0x01f2('0x5f')](_0x01f2('0x60'));var _0x192824=_0x20d8ae[_0x01f2('0x61')];var _0x229a87=_[_0x01f2('0x62')](_0x192824);var _0x368539=_0x20d8ae[_0x01f2('0x63')];var _0x365eb1=path[_0x01f2('0x12')](config[_0x01f2('0x64')],_0x01f2('0x65'),_0x368539+'.csv');logger[_0x01f2('0x58')](_0x01f2('0x66'),_0x20d8ae);db[_0x01f2('0x67')]['findAll']({'raw':!![],'attributes':['id',_0x01f2('0x68')]})[_0x01f2('0x1e')](function(_0x7e0ee6){for(var _0x814c5b=0x0;_0x814c5b<_0x7e0ee6[_0x01f2('0x22')];_0x814c5b++){if(_0x7e0ee6[_0x814c5b][_0x01f2('0x68')]in _0x192824){contactItemTypes['push'](_0x7e0ee6[_0x814c5b]);delete _0x229a87[_0x7e0ee6[_0x814c5b][_0x01f2('0x68')]];hasAdditionalPhones=!![];}for(var _0x510e76 in _0x192824){if(_0x7e0ee6[_0x814c5b][_0x01f2('0x68')]+_0x01f2('0x69')===_0x510e76){phoneDescriptions[_0x01f2('0x1c')]({'itemTypeId':_0x7e0ee6[_0x814c5b]['id'],'description':_0x510e76});delete _0x229a87[_0x510e76];}}}if(hasAdditionalPhones)_0x229a87[_0x01f2('0x1b')]='';var _0x2d14df=_[_0x01f2('0x51')](_0x229a87)[_0x01f2('0x12')]();logger[_0x01f2('0x58')](_0x01f2('0x6a'),_0x2d14df);fs[_0x01f2('0x6b')](_0x365eb1,_0x2d14df+'\x0a');Papa[_0x01f2('0x6c')](fs[_0x01f2('0x6d')](_0x7ccd04),{'header':!![],'skipEmptyLines':!![],'step':function(_0x39f95a,_0x308402){try{for(var _0x6504eb=0x0,_0x4b5d63=[];_0x6504eb<_0x39f95a['data'][_0x01f2('0x22')];_0x6504eb++){stats[_0x01f2('0x6e')]+=0x1;if(_0x39f95a[_0x01f2('0x5c')][_0x6504eb]){handleError(_0x39f95a[_0x01f2('0x6f')][_0x6504eb],_0x39f95a[_0x01f2('0x5c')][_0x6504eb]);}else{var _0x5f2146=[];var _0x2ff28d=[];var _0x4d85d7={};for(var _0x368119 in _0x192824){let _0x28904b=contactItemTypes[_0x01f2('0x70')](_0x4b999c=>_0x4b999c[_0x01f2('0x68')]===_0x368119);let _0x470ab6=contactItemTypes['find'](_0x24c5b0=>_0x24c5b0['name']+_0x01f2('0x69')===_0x368119);if(_[_0x01f2('0x19')](_0x28904b)&&_[_0x01f2('0x19')](_0x470ab6)){if(_0x192824['hasOwnProperty'](_0x368119)){if(_0x39f95a[_0x01f2('0x6f')][_0x6504eb][_0x192824[_0x368119]]){var _0x26d45e=_[_0x01f2('0x71')](_0x39f95a[_0x01f2('0x6f')][_0x6504eb][_0x192824[_0x368119]][_0x01f2('0x72')](/"/g,'\x27'));switch(_0x368119){case _0x01f2('0x34'):var _0x1efffe=moment(_0x26d45e,'YYYY-MM-DD\x20HH:mm:ss',!![]);if(_0x1efffe[_0x01f2('0x73')]()){_0x4b5d63[_0x01f2('0x1c')]('\x22'+_0x26d45e+'\x22');}else{_0x5f2146[_0x01f2('0x1c')](_0x01f2('0x74'));}break;case _0x01f2('0x75'):var _0x3dfd32=parseInt(_0x26d45e);_0x26d45e=_[_0x01f2('0x76')](_0x3dfd32)||_0x3dfd32<0x0||_0x3dfd32>0x4?_0x49c141?0x3:0x2:_0x3dfd32;_0x4b5d63[_0x01f2('0x1c')]('\x22'+_0x26d45e+'\x22');break;case _0x01f2('0x38'):var _0x5b6075=parseInt(_0x26d45e);if(_[_0x01f2('0x77')](_0x5b6075)&&_[_0x01f2('0x78')](_0x482b24,_0x5b6075)){_0x4b5d63[_0x01f2('0x1c')]('\x22'+_0x5b6075+'\x22');}else{_0x5f2146[_0x01f2('0x1c')](_0x01f2('0x79'));}break;case _0x01f2('0x7a'):if(isEmail(_0x26d45e)){_0x4b5d63[_0x01f2('0x1c')]('\x22'+_0x26d45e+'\x22');}else{_0x5f2146[_0x01f2('0x1c')](_0x01f2('0x7b'));}break;case _0x01f2('0x7c'):var _0x476f5=moment(_0x26d45e,_0x01f2('0x7d'),!![]);if(_0x476f5[_0x01f2('0x73')]()){_0x4b5d63[_0x01f2('0x1c')]('\x22'+_0x26d45e+'\x22');}else{_0x5f2146[_0x01f2('0x1c')](_0x01f2('0x7e'));}break;default:_0x4b5d63[_0x01f2('0x1c')]('\x22'+_0x26d45e+'\x22');}}else{switch(_0x368119){case _0x01f2('0x7f'):case _0x01f2('0x1a'):_0x5f2146[_0x01f2('0x1c')](_0x368119+_0x01f2('0x80'));break;default:_0x4b5d63[_0x01f2('0x1c')]('\x22\x22');}}}}else{var _0x1eeda6='';if(!_[_0x01f2('0x19')](_0x28904b)){if(!_0x4d85d7[_0x01f2('0x81')](_0x28904b['id'])){for(var _0x354aac=0x0;_0x354aac<_0x192824[_0x368119][_0x01f2('0x22')];_0x354aac++){var _0x26d45e=_[_0x01f2('0x71')](_0x39f95a[_0x01f2('0x6f')][_0x6504eb][_0x192824[_0x368119][_0x354aac]]['replace'](/"/g,'\x27'));var _0xf25a55=phoneDescriptions[_0x01f2('0x70')](_0x1b438f=>_0x1b438f[_0x01f2('0x82')]===_0x28904b['id']);if(!_[_0x01f2('0x19')](_0xf25a55)){var _0x112255=_[_0x01f2('0x71')](_0x39f95a[_0x01f2('0x6f')][_0x6504eb][_0x192824[_0xf25a55[_0x01f2('0x83')]][0x0]]['replace'](/"/g,'\x27'));if(!_[_0x01f2('0x19')](_0x112255))_0x26d45e=_0x26d45e+'§'+_0x112255;}if(_0x1eeda6=='')_0x1eeda6=_0x26d45e;else _0x1eeda6+='|'+_0x26d45e;}_0x2ff28d[_0x01f2('0x1c')](_0x28904b['id']+':'+_0x1eeda6);_0x4d85d7[_0x28904b['id']]=0x1;}}}}if(hasAdditionalPhones){_0x4b5d63['push']('\x22'+_0x2ff28d[_0x01f2('0x12')](';')+'\x22');}if(_0x5f2146[_0x01f2('0x22')]){handleError(_0x39f95a[_0x01f2('0x6f')][_0x6504eb],{'code':_0x01f2('0x84'),'message':_0x5f2146[_0x01f2('0x12')]()});}else{fs[_0x01f2('0x85')](_0x365eb1,_0x4b5d63[_0x01f2('0x12')]()+'\x0a');}_0x4b5d63=[];}if(!(stats['rows']%0xc8)){socket['emit'](_0x01f2('0x86')+_0x368539,stats);stats[_0x01f2('0x5c')]=[];}}if(stopped){logger[_0x01f2('0x58')](_0x01f2('0x87'));_0x308402[_0x01f2('0x88')]();}}catch(_0x22f1ec){handleError(_0x39f95a[_0x01f2('0x6f')][_0x6504eb],{'code':_0x01f2('0x89'),'message':_0x22f1ec[_0x01f2('0x5a')]});logger[_0x01f2('0x20')](_0x01f2('0x8a'),_0x22f1ec['message']);}},'complete':function(){try{var _0x57c67d=[];var _0x5a5932=tempTableName;_0x57c67d[_0x01f2('0x1c')](_0x01f2('0x8b')+_0x5a5932+'\x20LIKE\x20cm_contacts;');logger[_0x01f2('0x58')]('CIS\x20len',contactItemTypes[_0x01f2('0x22')]);var _0x26e30e=util[_0x01f2('0xb')](_0x01f2('0x8c'),_0x365eb1,_0x5a5932,_0x2d14df,_0x20d8ae[_0x01f2('0x36')],_0x20d8ae[_0x01f2('0x52')]||null,NOW,NOW);if(_[_0x01f2('0x19')](_0x192824[_0x01f2('0x34')])){_0x26e30e+=_0x01f2('0x8d');}_0x57c67d['push'](_0x26e30e);BPromise[_0x01f2('0x8e')](_0x57c67d,handleQuery)[_0x01f2('0x1e')](function(_0x284a73){BPromise[_0x01f2('0x1d')]([handleAdditionalPhones()])[_0x01f2('0x1e')](function(){_0x57c67d=[];for(var _0x496fc7=0x0;_0x496fc7<promisesContact[_0x01f2('0x22')];_0x496fc7++){_0x57c67d[_0x01f2('0x1c')](updateContact(promisesContact[_0x496fc7]['contact']));}BPromise[_0x01f2('0x1d')](_0x57c67d)['then'](function(){_0x57c67d=[];for(var _0x330a6f=0x0;_0x330a6f<promisesAdditionalPhones[_0x01f2('0x22')];_0x330a6f++){_0x57c67d[_0x01f2('0x1c')](createAdditionalPhone(promisesAdditionalPhones[_0x330a6f][_0x01f2('0x8f')],promisesAdditionalPhones[_0x330a6f][_0x01f2('0x90')],promisesAdditionalPhones[_0x330a6f][_0x01f2('0x1a')],promisesAdditionalPhones[_0x330a6f][_0x01f2('0x91')]));}BPromise[_0x01f2('0x1d')](_0x57c67d)['then'](function(){_0x57c67d=[];_0x57c67d[_0x01f2('0x1c')](insertCmHopperAdditionalPhones(_0x20d8ae[_0x01f2('0x36')]));_0x57c67d[_0x01f2('0x1c')]('DROP\x20TABLE\x20'+_0x5a5932+';');BPromise[_0x01f2('0x8e')](_0x57c67d,handleQuery)[_0x01f2('0x1e')](function(_0x4a21e3){stats[_0x01f2('0x92')]=!![];stats[_0x01f2('0x93')]=updatedRows;socket[_0x01f2('0x94')]('contact:import:'+_0x368539,stats);fs['unlink'](_0x7ccd04);fs[_0x01f2('0x95')](_0x365eb1);process[_0x01f2('0x5b')](0x0);})[_0x01f2('0x1f')](function(_0x17f6b3){logger[_0x01f2('0x20')](_0x17f6b3[_0x01f2('0x5a')]);process[_0x01f2('0x5b')](0x1);});});});});})['catch'](function(_0x248f97){logger[_0x01f2('0x20')](_0x248f97[_0x01f2('0x5a')]);process[_0x01f2('0x5b')](0x1);});}catch(_0x546034){logger[_0x01f2('0x20')](_0x01f2('0x96'),_0x546034[_0x01f2('0x5a')]);process[_0x01f2('0x5b')](0x1);}},'error':function(_0x5df081,_0x3f3a9b,_0x524d48,_0x2a96f8){throw new Error(_0x2a96f8);}});});}function validate(){if(process[_0x01f2('0x97')]&&process[_0x01f2('0x97')][_0x01f2('0x22')]<0x4){throw new Error(_0x01f2('0x98'));}var _0x3829b2=path[_0x01f2('0x12')](config[_0x01f2('0x64')],_0x01f2('0x65'),process['argv'][0x2]);if(!fs[_0x01f2('0x99')](_0x3829b2)){throw new Error(_0x01f2('0x9a'));}var _0x48efc9={};try{_0x48efc9=JSON[_0x01f2('0x6c')](process[_0x01f2('0x97')][0x3]);if(!_0x48efc9[_0x01f2('0x61')]){throw new Error(_0x01f2('0x9b'));}var _0x44a3fa=0x0;if(_0x48efc9[_0x01f2('0x61')]['UserId']){_0x44a3fa=0x1;}if(!_0x48efc9[_0x01f2('0x36')]){throw new Error('ListId\x20is\x20mandatory');}}catch(_0x3b683d){throw new Error(_0x01f2('0x9c'));}var _0x42cf36=[];try{_0x42cf36=_[_0x01f2('0x9d')](JSON['parse'](process[_0x01f2('0x97')][0x4]),'id');}catch(_0x294f92){logger[_0x01f2('0x58')]('No\x20agent\x20available');}main(_0x3829b2,_0x48efc9,_0x42cf36,_0x44a3fa);}validate();process['on'](_0x01f2('0x9e'),handleStop);process['on'](_0x01f2('0x9f'),handleUncaughtException);
git://repos.xcallymotion.com / motion2.git / blob