// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x52ee=['campaigns_has_cm_blacklists','CampaignId','voice_queues_has_cm_blacklists','affectedRows','emit','unlink','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists','binding','binding\x20doesn\x27t\x20exists','firstName','UserId','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','No\x20agent\x20available','path','lodash','util','bluebird','ioredis','../../../mysqldb','../../../config/environment/shared','../../../config/logger','defaults','redis','localhost','YYYY-MM-DD\x20HH:mm:ss','format','test','select','field','phone','from','join','.id\x20=\x20','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','CmContact','findAll','AdditionalPhones','length','push','all','then','split','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','scheduledat','ListId','createdAt','updatedAt','priority','recallme','fields','.CmListId','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','cm_hopper','\x22onlyIfOpen\x22','toString','cm_contacts.ListId','cm_hopper_black','fromQuery','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId\x20=\x20?','date_add(cm_contacts.scheduledat,interval\x20','.offset-cm_contacts.utcOffset\x20minute)','\x22always\x22','ContactId','ListId\x20=\x20?','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_hopper_additional_phones','CmHopperId','OrderBy','cm_contact_has_items','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId','scheduledAt',')\x20NOT\x20IN\x20?','deletedAt\x20IS\x20NULL','id\x20IN\x20?','min_id','group','message','exit','errors','code','info','spread','catch','campaigns.id','campaigns.dialTimezone','campaigns','campaigns_has_cm_lists','campaigns.id\x20=\x20campaigns_has_cm_lists.CampaignId','campaigns_has_cm_lists.CmListId=','sequelize','query','voice_queues.id','voice_queues','voice_queues.id\x20=\x20voice_queues_has_cm_lists.VoiceQueueId','error','dialTimezone','isNil','utcOffset','set','offset','main','stringify','start','clone','socket_timestamp','root','server/files/tmp','ContactItemType','name','writeFileSync','parse','createReadStream','data','rows','find','_description','replace','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','includes','agent\x20not\x20exists','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','\x20not\x20specified','trim','itemTypeId','description','SystemRow','appendFileSync','contact:import:','Abort\x20parser','abort','step','duplicates','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','campaigns_','(id\x20int,dialTimezone\x20varchar(255),offset\x20int);','each','dialTimezone,utcOffset','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','contactTypeId','orderBy','voice_queues_has_cm_lists','VoiceQueueId'];(function(_0x433194,_0x44240a){var _0xc2fac4=function(_0x744f93){while(--_0x744f93){_0x433194['push'](_0x433194['shift']());}};_0xc2fac4(++_0x44240a);}(_0x52ee,0xc9));var _0xe52e=function(_0x1d8b9c,_0xc2cdd3){_0x1d8b9c=_0x1d8b9c-0x0;var _0x459bf4=_0x52ee[_0x1d8b9c];return _0x459bf4;};'use strict';var fs=require('fs');var path=require(_0xe52e('0x0'));var _=require(_0xe52e('0x1'));var Papa=require('papaparse');var util=require(_0xe52e('0x2'));var BPromise=require(_0xe52e('0x3'));var moment=require('moment');var squel=require('squel');var Redis=require(_0xe52e('0x4'));var db=require(_0xe52e('0x5'))['db'];var config=require('../../../config/environment');var shared=require(_0xe52e('0x6'));var logger=require(_0xe52e('0x7'))('import');config['redis']=_[_0xe52e('0x8')](config[_0xe52e('0x9')],{'host':_0xe52e('0xa'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xe52e('0x9')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()['format'](_0xe52e('0xb'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];var tmp_voice_queues;var tmp_campaigns;var tzOffset=0x0;var hasTZ;var NOW=moment()[_0xe52e('0xc')](_0xe52e('0xb'));function isEmail(_0x2a7b1c){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))*$/[_0xe52e('0xd')](_0x2a7b1c);}function selectNotIn(_0x427883,_0x489b82,_0x1ffa2f,_0x3f0ab4,_0x402a0a){return squel[_0xe52e('0xe')]()[_0xe52e('0xf')](_0xe52e('0x10'))[_0xe52e('0x11')](_0x3f0ab4)[_0xe52e('0x12')](_0x489b82,null,_0x489b82+_0xe52e('0x13')+_0x3f0ab4+'.'+_0x1ffa2f)['where'](_0x3f0ab4+'.'+_0x1ffa2f+_0xe52e('0x14')+_0x427883+'.'+_0x1ffa2f)[_0xe52e('0x15')](_0x489b82+_0xe52e('0x16')+_0x402a0a[_0xe52e('0x12')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x29f6c6,_0x10f8ee){promisesAdditionalPhones=[];return db[_0xe52e('0x17')][_0xe52e('0x18')]({'raw':!![],'attributes':['id',_0xe52e('0x19')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})['then'](function(_0x2adf72){if(_0x2adf72!==null){var _0x12074c=[];for(var _0x1a2450=0x0;_0x1a2450<_0x2adf72[_0xe52e('0x1a')];_0x1a2450++){var _0x2132a6=_0x2adf72[_0x1a2450];_0x12074c[_0xe52e('0x1b')](insertAdditionalPhones(_0x2132a6));}}Promise[_0xe52e('0x1c')](_0x12074c)[_0xe52e('0x1d')](function(){_0x29f6c6({'val':0x1});});});});}function insertAdditionalPhones(_0x5a45f0){return new Promise(function(_0x57ecc7,_0x44f61c){var _0x5da303=_0x5a45f0[_0xe52e('0x19')];var _0x3ad5cf=_0x5da303[_0xe52e('0x1e')](';');var _0x460376=[];orderBy=0x0;for(var _0x1a8c91=0x0;_0x1a8c91<_0x3ad5cf[_0xe52e('0x1a')];_0x1a8c91++){_0x460376['push'](splitAdditionalPhone(_0x5a45f0['id'],_0x3ad5cf[_0x1a8c91]));}Promise['all'](_0x460376)['then'](function(){_0x57ecc7({'val':_0x3ad5cf[_0xe52e('0x1a')]});});});}function splitAdditionalPhone(_0x1a46a6,_0x19fff2){return new Promise(function(_0x474337,_0x2bf555){var _0x13c1bf=_0x19fff2[_0xe52e('0x1e')](':');var _0x1eee6c=_0x13c1bf[0x0];var _0x1f95f7=_0x13c1bf[0x1];if(!_['isNil'](_0x1f95f7)){var _0x4054e9=_0x1f95f7[_0xe52e('0x1e')]('|');var _0x76764=[];for(var _0x543e9c=0x0;_0x543e9c<_0x4054e9['length'];_0x543e9c++){if(_0x4054e9[_0x543e9c]!==''){var _0x3f2af1=_[_0xe52e('0x1f')](promisesAdditionalPhones,{'contactId':_0x1a46a6,'phone':_0x4054e9[_0x543e9c]});if(_0x3f2af1[_0xe52e('0x1a')]==0x0){orderBy++;promisesAdditionalPhones[_0xe52e('0x1b')]({'contactId':_0x1a46a6,'contactTypeId':_0x1eee6c,'phone':_0x4054e9[_0x543e9c],'orderBy':orderBy});}}}_0x474337({'ok':0x1});}else _0x474337({'res':0x0});});}function createAdditionalPhone(_0x58b0d6,_0x34fd95,_0x3186b5,_0x1c2c0c){var _0x2bc091='';var _0x2621c9='';var _0x4b1808=_0x3186b5['split']('§');_0x2bc091=_0x4b1808[0x0];if(_0x4b1808[_0xe52e('0x1a')]==0x2)_0x2621c9=_0x4b1808[0x1];return new Promise(function(_0x55fe98,_0x442e58){return db[_0xe52e('0x20')]['findOne']({'where':{'CmContactId':_0x58b0d6,'item':_0x2bc091}})[_0xe52e('0x1d')](function(_0xba82d1){if(_0xba82d1){return db['CmContactHasItem']['update']({'ItemTypeId':_0x34fd95,'description':_0x2621c9,'OrderBy':_0x1c2c0c},{'where':{'CmContactId':_0x58b0d6,'item':_0x2bc091}})[_0xe52e('0x1d')](function(_0xe3b532){_0x55fe98({'res':_0xe52e('0x21')});});}else{return db[_0xe52e('0x20')][_0xe52e('0x22')]({'CmContactId':_0x58b0d6,'item':_0x2bc091,'description':_0x2621c9,'ItemTypeId':_0x34fd95,'OrderBy':_0x1c2c0c,'ItemClass':_0xe52e('0x23')})[_0xe52e('0x1d')](function(_0x434200){_0x55fe98({'res':_0xe52e('0x24')});});}});});}function insertCmHopper(_0x272e88,_0x1e7bf5,_0x1dace1,_0x44dd42,_0x4e1ab5){var _0x16f3b5=[_0xe52e('0x25'),_0xe52e('0x26'),_0xe52e('0x27'),'cm_contacts.ListId',_0x1e7bf5+'.'+_0x44dd42,_0xe52e('0x28'),_0xe52e('0x29'),_0xe52e('0x2a'),'cm_contacts.UserId','\x22'+_0x4e1ab5+'\x22'];return squel[_0xe52e('0x2b')]()[_0xe52e('0x2c')]('cm_hopper')['fromQuery']([_0xe52e('0x10'),_0xe52e('0x2d'),'ContactId',_0xe52e('0x2e'),_0x44dd42,_0xe52e('0x2f'),_0xe52e('0x30'),_0xe52e('0x31'),'UserId',_0xe52e('0x32')],squel[_0xe52e('0xe')]()[_0xe52e('0x33')](_0x16f3b5)[_0xe52e('0x11')](_0x1e7bf5)[_0xe52e('0x12')]('cm_contacts',null,'cm_contacts.ListId\x20=\x20'+_0x1e7bf5+_0xe52e('0x34'))[_0xe52e('0x12')](_0x1dace1,null,_0x1dace1+'.id\x20=\x20'+_0x1e7bf5+'.'+_0x44dd42)[_0xe52e('0x15')](_0x1e7bf5+'.CmListId\x20=\x20?',_0x272e88)['where'](_0xe52e('0x35'),NOW)[_0xe52e('0x15')](_0xe52e('0x36'),selectNotIn(_0x1e7bf5,_0x1dace1,_0x44dd42,_0xe52e('0x37'),['\x22always\x22',_0xe52e('0x38')]))[_0xe52e('0x15')](_0xe52e('0x36'),selectNotIn(_0x1e7bf5,_0x1dace1,_0x44dd42,'cm_hopper',['\x22always\x22'])))[_0xe52e('0x39')]();}function insertCmHopperBlack(_0x389a27,_0x3b6913,_0xf02811,_0x55d8ce){var _0x3d7f6a=[_0xe52e('0x25'),_0xe52e('0x27'),_0xe52e('0x3a'),_0x3b6913+'.'+_0x55d8ce,_0xe52e('0x28'),_0xe52e('0x29')];return squel[_0xe52e('0x2b')]()[_0xe52e('0x2c')](_0xe52e('0x3b'))[_0xe52e('0x3c')]([_0xe52e('0x10'),'ContactId','ListId',_0x55d8ce,_0xe52e('0x2f'),_0xe52e('0x30')],squel[_0xe52e('0xe')]()[_0xe52e('0x33')](_0x3d7f6a)[_0xe52e('0x11')](_0x3b6913)[_0xe52e('0x12')](_0xe52e('0x3d'),null,_0xe52e('0x3e')+_0x3b6913+_0xe52e('0x34'))['join'](_0xf02811,null,_0xf02811+'.id\x20=\x20'+_0x3b6913+'.'+_0x55d8ce)[_0xe52e('0x15')](_0x3b6913+_0xe52e('0x3f'),_0x389a27)[_0xe52e('0x15')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0xe52e('0x15')](_0xe52e('0x36'),squel[_0xe52e('0xe')]()['field'](_0xe52e('0x10'))['from'](_0xe52e('0x3b'))[_0xe52e('0x15')]('ListId\x20=\x20?',_0x389a27)['where'](_0x55d8ce+_0xe52e('0x14')+_0x3b6913+'.'+_0x55d8ce)))[_0xe52e('0x39')]();}function insertTzCmHopper(_0x2331bf,_0x13e934,_0x29ebbf,_0x4220d6,_0x34f079,_0x26ed84){var _0x3addcd=['cm_contacts.phone',_0xe52e('0x40')+_0x26ed84+_0xe52e('0x41'),'cm_contacts.id',_0xe52e('0x3a'),_0x13e934+'.'+_0x4220d6,_0xe52e('0x28'),_0xe52e('0x29'),_0xe52e('0x2a'),'cm_contacts.UserId','\x22'+_0x34f079+'\x22'];var _0x4f2412=squel['insert']()[_0xe52e('0x2c')]('cm_hopper')['fromQuery']([_0xe52e('0x10'),'scheduledat','ContactId',_0xe52e('0x2e'),_0x4220d6,_0xe52e('0x2f'),_0xe52e('0x30'),_0xe52e('0x31'),'UserId',_0xe52e('0x32')],squel['select']()[_0xe52e('0x33')](_0x3addcd)[_0xe52e('0x11')](_0x13e934)[_0xe52e('0x12')](_0xe52e('0x3d'),null,_0xe52e('0x3e')+_0x13e934+_0xe52e('0x34'))[_0xe52e('0x12')](_0x29ebbf,null,_0x29ebbf+_0xe52e('0x13')+_0x13e934+'.'+_0x4220d6)['join'](_0x26ed84,null,_0x26ed84+'.id\x20=\x20'+_0x13e934+'.'+_0x4220d6)[_0xe52e('0x15')](_0x13e934+_0xe52e('0x3f'),_0x2331bf)['where'](_0xe52e('0x35'),NOW)[_0xe52e('0x15')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x13e934,_0x29ebbf,_0x4220d6,'cm_hopper',[_0xe52e('0x42'),'\x22onlyIfOpen\x22']))[_0xe52e('0x15')](_0xe52e('0x36'),selectNotIn(_0x13e934,_0x29ebbf,_0x4220d6,'cm_hopper',[_0xe52e('0x42')])))[_0xe52e('0x39')]();return _0x4f2412;}function insertTzCmHopperBlack(_0x29c4d4,_0x3e82dd,_0x24376e,_0x374623){var _0x56fceb=[_0xe52e('0x25'),_0xe52e('0x27'),'cm_contacts.ListId',_0x3e82dd+'.'+_0x374623,_0xe52e('0x28'),_0xe52e('0x29')];return squel[_0xe52e('0x2b')]()[_0xe52e('0x2c')](_0xe52e('0x3b'))[_0xe52e('0x3c')]([_0xe52e('0x10'),_0xe52e('0x43'),_0xe52e('0x2e'),_0x374623,_0xe52e('0x2f'),_0xe52e('0x30')],squel[_0xe52e('0xe')]()['fields'](_0x56fceb)['from'](_0x3e82dd)['join'](_0xe52e('0x3d'),null,_0xe52e('0x3e')+_0x3e82dd+'.CmListId')[_0xe52e('0x12')](_0x24376e,null,_0x24376e+_0xe52e('0x13')+_0x3e82dd+'.'+_0x374623)[_0xe52e('0x15')](_0x3e82dd+_0xe52e('0x3f'),_0x29c4d4)[_0xe52e('0x15')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0xe52e('0x15')](_0xe52e('0x36'),squel[_0xe52e('0xe')]()[_0xe52e('0xf')](_0xe52e('0x10'))[_0xe52e('0x11')](_0xe52e('0x3b'))[_0xe52e('0x15')](_0xe52e('0x44'),_0x29c4d4)['where'](_0x374623+_0xe52e('0x14')+_0x3e82dd+'.'+_0x374623)))[_0xe52e('0x39')]();}function insertCmHopperAdditionalPhones(_0x59577f){var _0x4b6467=[_0xe52e('0x45'),_0xe52e('0x46'),_0xe52e('0x47'),_0xe52e('0x48'),'cm_contact_has_items.updatedAt'];return squel[_0xe52e('0x2b')]()[_0xe52e('0x2c')](_0xe52e('0x49'))[_0xe52e('0x3c')]([_0xe52e('0x4a'),_0xe52e('0x10'),_0xe52e('0x4b'),_0xe52e('0x2f'),'updatedAt'],squel[_0xe52e('0xe')]()[_0xe52e('0x33')](_0x4b6467)[_0xe52e('0x11')](_0xe52e('0x37'))[_0xe52e('0x12')](_0xe52e('0x3d'),null,'cm_contacts.id\x20=\x20cm_hopper.ContactId')[_0xe52e('0x12')](_0xe52e('0x4c'),null,_0xe52e('0x4d'))[_0xe52e('0x15')](_0xe52e('0x4e'),_0x59577f)[_0xe52e('0x15')](_0xe52e('0x35'),NOW))[_0xe52e('0x39')]();}function insertCmContact(_0x59443a,_0x2b140b,_0x46a359,_0xd2f6a9){var _0x286bab=_[_0xe52e('0x4f')](_[_0xe52e('0x50')](_0xd2f6a9),[_0xe52e('0x2e'),_0xe52e('0x51'),'createdAt',_0xe52e('0x30'),_0xe52e('0x52')]);return squel[_0xe52e('0x2b')]()['into'](_0xe52e('0x3d'))['fromQuery'](_0x286bab,squel[_0xe52e('0xe')]()[_0xe52e('0x33')](_0x286bab)[_0xe52e('0x11')](_0x2b140b)[_0xe52e('0x15')]('('+_0x46a359[_0xe52e('0x12')](',')+_0xe52e('0x53'),squel['select']()[_0xe52e('0x33')](_0x46a359)[_0xe52e('0x11')]('cm_contacts')[_0xe52e('0x15')](_0xe52e('0x44'),_0x59443a)[_0xe52e('0x15')](_0xe52e('0x54')))['where'](_0xe52e('0x55'),squel[_0xe52e('0xe')]()['field']('MIN(id)',_0xe52e('0x56'))[_0xe52e('0x11')](_0x2b140b)[_0xe52e('0x57')](_0x46a359[_0xe52e('0x12')](','))))[_0xe52e('0x39')]();}function handleStop(){logger['info']('Received\x20SIGINT');stopped=!![];}function handleUncaughtException(_0x26a1e5){logger['error'](_0x26a1e5[_0xe52e('0x58')]);process[_0xe52e('0x59')](0x1);}function handleError(_0x4e9d88,_0x26adf8){stats[_0xe52e('0x5a')][_0xe52e('0x1b')]({'name':_0x26adf8[_0xe52e('0x5b')],'message':_0x26adf8[_0xe52e('0x58')],'row':_0x4e9d88});}function handleQuery(_0xe84896){logger[_0xe52e('0x5c')](_0xe84896);return db['sequelize']['query'](_0xe84896)[_0xe52e('0x5d')](function(_0x1b47bb){results['push'](_0x1b47bb);})[_0xe52e('0x5e')](function(_0x5e70c6){logger['error'](_0x5e70c6[_0xe52e('0x58')]);});}function updateTzCampaigns(_0x54e8d4){return new Promise(function(_0x28802a,_0x40a89c){var _0x39ed93=squel[_0xe52e('0xe')]()[_0xe52e('0x33')]([_0xe52e('0x5f'),_0xe52e('0x60')])[_0xe52e('0x11')](_0xe52e('0x61'))['join'](_0xe52e('0x62'),null,_0xe52e('0x63'))['where'](_0xe52e('0x64')+_0x54e8d4);db[_0xe52e('0x65')][_0xe52e('0x66')](_0x39ed93[_0xe52e('0x39')]())[_0xe52e('0x5d')](function(_0x233ef6){var _0x50b514=[];for(var _0xbbd9f=0x0;_0xbbd9f<_0x233ef6[_0xe52e('0x1a')];_0xbbd9f++){_0x50b514[_0xe52e('0x1b')](getTimezoneData(_0x233ef6[_0xbbd9f],tmp_campaigns));}BPromise[_0xe52e('0x1c')](_0x50b514)['then'](function(){_0x28802a({'val':0x1});});})[_0xe52e('0x5e')](function(_0x5dddb9){logger['error'](_0x5dddb9['message']);_0x28802a({'val':0x0});});});}function updateTzVoiceQueues(_0x34761){return new Promise(function(_0x59ba62,_0x2ae7c8){var _0x328562=squel[_0xe52e('0xe')]()['fields']([_0xe52e('0x67'),'voice_queues.dialTimezone'])['from'](_0xe52e('0x68'))[_0xe52e('0x12')]('voice_queues_has_cm_lists',null,_0xe52e('0x69'))[_0xe52e('0x15')]('voice_queues_has_cm_lists.CmListId='+_0x34761);db[_0xe52e('0x65')][_0xe52e('0x66')](_0x328562['toString']())[_0xe52e('0x5d')](function(_0x3e7e8f){var _0x1f3ab4=[];for(var _0x3af79b=0x0;_0x3af79b<_0x3e7e8f['length'];_0x3af79b++){_0x1f3ab4[_0xe52e('0x1b')](getTimezoneData(_0x3e7e8f[_0x3af79b],tmp_voice_queues));}BPromise[_0xe52e('0x1c')](_0x1f3ab4)['then'](function(){_0x59ba62({'val':0x1});});})[_0xe52e('0x5e')](function(_0x5a4e92){logger[_0xe52e('0x6a')](_0x5a4e92['message']);_0x59ba62({'val':0x0});});});}function getTimezoneData(_0x12d5d9,_0x406323){return new Promise(function(_0x471dd4,_0x42e299){var _0x364519=shared['timezones'];var _0x5f7d94=_0x364519[_0x12d5d9[_0xe52e('0x6b')]];if(_[_0xe52e('0x6c')](_0x5f7d94)){_0x471dd4({'ret':0x1});}else{var _0x1f4305=_0x5f7d94[_0xe52e('0x6d')];var _0x28f062=squel[_0xe52e('0x2b')]()[_0xe52e('0x2c')](_0x406323)['set']('id',_0x12d5d9['id'])[_0xe52e('0x6e')](_0xe52e('0x6f'),_0x1f4305)[_0xe52e('0x6e')](_0xe52e('0x6b'),_0x12d5d9['dialTimezone'])[_0xe52e('0x39')]();return db[_0xe52e('0x65')][_0xe52e('0x66')](_0x28f062)[_0xe52e('0x5d')](function(_0x2a8714){_0x471dd4({'ret':0x1});})['catch'](function(_0x3501c8){logger[_0xe52e('0x6a')](_0x3501c8[_0xe52e('0x58')]);_0x42e299({'ret':0x1});});}});}function handleTZQuery(_0x8c089f){logger[_0xe52e('0x5c')](_0x8c089f);return db[_0xe52e('0x65')][_0xe52e('0x66')](_0x8c089f)[_0xe52e('0x5d')](function(_0x109cc8){})[_0xe52e('0x5e')](function(_0x107d72){logger[_0xe52e('0x6a')](_0x107d72[_0xe52e('0x58')]);});}function main(_0x183a4f,_0x275678,_0x1a41eb,_0x297701){logger[_0xe52e('0x5c')](_0xe52e('0x70'),_0x183a4f,JSON[_0xe52e('0x71')](_0x275678));process['send'](_0xe52e('0x72'));var _0xede4dc=_0x275678['binding'];var _0x150af6=_[_0xe52e('0x73')](_0xede4dc);var _0x173288=_0x275678[_0xe52e('0x74')];var _0x64bd81=path[_0xe52e('0x12')](config[_0xe52e('0x75')],_0xe52e('0x76'),_0x173288+'.csv');hasTZ=_[_0xe52e('0x50')](_0xede4dc)['includes'](_0xe52e('0x6b'));var _0x1cabed=_['keys'](_0xede4dc)[_0xe52e('0x12')]();logger[_0xe52e('0x5c')]('header',_0x1cabed);db[_0xe52e('0x77')]['findAll']({'raw':!![],'attributes':['id',_0xe52e('0x78')]})[_0xe52e('0x1d')](function(_0x3a6e77){for(var _0x2ba3cb=0x0;_0x2ba3cb<_0x3a6e77['length'];_0x2ba3cb++){if(_0x3a6e77[_0x2ba3cb]['name']in _0xede4dc){contactItemTypes['push'](_0x3a6e77[_0x2ba3cb]);delete _0x150af6[_0x3a6e77[_0x2ba3cb][_0xe52e('0x78')]];hasAdditionalPhones=!![];}for(var _0xd35a92 in _0xede4dc){if(_0x3a6e77[_0x2ba3cb]['name']+'_description'===_0xd35a92){phoneDescriptions[_0xe52e('0x1b')]({'itemTypeId':_0x3a6e77[_0x2ba3cb]['id'],'description':_0xd35a92});delete _0x150af6[_0xd35a92];}}}if(hasAdditionalPhones)_0x150af6[_0xe52e('0x19')]='';var _0x490e36=_['keys'](_0x150af6)[_0xe52e('0x12')]();logger[_0xe52e('0x5c')]('header',_0x490e36);fs[_0xe52e('0x79')](_0x64bd81,_0x490e36+'\x0a');Papa[_0xe52e('0x7a')](fs[_0xe52e('0x7b')](_0x183a4f),{'header':!![],'skipEmptyLines':!![],'step':function(_0xe17d29,_0x1bf924){try{for(var _0x27b4ca=0x0,_0x141d25=[];_0x27b4ca<_0xe17d29[_0xe52e('0x7c')][_0xe52e('0x1a')];_0x27b4ca++){stats[_0xe52e('0x7d')]+=0x1;if(_0xe17d29['errors'][_0x27b4ca]){handleError(_0xe17d29[_0xe52e('0x7c')][_0x27b4ca],_0xe17d29[_0xe52e('0x5a')][_0x27b4ca]);}else{var _0x52131e=[];var _0x708d40=[];var _0x29b224={};for(var _0xef4994 in _0xede4dc){let _0x339687=contactItemTypes[_0xe52e('0x7e')](_0x21884b=>_0x21884b[_0xe52e('0x78')]===_0xef4994);let _0x3f4a03=contactItemTypes[_0xe52e('0x7e')](_0x47a294=>_0x47a294[_0xe52e('0x78')]+_0xe52e('0x7f')===_0xef4994);if(_[_0xe52e('0x6c')](_0x339687)&&_[_0xe52e('0x6c')](_0x3f4a03)){if(_0xede4dc['hasOwnProperty'](_0xef4994)){if(_0xe17d29[_0xe52e('0x7c')][_0x27b4ca][_0xede4dc[_0xef4994]]){var _0x33fa75=_['trim'](_0xe17d29[_0xe52e('0x7c')][_0x27b4ca][_0xede4dc[_0xef4994]][_0xe52e('0x80')](/"/g,'\x27'));switch(_0xef4994){case'scheduledat':var _0x17812f=moment(_0x33fa75,_0xe52e('0xb'),!![]);if(_0x17812f[_0xe52e('0x81')]()){_0x141d25[_0xe52e('0x1b')]('\x22'+_0x33fa75+'\x22');}else{_0x52131e[_0xe52e('0x1b')](_0xe52e('0x82'));}break;case'priority':var _0x2fe0e8=parseInt(_0x33fa75);_0x33fa75=_[_0xe52e('0x83')](_0x2fe0e8)||_0x2fe0e8<0x0||_0x2fe0e8>0x4?_0x297701?0x3:0x2:_0x2fe0e8;_0x141d25['push']('\x22'+_0x33fa75+'\x22');break;case'UserId':var _0x43a426=parseInt(_0x33fa75);if(_[_0xe52e('0x84')](_0x43a426)&&_[_0xe52e('0x85')](_0x1a41eb,_0x43a426)){_0x141d25['push']('\x22'+_0x43a426+'\x22');}else{_0x52131e[_0xe52e('0x1b')](_0xe52e('0x86'));}break;case'email':if(isEmail(_0x33fa75)){_0x141d25[_0xe52e('0x1b')]('\x22'+_0x33fa75+'\x22');}else{_0x52131e[_0xe52e('0x1b')](_0xe52e('0x87'));}break;case _0xe52e('0x88'):var _0x395d40=moment(_0x33fa75,_0xe52e('0x89'),!![]);if(_0x395d40[_0xe52e('0x81')]()){_0x141d25[_0xe52e('0x1b')]('\x22'+_0x33fa75+'\x22');}else{_0x52131e[_0xe52e('0x1b')](_0xe52e('0x8a'));}break;case'dialTimezone':var _0x367e6b=shared['timezones'];var _0x4444d2=_0x367e6b[_0x33fa75];if(!_[_0xe52e('0x6c')](_0x4444d2)){var _0x3b99a0=_0x4444d2[_0xe52e('0x6d')];_0x141d25[_0xe52e('0x1b')]('\x22'+_0x33fa75+'\x22');_0x141d25[_0xe52e('0x1b')]('\x22'+_0x3b99a0+'\x22');}break;default:_0x141d25[_0xe52e('0x1b')]('\x22'+_0x33fa75+'\x22');}}else{switch(_0xef4994){case'firstName':case _0xe52e('0x10'):_0x52131e[_0xe52e('0x1b')](_0xef4994+_0xe52e('0x8b'));break;default:_0x141d25[_0xe52e('0x1b')]('\x22\x22');}}}}else{var _0x299998='';if(!_['isNil'](_0x339687)){if(!_0x29b224['hasOwnProperty'](_0x339687['id'])){if(!_[_0xe52e('0x6c')](_0xe17d29['data'][_0x27b4ca][_0xede4dc[_0xef4994]])){var _0x33fa75=_[_0xe52e('0x8c')](_0xe17d29[_0xe52e('0x7c')][_0x27b4ca][_0xede4dc[_0xef4994]][_0xe52e('0x80')](/"/g,'\x27'));var _0x7336d6=phoneDescriptions['find'](_0x32cf7d=>_0x32cf7d[_0xe52e('0x8d')]===_0x339687['id']);if(!_[_0xe52e('0x6c')](_0x7336d6)){var _0x446360=_['trim'](_0xe17d29['data'][_0x27b4ca][_0xede4dc[_0x7336d6[_0xe52e('0x8e')]]][_0xe52e('0x80')](/"/g,'\x27'));if(!_['isNil'](_0x446360))_0x33fa75=_0x33fa75+'§'+_0x446360;}if(_0x299998=='')_0x299998=_0x33fa75;else _0x299998+='|'+_0x33fa75;}_0x708d40['push'](_0x339687['id']+':'+_0x299998);_0x29b224[_0x339687['id']]=0x1;}}}}if(hasAdditionalPhones){_0x141d25['push']('\x22'+_0x708d40[_0xe52e('0x12')](';')+'\x22');}if(_0x52131e[_0xe52e('0x1a')]){handleError(_0xe17d29[_0xe52e('0x7c')][_0x27b4ca],{'code':_0xe52e('0x8f'),'message':_0x52131e[_0xe52e('0x12')]()});}else{fs[_0xe52e('0x90')](_0x64bd81,_0x141d25[_0xe52e('0x12')]()+'\x0a');}_0x141d25=[];}if(!(stats['rows']%0xc8)){socket['emit'](_0xe52e('0x91')+_0x173288,stats);stats[_0xe52e('0x5a')]=[];}}if(stopped){logger[_0xe52e('0x5c')](_0xe52e('0x92'));_0x1bf924[_0xe52e('0x93')]();}}catch(_0x14e21){handleError(_0xe17d29[_0xe52e('0x7c')][_0x27b4ca],{'code':'SystemError','message':_0x14e21[_0xe52e('0x58')]});logger[_0xe52e('0x6a')](_0xe52e('0x94'),_0x14e21[_0xe52e('0x58')]);}},'complete':function(){try{var _0x181549=[];var _0x48443a=[];var _0x38ec02='cm_contacts';if(_0x275678[_0xe52e('0x95')]&&_0x275678[_0xe52e('0x95')][_0xe52e('0x1a')]){_0x38ec02='cm_contacts_'+_0x173288;_0x181549[_0xe52e('0x1b')](_0xe52e('0x96')+_0x38ec02+_0xe52e('0x97'));}tmp_campaigns=_0xe52e('0x98')+_0x173288;tmp_voice_queues='voice_queues_'+_0x173288;_0x48443a[_0xe52e('0x1b')](_0xe52e('0x96')+tmp_campaigns+_0xe52e('0x99'));_0x48443a[_0xe52e('0x1b')](_0xe52e('0x96')+tmp_voice_queues+_0xe52e('0x99'));BPromise[_0xe52e('0x9a')](_0x48443a,handleTZQuery)[_0xe52e('0x1d')](function(_0x539f1e){updateTzCampaigns(_0x275678['ListId'])['then'](function(_0x18594b){updateTzVoiceQueues(_0x275678[_0xe52e('0x2e')])[_0xe52e('0x1d')](function(_0x513d3e){if(hasTZ)_0x490e36=_0x490e36[_0xe52e('0x80')](_0xe52e('0x6b'),_0xe52e('0x9b'));var _0x457283=util['format'](_0xe52e('0x9c'),_0x64bd81,_0x38ec02,_0x490e36,_0x275678['ListId'],_0x275678['CompanyId']||null,NOW,NOW);if(_['isNil'](_0xede4dc['scheduledat'])){_0x457283+=_0xe52e('0x9d');}_0x181549['push'](_0x457283);if(_0x275678[_0xe52e('0x95')]&&_0x275678[_0xe52e('0x95')][_0xe52e('0x1a')]){_0x181549[_0xe52e('0x1b')](insertCmContact(_0x275678[_0xe52e('0x2e')],_0x38ec02,_0x275678[_0xe52e('0x95')],_0xede4dc));_0x181549['push'](_0xe52e('0x9e')+_0x38ec02+';');}BPromise[_0xe52e('0x9a')](_0x181549,handleQuery)['then'](function(_0xdce264){BPromise[_0xe52e('0x1c')]([handleAdditionalPhones()])[_0xe52e('0x1d')](function(){_0x181549=[];for(var _0x1cf290=0x0;_0x1cf290<promisesAdditionalPhones[_0xe52e('0x1a')];_0x1cf290++){if(promisesAdditionalPhones[_0x1cf290][_0xe52e('0x10')]!='§'){_0x181549[_0xe52e('0x1b')](createAdditionalPhone(promisesAdditionalPhones[_0x1cf290]['contactId'],promisesAdditionalPhones[_0x1cf290][_0xe52e('0x9f')],promisesAdditionalPhones[_0x1cf290][_0xe52e('0x10')],promisesAdditionalPhones[_0x1cf290][_0xe52e('0xa0')]));}}BPromise[_0xe52e('0x1c')](_0x181549)['then'](function(){_0x181549=[];if(hasTZ){_0x181549[_0xe52e('0x1b')](insertTzCmHopper(_0x275678['ListId'],_0xe52e('0xa1'),_0xe52e('0x68'),_0xe52e('0xa2'),_0x297701,tmp_voice_queues));_0x181549[_0xe52e('0x1b')](insertTzCmHopperBlack(_0x275678[_0xe52e('0x2e')],'voice_queues_has_cm_blacklists',_0xe52e('0x68'),'VoiceQueueId'));_0x181549[_0xe52e('0x1b')](insertTzCmHopper(_0x275678[_0xe52e('0x2e')],_0xe52e('0x62'),'campaigns','CampaignId',_0x297701,tmp_campaigns));_0x181549[_0xe52e('0x1b')](insertTzCmHopperBlack(_0x275678['ListId'],_0xe52e('0xa3'),_0xe52e('0x61'),_0xe52e('0xa4')));_0x181549[_0xe52e('0x1b')](insertCmHopperAdditionalPhones(_0x275678[_0xe52e('0x2e')]));}else{_0x181549[_0xe52e('0x1b')](insertCmHopper(_0x275678[_0xe52e('0x2e')],_0xe52e('0xa1'),'voice_queues',_0xe52e('0xa2'),_0x297701));_0x181549[_0xe52e('0x1b')](insertCmHopperBlack(_0x275678[_0xe52e('0x2e')],_0xe52e('0xa5'),_0xe52e('0x68'),_0xe52e('0xa2')));_0x181549[_0xe52e('0x1b')](insertCmHopper(_0x275678[_0xe52e('0x2e')],_0xe52e('0x62'),_0xe52e('0x61'),'CampaignId',_0x297701));_0x181549[_0xe52e('0x1b')](insertCmHopperBlack(_0x275678['ListId'],_0xe52e('0xa3'),'campaigns',_0xe52e('0xa4')));_0x181549[_0xe52e('0x1b')](insertCmHopperAdditionalPhones(_0x275678[_0xe52e('0x2e')]));}_0x181549[_0xe52e('0x1b')]('DROP\x20TABLE\x20'+tmp_campaigns+';');_0x181549[_0xe52e('0x1b')](_0xe52e('0x9e')+tmp_voice_queues+';');BPromise['each'](_0x181549,handleQuery)['then'](function(_0x4507e3){stats['finish']=!![];stats[_0xe52e('0xa6')]=_0x275678[_0xe52e('0x95')]&&_0x275678[_0xe52e('0x95')]['length']?results[0x2][_0xe52e('0xa6')]:results[0x0][_0xe52e('0xa6')];socket[_0xe52e('0xa7')](_0xe52e('0x91')+_0x173288,stats);fs[_0xe52e('0xa8')](_0x183a4f);fs['unlink'](_0x64bd81);process[_0xe52e('0x59')](0x0);})[_0xe52e('0x5e')](function(_0x30a016){logger[_0xe52e('0x6a')](_0x30a016[_0xe52e('0x58')]);process[_0xe52e('0x59')](0x1);});});});})[_0xe52e('0x5e')](function(_0x2617bc){logger['error'](_0x2617bc[_0xe52e('0x58')]);process[_0xe52e('0x59')](0x1);});});});});}catch(_0x27b1ea){logger[_0xe52e('0x6a')](_0xe52e('0xa9'),_0x27b1ea[_0xe52e('0x58')]);process['exit'](0x1);}},'error':function(_0x2e86cd,_0x5784e1,_0x2b55de,_0xe25f7d){throw new Error(_0xe25f7d);}});});}function validate(){if(process[_0xe52e('0xaa')]&&process[_0xe52e('0xaa')][_0xe52e('0x1a')]<0x4){throw new Error(_0xe52e('0xab'));}var _0x42df84=path[_0xe52e('0x12')](config[_0xe52e('0x75')],_0xe52e('0x76'),process[_0xe52e('0xaa')][0x2]);if(!fs[_0xe52e('0xac')](_0x42df84)){throw new Error(_0xe52e('0xad'));}var _0x33fd28={};try{_0x33fd28=JSON[_0xe52e('0x7a')](process[_0xe52e('0xaa')][0x3]);if(!_0x33fd28[_0xe52e('0xae')]){throw new Error(_0xe52e('0xaf'));}if(!_0x33fd28[_0xe52e('0xae')][_0xe52e('0x10')]){throw new Error('phone\x20is\x20mandatory');}if(!_0x33fd28[_0xe52e('0xae')][_0xe52e('0xb0')]){throw new Error('firstName\x20is\x20mandatory');}var _0x19ed7e=0x0;if(_0x33fd28[_0xe52e('0xae')][_0xe52e('0xb1')]){_0x19ed7e=0x1;}if(!_0x33fd28['ListId']){throw new Error(_0xe52e('0xb2'));}}catch(_0x59e4d9){throw new Error(_0xe52e('0xb3'));}var _0x5dcb93=[];try{_0x5dcb93=_[_0xe52e('0xb4')](JSON[_0xe52e('0x7a')](process['argv'][0x4]),'id');}catch(_0x5a4169){logger[_0xe52e('0x5c')](_0xe52e('0xb5'));}main(_0x42df84,_0x33fd28,_0x5dcb93,_0x19ed7e);}validate();process['on']('SIGINT',handleStop);process['on']('uncaughtException',handleUncaughtException);
\ No newline at end of file
+var _0x040c=['send','start','binding','clone','root','.csv','header','ContactItemType','name','_description','writeFileSync','parse','data','rows','find','trim','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNumber','includes','email','email\x20wrong\x20format','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','utcOffset','firstName','\x20not\x20specified','hasOwnProperty','itemTypeId','description','replace','emit','contact:import:','Abort\x20parser','abort','SystemError','step','duplicates','cm_contacts_','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','campaigns_','(id\x20int,dialTimezone\x20varchar(255),offset\x20int);','each','dialTimezone,utcOffset','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','DROP\x20TABLE\x20','contactId','orderBy','VoiceQueueId','voice_queues_has_cm_blacklists','CampaignId','campaigns_has_cm_blacklists','finish','affectedRows','unlink','complete','argv','server/files/tmp','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','phone\x20is\x20mandatory','ListId\x20is\x20mandatory','map','No\x20agent\x20available','SIGINT','uncaughtException','lodash','util','bluebird','moment','squel','ioredis','../../../mysqldb','../../../config/environment','../../../config/environment/shared','../../../config/logger','redis','defaults','socket.io-emitter','format','YYYY-MM-DD\x20HH:mm:ss','test','select','field','phone','from','join','.id\x20=\x20','where','\x20=\x20','CmContact','findAll','AdditionalPhones','then','push','all','split','length','isNil','filter','findOne','update','inserted','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.priority','insert','into','fromQuery','scheduledat','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(?)','cm_hopper','\x22always\x22','\x22onlyIfOpen\x22','cm_contacts.updatedAt','ContactId','ListId','createdAt','updatedAt','cm_hopper_black','ListId\x20=\x20?','toString','.offset-cm_contacts.utcOffset\x20minute)','cm_contacts.UserId','cm_hopper.id','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','scheduledAt',')\x20NOT\x20IN\x20?','MIN(id)','min_id','group','info','Received\x20SIGINT','exit','errors','message','query','spread','campaigns.id','campaigns.dialTimezone','campaigns','campaigns_has_cm_lists','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','set','offset','dialTimezone','catch','main','stringify'];(function(_0x226cf9,_0x42cdf7){var _0x1927a1=function(_0x365137){while(--_0x365137){_0x226cf9['push'](_0x226cf9['shift']());}};_0x1927a1(++_0x42cdf7);}(_0x040c,0x1b5));var _0xc040=function(_0x3850c1,_0x28e14e){_0x3850c1=_0x3850c1-0x0;var _0x55d3f2=_0x040c[_0x3850c1];return _0x55d3f2;};'use strict';var fs=require('fs');var path=require('path');var _=require(_0xc040('0x0'));var Papa=require('papaparse');var util=require(_0xc040('0x1'));var BPromise=require(_0xc040('0x2'));var moment=require(_0xc040('0x3'));var squel=require(_0xc040('0x4'));var Redis=require(_0xc040('0x5'));var db=require(_0xc040('0x6'))['db'];var config=require(_0xc040('0x7'));var shared=require(_0xc040('0x8'));var logger=require(_0xc040('0x9'))('import');config[_0xc040('0xa')]=_[_0xc040('0xb')](config[_0xc040('0xa')],{'host':'localhost','port':0x18eb});var socket=require(_0xc040('0xc'))(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']('YYYY-MM-DD\x20HH:mm:ss');var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];var tmp_voice_queues;var tmp_campaigns;var tzOffset=0x0;var hasTZ;var NOW=moment()[_0xc040('0xd')](_0xc040('0xe'));function isEmail(_0x37ed27){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))*$/[_0xc040('0xf')](_0x37ed27);}function selectNotIn(_0x335a75,_0x5237c0,_0x32c7cb,_0x4bb789,_0x30a6f1){return squel[_0xc040('0x10')]()[_0xc040('0x11')](_0xc040('0x12'))[_0xc040('0x13')](_0x4bb789)[_0xc040('0x14')](_0x5237c0,null,_0x5237c0+_0xc040('0x15')+_0x4bb789+'.'+_0x32c7cb)[_0xc040('0x16')](_0x4bb789+'.'+_0x32c7cb+_0xc040('0x17')+_0x335a75+'.'+_0x32c7cb)[_0xc040('0x16')](_0x5237c0+'.dialCheckDuplicateType\x20IN\x20('+_0x30a6f1['join']()+')');}function handleAdditionalPhones(){return new Promise(function(_0x509ae1,_0x11fa8a){promisesAdditionalPhones=[];return db[_0xc040('0x18')][_0xc040('0x19')]({'raw':!![],'attributes':['id',_0xc040('0x1a')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})[_0xc040('0x1b')](function(_0x37e5df){if(_0x37e5df!==null){var _0x3b6442=[];for(var _0x4e00db=0x0;_0x4e00db<_0x37e5df['length'];_0x4e00db++){var _0x447487=_0x37e5df[_0x4e00db];_0x3b6442[_0xc040('0x1c')](insertAdditionalPhones(_0x447487));}}Promise[_0xc040('0x1d')](_0x3b6442)[_0xc040('0x1b')](function(){_0x509ae1({'val':0x1});});});});}function insertAdditionalPhones(_0x1ad6d6){return new Promise(function(_0x118b1e,_0x3bdd51){var _0x55c81f=_0x1ad6d6[_0xc040('0x1a')];var _0x3d7ded=_0x55c81f[_0xc040('0x1e')](';');var _0x4e36ee=[];orderBy=0x0;for(var _0x2c51fe=0x0;_0x2c51fe<_0x3d7ded[_0xc040('0x1f')];_0x2c51fe++){_0x4e36ee[_0xc040('0x1c')](splitAdditionalPhone(_0x1ad6d6['id'],_0x3d7ded[_0x2c51fe]));}Promise['all'](_0x4e36ee)[_0xc040('0x1b')](function(){_0x118b1e({'val':_0x3d7ded[_0xc040('0x1f')]});});});}function splitAdditionalPhone(_0x23db3c,_0x1261e5){return new Promise(function(_0x2c72fa,_0x5ef42f){var _0xaba101=_0x1261e5[_0xc040('0x1e')](':');var _0x21f1cc=_0xaba101[0x0];var _0x4ed604=_0xaba101[0x1];if(!_[_0xc040('0x20')](_0x4ed604)){var _0x4d392f=_0x4ed604['split']('|');var _0x5853f5=[];for(var _0x105c38=0x0;_0x105c38<_0x4d392f['length'];_0x105c38++){if(_0x4d392f[_0x105c38]!==''){var _0x16b992=_[_0xc040('0x21')](promisesAdditionalPhones,{'contactId':_0x23db3c,'phone':_0x4d392f[_0x105c38]});if(_0x16b992['length']==0x0){orderBy++;promisesAdditionalPhones[_0xc040('0x1c')]({'contactId':_0x23db3c,'contactTypeId':_0x21f1cc,'phone':_0x4d392f[_0x105c38],'orderBy':orderBy});}}}_0x2c72fa({'ok':0x1});}else _0x2c72fa({'res':0x0});});}function createAdditionalPhone(_0x5c30e4,_0x5f1770,_0x3192ca,_0x365657){var _0x4bb348='';var _0x945c30='';var _0x297987=_0x3192ca[_0xc040('0x1e')]('§');_0x4bb348=_0x297987[0x0];if(_0x297987[_0xc040('0x1f')]==0x2)_0x945c30=_0x297987[0x1];return new Promise(function(_0x3d69c4,_0x4c3317){return db['CmContactHasItem'][_0xc040('0x22')]({'where':{'CmContactId':_0x5c30e4,'item':_0x4bb348}})[_0xc040('0x1b')](function(_0x2a0812){if(_0x2a0812){return db['CmContactHasItem'][_0xc040('0x23')]({'ItemTypeId':_0x5f1770,'description':_0x945c30,'OrderBy':_0x365657},{'where':{'CmContactId':_0x5c30e4,'item':_0x4bb348}})[_0xc040('0x1b')](function(_0x146428){_0x3d69c4({'res':'updated'});});}else{return db['CmContactHasItem']['create']({'CmContactId':_0x5c30e4,'item':_0x4bb348,'description':_0x945c30,'ItemTypeId':_0x5f1770,'OrderBy':_0x365657,'ItemClass':'PHONE'})[_0xc040('0x1b')](function(_0x502617){_0x3d69c4({'res':_0xc040('0x24')});});}});});}function insertCmHopper(_0x40adb8,_0x3d7ece,_0x44f5ee,_0x27218f,_0x75e7c5){var _0x2579cb=[_0xc040('0x25'),_0xc040('0x26'),_0xc040('0x27'),_0xc040('0x28'),_0x3d7ece+'.'+_0x27218f,_0xc040('0x29'),'cm_contacts.updatedAt',_0xc040('0x2a'),'cm_contacts.UserId','\x22'+_0x75e7c5+'\x22'];return squel[_0xc040('0x2b')]()[_0xc040('0x2c')]('cm_hopper')[_0xc040('0x2d')]([_0xc040('0x12'),_0xc040('0x2e'),'ContactId','ListId',_0x27218f,'createdAt','updatedAt',_0xc040('0x2f'),_0xc040('0x30'),'recallme'],squel[_0xc040('0x10')]()[_0xc040('0x31')](_0x2579cb)[_0xc040('0x13')](_0x3d7ece)['join'](_0xc040('0x32'),null,_0xc040('0x33')+_0x3d7ece+_0xc040('0x34'))[_0xc040('0x14')](_0x44f5ee,null,_0x44f5ee+'.id\x20=\x20'+_0x3d7ece+'.'+_0x27218f)[_0xc040('0x16')](_0x3d7ece+_0xc040('0x35'),_0x40adb8)[_0xc040('0x16')](_0xc040('0x36'),NOW)[_0xc040('0x16')](_0xc040('0x37'),selectNotIn(_0x3d7ece,_0x44f5ee,_0x27218f,_0xc040('0x38'),[_0xc040('0x39'),_0xc040('0x3a')]))[_0xc040('0x16')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x3d7ece,_0x44f5ee,_0x27218f,_0xc040('0x38'),[_0xc040('0x39')])))['toString']();}function insertCmHopperBlack(_0x310ff9,_0x1721c8,_0x464d9b,_0x4ebc3f){var _0x21b09e=[_0xc040('0x25'),'cm_contacts.id',_0xc040('0x28'),_0x1721c8+'.'+_0x4ebc3f,'cm_contacts.createdAt',_0xc040('0x3b')];return squel[_0xc040('0x2b')]()[_0xc040('0x2c')]('cm_hopper_black')[_0xc040('0x2d')]([_0xc040('0x12'),_0xc040('0x3c'),_0xc040('0x3d'),_0x4ebc3f,_0xc040('0x3e'),_0xc040('0x3f')],squel[_0xc040('0x10')]()[_0xc040('0x31')](_0x21b09e)[_0xc040('0x13')](_0x1721c8)[_0xc040('0x14')](_0xc040('0x32'),null,_0xc040('0x33')+_0x1721c8+_0xc040('0x34'))['join'](_0x464d9b,null,_0x464d9b+'.id\x20=\x20'+_0x1721c8+'.'+_0x4ebc3f)[_0xc040('0x16')](_0x1721c8+_0xc040('0x35'),_0x310ff9)[_0xc040('0x16')](_0xc040('0x36'),NOW)[_0xc040('0x16')](_0xc040('0x37'),squel[_0xc040('0x10')]()[_0xc040('0x11')](_0xc040('0x12'))['from'](_0xc040('0x40'))[_0xc040('0x16')](_0xc040('0x41'),_0x310ff9)[_0xc040('0x16')](_0x4ebc3f+_0xc040('0x17')+_0x1721c8+'.'+_0x4ebc3f)))[_0xc040('0x42')]();}function insertTzCmHopper(_0x49cc62,_0x1c6136,_0x3af8e8,_0x4aa81d,_0x20cfb9,_0x2758f5){var _0x1b9c7b=[_0xc040('0x25'),'date_add(cm_contacts.scheduledat,interval\x20'+_0x2758f5+_0xc040('0x43'),_0xc040('0x27'),_0xc040('0x28'),_0x1c6136+'.'+_0x4aa81d,_0xc040('0x29'),'cm_contacts.updatedAt',_0xc040('0x2a'),_0xc040('0x44'),'\x22'+_0x20cfb9+'\x22'];var _0x4a86a7=squel[_0xc040('0x2b')]()['into'](_0xc040('0x38'))['fromQuery'](['phone',_0xc040('0x2e'),_0xc040('0x3c'),_0xc040('0x3d'),_0x4aa81d,'createdAt',_0xc040('0x3f'),_0xc040('0x2f'),_0xc040('0x30'),'recallme'],squel[_0xc040('0x10')]()['fields'](_0x1b9c7b)['from'](_0x1c6136)[_0xc040('0x14')]('cm_contacts',null,_0xc040('0x33')+_0x1c6136+'.CmListId')[_0xc040('0x14')](_0x3af8e8,null,_0x3af8e8+'.id\x20=\x20'+_0x1c6136+'.'+_0x4aa81d)[_0xc040('0x14')](_0x2758f5,null,_0x2758f5+'.id\x20=\x20'+_0x1c6136+'.'+_0x4aa81d)['where'](_0x1c6136+'.CmListId\x20=\x20?',_0x49cc62)[_0xc040('0x16')](_0xc040('0x36'),NOW)[_0xc040('0x16')](_0xc040('0x37'),selectNotIn(_0x1c6136,_0x3af8e8,_0x4aa81d,_0xc040('0x38'),['\x22always\x22','\x22onlyIfOpen\x22']))[_0xc040('0x16')](_0xc040('0x37'),selectNotIn(_0x1c6136,_0x3af8e8,_0x4aa81d,_0xc040('0x38'),[_0xc040('0x39')])))[_0xc040('0x42')]();return _0x4a86a7;}function insertTzCmHopperBlack(_0x39a0f2,_0x42d408,_0x990c60,_0x46331d){var _0x3286c5=[_0xc040('0x25'),_0xc040('0x27'),_0xc040('0x28'),_0x42d408+'.'+_0x46331d,_0xc040('0x29'),_0xc040('0x3b')];return squel[_0xc040('0x2b')]()[_0xc040('0x2c')](_0xc040('0x40'))[_0xc040('0x2d')](['phone',_0xc040('0x3c'),_0xc040('0x3d'),_0x46331d,_0xc040('0x3e'),_0xc040('0x3f')],squel[_0xc040('0x10')]()[_0xc040('0x31')](_0x3286c5)[_0xc040('0x13')](_0x42d408)['join']('cm_contacts',null,_0xc040('0x33')+_0x42d408+_0xc040('0x34'))[_0xc040('0x14')](_0x990c60,null,_0x990c60+'.id\x20=\x20'+_0x42d408+'.'+_0x46331d)[_0xc040('0x16')](_0x42d408+_0xc040('0x35'),_0x39a0f2)[_0xc040('0x16')](_0xc040('0x36'),NOW)[_0xc040('0x16')](_0xc040('0x37'),squel['select']()[_0xc040('0x11')](_0xc040('0x12'))[_0xc040('0x13')](_0xc040('0x40'))[_0xc040('0x16')](_0xc040('0x41'),_0x39a0f2)[_0xc040('0x16')](_0x46331d+_0xc040('0x17')+_0x42d408+'.'+_0x46331d)))['toString']();}function insertCmHopperAdditionalPhones(_0x49ded1){var _0x356294=[_0xc040('0x45'),'cm_contact_has_items.item',_0xc040('0x46'),_0xc040('0x47'),_0xc040('0x48')];return squel[_0xc040('0x2b')]()[_0xc040('0x2c')](_0xc040('0x49'))[_0xc040('0x2d')]([_0xc040('0x4a'),_0xc040('0x12'),_0xc040('0x4b'),_0xc040('0x3e'),'updatedAt'],squel[_0xc040('0x10')]()[_0xc040('0x31')](_0x356294)['from'](_0xc040('0x38'))[_0xc040('0x14')](_0xc040('0x32'),null,_0xc040('0x4c'))['join'](_0xc040('0x4d'),null,_0xc040('0x4e'))[_0xc040('0x16')](_0xc040('0x4f'),_0x49ded1)[_0xc040('0x16')](_0xc040('0x36'),NOW))[_0xc040('0x42')]();}function insertCmContact(_0x474f9e,_0x428cd2,_0x245e2d,_0x31457b){var _0x3507e1=_[_0xc040('0x50')](_[_0xc040('0x51')](_0x31457b),['ListId','CompanyId',_0xc040('0x3e'),'updatedAt',_0xc040('0x52')]);return squel[_0xc040('0x2b')]()[_0xc040('0x2c')](_0xc040('0x32'))[_0xc040('0x2d')](_0x3507e1,squel[_0xc040('0x10')]()[_0xc040('0x31')](_0x3507e1)[_0xc040('0x13')](_0x428cd2)[_0xc040('0x16')]('('+_0x245e2d['join'](',')+_0xc040('0x53'),squel[_0xc040('0x10')]()[_0xc040('0x31')](_0x245e2d)[_0xc040('0x13')](_0xc040('0x32'))['where'](_0xc040('0x41'),_0x474f9e)['where']('deletedAt\x20IS\x20NULL'))[_0xc040('0x16')]('id\x20IN\x20?',squel[_0xc040('0x10')]()['field'](_0xc040('0x54'),_0xc040('0x55'))[_0xc040('0x13')](_0x428cd2)[_0xc040('0x56')](_0x245e2d['join'](','))))[_0xc040('0x42')]();}function handleStop(){logger[_0xc040('0x57')](_0xc040('0x58'));stopped=!![];}function handleUncaughtException(_0x3b0a91){logger['error'](_0x3b0a91['message']);process[_0xc040('0x59')](0x1);}function handleError(_0x1daa6b,_0x171996){stats[_0xc040('0x5a')][_0xc040('0x1c')]({'name':_0x171996['code'],'message':_0x171996[_0xc040('0x5b')],'row':_0x1daa6b});}function handleQuery(_0x24950e){logger[_0xc040('0x57')](_0x24950e);return db['sequelize'][_0xc040('0x5c')](_0x24950e)[_0xc040('0x5d')](function(_0x104ce5){results[_0xc040('0x1c')](_0x104ce5);})['catch'](function(_0x29506a){logger['error'](_0x29506a[_0xc040('0x5b')]);});}function updateTzCampaigns(_0x2ed9e7){return new Promise(function(_0x4eab3a,_0x382759){var _0x2eb440=squel[_0xc040('0x10')]()[_0xc040('0x31')]([_0xc040('0x5e'),_0xc040('0x5f')])[_0xc040('0x13')](_0xc040('0x60'))[_0xc040('0x14')](_0xc040('0x61'),null,_0xc040('0x62'))['where'](_0xc040('0x63')+_0x2ed9e7);db[_0xc040('0x64')][_0xc040('0x5c')](_0x2eb440[_0xc040('0x42')]())[_0xc040('0x5d')](function(_0x55cbe8){var _0x99f7cc=[];for(var _0x85398a=0x0;_0x85398a<_0x55cbe8[_0xc040('0x1f')];_0x85398a++){_0x99f7cc[_0xc040('0x1c')](getTimezoneData(_0x55cbe8[_0x85398a],tmp_campaigns));}BPromise[_0xc040('0x1d')](_0x99f7cc)[_0xc040('0x1b')](function(){_0x4eab3a({'val':0x1});});})['catch'](function(_0x31898f){logger[_0xc040('0x65')](_0x31898f['message']);_0x4eab3a({'val':0x0});});});}function updateTzVoiceQueues(_0x51d4a7){return new Promise(function(_0x47da44,_0x338f98){var _0x598c62=squel[_0xc040('0x10')]()[_0xc040('0x31')]([_0xc040('0x66'),_0xc040('0x67')])[_0xc040('0x13')](_0xc040('0x68'))['join'](_0xc040('0x69'),null,_0xc040('0x6a'))[_0xc040('0x16')](_0xc040('0x6b')+_0x51d4a7);db[_0xc040('0x64')][_0xc040('0x5c')](_0x598c62[_0xc040('0x42')]())[_0xc040('0x5d')](function(_0x34a14e){var _0x268e79=[];for(var _0x1ed23f=0x0;_0x1ed23f<_0x34a14e[_0xc040('0x1f')];_0x1ed23f++){_0x268e79[_0xc040('0x1c')](getTimezoneData(_0x34a14e[_0x1ed23f],tmp_voice_queues));}BPromise[_0xc040('0x1d')](_0x268e79)['then'](function(){_0x47da44({'val':0x1});});})['catch'](function(_0x4199d1){logger[_0xc040('0x65')](_0x4199d1[_0xc040('0x5b')]);_0x47da44({'val':0x0});});});}function getTimezoneData(_0x205509,_0x2fcff4){return new Promise(function(_0x4e8457,_0xcbcde){var _0x5cf618=shared[_0xc040('0x6c')];var _0x4c43f9=_0x5cf618[_0x205509['dialTimezone']];if(_[_0xc040('0x20')](_0x4c43f9)){_0x4e8457({'ret':0x1});}else{var _0x2f242e=_0x4c43f9['utcOffset'];var _0x434d5b=squel[_0xc040('0x2b')]()[_0xc040('0x2c')](_0x2fcff4)[_0xc040('0x6d')]('id',_0x205509['id'])[_0xc040('0x6d')](_0xc040('0x6e'),_0x2f242e)[_0xc040('0x6d')](_0xc040('0x6f'),_0x205509[_0xc040('0x6f')])[_0xc040('0x42')]();return db[_0xc040('0x64')][_0xc040('0x5c')](_0x434d5b)[_0xc040('0x5d')](function(_0x29815c){_0x4e8457({'ret':0x1});})[_0xc040('0x70')](function(_0x246367){logger[_0xc040('0x65')](_0x246367[_0xc040('0x5b')]);_0xcbcde({'ret':0x1});});}});}function handleTZQuery(_0x33d937){logger['info'](_0x33d937);return db[_0xc040('0x64')][_0xc040('0x5c')](_0x33d937)[_0xc040('0x5d')](function(_0x18bd62){})[_0xc040('0x70')](function(_0xa9f81c){logger[_0xc040('0x65')](_0xa9f81c[_0xc040('0x5b')]);});}function main(_0x1d9afd,_0x2af864,_0x274cb2,_0x4356cf){logger[_0xc040('0x57')](_0xc040('0x71'),_0x1d9afd,JSON[_0xc040('0x72')](_0x2af864));process[_0xc040('0x73')](_0xc040('0x74'));var _0x4e5d85=_0x2af864[_0xc040('0x75')];var _0x294a2b=_[_0xc040('0x76')](_0x4e5d85);var _0x4b94c3=_0x2af864['socket_timestamp'];var _0x2b32aa=path['join'](config[_0xc040('0x77')],'server/files/tmp',_0x4b94c3+_0xc040('0x78'));hasTZ=_[_0xc040('0x51')](_0x4e5d85)['includes'](_0xc040('0x6f'));var _0x16da7c=_[_0xc040('0x51')](_0x4e5d85)['join']();logger[_0xc040('0x57')](_0xc040('0x79'),_0x16da7c);db[_0xc040('0x7a')][_0xc040('0x19')]({'raw':!![],'attributes':['id','name']})['then'](function(_0x6a83b6){for(var _0x84d785=0x0;_0x84d785<_0x6a83b6[_0xc040('0x1f')];_0x84d785++){if(_0x6a83b6[_0x84d785][_0xc040('0x7b')]in _0x4e5d85){contactItemTypes[_0xc040('0x1c')](_0x6a83b6[_0x84d785]);delete _0x294a2b[_0x6a83b6[_0x84d785][_0xc040('0x7b')]];hasAdditionalPhones=!![];}for(var _0x5b4af4 in _0x4e5d85){if(_0x6a83b6[_0x84d785][_0xc040('0x7b')]+_0xc040('0x7c')===_0x5b4af4){phoneDescriptions['push']({'itemTypeId':_0x6a83b6[_0x84d785]['id'],'description':_0x5b4af4});delete _0x294a2b[_0x5b4af4];}}}if(hasAdditionalPhones)_0x294a2b[_0xc040('0x1a')]='';var _0x50da0e=_[_0xc040('0x51')](_0x294a2b)['join']();logger[_0xc040('0x57')](_0xc040('0x79'),_0x50da0e);fs[_0xc040('0x7d')](_0x2b32aa,_0x50da0e+'\x0a');Papa[_0xc040('0x7e')](fs['createReadStream'](_0x1d9afd),{'header':!![],'skipEmptyLines':!![],'step':function(_0x13d3ea,_0x5641b0){try{for(var _0x45d2e5=0x0,_0x36f14a=[];_0x45d2e5<_0x13d3ea[_0xc040('0x7f')][_0xc040('0x1f')];_0x45d2e5++){stats[_0xc040('0x80')]+=0x1;if(_0x13d3ea[_0xc040('0x5a')][_0x45d2e5]){handleError(_0x13d3ea[_0xc040('0x7f')][_0x45d2e5],_0x13d3ea[_0xc040('0x5a')][_0x45d2e5]);}else{var _0x43d783=[];var _0x58de77=[];var _0x488592={};for(var _0x390d20 in _0x4e5d85){let _0x2d7005=contactItemTypes[_0xc040('0x81')](_0x419808=>_0x419808['name']===_0x390d20);let _0x2792e3=contactItemTypes[_0xc040('0x81')](_0x4dbb0a=>_0x4dbb0a[_0xc040('0x7b')]+_0xc040('0x7c')===_0x390d20);if(_[_0xc040('0x20')](_0x2d7005)&&_['isNil'](_0x2792e3)){if(_0x4e5d85['hasOwnProperty'](_0x390d20)){if(_0x13d3ea[_0xc040('0x7f')][_0x45d2e5][_0x4e5d85[_0x390d20]]){var _0x5d12e2=_[_0xc040('0x82')](_0x13d3ea['data'][_0x45d2e5][_0x4e5d85[_0x390d20]]['replace'](/"/g,'\x27'));switch(_0x390d20){case _0xc040('0x2e'):var _0x5c8ae3=moment(_0x5d12e2,_0xc040('0xe'),!![]);if(_0x5c8ae3[_0xc040('0x83')]()){_0x36f14a[_0xc040('0x1c')]('\x22'+_0x5d12e2+'\x22');}else{_0x43d783['push'](_0xc040('0x84'));}break;case _0xc040('0x2f'):var _0x12628e=parseInt(_0x5d12e2);_0x5d12e2=_['isNaN'](_0x12628e)||_0x12628e<0x0||_0x12628e>0x4?_0x4356cf?0x3:0x2:_0x12628e;_0x36f14a[_0xc040('0x1c')]('\x22'+_0x5d12e2+'\x22');break;case'UserId':var _0x586f72=parseInt(_0x5d12e2);if(_[_0xc040('0x85')](_0x586f72)&&_[_0xc040('0x86')](_0x274cb2,_0x586f72)){_0x36f14a[_0xc040('0x1c')]('\x22'+_0x586f72+'\x22');}else{_0x43d783['push']('agent\x20not\x20exists');}break;case _0xc040('0x87'):if(isEmail(_0x5d12e2)){_0x36f14a[_0xc040('0x1c')]('\x22'+_0x5d12e2+'\x22');}else{_0x43d783[_0xc040('0x1c')](_0xc040('0x88'));}break;case'dateOfBirth':var _0x3b9905=moment(_0x5d12e2,_0xc040('0x89'),!![]);if(_0x3b9905[_0xc040('0x83')]()){_0x36f14a[_0xc040('0x1c')]('\x22'+_0x5d12e2+'\x22');}else{_0x43d783['push'](_0xc040('0x8a'));}break;case _0xc040('0x6f'):var _0x379533=shared[_0xc040('0x6c')];var _0x3dfeea=_0x379533[_0x5d12e2];if(!_[_0xc040('0x20')](_0x3dfeea)){var _0x3d7e77=_0x3dfeea[_0xc040('0x8b')];_0x36f14a[_0xc040('0x1c')]('\x22'+_0x5d12e2+'\x22');_0x36f14a[_0xc040('0x1c')]('\x22'+_0x3d7e77+'\x22');}break;default:_0x36f14a[_0xc040('0x1c')]('\x22'+_0x5d12e2+'\x22');}}else{switch(_0x390d20){case _0xc040('0x8c'):case _0xc040('0x12'):_0x43d783['push'](_0x390d20+_0xc040('0x8d'));break;default:_0x36f14a[_0xc040('0x1c')]('\x22\x22');}}}}else{var _0x490368='';if(!_[_0xc040('0x20')](_0x2d7005)){if(!_0x488592[_0xc040('0x8e')](_0x2d7005['id'])){if(!_[_0xc040('0x20')](_0x13d3ea[_0xc040('0x7f')][_0x45d2e5][_0x4e5d85[_0x390d20]])){var _0x5d12e2=_['trim'](_0x13d3ea[_0xc040('0x7f')][_0x45d2e5][_0x4e5d85[_0x390d20]]['replace'](/"/g,'\x27'));var _0x4d3aaf=phoneDescriptions['find'](_0xf5fedd=>_0xf5fedd[_0xc040('0x8f')]===_0x2d7005['id']);if(!_[_0xc040('0x20')](_0x4d3aaf)){var _0xf649f6=_['trim'](_0x13d3ea[_0xc040('0x7f')][_0x45d2e5][_0x4e5d85[_0x4d3aaf[_0xc040('0x90')]]][_0xc040('0x91')](/"/g,'\x27'));if(!_['isNil'](_0xf649f6))_0x5d12e2=_0x5d12e2+'§'+_0xf649f6;}if(_0x490368=='')_0x490368=_0x5d12e2;else _0x490368+='|'+_0x5d12e2;}_0x58de77[_0xc040('0x1c')](_0x2d7005['id']+':'+_0x490368);_0x488592[_0x2d7005['id']]=0x1;}}}}if(hasAdditionalPhones){_0x36f14a[_0xc040('0x1c')]('\x22'+_0x58de77['join'](';')+'\x22');}if(_0x43d783['length']){handleError(_0x13d3ea[_0xc040('0x7f')][_0x45d2e5],{'code':'SystemRow','message':_0x43d783[_0xc040('0x14')]()});}else{fs['appendFileSync'](_0x2b32aa,_0x36f14a[_0xc040('0x14')]()+'\x0a');}_0x36f14a=[];}if(!(stats['rows']%0xc8)){socket[_0xc040('0x92')](_0xc040('0x93')+_0x4b94c3,stats);stats['errors']=[];}}if(stopped){logger[_0xc040('0x57')](_0xc040('0x94'));_0x5641b0[_0xc040('0x95')]();}}catch(_0x19c099){handleError(_0x13d3ea[_0xc040('0x7f')][_0x45d2e5],{'code':_0xc040('0x96'),'message':_0x19c099[_0xc040('0x5b')]});logger[_0xc040('0x65')](_0xc040('0x97'),_0x19c099[_0xc040('0x5b')]);}},'complete':function(){try{var _0x5c9021=[];var _0x1e2f25=[];var _0x4f7bcf='cm_contacts';if(_0x2af864['duplicates']&&_0x2af864[_0xc040('0x98')][_0xc040('0x1f')]){_0x4f7bcf=_0xc040('0x99')+_0x4b94c3;_0x5c9021['push'](_0xc040('0x9a')+_0x4f7bcf+_0xc040('0x9b'));}tmp_campaigns=_0xc040('0x9c')+_0x4b94c3;tmp_voice_queues='voice_queues_'+_0x4b94c3;_0x1e2f25[_0xc040('0x1c')](_0xc040('0x9a')+tmp_campaigns+_0xc040('0x9d'));_0x1e2f25['push'](_0xc040('0x9a')+tmp_voice_queues+'(id\x20int,dialTimezone\x20varchar(255),offset\x20int);');BPromise[_0xc040('0x9e')](_0x1e2f25,handleTZQuery)[_0xc040('0x1b')](function(_0x3599b0){updateTzCampaigns(_0x2af864[_0xc040('0x3d')])[_0xc040('0x1b')](function(_0xd64033){updateTzVoiceQueues(_0x2af864[_0xc040('0x3d')])['then'](function(_0x373abe){if(hasTZ)_0x50da0e=_0x50da0e[_0xc040('0x91')](_0xc040('0x6f'),_0xc040('0x9f'));var _0x24e147=util[_0xc040('0xd')](_0xc040('0xa0'),_0x2b32aa,_0x4f7bcf,_0x50da0e,_0x2af864[_0xc040('0x3d')],_0x2af864[_0xc040('0xa1')]||null,NOW,NOW);if(_[_0xc040('0x20')](_0x4e5d85[_0xc040('0x2e')])){_0x24e147+=',\x20scheduledAt\x20=\x20NOW()';}_0x5c9021[_0xc040('0x1c')](_0x24e147);if(_0x2af864[_0xc040('0x98')]&&_0x2af864[_0xc040('0x98')]['length']){_0x5c9021[_0xc040('0x1c')](insertCmContact(_0x2af864[_0xc040('0x3d')],_0x4f7bcf,_0x2af864[_0xc040('0x98')],_0x4e5d85));_0x5c9021[_0xc040('0x1c')](_0xc040('0xa2')+_0x4f7bcf+';');}BPromise[_0xc040('0x9e')](_0x5c9021,handleQuery)['then'](function(_0x4d41aa){BPromise[_0xc040('0x1d')]([handleAdditionalPhones()])[_0xc040('0x1b')](function(){_0x5c9021=[];for(var _0xa7ae10=0x0;_0xa7ae10<promisesAdditionalPhones['length'];_0xa7ae10++){if(promisesAdditionalPhones[_0xa7ae10][_0xc040('0x12')]!='§'){_0x5c9021[_0xc040('0x1c')](createAdditionalPhone(promisesAdditionalPhones[_0xa7ae10][_0xc040('0xa3')],promisesAdditionalPhones[_0xa7ae10]['contactTypeId'],promisesAdditionalPhones[_0xa7ae10][_0xc040('0x12')],promisesAdditionalPhones[_0xa7ae10][_0xc040('0xa4')]));}}BPromise[_0xc040('0x1d')](_0x5c9021)[_0xc040('0x1b')](function(){_0x5c9021=[];if(hasTZ){_0x5c9021[_0xc040('0x1c')](insertTzCmHopper(_0x2af864[_0xc040('0x3d')],'voice_queues_has_cm_lists',_0xc040('0x68'),_0xc040('0xa5'),_0x4356cf,tmp_voice_queues));_0x5c9021[_0xc040('0x1c')](insertTzCmHopperBlack(_0x2af864[_0xc040('0x3d')],_0xc040('0xa6'),_0xc040('0x68'),_0xc040('0xa5')));_0x5c9021['push'](insertTzCmHopper(_0x2af864[_0xc040('0x3d')],_0xc040('0x61'),'campaigns',_0xc040('0xa7'),_0x4356cf,tmp_campaigns));_0x5c9021[_0xc040('0x1c')](insertTzCmHopperBlack(_0x2af864['ListId'],_0xc040('0xa8'),'campaigns',_0xc040('0xa7')));_0x5c9021[_0xc040('0x1c')](insertCmHopperAdditionalPhones(_0x2af864['ListId']));}else{_0x5c9021['push'](insertCmHopper(_0x2af864['ListId'],_0xc040('0x69'),_0xc040('0x68'),_0xc040('0xa5'),_0x4356cf));_0x5c9021[_0xc040('0x1c')](insertCmHopperBlack(_0x2af864[_0xc040('0x3d')],_0xc040('0xa6'),_0xc040('0x68'),_0xc040('0xa5')));_0x5c9021[_0xc040('0x1c')](insertCmHopper(_0x2af864[_0xc040('0x3d')],_0xc040('0x61'),_0xc040('0x60'),_0xc040('0xa7'),_0x4356cf));_0x5c9021[_0xc040('0x1c')](insertCmHopperBlack(_0x2af864[_0xc040('0x3d')],'campaigns_has_cm_blacklists','campaigns',_0xc040('0xa7')));_0x5c9021[_0xc040('0x1c')](insertCmHopperAdditionalPhones(_0x2af864[_0xc040('0x3d')]));}_0x5c9021[_0xc040('0x1c')]('DROP\x20TABLE\x20'+tmp_campaigns+';');_0x5c9021[_0xc040('0x1c')](_0xc040('0xa2')+tmp_voice_queues+';');BPromise[_0xc040('0x9e')](_0x5c9021,handleQuery)[_0xc040('0x1b')](function(_0x128a4e){stats[_0xc040('0xa9')]=!![];stats[_0xc040('0xaa')]=_0x2af864[_0xc040('0x98')]&&_0x2af864[_0xc040('0x98')]['length']?results[0x2][_0xc040('0xaa')]:results[0x0][_0xc040('0xaa')];socket[_0xc040('0x92')](_0xc040('0x93')+_0x4b94c3,stats);fs[_0xc040('0xab')](_0x1d9afd);fs[_0xc040('0xab')](_0x2b32aa);process[_0xc040('0x59')](0x0);})[_0xc040('0x70')](function(_0x440297){logger[_0xc040('0x65')](_0x440297[_0xc040('0x5b')]);process[_0xc040('0x59')](0x1);});});});})[_0xc040('0x70')](function(_0x53e6fc){logger['error'](_0x53e6fc[_0xc040('0x5b')]);process[_0xc040('0x59')](0x1);});});});});}catch(_0x473773){logger['error'](_0xc040('0xac'),_0x473773[_0xc040('0x5b')]);process[_0xc040('0x59')](0x1);}},'error':function(_0x2c78f8,_0xba7d9,_0x4feff8,_0x960868){throw new Error(_0x960868);}});});}function validate(){if(process['argv']&&process[_0xc040('0xad')][_0xc040('0x1f')]<0x4){throw new Error('arguments\x20<filename>\x20<parameters>\x20<agents>');}var _0x28c5fc=path[_0xc040('0x14')](config[_0xc040('0x77')],_0xc040('0xae'),process[_0xc040('0xad')][0x2]);if(!fs[_0xc040('0xaf')](_0x28c5fc)){throw new Error(_0xc040('0xb0'));}var _0x33f6d4={};try{_0x33f6d4=JSON[_0xc040('0x7e')](process[_0xc040('0xad')][0x3]);if(!_0x33f6d4[_0xc040('0x75')]){throw new Error(_0xc040('0xb1'));}if(!_0x33f6d4[_0xc040('0x75')][_0xc040('0x12')]){throw new Error(_0xc040('0xb2'));}if(!_0x33f6d4[_0xc040('0x75')][_0xc040('0x8c')]){throw new Error('firstName\x20is\x20mandatory');}var _0x13084c=0x0;if(_0x33f6d4[_0xc040('0x75')]['UserId']){_0x13084c=0x1;}if(!_0x33f6d4[_0xc040('0x3d')]){throw new Error(_0xc040('0xb3'));}}catch(_0x171dcc){throw new Error('body\x20id\x20mandatory');}var _0x5c7872=[];try{_0x5c7872=_[_0xc040('0xb4')](JSON[_0xc040('0x7e')](process[_0xc040('0xad')][0x4]),'id');}catch(_0x218eb5){logger[_0xc040('0x57')](_0xc040('0xb5'));}main(_0x28c5fc,_0x33f6d4,_0x5c7872,_0x13084c);}validate();process['on'](_0xc040('0xb6'),handleStop);process['on'](_0xc040('0xb7'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff