// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1b4f=['\x22always\x22','\x22onlyIfOpen\x22','toString','cm_contacts.createdAt','cm_hopper_black','.CmListId','cm_contacts.createdAt\x20=\x20?','ListId\x20=\x20?','date_add(cm_contacts.scheduledat,interval\x20','UserId','cm_hopper','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','CmHopperId','OrderBy','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contact_has_items','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId','scheduledAt',')\x20NOT\x20IN\x20?','deletedAt\x20IS\x20NULL','id\x20IN\x20?','MIN(id)','group','info','message','exit','errors','spread','catch','error','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.dialTimezone','voice_queues','voice_queues.id\x20=\x20voice_queues_has_cm_lists.VoiceQueueId','voice_queues_has_cm_lists.CmListId=','all','timezones','dialTimezone','utcOffset','set','offset','main','stringify','start','binding','clone','root','server/files/tmp','.csv','includes','ContactItemType','name','_description','header','data','rows','find','hasOwnProperty','trim','replace','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','agent\x20not\x20exists','email','dateOfBirth','YYYY-MM-DD','isValid','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','\x20not\x20specified','itemTypeId','description','SystemRow','appendFileSync','emit','contact:import:','duplicates','cm_contacts_','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','campaigns_','voice_queues_','(id\x20int,dialTimezone\x20varchar(255),offset\x20int);','each','LOAD\x20DATA\x20LOCAL\x20INFILE\x20\x27%s\x27\x20INTO\x20TABLE\x20%s\x20CHARACTER\x20SET\x20UTF8\x20FIELDS\x20TERMINATED\x20BY\x20\x27,\x27\x20ENCLOSED\x20BY\x20\x27\x22\x27\x20LINES\x20TERMINATED\x20BY\x20\x27\x0a\x27\x20IGNORE\x201\x20ROWS\x20(%s)\x20SET\x20id\x20=\x20NULL,\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27',',\x20scheduledAt\x20=\x20NOW()','contactTypeId','orderBy','voice_queues_has_cm_lists','voice_queues_has_cm_blacklists','VoiceQueueId','CampaignId','DROP\x20TABLE\x20','finish','affectedRows','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','file\x20doesn\x27t\x20exists','parse','binding\x20doesn\x27t\x20exists','phone\x20is\x20mandatory','firstName\x20is\x20mandatory','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','SIGINT','uncaughtException','path','lodash','papaparse','util','bluebird','moment','squel','../../../config/environment/shared','../../../config/logger','import','redis','defaults','localhost','socket.io-emitter','format','YYYY-MM-DD\x20HH:mm:ss','test','select','field','phone','from','join','.id\x20=\x20','where','\x20=\x20','.dialCheckDuplicateType\x20IN\x20(','findAll','AdditionalPhones','then','length','split','isNil','filter','push','CmContactHasItem','update','updated','create','PHONE','inserted','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.updatedAt','cm_contacts.priority','insert','into','fromQuery','scheduledat','ContactId','ListId','createdAt','updatedAt','priority','recallme','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)'];(function(_0x3fb8ee,_0x2b0f23){var _0x1a2e74=function(_0x3a23c6){while(--_0x3a23c6){_0x3fb8ee['push'](_0x3fb8ee['shift']());}};_0x1a2e74(++_0x2b0f23);}(_0x1b4f,0x7b));var _0xf1b4=function(_0x520e83,_0x565ac7){_0x520e83=_0x520e83-0x0;var _0x4cd196=_0x1b4f[_0x520e83];return _0x4cd196;};'use strict';var fs=require('fs');var path=require(_0xf1b4('0x0'));var _=require(_0xf1b4('0x1'));var Papa=require(_0xf1b4('0x2'));var util=require(_0xf1b4('0x3'));var BPromise=require(_0xf1b4('0x4'));var moment=require(_0xf1b4('0x5'));var squel=require(_0xf1b4('0x6'));var Redis=require('ioredis');var db=require('../../../mysqldb')['db'];var config=require('../../../config/environment');var shared=require(_0xf1b4('0x7'));var logger=require(_0xf1b4('0x8'))(_0xf1b4('0x9'));config[_0xf1b4('0xa')]=_[_0xf1b4('0xb')](config[_0xf1b4('0xa')],{'host':_0xf1b4('0xc'),'port':0x18eb});var socket=require(_0xf1b4('0xd'))(new Redis(config[_0xf1b4('0xa')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()[_0xf1b4('0xe')](_0xf1b4('0xf'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];var tmp_voice_queues;var tmp_campaigns;var tzOffset=0x0;var hasTZ;var NOW=moment()['format'](_0xf1b4('0xf'));function isEmail(_0x1fbb34){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))*$/[_0xf1b4('0x10')](_0x1fbb34);}function selectNotIn(_0x1bfb3,_0x1293b2,_0x35d4f4,_0x459654,_0x14d0cf){return squel[_0xf1b4('0x11')]()[_0xf1b4('0x12')](_0xf1b4('0x13'))[_0xf1b4('0x14')](_0x459654)[_0xf1b4('0x15')](_0x1293b2,null,_0x1293b2+_0xf1b4('0x16')+_0x459654+'.'+_0x35d4f4)[_0xf1b4('0x17')](_0x459654+'.'+_0x35d4f4+_0xf1b4('0x18')+_0x1bfb3+'.'+_0x35d4f4)[_0xf1b4('0x17')](_0x1293b2+_0xf1b4('0x19')+_0x14d0cf[_0xf1b4('0x15')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x54ef41,_0x365234){promisesAdditionalPhones=[];return db['CmContact'][_0xf1b4('0x1a')]({'raw':!![],'attributes':['id',_0xf1b4('0x1b')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})[_0xf1b4('0x1c')](function(_0x3ee658){if(_0x3ee658!==null){var _0x174f02=[];for(var _0x5ca51a=0x0;_0x5ca51a<_0x3ee658[_0xf1b4('0x1d')];_0x5ca51a++){var _0x4f2f89=_0x3ee658[_0x5ca51a];_0x174f02['push'](insertAdditionalPhones(_0x4f2f89));}}Promise['all'](_0x174f02)['then'](function(){_0x54ef41({'val':0x1});});});});}function insertAdditionalPhones(_0x528793){return new Promise(function(_0x4bf87d,_0x5b11ab){var _0x3b69ce=_0x528793[_0xf1b4('0x1b')];var _0x54e9a9=_0x3b69ce['split'](';');var _0x47cb31=[];orderBy=0x0;for(var _0x5c2fa0=0x0;_0x5c2fa0<_0x54e9a9[_0xf1b4('0x1d')];_0x5c2fa0++){_0x47cb31['push'](splitAdditionalPhone(_0x528793['id'],_0x54e9a9[_0x5c2fa0]));}Promise['all'](_0x47cb31)[_0xf1b4('0x1c')](function(){_0x4bf87d({'val':_0x54e9a9[_0xf1b4('0x1d')]});});});}function splitAdditionalPhone(_0x49643c,_0x4b425f){return new Promise(function(_0x33e07a,_0x4e40d3){var _0x2de728=_0x4b425f[_0xf1b4('0x1e')](':');var _0x585f85=_0x2de728[0x0];var _0x3d82f5=_0x2de728[0x1];if(!_[_0xf1b4('0x1f')](_0x3d82f5)){var _0x49ca3f=_0x3d82f5[_0xf1b4('0x1e')]('|');var _0x19ee40=[];for(var _0x590e78=0x0;_0x590e78<_0x49ca3f[_0xf1b4('0x1d')];_0x590e78++){if(_0x49ca3f[_0x590e78]!==''){var _0x512155=_[_0xf1b4('0x20')](promisesAdditionalPhones,{'contactId':_0x49643c,'phone':_0x49ca3f[_0x590e78]});if(_0x512155['length']==0x0){orderBy++;promisesAdditionalPhones[_0xf1b4('0x21')]({'contactId':_0x49643c,'contactTypeId':_0x585f85,'phone':_0x49ca3f[_0x590e78],'orderBy':orderBy});}}}_0x33e07a({'ok':0x1});}else _0x33e07a({'res':0x0});});}function createAdditionalPhone(_0xe934c7,_0x5faf78,_0x4d81bf,_0xe8c8f1){var _0x364916='';var _0x2f7869='';var _0x355753=_0x4d81bf[_0xf1b4('0x1e')]('§');_0x364916=_0x355753[0x0];if(_0x355753[_0xf1b4('0x1d')]==0x2)_0x2f7869=_0x355753[0x1];return new Promise(function(_0x401694,_0x23e4b0){return db[_0xf1b4('0x22')]['findOne']({'where':{'CmContactId':_0xe934c7,'item':_0x364916}})[_0xf1b4('0x1c')](function(_0x2ffd38){if(_0x2ffd38){return db['CmContactHasItem'][_0xf1b4('0x23')]({'ItemTypeId':_0x5faf78,'description':_0x2f7869,'OrderBy':_0xe8c8f1},{'where':{'CmContactId':_0xe934c7,'item':_0x364916}})[_0xf1b4('0x1c')](function(_0x1acca9){_0x401694({'res':_0xf1b4('0x24')});});}else{return db[_0xf1b4('0x22')][_0xf1b4('0x25')]({'CmContactId':_0xe934c7,'item':_0x364916,'description':_0x2f7869,'ItemTypeId':_0x5faf78,'OrderBy':_0xe8c8f1,'ItemClass':_0xf1b4('0x26')})[_0xf1b4('0x1c')](function(_0x11c696){_0x401694({'res':_0xf1b4('0x27')});});}});});}function insertCmHopper(_0x35b0eb,_0x3a0dfb,_0x36195c,_0x4aaf2d,_0x21244e){var _0x3d7603=[_0xf1b4('0x28'),_0xf1b4('0x29'),_0xf1b4('0x2a'),_0xf1b4('0x2b'),_0x3a0dfb+'.'+_0x4aaf2d,'cm_contacts.createdAt',_0xf1b4('0x2c'),_0xf1b4('0x2d'),'cm_contacts.UserId','\x22'+_0x21244e+'\x22'];return squel[_0xf1b4('0x2e')]()[_0xf1b4('0x2f')]('cm_hopper')[_0xf1b4('0x30')]([_0xf1b4('0x13'),_0xf1b4('0x31'),_0xf1b4('0x32'),_0xf1b4('0x33'),_0x4aaf2d,_0xf1b4('0x34'),_0xf1b4('0x35'),_0xf1b4('0x36'),'UserId',_0xf1b4('0x37')],squel[_0xf1b4('0x11')]()[_0xf1b4('0x38')](_0x3d7603)[_0xf1b4('0x14')](_0x3a0dfb)[_0xf1b4('0x15')](_0xf1b4('0x39'),null,_0xf1b4('0x3a')+_0x3a0dfb+'.CmListId')['join'](_0x36195c,null,_0x36195c+_0xf1b4('0x16')+_0x3a0dfb+'.'+_0x4aaf2d)[_0xf1b4('0x17')](_0x3a0dfb+_0xf1b4('0x3b'),_0x35b0eb)[_0xf1b4('0x17')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0xf1b4('0x17')](_0xf1b4('0x3c'),selectNotIn(_0x3a0dfb,_0x36195c,_0x4aaf2d,'cm_hopper',[_0xf1b4('0x3d'),_0xf1b4('0x3e')]))[_0xf1b4('0x17')](_0xf1b4('0x3c'),selectNotIn(_0x3a0dfb,_0x36195c,_0x4aaf2d,'cm_hopper',[_0xf1b4('0x3d')])))[_0xf1b4('0x3f')]();}function insertCmHopperBlack(_0x1780dc,_0xfffb3,_0x305207,_0x4e145b){var _0x4b7fa6=[_0xf1b4('0x28'),_0xf1b4('0x2a'),'cm_contacts.ListId',_0xfffb3+'.'+_0x4e145b,_0xf1b4('0x40'),_0xf1b4('0x2c')];return squel[_0xf1b4('0x2e')]()[_0xf1b4('0x2f')](_0xf1b4('0x41'))[_0xf1b4('0x30')](['phone','ContactId',_0xf1b4('0x33'),_0x4e145b,_0xf1b4('0x34'),_0xf1b4('0x35')],squel[_0xf1b4('0x11')]()[_0xf1b4('0x38')](_0x4b7fa6)[_0xf1b4('0x14')](_0xfffb3)[_0xf1b4('0x15')](_0xf1b4('0x39'),null,_0xf1b4('0x3a')+_0xfffb3+_0xf1b4('0x42'))[_0xf1b4('0x15')](_0x305207,null,_0x305207+_0xf1b4('0x16')+_0xfffb3+'.'+_0x4e145b)[_0xf1b4('0x17')](_0xfffb3+_0xf1b4('0x3b'),_0x1780dc)[_0xf1b4('0x17')](_0xf1b4('0x43'),NOW)[_0xf1b4('0x17')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel[_0xf1b4('0x11')]()[_0xf1b4('0x12')](_0xf1b4('0x13'))[_0xf1b4('0x14')](_0xf1b4('0x41'))[_0xf1b4('0x17')](_0xf1b4('0x44'),_0x1780dc)[_0xf1b4('0x17')](_0x4e145b+_0xf1b4('0x18')+_0xfffb3+'.'+_0x4e145b)))['toString']();}function insertTzCmHopper(_0x3b240a,_0x5216bd,_0x43dce6,_0x249a59,_0x21da91,_0x16f5b2){var _0x3116ab=[_0xf1b4('0x28'),_0xf1b4('0x45')+_0x16f5b2+'.offset-cm_contacts.utcOffset\x20minute)',_0xf1b4('0x2a'),_0xf1b4('0x2b'),_0x5216bd+'.'+_0x249a59,'cm_contacts.createdAt',_0xf1b4('0x2c'),_0xf1b4('0x2d'),'cm_contacts.UserId','\x22'+_0x21da91+'\x22'];var _0x1689a7=squel[_0xf1b4('0x2e')]()[_0xf1b4('0x2f')]('cm_hopper')['fromQuery'](['phone',_0xf1b4('0x31'),_0xf1b4('0x32'),_0xf1b4('0x33'),_0x249a59,_0xf1b4('0x34'),'updatedAt',_0xf1b4('0x36'),_0xf1b4('0x46'),_0xf1b4('0x37')],squel[_0xf1b4('0x11')]()[_0xf1b4('0x38')](_0x3116ab)['from'](_0x5216bd)[_0xf1b4('0x15')](_0xf1b4('0x39'),null,_0xf1b4('0x3a')+_0x5216bd+_0xf1b4('0x42'))[_0xf1b4('0x15')](_0x43dce6,null,_0x43dce6+'.id\x20=\x20'+_0x5216bd+'.'+_0x249a59)[_0xf1b4('0x15')](_0x16f5b2,null,_0x16f5b2+_0xf1b4('0x16')+_0x5216bd+'.'+_0x249a59)[_0xf1b4('0x17')](_0x5216bd+_0xf1b4('0x3b'),_0x3b240a)[_0xf1b4('0x17')](_0xf1b4('0x43'),NOW)[_0xf1b4('0x17')](_0xf1b4('0x3c'),selectNotIn(_0x5216bd,_0x43dce6,_0x249a59,'cm_hopper',[_0xf1b4('0x3d'),'\x22onlyIfOpen\x22']))[_0xf1b4('0x17')](_0xf1b4('0x3c'),selectNotIn(_0x5216bd,_0x43dce6,_0x249a59,_0xf1b4('0x47'),[_0xf1b4('0x3d')])))[_0xf1b4('0x3f')]();return _0x1689a7;}function insertTzCmHopperBlack(_0x374148,_0x308b72,_0x1dc53b,_0x5694a3){var _0x8ac663=[_0xf1b4('0x28'),_0xf1b4('0x2a'),_0xf1b4('0x2b'),_0x308b72+'.'+_0x5694a3,_0xf1b4('0x40'),'cm_contacts.updatedAt'];return squel[_0xf1b4('0x2e')]()[_0xf1b4('0x2f')](_0xf1b4('0x41'))['fromQuery'](['phone',_0xf1b4('0x32'),_0xf1b4('0x33'),_0x5694a3,_0xf1b4('0x34'),_0xf1b4('0x35')],squel['select']()[_0xf1b4('0x38')](_0x8ac663)[_0xf1b4('0x14')](_0x308b72)['join']('cm_contacts',null,_0xf1b4('0x3a')+_0x308b72+_0xf1b4('0x42'))[_0xf1b4('0x15')](_0x1dc53b,null,_0x1dc53b+_0xf1b4('0x16')+_0x308b72+'.'+_0x5694a3)[_0xf1b4('0x17')](_0x308b72+'.CmListId\x20=\x20?',_0x374148)[_0xf1b4('0x17')](_0xf1b4('0x43'),NOW)[_0xf1b4('0x17')](_0xf1b4('0x3c'),squel['select']()[_0xf1b4('0x12')](_0xf1b4('0x13'))[_0xf1b4('0x14')](_0xf1b4('0x41'))[_0xf1b4('0x17')](_0xf1b4('0x44'),_0x374148)[_0xf1b4('0x17')](_0x5694a3+_0xf1b4('0x18')+_0x308b72+'.'+_0x5694a3)))[_0xf1b4('0x3f')]();}function insertCmHopperAdditionalPhones(_0x18fad7){var _0x32e900=[_0xf1b4('0x48'),_0xf1b4('0x49'),_0xf1b4('0x4a'),_0xf1b4('0x4b'),_0xf1b4('0x4c')];return squel['insert']()[_0xf1b4('0x2f')]('cm_hopper_additional_phones')[_0xf1b4('0x30')]([_0xf1b4('0x4d'),_0xf1b4('0x13'),_0xf1b4('0x4e'),_0xf1b4('0x34'),_0xf1b4('0x35')],squel[_0xf1b4('0x11')]()[_0xf1b4('0x38')](_0x32e900)[_0xf1b4('0x14')](_0xf1b4('0x47'))[_0xf1b4('0x15')](_0xf1b4('0x39'),null,_0xf1b4('0x4f'))[_0xf1b4('0x15')](_0xf1b4('0x50'),null,'cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId')[_0xf1b4('0x17')](_0xf1b4('0x51'),_0x18fad7)[_0xf1b4('0x17')](_0xf1b4('0x43'),NOW))[_0xf1b4('0x3f')]();}function insertCmContact(_0x1182a7,_0x411f19,_0x5b2258,_0x9c9375){var _0x11c0a7=_[_0xf1b4('0x52')](_[_0xf1b4('0x53')](_0x9c9375),[_0xf1b4('0x33'),_0xf1b4('0x54'),'createdAt','updatedAt',_0xf1b4('0x55')]);return squel[_0xf1b4('0x2e')]()[_0xf1b4('0x2f')](_0xf1b4('0x39'))[_0xf1b4('0x30')](_0x11c0a7,squel[_0xf1b4('0x11')]()[_0xf1b4('0x38')](_0x11c0a7)[_0xf1b4('0x14')](_0x411f19)[_0xf1b4('0x17')]('('+_0x5b2258[_0xf1b4('0x15')](',')+_0xf1b4('0x56'),squel[_0xf1b4('0x11')]()[_0xf1b4('0x38')](_0x5b2258)[_0xf1b4('0x14')](_0xf1b4('0x39'))[_0xf1b4('0x17')](_0xf1b4('0x44'),_0x1182a7)[_0xf1b4('0x17')](_0xf1b4('0x57')))['where'](_0xf1b4('0x58'),squel[_0xf1b4('0x11')]()[_0xf1b4('0x12')](_0xf1b4('0x59'),'min_id')['from'](_0x411f19)[_0xf1b4('0x5a')](_0x5b2258['join'](','))))[_0xf1b4('0x3f')]();}function handleStop(){logger[_0xf1b4('0x5b')]('Received\x20SIGINT');stopped=!![];}function handleUncaughtException(_0x258c78){logger['error'](_0x258c78[_0xf1b4('0x5c')]);process[_0xf1b4('0x5d')](0x1);}function handleError(_0x256ef2,_0x36ca2c){stats[_0xf1b4('0x5e')][_0xf1b4('0x21')]({'name':_0x36ca2c['code'],'message':_0x36ca2c[_0xf1b4('0x5c')],'row':_0x256ef2});}function handleQuery(_0x54717a){logger[_0xf1b4('0x5b')](_0x54717a);return db['sequelize']['query'](_0x54717a)[_0xf1b4('0x5f')](function(_0x3ea2ce){results[_0xf1b4('0x21')](_0x3ea2ce);})[_0xf1b4('0x60')](function(_0x531150){logger[_0xf1b4('0x61')](_0x531150[_0xf1b4('0x5c')]);});}function updateTzCampaigns(_0x34ab62){return new Promise(function(_0x4228cb,_0x524a01){var _0x4f84c3=squel[_0xf1b4('0x11')]()[_0xf1b4('0x38')]([_0xf1b4('0x62'),_0xf1b4('0x63')])[_0xf1b4('0x14')](_0xf1b4('0x64'))[_0xf1b4('0x15')](_0xf1b4('0x65'),null,_0xf1b4('0x66'))[_0xf1b4('0x17')](_0xf1b4('0x67')+_0x34ab62);db[_0xf1b4('0x68')][_0xf1b4('0x69')](_0x4f84c3[_0xf1b4('0x3f')]())[_0xf1b4('0x5f')](function(_0x381c14){var _0x14a47a=[];for(var _0x11cd10=0x0;_0x11cd10<_0x381c14[_0xf1b4('0x1d')];_0x11cd10++){_0x14a47a['push'](getTimezoneData(_0x381c14[_0x11cd10],tmp_campaigns));}BPromise['all'](_0x14a47a)[_0xf1b4('0x1c')](function(){_0x4228cb({'val':0x1});});})[_0xf1b4('0x60')](function(_0x2144e5){logger[_0xf1b4('0x61')](_0x2144e5['message']);_0x4228cb({'val':0x0});});});}function updateTzVoiceQueues(_0x2916f){return new Promise(function(_0x3cfc8c,_0x11fde0){var _0x4d4321=squel[_0xf1b4('0x11')]()[_0xf1b4('0x38')]([_0xf1b4('0x6a'),_0xf1b4('0x6b')])['from'](_0xf1b4('0x6c'))[_0xf1b4('0x15')]('voice_queues_has_cm_lists',null,_0xf1b4('0x6d'))[_0xf1b4('0x17')](_0xf1b4('0x6e')+_0x2916f);db[_0xf1b4('0x68')]['query'](_0x4d4321['toString']())[_0xf1b4('0x5f')](function(_0xc1b0c9){var _0x5def80=[];for(var _0x927f2b=0x0;_0x927f2b<_0xc1b0c9[_0xf1b4('0x1d')];_0x927f2b++){_0x5def80[_0xf1b4('0x21')](getTimezoneData(_0xc1b0c9[_0x927f2b],tmp_voice_queues));}BPromise[_0xf1b4('0x6f')](_0x5def80)[_0xf1b4('0x1c')](function(){_0x3cfc8c({'val':0x1});});})[_0xf1b4('0x60')](function(_0x5ab416){logger[_0xf1b4('0x61')](_0x5ab416[_0xf1b4('0x5c')]);_0x3cfc8c({'val':0x0});});});}function getTimezoneData(_0x1e4816,_0x543645){return new Promise(function(_0x489488,_0x566c6c){var _0x27ba4a=shared[_0xf1b4('0x70')];var _0x36cba9=_0x27ba4a[_0x1e4816[_0xf1b4('0x71')]];if(_['isNil'](_0x36cba9)){_0x489488({'ret':0x1});}else{var _0x46f98a=_0x36cba9[_0xf1b4('0x72')];var _0x29dad8=squel[_0xf1b4('0x2e')]()[_0xf1b4('0x2f')](_0x543645)[_0xf1b4('0x73')]('id',_0x1e4816['id'])[_0xf1b4('0x73')](_0xf1b4('0x74'),_0x46f98a)[_0xf1b4('0x73')]('dialTimezone',_0x1e4816['dialTimezone'])[_0xf1b4('0x3f')]();return db[_0xf1b4('0x68')][_0xf1b4('0x69')](_0x29dad8)[_0xf1b4('0x5f')](function(_0x32f966){_0x489488({'ret':0x1});})[_0xf1b4('0x60')](function(_0x53e0d0){logger['error'](_0x53e0d0[_0xf1b4('0x5c')]);_0x566c6c({'ret':0x1});});}});}function handleTZQuery(_0x443532){logger[_0xf1b4('0x5b')](_0x443532);return db['sequelize']['query'](_0x443532)[_0xf1b4('0x5f')](function(_0x5d15aa){})['catch'](function(_0x5b968c){logger[_0xf1b4('0x61')](_0x5b968c[_0xf1b4('0x5c')]);});}function main(_0xe429f5,_0x58030f,_0x4d49e0,_0x3593e1){logger['info'](_0xf1b4('0x75'),_0xe429f5,JSON[_0xf1b4('0x76')](_0x58030f));process['send'](_0xf1b4('0x77'));var _0xa818f1=_0x58030f[_0xf1b4('0x78')];var _0x3012ce=_[_0xf1b4('0x79')](_0xa818f1);var _0x143209=_0x58030f['socket_timestamp'];var _0x4aa2f4=path[_0xf1b4('0x15')](config[_0xf1b4('0x7a')],_0xf1b4('0x7b'),_0x143209+_0xf1b4('0x7c'));hasTZ=_[_0xf1b4('0x53')](_0xa818f1)[_0xf1b4('0x7d')]('dialTimezone');var _0x30fc59=_[_0xf1b4('0x53')](_0xa818f1)[_0xf1b4('0x15')]();logger[_0xf1b4('0x5b')]('header',_0x30fc59);db[_0xf1b4('0x7e')]['findAll']({'raw':!![],'attributes':['id',_0xf1b4('0x7f')]})[_0xf1b4('0x1c')](function(_0x19ba90){for(var _0x2e8c1e=0x0;_0x2e8c1e<_0x19ba90[_0xf1b4('0x1d')];_0x2e8c1e++){if(_0x19ba90[_0x2e8c1e]['name']in _0xa818f1){contactItemTypes[_0xf1b4('0x21')](_0x19ba90[_0x2e8c1e]);delete _0x3012ce[_0x19ba90[_0x2e8c1e][_0xf1b4('0x7f')]];hasAdditionalPhones=!![];}for(var _0x59be43 in _0xa818f1){if(_0x19ba90[_0x2e8c1e][_0xf1b4('0x7f')]+_0xf1b4('0x80')===_0x59be43){phoneDescriptions[_0xf1b4('0x21')]({'itemTypeId':_0x19ba90[_0x2e8c1e]['id'],'description':_0x59be43});delete _0x3012ce[_0x59be43];}}}if(hasAdditionalPhones)_0x3012ce['AdditionalPhones']='';var _0x186231=_[_0xf1b4('0x53')](_0x3012ce)[_0xf1b4('0x15')]();logger['info'](_0xf1b4('0x81'),_0x186231);fs['writeFileSync'](_0x4aa2f4,_0x186231+'\x0a');Papa['parse'](fs['createReadStream'](_0xe429f5),{'header':!![],'skipEmptyLines':!![],'step':function(_0x45ea8e,_0x335dfe){try{for(var _0x4054a2=0x0,_0x3f2045=[];_0x4054a2<_0x45ea8e[_0xf1b4('0x82')][_0xf1b4('0x1d')];_0x4054a2++){stats[_0xf1b4('0x83')]+=0x1;if(_0x45ea8e['errors'][_0x4054a2]){handleError(_0x45ea8e[_0xf1b4('0x82')][_0x4054a2],_0x45ea8e[_0xf1b4('0x5e')][_0x4054a2]);}else{var _0x1ae099=[];var _0x17f93c=[];var _0x192622={};for(var _0x289de4 in _0xa818f1){let _0x1c6a65=contactItemTypes[_0xf1b4('0x84')](_0x2a6b3b=>_0x2a6b3b[_0xf1b4('0x7f')]===_0x289de4);let _0xff67fe=contactItemTypes[_0xf1b4('0x84')](_0x5b2298=>_0x5b2298[_0xf1b4('0x7f')]+_0xf1b4('0x80')===_0x289de4);if(_[_0xf1b4('0x1f')](_0x1c6a65)&&_['isNil'](_0xff67fe)){if(_0xa818f1[_0xf1b4('0x85')](_0x289de4)){if(_0x45ea8e[_0xf1b4('0x82')][_0x4054a2][_0xa818f1[_0x289de4]]){var _0x5d1847=_[_0xf1b4('0x86')](_0x45ea8e[_0xf1b4('0x82')][_0x4054a2][_0xa818f1[_0x289de4]][_0xf1b4('0x87')](/"/g,'\x27'));switch(_0x289de4){case'scheduledat':var _0x560740=moment(_0x5d1847,_0xf1b4('0xf'),!![]);if(_0x560740['isValid']()){_0x3f2045[_0xf1b4('0x21')]('\x22'+_0x5d1847+'\x22');}else{_0x1ae099[_0xf1b4('0x21')](_0xf1b4('0x88'));}break;case _0xf1b4('0x36'):var _0x4c072d=parseInt(_0x5d1847);_0x5d1847=_[_0xf1b4('0x89')](_0x4c072d)||_0x4c072d<0x0||_0x4c072d>0x4?_0x3593e1?0x3:0x2:_0x4c072d;_0x3f2045[_0xf1b4('0x21')]('\x22'+_0x5d1847+'\x22');break;case'UserId':var _0x208cf9=parseInt(_0x5d1847);if(_[_0xf1b4('0x8a')](_0x208cf9)&&_[_0xf1b4('0x7d')](_0x4d49e0,_0x208cf9)){_0x3f2045[_0xf1b4('0x21')]('\x22'+_0x208cf9+'\x22');}else{_0x1ae099['push'](_0xf1b4('0x8b'));}break;case _0xf1b4('0x8c'):if(isEmail(_0x5d1847)){_0x3f2045[_0xf1b4('0x21')]('\x22'+_0x5d1847+'\x22');}else{_0x1ae099[_0xf1b4('0x21')]('email\x20wrong\x20format');}break;case _0xf1b4('0x8d'):var _0x9f1e5a=moment(_0x5d1847,_0xf1b4('0x8e'),!![]);if(_0x9f1e5a[_0xf1b4('0x8f')]()){_0x3f2045['push']('\x22'+_0x5d1847+'\x22');}else{_0x1ae099['push'](_0xf1b4('0x90'));}break;case _0xf1b4('0x71'):var _0x47b505=shared[_0xf1b4('0x70')];var _0x616bf5=_0x47b505[_0x5d1847];if(!_['isNil'](_0x616bf5)){var _0x4b9d85=_0x616bf5['utcOffset'];_0x3f2045[_0xf1b4('0x21')]('\x22'+_0x5d1847+'\x22');_0x3f2045['push']('\x22'+_0x4b9d85+'\x22');}break;default:_0x3f2045[_0xf1b4('0x21')]('\x22'+_0x5d1847+'\x22');}}else{switch(_0x289de4){case'firstName':case'phone':_0x1ae099['push'](_0x289de4+_0xf1b4('0x91'));break;default:_0x3f2045['push']('\x22\x22');}}}}else{var _0x2649f0='';if(!_['isNil'](_0x1c6a65)){if(!_0x192622[_0xf1b4('0x85')](_0x1c6a65['id'])){if(!_[_0xf1b4('0x1f')](_0x45ea8e[_0xf1b4('0x82')][_0x4054a2][_0xa818f1[_0x289de4]])){var _0x5d1847=_[_0xf1b4('0x86')](_0x45ea8e['data'][_0x4054a2][_0xa818f1[_0x289de4]][_0xf1b4('0x87')](/"/g,'\x27'));var _0x181289=phoneDescriptions[_0xf1b4('0x84')](_0x174773=>_0x174773[_0xf1b4('0x92')]===_0x1c6a65['id']);if(!_['isNil'](_0x181289)){var _0x340cdc=_[_0xf1b4('0x86')](_0x45ea8e[_0xf1b4('0x82')][_0x4054a2][_0xa818f1[_0x181289[_0xf1b4('0x93')]]][_0xf1b4('0x87')](/"/g,'\x27'));if(!_['isNil'](_0x340cdc))_0x5d1847=_0x5d1847+'§'+_0x340cdc;}if(_0x2649f0=='')_0x2649f0=_0x5d1847;else _0x2649f0+='|'+_0x5d1847;}_0x17f93c[_0xf1b4('0x21')](_0x1c6a65['id']+':'+_0x2649f0);_0x192622[_0x1c6a65['id']]=0x1;}}}}if(hasAdditionalPhones){_0x3f2045['push']('\x22'+_0x17f93c[_0xf1b4('0x15')](';')+'\x22');}if(_0x1ae099[_0xf1b4('0x1d')]){handleError(_0x45ea8e[_0xf1b4('0x82')][_0x4054a2],{'code':_0xf1b4('0x94'),'message':_0x1ae099[_0xf1b4('0x15')]()});}else{fs[_0xf1b4('0x95')](_0x4aa2f4,_0x3f2045[_0xf1b4('0x15')]()+'\x0a');}_0x3f2045=[];}if(!(stats[_0xf1b4('0x83')]%0xc8)){socket[_0xf1b4('0x96')](_0xf1b4('0x97')+_0x143209,stats);stats[_0xf1b4('0x5e')]=[];}}if(stopped){logger[_0xf1b4('0x5b')]('Abort\x20parser');_0x335dfe['abort']();}}catch(_0x5e9198){handleError(_0x45ea8e[_0xf1b4('0x82')][_0x4054a2],{'code':'SystemError','message':_0x5e9198['message']});logger[_0xf1b4('0x61')]('step',_0x5e9198[_0xf1b4('0x5c')]);}},'complete':function(){try{var _0x4da1ba=[];var _0x5a61a5=[];var _0x35c9bd=_0xf1b4('0x39');if(_0x58030f[_0xf1b4('0x98')]&&_0x58030f[_0xf1b4('0x98')][_0xf1b4('0x1d')]){_0x35c9bd=_0xf1b4('0x99')+_0x143209;_0x4da1ba[_0xf1b4('0x21')](_0xf1b4('0x9a')+_0x35c9bd+_0xf1b4('0x9b'));}tmp_campaigns=_0xf1b4('0x9c')+_0x143209;tmp_voice_queues=_0xf1b4('0x9d')+_0x143209;_0x5a61a5['push']('CREATE\x20TABLE\x20'+tmp_campaigns+_0xf1b4('0x9e'));_0x5a61a5[_0xf1b4('0x21')](_0xf1b4('0x9a')+tmp_voice_queues+_0xf1b4('0x9e'));BPromise[_0xf1b4('0x9f')](_0x5a61a5,handleTZQuery)['then'](function(_0x325c94){updateTzCampaigns(_0x58030f[_0xf1b4('0x33')])['then'](function(_0x4f6473){updateTzVoiceQueues(_0x58030f[_0xf1b4('0x33')])[_0xf1b4('0x1c')](function(_0x3ee399){if(hasTZ)_0x186231=_0x186231[_0xf1b4('0x87')]('dialTimezone','dialTimezone,utcOffset');var _0x366d0d=util['format'](_0xf1b4('0xa0'),_0x4aa2f4,_0x35c9bd,_0x186231,_0x58030f[_0xf1b4('0x33')],_0x58030f[_0xf1b4('0x54')]||null,NOW,NOW);if(_[_0xf1b4('0x1f')](_0xa818f1[_0xf1b4('0x31')])){_0x366d0d+=_0xf1b4('0xa1');}_0x4da1ba['push'](_0x366d0d);if(_0x58030f[_0xf1b4('0x98')]&&_0x58030f['duplicates']['length']){_0x4da1ba['push'](insertCmContact(_0x58030f['ListId'],_0x35c9bd,_0x58030f[_0xf1b4('0x98')],_0xa818f1));_0x4da1ba[_0xf1b4('0x21')]('DROP\x20TABLE\x20'+_0x35c9bd+';');}BPromise['each'](_0x4da1ba,handleQuery)[_0xf1b4('0x1c')](function(_0x3c8651){BPromise['all']([handleAdditionalPhones()])[_0xf1b4('0x1c')](function(){_0x4da1ba=[];for(var _0xd98504=0x0;_0xd98504<promisesAdditionalPhones['length'];_0xd98504++){if(promisesAdditionalPhones[_0xd98504][_0xf1b4('0x13')]!='§'){_0x4da1ba[_0xf1b4('0x21')](createAdditionalPhone(promisesAdditionalPhones[_0xd98504]['contactId'],promisesAdditionalPhones[_0xd98504][_0xf1b4('0xa2')],promisesAdditionalPhones[_0xd98504][_0xf1b4('0x13')],promisesAdditionalPhones[_0xd98504][_0xf1b4('0xa3')]));}}BPromise['all'](_0x4da1ba)[_0xf1b4('0x1c')](function(){_0x4da1ba=[];if(hasTZ){_0x4da1ba[_0xf1b4('0x21')](insertTzCmHopper(_0x58030f[_0xf1b4('0x33')],_0xf1b4('0xa4'),_0xf1b4('0x6c'),'VoiceQueueId',_0x3593e1,tmp_voice_queues));_0x4da1ba['push'](insertTzCmHopperBlack(_0x58030f[_0xf1b4('0x33')],_0xf1b4('0xa5'),_0xf1b4('0x6c'),_0xf1b4('0xa6')));_0x4da1ba[_0xf1b4('0x21')](insertTzCmHopper(_0x58030f['ListId'],_0xf1b4('0x65'),_0xf1b4('0x64'),_0xf1b4('0xa7'),_0x3593e1,tmp_campaigns));_0x4da1ba[_0xf1b4('0x21')](insertTzCmHopperBlack(_0x58030f[_0xf1b4('0x33')],'campaigns_has_cm_blacklists',_0xf1b4('0x64'),'CampaignId'));_0x4da1ba[_0xf1b4('0x21')](insertCmHopperAdditionalPhones(_0x58030f['ListId']));}else{_0x4da1ba[_0xf1b4('0x21')](insertCmHopper(_0x58030f[_0xf1b4('0x33')],_0xf1b4('0xa4'),_0xf1b4('0x6c'),_0xf1b4('0xa6'),_0x3593e1));_0x4da1ba[_0xf1b4('0x21')](insertCmHopperBlack(_0x58030f[_0xf1b4('0x33')],_0xf1b4('0xa5'),_0xf1b4('0x6c'),_0xf1b4('0xa6')));_0x4da1ba['push'](insertCmHopper(_0x58030f[_0xf1b4('0x33')],_0xf1b4('0x65'),_0xf1b4('0x64'),'CampaignId',_0x3593e1));_0x4da1ba[_0xf1b4('0x21')](insertCmHopperBlack(_0x58030f[_0xf1b4('0x33')],'campaigns_has_cm_blacklists','campaigns',_0xf1b4('0xa7')));_0x4da1ba['push'](insertCmHopperAdditionalPhones(_0x58030f[_0xf1b4('0x33')]));}_0x4da1ba['push'](_0xf1b4('0xa8')+tmp_campaigns+';');_0x4da1ba[_0xf1b4('0x21')](_0xf1b4('0xa8')+tmp_voice_queues+';');BPromise[_0xf1b4('0x9f')](_0x4da1ba,handleQuery)['then'](function(_0xdb4edc){stats[_0xf1b4('0xa9')]=!![];stats['affectedRows']=_0x58030f[_0xf1b4('0x98')]&&_0x58030f[_0xf1b4('0x98')]['length']?results[0x2][_0xf1b4('0xaa')]:results[0x0]['affectedRows'];socket[_0xf1b4('0x96')](_0xf1b4('0x97')+_0x143209,stats);fs['unlink'](_0xe429f5);fs['unlink'](_0x4aa2f4);process[_0xf1b4('0x5d')](0x0);})[_0xf1b4('0x60')](function(_0x1f98e1){logger[_0xf1b4('0x61')](_0x1f98e1['message']);process[_0xf1b4('0x5d')](0x1);});});});})[_0xf1b4('0x60')](function(_0x26ede2){logger['error'](_0x26ede2[_0xf1b4('0x5c')]);process[_0xf1b4('0x5d')](0x1);});});});});}catch(_0x5c0420){logger[_0xf1b4('0x61')](_0xf1b4('0xab'),_0x5c0420['message']);process[_0xf1b4('0x5d')](0x1);}},'error':function(_0x3f76c1,_0x6686d1,_0x2cac8a,_0x13a069){throw new Error(_0x13a069);}});});}function validate(){if(process[_0xf1b4('0xac')]&&process['argv']['length']<0x4){throw new Error(_0xf1b4('0xad'));}var _0x341675=path[_0xf1b4('0x15')](config[_0xf1b4('0x7a')],_0xf1b4('0x7b'),process[_0xf1b4('0xac')][0x2]);if(!fs['existsSync'](_0x341675)){throw new Error(_0xf1b4('0xae'));}var _0x109d0a={};try{_0x109d0a=JSON[_0xf1b4('0xaf')](process[_0xf1b4('0xac')][0x3]);if(!_0x109d0a[_0xf1b4('0x78')]){throw new Error(_0xf1b4('0xb0'));}if(!_0x109d0a[_0xf1b4('0x78')][_0xf1b4('0x13')]){throw new Error(_0xf1b4('0xb1'));}if(!_0x109d0a[_0xf1b4('0x78')]['firstName']){throw new Error(_0xf1b4('0xb2'));}var _0x30195d=0x0;if(_0x109d0a[_0xf1b4('0x78')][_0xf1b4('0x46')]){_0x30195d=0x1;}if(!_0x109d0a['ListId']){throw new Error(_0xf1b4('0xb3'));}}catch(_0x4a62c6){throw new Error(_0xf1b4('0xb4'));}var _0x17afc5=[];try{_0x17afc5=_[_0xf1b4('0xb5')](JSON[_0xf1b4('0xaf')](process[_0xf1b4('0xac')][0x4]),'id');}catch(_0x5034cd){logger['info']('No\x20agent\x20available');}main(_0x341675,_0x109d0a,_0x17afc5,_0x30195d);}validate();process['on'](_0xf1b4('0xb6'),handleStop);process['on'](_0xf1b4('0xb7'),handleUncaughtException);
\ No newline at end of file
+var _0xb835=['deletedAt\x20IS\x20NULL','id\x20IN\x20?','group','Received\x20SIGINT','error','exit','errors','code','message','sequelize','spread','catch','campaigns','campaigns_has_cm_lists','campaigns.id\x20=\x20campaigns_has_cm_lists.CampaignId','campaigns_has_cm_lists.CmListId=','query','voice_queues.id','voice_queues.dialTimezone','voice_queues','voice_queues_has_cm_lists','voice_queues.id\x20=\x20voice_queues_has_cm_lists.VoiceQueueId','voice_queues_has_cm_lists.CmListId=','timezones','dialTimezone','utcOffset','set','offset','info','main','stringify','send','binding','clone','socket_timestamp','server/files/tmp','.csv','keys','header','name','writeFileSync','createReadStream','data','rows','hasOwnProperty','replace','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','includes','agent\x20not\x20exists','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','isValid','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','trim','find','itemTypeId','description','SystemRow','emit','contact:import:','Abort\x20parser','abort','SystemError','step','duplicates','cm_contacts_','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','campaigns_','voice_queues_','(id\x20int,dialTimezone\x20varchar(255),offset\x20int);','each','dialTimezone,utcOffset',',\x20scheduledAt\x20=\x20NOW()','DROP\x20TABLE\x20','contactId','contactTypeId','orderBy','VoiceQueueId','voice_queues_has_cm_blacklists','CampaignId','campaigns_has_cm_blacklists','finish','affectedRows','unlink','complete','argv','root','existsSync','file\x20doesn\x27t\x20exists','parse','binding\x20doesn\x27t\x20exists','phone\x20is\x20mandatory','firstName\x20is\x20mandatory','body\x20id\x20mandatory','map','No\x20agent\x20available','path','lodash','papaparse','util','bluebird','moment','squel','../../../mysqldb','../../../config/environment','../../../config/environment/shared','../../../config/logger','redis','localhost','format','YYYY-MM-DD\x20HH:mm:ss','test','select','from','join','.id\x20=\x20','where','\x20=\x20','findAll','then','length','push','all','AdditionalPhones','split','isNil','filter','CmContactHasItem','updated','create','PHONE','inserted','cm_contacts.phone','cm_contacts.id','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','insert','cm_hopper','ContactId','createdAt','updatedAt','priority','recallme','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','cm_contacts.createdAt\x20=\x20?','\x22always\x22','\x22onlyIfOpen\x22','cm_contacts.phone\x20NOT\x20IN\x20(?)','toString','cm_contacts.ListId','cm_contacts.createdAt','into','cm_hopper_black','fromQuery','phone','fields','field','date_add(cm_contacts.scheduledat,interval\x20','.offset-cm_contacts.utcOffset\x20minute)','scheduledat','ListId','UserId','.CmListId\x20=\x20?','ListId\x20=\x20?','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','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?','CompanyId','scheduledAt',')\x20NOT\x20IN\x20?'];(function(_0x22770b,_0x41fd48){var _0x4af8d2=function(_0x3b2de9){while(--_0x3b2de9){_0x22770b['push'](_0x22770b['shift']());}};_0x4af8d2(++_0x41fd48);}(_0xb835,0x1d9));var _0x5b83=function(_0x3e480c,_0x26f38c){_0x3e480c=_0x3e480c-0x0;var _0x20b860=_0xb835[_0x3e480c];return _0x20b860;};'use strict';var fs=require('fs');var path=require(_0x5b83('0x0'));var _=require(_0x5b83('0x1'));var Papa=require(_0x5b83('0x2'));var util=require(_0x5b83('0x3'));var BPromise=require(_0x5b83('0x4'));var moment=require(_0x5b83('0x5'));var squel=require(_0x5b83('0x6'));var Redis=require('ioredis');var db=require(_0x5b83('0x7'))['db'];var config=require(_0x5b83('0x8'));var shared=require(_0x5b83('0x9'));var logger=require(_0x5b83('0xa'))('import');config[_0x5b83('0xb')]=_['defaults'](config[_0x5b83('0xb')],{'host':_0x5b83('0xc'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()[_0x5b83('0xd')](_0x5b83('0xe'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];var tmp_voice_queues;var tmp_campaigns;var tzOffset=0x0;var hasTZ;var NOW=moment()['format']('YYYY-MM-DD\x20HH:mm:ss');function isEmail(_0x53f572){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))*$/[_0x5b83('0xf')](_0x53f572);}function selectNotIn(_0x34d3df,_0x51a760,_0x1bc917,_0x16a7f8,_0x315483){return squel[_0x5b83('0x10')]()['field']('phone')[_0x5b83('0x11')](_0x16a7f8)[_0x5b83('0x12')](_0x51a760,null,_0x51a760+_0x5b83('0x13')+_0x16a7f8+'.'+_0x1bc917)[_0x5b83('0x14')](_0x16a7f8+'.'+_0x1bc917+_0x5b83('0x15')+_0x34d3df+'.'+_0x1bc917)['where'](_0x51a760+'.dialCheckDuplicateType\x20IN\x20('+_0x315483['join']()+')');}function handleAdditionalPhones(){return new Promise(function(_0x1bec20,_0x293501){promisesAdditionalPhones=[];return db['CmContact'][_0x5b83('0x16')]({'raw':!![],'attributes':['id','AdditionalPhones'],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})[_0x5b83('0x17')](function(_0x3a6fe5){if(_0x3a6fe5!==null){var _0x335f08=[];for(var _0xdeb6bf=0x0;_0xdeb6bf<_0x3a6fe5[_0x5b83('0x18')];_0xdeb6bf++){var _0x4e1b03=_0x3a6fe5[_0xdeb6bf];_0x335f08[_0x5b83('0x19')](insertAdditionalPhones(_0x4e1b03));}}Promise[_0x5b83('0x1a')](_0x335f08)[_0x5b83('0x17')](function(){_0x1bec20({'val':0x1});});});});}function insertAdditionalPhones(_0x152514){return new Promise(function(_0x261a89,_0xff14c5){var _0x3219f7=_0x152514[_0x5b83('0x1b')];var _0x102e87=_0x3219f7[_0x5b83('0x1c')](';');var _0xbf0451=[];orderBy=0x0;for(var _0x3338e7=0x0;_0x3338e7<_0x102e87[_0x5b83('0x18')];_0x3338e7++){_0xbf0451[_0x5b83('0x19')](splitAdditionalPhone(_0x152514['id'],_0x102e87[_0x3338e7]));}Promise[_0x5b83('0x1a')](_0xbf0451)[_0x5b83('0x17')](function(){_0x261a89({'val':_0x102e87[_0x5b83('0x18')]});});});}function splitAdditionalPhone(_0x34c546,_0x3d3c24){return new Promise(function(_0x177172,_0x451382){var _0x9c0f6=_0x3d3c24[_0x5b83('0x1c')](':');var _0x5b4fc1=_0x9c0f6[0x0];var _0x5c887a=_0x9c0f6[0x1];if(!_[_0x5b83('0x1d')](_0x5c887a)){var _0x305c7e=_0x5c887a[_0x5b83('0x1c')]('|');var _0x5c32ab=[];for(var _0x296b6e=0x0;_0x296b6e<_0x305c7e['length'];_0x296b6e++){if(_0x305c7e[_0x296b6e]!==''){var _0xb0f4bb=_[_0x5b83('0x1e')](promisesAdditionalPhones,{'contactId':_0x34c546,'phone':_0x305c7e[_0x296b6e]});if(_0xb0f4bb[_0x5b83('0x18')]==0x0){orderBy++;promisesAdditionalPhones[_0x5b83('0x19')]({'contactId':_0x34c546,'contactTypeId':_0x5b4fc1,'phone':_0x305c7e[_0x296b6e],'orderBy':orderBy});}}}_0x177172({'ok':0x1});}else _0x177172({'res':0x0});});}function createAdditionalPhone(_0x143d5,_0x5d569b,_0x2069c9,_0x5d4413){var _0x37671c='';var _0x59c5b6='';var _0x46d6bc=_0x2069c9['split']('§');_0x37671c=_0x46d6bc[0x0];if(_0x46d6bc[_0x5b83('0x18')]==0x2)_0x59c5b6=_0x46d6bc[0x1];return new Promise(function(_0x3c3b1f,_0x5a30c2){return db['CmContactHasItem']['findOne']({'where':{'CmContactId':_0x143d5,'item':_0x37671c}})[_0x5b83('0x17')](function(_0x4bc911){if(_0x4bc911){return db[_0x5b83('0x1f')]['update']({'ItemTypeId':_0x5d569b,'description':_0x59c5b6,'OrderBy':_0x5d4413},{'where':{'CmContactId':_0x143d5,'item':_0x37671c}})['then'](function(_0x4f40c4){_0x3c3b1f({'res':_0x5b83('0x20')});});}else{return db[_0x5b83('0x1f')][_0x5b83('0x21')]({'CmContactId':_0x143d5,'item':_0x37671c,'description':_0x59c5b6,'ItemTypeId':_0x5d569b,'OrderBy':_0x5d4413,'ItemClass':_0x5b83('0x22')})[_0x5b83('0x17')](function(_0x4f1b6d){_0x3c3b1f({'res':_0x5b83('0x23')});});}});});}function insertCmHopper(_0x188e6f,_0x2e05b1,_0x13b27b,_0x509225,_0x518b68){var _0x27ec22=[_0x5b83('0x24'),'cm_contacts.scheduledat',_0x5b83('0x25'),'cm_contacts.ListId',_0x2e05b1+'.'+_0x509225,'cm_contacts.createdAt',_0x5b83('0x26'),_0x5b83('0x27'),_0x5b83('0x28'),'\x22'+_0x518b68+'\x22'];return squel[_0x5b83('0x29')]()['into'](_0x5b83('0x2a'))['fromQuery'](['phone','scheduledat',_0x5b83('0x2b'),'ListId',_0x509225,_0x5b83('0x2c'),_0x5b83('0x2d'),_0x5b83('0x2e'),'UserId',_0x5b83('0x2f')],squel[_0x5b83('0x10')]()['fields'](_0x27ec22)[_0x5b83('0x11')](_0x2e05b1)[_0x5b83('0x12')](_0x5b83('0x30'),null,_0x5b83('0x31')+_0x2e05b1+_0x5b83('0x32'))[_0x5b83('0x12')](_0x13b27b,null,_0x13b27b+_0x5b83('0x13')+_0x2e05b1+'.'+_0x509225)['where'](_0x2e05b1+'.CmListId\x20=\x20?',_0x188e6f)[_0x5b83('0x14')](_0x5b83('0x33'),NOW)['where']('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x2e05b1,_0x13b27b,_0x509225,_0x5b83('0x2a'),[_0x5b83('0x34'),_0x5b83('0x35')]))['where'](_0x5b83('0x36'),selectNotIn(_0x2e05b1,_0x13b27b,_0x509225,'cm_hopper',[_0x5b83('0x34')])))[_0x5b83('0x37')]();}function insertCmHopperBlack(_0x3a68f4,_0xdca7f6,_0x4bf2a2,_0x30a63e){var _0x11edd7=[_0x5b83('0x24'),'cm_contacts.id',_0x5b83('0x38'),_0xdca7f6+'.'+_0x30a63e,_0x5b83('0x39'),_0x5b83('0x26')];return squel[_0x5b83('0x29')]()[_0x5b83('0x3a')](_0x5b83('0x3b'))[_0x5b83('0x3c')]([_0x5b83('0x3d'),_0x5b83('0x2b'),'ListId',_0x30a63e,_0x5b83('0x2c'),_0x5b83('0x2d')],squel['select']()[_0x5b83('0x3e')](_0x11edd7)[_0x5b83('0x11')](_0xdca7f6)[_0x5b83('0x12')]('cm_contacts',null,_0x5b83('0x31')+_0xdca7f6+_0x5b83('0x32'))['join'](_0x4bf2a2,null,_0x4bf2a2+'.id\x20=\x20'+_0xdca7f6+'.'+_0x30a63e)[_0x5b83('0x14')](_0xdca7f6+'.CmListId\x20=\x20?',_0x3a68f4)[_0x5b83('0x14')](_0x5b83('0x33'),NOW)['where'](_0x5b83('0x36'),squel[_0x5b83('0x10')]()[_0x5b83('0x3f')]('phone')[_0x5b83('0x11')](_0x5b83('0x3b'))['where']('ListId\x20=\x20?',_0x3a68f4)[_0x5b83('0x14')](_0x30a63e+_0x5b83('0x15')+_0xdca7f6+'.'+_0x30a63e)))[_0x5b83('0x37')]();}function insertTzCmHopper(_0x71758,_0xc0259,_0x11e69b,_0x14f174,_0x33a136,_0x530785){var _0x151939=[_0x5b83('0x24'),_0x5b83('0x40')+_0x530785+_0x5b83('0x41'),_0x5b83('0x25'),_0x5b83('0x38'),_0xc0259+'.'+_0x14f174,_0x5b83('0x39'),_0x5b83('0x26'),'cm_contacts.priority',_0x5b83('0x28'),'\x22'+_0x33a136+'\x22'];var _0x28d4ae=squel[_0x5b83('0x29')]()[_0x5b83('0x3a')](_0x5b83('0x2a'))[_0x5b83('0x3c')]([_0x5b83('0x3d'),_0x5b83('0x42'),_0x5b83('0x2b'),_0x5b83('0x43'),_0x14f174,_0x5b83('0x2c'),_0x5b83('0x2d'),_0x5b83('0x2e'),_0x5b83('0x44'),_0x5b83('0x2f')],squel['select']()[_0x5b83('0x3e')](_0x151939)[_0x5b83('0x11')](_0xc0259)[_0x5b83('0x12')](_0x5b83('0x30'),null,'cm_contacts.ListId\x20=\x20'+_0xc0259+_0x5b83('0x32'))['join'](_0x11e69b,null,_0x11e69b+_0x5b83('0x13')+_0xc0259+'.'+_0x14f174)[_0x5b83('0x12')](_0x530785,null,_0x530785+'.id\x20=\x20'+_0xc0259+'.'+_0x14f174)[_0x5b83('0x14')](_0xc0259+'.CmListId\x20=\x20?',_0x71758)[_0x5b83('0x14')]('cm_contacts.createdAt\x20=\x20?',NOW)['where'](_0x5b83('0x36'),selectNotIn(_0xc0259,_0x11e69b,_0x14f174,_0x5b83('0x2a'),[_0x5b83('0x34'),_0x5b83('0x35')]))[_0x5b83('0x14')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0xc0259,_0x11e69b,_0x14f174,_0x5b83('0x2a'),['\x22always\x22'])))['toString']();return _0x28d4ae;}function insertTzCmHopperBlack(_0x563186,_0x42f40e,_0x114da9,_0x2e5056){var _0x1646b4=[_0x5b83('0x24'),_0x5b83('0x25'),_0x5b83('0x38'),_0x42f40e+'.'+_0x2e5056,_0x5b83('0x39'),'cm_contacts.updatedAt'];return squel['insert']()[_0x5b83('0x3a')](_0x5b83('0x3b'))['fromQuery']([_0x5b83('0x3d'),'ContactId','ListId',_0x2e5056,_0x5b83('0x2c'),'updatedAt'],squel['select']()[_0x5b83('0x3e')](_0x1646b4)[_0x5b83('0x11')](_0x42f40e)[_0x5b83('0x12')](_0x5b83('0x30'),null,_0x5b83('0x31')+_0x42f40e+_0x5b83('0x32'))[_0x5b83('0x12')](_0x114da9,null,_0x114da9+_0x5b83('0x13')+_0x42f40e+'.'+_0x2e5056)[_0x5b83('0x14')](_0x42f40e+_0x5b83('0x45'),_0x563186)[_0x5b83('0x14')](_0x5b83('0x33'),NOW)[_0x5b83('0x14')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel[_0x5b83('0x10')]()[_0x5b83('0x3f')](_0x5b83('0x3d'))[_0x5b83('0x11')](_0x5b83('0x3b'))[_0x5b83('0x14')](_0x5b83('0x46'),_0x563186)[_0x5b83('0x14')](_0x2e5056+_0x5b83('0x15')+_0x42f40e+'.'+_0x2e5056)))[_0x5b83('0x37')]();}function insertCmHopperAdditionalPhones(_0x309f3c){var _0x2c2e1f=[_0x5b83('0x47'),_0x5b83('0x48'),_0x5b83('0x49'),_0x5b83('0x4a'),_0x5b83('0x4b')];return squel[_0x5b83('0x29')]()['into']('cm_hopper_additional_phones')[_0x5b83('0x3c')]([_0x5b83('0x4c'),_0x5b83('0x3d'),_0x5b83('0x4d'),'createdAt',_0x5b83('0x2d')],squel[_0x5b83('0x10')]()[_0x5b83('0x3e')](_0x2c2e1f)[_0x5b83('0x11')](_0x5b83('0x2a'))[_0x5b83('0x12')](_0x5b83('0x30'),null,_0x5b83('0x4e'))[_0x5b83('0x12')](_0x5b83('0x4f'),null,_0x5b83('0x50'))[_0x5b83('0x14')](_0x5b83('0x51'),_0x309f3c)['where'](_0x5b83('0x33'),NOW))['toString']();}function insertCmContact(_0xf5892d,_0x2d1875,_0x5fd535,_0xe623b1){var _0x16460f=_['concat'](_['keys'](_0xe623b1),[_0x5b83('0x43'),_0x5b83('0x52'),'createdAt',_0x5b83('0x2d'),_0x5b83('0x53')]);return squel['insert']()[_0x5b83('0x3a')](_0x5b83('0x30'))['fromQuery'](_0x16460f,squel['select']()[_0x5b83('0x3e')](_0x16460f)['from'](_0x2d1875)[_0x5b83('0x14')]('('+_0x5fd535[_0x5b83('0x12')](',')+_0x5b83('0x54'),squel[_0x5b83('0x10')]()['fields'](_0x5fd535)[_0x5b83('0x11')]('cm_contacts')['where'](_0x5b83('0x46'),_0xf5892d)[_0x5b83('0x14')](_0x5b83('0x55')))[_0x5b83('0x14')](_0x5b83('0x56'),squel[_0x5b83('0x10')]()['field']('MIN(id)','min_id')[_0x5b83('0x11')](_0x2d1875)[_0x5b83('0x57')](_0x5fd535[_0x5b83('0x12')](','))))[_0x5b83('0x37')]();}function handleStop(){logger['info'](_0x5b83('0x58'));stopped=!![];}function handleUncaughtException(_0x1fe24f){logger[_0x5b83('0x59')](_0x1fe24f['message']);process[_0x5b83('0x5a')](0x1);}function handleError(_0x144a13,_0x46d1a7){stats[_0x5b83('0x5b')][_0x5b83('0x19')]({'name':_0x46d1a7[_0x5b83('0x5c')],'message':_0x46d1a7[_0x5b83('0x5d')],'row':_0x144a13});}function handleQuery(_0x208737){logger['info'](_0x208737);return db[_0x5b83('0x5e')]['query'](_0x208737)[_0x5b83('0x5f')](function(_0xad8b2){results[_0x5b83('0x19')](_0xad8b2);})[_0x5b83('0x60')](function(_0x401df8){logger[_0x5b83('0x59')](_0x401df8[_0x5b83('0x5d')]);});}function updateTzCampaigns(_0x4a7efd){return new Promise(function(_0x576111,_0x46669e){var _0x1cab9c=squel[_0x5b83('0x10')]()[_0x5b83('0x3e')](['campaigns.id','campaigns.dialTimezone'])[_0x5b83('0x11')](_0x5b83('0x61'))[_0x5b83('0x12')](_0x5b83('0x62'),null,_0x5b83('0x63'))[_0x5b83('0x14')](_0x5b83('0x64')+_0x4a7efd);db['sequelize'][_0x5b83('0x65')](_0x1cab9c['toString']())['spread'](function(_0x36efee){var _0x1d2e48=[];for(var _0x1b071f=0x0;_0x1b071f<_0x36efee[_0x5b83('0x18')];_0x1b071f++){_0x1d2e48[_0x5b83('0x19')](getTimezoneData(_0x36efee[_0x1b071f],tmp_campaigns));}BPromise[_0x5b83('0x1a')](_0x1d2e48)[_0x5b83('0x17')](function(){_0x576111({'val':0x1});});})['catch'](function(_0x5293fc){logger[_0x5b83('0x59')](_0x5293fc[_0x5b83('0x5d')]);_0x576111({'val':0x0});});});}function updateTzVoiceQueues(_0x429843){return new Promise(function(_0x56711a,_0x55c5d0){var _0xb06d52=squel[_0x5b83('0x10')]()['fields']([_0x5b83('0x66'),_0x5b83('0x67')])[_0x5b83('0x11')](_0x5b83('0x68'))['join'](_0x5b83('0x69'),null,_0x5b83('0x6a'))['where'](_0x5b83('0x6b')+_0x429843);db['sequelize'][_0x5b83('0x65')](_0xb06d52[_0x5b83('0x37')]())['spread'](function(_0x435f84){var _0x467c31=[];for(var _0x42126a=0x0;_0x42126a<_0x435f84[_0x5b83('0x18')];_0x42126a++){_0x467c31[_0x5b83('0x19')](getTimezoneData(_0x435f84[_0x42126a],tmp_voice_queues));}BPromise[_0x5b83('0x1a')](_0x467c31)[_0x5b83('0x17')](function(){_0x56711a({'val':0x1});});})[_0x5b83('0x60')](function(_0x22cb79){logger[_0x5b83('0x59')](_0x22cb79['message']);_0x56711a({'val':0x0});});});}function getTimezoneData(_0x424085,_0x1c447f){return new Promise(function(_0x2feb85,_0x4b5f43){var _0x1e6f7a=shared[_0x5b83('0x6c')];var _0x1a1fbe=_0x1e6f7a[_0x424085[_0x5b83('0x6d')]];if(_[_0x5b83('0x1d')](_0x1a1fbe)){_0x2feb85({'ret':0x1});}else{var _0xc53dc=_0x1a1fbe[_0x5b83('0x6e')];var _0x13c6f3=squel['insert']()[_0x5b83('0x3a')](_0x1c447f)[_0x5b83('0x6f')]('id',_0x424085['id'])['set'](_0x5b83('0x70'),_0xc53dc)['set'](_0x5b83('0x6d'),_0x424085[_0x5b83('0x6d')])['toString']();return db[_0x5b83('0x5e')][_0x5b83('0x65')](_0x13c6f3)['spread'](function(_0x2ae105){_0x2feb85({'ret':0x1});})[_0x5b83('0x60')](function(_0x4482c0){logger[_0x5b83('0x59')](_0x4482c0[_0x5b83('0x5d')]);_0x4b5f43({'ret':0x1});});}});}function handleTZQuery(_0x3f0cd0){logger[_0x5b83('0x71')](_0x3f0cd0);return db['sequelize'][_0x5b83('0x65')](_0x3f0cd0)[_0x5b83('0x5f')](function(_0x1781cc){})['catch'](function(_0x594c32){logger['error'](_0x594c32[_0x5b83('0x5d')]);});}function main(_0x597d5a,_0x3bcabb,_0x43d803,_0xa8ee8b){logger['info'](_0x5b83('0x72'),_0x597d5a,JSON[_0x5b83('0x73')](_0x3bcabb));process[_0x5b83('0x74')]('start');var _0x5bcbeb=_0x3bcabb[_0x5b83('0x75')];var _0x3cb511=_[_0x5b83('0x76')](_0x5bcbeb);var _0x21a516=_0x3bcabb[_0x5b83('0x77')];var _0x49f2bb=path[_0x5b83('0x12')](config['root'],_0x5b83('0x78'),_0x21a516+_0x5b83('0x79'));hasTZ=_[_0x5b83('0x7a')](_0x5bcbeb)['includes'](_0x5b83('0x6d'));var _0x3dd04b=_[_0x5b83('0x7a')](_0x5bcbeb)[_0x5b83('0x12')]();logger[_0x5b83('0x71')](_0x5b83('0x7b'),_0x3dd04b);db['ContactItemType']['findAll']({'raw':!![],'attributes':['id',_0x5b83('0x7c')]})[_0x5b83('0x17')](function(_0x1ca482){for(var _0x18baa4=0x0;_0x18baa4<_0x1ca482['length'];_0x18baa4++){if(_0x1ca482[_0x18baa4][_0x5b83('0x7c')]in _0x5bcbeb){contactItemTypes[_0x5b83('0x19')](_0x1ca482[_0x18baa4]);delete _0x3cb511[_0x1ca482[_0x18baa4][_0x5b83('0x7c')]];hasAdditionalPhones=!![];}for(var _0x4abd0b in _0x5bcbeb){if(_0x1ca482[_0x18baa4]['name']+'_description'===_0x4abd0b){phoneDescriptions[_0x5b83('0x19')]({'itemTypeId':_0x1ca482[_0x18baa4]['id'],'description':_0x4abd0b});delete _0x3cb511[_0x4abd0b];}}}if(hasAdditionalPhones)_0x3cb511[_0x5b83('0x1b')]='';var _0x3ae8a1=_[_0x5b83('0x7a')](_0x3cb511)[_0x5b83('0x12')]();logger[_0x5b83('0x71')](_0x5b83('0x7b'),_0x3ae8a1);fs[_0x5b83('0x7d')](_0x49f2bb,_0x3ae8a1+'\x0a');Papa['parse'](fs[_0x5b83('0x7e')](_0x597d5a),{'header':!![],'skipEmptyLines':!![],'step':function(_0x56fcf1,_0x3be8b2){try{for(var _0x1e96b0=0x0,_0x26f087=[];_0x1e96b0<_0x56fcf1[_0x5b83('0x7f')][_0x5b83('0x18')];_0x1e96b0++){stats[_0x5b83('0x80')]+=0x1;if(_0x56fcf1[_0x5b83('0x5b')][_0x1e96b0]){handleError(_0x56fcf1[_0x5b83('0x7f')][_0x1e96b0],_0x56fcf1['errors'][_0x1e96b0]);}else{var _0x1a7e02=[];var _0x5a9e3b=[];var _0x4fb8ef={};for(var _0x4d1b1e in _0x5bcbeb){let _0x3d666a=contactItemTypes['find'](_0x7d41a7=>_0x7d41a7['name']===_0x4d1b1e);let _0x4a4c43=contactItemTypes['find'](_0x33f7ea=>_0x33f7ea['name']+'_description'===_0x4d1b1e);if(_[_0x5b83('0x1d')](_0x3d666a)&&_[_0x5b83('0x1d')](_0x4a4c43)){if(_0x5bcbeb[_0x5b83('0x81')](_0x4d1b1e)){if(_0x56fcf1[_0x5b83('0x7f')][_0x1e96b0][_0x5bcbeb[_0x4d1b1e]]){var _0x450df2=_['trim'](_0x56fcf1[_0x5b83('0x7f')][_0x1e96b0][_0x5bcbeb[_0x4d1b1e]][_0x5b83('0x82')](/"/g,'\x27'));switch(_0x4d1b1e){case _0x5b83('0x42'):var _0x39c0ad=moment(_0x450df2,_0x5b83('0xe'),!![]);if(_0x39c0ad['isValid']()){_0x26f087['push']('\x22'+_0x450df2+'\x22');}else{_0x1a7e02[_0x5b83('0x19')](_0x5b83('0x83'));}break;case _0x5b83('0x2e'):var _0x5160f1=parseInt(_0x450df2);_0x450df2=_[_0x5b83('0x84')](_0x5160f1)||_0x5160f1<0x0||_0x5160f1>0x4?_0xa8ee8b?0x3:0x2:_0x5160f1;_0x26f087[_0x5b83('0x19')]('\x22'+_0x450df2+'\x22');break;case _0x5b83('0x44'):var _0x51a47e=parseInt(_0x450df2);if(_['isNumber'](_0x51a47e)&&_[_0x5b83('0x85')](_0x43d803,_0x51a47e)){_0x26f087[_0x5b83('0x19')]('\x22'+_0x51a47e+'\x22');}else{_0x1a7e02[_0x5b83('0x19')](_0x5b83('0x86'));}break;case'email':if(isEmail(_0x450df2)){_0x26f087[_0x5b83('0x19')]('\x22'+_0x450df2+'\x22');}else{_0x1a7e02[_0x5b83('0x19')](_0x5b83('0x87'));}break;case _0x5b83('0x88'):var _0x156116=moment(_0x450df2,_0x5b83('0x89'),!![]);if(_0x156116[_0x5b83('0x8a')]()){_0x26f087['push']('\x22'+_0x450df2+'\x22');}else{_0x1a7e02[_0x5b83('0x19')](_0x5b83('0x8b'));}break;case _0x5b83('0x6d'):var _0x5e485b=shared[_0x5b83('0x6c')];var _0x41c9fc=_0x5e485b[_0x450df2];if(!_[_0x5b83('0x1d')](_0x41c9fc)){var _0x3faf90=_0x41c9fc['utcOffset'];_0x26f087[_0x5b83('0x19')]('\x22'+_0x450df2+'\x22');_0x26f087[_0x5b83('0x19')]('\x22'+_0x3faf90+'\x22');}break;default:_0x26f087['push']('\x22'+_0x450df2+'\x22');}}else{switch(_0x4d1b1e){case _0x5b83('0x8c'):case _0x5b83('0x3d'):_0x1a7e02[_0x5b83('0x19')](_0x4d1b1e+_0x5b83('0x8d'));break;default:_0x26f087[_0x5b83('0x19')]('\x22\x22');}}}}else{var _0xdcb855='';if(!_[_0x5b83('0x1d')](_0x3d666a)){if(!_0x4fb8ef[_0x5b83('0x81')](_0x3d666a['id'])){if(!_['isNil'](_0x56fcf1[_0x5b83('0x7f')][_0x1e96b0][_0x5bcbeb[_0x4d1b1e]])){var _0x450df2=_[_0x5b83('0x8e')](_0x56fcf1[_0x5b83('0x7f')][_0x1e96b0][_0x5bcbeb[_0x4d1b1e]]['replace'](/"/g,'\x27'));var _0xa67365=phoneDescriptions[_0x5b83('0x8f')](_0x535bc1=>_0x535bc1[_0x5b83('0x90')]===_0x3d666a['id']);if(!_[_0x5b83('0x1d')](_0xa67365)){var _0x126421=_['trim'](_0x56fcf1[_0x5b83('0x7f')][_0x1e96b0][_0x5bcbeb[_0xa67365[_0x5b83('0x91')]]][_0x5b83('0x82')](/"/g,'\x27'));if(!_[_0x5b83('0x1d')](_0x126421))_0x450df2=_0x450df2+'§'+_0x126421;}if(_0xdcb855=='')_0xdcb855=_0x450df2;else _0xdcb855+='|'+_0x450df2;}_0x5a9e3b['push'](_0x3d666a['id']+':'+_0xdcb855);_0x4fb8ef[_0x3d666a['id']]=0x1;}}}}if(hasAdditionalPhones){_0x26f087['push']('\x22'+_0x5a9e3b['join'](';')+'\x22');}if(_0x1a7e02[_0x5b83('0x18')]){handleError(_0x56fcf1[_0x5b83('0x7f')][_0x1e96b0],{'code':_0x5b83('0x92'),'message':_0x1a7e02[_0x5b83('0x12')]()});}else{fs['appendFileSync'](_0x49f2bb,_0x26f087[_0x5b83('0x12')]()+'\x0a');}_0x26f087=[];}if(!(stats[_0x5b83('0x80')]%0xc8)){socket[_0x5b83('0x93')](_0x5b83('0x94')+_0x21a516,stats);stats[_0x5b83('0x5b')]=[];}}if(stopped){logger[_0x5b83('0x71')](_0x5b83('0x95'));_0x3be8b2[_0x5b83('0x96')]();}}catch(_0x5a149a){handleError(_0x56fcf1['data'][_0x1e96b0],{'code':_0x5b83('0x97'),'message':_0x5a149a[_0x5b83('0x5d')]});logger[_0x5b83('0x59')](_0x5b83('0x98'),_0x5a149a[_0x5b83('0x5d')]);}},'complete':function(){try{var _0x101b70=[];var _0xf9bff1=[];var _0x35e519=_0x5b83('0x30');if(_0x3bcabb[_0x5b83('0x99')]&&_0x3bcabb[_0x5b83('0x99')]['length']){_0x35e519=_0x5b83('0x9a')+_0x21a516;_0x101b70[_0x5b83('0x19')](_0x5b83('0x9b')+_0x35e519+_0x5b83('0x9c'));}tmp_campaigns=_0x5b83('0x9d')+_0x21a516;tmp_voice_queues=_0x5b83('0x9e')+_0x21a516;_0xf9bff1[_0x5b83('0x19')]('CREATE\x20TABLE\x20'+tmp_campaigns+_0x5b83('0x9f'));_0xf9bff1['push'](_0x5b83('0x9b')+tmp_voice_queues+_0x5b83('0x9f'));BPromise[_0x5b83('0xa0')](_0xf9bff1,handleTZQuery)['then'](function(_0x274b7b){updateTzCampaigns(_0x3bcabb[_0x5b83('0x43')])[_0x5b83('0x17')](function(_0x20e069){updateTzVoiceQueues(_0x3bcabb[_0x5b83('0x43')])[_0x5b83('0x17')](function(_0x526cb2){if(hasTZ)_0x3ae8a1=_0x3ae8a1[_0x5b83('0x82')](_0x5b83('0x6d'),_0x5b83('0xa1'));var _0x22c860=util[_0x5b83('0xd')]('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',_0x49f2bb,_0x35e519,_0x3ae8a1,_0x3bcabb[_0x5b83('0x43')],_0x3bcabb[_0x5b83('0x52')]||null,NOW,NOW);if(_[_0x5b83('0x1d')](_0x5bcbeb[_0x5b83('0x42')])){_0x22c860+=_0x5b83('0xa2');}_0x101b70[_0x5b83('0x19')](_0x22c860);if(_0x3bcabb[_0x5b83('0x99')]&&_0x3bcabb[_0x5b83('0x99')][_0x5b83('0x18')]){_0x101b70[_0x5b83('0x19')](insertCmContact(_0x3bcabb[_0x5b83('0x43')],_0x35e519,_0x3bcabb[_0x5b83('0x99')],_0x5bcbeb));_0x101b70[_0x5b83('0x19')](_0x5b83('0xa3')+_0x35e519+';');}BPromise[_0x5b83('0xa0')](_0x101b70,handleQuery)[_0x5b83('0x17')](function(_0x16c452){BPromise[_0x5b83('0x1a')]([handleAdditionalPhones()])[_0x5b83('0x17')](function(){_0x101b70=[];for(var _0x384e68=0x0;_0x384e68<promisesAdditionalPhones[_0x5b83('0x18')];_0x384e68++){if(promisesAdditionalPhones[_0x384e68][_0x5b83('0x3d')]!='§'){_0x101b70['push'](createAdditionalPhone(promisesAdditionalPhones[_0x384e68][_0x5b83('0xa4')],promisesAdditionalPhones[_0x384e68][_0x5b83('0xa5')],promisesAdditionalPhones[_0x384e68][_0x5b83('0x3d')],promisesAdditionalPhones[_0x384e68][_0x5b83('0xa6')]));}}BPromise['all'](_0x101b70)['then'](function(){_0x101b70=[];if(hasTZ){_0x101b70[_0x5b83('0x19')](insertTzCmHopper(_0x3bcabb[_0x5b83('0x43')],'voice_queues_has_cm_lists',_0x5b83('0x68'),_0x5b83('0xa7'),_0xa8ee8b,tmp_voice_queues));_0x101b70[_0x5b83('0x19')](insertTzCmHopperBlack(_0x3bcabb[_0x5b83('0x43')],_0x5b83('0xa8'),_0x5b83('0x68'),'VoiceQueueId'));_0x101b70['push'](insertTzCmHopper(_0x3bcabb['ListId'],'campaigns_has_cm_lists',_0x5b83('0x61'),_0x5b83('0xa9'),_0xa8ee8b,tmp_campaigns));_0x101b70[_0x5b83('0x19')](insertTzCmHopperBlack(_0x3bcabb[_0x5b83('0x43')],_0x5b83('0xaa'),_0x5b83('0x61'),_0x5b83('0xa9')));_0x101b70[_0x5b83('0x19')](insertCmHopperAdditionalPhones(_0x3bcabb[_0x5b83('0x43')]));}else{_0x101b70[_0x5b83('0x19')](insertCmHopper(_0x3bcabb[_0x5b83('0x43')],_0x5b83('0x69'),_0x5b83('0x68'),'VoiceQueueId',_0xa8ee8b));_0x101b70[_0x5b83('0x19')](insertCmHopperBlack(_0x3bcabb[_0x5b83('0x43')],_0x5b83('0xa8'),_0x5b83('0x68'),_0x5b83('0xa7')));_0x101b70[_0x5b83('0x19')](insertCmHopper(_0x3bcabb[_0x5b83('0x43')],_0x5b83('0x62'),_0x5b83('0x61'),'CampaignId',_0xa8ee8b));_0x101b70[_0x5b83('0x19')](insertCmHopperBlack(_0x3bcabb[_0x5b83('0x43')],'campaigns_has_cm_blacklists',_0x5b83('0x61'),'CampaignId'));_0x101b70[_0x5b83('0x19')](insertCmHopperAdditionalPhones(_0x3bcabb[_0x5b83('0x43')]));}_0x101b70[_0x5b83('0x19')]('DROP\x20TABLE\x20'+tmp_campaigns+';');_0x101b70[_0x5b83('0x19')](_0x5b83('0xa3')+tmp_voice_queues+';');BPromise[_0x5b83('0xa0')](_0x101b70,handleQuery)['then'](function(_0x2b074f){stats[_0x5b83('0xab')]=!![];stats[_0x5b83('0xac')]=_0x3bcabb[_0x5b83('0x99')]&&_0x3bcabb[_0x5b83('0x99')][_0x5b83('0x18')]?results[0x2][_0x5b83('0xac')]:results[0x0][_0x5b83('0xac')];socket['emit'](_0x5b83('0x94')+_0x21a516,stats);fs[_0x5b83('0xad')](_0x597d5a);fs[_0x5b83('0xad')](_0x49f2bb);process[_0x5b83('0x5a')](0x0);})[_0x5b83('0x60')](function(_0x25a49a){logger[_0x5b83('0x59')](_0x25a49a[_0x5b83('0x5d')]);process[_0x5b83('0x5a')](0x1);});});});})['catch'](function(_0x47cd33){logger[_0x5b83('0x59')](_0x47cd33[_0x5b83('0x5d')]);process['exit'](0x1);});});});});}catch(_0x800ab9){logger[_0x5b83('0x59')](_0x5b83('0xae'),_0x800ab9['message']);process[_0x5b83('0x5a')](0x1);}},'error':function(_0x5bc640,_0x1732d7,_0x112303,_0x717fbf){throw new Error(_0x717fbf);}});});}function validate(){if(process[_0x5b83('0xaf')]&&process[_0x5b83('0xaf')]['length']<0x4){throw new Error('arguments\x20<filename>\x20<parameters>\x20<agents>');}var _0x36d5ad=path[_0x5b83('0x12')](config[_0x5b83('0xb0')],_0x5b83('0x78'),process[_0x5b83('0xaf')][0x2]);if(!fs[_0x5b83('0xb1')](_0x36d5ad)){throw new Error(_0x5b83('0xb2'));}var _0x113e44={};try{_0x113e44=JSON[_0x5b83('0xb3')](process[_0x5b83('0xaf')][0x3]);if(!_0x113e44[_0x5b83('0x75')]){throw new Error(_0x5b83('0xb4'));}if(!_0x113e44[_0x5b83('0x75')][_0x5b83('0x3d')]){throw new Error(_0x5b83('0xb5'));}if(!_0x113e44['binding'][_0x5b83('0x8c')]){throw new Error(_0x5b83('0xb6'));}var _0x42504c=0x0;if(_0x113e44['binding'][_0x5b83('0x44')]){_0x42504c=0x1;}if(!_0x113e44[_0x5b83('0x43')]){throw new Error('ListId\x20is\x20mandatory');}}catch(_0x48eef3){throw new Error(_0x5b83('0xb7'));}var _0x5de667=[];try{_0x5de667=_[_0x5b83('0xb8')](JSON[_0x5b83('0xb3')](process[_0x5b83('0xaf')][0x4]),'id');}catch(_0x1b88c9){logger[_0x5b83('0x71')](_0x5b83('0xb9'));}main(_0x36d5ad,_0x113e44,_0x5de667,_0x42504c);}validate();process['on']('SIGINT',handleStop);process['on']('uncaughtException',handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff