// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x8d0a=['binding\x20doesn\x27t\x20exists','phone\x20is\x20mandatory','firstName\x20is\x20mandatory','ListId\x20is\x20mandatory','No\x20agent\x20available','uncaughtException','path','lodash','papaparse','bluebird','moment','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','import','redis','defaults','localhost','socket.io-emitter','format','YYYY-MM-DD\x20HH:mm:ss','test','select','from','join','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','CmContact','findAll','AdditionalPhones','then','length','push','all','split','isNil','findOne','updated','CmContactHasItem','create','PHONE','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','insert','into','phone','scheduledat','ContactId','ListId','createdAt','updatedAt','UserId','recallme','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','\x22onlyIfOpen\x22','cm_hopper','toString','cm_contacts.phone','cm_contacts.ListId','cm_contacts.createdAt','cm_hopper_black','fromQuery','field','ListId\x20=\x20?','date_add(cm_contacts.scheduledat,interval\x20','.offset-cm_contacts.utcOffset\x20minute)','priority','fields','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','CmHopperId','cm_contact_has_items','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','deletedAt\x20IS\x20NULL','id\x20IN\x20?','min_id','group','info','Received\x20SIGINT','message','exit','query','spread','catch','campaigns.id','campaigns.dialTimezone','campaigns.id\x20=\x20campaigns_has_cm_lists.CampaignId','campaigns_has_cm_lists.CmListId=','sequelize','error','voice_queues.id','voice_queues.dialTimezone','voice_queues','voice_queues_has_cm_lists','voice_queues.id\x20=\x20voice_queues_has_cm_lists.VoiceQueueId','voice_queues_has_cm_lists.CmListId=','timezones','dialTimezone','utcOffset','set','send','start','binding','clone','socket_timestamp','root','server/files/tmp','.csv','header','ContactItemType','name','writeFileSync','parse','createReadStream','data','rows','errors','find','_description','trim','replace','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNumber','includes','agent\x20not\x20exists','email','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','isValid','firstName','\x20not\x20specified','hasOwnProperty','itemTypeId','description','SystemRow','appendFileSync','emit','SystemError','step','duplicates','cm_contacts_','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','campaigns_','(id\x20int,dialTimezone\x20varchar(255),offset\x20int);','each','LOAD\x20DATA\x20LOCAL\x20INFILE\x20\x27%s\x27\x20INTO\x20TABLE\x20%s\x20CHARACTER\x20SET\x20UTF8\x20FIELDS\x20TERMINATED\x20BY\x20\x27,\x27\x20ENCLOSED\x20BY\x20\x27\x22\x27\x20LINES\x20TERMINATED\x20BY\x20\x27\x0a\x27\x20IGNORE\x201\x20ROWS\x20(%s)\x20SET\x20id\x20=\x20NULL,\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27','CompanyId',',\x20scheduledAt\x20=\x20NOW()','orderBy','VoiceQueueId','voice_queues_has_cm_blacklists','campaigns_has_cm_lists','campaigns','CampaignId','campaigns_has_cm_blacklists','DROP\x20TABLE\x20','finish','affectedRows','contact:import:','unlink','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists'];(function(_0x4dd479,_0x26d87a){var _0x1b6807=function(_0x2bec19){while(--_0x2bec19){_0x4dd479['push'](_0x4dd479['shift']());}};_0x1b6807(++_0x26d87a);}(_0x8d0a,0x172));var _0xa8d0=function(_0x12c3a9,_0x1b9a16){_0x12c3a9=_0x12c3a9-0x0;var _0x91d06=_0x8d0a[_0x12c3a9];return _0x91d06;};'use strict';var fs=require('fs');var path=require(_0xa8d0('0x0'));var _=require(_0xa8d0('0x1'));var Papa=require(_0xa8d0('0x2'));var util=require('util');var BPromise=require(_0xa8d0('0x3'));var moment=require(_0xa8d0('0x4'));var squel=require('squel');var Redis=require(_0xa8d0('0x5'));var db=require(_0xa8d0('0x6'))['db'];var config=require(_0xa8d0('0x7'));var shared=require('../../../config/environment/shared');var logger=require(_0xa8d0('0x8'))(_0xa8d0('0x9'));config[_0xa8d0('0xa')]=_[_0xa8d0('0xb')](config[_0xa8d0('0xa')],{'host':_0xa8d0('0xc'),'port':0x18eb});var socket=require(_0xa8d0('0xd'))(new Redis(config[_0xa8d0('0xa')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()[_0xa8d0('0xe')](_0xa8d0('0xf'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];var tmp_voice_queues;var tmp_campaigns;var tzOffset=0x0;var hasTZ;var NOW=moment()[_0xa8d0('0xe')](_0xa8d0('0xf'));function isEmail(_0x3c1221){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))*$/[_0xa8d0('0x10')](_0x3c1221);}function selectNotIn(_0x3a1138,_0xe516eb,_0x2c34df,_0x1e15f8,_0x380cc5){return squel[_0xa8d0('0x11')]()['field']('phone')[_0xa8d0('0x12')](_0x1e15f8)[_0xa8d0('0x13')](_0xe516eb,null,_0xe516eb+'.id\x20=\x20'+_0x1e15f8+'.'+_0x2c34df)['where'](_0x1e15f8+'.'+_0x2c34df+_0xa8d0('0x14')+_0x3a1138+'.'+_0x2c34df)[_0xa8d0('0x15')](_0xe516eb+_0xa8d0('0x16')+_0x380cc5[_0xa8d0('0x13')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x2ebddf,_0x18f935){promisesAdditionalPhones=[];return db[_0xa8d0('0x17')][_0xa8d0('0x18')]({'raw':!![],'attributes':['id',_0xa8d0('0x19')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})[_0xa8d0('0x1a')](function(_0xfa19ee){if(_0xfa19ee!==null){var _0x575f69=[];for(var _0x728809=0x0;_0x728809<_0xfa19ee[_0xa8d0('0x1b')];_0x728809++){var _0x4dd4b0=_0xfa19ee[_0x728809];_0x575f69[_0xa8d0('0x1c')](insertAdditionalPhones(_0x4dd4b0));}}Promise[_0xa8d0('0x1d')](_0x575f69)[_0xa8d0('0x1a')](function(){_0x2ebddf({'val':0x1});});});});}function insertAdditionalPhones(_0x434ad5){return new Promise(function(_0x34ce5d,_0x48e8c5){var _0x35554e=_0x434ad5[_0xa8d0('0x19')];var _0x213de2=_0x35554e[_0xa8d0('0x1e')](';');var _0x1b5dfb=[];orderBy=0x0;for(var _0x16e479=0x0;_0x16e479<_0x213de2[_0xa8d0('0x1b')];_0x16e479++){_0x1b5dfb['push'](splitAdditionalPhone(_0x434ad5['id'],_0x213de2[_0x16e479]));}Promise[_0xa8d0('0x1d')](_0x1b5dfb)[_0xa8d0('0x1a')](function(){_0x34ce5d({'val':_0x213de2[_0xa8d0('0x1b')]});});});}function splitAdditionalPhone(_0x3ceb45,_0x4b003f){return new Promise(function(_0x31cf4f,_0x31216e){var _0x3212a3=_0x4b003f[_0xa8d0('0x1e')](':');var _0x4d6005=_0x3212a3[0x0];var _0x150080=_0x3212a3[0x1];if(!_[_0xa8d0('0x1f')](_0x150080)){var _0x20ae2c=_0x150080[_0xa8d0('0x1e')]('|');var _0x55e6e0=[];for(var _0x35b4a6=0x0;_0x35b4a6<_0x20ae2c[_0xa8d0('0x1b')];_0x35b4a6++){if(_0x20ae2c[_0x35b4a6]!==''){var _0x434252=_['filter'](promisesAdditionalPhones,{'contactId':_0x3ceb45,'phone':_0x20ae2c[_0x35b4a6]});if(_0x434252[_0xa8d0('0x1b')]==0x0){orderBy++;promisesAdditionalPhones['push']({'contactId':_0x3ceb45,'contactTypeId':_0x4d6005,'phone':_0x20ae2c[_0x35b4a6],'orderBy':orderBy});}}}_0x31cf4f({'ok':0x1});}else _0x31cf4f({'res':0x0});});}function createAdditionalPhone(_0x3efa4e,_0x291e8e,_0x548076,_0x5d7292){var _0x216045='';var _0x5d9a04='';var _0x312a29=_0x548076[_0xa8d0('0x1e')]('§');_0x216045=_0x312a29[0x0];if(_0x312a29[_0xa8d0('0x1b')]==0x2)_0x5d9a04=_0x312a29[0x1];return new Promise(function(_0x460fae,_0x3ceaa9){return db['CmContactHasItem'][_0xa8d0('0x20')]({'where':{'CmContactId':_0x3efa4e,'item':_0x216045}})[_0xa8d0('0x1a')](function(_0x13de71){if(_0x13de71){return db['CmContactHasItem']['update']({'ItemTypeId':_0x291e8e,'description':_0x5d9a04,'OrderBy':_0x5d7292},{'where':{'CmContactId':_0x3efa4e,'item':_0x216045}})['then'](function(_0x472982){_0x460fae({'res':_0xa8d0('0x21')});});}else{return db[_0xa8d0('0x22')][_0xa8d0('0x23')]({'CmContactId':_0x3efa4e,'item':_0x216045,'description':_0x5d9a04,'ItemTypeId':_0x291e8e,'OrderBy':_0x5d7292,'ItemClass':_0xa8d0('0x24')})[_0xa8d0('0x1a')](function(_0x3f6fb9){_0x460fae({'res':'inserted'});});}});});}function insertCmHopper(_0x1fa36f,_0x58ff81,_0x454a82,_0x538e51,_0x4ea42b){var _0x54bc61=['cm_contacts.phone',_0xa8d0('0x25'),_0xa8d0('0x26'),'cm_contacts.ListId',_0x58ff81+'.'+_0x538e51,'cm_contacts.createdAt',_0xa8d0('0x27'),_0xa8d0('0x28'),_0xa8d0('0x29'),'\x22'+_0x4ea42b+'\x22'];return squel[_0xa8d0('0x2a')]()[_0xa8d0('0x2b')]('cm_hopper')['fromQuery']([_0xa8d0('0x2c'),_0xa8d0('0x2d'),_0xa8d0('0x2e'),_0xa8d0('0x2f'),_0x538e51,_0xa8d0('0x30'),_0xa8d0('0x31'),'priority',_0xa8d0('0x32'),_0xa8d0('0x33')],squel[_0xa8d0('0x11')]()['fields'](_0x54bc61)[_0xa8d0('0x12')](_0x58ff81)[_0xa8d0('0x13')](_0xa8d0('0x34'),null,_0xa8d0('0x35')+_0x58ff81+_0xa8d0('0x36'))[_0xa8d0('0x13')](_0x454a82,null,_0x454a82+_0xa8d0('0x37')+_0x58ff81+'.'+_0x538e51)[_0xa8d0('0x15')](_0x58ff81+_0xa8d0('0x38'),_0x1fa36f)[_0xa8d0('0x15')](_0xa8d0('0x39'),NOW)['where'](_0xa8d0('0x3a'),selectNotIn(_0x58ff81,_0x454a82,_0x538e51,'cm_hopper',[_0xa8d0('0x3b'),_0xa8d0('0x3c')]))[_0xa8d0('0x15')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x58ff81,_0x454a82,_0x538e51,_0xa8d0('0x3d'),[_0xa8d0('0x3b')])))[_0xa8d0('0x3e')]();}function insertCmHopperBlack(_0x4ab119,_0x26524f,_0x3c8d89,_0xcaf615){var _0x3c3080=[_0xa8d0('0x3f'),_0xa8d0('0x26'),_0xa8d0('0x40'),_0x26524f+'.'+_0xcaf615,_0xa8d0('0x41'),_0xa8d0('0x27')];return squel['insert']()[_0xa8d0('0x2b')](_0xa8d0('0x42'))[_0xa8d0('0x43')]([_0xa8d0('0x2c'),_0xa8d0('0x2e'),_0xa8d0('0x2f'),_0xcaf615,_0xa8d0('0x30'),_0xa8d0('0x31')],squel[_0xa8d0('0x11')]()['fields'](_0x3c3080)[_0xa8d0('0x12')](_0x26524f)['join'](_0xa8d0('0x34'),null,_0xa8d0('0x35')+_0x26524f+'.CmListId')[_0xa8d0('0x13')](_0x3c8d89,null,_0x3c8d89+'.id\x20=\x20'+_0x26524f+'.'+_0xcaf615)[_0xa8d0('0x15')](_0x26524f+_0xa8d0('0x38'),_0x4ab119)[_0xa8d0('0x15')]('cm_contacts.createdAt\x20=\x20?',NOW)['where'](_0xa8d0('0x3a'),squel[_0xa8d0('0x11')]()[_0xa8d0('0x44')](_0xa8d0('0x2c'))[_0xa8d0('0x12')](_0xa8d0('0x42'))[_0xa8d0('0x15')](_0xa8d0('0x45'),_0x4ab119)['where'](_0xcaf615+_0xa8d0('0x14')+_0x26524f+'.'+_0xcaf615)))['toString']();}function insertTzCmHopper(_0x21724b,_0x5b34a1,_0x1b48a9,_0x44df67,_0x3b48f2,_0x58d820){var _0x384cee=[_0xa8d0('0x3f'),_0xa8d0('0x46')+_0x58d820+_0xa8d0('0x47'),_0xa8d0('0x26'),_0xa8d0('0x40'),_0x5b34a1+'.'+_0x44df67,_0xa8d0('0x41'),_0xa8d0('0x27'),_0xa8d0('0x28'),_0xa8d0('0x29'),'\x22'+_0x3b48f2+'\x22'];var _0x39f402=squel[_0xa8d0('0x2a')]()[_0xa8d0('0x2b')](_0xa8d0('0x3d'))[_0xa8d0('0x43')](['phone','scheduledat',_0xa8d0('0x2e'),_0xa8d0('0x2f'),_0x44df67,_0xa8d0('0x30'),_0xa8d0('0x31'),_0xa8d0('0x48'),_0xa8d0('0x32'),_0xa8d0('0x33')],squel[_0xa8d0('0x11')]()[_0xa8d0('0x49')](_0x384cee)[_0xa8d0('0x12')](_0x5b34a1)[_0xa8d0('0x13')](_0xa8d0('0x34'),null,_0xa8d0('0x35')+_0x5b34a1+'.CmListId')[_0xa8d0('0x13')](_0x1b48a9,null,_0x1b48a9+_0xa8d0('0x37')+_0x5b34a1+'.'+_0x44df67)[_0xa8d0('0x13')](_0x58d820,null,_0x58d820+'.id\x20=\x20'+_0x5b34a1+'.'+_0x44df67)[_0xa8d0('0x15')](_0x5b34a1+_0xa8d0('0x38'),_0x21724b)[_0xa8d0('0x15')](_0xa8d0('0x39'),NOW)[_0xa8d0('0x15')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x5b34a1,_0x1b48a9,_0x44df67,'cm_hopper',[_0xa8d0('0x3b'),_0xa8d0('0x3c')]))[_0xa8d0('0x15')](_0xa8d0('0x3a'),selectNotIn(_0x5b34a1,_0x1b48a9,_0x44df67,_0xa8d0('0x3d'),[_0xa8d0('0x3b')])))[_0xa8d0('0x3e')]();return _0x39f402;}function insertTzCmHopperBlack(_0x15e8d9,_0x39e84b,_0x495758,_0x30dc28){var _0x184fbd=[_0xa8d0('0x3f'),_0xa8d0('0x26'),_0xa8d0('0x40'),_0x39e84b+'.'+_0x30dc28,'cm_contacts.createdAt',_0xa8d0('0x27')];return squel['insert']()[_0xa8d0('0x2b')]('cm_hopper_black')[_0xa8d0('0x43')](['phone','ContactId',_0xa8d0('0x2f'),_0x30dc28,_0xa8d0('0x30'),_0xa8d0('0x31')],squel['select']()[_0xa8d0('0x49')](_0x184fbd)['from'](_0x39e84b)['join'](_0xa8d0('0x34'),null,_0xa8d0('0x35')+_0x39e84b+_0xa8d0('0x36'))['join'](_0x495758,null,_0x495758+'.id\x20=\x20'+_0x39e84b+'.'+_0x30dc28)[_0xa8d0('0x15')](_0x39e84b+_0xa8d0('0x38'),_0x15e8d9)[_0xa8d0('0x15')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0xa8d0('0x15')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel[_0xa8d0('0x11')]()[_0xa8d0('0x44')](_0xa8d0('0x2c'))['from'](_0xa8d0('0x42'))[_0xa8d0('0x15')](_0xa8d0('0x45'),_0x15e8d9)['where'](_0x30dc28+'\x20=\x20'+_0x39e84b+'.'+_0x30dc28)))[_0xa8d0('0x3e')]();}function insertCmHopperAdditionalPhones(_0x19d7be){var _0x5173dd=['cm_hopper.id',_0xa8d0('0x4a'),_0xa8d0('0x4b'),_0xa8d0('0x4c'),'cm_contact_has_items.updatedAt'];return squel['insert']()[_0xa8d0('0x2b')]('cm_hopper_additional_phones')[_0xa8d0('0x43')]([_0xa8d0('0x4d'),'phone','OrderBy','createdAt',_0xa8d0('0x31')],squel['select']()[_0xa8d0('0x49')](_0x5173dd)[_0xa8d0('0x12')](_0xa8d0('0x3d'))['join']('cm_contacts',null,'cm_contacts.id\x20=\x20cm_hopper.ContactId')[_0xa8d0('0x13')](_0xa8d0('0x4e'),null,_0xa8d0('0x4f'))[_0xa8d0('0x15')](_0xa8d0('0x50'),_0x19d7be)['where'](_0xa8d0('0x39'),NOW))['toString']();}function insertCmContact(_0x217995,_0x4812cc,_0x130ba2,_0x4fdc81){var _0x16b690=_[_0xa8d0('0x51')](_[_0xa8d0('0x52')](_0x4fdc81),[_0xa8d0('0x2f'),'CompanyId',_0xa8d0('0x30'),_0xa8d0('0x31')]);return squel['insert']()[_0xa8d0('0x2b')](_0xa8d0('0x34'))['fromQuery'](_0x16b690,squel[_0xa8d0('0x11')]()[_0xa8d0('0x49')](_0x16b690)[_0xa8d0('0x12')](_0x4812cc)[_0xa8d0('0x15')]('('+_0x130ba2['join'](',')+')\x20NOT\x20IN\x20?',squel[_0xa8d0('0x11')]()[_0xa8d0('0x49')](_0x130ba2)[_0xa8d0('0x12')](_0xa8d0('0x34'))[_0xa8d0('0x15')]('ListId\x20=\x20?',_0x217995)[_0xa8d0('0x15')](_0xa8d0('0x53')))[_0xa8d0('0x15')](_0xa8d0('0x54'),squel[_0xa8d0('0x11')]()[_0xa8d0('0x44')]('MIN(id)',_0xa8d0('0x55'))[_0xa8d0('0x12')](_0x4812cc)[_0xa8d0('0x56')](_0x130ba2['join'](','))))[_0xa8d0('0x3e')]();}function handleStop(){logger[_0xa8d0('0x57')](_0xa8d0('0x58'));stopped=!![];}function handleUncaughtException(_0x58da3b){logger['error'](_0x58da3b[_0xa8d0('0x59')]);process[_0xa8d0('0x5a')](0x1);}function handleError(_0x5dc214,_0xef6c6d){stats['errors']['push']({'name':_0xef6c6d['code'],'message':_0xef6c6d[_0xa8d0('0x59')],'row':_0x5dc214});}function handleQuery(_0x3e2e94){logger[_0xa8d0('0x57')](_0x3e2e94);return db['sequelize'][_0xa8d0('0x5b')](_0x3e2e94)[_0xa8d0('0x5c')](function(_0x176f02){results[_0xa8d0('0x1c')](_0x176f02);})[_0xa8d0('0x5d')](function(_0x717ea5){logger['error'](_0x717ea5[_0xa8d0('0x59')]);});}function updateTzCampaigns(_0x404e95){return new Promise(function(_0x2ca430,_0x2d9518){var _0x134ee7=squel[_0xa8d0('0x11')]()[_0xa8d0('0x49')]([_0xa8d0('0x5e'),_0xa8d0('0x5f')])[_0xa8d0('0x12')]('campaigns')[_0xa8d0('0x13')]('campaigns_has_cm_lists',null,_0xa8d0('0x60'))['where'](_0xa8d0('0x61')+_0x404e95);db[_0xa8d0('0x62')][_0xa8d0('0x5b')](_0x134ee7[_0xa8d0('0x3e')]())[_0xa8d0('0x5c')](function(_0x17a710){var _0x1472f9=[];for(var _0x11bc8f=0x0;_0x11bc8f<_0x17a710[_0xa8d0('0x1b')];_0x11bc8f++){_0x1472f9[_0xa8d0('0x1c')](getTimezoneData(_0x17a710[_0x11bc8f],tmp_campaigns));}BPromise['all'](_0x1472f9)[_0xa8d0('0x1a')](function(){_0x2ca430({'val':0x1});});})[_0xa8d0('0x5d')](function(_0x221659){logger[_0xa8d0('0x63')](_0x221659['message']);_0x2ca430({'val':0x0});});});}function updateTzVoiceQueues(_0x28ad5d){return new Promise(function(_0x606740,_0x27b539){var _0x258800=squel[_0xa8d0('0x11')]()['fields']([_0xa8d0('0x64'),_0xa8d0('0x65')])[_0xa8d0('0x12')](_0xa8d0('0x66'))[_0xa8d0('0x13')](_0xa8d0('0x67'),null,_0xa8d0('0x68'))['where'](_0xa8d0('0x69')+_0x28ad5d);db['sequelize']['query'](_0x258800[_0xa8d0('0x3e')]())[_0xa8d0('0x5c')](function(_0x307b5c){var _0x5937ee=[];for(var _0xe27834=0x0;_0xe27834<_0x307b5c[_0xa8d0('0x1b')];_0xe27834++){_0x5937ee['push'](getTimezoneData(_0x307b5c[_0xe27834],tmp_voice_queues));}BPromise[_0xa8d0('0x1d')](_0x5937ee)[_0xa8d0('0x1a')](function(){_0x606740({'val':0x1});});})['catch'](function(_0x26ab4c){logger[_0xa8d0('0x63')](_0x26ab4c[_0xa8d0('0x59')]);_0x606740({'val':0x0});});});}function getTimezoneData(_0x12ff4a,_0x5b0b4e){return new Promise(function(_0x3c70fb,_0x297fa4){var _0x1346f3=shared[_0xa8d0('0x6a')];var _0x405af2=_0x1346f3[_0x12ff4a[_0xa8d0('0x6b')]];if(_['isNil'](_0x405af2)){_0x3c70fb({'ret':0x1});}else{var _0x34689e=_0x405af2[_0xa8d0('0x6c')];var _0x3a4d89=squel[_0xa8d0('0x2a')]()[_0xa8d0('0x2b')](_0x5b0b4e)['set']('id',_0x12ff4a['id'])[_0xa8d0('0x6d')]('offset',_0x34689e)[_0xa8d0('0x6d')](_0xa8d0('0x6b'),_0x12ff4a[_0xa8d0('0x6b')])[_0xa8d0('0x3e')]();return db['sequelize'][_0xa8d0('0x5b')](_0x3a4d89)[_0xa8d0('0x5c')](function(_0x55dba2){_0x3c70fb({'ret':0x1});})['catch'](function(_0x4d53f8){logger[_0xa8d0('0x63')](_0x4d53f8[_0xa8d0('0x59')]);_0x297fa4({'ret':0x1});});}});}function handleTZQuery(_0x18cddc){logger[_0xa8d0('0x57')](_0x18cddc);return db[_0xa8d0('0x62')][_0xa8d0('0x5b')](_0x18cddc)[_0xa8d0('0x5c')](function(_0x5d0313){})[_0xa8d0('0x5d')](function(_0x47f818){logger[_0xa8d0('0x63')](_0x47f818['message']);});}function main(_0x4fb62f,_0x24565a,_0x506edd,_0xf7f94b){logger[_0xa8d0('0x57')]('main',_0x4fb62f,JSON['stringify'](_0x24565a));process[_0xa8d0('0x6e')](_0xa8d0('0x6f'));var _0x116ca5=_0x24565a[_0xa8d0('0x70')];var _0x44fe03=_[_0xa8d0('0x71')](_0x116ca5);var _0x4529a3=_0x24565a[_0xa8d0('0x72')];var _0x30a66d=path[_0xa8d0('0x13')](config[_0xa8d0('0x73')],_0xa8d0('0x74'),_0x4529a3+_0xa8d0('0x75'));hasTZ=_[_0xa8d0('0x52')](_0x116ca5)['includes'](_0xa8d0('0x6b'));var _0x54a61b=_[_0xa8d0('0x52')](_0x116ca5)[_0xa8d0('0x13')]();logger[_0xa8d0('0x57')](_0xa8d0('0x76'),_0x54a61b);db[_0xa8d0('0x77')][_0xa8d0('0x18')]({'raw':!![],'attributes':['id',_0xa8d0('0x78')]})[_0xa8d0('0x1a')](function(_0x43faf1){for(var _0x3affc5=0x0;_0x3affc5<_0x43faf1[_0xa8d0('0x1b')];_0x3affc5++){if(_0x43faf1[_0x3affc5][_0xa8d0('0x78')]in _0x116ca5){contactItemTypes['push'](_0x43faf1[_0x3affc5]);delete _0x44fe03[_0x43faf1[_0x3affc5]['name']];hasAdditionalPhones=!![];}for(var _0x49d3b3 in _0x116ca5){if(_0x43faf1[_0x3affc5][_0xa8d0('0x78')]+'_description'===_0x49d3b3){phoneDescriptions[_0xa8d0('0x1c')]({'itemTypeId':_0x43faf1[_0x3affc5]['id'],'description':_0x49d3b3});delete _0x44fe03[_0x49d3b3];}}}if(hasAdditionalPhones)_0x44fe03[_0xa8d0('0x19')]='';var _0x5c0685=_[_0xa8d0('0x52')](_0x44fe03)['join']();logger[_0xa8d0('0x57')]('header',_0x5c0685);fs[_0xa8d0('0x79')](_0x30a66d,_0x5c0685+'\x0a');Papa[_0xa8d0('0x7a')](fs[_0xa8d0('0x7b')](_0x4fb62f),{'header':!![],'skipEmptyLines':!![],'step':function(_0x2a810b,_0x20c674){try{for(var _0x16aae4=0x0,_0x1178d9=[];_0x16aae4<_0x2a810b[_0xa8d0('0x7c')][_0xa8d0('0x1b')];_0x16aae4++){stats[_0xa8d0('0x7d')]+=0x1;if(_0x2a810b[_0xa8d0('0x7e')][_0x16aae4]){handleError(_0x2a810b[_0xa8d0('0x7c')][_0x16aae4],_0x2a810b[_0xa8d0('0x7e')][_0x16aae4]);}else{var _0x4a3adf=[];var _0x525392=[];var _0x2cec05={};for(var _0x37bc4c in _0x116ca5){let _0x12945c=contactItemTypes['find'](_0x383b39=>_0x383b39['name']===_0x37bc4c);let _0x544f14=contactItemTypes[_0xa8d0('0x7f')](_0x2d35f4=>_0x2d35f4[_0xa8d0('0x78')]+_0xa8d0('0x80')===_0x37bc4c);if(_['isNil'](_0x12945c)&&_[_0xa8d0('0x1f')](_0x544f14)){if(_0x116ca5['hasOwnProperty'](_0x37bc4c)){if(_0x2a810b['data'][_0x16aae4][_0x116ca5[_0x37bc4c]]){var _0x17bfec=_[_0xa8d0('0x81')](_0x2a810b['data'][_0x16aae4][_0x116ca5[_0x37bc4c]][_0xa8d0('0x82')](/"/g,'\x27'));switch(_0x37bc4c){case _0xa8d0('0x2d'):var _0x3b124a=moment(_0x17bfec,_0xa8d0('0xf'),!![]);if(_0x3b124a['isValid']()){_0x1178d9[_0xa8d0('0x1c')]('\x22'+_0x17bfec+'\x22');}else{_0x4a3adf[_0xa8d0('0x1c')](_0xa8d0('0x83'));}break;case'priority':var _0x37f370=parseInt(_0x17bfec);_0x17bfec=_['isNaN'](_0x37f370)||_0x37f370<0x0||_0x37f370>0x4?_0xf7f94b?0x3:0x2:_0x37f370;_0x1178d9[_0xa8d0('0x1c')]('\x22'+_0x17bfec+'\x22');break;case _0xa8d0('0x32'):var _0x209837=parseInt(_0x17bfec);if(_[_0xa8d0('0x84')](_0x209837)&&_[_0xa8d0('0x85')](_0x506edd,_0x209837)){_0x1178d9[_0xa8d0('0x1c')]('\x22'+_0x209837+'\x22');}else{_0x4a3adf[_0xa8d0('0x1c')](_0xa8d0('0x86'));}break;case _0xa8d0('0x87'):if(isEmail(_0x17bfec)){_0x1178d9[_0xa8d0('0x1c')]('\x22'+_0x17bfec+'\x22');}else{_0x4a3adf[_0xa8d0('0x1c')](_0xa8d0('0x88'));}break;case _0xa8d0('0x89'):var _0xa196f3=moment(_0x17bfec,_0xa8d0('0x8a'),!![]);if(_0xa196f3[_0xa8d0('0x8b')]()){_0x1178d9['push']('\x22'+_0x17bfec+'\x22');}else{_0x4a3adf[_0xa8d0('0x1c')]('dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)');}break;case'dialTimezone':var _0x1d9cba=shared['timezones'];var _0x19db7d=_0x1d9cba[_0x17bfec];if(!_[_0xa8d0('0x1f')](_0x19db7d)){var _0x2d6e4e=_0x19db7d['utcOffset'];_0x1178d9['push']('\x22'+_0x17bfec+'\x22');_0x1178d9[_0xa8d0('0x1c')]('\x22'+_0x2d6e4e+'\x22');}break;default:_0x1178d9[_0xa8d0('0x1c')]('\x22'+_0x17bfec+'\x22');}}else{switch(_0x37bc4c){case _0xa8d0('0x8c'):case _0xa8d0('0x2c'):_0x4a3adf[_0xa8d0('0x1c')](_0x37bc4c+_0xa8d0('0x8d'));break;default:_0x1178d9['push']('\x22\x22');}}}}else{var _0x390542='';if(!_[_0xa8d0('0x1f')](_0x12945c)){if(!_0x2cec05[_0xa8d0('0x8e')](_0x12945c['id'])){if(!_[_0xa8d0('0x1f')](_0x2a810b[_0xa8d0('0x7c')][_0x16aae4][_0x116ca5[_0x37bc4c]])){var _0x17bfec=_[_0xa8d0('0x81')](_0x2a810b[_0xa8d0('0x7c')][_0x16aae4][_0x116ca5[_0x37bc4c]][_0xa8d0('0x82')](/"/g,'\x27'));var _0x5416a1=phoneDescriptions[_0xa8d0('0x7f')](_0x46ef3e=>_0x46ef3e[_0xa8d0('0x8f')]===_0x12945c['id']);if(!_['isNil'](_0x5416a1)){var _0x4516ca=_[_0xa8d0('0x81')](_0x2a810b[_0xa8d0('0x7c')][_0x16aae4][_0x116ca5[_0x5416a1[_0xa8d0('0x90')]]]['replace'](/"/g,'\x27'));if(!_['isNil'](_0x4516ca))_0x17bfec=_0x17bfec+'§'+_0x4516ca;}if(_0x390542=='')_0x390542=_0x17bfec;else _0x390542+='|'+_0x17bfec;}_0x525392[_0xa8d0('0x1c')](_0x12945c['id']+':'+_0x390542);_0x2cec05[_0x12945c['id']]=0x1;}}}}if(hasAdditionalPhones){_0x1178d9[_0xa8d0('0x1c')]('\x22'+_0x525392[_0xa8d0('0x13')](';')+'\x22');}if(_0x4a3adf[_0xa8d0('0x1b')]){handleError(_0x2a810b[_0xa8d0('0x7c')][_0x16aae4],{'code':_0xa8d0('0x91'),'message':_0x4a3adf['join']()});}else{fs[_0xa8d0('0x92')](_0x30a66d,_0x1178d9[_0xa8d0('0x13')]()+'\x0a');}_0x1178d9=[];}if(!(stats[_0xa8d0('0x7d')]%0xc8)){socket[_0xa8d0('0x93')]('contact:import:'+_0x4529a3,stats);stats[_0xa8d0('0x7e')]=[];}}if(stopped){logger[_0xa8d0('0x57')]('Abort\x20parser');_0x20c674['abort']();}}catch(_0x6d06c6){handleError(_0x2a810b[_0xa8d0('0x7c')][_0x16aae4],{'code':_0xa8d0('0x94'),'message':_0x6d06c6[_0xa8d0('0x59')]});logger[_0xa8d0('0x63')](_0xa8d0('0x95'),_0x6d06c6[_0xa8d0('0x59')]);}},'complete':function(){try{var _0x2e132b=[];var _0x5cd9bc=[];var _0x301b09=_0xa8d0('0x34');if(_0x24565a[_0xa8d0('0x96')]&&_0x24565a['duplicates']['length']){_0x301b09=_0xa8d0('0x97')+_0x4529a3;_0x2e132b[_0xa8d0('0x1c')](_0xa8d0('0x98')+_0x301b09+_0xa8d0('0x99'));}tmp_campaigns=_0xa8d0('0x9a')+_0x4529a3;tmp_voice_queues='voice_queues_'+_0x4529a3;_0x5cd9bc[_0xa8d0('0x1c')]('CREATE\x20TABLE\x20'+tmp_campaigns+_0xa8d0('0x9b'));_0x5cd9bc[_0xa8d0('0x1c')](_0xa8d0('0x98')+tmp_voice_queues+_0xa8d0('0x9b'));BPromise[_0xa8d0('0x9c')](_0x5cd9bc,handleTZQuery)[_0xa8d0('0x1a')](function(_0x38e0ed){updateTzCampaigns(_0x24565a[_0xa8d0('0x2f')])[_0xa8d0('0x1a')](function(_0x32a22a){updateTzVoiceQueues(_0x24565a[_0xa8d0('0x2f')])[_0xa8d0('0x1a')](function(_0x4714eb){if(hasTZ)_0x5c0685=_0x5c0685[_0xa8d0('0x82')](_0xa8d0('0x6b'),'dialTimezone,utcOffset');var _0x15ce39=util[_0xa8d0('0xe')](_0xa8d0('0x9d'),_0x30a66d,_0x301b09,_0x5c0685,_0x24565a[_0xa8d0('0x2f')],_0x24565a[_0xa8d0('0x9e')]||null,NOW,NOW);if(_[_0xa8d0('0x1f')](_0x116ca5[_0xa8d0('0x2d')])){_0x15ce39+=_0xa8d0('0x9f');}_0x2e132b[_0xa8d0('0x1c')](_0x15ce39);if(_0x24565a['duplicates']&&_0x24565a[_0xa8d0('0x96')][_0xa8d0('0x1b')]){_0x2e132b[_0xa8d0('0x1c')](insertCmContact(_0x24565a[_0xa8d0('0x2f')],_0x301b09,_0x24565a['duplicates'],_0x116ca5));_0x2e132b[_0xa8d0('0x1c')]('DROP\x20TABLE\x20'+_0x301b09+';');}BPromise['each'](_0x2e132b,handleQuery)[_0xa8d0('0x1a')](function(_0x18795b){BPromise['all']([handleAdditionalPhones()])['then'](function(){_0x2e132b=[];for(var _0x33c8ab=0x0;_0x33c8ab<promisesAdditionalPhones[_0xa8d0('0x1b')];_0x33c8ab++){if(promisesAdditionalPhones[_0x33c8ab][_0xa8d0('0x2c')]!='§'){_0x2e132b[_0xa8d0('0x1c')](createAdditionalPhone(promisesAdditionalPhones[_0x33c8ab]['contactId'],promisesAdditionalPhones[_0x33c8ab]['contactTypeId'],promisesAdditionalPhones[_0x33c8ab][_0xa8d0('0x2c')],promisesAdditionalPhones[_0x33c8ab][_0xa8d0('0xa0')]));}}BPromise['all'](_0x2e132b)[_0xa8d0('0x1a')](function(){_0x2e132b=[];if(hasTZ){_0x2e132b['push'](insertTzCmHopper(_0x24565a['ListId'],_0xa8d0('0x67'),_0xa8d0('0x66'),_0xa8d0('0xa1'),_0xf7f94b,tmp_voice_queues));_0x2e132b[_0xa8d0('0x1c')](insertTzCmHopperBlack(_0x24565a['ListId'],_0xa8d0('0xa2'),_0xa8d0('0x66'),_0xa8d0('0xa1')));_0x2e132b['push'](insertTzCmHopper(_0x24565a[_0xa8d0('0x2f')],_0xa8d0('0xa3'),_0xa8d0('0xa4'),_0xa8d0('0xa5'),_0xf7f94b,tmp_campaigns));_0x2e132b[_0xa8d0('0x1c')](insertTzCmHopperBlack(_0x24565a[_0xa8d0('0x2f')],_0xa8d0('0xa6'),_0xa8d0('0xa4'),'CampaignId'));_0x2e132b[_0xa8d0('0x1c')](insertCmHopperAdditionalPhones(_0x24565a['ListId']));}else{_0x2e132b['push'](insertCmHopper(_0x24565a['ListId'],_0xa8d0('0x67'),_0xa8d0('0x66'),_0xa8d0('0xa1'),_0xf7f94b));_0x2e132b[_0xa8d0('0x1c')](insertCmHopperBlack(_0x24565a['ListId'],'voice_queues_has_cm_blacklists',_0xa8d0('0x66'),_0xa8d0('0xa1')));_0x2e132b[_0xa8d0('0x1c')](insertCmHopper(_0x24565a[_0xa8d0('0x2f')],_0xa8d0('0xa3'),'campaigns',_0xa8d0('0xa5'),_0xf7f94b));_0x2e132b['push'](insertCmHopperBlack(_0x24565a[_0xa8d0('0x2f')],'campaigns_has_cm_blacklists',_0xa8d0('0xa4'),'CampaignId'));_0x2e132b[_0xa8d0('0x1c')](insertCmHopperAdditionalPhones(_0x24565a[_0xa8d0('0x2f')]));}_0x2e132b[_0xa8d0('0x1c')](_0xa8d0('0xa7')+tmp_campaigns+';');_0x2e132b[_0xa8d0('0x1c')](_0xa8d0('0xa7')+tmp_voice_queues+';');BPromise[_0xa8d0('0x9c')](_0x2e132b,handleQuery)['then'](function(_0x28aa35){stats[_0xa8d0('0xa8')]=!![];stats[_0xa8d0('0xa9')]=_0x24565a['duplicates']&&_0x24565a['duplicates']['length']?results[0x2][_0xa8d0('0xa9')]:results[0x0]['affectedRows'];socket[_0xa8d0('0x93')](_0xa8d0('0xaa')+_0x4529a3,stats);fs[_0xa8d0('0xab')](_0x4fb62f);fs[_0xa8d0('0xab')](_0x30a66d);process['exit'](0x0);})[_0xa8d0('0x5d')](function(_0x55dd57){logger[_0xa8d0('0x63')](_0x55dd57[_0xa8d0('0x59')]);process[_0xa8d0('0x5a')](0x1);});});});})[_0xa8d0('0x5d')](function(_0x44c560){logger['error'](_0x44c560[_0xa8d0('0x59')]);process[_0xa8d0('0x5a')](0x1);});});});});}catch(_0x1d780c){logger[_0xa8d0('0x63')]('complete',_0x1d780c[_0xa8d0('0x59')]);process[_0xa8d0('0x5a')](0x1);}},'error':function(_0x15f4c7,_0x31a29c,_0x16bb83,_0xb4b27b){throw new Error(_0xb4b27b);}});});}function validate(){if(process[_0xa8d0('0xac')]&&process[_0xa8d0('0xac')][_0xa8d0('0x1b')]<0x4){throw new Error(_0xa8d0('0xad'));}var _0x2dd21c=path[_0xa8d0('0x13')](config[_0xa8d0('0x73')],'server/files/tmp',process['argv'][0x2]);if(!fs[_0xa8d0('0xae')](_0x2dd21c)){throw new Error(_0xa8d0('0xaf'));}var _0x43844f={};try{_0x43844f=JSON[_0xa8d0('0x7a')](process[_0xa8d0('0xac')][0x3]);if(!_0x43844f['binding']){throw new Error(_0xa8d0('0xb0'));}if(!_0x43844f[_0xa8d0('0x70')][_0xa8d0('0x2c')]){throw new Error(_0xa8d0('0xb1'));}if(!_0x43844f[_0xa8d0('0x70')][_0xa8d0('0x8c')]){throw new Error(_0xa8d0('0xb2'));}var _0x32236e=0x0;if(_0x43844f['binding'][_0xa8d0('0x32')]){_0x32236e=0x1;}if(!_0x43844f[_0xa8d0('0x2f')]){throw new Error(_0xa8d0('0xb3'));}}catch(_0x58e1b0){throw new Error('body\x20id\x20mandatory');}var _0x2ceebf=[];try{_0x2ceebf=_['map'](JSON['parse'](process['argv'][0x4]),'id');}catch(_0x2bc35d){logger['info'](_0xa8d0('0xb4'));}main(_0x2dd21c,_0x43844f,_0x2ceebf,_0x32236e);}validate();process['on']('SIGINT',handleStop);process['on'](_0xa8d0('0xb5'),handleUncaughtException);
\ No newline at end of file
+var _0x5017=['localhost','socket.io-emitter','YYYY-MM-DD\x20HH:mm:ss','select','field','phone','.id\x20=\x20','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','join','findAll','AdditionalPhones','then','push','all','length','split','isNil','filter','CmContactHasItem','findOne','update','updated','PHONE','inserted','cm_contacts.scheduledat','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.updatedAt','cm_contacts.UserId','insert','into','cm_hopper','fromQuery','ContactId','createdAt','updatedAt','UserId','recallme','fields','from','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.id','cm_hopper_black','ListId','ListId\x20=\x20?','cm_contacts.phone','date_add(cm_contacts.scheduledat,interval\x20','scheduledat','priority','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','CmHopperId','cm_hopper.ListId\x20=\x20?','concat','keys','min_id','group','info','Received\x20SIGINT','error','message','exit','errors','code','sequelize','query','spread','catch','campaigns.id','campaigns.dialTimezone','campaigns_has_cm_lists','campaigns.id\x20=\x20campaigns_has_cm_lists.CampaignId','voice_queues.id','voice_queues.dialTimezone','voice_queues','voice_queues_has_cm_lists','voice_queues.id\x20=\x20voice_queues_has_cm_lists.VoiceQueueId','dialTimezone','utcOffset','set','offset','send','start','clone','socket_timestamp','root','server/files/tmp','header','ContactItemType','name','writeFileSync','createReadStream','rows','data','find','hasOwnProperty','replace','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','includes','agent\x20not\x20exists','email\x20wrong\x20format','YYYY-MM-DD','isValid','timezones','\x20not\x20specified','trim','itemTypeId','description','SystemRow','appendFileSync','emit','contact:import:','SystemError','step','cm_contacts_','\x20LIKE\x20cm_contacts;','campaigns_','CREATE\x20TABLE\x20','(id\x20int,dialTimezone\x20varchar(255),offset\x20int);','each','dialTimezone,utcOffset','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\x20id\x20=\x20NULL,\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27','CompanyId','duplicates','DROP\x20TABLE\x20','contactId','orderBy','VoiceQueueId','voice_queues_has_cm_blacklists','CampaignId','campaigns','campaigns_has_cm_blacklists','finish','affectedRows','unlink','complete','argv','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','binding','firstName','ListId\x20is\x20mandatory','body\x20id\x20mandatory','parse','No\x20agent\x20available','SIGINT','uncaughtException','papaparse','util','moment','squel','../../../mysqldb','../../../config/environment','../../../config/environment/shared','redis','defaults'];(function(_0x198f73,_0x33a4c1){var _0x22c693=function(_0x52cd40){while(--_0x52cd40){_0x198f73['push'](_0x198f73['shift']());}};_0x22c693(++_0x33a4c1);}(_0x5017,0xa3));var _0x7501=function(_0x40cea8,_0x865bf){_0x40cea8=_0x40cea8-0x0;var _0x87641b=_0x5017[_0x40cea8];return _0x87641b;};'use strict';var fs=require('fs');var path=require('path');var _=require('lodash');var Papa=require(_0x7501('0x0'));var util=require(_0x7501('0x1'));var BPromise=require('bluebird');var moment=require(_0x7501('0x2'));var squel=require(_0x7501('0x3'));var Redis=require('ioredis');var db=require(_0x7501('0x4'))['db'];var config=require(_0x7501('0x5'));var shared=require(_0x7501('0x6'));var logger=require('../../../config/logger')('import');config[_0x7501('0x7')]=_[_0x7501('0x8')](config[_0x7501('0x7')],{'host':_0x7501('0x9'),'port':0x18eb});var socket=require(_0x7501('0xa'))(new Redis(config[_0x7501('0x7')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()['format'](_0x7501('0xb'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];var tmp_voice_queues;var tmp_campaigns;var tzOffset=0x0;var hasTZ;var NOW=moment()['format']('YYYY-MM-DD\x20HH:mm:ss');function isEmail(_0x59157b){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'](_0x59157b);}function selectNotIn(_0x3f85f8,_0x59d6ce,_0x65b2e6,_0x546cca,_0x187322){return squel[_0x7501('0xc')]()[_0x7501('0xd')](_0x7501('0xe'))['from'](_0x546cca)['join'](_0x59d6ce,null,_0x59d6ce+_0x7501('0xf')+_0x546cca+'.'+_0x65b2e6)['where'](_0x546cca+'.'+_0x65b2e6+_0x7501('0x10')+_0x3f85f8+'.'+_0x65b2e6)[_0x7501('0x11')](_0x59d6ce+_0x7501('0x12')+_0x187322[_0x7501('0x13')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x7c3d4a,_0x591099){promisesAdditionalPhones=[];return db['CmContact'][_0x7501('0x14')]({'raw':!![],'attributes':['id',_0x7501('0x15')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})[_0x7501('0x16')](function(_0x3603af){if(_0x3603af!==null){var _0x238d43=[];for(var _0x9118c=0x0;_0x9118c<_0x3603af['length'];_0x9118c++){var _0x1d60a1=_0x3603af[_0x9118c];_0x238d43[_0x7501('0x17')](insertAdditionalPhones(_0x1d60a1));}}Promise[_0x7501('0x18')](_0x238d43)[_0x7501('0x16')](function(){_0x7c3d4a({'val':0x1});});});});}function insertAdditionalPhones(_0x11954b){return new Promise(function(_0x1364a8,_0x197912){var _0x53aa61=_0x11954b['AdditionalPhones'];var _0x118859=_0x53aa61['split'](';');var _0x304635=[];orderBy=0x0;for(var _0x7f0d6c=0x0;_0x7f0d6c<_0x118859['length'];_0x7f0d6c++){_0x304635[_0x7501('0x17')](splitAdditionalPhone(_0x11954b['id'],_0x118859[_0x7f0d6c]));}Promise[_0x7501('0x18')](_0x304635)[_0x7501('0x16')](function(){_0x1364a8({'val':_0x118859[_0x7501('0x19')]});});});}function splitAdditionalPhone(_0xa64532,_0x2475dd){return new Promise(function(_0x39bfa3,_0x233787){var _0x4c00ad=_0x2475dd[_0x7501('0x1a')](':');var _0x2d6be8=_0x4c00ad[0x0];var _0x54470e=_0x4c00ad[0x1];if(!_[_0x7501('0x1b')](_0x54470e)){var _0x31db2b=_0x54470e[_0x7501('0x1a')]('|');var _0x25af18=[];for(var _0x4a13c4=0x0;_0x4a13c4<_0x31db2b[_0x7501('0x19')];_0x4a13c4++){if(_0x31db2b[_0x4a13c4]!==''){var _0x27c08a=_[_0x7501('0x1c')](promisesAdditionalPhones,{'contactId':_0xa64532,'phone':_0x31db2b[_0x4a13c4]});if(_0x27c08a['length']==0x0){orderBy++;promisesAdditionalPhones[_0x7501('0x17')]({'contactId':_0xa64532,'contactTypeId':_0x2d6be8,'phone':_0x31db2b[_0x4a13c4],'orderBy':orderBy});}}}_0x39bfa3({'ok':0x1});}else _0x39bfa3({'res':0x0});});}function createAdditionalPhone(_0x3a5a20,_0x381176,_0x4d72c8,_0x138b59){var _0x5128d3='';var _0x49bbe8='';var _0x58ca6a=_0x4d72c8[_0x7501('0x1a')]('§');_0x5128d3=_0x58ca6a[0x0];if(_0x58ca6a[_0x7501('0x19')]==0x2)_0x49bbe8=_0x58ca6a[0x1];return new Promise(function(_0xd2e8ac,_0x1c362d){return db[_0x7501('0x1d')][_0x7501('0x1e')]({'where':{'CmContactId':_0x3a5a20,'item':_0x5128d3}})[_0x7501('0x16')](function(_0x556ac1){if(_0x556ac1){return db['CmContactHasItem'][_0x7501('0x1f')]({'ItemTypeId':_0x381176,'description':_0x49bbe8,'OrderBy':_0x138b59},{'where':{'CmContactId':_0x3a5a20,'item':_0x5128d3}})['then'](function(_0x204e30){_0xd2e8ac({'res':_0x7501('0x20')});});}else{return db[_0x7501('0x1d')]['create']({'CmContactId':_0x3a5a20,'item':_0x5128d3,'description':_0x49bbe8,'ItemTypeId':_0x381176,'OrderBy':_0x138b59,'ItemClass':_0x7501('0x21')})[_0x7501('0x16')](function(_0x1b87d2){_0xd2e8ac({'res':_0x7501('0x22')});});}});});}function insertCmHopper(_0x1eef66,_0x2ae6f8,_0x18bee5,_0x592434,_0xb6c063){var _0x4c98b4=['cm_contacts.phone',_0x7501('0x23'),'cm_contacts.id',_0x7501('0x24'),_0x2ae6f8+'.'+_0x592434,_0x7501('0x25'),_0x7501('0x26'),'cm_contacts.priority',_0x7501('0x27'),'\x22'+_0xb6c063+'\x22'];return squel[_0x7501('0x28')]()[_0x7501('0x29')](_0x7501('0x2a'))[_0x7501('0x2b')]([_0x7501('0xe'),'scheduledat',_0x7501('0x2c'),'ListId',_0x592434,_0x7501('0x2d'),_0x7501('0x2e'),'priority',_0x7501('0x2f'),_0x7501('0x30')],squel[_0x7501('0xc')]()[_0x7501('0x31')](_0x4c98b4)[_0x7501('0x32')](_0x2ae6f8)['join'](_0x7501('0x33'),null,_0x7501('0x34')+_0x2ae6f8+_0x7501('0x35'))[_0x7501('0x13')](_0x18bee5,null,_0x18bee5+_0x7501('0xf')+_0x2ae6f8+'.'+_0x592434)[_0x7501('0x11')](_0x2ae6f8+_0x7501('0x36'),_0x1eef66)[_0x7501('0x11')](_0x7501('0x37'),NOW)[_0x7501('0x11')](_0x7501('0x38'),selectNotIn(_0x2ae6f8,_0x18bee5,_0x592434,_0x7501('0x2a'),[_0x7501('0x39'),_0x7501('0x3a')]))[_0x7501('0x11')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x2ae6f8,_0x18bee5,_0x592434,'cm_hopper',[_0x7501('0x39')])))[_0x7501('0x3b')]();}function insertCmHopperBlack(_0x167887,_0x25c541,_0x1304f2,_0x2c5428){var _0x444e8b=['cm_contacts.phone',_0x7501('0x3c'),_0x7501('0x24'),_0x25c541+'.'+_0x2c5428,_0x7501('0x25'),_0x7501('0x26')];return squel['insert']()['into'](_0x7501('0x3d'))[_0x7501('0x2b')]([_0x7501('0xe'),_0x7501('0x2c'),_0x7501('0x3e'),_0x2c5428,_0x7501('0x2d'),_0x7501('0x2e')],squel[_0x7501('0xc')]()['fields'](_0x444e8b)[_0x7501('0x32')](_0x25c541)['join']('cm_contacts',null,_0x7501('0x34')+_0x25c541+_0x7501('0x35'))[_0x7501('0x13')](_0x1304f2,null,_0x1304f2+_0x7501('0xf')+_0x25c541+'.'+_0x2c5428)[_0x7501('0x11')](_0x25c541+_0x7501('0x36'),_0x167887)['where']('cm_contacts.createdAt\x20=\x20?',NOW)[_0x7501('0x11')](_0x7501('0x38'),squel[_0x7501('0xc')]()['field'](_0x7501('0xe'))[_0x7501('0x32')](_0x7501('0x3d'))[_0x7501('0x11')](_0x7501('0x3f'),_0x167887)['where'](_0x2c5428+_0x7501('0x10')+_0x25c541+'.'+_0x2c5428)))['toString']();}function insertTzCmHopper(_0x5cc161,_0x90e67b,_0x5c2b9f,_0x2d220a,_0x161be5,_0x390173){var _0x3a8117=[_0x7501('0x40'),_0x7501('0x41')+_0x390173+'.offset-cm_contacts.utcOffset\x20minute)',_0x7501('0x3c'),_0x7501('0x24'),_0x90e67b+'.'+_0x2d220a,_0x7501('0x25'),_0x7501('0x26'),'cm_contacts.priority','cm_contacts.UserId','\x22'+_0x161be5+'\x22'];var _0x55b57e=squel[_0x7501('0x28')]()['into'](_0x7501('0x2a'))['fromQuery']([_0x7501('0xe'),_0x7501('0x42'),_0x7501('0x2c'),'ListId',_0x2d220a,_0x7501('0x2d'),'updatedAt',_0x7501('0x43'),'UserId',_0x7501('0x30')],squel[_0x7501('0xc')]()['fields'](_0x3a8117)[_0x7501('0x32')](_0x90e67b)['join']('cm_contacts',null,_0x7501('0x34')+_0x90e67b+_0x7501('0x35'))['join'](_0x5c2b9f,null,_0x5c2b9f+_0x7501('0xf')+_0x90e67b+'.'+_0x2d220a)[_0x7501('0x13')](_0x390173,null,_0x390173+_0x7501('0xf')+_0x90e67b+'.'+_0x2d220a)[_0x7501('0x11')](_0x90e67b+_0x7501('0x36'),_0x5cc161)[_0x7501('0x11')](_0x7501('0x37'),NOW)['where'](_0x7501('0x38'),selectNotIn(_0x90e67b,_0x5c2b9f,_0x2d220a,_0x7501('0x2a'),['\x22always\x22',_0x7501('0x3a')]))[_0x7501('0x11')](_0x7501('0x38'),selectNotIn(_0x90e67b,_0x5c2b9f,_0x2d220a,_0x7501('0x2a'),['\x22always\x22'])))['toString']();return _0x55b57e;}function insertTzCmHopperBlack(_0x3159bc,_0x5321d8,_0x4da6ff,_0x34ca8a){var _0x82b1f5=[_0x7501('0x40'),_0x7501('0x3c'),'cm_contacts.ListId',_0x5321d8+'.'+_0x34ca8a,_0x7501('0x25'),_0x7501('0x26')];return squel[_0x7501('0x28')]()[_0x7501('0x29')]('cm_hopper_black')[_0x7501('0x2b')](['phone',_0x7501('0x2c'),'ListId',_0x34ca8a,_0x7501('0x2d'),_0x7501('0x2e')],squel[_0x7501('0xc')]()[_0x7501('0x31')](_0x82b1f5)['from'](_0x5321d8)[_0x7501('0x13')](_0x7501('0x33'),null,'cm_contacts.ListId\x20=\x20'+_0x5321d8+_0x7501('0x35'))[_0x7501('0x13')](_0x4da6ff,null,_0x4da6ff+'.id\x20=\x20'+_0x5321d8+'.'+_0x34ca8a)['where'](_0x5321d8+_0x7501('0x36'),_0x3159bc)[_0x7501('0x11')](_0x7501('0x37'),NOW)['where']('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel[_0x7501('0xc')]()[_0x7501('0xd')](_0x7501('0xe'))[_0x7501('0x32')](_0x7501('0x3d'))[_0x7501('0x11')](_0x7501('0x3f'),_0x3159bc)[_0x7501('0x11')](_0x34ca8a+_0x7501('0x10')+_0x5321d8+'.'+_0x34ca8a)))['toString']();}function insertCmHopperAdditionalPhones(_0x428ca5){var _0x5313e5=[_0x7501('0x44'),_0x7501('0x45'),'cm_contact_has_items.OrderBy',_0x7501('0x46'),_0x7501('0x47')];return squel[_0x7501('0x28')]()[_0x7501('0x29')](_0x7501('0x48'))[_0x7501('0x2b')]([_0x7501('0x49'),_0x7501('0xe'),'OrderBy','createdAt',_0x7501('0x2e')],squel[_0x7501('0xc')]()[_0x7501('0x31')](_0x5313e5)[_0x7501('0x32')](_0x7501('0x2a'))[_0x7501('0x13')](_0x7501('0x33'),null,'cm_contacts.id\x20=\x20cm_hopper.ContactId')['join']('cm_contact_has_items',null,'cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId')[_0x7501('0x11')](_0x7501('0x4a'),_0x428ca5)[_0x7501('0x11')](_0x7501('0x37'),NOW))[_0x7501('0x3b')]();}function insertCmContact(_0x5a6870,_0x3dd12a,_0x17fa3b,_0x41d53a){var _0x2ab683=_[_0x7501('0x4b')](_[_0x7501('0x4c')](_0x41d53a),[_0x7501('0x3e'),'CompanyId',_0x7501('0x2d'),'updatedAt']);return squel['insert']()[_0x7501('0x29')](_0x7501('0x33'))['fromQuery'](_0x2ab683,squel[_0x7501('0xc')]()[_0x7501('0x31')](_0x2ab683)[_0x7501('0x32')](_0x3dd12a)[_0x7501('0x11')]('('+_0x17fa3b['join'](',')+')\x20NOT\x20IN\x20?',squel['select']()['fields'](_0x17fa3b)['from'](_0x7501('0x33'))[_0x7501('0x11')](_0x7501('0x3f'),_0x5a6870)['where']('deletedAt\x20IS\x20NULL'))[_0x7501('0x11')]('id\x20IN\x20?',squel[_0x7501('0xc')]()['field']('MIN(id)',_0x7501('0x4d'))[_0x7501('0x32')](_0x3dd12a)[_0x7501('0x4e')](_0x17fa3b[_0x7501('0x13')](','))))[_0x7501('0x3b')]();}function handleStop(){logger[_0x7501('0x4f')](_0x7501('0x50'));stopped=!![];}function handleUncaughtException(_0x4bc11b){logger[_0x7501('0x51')](_0x4bc11b[_0x7501('0x52')]);process[_0x7501('0x53')](0x1);}function handleError(_0x599daa,_0xd2947){stats[_0x7501('0x54')]['push']({'name':_0xd2947[_0x7501('0x55')],'message':_0xd2947[_0x7501('0x52')],'row':_0x599daa});}function handleQuery(_0x255046){logger[_0x7501('0x4f')](_0x255046);return db[_0x7501('0x56')][_0x7501('0x57')](_0x255046)[_0x7501('0x58')](function(_0x20e188){results['push'](_0x20e188);})[_0x7501('0x59')](function(_0x52de46){logger['error'](_0x52de46[_0x7501('0x52')]);});}function updateTzCampaigns(_0x101d66){return new Promise(function(_0xf437bf,_0x398b0c){var _0x22a98c=squel[_0x7501('0xc')]()[_0x7501('0x31')]([_0x7501('0x5a'),_0x7501('0x5b')])['from']('campaigns')[_0x7501('0x13')](_0x7501('0x5c'),null,_0x7501('0x5d'))[_0x7501('0x11')]('campaigns_has_cm_lists.CmListId='+_0x101d66);db[_0x7501('0x56')][_0x7501('0x57')](_0x22a98c[_0x7501('0x3b')]())[_0x7501('0x58')](function(_0x650236){var _0x8e429d=[];for(var _0x23910a=0x0;_0x23910a<_0x650236[_0x7501('0x19')];_0x23910a++){_0x8e429d[_0x7501('0x17')](getTimezoneData(_0x650236[_0x23910a],tmp_campaigns));}BPromise[_0x7501('0x18')](_0x8e429d)[_0x7501('0x16')](function(){_0xf437bf({'val':0x1});});})['catch'](function(_0x2cf89f){logger[_0x7501('0x51')](_0x2cf89f[_0x7501('0x52')]);_0xf437bf({'val':0x0});});});}function updateTzVoiceQueues(_0x599994){return new Promise(function(_0x2baddb,_0x10d9db){var _0x5c35bf=squel[_0x7501('0xc')]()['fields']([_0x7501('0x5e'),_0x7501('0x5f')])[_0x7501('0x32')](_0x7501('0x60'))[_0x7501('0x13')](_0x7501('0x61'),null,_0x7501('0x62'))[_0x7501('0x11')]('voice_queues_has_cm_lists.CmListId='+_0x599994);db[_0x7501('0x56')][_0x7501('0x57')](_0x5c35bf[_0x7501('0x3b')]())[_0x7501('0x58')](function(_0x4719ea){var _0x17d47f=[];for(var _0x216ccc=0x0;_0x216ccc<_0x4719ea[_0x7501('0x19')];_0x216ccc++){_0x17d47f['push'](getTimezoneData(_0x4719ea[_0x216ccc],tmp_voice_queues));}BPromise[_0x7501('0x18')](_0x17d47f)['then'](function(){_0x2baddb({'val':0x1});});})[_0x7501('0x59')](function(_0x84c9a5){logger['error'](_0x84c9a5['message']);_0x2baddb({'val':0x0});});});}function getTimezoneData(_0x1b9feb,_0x59fcb4){return new Promise(function(_0x25683e,_0x877cf3){var _0x19ff59=shared['timezones'];var _0xfbfbf1=_0x19ff59[_0x1b9feb[_0x7501('0x63')]];if(_[_0x7501('0x1b')](_0xfbfbf1)){_0x25683e({'ret':0x1});}else{var _0x2c568e=_0xfbfbf1[_0x7501('0x64')];var _0xbb3d08=squel['insert']()[_0x7501('0x29')](_0x59fcb4)[_0x7501('0x65')]('id',_0x1b9feb['id'])[_0x7501('0x65')](_0x7501('0x66'),_0x2c568e)[_0x7501('0x65')]('dialTimezone',_0x1b9feb[_0x7501('0x63')])[_0x7501('0x3b')]();return db[_0x7501('0x56')]['query'](_0xbb3d08)[_0x7501('0x58')](function(_0x526f73){_0x25683e({'ret':0x1});})[_0x7501('0x59')](function(_0x258972){logger[_0x7501('0x51')](_0x258972['message']);_0x877cf3({'ret':0x1});});}});}function handleTZQuery(_0x55d158){logger[_0x7501('0x4f')](_0x55d158);return db[_0x7501('0x56')][_0x7501('0x57')](_0x55d158)[_0x7501('0x58')](function(_0x3bb67d){})[_0x7501('0x59')](function(_0x56c832){logger['error'](_0x56c832[_0x7501('0x52')]);});}function main(_0x2b887b,_0x3b5f9e,_0xf9a4e3,_0xe1ab1d){logger['info']('main',_0x2b887b,JSON['stringify'](_0x3b5f9e));process[_0x7501('0x67')](_0x7501('0x68'));var _0x3ffd09=_0x3b5f9e['binding'];var _0x2c299c=_[_0x7501('0x69')](_0x3ffd09);var _0x27568f=_0x3b5f9e[_0x7501('0x6a')];var _0x372c36=path[_0x7501('0x13')](config[_0x7501('0x6b')],_0x7501('0x6c'),_0x27568f+'.csv');hasTZ=_[_0x7501('0x4c')](_0x3ffd09)['includes']('dialTimezone');var _0x16493a=_[_0x7501('0x4c')](_0x3ffd09)[_0x7501('0x13')]();logger[_0x7501('0x4f')](_0x7501('0x6d'),_0x16493a);db[_0x7501('0x6e')][_0x7501('0x14')]({'raw':!![],'attributes':['id',_0x7501('0x6f')]})[_0x7501('0x16')](function(_0x5e80d5){for(var _0x3213d9=0x0;_0x3213d9<_0x5e80d5['length'];_0x3213d9++){if(_0x5e80d5[_0x3213d9][_0x7501('0x6f')]in _0x3ffd09){contactItemTypes[_0x7501('0x17')](_0x5e80d5[_0x3213d9]);delete _0x2c299c[_0x5e80d5[_0x3213d9][_0x7501('0x6f')]];hasAdditionalPhones=!![];}for(var _0x56ebee in _0x3ffd09){if(_0x5e80d5[_0x3213d9]['name']+'_description'===_0x56ebee){phoneDescriptions[_0x7501('0x17')]({'itemTypeId':_0x5e80d5[_0x3213d9]['id'],'description':_0x56ebee});delete _0x2c299c[_0x56ebee];}}}if(hasAdditionalPhones)_0x2c299c[_0x7501('0x15')]='';var _0xf78263=_[_0x7501('0x4c')](_0x2c299c)['join']();logger['info']('header',_0xf78263);fs[_0x7501('0x70')](_0x372c36,_0xf78263+'\x0a');Papa['parse'](fs[_0x7501('0x71')](_0x2b887b),{'header':!![],'skipEmptyLines':!![],'step':function(_0x56af49,_0x225afa){try{for(var _0x1e8959=0x0,_0x5e3fb7=[];_0x1e8959<_0x56af49['data']['length'];_0x1e8959++){stats[_0x7501('0x72')]+=0x1;if(_0x56af49['errors'][_0x1e8959]){handleError(_0x56af49[_0x7501('0x73')][_0x1e8959],_0x56af49['errors'][_0x1e8959]);}else{var _0x27da4c=[];var _0x1d5b68=[];var _0x5b5d29={};for(var _0x7c8959 in _0x3ffd09){let _0x5e1955=contactItemTypes[_0x7501('0x74')](_0x5d81cc=>_0x5d81cc[_0x7501('0x6f')]===_0x7c8959);let _0xa9777e=contactItemTypes[_0x7501('0x74')](_0x14333b=>_0x14333b['name']+'_description'===_0x7c8959);if(_[_0x7501('0x1b')](_0x5e1955)&&_[_0x7501('0x1b')](_0xa9777e)){if(_0x3ffd09[_0x7501('0x75')](_0x7c8959)){if(_0x56af49['data'][_0x1e8959][_0x3ffd09[_0x7c8959]]){var _0x1e62c9=_['trim'](_0x56af49[_0x7501('0x73')][_0x1e8959][_0x3ffd09[_0x7c8959]][_0x7501('0x76')](/"/g,'\x27'));switch(_0x7c8959){case _0x7501('0x42'):var _0x12cf36=moment(_0x1e62c9,'YYYY-MM-DD\x20HH:mm:ss',!![]);if(_0x12cf36['isValid']()){_0x5e3fb7[_0x7501('0x17')]('\x22'+_0x1e62c9+'\x22');}else{_0x27da4c[_0x7501('0x17')](_0x7501('0x77'));}break;case _0x7501('0x43'):var _0x3162ba=parseInt(_0x1e62c9);_0x1e62c9=_[_0x7501('0x78')](_0x3162ba)||_0x3162ba<0x0||_0x3162ba>0x4?_0xe1ab1d?0x3:0x2:_0x3162ba;_0x5e3fb7[_0x7501('0x17')]('\x22'+_0x1e62c9+'\x22');break;case _0x7501('0x2f'):var _0x28376c=parseInt(_0x1e62c9);if(_[_0x7501('0x79')](_0x28376c)&&_[_0x7501('0x7a')](_0xf9a4e3,_0x28376c)){_0x5e3fb7[_0x7501('0x17')]('\x22'+_0x28376c+'\x22');}else{_0x27da4c['push'](_0x7501('0x7b'));}break;case'email':if(isEmail(_0x1e62c9)){_0x5e3fb7['push']('\x22'+_0x1e62c9+'\x22');}else{_0x27da4c['push'](_0x7501('0x7c'));}break;case'dateOfBirth':var _0x4e1693=moment(_0x1e62c9,_0x7501('0x7d'),!![]);if(_0x4e1693[_0x7501('0x7e')]()){_0x5e3fb7['push']('\x22'+_0x1e62c9+'\x22');}else{_0x27da4c[_0x7501('0x17')]('dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)');}break;case _0x7501('0x63'):var _0x471b3d=shared[_0x7501('0x7f')];var _0x2df4f5=_0x471b3d[_0x1e62c9];if(!_[_0x7501('0x1b')](_0x2df4f5)){var _0x60c9e0=_0x2df4f5[_0x7501('0x64')];_0x5e3fb7[_0x7501('0x17')]('\x22'+_0x1e62c9+'\x22');_0x5e3fb7[_0x7501('0x17')]('\x22'+_0x60c9e0+'\x22');}break;default:_0x5e3fb7['push']('\x22'+_0x1e62c9+'\x22');}}else{switch(_0x7c8959){case'firstName':case _0x7501('0xe'):_0x27da4c[_0x7501('0x17')](_0x7c8959+_0x7501('0x80'));break;default:_0x5e3fb7[_0x7501('0x17')]('\x22\x22');}}}}else{var _0x2f6f26='';if(!_[_0x7501('0x1b')](_0x5e1955)){if(!_0x5b5d29[_0x7501('0x75')](_0x5e1955['id'])){if(!_[_0x7501('0x1b')](_0x56af49[_0x7501('0x73')][_0x1e8959][_0x3ffd09[_0x7c8959]])){var _0x1e62c9=_[_0x7501('0x81')](_0x56af49[_0x7501('0x73')][_0x1e8959][_0x3ffd09[_0x7c8959]][_0x7501('0x76')](/"/g,'\x27'));var _0x4bceb8=phoneDescriptions['find'](_0x574010=>_0x574010[_0x7501('0x82')]===_0x5e1955['id']);if(!_[_0x7501('0x1b')](_0x4bceb8)){var _0x10153a=_[_0x7501('0x81')](_0x56af49[_0x7501('0x73')][_0x1e8959][_0x3ffd09[_0x4bceb8[_0x7501('0x83')]]][_0x7501('0x76')](/"/g,'\x27'));if(!_[_0x7501('0x1b')](_0x10153a))_0x1e62c9=_0x1e62c9+'§'+_0x10153a;}if(_0x2f6f26=='')_0x2f6f26=_0x1e62c9;else _0x2f6f26+='|'+_0x1e62c9;}_0x1d5b68[_0x7501('0x17')](_0x5e1955['id']+':'+_0x2f6f26);_0x5b5d29[_0x5e1955['id']]=0x1;}}}}if(hasAdditionalPhones){_0x5e3fb7[_0x7501('0x17')]('\x22'+_0x1d5b68[_0x7501('0x13')](';')+'\x22');}if(_0x27da4c['length']){handleError(_0x56af49['data'][_0x1e8959],{'code':_0x7501('0x84'),'message':_0x27da4c[_0x7501('0x13')]()});}else{fs[_0x7501('0x85')](_0x372c36,_0x5e3fb7['join']()+'\x0a');}_0x5e3fb7=[];}if(!(stats['rows']%0xc8)){socket[_0x7501('0x86')](_0x7501('0x87')+_0x27568f,stats);stats[_0x7501('0x54')]=[];}}if(stopped){logger[_0x7501('0x4f')]('Abort\x20parser');_0x225afa['abort']();}}catch(_0x377aa0){handleError(_0x56af49[_0x7501('0x73')][_0x1e8959],{'code':_0x7501('0x88'),'message':_0x377aa0[_0x7501('0x52')]});logger['error'](_0x7501('0x89'),_0x377aa0[_0x7501('0x52')]);}},'complete':function(){try{var _0x468a2e=[];var _0x4670bc=[];var _0xcf6f19='cm_contacts';if(_0x3b5f9e['duplicates']&&_0x3b5f9e['duplicates'][_0x7501('0x19')]){_0xcf6f19=_0x7501('0x8a')+_0x27568f;_0x468a2e[_0x7501('0x17')]('CREATE\x20TABLE\x20'+_0xcf6f19+_0x7501('0x8b'));}tmp_campaigns=_0x7501('0x8c')+_0x27568f;tmp_voice_queues='voice_queues_'+_0x27568f;_0x4670bc[_0x7501('0x17')](_0x7501('0x8d')+tmp_campaigns+_0x7501('0x8e'));_0x4670bc['push']('CREATE\x20TABLE\x20'+tmp_voice_queues+_0x7501('0x8e'));BPromise[_0x7501('0x8f')](_0x4670bc,handleTZQuery)['then'](function(_0x454ed8){updateTzCampaigns(_0x3b5f9e[_0x7501('0x3e')])['then'](function(_0x1c494c){updateTzVoiceQueues(_0x3b5f9e[_0x7501('0x3e')])[_0x7501('0x16')](function(_0x185a0d){if(hasTZ)_0xf78263=_0xf78263[_0x7501('0x76')](_0x7501('0x63'),_0x7501('0x90'));var _0x5dfad5=util[_0x7501('0x91')](_0x7501('0x92'),_0x372c36,_0xcf6f19,_0xf78263,_0x3b5f9e[_0x7501('0x3e')],_0x3b5f9e[_0x7501('0x93')]||null,NOW,NOW);if(_[_0x7501('0x1b')](_0x3ffd09[_0x7501('0x42')])){_0x5dfad5+=',\x20scheduledAt\x20=\x20NOW()';}_0x468a2e['push'](_0x5dfad5);if(_0x3b5f9e[_0x7501('0x94')]&&_0x3b5f9e[_0x7501('0x94')][_0x7501('0x19')]){_0x468a2e['push'](insertCmContact(_0x3b5f9e[_0x7501('0x3e')],_0xcf6f19,_0x3b5f9e[_0x7501('0x94')],_0x3ffd09));_0x468a2e['push'](_0x7501('0x95')+_0xcf6f19+';');}BPromise[_0x7501('0x8f')](_0x468a2e,handleQuery)['then'](function(_0x3ce96e){BPromise[_0x7501('0x18')]([handleAdditionalPhones()])[_0x7501('0x16')](function(){_0x468a2e=[];for(var _0x523fea=0x0;_0x523fea<promisesAdditionalPhones[_0x7501('0x19')];_0x523fea++){if(promisesAdditionalPhones[_0x523fea][_0x7501('0xe')]!='§'){_0x468a2e[_0x7501('0x17')](createAdditionalPhone(promisesAdditionalPhones[_0x523fea][_0x7501('0x96')],promisesAdditionalPhones[_0x523fea]['contactTypeId'],promisesAdditionalPhones[_0x523fea]['phone'],promisesAdditionalPhones[_0x523fea][_0x7501('0x97')]));}}BPromise[_0x7501('0x18')](_0x468a2e)['then'](function(){_0x468a2e=[];if(hasTZ){_0x468a2e[_0x7501('0x17')](insertTzCmHopper(_0x3b5f9e[_0x7501('0x3e')],'voice_queues_has_cm_lists','voice_queues',_0x7501('0x98'),_0xe1ab1d,tmp_voice_queues));_0x468a2e[_0x7501('0x17')](insertTzCmHopperBlack(_0x3b5f9e[_0x7501('0x3e')],_0x7501('0x99'),_0x7501('0x60'),'VoiceQueueId'));_0x468a2e['push'](insertTzCmHopper(_0x3b5f9e[_0x7501('0x3e')],_0x7501('0x5c'),'campaigns',_0x7501('0x9a'),_0xe1ab1d,tmp_campaigns));_0x468a2e['push'](insertTzCmHopperBlack(_0x3b5f9e[_0x7501('0x3e')],'campaigns_has_cm_blacklists','campaigns',_0x7501('0x9a')));_0x468a2e[_0x7501('0x17')](insertCmHopperAdditionalPhones(_0x3b5f9e[_0x7501('0x3e')]));}else{_0x468a2e[_0x7501('0x17')](insertCmHopper(_0x3b5f9e[_0x7501('0x3e')],'voice_queues_has_cm_lists',_0x7501('0x60'),_0x7501('0x98'),_0xe1ab1d));_0x468a2e[_0x7501('0x17')](insertCmHopperBlack(_0x3b5f9e[_0x7501('0x3e')],_0x7501('0x99'),_0x7501('0x60'),_0x7501('0x98')));_0x468a2e[_0x7501('0x17')](insertCmHopper(_0x3b5f9e[_0x7501('0x3e')],'campaigns_has_cm_lists',_0x7501('0x9b'),_0x7501('0x9a'),_0xe1ab1d));_0x468a2e[_0x7501('0x17')](insertCmHopperBlack(_0x3b5f9e[_0x7501('0x3e')],_0x7501('0x9c'),_0x7501('0x9b'),_0x7501('0x9a')));_0x468a2e[_0x7501('0x17')](insertCmHopperAdditionalPhones(_0x3b5f9e[_0x7501('0x3e')]));}_0x468a2e[_0x7501('0x17')](_0x7501('0x95')+tmp_campaigns+';');_0x468a2e['push'](_0x7501('0x95')+tmp_voice_queues+';');BPromise[_0x7501('0x8f')](_0x468a2e,handleQuery)[_0x7501('0x16')](function(_0x1e41c7){stats[_0x7501('0x9d')]=!![];stats['affectedRows']=_0x3b5f9e[_0x7501('0x94')]&&_0x3b5f9e['duplicates']['length']?results[0x2][_0x7501('0x9e')]:results[0x0][_0x7501('0x9e')];socket[_0x7501('0x86')]('contact:import:'+_0x27568f,stats);fs[_0x7501('0x9f')](_0x2b887b);fs[_0x7501('0x9f')](_0x372c36);process[_0x7501('0x53')](0x0);})[_0x7501('0x59')](function(_0x289183){logger[_0x7501('0x51')](_0x289183[_0x7501('0x52')]);process[_0x7501('0x53')](0x1);});});});})[_0x7501('0x59')](function(_0x2f445b){logger['error'](_0x2f445b['message']);process[_0x7501('0x53')](0x1);});});});});}catch(_0x35b235){logger[_0x7501('0x51')](_0x7501('0xa0'),_0x35b235[_0x7501('0x52')]);process[_0x7501('0x53')](0x1);}},'error':function(_0x108f70,_0x4e22e5,_0x439a0f,_0x51e3d6){throw new Error(_0x51e3d6);}});});}function validate(){if(process[_0x7501('0xa1')]&&process[_0x7501('0xa1')][_0x7501('0x19')]<0x4){throw new Error('arguments\x20<filename>\x20<parameters>\x20<agents>');}var _0x1a2fc8=path[_0x7501('0x13')](config[_0x7501('0x6b')],_0x7501('0x6c'),process[_0x7501('0xa1')][0x2]);if(!fs['existsSync'](_0x1a2fc8)){throw new Error(_0x7501('0xa2'));}var _0x281f62={};try{_0x281f62=JSON['parse'](process[_0x7501('0xa1')][0x3]);if(!_0x281f62['binding']){throw new Error(_0x7501('0xa3'));}if(!_0x281f62[_0x7501('0xa4')][_0x7501('0xe')]){throw new Error('phone\x20is\x20mandatory');}if(!_0x281f62[_0x7501('0xa4')][_0x7501('0xa5')]){throw new Error('firstName\x20is\x20mandatory');}var _0x3944eb=0x0;if(_0x281f62['binding'][_0x7501('0x2f')]){_0x3944eb=0x1;}if(!_0x281f62[_0x7501('0x3e')]){throw new Error(_0x7501('0xa6'));}}catch(_0x3d83c3){throw new Error(_0x7501('0xa7'));}var _0x516ad1=[];try{_0x516ad1=_['map'](JSON[_0x7501('0xa8')](process[_0x7501('0xa1')][0x4]),'id');}catch(_0x5be867){logger['info'](_0x7501('0xa9'));}main(_0x1a2fc8,_0x281f62,_0x516ad1,_0x3944eb);}validate();process['on'](_0x7501('0xaa'),handleStop);process['on'](_0x7501('0xab'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff