// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x21d2=['offset','main','stringify','send','start','binding','socket_timestamp','root','includes','ContactItemType','name','_description','writeFileSync','createReadStream','data','rows','find','hasOwnProperty','trim','replace','isValid','isNaN','isNumber','agent\x20not\x20exists','email','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','itemTypeId','description','SystemRow','appendFileSync','Abort\x20parser','step','duplicates','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','campaigns_','voice_queues_','(id\x20int,dialTimezone\x20varchar(255),offset\x20int);','each','dialTimezone,utcOffset','format','LOAD\x20DATA\x20LOCAL\x20INFILE\x20\x27%s\x27\x20INTO\x20TABLE\x20%s\x20CHARACTER\x20SET\x20UTF8\x20FIELDS\x20TERMINATED\x20BY\x20\x27,\x27\x20ENCLOSED\x20BY\x20\x27\x22\x27\x20LINES\x20TERMINATED\x20BY\x20\x27\x0a\x27\x20IGNORE\x201\x20ROWS\x20(%s)\x20SET\x20id\x20=\x20NULL,\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27',',\x20scheduledAt\x20=\x20NOW()','contactId','orderBy','VoiceQueueId','voice_queues_has_cm_blacklists','CampaignId','campaigns_has_cm_blacklists','DROP\x20TABLE\x20','finish','affectedRows','emit','contact:import:','unlink','exit','complete','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','server/files/tmp','existsSync','binding\x20doesn\x27t\x20exists','firstName\x20is\x20mandatory','ListId\x20is\x20mandatory','No\x20agent\x20available','SIGINT','path','lodash','papaparse','util','moment','squel','ioredis','../../../config/environment','../../../config/environment/shared','../../../config/logger','import','redis','localhost','socket.io-emitter','YYYY-MM-DD\x20HH:mm:ss','select','field','phone','from','join','.id\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','CmContact','findAll','AdditionalPhones','push','all','then','split','length','isNil','filter','CmContactHasItem','findOne','update','updated','create','PHONE','inserted','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','insert','into','cm_hopper','fromQuery','scheduledat','ListId','createdAt','updatedAt','UserId','recallme','cm_contacts','.CmListId','.CmListId\x20=\x20?','\x22always\x22','\x22onlyIfOpen\x22','cm_contacts.phone\x20NOT\x20IN\x20(?)','toString','cm_contacts.phone','cm_hopper_black','fields','cm_contacts.ListId\x20=\x20','cm_contacts.createdAt\x20=\x20?','\x20=\x20','date_add(cm_contacts.scheduledat,interval\x20','.offset-cm_contacts.utcOffset\x20minute)','priority','ContactId','ListId\x20=\x20?','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','CmHopperId','OrderBy','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contact_has_items','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId','scheduledAt',')\x20NOT\x20IN\x20?','deletedAt\x20IS\x20NULL','id\x20IN\x20?','MIN(id)','min_id','group','info','Received\x20SIGINT','error','message','errors','query','spread','catch','campaigns.dialTimezone','campaigns','campaigns_has_cm_lists','campaigns.id\x20=\x20campaigns_has_cm_lists.CampaignId','campaigns_has_cm_lists.CmListId=','sequelize','voice_queues.id','voice_queues.dialTimezone','voice_queues','voice_queues_has_cm_lists','timezones','dialTimezone','utcOffset','set'];(function(_0x27d8bc,_0x19e010){var _0x4b04cb=function(_0x524568){while(--_0x524568){_0x27d8bc['push'](_0x27d8bc['shift']());}};_0x4b04cb(++_0x19e010);}(_0x21d2,0x1c1));var _0x221d=function(_0x166d93,_0x301f09){_0x166d93=_0x166d93-0x0;var _0xba708=_0x21d2[_0x166d93];return _0xba708;};'use strict';var fs=require('fs');var path=require(_0x221d('0x0'));var _=require(_0x221d('0x1'));var Papa=require(_0x221d('0x2'));var util=require(_0x221d('0x3'));var BPromise=require('bluebird');var moment=require(_0x221d('0x4'));var squel=require(_0x221d('0x5'));var Redis=require(_0x221d('0x6'));var db=require('../../../mysqldb')['db'];var config=require(_0x221d('0x7'));var shared=require(_0x221d('0x8'));var logger=require(_0x221d('0x9'))(_0x221d('0xa'));config[_0x221d('0xb')]=_['defaults'](config[_0x221d('0xb')],{'host':_0x221d('0xc'),'port':0x18eb});var socket=require(_0x221d('0xd'))(new Redis(config[_0x221d('0xb')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()['format'](_0x221d('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(_0x3db69d){return/^([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x22([^\x0d\x22\x5c\x80-\xff]|\x5c[\x00-\x7f])*\x22)(\x2e([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x22([^\x0d\x22\x5c\x80-\xff]|\x5c[\x00-\x7f])*\x22))*\x40([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x5b([^\x0d\x5b-\x5d\x80-\xff]|\x5c[\x00-\x7f])*\x5d)(\x2e([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x5b([^\x0d\x5b-\x5d\x80-\xff]|\x5c[\x00-\x7f])*\x5d))*$/['test'](_0x3db69d);}function selectNotIn(_0x2ef868,_0x369285,_0x449949,_0x10b7e6,_0x2db5bc){return squel[_0x221d('0xf')]()[_0x221d('0x10')](_0x221d('0x11'))[_0x221d('0x12')](_0x10b7e6)[_0x221d('0x13')](_0x369285,null,_0x369285+_0x221d('0x14')+_0x10b7e6+'.'+_0x449949)[_0x221d('0x15')](_0x10b7e6+'.'+_0x449949+'\x20=\x20'+_0x2ef868+'.'+_0x449949)['where'](_0x369285+_0x221d('0x16')+_0x2db5bc['join']()+')');}function handleAdditionalPhones(){return new Promise(function(_0x116aef,_0x97e5f0){promisesAdditionalPhones=[];return db[_0x221d('0x17')][_0x221d('0x18')]({'raw':!![],'attributes':['id',_0x221d('0x19')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})['then'](function(_0x65628){if(_0x65628!==null){var _0x5bb69d=[];for(var _0x19adab=0x0;_0x19adab<_0x65628['length'];_0x19adab++){var _0x2d276b=_0x65628[_0x19adab];_0x5bb69d[_0x221d('0x1a')](insertAdditionalPhones(_0x2d276b));}}Promise[_0x221d('0x1b')](_0x5bb69d)[_0x221d('0x1c')](function(){_0x116aef({'val':0x1});});});});}function insertAdditionalPhones(_0x4f6a70){return new Promise(function(_0x4321ca,_0x59e572){var _0x4375ab=_0x4f6a70['AdditionalPhones'];var _0x5b1ffc=_0x4375ab[_0x221d('0x1d')](';');var _0xcebec4=[];orderBy=0x0;for(var _0x54d87e=0x0;_0x54d87e<_0x5b1ffc[_0x221d('0x1e')];_0x54d87e++){_0xcebec4[_0x221d('0x1a')](splitAdditionalPhone(_0x4f6a70['id'],_0x5b1ffc[_0x54d87e]));}Promise[_0x221d('0x1b')](_0xcebec4)[_0x221d('0x1c')](function(){_0x4321ca({'val':_0x5b1ffc['length']});});});}function splitAdditionalPhone(_0x3b3e38,_0x1332b6){return new Promise(function(_0x5135a5,_0x330cda){var _0x5a2886=_0x1332b6[_0x221d('0x1d')](':');var _0x935554=_0x5a2886[0x0];var _0x14cd44=_0x5a2886[0x1];if(!_[_0x221d('0x1f')](_0x14cd44)){var _0x378d00=_0x14cd44[_0x221d('0x1d')]('|');var _0x5db1a7=[];for(var _0xece436=0x0;_0xece436<_0x378d00[_0x221d('0x1e')];_0xece436++){if(_0x378d00[_0xece436]!==''){var _0x594cde=_[_0x221d('0x20')](promisesAdditionalPhones,{'contactId':_0x3b3e38,'phone':_0x378d00[_0xece436]});if(_0x594cde[_0x221d('0x1e')]==0x0){orderBy++;promisesAdditionalPhones[_0x221d('0x1a')]({'contactId':_0x3b3e38,'contactTypeId':_0x935554,'phone':_0x378d00[_0xece436],'orderBy':orderBy});}}}_0x5135a5({'ok':0x1});}else _0x5135a5({'res':0x0});});}function createAdditionalPhone(_0x438d1b,_0x17333f,_0x339945,_0x33284b){var _0x142c5c='';var _0x47603a='';var _0x15a7c0=_0x339945[_0x221d('0x1d')]('§');_0x142c5c=_0x15a7c0[0x0];if(_0x15a7c0[_0x221d('0x1e')]==0x2)_0x47603a=_0x15a7c0[0x1];return new Promise(function(_0x26621d,_0x3a7882){return db[_0x221d('0x21')][_0x221d('0x22')]({'where':{'CmContactId':_0x438d1b,'item':_0x142c5c}})[_0x221d('0x1c')](function(_0x36c890){if(_0x36c890){return db['CmContactHasItem'][_0x221d('0x23')]({'ItemTypeId':_0x17333f,'description':_0x47603a,'OrderBy':_0x33284b},{'where':{'CmContactId':_0x438d1b,'item':_0x142c5c}})[_0x221d('0x1c')](function(_0x56c7aa){_0x26621d({'res':_0x221d('0x24')});});}else{return db[_0x221d('0x21')][_0x221d('0x25')]({'CmContactId':_0x438d1b,'item':_0x142c5c,'description':_0x47603a,'ItemTypeId':_0x17333f,'OrderBy':_0x33284b,'ItemClass':_0x221d('0x26')})[_0x221d('0x1c')](function(_0x230909){_0x26621d({'res':_0x221d('0x27')});});}});});}function insertCmHopper(_0x1668ea,_0x4383f4,_0x57418b,_0x469769,_0xf1665b){var _0x1a1d0e=['cm_contacts.phone',_0x221d('0x28'),_0x221d('0x29'),_0x221d('0x2a'),_0x4383f4+'.'+_0x469769,_0x221d('0x2b'),_0x221d('0x2c'),_0x221d('0x2d'),_0x221d('0x2e'),'\x22'+_0xf1665b+'\x22'];return squel[_0x221d('0x2f')]()[_0x221d('0x30')](_0x221d('0x31'))[_0x221d('0x32')]([_0x221d('0x11'),_0x221d('0x33'),'ContactId',_0x221d('0x34'),_0x469769,_0x221d('0x35'),_0x221d('0x36'),'priority',_0x221d('0x37'),_0x221d('0x38')],squel[_0x221d('0xf')]()['fields'](_0x1a1d0e)['from'](_0x4383f4)['join'](_0x221d('0x39'),null,'cm_contacts.ListId\x20=\x20'+_0x4383f4+_0x221d('0x3a'))[_0x221d('0x13')](_0x57418b,null,_0x57418b+_0x221d('0x14')+_0x4383f4+'.'+_0x469769)['where'](_0x4383f4+_0x221d('0x3b'),_0x1668ea)[_0x221d('0x15')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0x221d('0x15')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x4383f4,_0x57418b,_0x469769,_0x221d('0x31'),[_0x221d('0x3c'),_0x221d('0x3d')]))['where'](_0x221d('0x3e'),selectNotIn(_0x4383f4,_0x57418b,_0x469769,_0x221d('0x31'),[_0x221d('0x3c')])))[_0x221d('0x3f')]();}function insertCmHopperBlack(_0x24cbb1,_0xe22d33,_0x427bd0,_0x2e84f1){var _0x38255d=[_0x221d('0x40'),_0x221d('0x29'),'cm_contacts.ListId',_0xe22d33+'.'+_0x2e84f1,_0x221d('0x2b'),_0x221d('0x2c')];return squel[_0x221d('0x2f')]()[_0x221d('0x30')](_0x221d('0x41'))[_0x221d('0x32')]([_0x221d('0x11'),'ContactId',_0x221d('0x34'),_0x2e84f1,_0x221d('0x35'),_0x221d('0x36')],squel[_0x221d('0xf')]()[_0x221d('0x42')](_0x38255d)[_0x221d('0x12')](_0xe22d33)[_0x221d('0x13')](_0x221d('0x39'),null,_0x221d('0x43')+_0xe22d33+_0x221d('0x3a'))[_0x221d('0x13')](_0x427bd0,null,_0x427bd0+_0x221d('0x14')+_0xe22d33+'.'+_0x2e84f1)[_0x221d('0x15')](_0xe22d33+_0x221d('0x3b'),_0x24cbb1)[_0x221d('0x15')](_0x221d('0x44'),NOW)[_0x221d('0x15')](_0x221d('0x3e'),squel[_0x221d('0xf')]()['field'](_0x221d('0x11'))[_0x221d('0x12')](_0x221d('0x41'))[_0x221d('0x15')]('ListId\x20=\x20?',_0x24cbb1)['where'](_0x2e84f1+_0x221d('0x45')+_0xe22d33+'.'+_0x2e84f1)))[_0x221d('0x3f')]();}function insertTzCmHopper(_0x2a4f7f,_0x1b0242,_0x3711b5,_0x189ef9,_0x3fb99f,_0x5e656c){var _0x3574da=[_0x221d('0x40'),_0x221d('0x46')+_0x5e656c+_0x221d('0x47'),'cm_contacts.id',_0x221d('0x2a'),_0x1b0242+'.'+_0x189ef9,_0x221d('0x2b'),_0x221d('0x2c'),'cm_contacts.priority',_0x221d('0x2e'),'\x22'+_0x3fb99f+'\x22'];var _0xb52e7b=squel[_0x221d('0x2f')]()[_0x221d('0x30')]('cm_hopper')['fromQuery']([_0x221d('0x11'),_0x221d('0x33'),'ContactId','ListId',_0x189ef9,_0x221d('0x35'),_0x221d('0x36'),_0x221d('0x48'),_0x221d('0x37'),_0x221d('0x38')],squel['select']()[_0x221d('0x42')](_0x3574da)[_0x221d('0x12')](_0x1b0242)[_0x221d('0x13')](_0x221d('0x39'),null,_0x221d('0x43')+_0x1b0242+_0x221d('0x3a'))[_0x221d('0x13')](_0x3711b5,null,_0x3711b5+_0x221d('0x14')+_0x1b0242+'.'+_0x189ef9)[_0x221d('0x13')](_0x5e656c,null,_0x5e656c+'.id\x20=\x20'+_0x1b0242+'.'+_0x189ef9)[_0x221d('0x15')](_0x1b0242+'.CmListId\x20=\x20?',_0x2a4f7f)[_0x221d('0x15')]('cm_contacts.createdAt\x20=\x20?',NOW)['where']('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x1b0242,_0x3711b5,_0x189ef9,_0x221d('0x31'),[_0x221d('0x3c'),'\x22onlyIfOpen\x22']))[_0x221d('0x15')](_0x221d('0x3e'),selectNotIn(_0x1b0242,_0x3711b5,_0x189ef9,_0x221d('0x31'),[_0x221d('0x3c')])))[_0x221d('0x3f')]();return _0xb52e7b;}function insertTzCmHopperBlack(_0x2c3ad0,_0x201175,_0x484fbf,_0x46db70){var _0x352377=['cm_contacts.phone',_0x221d('0x29'),'cm_contacts.ListId',_0x201175+'.'+_0x46db70,'cm_contacts.createdAt','cm_contacts.updatedAt'];return squel[_0x221d('0x2f')]()[_0x221d('0x30')](_0x221d('0x41'))[_0x221d('0x32')]([_0x221d('0x11'),_0x221d('0x49'),'ListId',_0x46db70,_0x221d('0x35'),_0x221d('0x36')],squel[_0x221d('0xf')]()[_0x221d('0x42')](_0x352377)['from'](_0x201175)[_0x221d('0x13')](_0x221d('0x39'),null,_0x221d('0x43')+_0x201175+_0x221d('0x3a'))['join'](_0x484fbf,null,_0x484fbf+_0x221d('0x14')+_0x201175+'.'+_0x46db70)['where'](_0x201175+_0x221d('0x3b'),_0x2c3ad0)['where'](_0x221d('0x44'),NOW)[_0x221d('0x15')](_0x221d('0x3e'),squel['select']()[_0x221d('0x10')](_0x221d('0x11'))[_0x221d('0x12')](_0x221d('0x41'))[_0x221d('0x15')](_0x221d('0x4a'),_0x2c3ad0)[_0x221d('0x15')](_0x46db70+_0x221d('0x45')+_0x201175+'.'+_0x46db70)))['toString']();}function insertCmHopperAdditionalPhones(_0x3e5f3a){var _0x38d14c=[_0x221d('0x4b'),_0x221d('0x4c'),'cm_contact_has_items.OrderBy',_0x221d('0x4d'),_0x221d('0x4e')];return squel[_0x221d('0x2f')]()['into'](_0x221d('0x4f'))[_0x221d('0x32')]([_0x221d('0x50'),_0x221d('0x11'),_0x221d('0x51'),_0x221d('0x35'),'updatedAt'],squel[_0x221d('0xf')]()['fields'](_0x38d14c)['from']('cm_hopper')['join'](_0x221d('0x39'),null,_0x221d('0x52'))[_0x221d('0x13')](_0x221d('0x53'),null,_0x221d('0x54'))[_0x221d('0x15')](_0x221d('0x55'),_0x3e5f3a)[_0x221d('0x15')](_0x221d('0x44'),NOW))[_0x221d('0x3f')]();}function insertCmContact(_0x199e4a,_0x90c9d7,_0x384b95,_0x1e1f90){var _0x2bfed7=_[_0x221d('0x56')](_[_0x221d('0x57')](_0x1e1f90),[_0x221d('0x34'),_0x221d('0x58'),_0x221d('0x35'),_0x221d('0x36'),_0x221d('0x59')]);return squel[_0x221d('0x2f')]()[_0x221d('0x30')](_0x221d('0x39'))[_0x221d('0x32')](_0x2bfed7,squel[_0x221d('0xf')]()[_0x221d('0x42')](_0x2bfed7)[_0x221d('0x12')](_0x90c9d7)[_0x221d('0x15')]('('+_0x384b95[_0x221d('0x13')](',')+_0x221d('0x5a'),squel[_0x221d('0xf')]()[_0x221d('0x42')](_0x384b95)[_0x221d('0x12')]('cm_contacts')[_0x221d('0x15')](_0x221d('0x4a'),_0x199e4a)[_0x221d('0x15')](_0x221d('0x5b')))['where'](_0x221d('0x5c'),squel[_0x221d('0xf')]()[_0x221d('0x10')](_0x221d('0x5d'),_0x221d('0x5e'))['from'](_0x90c9d7)[_0x221d('0x5f')](_0x384b95[_0x221d('0x13')](','))))[_0x221d('0x3f')]();}function handleStop(){logger[_0x221d('0x60')](_0x221d('0x61'));stopped=!![];}function handleUncaughtException(_0x334fee){logger[_0x221d('0x62')](_0x334fee[_0x221d('0x63')]);process['exit'](0x1);}function handleError(_0x48cfe7,_0x364d48){stats[_0x221d('0x64')][_0x221d('0x1a')]({'name':_0x364d48['code'],'message':_0x364d48[_0x221d('0x63')],'row':_0x48cfe7});}function handleQuery(_0x14c8b4){logger[_0x221d('0x60')](_0x14c8b4);return db['sequelize'][_0x221d('0x65')](_0x14c8b4)[_0x221d('0x66')](function(_0x16b577){results[_0x221d('0x1a')](_0x16b577);})[_0x221d('0x67')](function(_0x1f5a01){logger[_0x221d('0x62')](_0x1f5a01[_0x221d('0x63')]);});}function updateTzCampaigns(_0x95b73a){return new Promise(function(_0x8af3f3,_0x229a72){var _0xb6962f=squel[_0x221d('0xf')]()['fields'](['campaigns.id',_0x221d('0x68')])[_0x221d('0x12')](_0x221d('0x69'))[_0x221d('0x13')](_0x221d('0x6a'),null,_0x221d('0x6b'))[_0x221d('0x15')](_0x221d('0x6c')+_0x95b73a);db[_0x221d('0x6d')]['query'](_0xb6962f[_0x221d('0x3f')]())[_0x221d('0x66')](function(_0x4f8ca9){var _0x278e60=[];for(var _0x444782=0x0;_0x444782<_0x4f8ca9[_0x221d('0x1e')];_0x444782++){_0x278e60[_0x221d('0x1a')](getTimezoneData(_0x4f8ca9[_0x444782],tmp_campaigns));}BPromise[_0x221d('0x1b')](_0x278e60)[_0x221d('0x1c')](function(){_0x8af3f3({'val':0x1});});})[_0x221d('0x67')](function(_0x15dd3e){logger[_0x221d('0x62')](_0x15dd3e[_0x221d('0x63')]);_0x8af3f3({'val':0x0});});});}function updateTzVoiceQueues(_0x54d631){return new Promise(function(_0x11aee5,_0x4b984d){var _0x442cc3=squel[_0x221d('0xf')]()[_0x221d('0x42')]([_0x221d('0x6e'),_0x221d('0x6f')])[_0x221d('0x12')](_0x221d('0x70'))['join'](_0x221d('0x71'),null,'voice_queues.id\x20=\x20voice_queues_has_cm_lists.VoiceQueueId')[_0x221d('0x15')]('voice_queues_has_cm_lists.CmListId='+_0x54d631);db[_0x221d('0x6d')]['query'](_0x442cc3[_0x221d('0x3f')]())['spread'](function(_0x334e9d){var _0xc42625=[];for(var _0x3e0085=0x0;_0x3e0085<_0x334e9d[_0x221d('0x1e')];_0x3e0085++){_0xc42625[_0x221d('0x1a')](getTimezoneData(_0x334e9d[_0x3e0085],tmp_voice_queues));}BPromise['all'](_0xc42625)[_0x221d('0x1c')](function(){_0x11aee5({'val':0x1});});})['catch'](function(_0x69cd6e){logger[_0x221d('0x62')](_0x69cd6e[_0x221d('0x63')]);_0x11aee5({'val':0x0});});});}function getTimezoneData(_0xc4496a,_0x501b4d){return new Promise(function(_0x43dc04,_0xb44b20){var _0x29b973=shared[_0x221d('0x72')];var _0x2d8070=_0x29b973[_0xc4496a[_0x221d('0x73')]];if(_['isNil'](_0x2d8070)){_0x43dc04({'ret':0x1});}else{var _0x1b4a06=_0x2d8070[_0x221d('0x74')];var _0x2f6e25=squel[_0x221d('0x2f')]()['into'](_0x501b4d)['set']('id',_0xc4496a['id'])[_0x221d('0x75')](_0x221d('0x76'),_0x1b4a06)[_0x221d('0x75')]('dialTimezone',_0xc4496a[_0x221d('0x73')])[_0x221d('0x3f')]();return db[_0x221d('0x6d')][_0x221d('0x65')](_0x2f6e25)['spread'](function(_0x33d369){_0x43dc04({'ret':0x1});})[_0x221d('0x67')](function(_0x44504d){logger[_0x221d('0x62')](_0x44504d[_0x221d('0x63')]);_0xb44b20({'ret':0x1});});}});}function handleTZQuery(_0x11a513){logger[_0x221d('0x60')](_0x11a513);return db[_0x221d('0x6d')][_0x221d('0x65')](_0x11a513)[_0x221d('0x66')](function(_0x5605c0){})[_0x221d('0x67')](function(_0xd6d16f){logger[_0x221d('0x62')](_0xd6d16f[_0x221d('0x63')]);});}function main(_0x2e7787,_0x3379bb,_0x5276e8,_0x263715){logger[_0x221d('0x60')](_0x221d('0x77'),_0x2e7787,JSON[_0x221d('0x78')](_0x3379bb));process[_0x221d('0x79')](_0x221d('0x7a'));var _0x40ba08=_0x3379bb[_0x221d('0x7b')];var _0x5bde51=_['clone'](_0x40ba08);var _0x40580b=_0x3379bb[_0x221d('0x7c')];var _0x37428c=path['join'](config[_0x221d('0x7d')],'server/files/tmp',_0x40580b+'.csv');hasTZ=_[_0x221d('0x57')](_0x40ba08)[_0x221d('0x7e')](_0x221d('0x73'));var _0xfdc396=_[_0x221d('0x57')](_0x40ba08)['join']();logger['info']('header',_0xfdc396);db[_0x221d('0x7f')][_0x221d('0x18')]({'raw':!![],'attributes':['id',_0x221d('0x80')]})[_0x221d('0x1c')](function(_0x382085){for(var _0x6431e0=0x0;_0x6431e0<_0x382085['length'];_0x6431e0++){if(_0x382085[_0x6431e0][_0x221d('0x80')]in _0x40ba08){contactItemTypes['push'](_0x382085[_0x6431e0]);delete _0x5bde51[_0x382085[_0x6431e0][_0x221d('0x80')]];hasAdditionalPhones=!![];}for(var _0x19a327 in _0x40ba08){if(_0x382085[_0x6431e0][_0x221d('0x80')]+_0x221d('0x81')===_0x19a327){phoneDescriptions[_0x221d('0x1a')]({'itemTypeId':_0x382085[_0x6431e0]['id'],'description':_0x19a327});delete _0x5bde51[_0x19a327];}}}if(hasAdditionalPhones)_0x5bde51['AdditionalPhones']='';var _0xa61b0=_[_0x221d('0x57')](_0x5bde51)['join']();logger[_0x221d('0x60')]('header',_0xa61b0);fs[_0x221d('0x82')](_0x37428c,_0xa61b0+'\x0a');Papa['parse'](fs[_0x221d('0x83')](_0x2e7787),{'header':!![],'skipEmptyLines':!![],'step':function(_0x48e797,_0x5c8c5a){try{for(var _0x3fa980=0x0,_0xd58948=[];_0x3fa980<_0x48e797[_0x221d('0x84')]['length'];_0x3fa980++){stats[_0x221d('0x85')]+=0x1;if(_0x48e797[_0x221d('0x64')][_0x3fa980]){handleError(_0x48e797[_0x221d('0x84')][_0x3fa980],_0x48e797['errors'][_0x3fa980]);}else{var _0x2e61c8=[];var _0x4707b2=[];var _0x52710b={};for(var _0x57662b in _0x40ba08){let _0xa12e95=contactItemTypes[_0x221d('0x86')](_0x5f1ca1=>_0x5f1ca1[_0x221d('0x80')]===_0x57662b);let _0x4f6537=contactItemTypes[_0x221d('0x86')](_0x331b2a=>_0x331b2a['name']+_0x221d('0x81')===_0x57662b);if(_[_0x221d('0x1f')](_0xa12e95)&&_['isNil'](_0x4f6537)){if(_0x40ba08[_0x221d('0x87')](_0x57662b)){if(_0x48e797[_0x221d('0x84')][_0x3fa980][_0x40ba08[_0x57662b]]){var _0x2ead1d=_[_0x221d('0x88')](_0x48e797[_0x221d('0x84')][_0x3fa980][_0x40ba08[_0x57662b]][_0x221d('0x89')](/"/g,'\x27'));switch(_0x57662b){case'scheduledat':var _0x33563d=moment(_0x2ead1d,_0x221d('0xe'),!![]);if(_0x33563d[_0x221d('0x8a')]()){_0xd58948[_0x221d('0x1a')]('\x22'+_0x2ead1d+'\x22');}else{_0x2e61c8[_0x221d('0x1a')]('scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)');}break;case _0x221d('0x48'):var _0x2115c1=parseInt(_0x2ead1d);_0x2ead1d=_[_0x221d('0x8b')](_0x2115c1)||_0x2115c1<0x0||_0x2115c1>0x4?_0x263715?0x3:0x2:_0x2115c1;_0xd58948[_0x221d('0x1a')]('\x22'+_0x2ead1d+'\x22');break;case _0x221d('0x37'):var _0x241458=parseInt(_0x2ead1d);if(_[_0x221d('0x8c')](_0x241458)&&_['includes'](_0x5276e8,_0x241458)){_0xd58948['push']('\x22'+_0x241458+'\x22');}else{_0x2e61c8[_0x221d('0x1a')](_0x221d('0x8d'));}break;case _0x221d('0x8e'):if(isEmail(_0x2ead1d)){_0xd58948[_0x221d('0x1a')]('\x22'+_0x2ead1d+'\x22');}else{_0x2e61c8['push'](_0x221d('0x8f'));}break;case _0x221d('0x90'):var _0x53a9e0=moment(_0x2ead1d,_0x221d('0x91'),!![]);if(_0x53a9e0['isValid']()){_0xd58948['push']('\x22'+_0x2ead1d+'\x22');}else{_0x2e61c8[_0x221d('0x1a')](_0x221d('0x92'));}break;case _0x221d('0x73'):var _0x18cf7a=shared[_0x221d('0x72')];var _0x468eb5=_0x18cf7a[_0x2ead1d];if(!_[_0x221d('0x1f')](_0x468eb5)){var _0x4f4047=_0x468eb5['utcOffset'];_0xd58948[_0x221d('0x1a')]('\x22'+_0x2ead1d+'\x22');_0xd58948[_0x221d('0x1a')]('\x22'+_0x4f4047+'\x22');}break;default:_0xd58948['push']('\x22'+_0x2ead1d+'\x22');}}else{switch(_0x57662b){case _0x221d('0x93'):case'phone':_0x2e61c8[_0x221d('0x1a')](_0x57662b+_0x221d('0x94'));break;default:_0xd58948['push']('\x22\x22');}}}}else{var _0xa1699a='';if(!_[_0x221d('0x1f')](_0xa12e95)){if(!_0x52710b[_0x221d('0x87')](_0xa12e95['id'])){if(!_['isNil'](_0x48e797[_0x221d('0x84')][_0x3fa980][_0x40ba08[_0x57662b]])){var _0x2ead1d=_[_0x221d('0x88')](_0x48e797['data'][_0x3fa980][_0x40ba08[_0x57662b]][_0x221d('0x89')](/"/g,'\x27'));var _0x44f046=phoneDescriptions[_0x221d('0x86')](_0x367fbd=>_0x367fbd[_0x221d('0x95')]===_0xa12e95['id']);if(!_[_0x221d('0x1f')](_0x44f046)){var _0x255f32=_['trim'](_0x48e797[_0x221d('0x84')][_0x3fa980][_0x40ba08[_0x44f046[_0x221d('0x96')]]][_0x221d('0x89')](/"/g,'\x27'));if(!_['isNil'](_0x255f32))_0x2ead1d=_0x2ead1d+'§'+_0x255f32;}if(_0xa1699a=='')_0xa1699a=_0x2ead1d;else _0xa1699a+='|'+_0x2ead1d;}_0x4707b2[_0x221d('0x1a')](_0xa12e95['id']+':'+_0xa1699a);_0x52710b[_0xa12e95['id']]=0x1;}}}}if(hasAdditionalPhones){_0xd58948[_0x221d('0x1a')]('\x22'+_0x4707b2['join'](';')+'\x22');}if(_0x2e61c8[_0x221d('0x1e')]){handleError(_0x48e797[_0x221d('0x84')][_0x3fa980],{'code':_0x221d('0x97'),'message':_0x2e61c8[_0x221d('0x13')]()});}else{fs[_0x221d('0x98')](_0x37428c,_0xd58948['join']()+'\x0a');}_0xd58948=[];}if(!(stats['rows']%0xc8)){socket['emit']('contact:import:'+_0x40580b,stats);stats[_0x221d('0x64')]=[];}}if(stopped){logger[_0x221d('0x60')](_0x221d('0x99'));_0x5c8c5a['abort']();}}catch(_0x2de812){handleError(_0x48e797[_0x221d('0x84')][_0x3fa980],{'code':'SystemError','message':_0x2de812[_0x221d('0x63')]});logger[_0x221d('0x62')](_0x221d('0x9a'),_0x2de812['message']);}},'complete':function(){try{var _0x106f9e=[];var _0x21fbd1=[];var _0x28c50f=_0x221d('0x39');if(_0x3379bb['duplicates']&&_0x3379bb[_0x221d('0x9b')][_0x221d('0x1e')]){_0x28c50f='cm_contacts_'+_0x40580b;_0x106f9e[_0x221d('0x1a')](_0x221d('0x9c')+_0x28c50f+_0x221d('0x9d'));}tmp_campaigns=_0x221d('0x9e')+_0x40580b;tmp_voice_queues=_0x221d('0x9f')+_0x40580b;_0x21fbd1['push'](_0x221d('0x9c')+tmp_campaigns+_0x221d('0xa0'));_0x21fbd1[_0x221d('0x1a')](_0x221d('0x9c')+tmp_voice_queues+_0x221d('0xa0'));BPromise[_0x221d('0xa1')](_0x21fbd1,handleTZQuery)[_0x221d('0x1c')](function(_0x223dad){updateTzCampaigns(_0x3379bb['ListId'])[_0x221d('0x1c')](function(_0x4ce39c){updateTzVoiceQueues(_0x3379bb[_0x221d('0x34')])[_0x221d('0x1c')](function(_0x1f4af8){if(hasTZ)_0xa61b0=_0xa61b0[_0x221d('0x89')](_0x221d('0x73'),_0x221d('0xa2'));var _0x5dc1b0=util[_0x221d('0xa3')](_0x221d('0xa4'),_0x37428c,_0x28c50f,_0xa61b0,_0x3379bb[_0x221d('0x34')],_0x3379bb[_0x221d('0x58')]||null,NOW,NOW);if(_[_0x221d('0x1f')](_0x40ba08['scheduledat'])){_0x5dc1b0+=_0x221d('0xa5');}_0x106f9e['push'](_0x5dc1b0);if(_0x3379bb[_0x221d('0x9b')]&&_0x3379bb[_0x221d('0x9b')][_0x221d('0x1e')]){_0x106f9e[_0x221d('0x1a')](insertCmContact(_0x3379bb[_0x221d('0x34')],_0x28c50f,_0x3379bb[_0x221d('0x9b')],_0x40ba08));_0x106f9e[_0x221d('0x1a')]('DROP\x20TABLE\x20'+_0x28c50f+';');}BPromise[_0x221d('0xa1')](_0x106f9e,handleQuery)['then'](function(_0x12e912){BPromise[_0x221d('0x1b')]([handleAdditionalPhones()])[_0x221d('0x1c')](function(){_0x106f9e=[];for(var _0x1cf3c1=0x0;_0x1cf3c1<promisesAdditionalPhones[_0x221d('0x1e')];_0x1cf3c1++){if(promisesAdditionalPhones[_0x1cf3c1][_0x221d('0x11')]!='§'){_0x106f9e[_0x221d('0x1a')](createAdditionalPhone(promisesAdditionalPhones[_0x1cf3c1][_0x221d('0xa6')],promisesAdditionalPhones[_0x1cf3c1]['contactTypeId'],promisesAdditionalPhones[_0x1cf3c1][_0x221d('0x11')],promisesAdditionalPhones[_0x1cf3c1][_0x221d('0xa7')]));}}BPromise[_0x221d('0x1b')](_0x106f9e)[_0x221d('0x1c')](function(){_0x106f9e=[];if(hasTZ){_0x106f9e['push'](insertTzCmHopper(_0x3379bb[_0x221d('0x34')],_0x221d('0x71'),_0x221d('0x70'),_0x221d('0xa8'),_0x263715,tmp_voice_queues));_0x106f9e[_0x221d('0x1a')](insertTzCmHopperBlack(_0x3379bb[_0x221d('0x34')],_0x221d('0xa9'),_0x221d('0x70'),_0x221d('0xa8')));_0x106f9e[_0x221d('0x1a')](insertTzCmHopper(_0x3379bb[_0x221d('0x34')],_0x221d('0x6a'),_0x221d('0x69'),_0x221d('0xaa'),_0x263715,tmp_campaigns));_0x106f9e[_0x221d('0x1a')](insertTzCmHopperBlack(_0x3379bb['ListId'],'campaigns_has_cm_blacklists','campaigns',_0x221d('0xaa')));_0x106f9e[_0x221d('0x1a')](insertCmHopperAdditionalPhones(_0x3379bb[_0x221d('0x34')]));}else{_0x106f9e[_0x221d('0x1a')](insertCmHopper(_0x3379bb[_0x221d('0x34')],_0x221d('0x71'),'voice_queues',_0x221d('0xa8'),_0x263715));_0x106f9e[_0x221d('0x1a')](insertCmHopperBlack(_0x3379bb[_0x221d('0x34')],_0x221d('0xa9'),_0x221d('0x70'),_0x221d('0xa8')));_0x106f9e[_0x221d('0x1a')](insertCmHopper(_0x3379bb[_0x221d('0x34')],'campaigns_has_cm_lists',_0x221d('0x69'),_0x221d('0xaa'),_0x263715));_0x106f9e['push'](insertCmHopperBlack(_0x3379bb[_0x221d('0x34')],_0x221d('0xab'),_0x221d('0x69'),_0x221d('0xaa')));_0x106f9e['push'](insertCmHopperAdditionalPhones(_0x3379bb[_0x221d('0x34')]));}_0x106f9e[_0x221d('0x1a')](_0x221d('0xac')+tmp_campaigns+';');_0x106f9e[_0x221d('0x1a')](_0x221d('0xac')+tmp_voice_queues+';');BPromise['each'](_0x106f9e,handleQuery)[_0x221d('0x1c')](function(_0x2bc95b){stats[_0x221d('0xad')]=!![];stats[_0x221d('0xae')]=_0x3379bb[_0x221d('0x9b')]&&_0x3379bb[_0x221d('0x9b')]['length']?results[0x2]['affectedRows']:results[0x0][_0x221d('0xae')];socket[_0x221d('0xaf')](_0x221d('0xb0')+_0x40580b,stats);fs[_0x221d('0xb1')](_0x2e7787);fs['unlink'](_0x37428c);process[_0x221d('0xb2')](0x0);})[_0x221d('0x67')](function(_0x4b5890){logger[_0x221d('0x62')](_0x4b5890[_0x221d('0x63')]);process[_0x221d('0xb2')](0x1);});});});})[_0x221d('0x67')](function(_0xb06277){logger[_0x221d('0x62')](_0xb06277[_0x221d('0x63')]);process[_0x221d('0xb2')](0x1);});});});});}catch(_0x54f29f){logger['error'](_0x221d('0xb3'),_0x54f29f[_0x221d('0x63')]);process[_0x221d('0xb2')](0x1);}},'error':function(_0x581c3d,_0x3b3256,_0x34d292,_0x287b26){throw new Error(_0x287b26);}});});}function validate(){if(process[_0x221d('0xb4')]&&process[_0x221d('0xb4')][_0x221d('0x1e')]<0x4){throw new Error(_0x221d('0xb5'));}var _0x4c7f59=path[_0x221d('0x13')](config['root'],_0x221d('0xb6'),process['argv'][0x2]);if(!fs[_0x221d('0xb7')](_0x4c7f59)){throw new Error('file\x20doesn\x27t\x20exists');}var _0x80abc4={};try{_0x80abc4=JSON['parse'](process[_0x221d('0xb4')][0x3]);if(!_0x80abc4[_0x221d('0x7b')]){throw new Error(_0x221d('0xb8'));}if(!_0x80abc4[_0x221d('0x7b')][_0x221d('0x11')]){throw new Error('phone\x20is\x20mandatory');}if(!_0x80abc4[_0x221d('0x7b')]['firstName']){throw new Error(_0x221d('0xb9'));}var _0xa52b0b=0x0;if(_0x80abc4[_0x221d('0x7b')][_0x221d('0x37')]){_0xa52b0b=0x1;}if(!_0x80abc4[_0x221d('0x34')]){throw new Error(_0x221d('0xba'));}}catch(_0x57867e){throw new Error('body\x20id\x20mandatory');}var _0x130a84=[];try{_0x130a84=_['map'](JSON['parse'](process[_0x221d('0xb4')][0x4]),'id');}catch(_0xebe046){logger[_0x221d('0x60')](_0x221d('0xbb'));}main(_0x4c7f59,_0x80abc4,_0x130a84,_0xa52b0b);}validate();process['on'](_0x221d('0xbc'),handleStop);process['on']('uncaughtException',handleUncaughtException);
\ No newline at end of file
+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
git://repos.xcallymotion.com / motion2.git / blobdiff