// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x00ef=['findAll','then','length','push','all','split','isNil','filter','CmContactHasItem','updated','create','PHONE','inserted','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.createdAt','cm_contacts.updatedAt','cm_contacts.priority','insert','into','cm_hopper','fromQuery','scheduledat','createdAt','priority','recallme','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','.CmListId\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22always\x22','\x22onlyIfOpen\x22','toString','ContactId','ListId','updatedAt','cm_contacts.createdAt\x20=\x20?','cm_hopper_black','ListId\x20=\x20?','\x20=\x20','.offset-cm_contacts.utcOffset\x20minute)','cm_contacts.ListId','cm_contacts.UserId','UserId','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.createdAt','cm_hopper_additional_phones','CmHopperId','OrderBy','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contact_has_items','cm_hopper.ListId\x20=\x20?','keys','CompanyId','scheduledAt','deletedAt\x20IS\x20NULL','id\x20IN\x20?','MIN(id)','group','info','Received\x20SIGINT','message','errors','sequelize','query','spread','error','campaigns.dialTimezone','campaigns_has_cm_lists','campaigns.id\x20=\x20campaigns_has_cm_lists.CampaignId','campaigns_has_cm_lists.CmListId=','catch','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','set','offset','stringify','clone','socket_timestamp','root','server/files/tmp','.csv','includes','header','ContactItemType','name','_description','AdditionalPhones','writeFileSync','parse','createReadStream','data','rows','find','hasOwnProperty','trim','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNumber','email','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','utcOffset','firstName','\x20not\x20specified','replace','itemTypeId','description','SystemRow','appendFileSync','emit','contact:import:','abort','SystemError','step','duplicates','cm_contacts_','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','campaigns_','(id\x20int,dialTimezone\x20varchar(255),offset\x20int);','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',',\x20scheduledAt\x20=\x20NOW()','DROP\x20TABLE\x20','each','contactTypeId','orderBy','VoiceQueueId','voice_queues_has_cm_blacklists','campaigns','campaigns_has_cm_blacklists','CampaignId','finish','affectedRows','unlink','exit','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists','binding','binding\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','No\x20agent\x20available','uncaughtException','lodash','papaparse','bluebird','moment','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','import','redis','defaults','socket.io-emitter','YYYY-MM-DD\x20HH:mm:ss','format','test','select','field','phone','from','join','.id\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','CmContact'];(function(_0x5116ef,_0x5b983f){var _0x377dc2=function(_0x6a2add){while(--_0x6a2add){_0x5116ef['push'](_0x5116ef['shift']());}};_0x377dc2(++_0x5b983f);}(_0x00ef,0x9f));var _0xf00e=function(_0x46e363,_0x45d7e2){_0x46e363=_0x46e363-0x0;var _0x3fb059=_0x00ef[_0x46e363];return _0x3fb059;};'use strict';var fs=require('fs');var path=require('path');var _=require(_0xf00e('0x0'));var Papa=require(_0xf00e('0x1'));var util=require('util');var BPromise=require(_0xf00e('0x2'));var moment=require(_0xf00e('0x3'));var squel=require('squel');var Redis=require(_0xf00e('0x4'));var db=require(_0xf00e('0x5'))['db'];var config=require(_0xf00e('0x6'));var shared=require('../../../config/environment/shared');var logger=require(_0xf00e('0x7'))(_0xf00e('0x8'));config[_0xf00e('0x9')]=_[_0xf00e('0xa')](config['redis'],{'host':'localhost','port':0x18eb});var socket=require(_0xf00e('0xb'))(new Redis(config['redis']));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()['format'](_0xf00e('0xc'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];var tmp_voice_queues;var tmp_campaigns;var tzOffset=0x0;var hasTZ;var NOW=moment()[_0xf00e('0xd')](_0xf00e('0xc'));function isEmail(_0x1ee202){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))*$/[_0xf00e('0xe')](_0x1ee202);}function selectNotIn(_0x60207c,_0x34b69c,_0x34d5b8,_0x15035b,_0x1d6ab1){return squel[_0xf00e('0xf')]()[_0xf00e('0x10')](_0xf00e('0x11'))[_0xf00e('0x12')](_0x15035b)[_0xf00e('0x13')](_0x34b69c,null,_0x34b69c+_0xf00e('0x14')+_0x15035b+'.'+_0x34d5b8)[_0xf00e('0x15')](_0x15035b+'.'+_0x34d5b8+'\x20=\x20'+_0x60207c+'.'+_0x34d5b8)[_0xf00e('0x15')](_0x34b69c+_0xf00e('0x16')+_0x1d6ab1[_0xf00e('0x13')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x497d40,_0x62bf68){promisesAdditionalPhones=[];return db[_0xf00e('0x17')][_0xf00e('0x18')]({'raw':!![],'attributes':['id','AdditionalPhones'],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})[_0xf00e('0x19')](function(_0x374520){if(_0x374520!==null){var _0x39957d=[];for(var _0x4c9003=0x0;_0x4c9003<_0x374520[_0xf00e('0x1a')];_0x4c9003++){var _0x3e81f5=_0x374520[_0x4c9003];_0x39957d[_0xf00e('0x1b')](insertAdditionalPhones(_0x3e81f5));}}Promise[_0xf00e('0x1c')](_0x39957d)[_0xf00e('0x19')](function(){_0x497d40({'val':0x1});});});});}function insertAdditionalPhones(_0x4f2104){return new Promise(function(_0x4c8917,_0x537f72){var _0x4613cf=_0x4f2104['AdditionalPhones'];var _0x1b7d08=_0x4613cf[_0xf00e('0x1d')](';');var _0x16a670=[];orderBy=0x0;for(var _0x239ecf=0x0;_0x239ecf<_0x1b7d08['length'];_0x239ecf++){_0x16a670[_0xf00e('0x1b')](splitAdditionalPhone(_0x4f2104['id'],_0x1b7d08[_0x239ecf]));}Promise[_0xf00e('0x1c')](_0x16a670)[_0xf00e('0x19')](function(){_0x4c8917({'val':_0x1b7d08[_0xf00e('0x1a')]});});});}function splitAdditionalPhone(_0x2ee948,_0x2d8813){return new Promise(function(_0x5d9f68,_0x3f4092){var _0x3ffe94=_0x2d8813[_0xf00e('0x1d')](':');var _0x4049ae=_0x3ffe94[0x0];var _0x566dd8=_0x3ffe94[0x1];if(!_[_0xf00e('0x1e')](_0x566dd8)){var _0x1e0850=_0x566dd8[_0xf00e('0x1d')]('|');var _0x557768=[];for(var _0x37ff6a=0x0;_0x37ff6a<_0x1e0850[_0xf00e('0x1a')];_0x37ff6a++){if(_0x1e0850[_0x37ff6a]!==''){var _0x42882d=_[_0xf00e('0x1f')](promisesAdditionalPhones,{'contactId':_0x2ee948,'phone':_0x1e0850[_0x37ff6a]});if(_0x42882d[_0xf00e('0x1a')]==0x0){orderBy++;promisesAdditionalPhones[_0xf00e('0x1b')]({'contactId':_0x2ee948,'contactTypeId':_0x4049ae,'phone':_0x1e0850[_0x37ff6a],'orderBy':orderBy});}}}_0x5d9f68({'ok':0x1});}else _0x5d9f68({'res':0x0});});}function createAdditionalPhone(_0x20205e,_0x519de7,_0x39c8ea,_0x1fac06){var _0x505a37='';var _0x51c88b='';var _0x4303c0=_0x39c8ea['split']('§');_0x505a37=_0x4303c0[0x0];if(_0x4303c0[_0xf00e('0x1a')]==0x2)_0x51c88b=_0x4303c0[0x1];return new Promise(function(_0x333a8a,_0x4e448f){return db[_0xf00e('0x20')]['findOne']({'where':{'CmContactId':_0x20205e,'item':_0x505a37}})[_0xf00e('0x19')](function(_0x10ee8e){if(_0x10ee8e){return db[_0xf00e('0x20')]['update']({'ItemTypeId':_0x519de7,'description':_0x51c88b,'OrderBy':_0x1fac06},{'where':{'CmContactId':_0x20205e,'item':_0x505a37}})['then'](function(_0x2b9715){_0x333a8a({'res':_0xf00e('0x21')});});}else{return db[_0xf00e('0x20')][_0xf00e('0x22')]({'CmContactId':_0x20205e,'item':_0x505a37,'description':_0x51c88b,'ItemTypeId':_0x519de7,'OrderBy':_0x1fac06,'ItemClass':_0xf00e('0x23')})[_0xf00e('0x19')](function(_0x310db8){_0x333a8a({'res':_0xf00e('0x24')});});}});});}function insertCmHopper(_0x47ba61,_0x316c10,_0x305892,_0x3066fd,_0x5294fe){var _0x58de67=[_0xf00e('0x25'),_0xf00e('0x26'),_0xf00e('0x27'),'cm_contacts.ListId',_0x316c10+'.'+_0x3066fd,_0xf00e('0x28'),_0xf00e('0x29'),_0xf00e('0x2a'),'cm_contacts.UserId','\x22'+_0x5294fe+'\x22'];return squel[_0xf00e('0x2b')]()[_0xf00e('0x2c')](_0xf00e('0x2d'))[_0xf00e('0x2e')]([_0xf00e('0x11'),_0xf00e('0x2f'),'ContactId','ListId',_0x3066fd,_0xf00e('0x30'),'updatedAt',_0xf00e('0x31'),'UserId',_0xf00e('0x32')],squel[_0xf00e('0xf')]()[_0xf00e('0x33')](_0x58de67)['from'](_0x316c10)[_0xf00e('0x13')](_0xf00e('0x34'),null,_0xf00e('0x35')+_0x316c10+_0xf00e('0x36'))[_0xf00e('0x13')](_0x305892,null,_0x305892+_0xf00e('0x14')+_0x316c10+'.'+_0x3066fd)[_0xf00e('0x15')](_0x316c10+_0xf00e('0x37'),_0x47ba61)['where']('cm_contacts.createdAt\x20=\x20?',NOW)[_0xf00e('0x15')](_0xf00e('0x38'),selectNotIn(_0x316c10,_0x305892,_0x3066fd,_0xf00e('0x2d'),[_0xf00e('0x39'),_0xf00e('0x3a')]))[_0xf00e('0x15')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x316c10,_0x305892,_0x3066fd,_0xf00e('0x2d'),['\x22always\x22'])))[_0xf00e('0x3b')]();}function insertCmHopperBlack(_0x3bb8cf,_0x448c52,_0x336b5b,_0x1fc9cd){var _0x5b45b1=[_0xf00e('0x25'),_0xf00e('0x27'),'cm_contacts.ListId',_0x448c52+'.'+_0x1fc9cd,_0xf00e('0x28'),_0xf00e('0x29')];return squel[_0xf00e('0x2b')]()[_0xf00e('0x2c')]('cm_hopper_black')['fromQuery'](['phone',_0xf00e('0x3c'),_0xf00e('0x3d'),_0x1fc9cd,_0xf00e('0x30'),_0xf00e('0x3e')],squel[_0xf00e('0xf')]()[_0xf00e('0x33')](_0x5b45b1)[_0xf00e('0x12')](_0x448c52)['join'](_0xf00e('0x34'),null,_0xf00e('0x35')+_0x448c52+_0xf00e('0x36'))[_0xf00e('0x13')](_0x336b5b,null,_0x336b5b+'.id\x20=\x20'+_0x448c52+'.'+_0x1fc9cd)[_0xf00e('0x15')](_0x448c52+_0xf00e('0x37'),_0x3bb8cf)[_0xf00e('0x15')](_0xf00e('0x3f'),NOW)['where'](_0xf00e('0x38'),squel[_0xf00e('0xf')]()[_0xf00e('0x10')](_0xf00e('0x11'))[_0xf00e('0x12')](_0xf00e('0x40'))['where'](_0xf00e('0x41'),_0x3bb8cf)[_0xf00e('0x15')](_0x1fc9cd+_0xf00e('0x42')+_0x448c52+'.'+_0x1fc9cd)))[_0xf00e('0x3b')]();}function insertTzCmHopper(_0xd6f527,_0x196afe,_0x219c29,_0x54114a,_0x58353d,_0x1748b5){var _0x38abc8=[_0xf00e('0x25'),'date_add(cm_contacts.scheduledat,interval\x20'+_0x1748b5+_0xf00e('0x43'),_0xf00e('0x27'),_0xf00e('0x44'),_0x196afe+'.'+_0x54114a,_0xf00e('0x28'),_0xf00e('0x29'),'cm_contacts.priority',_0xf00e('0x45'),'\x22'+_0x58353d+'\x22'];var _0x4bd2a2=squel[_0xf00e('0x2b')]()[_0xf00e('0x2c')](_0xf00e('0x2d'))[_0xf00e('0x2e')]([_0xf00e('0x11'),_0xf00e('0x2f'),_0xf00e('0x3c'),_0xf00e('0x3d'),_0x54114a,_0xf00e('0x30'),_0xf00e('0x3e'),'priority',_0xf00e('0x46'),_0xf00e('0x32')],squel[_0xf00e('0xf')]()['fields'](_0x38abc8)[_0xf00e('0x12')](_0x196afe)[_0xf00e('0x13')]('cm_contacts',null,_0xf00e('0x35')+_0x196afe+_0xf00e('0x36'))[_0xf00e('0x13')](_0x219c29,null,_0x219c29+_0xf00e('0x14')+_0x196afe+'.'+_0x54114a)[_0xf00e('0x13')](_0x1748b5,null,_0x1748b5+'.id\x20=\x20'+_0x196afe+'.'+_0x54114a)[_0xf00e('0x15')](_0x196afe+_0xf00e('0x37'),_0xd6f527)[_0xf00e('0x15')](_0xf00e('0x3f'),NOW)['where'](_0xf00e('0x38'),selectNotIn(_0x196afe,_0x219c29,_0x54114a,_0xf00e('0x2d'),['\x22always\x22',_0xf00e('0x3a')]))[_0xf00e('0x15')](_0xf00e('0x38'),selectNotIn(_0x196afe,_0x219c29,_0x54114a,_0xf00e('0x2d'),[_0xf00e('0x39')])))[_0xf00e('0x3b')]();return _0x4bd2a2;}function insertTzCmHopperBlack(_0x4dc255,_0x290b8f,_0x12015d,_0x5a0b6e){var _0x5d1c98=[_0xf00e('0x25'),_0xf00e('0x27'),_0xf00e('0x44'),_0x290b8f+'.'+_0x5a0b6e,_0xf00e('0x28'),_0xf00e('0x29')];return squel[_0xf00e('0x2b')]()[_0xf00e('0x2c')](_0xf00e('0x40'))['fromQuery']([_0xf00e('0x11'),_0xf00e('0x3c'),_0xf00e('0x3d'),_0x5a0b6e,_0xf00e('0x30'),'updatedAt'],squel[_0xf00e('0xf')]()[_0xf00e('0x33')](_0x5d1c98)['from'](_0x290b8f)[_0xf00e('0x13')]('cm_contacts',null,_0xf00e('0x35')+_0x290b8f+_0xf00e('0x36'))[_0xf00e('0x13')](_0x12015d,null,_0x12015d+_0xf00e('0x14')+_0x290b8f+'.'+_0x5a0b6e)[_0xf00e('0x15')](_0x290b8f+_0xf00e('0x37'),_0x4dc255)['where'](_0xf00e('0x3f'),NOW)[_0xf00e('0x15')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel[_0xf00e('0xf')]()[_0xf00e('0x10')](_0xf00e('0x11'))['from'](_0xf00e('0x40'))[_0xf00e('0x15')](_0xf00e('0x41'),_0x4dc255)[_0xf00e('0x15')](_0x5a0b6e+_0xf00e('0x42')+_0x290b8f+'.'+_0x5a0b6e)))['toString']();}function insertCmHopperAdditionalPhones(_0xe211ef){var _0x467c1b=[_0xf00e('0x47'),_0xf00e('0x48'),'cm_contact_has_items.OrderBy',_0xf00e('0x49'),'cm_contact_has_items.updatedAt'];return squel[_0xf00e('0x2b')]()[_0xf00e('0x2c')](_0xf00e('0x4a'))['fromQuery']([_0xf00e('0x4b'),'phone',_0xf00e('0x4c'),_0xf00e('0x30'),_0xf00e('0x3e')],squel[_0xf00e('0xf')]()[_0xf00e('0x33')](_0x467c1b)[_0xf00e('0x12')](_0xf00e('0x2d'))['join'](_0xf00e('0x34'),null,_0xf00e('0x4d'))[_0xf00e('0x13')](_0xf00e('0x4e'),null,'cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId')['where'](_0xf00e('0x4f'),_0xe211ef)[_0xf00e('0x15')]('cm_contacts.createdAt\x20=\x20?',NOW))['toString']();}function insertCmContact(_0x161ced,_0x136ba4,_0x59072a,_0x5e03d1){var _0x16c9d7=_['concat'](_[_0xf00e('0x50')](_0x5e03d1),['ListId',_0xf00e('0x51'),_0xf00e('0x30'),_0xf00e('0x3e'),_0xf00e('0x52')]);return squel[_0xf00e('0x2b')]()[_0xf00e('0x2c')]('cm_contacts')['fromQuery'](_0x16c9d7,squel[_0xf00e('0xf')]()[_0xf00e('0x33')](_0x16c9d7)[_0xf00e('0x12')](_0x136ba4)[_0xf00e('0x15')]('('+_0x59072a[_0xf00e('0x13')](',')+')\x20NOT\x20IN\x20?',squel[_0xf00e('0xf')]()['fields'](_0x59072a)[_0xf00e('0x12')]('cm_contacts')[_0xf00e('0x15')]('ListId\x20=\x20?',_0x161ced)[_0xf00e('0x15')](_0xf00e('0x53')))['where'](_0xf00e('0x54'),squel['select']()[_0xf00e('0x10')](_0xf00e('0x55'),'min_id')['from'](_0x136ba4)[_0xf00e('0x56')](_0x59072a[_0xf00e('0x13')](','))))['toString']();}function handleStop(){logger[_0xf00e('0x57')](_0xf00e('0x58'));stopped=!![];}function handleUncaughtException(_0x212d7b){logger['error'](_0x212d7b[_0xf00e('0x59')]);process['exit'](0x1);}function handleError(_0x57a34b,_0x4b2be5){stats[_0xf00e('0x5a')]['push']({'name':_0x4b2be5['code'],'message':_0x4b2be5[_0xf00e('0x59')],'row':_0x57a34b});}function handleQuery(_0x4d02ad){logger[_0xf00e('0x57')](_0x4d02ad);return db[_0xf00e('0x5b')][_0xf00e('0x5c')](_0x4d02ad)[_0xf00e('0x5d')](function(_0x34818a){results[_0xf00e('0x1b')](_0x34818a);})['catch'](function(_0x4d21a3){logger[_0xf00e('0x5e')](_0x4d21a3[_0xf00e('0x59')]);});}function updateTzCampaigns(_0x549c8d){return new Promise(function(_0x489b8f,_0xac21d7){var _0x2a62ce=squel[_0xf00e('0xf')]()[_0xf00e('0x33')](['campaigns.id',_0xf00e('0x5f')])[_0xf00e('0x12')]('campaigns')['join'](_0xf00e('0x60'),null,_0xf00e('0x61'))['where'](_0xf00e('0x62')+_0x549c8d);db[_0xf00e('0x5b')][_0xf00e('0x5c')](_0x2a62ce[_0xf00e('0x3b')]())['spread'](function(_0x4083e4){var _0xadc0ef=[];for(var _0x1f6bce=0x0;_0x1f6bce<_0x4083e4[_0xf00e('0x1a')];_0x1f6bce++){_0xadc0ef[_0xf00e('0x1b')](getTimezoneData(_0x4083e4[_0x1f6bce],tmp_campaigns));}BPromise[_0xf00e('0x1c')](_0xadc0ef)[_0xf00e('0x19')](function(){_0x489b8f({'val':0x1});});})[_0xf00e('0x63')](function(_0x8c0e84){logger[_0xf00e('0x5e')](_0x8c0e84[_0xf00e('0x59')]);_0x489b8f({'val':0x0});});});}function updateTzVoiceQueues(_0x566ccd){return new Promise(function(_0x229e08,_0x1ae732){var _0x4e1ede=squel[_0xf00e('0xf')]()[_0xf00e('0x33')](['voice_queues.id',_0xf00e('0x64')])['from'](_0xf00e('0x65'))[_0xf00e('0x13')](_0xf00e('0x66'),null,_0xf00e('0x67'))[_0xf00e('0x15')](_0xf00e('0x68')+_0x566ccd);db[_0xf00e('0x5b')][_0xf00e('0x5c')](_0x4e1ede[_0xf00e('0x3b')]())[_0xf00e('0x5d')](function(_0xd0114f){var _0x319094=[];for(var _0x3f14a0=0x0;_0x3f14a0<_0xd0114f[_0xf00e('0x1a')];_0x3f14a0++){_0x319094['push'](getTimezoneData(_0xd0114f[_0x3f14a0],tmp_voice_queues));}BPromise[_0xf00e('0x1c')](_0x319094)[_0xf00e('0x19')](function(){_0x229e08({'val':0x1});});})[_0xf00e('0x63')](function(_0x31e1e5){logger[_0xf00e('0x5e')](_0x31e1e5['message']);_0x229e08({'val':0x0});});});}function getTimezoneData(_0x34c1f0,_0x4d5f36){return new Promise(function(_0x1f9388,_0x146cb0){var _0x51e182=shared[_0xf00e('0x69')];var _0x1c4fc1=_0x51e182[_0x34c1f0[_0xf00e('0x6a')]];if(_[_0xf00e('0x1e')](_0x1c4fc1)){_0x1f9388({'ret':0x1});}else{var _0x73deff=_0x1c4fc1['utcOffset'];var _0x3f150f=squel['insert']()[_0xf00e('0x2c')](_0x4d5f36)[_0xf00e('0x6b')]('id',_0x34c1f0['id'])[_0xf00e('0x6b')](_0xf00e('0x6c'),_0x73deff)['set'](_0xf00e('0x6a'),_0x34c1f0[_0xf00e('0x6a')])['toString']();return db[_0xf00e('0x5b')][_0xf00e('0x5c')](_0x3f150f)[_0xf00e('0x5d')](function(_0xfe9f90){_0x1f9388({'ret':0x1});})[_0xf00e('0x63')](function(_0x417534){logger['error'](_0x417534[_0xf00e('0x59')]);_0x146cb0({'ret':0x1});});}});}function handleTZQuery(_0x4c98a2){logger[_0xf00e('0x57')](_0x4c98a2);return db[_0xf00e('0x5b')][_0xf00e('0x5c')](_0x4c98a2)[_0xf00e('0x5d')](function(_0x2563b7){})[_0xf00e('0x63')](function(_0x580720){logger['error'](_0x580720[_0xf00e('0x59')]);});}function main(_0x2c9997,_0x4464a9,_0x35179b,_0x3ec46d){logger[_0xf00e('0x57')]('main',_0x2c9997,JSON[_0xf00e('0x6d')](_0x4464a9));process['send']('start');var _0x5dfa5e=_0x4464a9['binding'];var _0x253c1f=_[_0xf00e('0x6e')](_0x5dfa5e);var _0x353fca=_0x4464a9[_0xf00e('0x6f')];var _0x3ef32=path[_0xf00e('0x13')](config[_0xf00e('0x70')],_0xf00e('0x71'),_0x353fca+_0xf00e('0x72'));hasTZ=_['keys'](_0x5dfa5e)[_0xf00e('0x73')](_0xf00e('0x6a'));var _0x1e90ce=_[_0xf00e('0x50')](_0x5dfa5e)[_0xf00e('0x13')]();logger['info'](_0xf00e('0x74'),_0x1e90ce);db[_0xf00e('0x75')][_0xf00e('0x18')]({'raw':!![],'attributes':['id','name']})[_0xf00e('0x19')](function(_0x208214){for(var _0x273d09=0x0;_0x273d09<_0x208214[_0xf00e('0x1a')];_0x273d09++){if(_0x208214[_0x273d09][_0xf00e('0x76')]in _0x5dfa5e){contactItemTypes[_0xf00e('0x1b')](_0x208214[_0x273d09]);delete _0x253c1f[_0x208214[_0x273d09][_0xf00e('0x76')]];hasAdditionalPhones=!![];}for(var _0x143ac0 in _0x5dfa5e){if(_0x208214[_0x273d09]['name']+_0xf00e('0x77')===_0x143ac0){phoneDescriptions['push']({'itemTypeId':_0x208214[_0x273d09]['id'],'description':_0x143ac0});delete _0x253c1f[_0x143ac0];}}}if(hasAdditionalPhones)_0x253c1f[_0xf00e('0x78')]='';var _0x50a943=_[_0xf00e('0x50')](_0x253c1f)[_0xf00e('0x13')]();logger[_0xf00e('0x57')](_0xf00e('0x74'),_0x50a943);fs[_0xf00e('0x79')](_0x3ef32,_0x50a943+'\x0a');Papa[_0xf00e('0x7a')](fs[_0xf00e('0x7b')](_0x2c9997),{'header':!![],'skipEmptyLines':!![],'step':function(_0x14d694,_0x11ef28){try{for(var _0x2d30e6=0x0,_0x5cb7fa=[];_0x2d30e6<_0x14d694[_0xf00e('0x7c')][_0xf00e('0x1a')];_0x2d30e6++){stats[_0xf00e('0x7d')]+=0x1;if(_0x14d694[_0xf00e('0x5a')][_0x2d30e6]){handleError(_0x14d694[_0xf00e('0x7c')][_0x2d30e6],_0x14d694[_0xf00e('0x5a')][_0x2d30e6]);}else{var _0x83baf6=[];var _0x18e03f=[];var _0x4d1f1d={};for(var _0x5c723a in _0x5dfa5e){let _0x6def93=contactItemTypes[_0xf00e('0x7e')](_0x377d80=>_0x377d80['name']===_0x5c723a);let _0x1e6c20=contactItemTypes['find'](_0x17498e=>_0x17498e[_0xf00e('0x76')]+_0xf00e('0x77')===_0x5c723a);if(_[_0xf00e('0x1e')](_0x6def93)&&_[_0xf00e('0x1e')](_0x1e6c20)){if(_0x5dfa5e[_0xf00e('0x7f')](_0x5c723a)){if(_0x14d694[_0xf00e('0x7c')][_0x2d30e6][_0x5dfa5e[_0x5c723a]]){var _0x491ab1=_[_0xf00e('0x80')](_0x14d694['data'][_0x2d30e6][_0x5dfa5e[_0x5c723a]]['replace'](/"/g,'\x27'));switch(_0x5c723a){case _0xf00e('0x2f'):var _0x425b2e=moment(_0x491ab1,_0xf00e('0xc'),!![]);if(_0x425b2e[_0xf00e('0x81')]()){_0x5cb7fa['push']('\x22'+_0x491ab1+'\x22');}else{_0x83baf6[_0xf00e('0x1b')](_0xf00e('0x82'));}break;case _0xf00e('0x31'):var _0x34807b=parseInt(_0x491ab1);_0x491ab1=_['isNaN'](_0x34807b)||_0x34807b<0x0||_0x34807b>0x4?_0x3ec46d?0x3:0x2:_0x34807b;_0x5cb7fa[_0xf00e('0x1b')]('\x22'+_0x491ab1+'\x22');break;case'UserId':var _0x27ba7d=parseInt(_0x491ab1);if(_[_0xf00e('0x83')](_0x27ba7d)&&_[_0xf00e('0x73')](_0x35179b,_0x27ba7d)){_0x5cb7fa[_0xf00e('0x1b')]('\x22'+_0x27ba7d+'\x22');}else{_0x83baf6['push']('agent\x20not\x20exists');}break;case _0xf00e('0x84'):if(isEmail(_0x491ab1)){_0x5cb7fa[_0xf00e('0x1b')]('\x22'+_0x491ab1+'\x22');}else{_0x83baf6[_0xf00e('0x1b')](_0xf00e('0x85'));}break;case _0xf00e('0x86'):var _0xa06aee=moment(_0x491ab1,_0xf00e('0x87'),!![]);if(_0xa06aee['isValid']()){_0x5cb7fa[_0xf00e('0x1b')]('\x22'+_0x491ab1+'\x22');}else{_0x83baf6[_0xf00e('0x1b')](_0xf00e('0x88'));}break;case _0xf00e('0x6a'):var _0x3126f9=shared[_0xf00e('0x69')];var _0x50b63d=_0x3126f9[_0x491ab1];if(!_[_0xf00e('0x1e')](_0x50b63d)){var _0x1bf72d=_0x50b63d[_0xf00e('0x89')];_0x5cb7fa['push']('\x22'+_0x491ab1+'\x22');_0x5cb7fa['push']('\x22'+_0x1bf72d+'\x22');}break;default:_0x5cb7fa[_0xf00e('0x1b')]('\x22'+_0x491ab1+'\x22');}}else{switch(_0x5c723a){case _0xf00e('0x8a'):case _0xf00e('0x11'):_0x83baf6[_0xf00e('0x1b')](_0x5c723a+_0xf00e('0x8b'));break;default:_0x5cb7fa['push']('\x22\x22');}}}}else{var _0x4b2067='';if(!_[_0xf00e('0x1e')](_0x6def93)){if(!_0x4d1f1d[_0xf00e('0x7f')](_0x6def93['id'])){if(!_[_0xf00e('0x1e')](_0x14d694['data'][_0x2d30e6][_0x5dfa5e[_0x5c723a]])){var _0x491ab1=_[_0xf00e('0x80')](_0x14d694[_0xf00e('0x7c')][_0x2d30e6][_0x5dfa5e[_0x5c723a]][_0xf00e('0x8c')](/"/g,'\x27'));var _0xfd3be1=phoneDescriptions['find'](_0x11502d=>_0x11502d[_0xf00e('0x8d')]===_0x6def93['id']);if(!_['isNil'](_0xfd3be1)){var _0x2ae6a1=_[_0xf00e('0x80')](_0x14d694['data'][_0x2d30e6][_0x5dfa5e[_0xfd3be1[_0xf00e('0x8e')]]][_0xf00e('0x8c')](/"/g,'\x27'));if(!_['isNil'](_0x2ae6a1))_0x491ab1=_0x491ab1+'§'+_0x2ae6a1;}if(_0x4b2067=='')_0x4b2067=_0x491ab1;else _0x4b2067+='|'+_0x491ab1;}_0x18e03f[_0xf00e('0x1b')](_0x6def93['id']+':'+_0x4b2067);_0x4d1f1d[_0x6def93['id']]=0x1;}}}}if(hasAdditionalPhones){_0x5cb7fa[_0xf00e('0x1b')]('\x22'+_0x18e03f[_0xf00e('0x13')](';')+'\x22');}if(_0x83baf6['length']){handleError(_0x14d694['data'][_0x2d30e6],{'code':_0xf00e('0x8f'),'message':_0x83baf6[_0xf00e('0x13')]()});}else{fs[_0xf00e('0x90')](_0x3ef32,_0x5cb7fa['join']()+'\x0a');}_0x5cb7fa=[];}if(!(stats[_0xf00e('0x7d')]%0xc8)){socket[_0xf00e('0x91')](_0xf00e('0x92')+_0x353fca,stats);stats[_0xf00e('0x5a')]=[];}}if(stopped){logger[_0xf00e('0x57')]('Abort\x20parser');_0x11ef28[_0xf00e('0x93')]();}}catch(_0x3797f9){handleError(_0x14d694[_0xf00e('0x7c')][_0x2d30e6],{'code':_0xf00e('0x94'),'message':_0x3797f9[_0xf00e('0x59')]});logger[_0xf00e('0x5e')](_0xf00e('0x95'),_0x3797f9[_0xf00e('0x59')]);}},'complete':function(){try{var _0x573915=[];var _0x3e9140=[];var _0x204c9f=_0xf00e('0x34');if(_0x4464a9[_0xf00e('0x96')]&&_0x4464a9[_0xf00e('0x96')][_0xf00e('0x1a')]){_0x204c9f=_0xf00e('0x97')+_0x353fca;_0x573915['push'](_0xf00e('0x98')+_0x204c9f+_0xf00e('0x99'));}tmp_campaigns=_0xf00e('0x9a')+_0x353fca;tmp_voice_queues='voice_queues_'+_0x353fca;_0x3e9140['push'](_0xf00e('0x98')+tmp_campaigns+_0xf00e('0x9b'));_0x3e9140['push']('CREATE\x20TABLE\x20'+tmp_voice_queues+'(id\x20int,dialTimezone\x20varchar(255),offset\x20int);');BPromise['each'](_0x3e9140,handleTZQuery)[_0xf00e('0x19')](function(_0x344f3c){updateTzCampaigns(_0x4464a9[_0xf00e('0x3d')])['then'](function(_0x53df34){updateTzVoiceQueues(_0x4464a9[_0xf00e('0x3d')])[_0xf00e('0x19')](function(_0x3c1fe8){if(hasTZ)_0x50a943=_0x50a943[_0xf00e('0x8c')](_0xf00e('0x6a'),'dialTimezone,utcOffset');var _0x42a4f5=util[_0xf00e('0xd')](_0xf00e('0x9c'),_0x3ef32,_0x204c9f,_0x50a943,_0x4464a9[_0xf00e('0x3d')],_0x4464a9[_0xf00e('0x51')]||null,NOW,NOW);if(_['isNil'](_0x5dfa5e[_0xf00e('0x2f')])){_0x42a4f5+=_0xf00e('0x9d');}_0x573915['push'](_0x42a4f5);if(_0x4464a9['duplicates']&&_0x4464a9[_0xf00e('0x96')][_0xf00e('0x1a')]){_0x573915[_0xf00e('0x1b')](insertCmContact(_0x4464a9['ListId'],_0x204c9f,_0x4464a9[_0xf00e('0x96')],_0x5dfa5e));_0x573915[_0xf00e('0x1b')](_0xf00e('0x9e')+_0x204c9f+';');}BPromise[_0xf00e('0x9f')](_0x573915,handleQuery)[_0xf00e('0x19')](function(_0x4812fd){BPromise[_0xf00e('0x1c')]([handleAdditionalPhones()])['then'](function(){_0x573915=[];for(var _0x3db538=0x0;_0x3db538<promisesAdditionalPhones['length'];_0x3db538++){if(promisesAdditionalPhones[_0x3db538]['phone']!='§'){_0x573915['push'](createAdditionalPhone(promisesAdditionalPhones[_0x3db538]['contactId'],promisesAdditionalPhones[_0x3db538][_0xf00e('0xa0')],promisesAdditionalPhones[_0x3db538]['phone'],promisesAdditionalPhones[_0x3db538][_0xf00e('0xa1')]));}}BPromise[_0xf00e('0x1c')](_0x573915)[_0xf00e('0x19')](function(){_0x573915=[];if(hasTZ){_0x573915[_0xf00e('0x1b')](insertTzCmHopper(_0x4464a9[_0xf00e('0x3d')],_0xf00e('0x66'),'voice_queues',_0xf00e('0xa2'),_0x3ec46d,tmp_voice_queues));_0x573915[_0xf00e('0x1b')](insertTzCmHopperBlack(_0x4464a9[_0xf00e('0x3d')],_0xf00e('0xa3'),'voice_queues',_0xf00e('0xa2')));_0x573915['push'](insertTzCmHopper(_0x4464a9[_0xf00e('0x3d')],_0xf00e('0x60'),_0xf00e('0xa4'),'CampaignId',_0x3ec46d,tmp_campaigns));_0x573915[_0xf00e('0x1b')](insertTzCmHopperBlack(_0x4464a9[_0xf00e('0x3d')],_0xf00e('0xa5'),_0xf00e('0xa4'),_0xf00e('0xa6')));_0x573915[_0xf00e('0x1b')](insertCmHopperAdditionalPhones(_0x4464a9[_0xf00e('0x3d')]));}else{_0x573915['push'](insertCmHopper(_0x4464a9[_0xf00e('0x3d')],_0xf00e('0x66'),'voice_queues',_0xf00e('0xa2'),_0x3ec46d));_0x573915[_0xf00e('0x1b')](insertCmHopperBlack(_0x4464a9[_0xf00e('0x3d')],'voice_queues_has_cm_blacklists',_0xf00e('0x65'),_0xf00e('0xa2')));_0x573915['push'](insertCmHopper(_0x4464a9[_0xf00e('0x3d')],_0xf00e('0x60'),_0xf00e('0xa4'),_0xf00e('0xa6'),_0x3ec46d));_0x573915[_0xf00e('0x1b')](insertCmHopperBlack(_0x4464a9[_0xf00e('0x3d')],'campaigns_has_cm_blacklists',_0xf00e('0xa4'),_0xf00e('0xa6')));_0x573915[_0xf00e('0x1b')](insertCmHopperAdditionalPhones(_0x4464a9[_0xf00e('0x3d')]));}_0x573915[_0xf00e('0x1b')](_0xf00e('0x9e')+tmp_campaigns+';');_0x573915[_0xf00e('0x1b')](_0xf00e('0x9e')+tmp_voice_queues+';');BPromise[_0xf00e('0x9f')](_0x573915,handleQuery)['then'](function(_0x1f9d93){stats[_0xf00e('0xa7')]=!![];stats['affectedRows']=_0x4464a9['duplicates']&&_0x4464a9[_0xf00e('0x96')][_0xf00e('0x1a')]?results[0x2][_0xf00e('0xa8')]:results[0x0][_0xf00e('0xa8')];socket[_0xf00e('0x91')](_0xf00e('0x92')+_0x353fca,stats);fs[_0xf00e('0xa9')](_0x2c9997);fs[_0xf00e('0xa9')](_0x3ef32);process[_0xf00e('0xaa')](0x0);})['catch'](function(_0x5d395c){logger['error'](_0x5d395c[_0xf00e('0x59')]);process[_0xf00e('0xaa')](0x1);});});});})[_0xf00e('0x63')](function(_0x5e4b8d){logger[_0xf00e('0x5e')](_0x5e4b8d[_0xf00e('0x59')]);process[_0xf00e('0xaa')](0x1);});});});});}catch(_0x3c57d1){logger['error'](_0xf00e('0xab'),_0x3c57d1[_0xf00e('0x59')]);process[_0xf00e('0xaa')](0x1);}},'error':function(_0x5236fe,_0x227daf,_0x25a365,_0x3803ce){throw new Error(_0x3803ce);}});});}function validate(){if(process[_0xf00e('0xac')]&&process[_0xf00e('0xac')][_0xf00e('0x1a')]<0x4){throw new Error(_0xf00e('0xad'));}var _0x55ea13=path['join'](config[_0xf00e('0x70')],_0xf00e('0x71'),process[_0xf00e('0xac')][0x2]);if(!fs[_0xf00e('0xae')](_0x55ea13)){throw new Error(_0xf00e('0xaf'));}var _0x4e6bd9={};try{_0x4e6bd9=JSON[_0xf00e('0x7a')](process[_0xf00e('0xac')][0x3]);if(!_0x4e6bd9[_0xf00e('0xb0')]){throw new Error(_0xf00e('0xb1'));}if(!_0x4e6bd9[_0xf00e('0xb0')]['phone']){throw new Error('phone\x20is\x20mandatory');}if(!_0x4e6bd9[_0xf00e('0xb0')][_0xf00e('0x8a')]){throw new Error('firstName\x20is\x20mandatory');}var _0x3bac9e=0x0;if(_0x4e6bd9[_0xf00e('0xb0')][_0xf00e('0x46')]){_0x3bac9e=0x1;}if(!_0x4e6bd9[_0xf00e('0x3d')]){throw new Error(_0xf00e('0xb2'));}}catch(_0x341af7){throw new Error(_0xf00e('0xb3'));}var _0x50fa61=[];try{_0x50fa61=_[_0xf00e('0xb4')](JSON[_0xf00e('0x7a')](process[_0xf00e('0xac')][0x4]),'id');}catch(_0x1ab614){logger[_0xf00e('0x57')](_0xf00e('0xb5'));}main(_0x55ea13,_0x4e6bd9,_0x50fa61,_0x3bac9e);}validate();process['on']('SIGINT',handleStop);process['on'](_0xf00e('0xb6'),handleUncaughtException);
\ No newline at end of file
+var _0x21cf=['unlink','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','phone\x20is\x20mandatory','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','No\x20agent\x20available','SIGINT','uncaughtException','lodash','papaparse','util','bluebird','../../../mysqldb','../../../config/logger','import','defaults','localhost','socket.io-emitter','redis','format','YYYY-MM-DD\x20HH:mm:ss','test','select','phone','from','join','.id\x20=\x20','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','CmContact','findAll','AdditionalPhones','length','push','then','all','isNil','split','filter','CmContactHasItem','findOne','update','updated','PHONE','inserted','cm_contacts.phone','cm_contacts.id','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.updatedAt','cm_contacts.UserId','insert','into','cm_hopper','fromQuery','scheduledat','ContactId','ListId','createdAt','priority','UserId','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22onlyIfOpen\x22','\x22always\x22','cm_hopper_black','updatedAt','field','ListId\x20=\x20?','toString','date_add(cm_contacts.scheduledat,interval\x20','.offset-cm_contacts.utcOffset\x20minute)','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','CmHopperId','OrderBy','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contact_has_items','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId','scheduledAt','MIN(id)','group','info','message','exit','errors','code','query','error','campaigns.id','campaigns','campaigns_has_cm_lists','campaigns.id\x20=\x20campaigns_has_cm_lists.CampaignId','sequelize','spread','catch','voice_queues.id','voice_queues.dialTimezone','voice_queues','voice_queues.id\x20=\x20voice_queues_has_cm_lists.VoiceQueueId','voice_queues_has_cm_lists.CmListId=','dialTimezone','utcOffset','set','offset','main','stringify','send','binding','clone','socket_timestamp','root','server/files/tmp','.csv','includes','name','_description','header','writeFileSync','parse','data','rows','find','hasOwnProperty','trim','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','agent\x20not\x20exists','email','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','timezones','firstName','\x20not\x20specified','replace','description','SystemRow','contact:import:','Abort\x20parser','abort','SystemError','duplicates','cm_contacts_','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','campaigns_','voice_queues_','(id\x20int,dialTimezone\x20varchar(255),offset\x20int);','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','DROP\x20TABLE\x20','each','contactId','voice_queues_has_cm_lists','voice_queues_has_cm_blacklists','VoiceQueueId','CampaignId','campaigns_has_cm_blacklists','finish','affectedRows','emit'];(function(_0x650c7f,_0x1704b7){var _0x1bc89e=function(_0x4d1cdc){while(--_0x4d1cdc){_0x650c7f['push'](_0x650c7f['shift']());}};_0x1bc89e(++_0x1704b7);}(_0x21cf,0xc5));var _0xf21c=function(_0x313f3a,_0x26a9d3){_0x313f3a=_0x313f3a-0x0;var _0x2f94ff=_0x21cf[_0x313f3a];return _0x2f94ff;};'use strict';var fs=require('fs');var path=require('path');var _=require(_0xf21c('0x0'));var Papa=require(_0xf21c('0x1'));var util=require(_0xf21c('0x2'));var BPromise=require(_0xf21c('0x3'));var moment=require('moment');var squel=require('squel');var Redis=require('ioredis');var db=require(_0xf21c('0x4'))['db'];var config=require('../../../config/environment');var shared=require('../../../config/environment/shared');var logger=require(_0xf21c('0x5'))(_0xf21c('0x6'));config['redis']=_[_0xf21c('0x7')](config['redis'],{'host':_0xf21c('0x8'),'port':0x18eb});var socket=require(_0xf21c('0x9'))(new Redis(config[_0xf21c('0xa')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()[_0xf21c('0xb')](_0xf21c('0xc'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];var tmp_voice_queues;var tmp_campaigns;var tzOffset=0x0;var hasTZ;var NOW=moment()[_0xf21c('0xb')](_0xf21c('0xc'));function isEmail(_0x1ded14){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))*$/[_0xf21c('0xd')](_0x1ded14);}function selectNotIn(_0x36660a,_0x4f757b,_0x4ef846,_0x944ff9,_0x13a9da){return squel[_0xf21c('0xe')]()['field'](_0xf21c('0xf'))[_0xf21c('0x10')](_0x944ff9)[_0xf21c('0x11')](_0x4f757b,null,_0x4f757b+_0xf21c('0x12')+_0x944ff9+'.'+_0x4ef846)['where'](_0x944ff9+'.'+_0x4ef846+_0xf21c('0x13')+_0x36660a+'.'+_0x4ef846)[_0xf21c('0x14')](_0x4f757b+_0xf21c('0x15')+_0x13a9da[_0xf21c('0x11')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x3d8ff9,_0x2d13e8){promisesAdditionalPhones=[];return db[_0xf21c('0x16')][_0xf21c('0x17')]({'raw':!![],'attributes':['id',_0xf21c('0x18')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})['then'](function(_0x517bba){if(_0x517bba!==null){var _0xa491a4=[];for(var _0x50ce39=0x0;_0x50ce39<_0x517bba[_0xf21c('0x19')];_0x50ce39++){var _0x34044f=_0x517bba[_0x50ce39];_0xa491a4[_0xf21c('0x1a')](insertAdditionalPhones(_0x34044f));}}Promise['all'](_0xa491a4)[_0xf21c('0x1b')](function(){_0x3d8ff9({'val':0x1});});});});}function insertAdditionalPhones(_0x2d5681){return new Promise(function(_0x2de19d,_0xc9b857){var _0x17d08d=_0x2d5681[_0xf21c('0x18')];var _0x337b8e=_0x17d08d['split'](';');var _0x2d0d64=[];orderBy=0x0;for(var _0x397c90=0x0;_0x397c90<_0x337b8e[_0xf21c('0x19')];_0x397c90++){_0x2d0d64[_0xf21c('0x1a')](splitAdditionalPhone(_0x2d5681['id'],_0x337b8e[_0x397c90]));}Promise[_0xf21c('0x1c')](_0x2d0d64)[_0xf21c('0x1b')](function(){_0x2de19d({'val':_0x337b8e[_0xf21c('0x19')]});});});}function splitAdditionalPhone(_0x37d20f,_0x5a2d56){return new Promise(function(_0x97d5ee,_0x30b5bc){var _0x45e10c=_0x5a2d56['split'](':');var _0x34e052=_0x45e10c[0x0];var _0x873962=_0x45e10c[0x1];if(!_[_0xf21c('0x1d')](_0x873962)){var _0x35407a=_0x873962[_0xf21c('0x1e')]('|');var _0x1b78a5=[];for(var _0x278323=0x0;_0x278323<_0x35407a[_0xf21c('0x19')];_0x278323++){if(_0x35407a[_0x278323]!==''){var _0x2da248=_[_0xf21c('0x1f')](promisesAdditionalPhones,{'contactId':_0x37d20f,'phone':_0x35407a[_0x278323]});if(_0x2da248[_0xf21c('0x19')]==0x0){orderBy++;promisesAdditionalPhones[_0xf21c('0x1a')]({'contactId':_0x37d20f,'contactTypeId':_0x34e052,'phone':_0x35407a[_0x278323],'orderBy':orderBy});}}}_0x97d5ee({'ok':0x1});}else _0x97d5ee({'res':0x0});});}function createAdditionalPhone(_0x5d6153,_0x5e9e60,_0x5891e6,_0x53861c){var _0x3ccf5a='';var _0x4c5887='';var _0x12a7bf=_0x5891e6[_0xf21c('0x1e')]('§');_0x3ccf5a=_0x12a7bf[0x0];if(_0x12a7bf[_0xf21c('0x19')]==0x2)_0x4c5887=_0x12a7bf[0x1];return new Promise(function(_0x3978f3,_0x4a4a70){return db[_0xf21c('0x20')][_0xf21c('0x21')]({'where':{'CmContactId':_0x5d6153,'item':_0x3ccf5a}})[_0xf21c('0x1b')](function(_0x533255){if(_0x533255){return db[_0xf21c('0x20')][_0xf21c('0x22')]({'ItemTypeId':_0x5e9e60,'description':_0x4c5887,'OrderBy':_0x53861c},{'where':{'CmContactId':_0x5d6153,'item':_0x3ccf5a}})['then'](function(_0x2b7010){_0x3978f3({'res':_0xf21c('0x23')});});}else{return db['CmContactHasItem']['create']({'CmContactId':_0x5d6153,'item':_0x3ccf5a,'description':_0x4c5887,'ItemTypeId':_0x5e9e60,'OrderBy':_0x53861c,'ItemClass':_0xf21c('0x24')})[_0xf21c('0x1b')](function(_0x2e0fc6){_0x3978f3({'res':_0xf21c('0x25')});});}});});}function insertCmHopper(_0x25bff2,_0x951e3,_0x237877,_0xb22a7c,_0x1601d){var _0x211fe1=[_0xf21c('0x26'),'cm_contacts.scheduledat',_0xf21c('0x27'),_0xf21c('0x28'),_0x951e3+'.'+_0xb22a7c,_0xf21c('0x29'),_0xf21c('0x2a'),'cm_contacts.priority',_0xf21c('0x2b'),'\x22'+_0x1601d+'\x22'];return squel[_0xf21c('0x2c')]()[_0xf21c('0x2d')](_0xf21c('0x2e'))[_0xf21c('0x2f')]([_0xf21c('0xf'),_0xf21c('0x30'),_0xf21c('0x31'),_0xf21c('0x32'),_0xb22a7c,_0xf21c('0x33'),'updatedAt',_0xf21c('0x34'),_0xf21c('0x35'),'recallme'],squel['select']()[_0xf21c('0x36')](_0x211fe1)[_0xf21c('0x10')](_0x951e3)[_0xf21c('0x11')](_0xf21c('0x37'),null,_0xf21c('0x38')+_0x951e3+_0xf21c('0x39'))[_0xf21c('0x11')](_0x237877,null,_0x237877+_0xf21c('0x12')+_0x951e3+'.'+_0xb22a7c)[_0xf21c('0x14')](_0x951e3+_0xf21c('0x3a'),_0x25bff2)[_0xf21c('0x14')](_0xf21c('0x3b'),NOW)['where'](_0xf21c('0x3c'),selectNotIn(_0x951e3,_0x237877,_0xb22a7c,_0xf21c('0x2e'),['\x22always\x22',_0xf21c('0x3d')]))[_0xf21c('0x14')](_0xf21c('0x3c'),selectNotIn(_0x951e3,_0x237877,_0xb22a7c,_0xf21c('0x2e'),[_0xf21c('0x3e')])))['toString']();}function insertCmHopperBlack(_0x7fee33,_0x5e9a7b,_0x2cac7c,_0x2844f5){var _0x18dd60=[_0xf21c('0x26'),_0xf21c('0x27'),_0xf21c('0x28'),_0x5e9a7b+'.'+_0x2844f5,_0xf21c('0x29'),_0xf21c('0x2a')];return squel[_0xf21c('0x2c')]()[_0xf21c('0x2d')](_0xf21c('0x3f'))[_0xf21c('0x2f')]([_0xf21c('0xf'),_0xf21c('0x31'),_0xf21c('0x32'),_0x2844f5,_0xf21c('0x33'),_0xf21c('0x40')],squel[_0xf21c('0xe')]()[_0xf21c('0x36')](_0x18dd60)[_0xf21c('0x10')](_0x5e9a7b)[_0xf21c('0x11')]('cm_contacts',null,'cm_contacts.ListId\x20=\x20'+_0x5e9a7b+_0xf21c('0x39'))[_0xf21c('0x11')](_0x2cac7c,null,_0x2cac7c+_0xf21c('0x12')+_0x5e9a7b+'.'+_0x2844f5)[_0xf21c('0x14')](_0x5e9a7b+_0xf21c('0x3a'),_0x7fee33)[_0xf21c('0x14')](_0xf21c('0x3b'),NOW)[_0xf21c('0x14')](_0xf21c('0x3c'),squel[_0xf21c('0xe')]()[_0xf21c('0x41')]('phone')['from'](_0xf21c('0x3f'))['where'](_0xf21c('0x42'),_0x7fee33)['where'](_0x2844f5+_0xf21c('0x13')+_0x5e9a7b+'.'+_0x2844f5)))[_0xf21c('0x43')]();}function insertTzCmHopper(_0x374657,_0xe985e5,_0x52dec5,_0x26f3d5,_0x1a5567,_0x18ed9c){var _0xf62f92=[_0xf21c('0x26'),_0xf21c('0x44')+_0x18ed9c+_0xf21c('0x45'),'cm_contacts.id',_0xf21c('0x28'),_0xe985e5+'.'+_0x26f3d5,'cm_contacts.createdAt',_0xf21c('0x2a'),'cm_contacts.priority','cm_contacts.UserId','\x22'+_0x1a5567+'\x22'];var _0x48ad54=squel[_0xf21c('0x2c')]()[_0xf21c('0x2d')](_0xf21c('0x2e'))[_0xf21c('0x2f')]([_0xf21c('0xf'),_0xf21c('0x30'),_0xf21c('0x31'),_0xf21c('0x32'),_0x26f3d5,_0xf21c('0x33'),_0xf21c('0x40'),_0xf21c('0x34'),'UserId','recallme'],squel[_0xf21c('0xe')]()[_0xf21c('0x36')](_0xf62f92)[_0xf21c('0x10')](_0xe985e5)[_0xf21c('0x11')]('cm_contacts',null,_0xf21c('0x38')+_0xe985e5+_0xf21c('0x39'))[_0xf21c('0x11')](_0x52dec5,null,_0x52dec5+_0xf21c('0x12')+_0xe985e5+'.'+_0x26f3d5)[_0xf21c('0x11')](_0x18ed9c,null,_0x18ed9c+'.id\x20=\x20'+_0xe985e5+'.'+_0x26f3d5)[_0xf21c('0x14')](_0xe985e5+_0xf21c('0x3a'),_0x374657)[_0xf21c('0x14')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0xf21c('0x14')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0xe985e5,_0x52dec5,_0x26f3d5,_0xf21c('0x2e'),[_0xf21c('0x3e'),_0xf21c('0x3d')]))[_0xf21c('0x14')](_0xf21c('0x3c'),selectNotIn(_0xe985e5,_0x52dec5,_0x26f3d5,_0xf21c('0x2e'),['\x22always\x22'])))[_0xf21c('0x43')]();return _0x48ad54;}function insertTzCmHopperBlack(_0x7d15f5,_0x318daf,_0xf9e849,_0x413cd3){var _0x38238d=[_0xf21c('0x26'),'cm_contacts.id',_0xf21c('0x28'),_0x318daf+'.'+_0x413cd3,_0xf21c('0x29'),_0xf21c('0x2a')];return squel[_0xf21c('0x2c')]()[_0xf21c('0x2d')]('cm_hopper_black')['fromQuery'](['phone',_0xf21c('0x31'),_0xf21c('0x32'),_0x413cd3,_0xf21c('0x33'),_0xf21c('0x40')],squel['select']()[_0xf21c('0x36')](_0x38238d)[_0xf21c('0x10')](_0x318daf)[_0xf21c('0x11')](_0xf21c('0x37'),null,_0xf21c('0x38')+_0x318daf+'.CmListId')[_0xf21c('0x11')](_0xf9e849,null,_0xf9e849+_0xf21c('0x12')+_0x318daf+'.'+_0x413cd3)[_0xf21c('0x14')](_0x318daf+_0xf21c('0x3a'),_0x7d15f5)['where'](_0xf21c('0x3b'),NOW)[_0xf21c('0x14')](_0xf21c('0x3c'),squel[_0xf21c('0xe')]()['field'](_0xf21c('0xf'))[_0xf21c('0x10')]('cm_hopper_black')[_0xf21c('0x14')](_0xf21c('0x42'),_0x7d15f5)[_0xf21c('0x14')](_0x413cd3+_0xf21c('0x13')+_0x318daf+'.'+_0x413cd3)))['toString']();}function insertCmHopperAdditionalPhones(_0x86adf1){var _0x32298a=[_0xf21c('0x46'),_0xf21c('0x47'),_0xf21c('0x48'),_0xf21c('0x49'),_0xf21c('0x4a')];return squel['insert']()[_0xf21c('0x2d')](_0xf21c('0x4b'))[_0xf21c('0x2f')]([_0xf21c('0x4c'),_0xf21c('0xf'),_0xf21c('0x4d'),'createdAt',_0xf21c('0x40')],squel[_0xf21c('0xe')]()[_0xf21c('0x36')](_0x32298a)['from']('cm_hopper')[_0xf21c('0x11')](_0xf21c('0x37'),null,_0xf21c('0x4e'))[_0xf21c('0x11')](_0xf21c('0x4f'),null,_0xf21c('0x50'))[_0xf21c('0x14')](_0xf21c('0x51'),_0x86adf1)[_0xf21c('0x14')](_0xf21c('0x3b'),NOW))[_0xf21c('0x43')]();}function insertCmContact(_0x3eb040,_0x43746a,_0x4a41d8,_0x371854){var _0xfbb8b9=_[_0xf21c('0x52')](_[_0xf21c('0x53')](_0x371854),[_0xf21c('0x32'),_0xf21c('0x54'),_0xf21c('0x33'),_0xf21c('0x40'),_0xf21c('0x55')]);return squel['insert']()[_0xf21c('0x2d')](_0xf21c('0x37'))[_0xf21c('0x2f')](_0xfbb8b9,squel[_0xf21c('0xe')]()[_0xf21c('0x36')](_0xfbb8b9)[_0xf21c('0x10')](_0x43746a)[_0xf21c('0x14')]('('+_0x4a41d8[_0xf21c('0x11')](',')+')\x20NOT\x20IN\x20?',squel[_0xf21c('0xe')]()[_0xf21c('0x36')](_0x4a41d8)['from'](_0xf21c('0x37'))[_0xf21c('0x14')](_0xf21c('0x42'),_0x3eb040)[_0xf21c('0x14')]('deletedAt\x20IS\x20NULL'))['where']('id\x20IN\x20?',squel[_0xf21c('0xe')]()[_0xf21c('0x41')](_0xf21c('0x56'),'min_id')['from'](_0x43746a)[_0xf21c('0x57')](_0x4a41d8[_0xf21c('0x11')](','))))[_0xf21c('0x43')]();}function handleStop(){logger[_0xf21c('0x58')]('Received\x20SIGINT');stopped=!![];}function handleUncaughtException(_0x2952cf){logger['error'](_0x2952cf[_0xf21c('0x59')]);process[_0xf21c('0x5a')](0x1);}function handleError(_0x1d0cfe,_0x5525c0){stats[_0xf21c('0x5b')][_0xf21c('0x1a')]({'name':_0x5525c0[_0xf21c('0x5c')],'message':_0x5525c0['message'],'row':_0x1d0cfe});}function handleQuery(_0x179a22){logger[_0xf21c('0x58')](_0x179a22);return db['sequelize'][_0xf21c('0x5d')](_0x179a22)['spread'](function(_0x3cd0de){results[_0xf21c('0x1a')](_0x3cd0de);})['catch'](function(_0x4fb335){logger[_0xf21c('0x5e')](_0x4fb335[_0xf21c('0x59')]);});}function updateTzCampaigns(_0x540bbe){return new Promise(function(_0x1d9865,_0x500124){var _0x467c21=squel['select']()[_0xf21c('0x36')]([_0xf21c('0x5f'),'campaigns.dialTimezone'])[_0xf21c('0x10')](_0xf21c('0x60'))['join'](_0xf21c('0x61'),null,_0xf21c('0x62'))['where']('campaigns_has_cm_lists.CmListId='+_0x540bbe);db[_0xf21c('0x63')][_0xf21c('0x5d')](_0x467c21[_0xf21c('0x43')]())[_0xf21c('0x64')](function(_0x4dca2f){var _0x38f8c4=[];for(var _0x1af902=0x0;_0x1af902<_0x4dca2f[_0xf21c('0x19')];_0x1af902++){_0x38f8c4[_0xf21c('0x1a')](getTimezoneData(_0x4dca2f[_0x1af902],tmp_campaigns));}BPromise[_0xf21c('0x1c')](_0x38f8c4)['then'](function(){_0x1d9865({'val':0x1});});})[_0xf21c('0x65')](function(_0x1fd7d4){logger[_0xf21c('0x5e')](_0x1fd7d4[_0xf21c('0x59')]);_0x1d9865({'val':0x0});});});}function updateTzVoiceQueues(_0x4da5b){return new Promise(function(_0x4410df,_0x3581e4){var _0xcf2174=squel[_0xf21c('0xe')]()['fields']([_0xf21c('0x66'),_0xf21c('0x67')])[_0xf21c('0x10')](_0xf21c('0x68'))[_0xf21c('0x11')]('voice_queues_has_cm_lists',null,_0xf21c('0x69'))[_0xf21c('0x14')](_0xf21c('0x6a')+_0x4da5b);db[_0xf21c('0x63')]['query'](_0xcf2174[_0xf21c('0x43')]())['spread'](function(_0x339435){var _0x541e32=[];for(var _0x5700ab=0x0;_0x5700ab<_0x339435['length'];_0x5700ab++){_0x541e32[_0xf21c('0x1a')](getTimezoneData(_0x339435[_0x5700ab],tmp_voice_queues));}BPromise[_0xf21c('0x1c')](_0x541e32)[_0xf21c('0x1b')](function(){_0x4410df({'val':0x1});});})['catch'](function(_0x6e7f50){logger['error'](_0x6e7f50[_0xf21c('0x59')]);_0x4410df({'val':0x0});});});}function getTimezoneData(_0x1144bf,_0x2685e5){return new Promise(function(_0x1ae7af,_0x109763){var _0x1c9021=shared['timezones'];var _0x5a96be=_0x1c9021[_0x1144bf[_0xf21c('0x6b')]];if(_[_0xf21c('0x1d')](_0x5a96be)){_0x1ae7af({'ret':0x1});}else{var _0x485bb6=_0x5a96be[_0xf21c('0x6c')];var _0x2b587e=squel[_0xf21c('0x2c')]()[_0xf21c('0x2d')](_0x2685e5)['set']('id',_0x1144bf['id'])[_0xf21c('0x6d')](_0xf21c('0x6e'),_0x485bb6)['set'](_0xf21c('0x6b'),_0x1144bf[_0xf21c('0x6b')])['toString']();return db['sequelize'][_0xf21c('0x5d')](_0x2b587e)[_0xf21c('0x64')](function(_0x30e9d3){_0x1ae7af({'ret':0x1});})[_0xf21c('0x65')](function(_0x18b388){logger[_0xf21c('0x5e')](_0x18b388['message']);_0x109763({'ret':0x1});});}});}function handleTZQuery(_0x7ce1fd){logger[_0xf21c('0x58')](_0x7ce1fd);return db['sequelize'][_0xf21c('0x5d')](_0x7ce1fd)[_0xf21c('0x64')](function(_0x51d0e9){})[_0xf21c('0x65')](function(_0x1ca3e0){logger[_0xf21c('0x5e')](_0x1ca3e0[_0xf21c('0x59')]);});}function main(_0x119d52,_0x1f2e42,_0x5a4d47,_0x57c88c){logger[_0xf21c('0x58')](_0xf21c('0x6f'),_0x119d52,JSON[_0xf21c('0x70')](_0x1f2e42));process[_0xf21c('0x71')]('start');var _0x3224ca=_0x1f2e42[_0xf21c('0x72')];var _0x2e91e2=_[_0xf21c('0x73')](_0x3224ca);var _0x1501eb=_0x1f2e42[_0xf21c('0x74')];var _0x24d814=path[_0xf21c('0x11')](config[_0xf21c('0x75')],_0xf21c('0x76'),_0x1501eb+_0xf21c('0x77'));hasTZ=_[_0xf21c('0x53')](_0x3224ca)[_0xf21c('0x78')](_0xf21c('0x6b'));var _0xfffb2=_['keys'](_0x3224ca)[_0xf21c('0x11')]();logger[_0xf21c('0x58')]('header',_0xfffb2);db['ContactItemType']['findAll']({'raw':!![],'attributes':['id',_0xf21c('0x79')]})[_0xf21c('0x1b')](function(_0x6dc80c){for(var _0x10e9db=0x0;_0x10e9db<_0x6dc80c[_0xf21c('0x19')];_0x10e9db++){if(_0x6dc80c[_0x10e9db][_0xf21c('0x79')]in _0x3224ca){contactItemTypes[_0xf21c('0x1a')](_0x6dc80c[_0x10e9db]);delete _0x2e91e2[_0x6dc80c[_0x10e9db][_0xf21c('0x79')]];hasAdditionalPhones=!![];}for(var _0x1f66b5 in _0x3224ca){if(_0x6dc80c[_0x10e9db]['name']+_0xf21c('0x7a')===_0x1f66b5){phoneDescriptions[_0xf21c('0x1a')]({'itemTypeId':_0x6dc80c[_0x10e9db]['id'],'description':_0x1f66b5});delete _0x2e91e2[_0x1f66b5];}}}if(hasAdditionalPhones)_0x2e91e2[_0xf21c('0x18')]='';var _0x2c965=_[_0xf21c('0x53')](_0x2e91e2)[_0xf21c('0x11')]();logger['info'](_0xf21c('0x7b'),_0x2c965);fs[_0xf21c('0x7c')](_0x24d814,_0x2c965+'\x0a');Papa[_0xf21c('0x7d')](fs['createReadStream'](_0x119d52),{'header':!![],'skipEmptyLines':!![],'step':function(_0x5349e4,_0x2f072e){try{for(var _0x505886=0x0,_0x46dd1c=[];_0x505886<_0x5349e4[_0xf21c('0x7e')][_0xf21c('0x19')];_0x505886++){stats[_0xf21c('0x7f')]+=0x1;if(_0x5349e4['errors'][_0x505886]){handleError(_0x5349e4[_0xf21c('0x7e')][_0x505886],_0x5349e4[_0xf21c('0x5b')][_0x505886]);}else{var _0x5d0add=[];var _0x380c6d=[];var _0x24a17b={};for(var _0x279cd1 in _0x3224ca){let _0x3df5be=contactItemTypes[_0xf21c('0x80')](_0x47964c=>_0x47964c[_0xf21c('0x79')]===_0x279cd1);let _0x5f068b=contactItemTypes[_0xf21c('0x80')](_0x583a9e=>_0x583a9e['name']+'_description'===_0x279cd1);if(_['isNil'](_0x3df5be)&&_['isNil'](_0x5f068b)){if(_0x3224ca[_0xf21c('0x81')](_0x279cd1)){if(_0x5349e4['data'][_0x505886][_0x3224ca[_0x279cd1]]){var _0x4ec90e=_[_0xf21c('0x82')](_0x5349e4[_0xf21c('0x7e')][_0x505886][_0x3224ca[_0x279cd1]]['replace'](/"/g,'\x27'));switch(_0x279cd1){case _0xf21c('0x30'):var _0x566927=moment(_0x4ec90e,_0xf21c('0xc'),!![]);if(_0x566927[_0xf21c('0x83')]()){_0x46dd1c['push']('\x22'+_0x4ec90e+'\x22');}else{_0x5d0add['push'](_0xf21c('0x84'));}break;case _0xf21c('0x34'):var _0x2e7916=parseInt(_0x4ec90e);_0x4ec90e=_[_0xf21c('0x85')](_0x2e7916)||_0x2e7916<0x0||_0x2e7916>0x4?_0x57c88c?0x3:0x2:_0x2e7916;_0x46dd1c['push']('\x22'+_0x4ec90e+'\x22');break;case _0xf21c('0x35'):var _0x438f9d=parseInt(_0x4ec90e);if(_[_0xf21c('0x86')](_0x438f9d)&&_[_0xf21c('0x78')](_0x5a4d47,_0x438f9d)){_0x46dd1c[_0xf21c('0x1a')]('\x22'+_0x438f9d+'\x22');}else{_0x5d0add[_0xf21c('0x1a')](_0xf21c('0x87'));}break;case _0xf21c('0x88'):if(isEmail(_0x4ec90e)){_0x46dd1c[_0xf21c('0x1a')]('\x22'+_0x4ec90e+'\x22');}else{_0x5d0add[_0xf21c('0x1a')](_0xf21c('0x89'));}break;case _0xf21c('0x8a'):var _0x27c0e6=moment(_0x4ec90e,_0xf21c('0x8b'),!![]);if(_0x27c0e6[_0xf21c('0x83')]()){_0x46dd1c['push']('\x22'+_0x4ec90e+'\x22');}else{_0x5d0add['push']('dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)');}break;case'dialTimezone':var _0x1eb894=shared[_0xf21c('0x8c')];var _0xcbc430=_0x1eb894[_0x4ec90e];if(!_[_0xf21c('0x1d')](_0xcbc430)){var _0x599a70=_0xcbc430[_0xf21c('0x6c')];_0x46dd1c['push']('\x22'+_0x4ec90e+'\x22');_0x46dd1c[_0xf21c('0x1a')]('\x22'+_0x599a70+'\x22');}break;default:_0x46dd1c[_0xf21c('0x1a')]('\x22'+_0x4ec90e+'\x22');}}else{switch(_0x279cd1){case _0xf21c('0x8d'):case _0xf21c('0xf'):_0x5d0add[_0xf21c('0x1a')](_0x279cd1+_0xf21c('0x8e'));break;default:_0x46dd1c[_0xf21c('0x1a')]('\x22\x22');}}}}else{var _0x546d56='';if(!_['isNil'](_0x3df5be)){if(!_0x24a17b[_0xf21c('0x81')](_0x3df5be['id'])){if(!_['isNil'](_0x5349e4[_0xf21c('0x7e')][_0x505886][_0x3224ca[_0x279cd1]])){var _0x4ec90e=_[_0xf21c('0x82')](_0x5349e4[_0xf21c('0x7e')][_0x505886][_0x3224ca[_0x279cd1]][_0xf21c('0x8f')](/"/g,'\x27'));var _0x5a77e3=phoneDescriptions[_0xf21c('0x80')](_0x3fe659=>_0x3fe659['itemTypeId']===_0x3df5be['id']);if(!_['isNil'](_0x5a77e3)){var _0x308498=_[_0xf21c('0x82')](_0x5349e4[_0xf21c('0x7e')][_0x505886][_0x3224ca[_0x5a77e3[_0xf21c('0x90')]]][_0xf21c('0x8f')](/"/g,'\x27'));if(!_[_0xf21c('0x1d')](_0x308498))_0x4ec90e=_0x4ec90e+'§'+_0x308498;}if(_0x546d56=='')_0x546d56=_0x4ec90e;else _0x546d56+='|'+_0x4ec90e;}_0x380c6d[_0xf21c('0x1a')](_0x3df5be['id']+':'+_0x546d56);_0x24a17b[_0x3df5be['id']]=0x1;}}}}if(hasAdditionalPhones){_0x46dd1c['push']('\x22'+_0x380c6d[_0xf21c('0x11')](';')+'\x22');}if(_0x5d0add['length']){handleError(_0x5349e4[_0xf21c('0x7e')][_0x505886],{'code':_0xf21c('0x91'),'message':_0x5d0add[_0xf21c('0x11')]()});}else{fs['appendFileSync'](_0x24d814,_0x46dd1c[_0xf21c('0x11')]()+'\x0a');}_0x46dd1c=[];}if(!(stats[_0xf21c('0x7f')]%0xc8)){socket['emit'](_0xf21c('0x92')+_0x1501eb,stats);stats[_0xf21c('0x5b')]=[];}}if(stopped){logger[_0xf21c('0x58')](_0xf21c('0x93'));_0x2f072e[_0xf21c('0x94')]();}}catch(_0x14bca7){handleError(_0x5349e4[_0xf21c('0x7e')][_0x505886],{'code':_0xf21c('0x95'),'message':_0x14bca7['message']});logger[_0xf21c('0x5e')]('step',_0x14bca7[_0xf21c('0x59')]);}},'complete':function(){try{var _0x308379=[];var _0x5660f8=[];var _0x2da3a9=_0xf21c('0x37');if(_0x1f2e42[_0xf21c('0x96')]&&_0x1f2e42[_0xf21c('0x96')][_0xf21c('0x19')]){_0x2da3a9=_0xf21c('0x97')+_0x1501eb;_0x308379[_0xf21c('0x1a')](_0xf21c('0x98')+_0x2da3a9+_0xf21c('0x99'));}tmp_campaigns=_0xf21c('0x9a')+_0x1501eb;tmp_voice_queues=_0xf21c('0x9b')+_0x1501eb;_0x5660f8['push']('CREATE\x20TABLE\x20'+tmp_campaigns+_0xf21c('0x9c'));_0x5660f8[_0xf21c('0x1a')](_0xf21c('0x98')+tmp_voice_queues+_0xf21c('0x9c'));BPromise['each'](_0x5660f8,handleTZQuery)[_0xf21c('0x1b')](function(_0x4ceb8e){updateTzCampaigns(_0x1f2e42[_0xf21c('0x32')])['then'](function(_0x36840b){updateTzVoiceQueues(_0x1f2e42[_0xf21c('0x32')])[_0xf21c('0x1b')](function(_0x5411b4){if(hasTZ)_0x2c965=_0x2c965['replace']('dialTimezone','dialTimezone,utcOffset');var _0x278db5=util[_0xf21c('0xb')](_0xf21c('0x9d'),_0x24d814,_0x2da3a9,_0x2c965,_0x1f2e42[_0xf21c('0x32')],_0x1f2e42['CompanyId']||null,NOW,NOW);if(_[_0xf21c('0x1d')](_0x3224ca['scheduledat'])){_0x278db5+=',\x20scheduledAt\x20=\x20NOW()';}_0x308379[_0xf21c('0x1a')](_0x278db5);if(_0x1f2e42['duplicates']&&_0x1f2e42[_0xf21c('0x96')][_0xf21c('0x19')]){_0x308379[_0xf21c('0x1a')](insertCmContact(_0x1f2e42[_0xf21c('0x32')],_0x2da3a9,_0x1f2e42[_0xf21c('0x96')],_0x3224ca));_0x308379[_0xf21c('0x1a')](_0xf21c('0x9e')+_0x2da3a9+';');}BPromise[_0xf21c('0x9f')](_0x308379,handleQuery)['then'](function(_0x5bdc9e){BPromise['all']([handleAdditionalPhones()])[_0xf21c('0x1b')](function(){_0x308379=[];for(var _0x15f2f4=0x0;_0x15f2f4<promisesAdditionalPhones[_0xf21c('0x19')];_0x15f2f4++){if(promisesAdditionalPhones[_0x15f2f4]['phone']!='§'){_0x308379[_0xf21c('0x1a')](createAdditionalPhone(promisesAdditionalPhones[_0x15f2f4][_0xf21c('0xa0')],promisesAdditionalPhones[_0x15f2f4]['contactTypeId'],promisesAdditionalPhones[_0x15f2f4]['phone'],promisesAdditionalPhones[_0x15f2f4]['orderBy']));}}BPromise[_0xf21c('0x1c')](_0x308379)[_0xf21c('0x1b')](function(){_0x308379=[];if(hasTZ){_0x308379['push'](insertTzCmHopper(_0x1f2e42[_0xf21c('0x32')],_0xf21c('0xa1'),_0xf21c('0x68'),'VoiceQueueId',_0x57c88c,tmp_voice_queues));_0x308379[_0xf21c('0x1a')](insertTzCmHopperBlack(_0x1f2e42[_0xf21c('0x32')],_0xf21c('0xa2'),_0xf21c('0x68'),_0xf21c('0xa3')));_0x308379[_0xf21c('0x1a')](insertTzCmHopper(_0x1f2e42[_0xf21c('0x32')],_0xf21c('0x61'),_0xf21c('0x60'),_0xf21c('0xa4'),_0x57c88c,tmp_campaigns));_0x308379[_0xf21c('0x1a')](insertTzCmHopperBlack(_0x1f2e42[_0xf21c('0x32')],_0xf21c('0xa5'),_0xf21c('0x60'),_0xf21c('0xa4')));_0x308379[_0xf21c('0x1a')](insertCmHopperAdditionalPhones(_0x1f2e42['ListId']));}else{_0x308379[_0xf21c('0x1a')](insertCmHopper(_0x1f2e42[_0xf21c('0x32')],'voice_queues_has_cm_lists','voice_queues',_0xf21c('0xa3'),_0x57c88c));_0x308379[_0xf21c('0x1a')](insertCmHopperBlack(_0x1f2e42[_0xf21c('0x32')],'voice_queues_has_cm_blacklists',_0xf21c('0x68'),'VoiceQueueId'));_0x308379[_0xf21c('0x1a')](insertCmHopper(_0x1f2e42[_0xf21c('0x32')],'campaigns_has_cm_lists',_0xf21c('0x60'),_0xf21c('0xa4'),_0x57c88c));_0x308379['push'](insertCmHopperBlack(_0x1f2e42[_0xf21c('0x32')],_0xf21c('0xa5'),_0xf21c('0x60'),_0xf21c('0xa4')));_0x308379[_0xf21c('0x1a')](insertCmHopperAdditionalPhones(_0x1f2e42['ListId']));}_0x308379['push'](_0xf21c('0x9e')+tmp_campaigns+';');_0x308379[_0xf21c('0x1a')](_0xf21c('0x9e')+tmp_voice_queues+';');BPromise[_0xf21c('0x9f')](_0x308379,handleQuery)[_0xf21c('0x1b')](function(_0x41f1b0){stats[_0xf21c('0xa6')]=!![];stats[_0xf21c('0xa7')]=_0x1f2e42[_0xf21c('0x96')]&&_0x1f2e42['duplicates'][_0xf21c('0x19')]?results[0x2][_0xf21c('0xa7')]:results[0x0][_0xf21c('0xa7')];socket[_0xf21c('0xa8')](_0xf21c('0x92')+_0x1501eb,stats);fs[_0xf21c('0xa9')](_0x119d52);fs[_0xf21c('0xa9')](_0x24d814);process[_0xf21c('0x5a')](0x0);})[_0xf21c('0x65')](function(_0x126212){logger['error'](_0x126212['message']);process['exit'](0x1);});});});})[_0xf21c('0x65')](function(_0x51f616){logger['error'](_0x51f616[_0xf21c('0x59')]);process[_0xf21c('0x5a')](0x1);});});});});}catch(_0x31e1c1){logger[_0xf21c('0x5e')](_0xf21c('0xaa'),_0x31e1c1[_0xf21c('0x59')]);process[_0xf21c('0x5a')](0x1);}},'error':function(_0x2f845f,_0x210dc7,_0x2ee8af,_0x3c0c5d){throw new Error(_0x3c0c5d);}});});}function validate(){if(process[_0xf21c('0xab')]&&process[_0xf21c('0xab')]['length']<0x4){throw new Error(_0xf21c('0xac'));}var _0x905c3d=path['join'](config[_0xf21c('0x75')],_0xf21c('0x76'),process[_0xf21c('0xab')][0x2]);if(!fs[_0xf21c('0xad')](_0x905c3d)){throw new Error(_0xf21c('0xae'));}var _0xf9ab80={};try{_0xf9ab80=JSON[_0xf21c('0x7d')](process[_0xf21c('0xab')][0x3]);if(!_0xf9ab80[_0xf21c('0x72')]){throw new Error(_0xf21c('0xaf'));}if(!_0xf9ab80[_0xf21c('0x72')]['phone']){throw new Error(_0xf21c('0xb0'));}if(!_0xf9ab80[_0xf21c('0x72')]['firstName']){throw new Error('firstName\x20is\x20mandatory');}var _0x299f97=0x0;if(_0xf9ab80['binding'][_0xf21c('0x35')]){_0x299f97=0x1;}if(!_0xf9ab80[_0xf21c('0x32')]){throw new Error(_0xf21c('0xb1'));}}catch(_0x43b77d){throw new Error(_0xf21c('0xb2'));}var _0x5cad68=[];try{_0x5cad68=_[_0xf21c('0xb3')](JSON[_0xf21c('0x7d')](process[_0xf21c('0xab')][0x4]),'id');}catch(_0x58999c){logger[_0xf21c('0x58')](_0xf21c('0xb4'));}main(_0x905c3d,_0xf9ab80,_0x5cad68,_0x299f97);}validate();process['on'](_0xf21c('0xb5'),handleStop);process['on'](_0xf21c('0xb6'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff