// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa9d2=['writeFileSync','createReadStream','data','rows','find','hasOwnProperty','trim','replace','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','email','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','timezones','firstName','\x20not\x20specified','itemTypeId','description','SystemRow','appendFileSync','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','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','scheduledat',',\x20scheduledAt\x20=\x20NOW()','DROP\x20TABLE\x20','contactId','contactTypeId','orderBy','voice_queues_has_cm_lists','VoiceQueueId','voice_queues_has_cm_blacklists','campaigns','CampaignId','campaigns_has_cm_blacklists','finish','affectedRows','unlink','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','root','existsSync','file\x20doesn\x27t\x20exists','parse','binding','binding\x20doesn\x27t\x20exists','phone\x20is\x20mandatory','firstName\x20is\x20mandatory','body\x20id\x20mandatory','uncaughtException','path','lodash','papaparse','util','bluebird','squel','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','import','defaults','localhost','socket.io-emitter','redis','format','YYYY-MM-DD\x20HH:mm:ss','test','select','field','phone','from','join','.id\x20=\x20','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','CmContact','then','length','push','all','split','isNil','filter','CmContactHasItem','findOne','updated','create','PHONE','cm_contacts.phone','cm_contacts.id','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','insert','into','fromQuery','ContactId','createdAt','priority','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_hopper','\x22always\x22','\x22onlyIfOpen\x22','cm_contacts.phone\x20NOT\x20IN\x20(?)','toString','cm_contacts.ListId','cm_contacts.createdAt','cm_hopper_black','updatedAt','.CmListId','ListId\x20=\x20?','date_add(cm_contacts.scheduledat,interval\x20','.offset-cm_contacts.utcOffset\x20minute)','ListId','UserId','recallme','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','CmHopperId','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','info','Received\x20SIGINT','error','exit','errors','code','message','sequelize','query','spread','catch','campaigns.dialTimezone','campaigns_has_cm_lists','campaigns.id\x20=\x20campaigns_has_cm_lists.CampaignId','campaigns_has_cm_lists.CmListId=','voice_queues.id','voice_queues.dialTimezone','voice_queues','voice_queues_has_cm_lists.CmListId=','utcOffset','set','offset','dialTimezone','main','stringify','send','clone','socket_timestamp','.csv','includes','header','findAll','name'];(function(_0x29cc9d,_0x19a8e3){var _0x4a31be=function(_0x1aaa76){while(--_0x1aaa76){_0x29cc9d['push'](_0x29cc9d['shift']());}};_0x4a31be(++_0x19a8e3);}(_0xa9d2,0x100));var _0x2a9d=function(_0x3500de,_0x54e13e){_0x3500de=_0x3500de-0x0;var _0x32ede4=_0xa9d2[_0x3500de];return _0x32ede4;};'use strict';var fs=require('fs');var path=require(_0x2a9d('0x0'));var _=require(_0x2a9d('0x1'));var Papa=require(_0x2a9d('0x2'));var util=require(_0x2a9d('0x3'));var BPromise=require(_0x2a9d('0x4'));var moment=require('moment');var squel=require(_0x2a9d('0x5'));var Redis=require(_0x2a9d('0x6'));var db=require(_0x2a9d('0x7'))['db'];var config=require(_0x2a9d('0x8'));var shared=require('../../../config/environment/shared');var logger=require(_0x2a9d('0x9'))(_0x2a9d('0xa'));config['redis']=_[_0x2a9d('0xb')](config['redis'],{'host':_0x2a9d('0xc'),'port':0x18eb});var socket=require(_0x2a9d('0xd'))(new Redis(config[_0x2a9d('0xe')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()[_0x2a9d('0xf')](_0x2a9d('0x10'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];var tmp_voice_queues;var tmp_campaigns;var tzOffset=0x0;var hasTZ;var NOW=moment()[_0x2a9d('0xf')](_0x2a9d('0x10'));function isEmail(_0x2d5e0d){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))*$/[_0x2a9d('0x11')](_0x2d5e0d);}function selectNotIn(_0x1f7942,_0x478f11,_0x3595c2,_0x38b429,_0x4be416){return squel[_0x2a9d('0x12')]()[_0x2a9d('0x13')](_0x2a9d('0x14'))[_0x2a9d('0x15')](_0x38b429)[_0x2a9d('0x16')](_0x478f11,null,_0x478f11+_0x2a9d('0x17')+_0x38b429+'.'+_0x3595c2)['where'](_0x38b429+'.'+_0x3595c2+_0x2a9d('0x18')+_0x1f7942+'.'+_0x3595c2)[_0x2a9d('0x19')](_0x478f11+_0x2a9d('0x1a')+_0x4be416[_0x2a9d('0x16')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x3d7b83,_0x292e3f){promisesAdditionalPhones=[];return db[_0x2a9d('0x1b')]['findAll']({'raw':!![],'attributes':['id','AdditionalPhones'],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})[_0x2a9d('0x1c')](function(_0x241097){if(_0x241097!==null){var _0x1cdb37=[];for(var _0xd30c24=0x0;_0xd30c24<_0x241097[_0x2a9d('0x1d')];_0xd30c24++){var _0x18ce3b=_0x241097[_0xd30c24];_0x1cdb37[_0x2a9d('0x1e')](insertAdditionalPhones(_0x18ce3b));}}Promise[_0x2a9d('0x1f')](_0x1cdb37)[_0x2a9d('0x1c')](function(){_0x3d7b83({'val':0x1});});});});}function insertAdditionalPhones(_0xedd92e){return new Promise(function(_0x104fed,_0xcbf784){var _0x2f40e3=_0xedd92e['AdditionalPhones'];var _0x3d3364=_0x2f40e3[_0x2a9d('0x20')](';');var _0x556851=[];orderBy=0x0;for(var _0x57cf3f=0x0;_0x57cf3f<_0x3d3364[_0x2a9d('0x1d')];_0x57cf3f++){_0x556851[_0x2a9d('0x1e')](splitAdditionalPhone(_0xedd92e['id'],_0x3d3364[_0x57cf3f]));}Promise[_0x2a9d('0x1f')](_0x556851)[_0x2a9d('0x1c')](function(){_0x104fed({'val':_0x3d3364['length']});});});}function splitAdditionalPhone(_0x340cef,_0x1b581a){return new Promise(function(_0x43eef,_0x36e78d){var _0x511e48=_0x1b581a[_0x2a9d('0x20')](':');var _0x3baf86=_0x511e48[0x0];var _0x271ac2=_0x511e48[0x1];if(!_[_0x2a9d('0x21')](_0x271ac2)){var _0x1471bc=_0x271ac2[_0x2a9d('0x20')]('|');var _0xb5bbb9=[];for(var _0x88a8c1=0x0;_0x88a8c1<_0x1471bc[_0x2a9d('0x1d')];_0x88a8c1++){if(_0x1471bc[_0x88a8c1]!==''){var _0x58dfe7=_[_0x2a9d('0x22')](promisesAdditionalPhones,{'contactId':_0x340cef,'phone':_0x1471bc[_0x88a8c1]});if(_0x58dfe7['length']==0x0){orderBy++;promisesAdditionalPhones[_0x2a9d('0x1e')]({'contactId':_0x340cef,'contactTypeId':_0x3baf86,'phone':_0x1471bc[_0x88a8c1],'orderBy':orderBy});}}}_0x43eef({'ok':0x1});}else _0x43eef({'res':0x0});});}function createAdditionalPhone(_0x468a15,_0x3c9772,_0x10ed54,_0x3c8b12){var _0x2ac264='';var _0x292429='';var _0x932a81=_0x10ed54['split']('§');_0x2ac264=_0x932a81[0x0];if(_0x932a81[_0x2a9d('0x1d')]==0x2)_0x292429=_0x932a81[0x1];return new Promise(function(_0x5807f5,_0x4f77fb){return db[_0x2a9d('0x23')][_0x2a9d('0x24')]({'where':{'CmContactId':_0x468a15,'item':_0x2ac264}})[_0x2a9d('0x1c')](function(_0x5ba510){if(_0x5ba510){return db[_0x2a9d('0x23')]['update']({'ItemTypeId':_0x3c9772,'description':_0x292429,'OrderBy':_0x3c8b12},{'where':{'CmContactId':_0x468a15,'item':_0x2ac264}})[_0x2a9d('0x1c')](function(_0x1932b4){_0x5807f5({'res':_0x2a9d('0x25')});});}else{return db[_0x2a9d('0x23')][_0x2a9d('0x26')]({'CmContactId':_0x468a15,'item':_0x2ac264,'description':_0x292429,'ItemTypeId':_0x3c9772,'OrderBy':_0x3c8b12,'ItemClass':_0x2a9d('0x27')})[_0x2a9d('0x1c')](function(_0x5e0764){_0x5807f5({'res':'inserted'});});}});});}function insertCmHopper(_0x51a86e,_0x4f4c9e,_0xecd76c,_0x179c56,_0x54ac6c){var _0x587c56=[_0x2a9d('0x28'),'cm_contacts.scheduledat',_0x2a9d('0x29'),'cm_contacts.ListId',_0x4f4c9e+'.'+_0x179c56,'cm_contacts.createdAt',_0x2a9d('0x2a'),_0x2a9d('0x2b'),_0x2a9d('0x2c'),'\x22'+_0x54ac6c+'\x22'];return squel[_0x2a9d('0x2d')]()[_0x2a9d('0x2e')]('cm_hopper')[_0x2a9d('0x2f')]([_0x2a9d('0x14'),'scheduledat',_0x2a9d('0x30'),'ListId',_0x179c56,_0x2a9d('0x31'),'updatedAt',_0x2a9d('0x32'),'UserId','recallme'],squel[_0x2a9d('0x12')]()[_0x2a9d('0x33')](_0x587c56)['from'](_0x4f4c9e)[_0x2a9d('0x16')](_0x2a9d('0x34'),null,_0x2a9d('0x35')+_0x4f4c9e+'.CmListId')['join'](_0xecd76c,null,_0xecd76c+'.id\x20=\x20'+_0x4f4c9e+'.'+_0x179c56)[_0x2a9d('0x19')](_0x4f4c9e+_0x2a9d('0x36'),_0x51a86e)[_0x2a9d('0x19')](_0x2a9d('0x37'),NOW)[_0x2a9d('0x19')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x4f4c9e,_0xecd76c,_0x179c56,_0x2a9d('0x38'),[_0x2a9d('0x39'),_0x2a9d('0x3a')]))['where'](_0x2a9d('0x3b'),selectNotIn(_0x4f4c9e,_0xecd76c,_0x179c56,_0x2a9d('0x38'),['\x22always\x22'])))[_0x2a9d('0x3c')]();}function insertCmHopperBlack(_0x134871,_0x3aba35,_0x2074ae,_0x233f41){var _0x741a80=[_0x2a9d('0x28'),_0x2a9d('0x29'),_0x2a9d('0x3d'),_0x3aba35+'.'+_0x233f41,_0x2a9d('0x3e'),_0x2a9d('0x2a')];return squel[_0x2a9d('0x2d')]()[_0x2a9d('0x2e')](_0x2a9d('0x3f'))['fromQuery'](['phone',_0x2a9d('0x30'),'ListId',_0x233f41,_0x2a9d('0x31'),_0x2a9d('0x40')],squel['select']()[_0x2a9d('0x33')](_0x741a80)['from'](_0x3aba35)[_0x2a9d('0x16')](_0x2a9d('0x34'),null,_0x2a9d('0x35')+_0x3aba35+_0x2a9d('0x41'))[_0x2a9d('0x16')](_0x2074ae,null,_0x2074ae+_0x2a9d('0x17')+_0x3aba35+'.'+_0x233f41)['where'](_0x3aba35+_0x2a9d('0x36'),_0x134871)[_0x2a9d('0x19')](_0x2a9d('0x37'),NOW)[_0x2a9d('0x19')](_0x2a9d('0x3b'),squel[_0x2a9d('0x12')]()[_0x2a9d('0x13')](_0x2a9d('0x14'))[_0x2a9d('0x15')](_0x2a9d('0x3f'))[_0x2a9d('0x19')](_0x2a9d('0x42'),_0x134871)[_0x2a9d('0x19')](_0x233f41+_0x2a9d('0x18')+_0x3aba35+'.'+_0x233f41)))['toString']();}function insertTzCmHopper(_0x3a2c55,_0x1170e2,_0x26ee31,_0x31d7dc,_0x14fc2a,_0x5ba3fb){var _0x4a32cc=[_0x2a9d('0x28'),_0x2a9d('0x43')+_0x5ba3fb+_0x2a9d('0x44'),_0x2a9d('0x29'),_0x2a9d('0x3d'),_0x1170e2+'.'+_0x31d7dc,_0x2a9d('0x3e'),_0x2a9d('0x2a'),_0x2a9d('0x2b'),'cm_contacts.UserId','\x22'+_0x14fc2a+'\x22'];var _0x5379bb=squel[_0x2a9d('0x2d')]()[_0x2a9d('0x2e')]('cm_hopper')[_0x2a9d('0x2f')]([_0x2a9d('0x14'),'scheduledat',_0x2a9d('0x30'),_0x2a9d('0x45'),_0x31d7dc,_0x2a9d('0x31'),_0x2a9d('0x40'),_0x2a9d('0x32'),_0x2a9d('0x46'),_0x2a9d('0x47')],squel[_0x2a9d('0x12')]()[_0x2a9d('0x33')](_0x4a32cc)[_0x2a9d('0x15')](_0x1170e2)[_0x2a9d('0x16')](_0x2a9d('0x34'),null,_0x2a9d('0x35')+_0x1170e2+_0x2a9d('0x41'))[_0x2a9d('0x16')](_0x26ee31,null,_0x26ee31+_0x2a9d('0x17')+_0x1170e2+'.'+_0x31d7dc)[_0x2a9d('0x16')](_0x5ba3fb,null,_0x5ba3fb+_0x2a9d('0x17')+_0x1170e2+'.'+_0x31d7dc)[_0x2a9d('0x19')](_0x1170e2+'.CmListId\x20=\x20?',_0x3a2c55)['where'](_0x2a9d('0x37'),NOW)['where'](_0x2a9d('0x3b'),selectNotIn(_0x1170e2,_0x26ee31,_0x31d7dc,_0x2a9d('0x38'),['\x22always\x22',_0x2a9d('0x3a')]))['where'](_0x2a9d('0x3b'),selectNotIn(_0x1170e2,_0x26ee31,_0x31d7dc,_0x2a9d('0x38'),[_0x2a9d('0x39')])))[_0x2a9d('0x3c')]();return _0x5379bb;}function insertTzCmHopperBlack(_0x4728af,_0x278c69,_0x59efc6,_0xbd716b){var _0x5d8aaf=[_0x2a9d('0x28'),_0x2a9d('0x29'),_0x2a9d('0x3d'),_0x278c69+'.'+_0xbd716b,_0x2a9d('0x3e'),'cm_contacts.updatedAt'];return squel[_0x2a9d('0x2d')]()['into'](_0x2a9d('0x3f'))[_0x2a9d('0x2f')]([_0x2a9d('0x14'),_0x2a9d('0x30'),_0x2a9d('0x45'),_0xbd716b,_0x2a9d('0x31'),_0x2a9d('0x40')],squel['select']()[_0x2a9d('0x33')](_0x5d8aaf)[_0x2a9d('0x15')](_0x278c69)[_0x2a9d('0x16')](_0x2a9d('0x34'),null,'cm_contacts.ListId\x20=\x20'+_0x278c69+_0x2a9d('0x41'))[_0x2a9d('0x16')](_0x59efc6,null,_0x59efc6+_0x2a9d('0x17')+_0x278c69+'.'+_0xbd716b)[_0x2a9d('0x19')](_0x278c69+_0x2a9d('0x36'),_0x4728af)[_0x2a9d('0x19')](_0x2a9d('0x37'),NOW)[_0x2a9d('0x19')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel[_0x2a9d('0x12')]()[_0x2a9d('0x13')](_0x2a9d('0x14'))[_0x2a9d('0x15')](_0x2a9d('0x3f'))[_0x2a9d('0x19')](_0x2a9d('0x42'),_0x4728af)['where'](_0xbd716b+_0x2a9d('0x18')+_0x278c69+'.'+_0xbd716b)))[_0x2a9d('0x3c')]();}function insertCmHopperAdditionalPhones(_0x4f7c7d){var _0x236a92=[_0x2a9d('0x48'),_0x2a9d('0x49'),'cm_contact_has_items.OrderBy',_0x2a9d('0x4a'),_0x2a9d('0x4b')];return squel[_0x2a9d('0x2d')]()[_0x2a9d('0x2e')](_0x2a9d('0x4c'))[_0x2a9d('0x2f')]([_0x2a9d('0x4d'),_0x2a9d('0x14'),'OrderBy','createdAt','updatedAt'],squel[_0x2a9d('0x12')]()[_0x2a9d('0x33')](_0x236a92)[_0x2a9d('0x15')]('cm_hopper')[_0x2a9d('0x16')](_0x2a9d('0x34'),null,_0x2a9d('0x4e'))[_0x2a9d('0x16')](_0x2a9d('0x4f'),null,_0x2a9d('0x50'))[_0x2a9d('0x19')](_0x2a9d('0x51'),_0x4f7c7d)[_0x2a9d('0x19')]('cm_contacts.createdAt\x20=\x20?',NOW))['toString']();}function insertCmContact(_0x2025da,_0x3a0960,_0x53070a,_0x54ba4a){var _0x3cfce6=_[_0x2a9d('0x52')](_[_0x2a9d('0x53')](_0x54ba4a),[_0x2a9d('0x45'),_0x2a9d('0x54'),_0x2a9d('0x31'),_0x2a9d('0x40'),_0x2a9d('0x55')]);return squel[_0x2a9d('0x2d')]()[_0x2a9d('0x2e')](_0x2a9d('0x34'))[_0x2a9d('0x2f')](_0x3cfce6,squel[_0x2a9d('0x12')]()['fields'](_0x3cfce6)[_0x2a9d('0x15')](_0x3a0960)['where']('('+_0x53070a[_0x2a9d('0x16')](',')+_0x2a9d('0x56'),squel[_0x2a9d('0x12')]()[_0x2a9d('0x33')](_0x53070a)[_0x2a9d('0x15')]('cm_contacts')[_0x2a9d('0x19')](_0x2a9d('0x42'),_0x2025da)['where'](_0x2a9d('0x57')))['where'](_0x2a9d('0x58'),squel['select']()[_0x2a9d('0x13')](_0x2a9d('0x59'),_0x2a9d('0x5a'))[_0x2a9d('0x15')](_0x3a0960)['group'](_0x53070a[_0x2a9d('0x16')](','))))[_0x2a9d('0x3c')]();}function handleStop(){logger[_0x2a9d('0x5b')](_0x2a9d('0x5c'));stopped=!![];}function handleUncaughtException(_0x8d3d12){logger[_0x2a9d('0x5d')](_0x8d3d12['message']);process[_0x2a9d('0x5e')](0x1);}function handleError(_0x47a3cb,_0x4f06ed){stats[_0x2a9d('0x5f')]['push']({'name':_0x4f06ed[_0x2a9d('0x60')],'message':_0x4f06ed[_0x2a9d('0x61')],'row':_0x47a3cb});}function handleQuery(_0x4d1288){logger[_0x2a9d('0x5b')](_0x4d1288);return db[_0x2a9d('0x62')][_0x2a9d('0x63')](_0x4d1288)[_0x2a9d('0x64')](function(_0x37b32e){results[_0x2a9d('0x1e')](_0x37b32e);})[_0x2a9d('0x65')](function(_0x95e294){logger[_0x2a9d('0x5d')](_0x95e294[_0x2a9d('0x61')]);});}function updateTzCampaigns(_0x3e668a){return new Promise(function(_0x438dc9,_0x4b778c){var _0xdad1f5=squel[_0x2a9d('0x12')]()[_0x2a9d('0x33')](['campaigns.id',_0x2a9d('0x66')])[_0x2a9d('0x15')]('campaigns')[_0x2a9d('0x16')](_0x2a9d('0x67'),null,_0x2a9d('0x68'))[_0x2a9d('0x19')](_0x2a9d('0x69')+_0x3e668a);db[_0x2a9d('0x62')][_0x2a9d('0x63')](_0xdad1f5[_0x2a9d('0x3c')]())[_0x2a9d('0x64')](function(_0x421ae6){var _0x53a6cf=[];for(var _0x2ff8c1=0x0;_0x2ff8c1<_0x421ae6[_0x2a9d('0x1d')];_0x2ff8c1++){_0x53a6cf[_0x2a9d('0x1e')](getTimezoneData(_0x421ae6[_0x2ff8c1],tmp_campaigns));}BPromise[_0x2a9d('0x1f')](_0x53a6cf)[_0x2a9d('0x1c')](function(){_0x438dc9({'val':0x1});});})['catch'](function(_0x515270){logger[_0x2a9d('0x5d')](_0x515270['message']);_0x438dc9({'val':0x0});});});}function updateTzVoiceQueues(_0x431c9f){return new Promise(function(_0x1fa839,_0x42c196){var _0x1ab76e=squel[_0x2a9d('0x12')]()[_0x2a9d('0x33')]([_0x2a9d('0x6a'),_0x2a9d('0x6b')])[_0x2a9d('0x15')](_0x2a9d('0x6c'))['join']('voice_queues_has_cm_lists',null,'voice_queues.id\x20=\x20voice_queues_has_cm_lists.VoiceQueueId')['where'](_0x2a9d('0x6d')+_0x431c9f);db[_0x2a9d('0x62')]['query'](_0x1ab76e[_0x2a9d('0x3c')]())[_0x2a9d('0x64')](function(_0x232ad1){var _0x2af4dd=[];for(var _0x59ab01=0x0;_0x59ab01<_0x232ad1[_0x2a9d('0x1d')];_0x59ab01++){_0x2af4dd[_0x2a9d('0x1e')](getTimezoneData(_0x232ad1[_0x59ab01],tmp_voice_queues));}BPromise[_0x2a9d('0x1f')](_0x2af4dd)[_0x2a9d('0x1c')](function(){_0x1fa839({'val':0x1});});})[_0x2a9d('0x65')](function(_0x374a2a){logger[_0x2a9d('0x5d')](_0x374a2a[_0x2a9d('0x61')]);_0x1fa839({'val':0x0});});});}function getTimezoneData(_0x46e3f9,_0x26297c){return new Promise(function(_0x607f46,_0x4f515f){var _0x44de5b=shared['timezones'];var _0x4f4a3f=_0x44de5b[_0x46e3f9['dialTimezone']];if(_[_0x2a9d('0x21')](_0x4f4a3f)){_0x607f46({'ret':0x1});}else{var _0x18bbae=_0x4f4a3f[_0x2a9d('0x6e')];var _0x2658ba=squel[_0x2a9d('0x2d')]()[_0x2a9d('0x2e')](_0x26297c)[_0x2a9d('0x6f')]('id',_0x46e3f9['id'])[_0x2a9d('0x6f')](_0x2a9d('0x70'),_0x18bbae)['set']('dialTimezone',_0x46e3f9[_0x2a9d('0x71')])[_0x2a9d('0x3c')]();return db[_0x2a9d('0x62')][_0x2a9d('0x63')](_0x2658ba)[_0x2a9d('0x64')](function(_0x2f4517){_0x607f46({'ret':0x1});})[_0x2a9d('0x65')](function(_0x3e54d3){logger[_0x2a9d('0x5d')](_0x3e54d3[_0x2a9d('0x61')]);_0x4f515f({'ret':0x1});});}});}function handleTZQuery(_0x2e62b3){logger[_0x2a9d('0x5b')](_0x2e62b3);return db[_0x2a9d('0x62')][_0x2a9d('0x63')](_0x2e62b3)[_0x2a9d('0x64')](function(_0x1c5963){})[_0x2a9d('0x65')](function(_0xc28749){logger[_0x2a9d('0x5d')](_0xc28749['message']);});}function main(_0x2d8db2,_0x13aa36,_0x38a1a4,_0x5b4fe2){logger[_0x2a9d('0x5b')](_0x2a9d('0x72'),_0x2d8db2,JSON[_0x2a9d('0x73')](_0x13aa36));process[_0x2a9d('0x74')]('start');var _0x454b59=_0x13aa36['binding'];var _0x448560=_[_0x2a9d('0x75')](_0x454b59);var _0x4b97d3=_0x13aa36[_0x2a9d('0x76')];var _0x31a8f4=path[_0x2a9d('0x16')](config['root'],'server/files/tmp',_0x4b97d3+_0x2a9d('0x77'));hasTZ=_[_0x2a9d('0x53')](_0x454b59)[_0x2a9d('0x78')](_0x2a9d('0x71'));var _0xdcb089=_[_0x2a9d('0x53')](_0x454b59)['join']();logger['info'](_0x2a9d('0x79'),_0xdcb089);db['ContactItemType'][_0x2a9d('0x7a')]({'raw':!![],'attributes':['id','name']})[_0x2a9d('0x1c')](function(_0x3516a2){for(var _0x235cb8=0x0;_0x235cb8<_0x3516a2['length'];_0x235cb8++){if(_0x3516a2[_0x235cb8][_0x2a9d('0x7b')]in _0x454b59){contactItemTypes[_0x2a9d('0x1e')](_0x3516a2[_0x235cb8]);delete _0x448560[_0x3516a2[_0x235cb8][_0x2a9d('0x7b')]];hasAdditionalPhones=!![];}for(var _0x3555aa in _0x454b59){if(_0x3516a2[_0x235cb8]['name']+'_description'===_0x3555aa){phoneDescriptions['push']({'itemTypeId':_0x3516a2[_0x235cb8]['id'],'description':_0x3555aa});delete _0x448560[_0x3555aa];}}}if(hasAdditionalPhones)_0x448560['AdditionalPhones']='';var _0x283473=_[_0x2a9d('0x53')](_0x448560)[_0x2a9d('0x16')]();logger[_0x2a9d('0x5b')](_0x2a9d('0x79'),_0x283473);fs[_0x2a9d('0x7c')](_0x31a8f4,_0x283473+'\x0a');Papa['parse'](fs[_0x2a9d('0x7d')](_0x2d8db2),{'header':!![],'skipEmptyLines':!![],'step':function(_0x3debe1,_0xa70231){try{for(var _0x58ae08=0x0,_0x40d651=[];_0x58ae08<_0x3debe1[_0x2a9d('0x7e')][_0x2a9d('0x1d')];_0x58ae08++){stats[_0x2a9d('0x7f')]+=0x1;if(_0x3debe1[_0x2a9d('0x5f')][_0x58ae08]){handleError(_0x3debe1[_0x2a9d('0x7e')][_0x58ae08],_0x3debe1[_0x2a9d('0x5f')][_0x58ae08]);}else{var _0x3a10c4=[];var _0x26b0f7=[];var _0x34d61c={};for(var _0x4a1356 in _0x454b59){let _0x2defcb=contactItemTypes[_0x2a9d('0x80')](_0x2458a9=>_0x2458a9['name']===_0x4a1356);let _0x30b283=contactItemTypes['find'](_0x4eb257=>_0x4eb257[_0x2a9d('0x7b')]+'_description'===_0x4a1356);if(_['isNil'](_0x2defcb)&&_[_0x2a9d('0x21')](_0x30b283)){if(_0x454b59[_0x2a9d('0x81')](_0x4a1356)){if(_0x3debe1[_0x2a9d('0x7e')][_0x58ae08][_0x454b59[_0x4a1356]]){var _0x1d59a3=_[_0x2a9d('0x82')](_0x3debe1['data'][_0x58ae08][_0x454b59[_0x4a1356]][_0x2a9d('0x83')](/"/g,'\x27'));switch(_0x4a1356){case'scheduledat':var _0x998e04=moment(_0x1d59a3,'YYYY-MM-DD\x20HH:mm:ss',!![]);if(_0x998e04['isValid']()){_0x40d651[_0x2a9d('0x1e')]('\x22'+_0x1d59a3+'\x22');}else{_0x3a10c4[_0x2a9d('0x1e')](_0x2a9d('0x84'));}break;case _0x2a9d('0x32'):var _0x1e5d08=parseInt(_0x1d59a3);_0x1d59a3=_[_0x2a9d('0x85')](_0x1e5d08)||_0x1e5d08<0x0||_0x1e5d08>0x4?_0x5b4fe2?0x3:0x2:_0x1e5d08;_0x40d651[_0x2a9d('0x1e')]('\x22'+_0x1d59a3+'\x22');break;case _0x2a9d('0x46'):var _0x369968=parseInt(_0x1d59a3);if(_[_0x2a9d('0x86')](_0x369968)&&_[_0x2a9d('0x78')](_0x38a1a4,_0x369968)){_0x40d651[_0x2a9d('0x1e')]('\x22'+_0x369968+'\x22');}else{_0x3a10c4[_0x2a9d('0x1e')]('agent\x20not\x20exists');}break;case _0x2a9d('0x87'):if(isEmail(_0x1d59a3)){_0x40d651[_0x2a9d('0x1e')]('\x22'+_0x1d59a3+'\x22');}else{_0x3a10c4['push'](_0x2a9d('0x88'));}break;case _0x2a9d('0x89'):var _0x57fb58=moment(_0x1d59a3,_0x2a9d('0x8a'),!![]);if(_0x57fb58['isValid']()){_0x40d651[_0x2a9d('0x1e')]('\x22'+_0x1d59a3+'\x22');}else{_0x3a10c4[_0x2a9d('0x1e')](_0x2a9d('0x8b'));}break;case'dialTimezone':var _0x446bc1=shared[_0x2a9d('0x8c')];var _0x59f6c7=_0x446bc1[_0x1d59a3];if(!_[_0x2a9d('0x21')](_0x59f6c7)){var _0x537c3f=_0x59f6c7[_0x2a9d('0x6e')];_0x40d651[_0x2a9d('0x1e')]('\x22'+_0x1d59a3+'\x22');_0x40d651[_0x2a9d('0x1e')]('\x22'+_0x537c3f+'\x22');}break;default:_0x40d651['push']('\x22'+_0x1d59a3+'\x22');}}else{switch(_0x4a1356){case _0x2a9d('0x8d'):case'phone':_0x3a10c4[_0x2a9d('0x1e')](_0x4a1356+_0x2a9d('0x8e'));break;default:_0x40d651[_0x2a9d('0x1e')]('\x22\x22');}}}}else{var _0x2a66cb='';if(!_['isNil'](_0x2defcb)){if(!_0x34d61c[_0x2a9d('0x81')](_0x2defcb['id'])){if(!_[_0x2a9d('0x21')](_0x3debe1[_0x2a9d('0x7e')][_0x58ae08][_0x454b59[_0x4a1356]])){var _0x1d59a3=_[_0x2a9d('0x82')](_0x3debe1['data'][_0x58ae08][_0x454b59[_0x4a1356]][_0x2a9d('0x83')](/"/g,'\x27'));var _0x303b47=phoneDescriptions['find'](_0x3483f3=>_0x3483f3[_0x2a9d('0x8f')]===_0x2defcb['id']);if(!_[_0x2a9d('0x21')](_0x303b47)){var _0x804591=_[_0x2a9d('0x82')](_0x3debe1[_0x2a9d('0x7e')][_0x58ae08][_0x454b59[_0x303b47[_0x2a9d('0x90')]]][_0x2a9d('0x83')](/"/g,'\x27'));if(!_[_0x2a9d('0x21')](_0x804591))_0x1d59a3=_0x1d59a3+'§'+_0x804591;}if(_0x2a66cb=='')_0x2a66cb=_0x1d59a3;else _0x2a66cb+='|'+_0x1d59a3;}_0x26b0f7[_0x2a9d('0x1e')](_0x2defcb['id']+':'+_0x2a66cb);_0x34d61c[_0x2defcb['id']]=0x1;}}}}if(hasAdditionalPhones){_0x40d651[_0x2a9d('0x1e')]('\x22'+_0x26b0f7['join'](';')+'\x22');}if(_0x3a10c4[_0x2a9d('0x1d')]){handleError(_0x3debe1[_0x2a9d('0x7e')][_0x58ae08],{'code':_0x2a9d('0x91'),'message':_0x3a10c4[_0x2a9d('0x16')]()});}else{fs[_0x2a9d('0x92')](_0x31a8f4,_0x40d651[_0x2a9d('0x16')]()+'\x0a');}_0x40d651=[];}if(!(stats[_0x2a9d('0x7f')]%0xc8)){socket[_0x2a9d('0x93')](_0x2a9d('0x94')+_0x4b97d3,stats);stats[_0x2a9d('0x5f')]=[];}}if(stopped){logger[_0x2a9d('0x5b')](_0x2a9d('0x95'));_0xa70231[_0x2a9d('0x96')]();}}catch(_0x5bda71){handleError(_0x3debe1[_0x2a9d('0x7e')][_0x58ae08],{'code':_0x2a9d('0x97'),'message':_0x5bda71[_0x2a9d('0x61')]});logger[_0x2a9d('0x5d')](_0x2a9d('0x98'),_0x5bda71[_0x2a9d('0x61')]);}},'complete':function(){try{var _0x410b0c=[];var _0x251607=[];var _0x6951d0=_0x2a9d('0x34');if(_0x13aa36[_0x2a9d('0x99')]&&_0x13aa36[_0x2a9d('0x99')][_0x2a9d('0x1d')]){_0x6951d0=_0x2a9d('0x9a')+_0x4b97d3;_0x410b0c[_0x2a9d('0x1e')](_0x2a9d('0x9b')+_0x6951d0+_0x2a9d('0x9c'));}tmp_campaigns=_0x2a9d('0x9d')+_0x4b97d3;tmp_voice_queues=_0x2a9d('0x9e')+_0x4b97d3;_0x251607[_0x2a9d('0x1e')](_0x2a9d('0x9b')+tmp_campaigns+_0x2a9d('0x9f'));_0x251607[_0x2a9d('0x1e')](_0x2a9d('0x9b')+tmp_voice_queues+_0x2a9d('0x9f'));BPromise[_0x2a9d('0xa0')](_0x251607,handleTZQuery)[_0x2a9d('0x1c')](function(_0x2e0421){updateTzCampaigns(_0x13aa36[_0x2a9d('0x45')])[_0x2a9d('0x1c')](function(_0x466986){updateTzVoiceQueues(_0x13aa36[_0x2a9d('0x45')])['then'](function(_0x2b33a7){if(hasTZ)_0x283473=_0x283473['replace'](_0x2a9d('0x71'),_0x2a9d('0xa1'));var _0x25dc3f=util[_0x2a9d('0xf')](_0x2a9d('0xa2'),_0x31a8f4,_0x6951d0,_0x283473,_0x13aa36['ListId'],_0x13aa36['CompanyId']||null,NOW,NOW);if(_[_0x2a9d('0x21')](_0x454b59[_0x2a9d('0xa3')])){_0x25dc3f+=_0x2a9d('0xa4');}_0x410b0c[_0x2a9d('0x1e')](_0x25dc3f);if(_0x13aa36['duplicates']&&_0x13aa36[_0x2a9d('0x99')][_0x2a9d('0x1d')]){_0x410b0c[_0x2a9d('0x1e')](insertCmContact(_0x13aa36[_0x2a9d('0x45')],_0x6951d0,_0x13aa36['duplicates'],_0x454b59));_0x410b0c['push'](_0x2a9d('0xa5')+_0x6951d0+';');}BPromise['each'](_0x410b0c,handleQuery)[_0x2a9d('0x1c')](function(_0x2f9a51){BPromise['all']([handleAdditionalPhones()])['then'](function(){_0x410b0c=[];for(var _0x526ddd=0x0;_0x526ddd<promisesAdditionalPhones[_0x2a9d('0x1d')];_0x526ddd++){if(promisesAdditionalPhones[_0x526ddd]['phone']!='§'){_0x410b0c[_0x2a9d('0x1e')](createAdditionalPhone(promisesAdditionalPhones[_0x526ddd][_0x2a9d('0xa6')],promisesAdditionalPhones[_0x526ddd][_0x2a9d('0xa7')],promisesAdditionalPhones[_0x526ddd]['phone'],promisesAdditionalPhones[_0x526ddd][_0x2a9d('0xa8')]));}}BPromise[_0x2a9d('0x1f')](_0x410b0c)['then'](function(){_0x410b0c=[];if(hasTZ){_0x410b0c['push'](insertTzCmHopper(_0x13aa36[_0x2a9d('0x45')],_0x2a9d('0xa9'),_0x2a9d('0x6c'),_0x2a9d('0xaa'),_0x5b4fe2,tmp_voice_queues));_0x410b0c[_0x2a9d('0x1e')](insertTzCmHopperBlack(_0x13aa36[_0x2a9d('0x45')],_0x2a9d('0xab'),_0x2a9d('0x6c'),_0x2a9d('0xaa')));_0x410b0c[_0x2a9d('0x1e')](insertTzCmHopper(_0x13aa36[_0x2a9d('0x45')],_0x2a9d('0x67'),_0x2a9d('0xac'),_0x2a9d('0xad'),_0x5b4fe2,tmp_campaigns));_0x410b0c[_0x2a9d('0x1e')](insertTzCmHopperBlack(_0x13aa36[_0x2a9d('0x45')],_0x2a9d('0xae'),_0x2a9d('0xac'),_0x2a9d('0xad')));_0x410b0c['push'](insertCmHopperAdditionalPhones(_0x13aa36[_0x2a9d('0x45')]));}else{_0x410b0c[_0x2a9d('0x1e')](insertCmHopper(_0x13aa36[_0x2a9d('0x45')],'voice_queues_has_cm_lists',_0x2a9d('0x6c'),'VoiceQueueId',_0x5b4fe2));_0x410b0c['push'](insertCmHopperBlack(_0x13aa36['ListId'],_0x2a9d('0xab'),'voice_queues',_0x2a9d('0xaa')));_0x410b0c[_0x2a9d('0x1e')](insertCmHopper(_0x13aa36[_0x2a9d('0x45')],_0x2a9d('0x67'),_0x2a9d('0xac'),_0x2a9d('0xad'),_0x5b4fe2));_0x410b0c['push'](insertCmHopperBlack(_0x13aa36[_0x2a9d('0x45')],_0x2a9d('0xae'),_0x2a9d('0xac'),_0x2a9d('0xad')));_0x410b0c[_0x2a9d('0x1e')](insertCmHopperAdditionalPhones(_0x13aa36[_0x2a9d('0x45')]));}_0x410b0c[_0x2a9d('0x1e')]('DROP\x20TABLE\x20'+tmp_campaigns+';');_0x410b0c[_0x2a9d('0x1e')](_0x2a9d('0xa5')+tmp_voice_queues+';');BPromise[_0x2a9d('0xa0')](_0x410b0c,handleQuery)[_0x2a9d('0x1c')](function(_0x158bd0){stats[_0x2a9d('0xaf')]=!![];stats[_0x2a9d('0xb0')]=_0x13aa36[_0x2a9d('0x99')]&&_0x13aa36[_0x2a9d('0x99')][_0x2a9d('0x1d')]?results[0x2][_0x2a9d('0xb0')]:results[0x0]['affectedRows'];socket['emit'](_0x2a9d('0x94')+_0x4b97d3,stats);fs['unlink'](_0x2d8db2);fs[_0x2a9d('0xb1')](_0x31a8f4);process[_0x2a9d('0x5e')](0x0);})[_0x2a9d('0x65')](function(_0x4c71d7){logger[_0x2a9d('0x5d')](_0x4c71d7['message']);process['exit'](0x1);});});});})[_0x2a9d('0x65')](function(_0x1f9a2f){logger[_0x2a9d('0x5d')](_0x1f9a2f['message']);process[_0x2a9d('0x5e')](0x1);});});});});}catch(_0x62e78e){logger[_0x2a9d('0x5d')]('complete',_0x62e78e[_0x2a9d('0x61')]);process[_0x2a9d('0x5e')](0x1);}},'error':function(_0x5c8184,_0x29e0fd,_0x328094,_0x74d96f){throw new Error(_0x74d96f);}});});}function validate(){if(process[_0x2a9d('0xb2')]&&process[_0x2a9d('0xb2')][_0x2a9d('0x1d')]<0x4){throw new Error(_0x2a9d('0xb3'));}var _0x304abe=path[_0x2a9d('0x16')](config[_0x2a9d('0xb4')],'server/files/tmp',process[_0x2a9d('0xb2')][0x2]);if(!fs[_0x2a9d('0xb5')](_0x304abe)){throw new Error(_0x2a9d('0xb6'));}var _0x4817f0={};try{_0x4817f0=JSON[_0x2a9d('0xb7')](process[_0x2a9d('0xb2')][0x3]);if(!_0x4817f0[_0x2a9d('0xb8')]){throw new Error(_0x2a9d('0xb9'));}if(!_0x4817f0[_0x2a9d('0xb8')][_0x2a9d('0x14')]){throw new Error(_0x2a9d('0xba'));}if(!_0x4817f0[_0x2a9d('0xb8')]['firstName']){throw new Error(_0x2a9d('0xbb'));}var _0x453360=0x0;if(_0x4817f0['binding'][_0x2a9d('0x46')]){_0x453360=0x1;}if(!_0x4817f0[_0x2a9d('0x45')]){throw new Error('ListId\x20is\x20mandatory');}}catch(_0x162f81){throw new Error(_0x2a9d('0xbc'));}var _0x56b377=[];try{_0x56b377=_['map'](JSON[_0x2a9d('0xb7')](process[_0x2a9d('0xb2')][0x4]),'id');}catch(_0x3521c7){logger[_0x2a9d('0x5b')]('No\x20agent\x20available');}main(_0x304abe,_0x4817f0,_0x56b377,_0x453360);}validate();process['on']('SIGINT',handleStop);process['on'](_0x2a9d('0xbd'),handleUncaughtException);
\ No newline at end of file
+var _0x2fe4=['min_id','group','info','error','message','exit','errors','code','sequelize','query','spread','catch','campaigns.dialTimezone','campaigns_has_cm_lists','campaigns.id\x20=\x20campaigns_has_cm_lists.CampaignId','campaigns_has_cm_lists.CmListId=','voice_queues.id','voice_queues.dialTimezone','voice_queues','voice_queues_has_cm_lists','voice_queues.id\x20=\x20voice_queues_has_cm_lists.VoiceQueueId','timezones','dialTimezone','isNil','utcOffset','offset','set','main','send','start','binding','clone','socket_timestamp','root','server/files/tmp','includes','header','ContactItemType','name','_description','writeFileSync','parse','createReadStream','data','rows','find','hasOwnProperty','trim','replace','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','agent\x20not\x20exists','email','YYYY-MM-DD','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','\x20not\x20specified','itemTypeId','description','SystemRow','appendFileSync','emit','contact:import:','Abort\x20parser','SystemError','step','duplicates','cm_contacts_','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','(id\x20int,dialTimezone\x20varchar(255),offset\x20int);','each',',\x20scheduledAt\x20=\x20NOW()','DROP\x20TABLE\x20','contactId','orderBy','campaigns','CampaignId','VoiceQueueId','voice_queues_has_cm_blacklists','campaigns_has_cm_blacklists','finish','affectedRows','unlink','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','phone\x20is\x20mandatory','firstName','body\x20id\x20mandatory','No\x20agent\x20available','uncaughtException','path','lodash','papaparse','util','bluebird','moment','squel','ioredis','../../../mysqldb','../../../config/environment','../../../config/environment/shared','../../../config/logger','defaults','redis','socket.io-emitter','format','YYYY-MM-DD\x20HH:mm:ss','test','phone','from','join','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','CmContact','findAll','AdditionalPhones','then','push','all','split','length','filter','update','create','inserted','cm_contacts.phone','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','priority','UserId','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','.id\x20=\x20','.CmListId\x20=\x20?','\x22always\x22','\x22onlyIfOpen\x22','toString','cm_hopper_black','select','cm_contacts.createdAt\x20=\x20?','field','ListId\x20=\x20?','updatedAt','recallme','cm_contacts.phone\x20NOT\x20IN\x20(?)','ContactId','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','CmHopperId','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId','scheduledAt',')\x20NOT\x20IN\x20?','deletedAt\x20IS\x20NULL','MIN(id)'];(function(_0x2b78e5,_0x3126f8){var _0xa8d52d=function(_0x51fd7f){while(--_0x51fd7f){_0x2b78e5['push'](_0x2b78e5['shift']());}};_0xa8d52d(++_0x3126f8);}(_0x2fe4,0x110));var _0x42fe=function(_0x3c54ed,_0x1bb9b0){_0x3c54ed=_0x3c54ed-0x0;var _0x37d5a6=_0x2fe4[_0x3c54ed];return _0x37d5a6;};'use strict';var fs=require('fs');var path=require(_0x42fe('0x0'));var _=require(_0x42fe('0x1'));var Papa=require(_0x42fe('0x2'));var util=require(_0x42fe('0x3'));var BPromise=require(_0x42fe('0x4'));var moment=require(_0x42fe('0x5'));var squel=require(_0x42fe('0x6'));var Redis=require(_0x42fe('0x7'));var db=require(_0x42fe('0x8'))['db'];var config=require(_0x42fe('0x9'));var shared=require(_0x42fe('0xa'));var logger=require(_0x42fe('0xb'))('import');config['redis']=_[_0x42fe('0xc')](config[_0x42fe('0xd')],{'host':'localhost','port':0x18eb});var socket=require(_0x42fe('0xe'))(new Redis(config[_0x42fe('0xd')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()[_0x42fe('0xf')](_0x42fe('0x10'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];var tmp_voice_queues;var tmp_campaigns;var tzOffset=0x0;var hasTZ;var NOW=moment()[_0x42fe('0xf')](_0x42fe('0x10'));function isEmail(_0x19c33f){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))*$/[_0x42fe('0x11')](_0x19c33f);}function selectNotIn(_0x45c8b5,_0x1e8dc7,_0x276b2e,_0x1b4130,_0x44f044){return squel['select']()['field'](_0x42fe('0x12'))[_0x42fe('0x13')](_0x1b4130)[_0x42fe('0x14')](_0x1e8dc7,null,_0x1e8dc7+'.id\x20=\x20'+_0x1b4130+'.'+_0x276b2e)['where'](_0x1b4130+'.'+_0x276b2e+_0x42fe('0x15')+_0x45c8b5+'.'+_0x276b2e)[_0x42fe('0x16')](_0x1e8dc7+_0x42fe('0x17')+_0x44f044[_0x42fe('0x14')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x123735,_0x5461c8){promisesAdditionalPhones=[];return db[_0x42fe('0x18')][_0x42fe('0x19')]({'raw':!![],'attributes':['id',_0x42fe('0x1a')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})[_0x42fe('0x1b')](function(_0x2f07e3){if(_0x2f07e3!==null){var _0x15854e=[];for(var _0x103395=0x0;_0x103395<_0x2f07e3['length'];_0x103395++){var _0x2dc3d7=_0x2f07e3[_0x103395];_0x15854e[_0x42fe('0x1c')](insertAdditionalPhones(_0x2dc3d7));}}Promise[_0x42fe('0x1d')](_0x15854e)['then'](function(){_0x123735({'val':0x1});});});});}function insertAdditionalPhones(_0x5cff66){return new Promise(function(_0x4bf905,_0x193704){var _0x4a417e=_0x5cff66[_0x42fe('0x1a')];var _0xe29d0b=_0x4a417e[_0x42fe('0x1e')](';');var _0x21d263=[];orderBy=0x0;for(var _0x59758c=0x0;_0x59758c<_0xe29d0b['length'];_0x59758c++){_0x21d263[_0x42fe('0x1c')](splitAdditionalPhone(_0x5cff66['id'],_0xe29d0b[_0x59758c]));}Promise[_0x42fe('0x1d')](_0x21d263)[_0x42fe('0x1b')](function(){_0x4bf905({'val':_0xe29d0b[_0x42fe('0x1f')]});});});}function splitAdditionalPhone(_0x12d31e,_0x55aee1){return new Promise(function(_0x285597,_0x3c63bb){var _0x156872=_0x55aee1[_0x42fe('0x1e')](':');var _0x539d64=_0x156872[0x0];var _0x4ac805=_0x156872[0x1];if(!_['isNil'](_0x4ac805)){var _0x22045b=_0x4ac805[_0x42fe('0x1e')]('|');var _0x306131=[];for(var _0x47c04e=0x0;_0x47c04e<_0x22045b[_0x42fe('0x1f')];_0x47c04e++){if(_0x22045b[_0x47c04e]!==''){var _0x1198c6=_[_0x42fe('0x20')](promisesAdditionalPhones,{'contactId':_0x12d31e,'phone':_0x22045b[_0x47c04e]});if(_0x1198c6[_0x42fe('0x1f')]==0x0){orderBy++;promisesAdditionalPhones['push']({'contactId':_0x12d31e,'contactTypeId':_0x539d64,'phone':_0x22045b[_0x47c04e],'orderBy':orderBy});}}}_0x285597({'ok':0x1});}else _0x285597({'res':0x0});});}function createAdditionalPhone(_0x553939,_0x57e735,_0x4f8135,_0x3a12d9){var _0xc35591='';var _0x37cbba='';var _0x2552f7=_0x4f8135['split']('§');_0xc35591=_0x2552f7[0x0];if(_0x2552f7['length']==0x2)_0x37cbba=_0x2552f7[0x1];return new Promise(function(_0x231fd0,_0x49f287){return db['CmContactHasItem']['findOne']({'where':{'CmContactId':_0x553939,'item':_0xc35591}})[_0x42fe('0x1b')](function(_0xd66714){if(_0xd66714){return db['CmContactHasItem'][_0x42fe('0x21')]({'ItemTypeId':_0x57e735,'description':_0x37cbba,'OrderBy':_0x3a12d9},{'where':{'CmContactId':_0x553939,'item':_0xc35591}})[_0x42fe('0x1b')](function(_0x381538){_0x231fd0({'res':'updated'});});}else{return db['CmContactHasItem'][_0x42fe('0x22')]({'CmContactId':_0x553939,'item':_0xc35591,'description':_0x37cbba,'ItemTypeId':_0x57e735,'OrderBy':_0x3a12d9,'ItemClass':'PHONE'})[_0x42fe('0x1b')](function(_0x27004f){_0x231fd0({'res':_0x42fe('0x23')});});}});});}function insertCmHopper(_0x1d0b2a,_0x3e58e2,_0x15f770,_0x4aa4ab,_0x2cb0ee){var _0x57cdc6=[_0x42fe('0x24'),'cm_contacts.scheduledat',_0x42fe('0x25'),_0x42fe('0x26'),_0x3e58e2+'.'+_0x4aa4ab,_0x42fe('0x27'),_0x42fe('0x28'),_0x42fe('0x29'),_0x42fe('0x2a'),'\x22'+_0x2cb0ee+'\x22'];return squel[_0x42fe('0x2b')]()[_0x42fe('0x2c')](_0x42fe('0x2d'))[_0x42fe('0x2e')]([_0x42fe('0x12'),_0x42fe('0x2f'),'ContactId',_0x42fe('0x30'),_0x4aa4ab,_0x42fe('0x31'),'updatedAt',_0x42fe('0x32'),_0x42fe('0x33'),'recallme'],squel['select']()[_0x42fe('0x34')](_0x57cdc6)[_0x42fe('0x13')](_0x3e58e2)[_0x42fe('0x14')](_0x42fe('0x35'),null,_0x42fe('0x36')+_0x3e58e2+_0x42fe('0x37'))[_0x42fe('0x14')](_0x15f770,null,_0x15f770+_0x42fe('0x38')+_0x3e58e2+'.'+_0x4aa4ab)[_0x42fe('0x16')](_0x3e58e2+_0x42fe('0x39'),_0x1d0b2a)['where']('cm_contacts.createdAt\x20=\x20?',NOW)[_0x42fe('0x16')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x3e58e2,_0x15f770,_0x4aa4ab,'cm_hopper',[_0x42fe('0x3a'),_0x42fe('0x3b')]))[_0x42fe('0x16')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',selectNotIn(_0x3e58e2,_0x15f770,_0x4aa4ab,'cm_hopper',[_0x42fe('0x3a')])))[_0x42fe('0x3c')]();}function insertCmHopperBlack(_0x950efc,_0x320c3e,_0x59e92e,_0x8e533){var _0x4c924e=['cm_contacts.phone','cm_contacts.id',_0x42fe('0x26'),_0x320c3e+'.'+_0x8e533,_0x42fe('0x27'),_0x42fe('0x28')];return squel[_0x42fe('0x2b')]()[_0x42fe('0x2c')](_0x42fe('0x3d'))[_0x42fe('0x2e')]([_0x42fe('0x12'),'ContactId',_0x42fe('0x30'),_0x8e533,_0x42fe('0x31'),'updatedAt'],squel[_0x42fe('0x3e')]()['fields'](_0x4c924e)[_0x42fe('0x13')](_0x320c3e)[_0x42fe('0x14')](_0x42fe('0x35'),null,'cm_contacts.ListId\x20=\x20'+_0x320c3e+_0x42fe('0x37'))['join'](_0x59e92e,null,_0x59e92e+'.id\x20=\x20'+_0x320c3e+'.'+_0x8e533)[_0x42fe('0x16')](_0x320c3e+_0x42fe('0x39'),_0x950efc)[_0x42fe('0x16')](_0x42fe('0x3f'),NOW)[_0x42fe('0x16')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel['select']()[_0x42fe('0x40')](_0x42fe('0x12'))[_0x42fe('0x13')](_0x42fe('0x3d'))[_0x42fe('0x16')](_0x42fe('0x41'),_0x950efc)[_0x42fe('0x16')](_0x8e533+_0x42fe('0x15')+_0x320c3e+'.'+_0x8e533)))[_0x42fe('0x3c')]();}function insertTzCmHopper(_0xf5752d,_0xe4836f,_0x305bd2,_0x904461,_0x464e60,_0x1d0ee3){var _0xe850c0=[_0x42fe('0x24'),'date_add(cm_contacts.scheduledat,interval\x20'+_0x1d0ee3+'.offset-cm_contacts.utcOffset\x20minute)',_0x42fe('0x25'),_0x42fe('0x26'),_0xe4836f+'.'+_0x904461,'cm_contacts.createdAt',_0x42fe('0x28'),_0x42fe('0x29'),'cm_contacts.UserId','\x22'+_0x464e60+'\x22'];var _0x28ae28=squel[_0x42fe('0x2b')]()[_0x42fe('0x2c')](_0x42fe('0x2d'))[_0x42fe('0x2e')]([_0x42fe('0x12'),'scheduledat','ContactId','ListId',_0x904461,_0x42fe('0x31'),_0x42fe('0x42'),_0x42fe('0x32'),_0x42fe('0x33'),_0x42fe('0x43')],squel['select']()[_0x42fe('0x34')](_0xe850c0)[_0x42fe('0x13')](_0xe4836f)[_0x42fe('0x14')](_0x42fe('0x35'),null,_0x42fe('0x36')+_0xe4836f+_0x42fe('0x37'))[_0x42fe('0x14')](_0x305bd2,null,_0x305bd2+_0x42fe('0x38')+_0xe4836f+'.'+_0x904461)['join'](_0x1d0ee3,null,_0x1d0ee3+_0x42fe('0x38')+_0xe4836f+'.'+_0x904461)[_0x42fe('0x16')](_0xe4836f+_0x42fe('0x39'),_0xf5752d)[_0x42fe('0x16')](_0x42fe('0x3f'),NOW)['where'](_0x42fe('0x44'),selectNotIn(_0xe4836f,_0x305bd2,_0x904461,_0x42fe('0x2d'),[_0x42fe('0x3a'),_0x42fe('0x3b')]))[_0x42fe('0x16')](_0x42fe('0x44'),selectNotIn(_0xe4836f,_0x305bd2,_0x904461,'cm_hopper',['\x22always\x22'])))[_0x42fe('0x3c')]();return _0x28ae28;}function insertTzCmHopperBlack(_0x15facb,_0x374ae5,_0x18d55a,_0xeac0fe){var _0x12d685=[_0x42fe('0x24'),_0x42fe('0x25'),_0x42fe('0x26'),_0x374ae5+'.'+_0xeac0fe,'cm_contacts.createdAt',_0x42fe('0x28')];return squel[_0x42fe('0x2b')]()['into'](_0x42fe('0x3d'))['fromQuery']([_0x42fe('0x12'),_0x42fe('0x45'),_0x42fe('0x30'),_0xeac0fe,_0x42fe('0x31'),'updatedAt'],squel[_0x42fe('0x3e')]()[_0x42fe('0x34')](_0x12d685)[_0x42fe('0x13')](_0x374ae5)['join']('cm_contacts',null,_0x42fe('0x36')+_0x374ae5+'.CmListId')[_0x42fe('0x14')](_0x18d55a,null,_0x18d55a+_0x42fe('0x38')+_0x374ae5+'.'+_0xeac0fe)[_0x42fe('0x16')](_0x374ae5+_0x42fe('0x39'),_0x15facb)[_0x42fe('0x16')](_0x42fe('0x3f'),NOW)[_0x42fe('0x16')](_0x42fe('0x44'),squel[_0x42fe('0x3e')]()[_0x42fe('0x40')]('phone')['from'](_0x42fe('0x3d'))[_0x42fe('0x16')](_0x42fe('0x41'),_0x15facb)[_0x42fe('0x16')](_0xeac0fe+_0x42fe('0x15')+_0x374ae5+'.'+_0xeac0fe)))[_0x42fe('0x3c')]();}function insertCmHopperAdditionalPhones(_0x4fe052){var _0x564937=[_0x42fe('0x46'),_0x42fe('0x47'),_0x42fe('0x48'),_0x42fe('0x49'),_0x42fe('0x4a')];return squel[_0x42fe('0x2b')]()[_0x42fe('0x2c')](_0x42fe('0x4b'))['fromQuery']([_0x42fe('0x4c'),_0x42fe('0x12'),'OrderBy','createdAt',_0x42fe('0x42')],squel[_0x42fe('0x3e')]()[_0x42fe('0x34')](_0x564937)['from'](_0x42fe('0x2d'))[_0x42fe('0x14')](_0x42fe('0x35'),null,'cm_contacts.id\x20=\x20cm_hopper.ContactId')[_0x42fe('0x14')]('cm_contact_has_items',null,_0x42fe('0x4d'))[_0x42fe('0x16')](_0x42fe('0x4e'),_0x4fe052)['where']('cm_contacts.createdAt\x20=\x20?',NOW))[_0x42fe('0x3c')]();}function insertCmContact(_0x4e7330,_0x4745f1,_0x2ab288,_0x2ca36d){var _0xcd1101=_[_0x42fe('0x4f')](_[_0x42fe('0x50')](_0x2ca36d),['ListId',_0x42fe('0x51'),_0x42fe('0x31'),'updatedAt',_0x42fe('0x52')]);return squel[_0x42fe('0x2b')]()['into'](_0x42fe('0x35'))['fromQuery'](_0xcd1101,squel[_0x42fe('0x3e')]()['fields'](_0xcd1101)[_0x42fe('0x13')](_0x4745f1)['where']('('+_0x2ab288['join'](',')+_0x42fe('0x53'),squel[_0x42fe('0x3e')]()[_0x42fe('0x34')](_0x2ab288)[_0x42fe('0x13')](_0x42fe('0x35'))[_0x42fe('0x16')](_0x42fe('0x41'),_0x4e7330)[_0x42fe('0x16')](_0x42fe('0x54')))[_0x42fe('0x16')]('id\x20IN\x20?',squel['select']()[_0x42fe('0x40')](_0x42fe('0x55'),_0x42fe('0x56'))[_0x42fe('0x13')](_0x4745f1)[_0x42fe('0x57')](_0x2ab288[_0x42fe('0x14')](','))))['toString']();}function handleStop(){logger[_0x42fe('0x58')]('Received\x20SIGINT');stopped=!![];}function handleUncaughtException(_0x517962){logger[_0x42fe('0x59')](_0x517962[_0x42fe('0x5a')]);process[_0x42fe('0x5b')](0x1);}function handleError(_0x299aaf,_0x1ebe74){stats[_0x42fe('0x5c')]['push']({'name':_0x1ebe74[_0x42fe('0x5d')],'message':_0x1ebe74[_0x42fe('0x5a')],'row':_0x299aaf});}function handleQuery(_0x4056be){logger[_0x42fe('0x58')](_0x4056be);return db[_0x42fe('0x5e')][_0x42fe('0x5f')](_0x4056be)[_0x42fe('0x60')](function(_0xb7223f){results[_0x42fe('0x1c')](_0xb7223f);})[_0x42fe('0x61')](function(_0x1e0012){logger['error'](_0x1e0012['message']);});}function updateTzCampaigns(_0x29cf42){return new Promise(function(_0x1fbb24,_0x4c27a1){var _0x9faf97=squel['select']()['fields'](['campaigns.id',_0x42fe('0x62')])[_0x42fe('0x13')]('campaigns')[_0x42fe('0x14')](_0x42fe('0x63'),null,_0x42fe('0x64'))['where'](_0x42fe('0x65')+_0x29cf42);db[_0x42fe('0x5e')][_0x42fe('0x5f')](_0x9faf97[_0x42fe('0x3c')]())['spread'](function(_0x449bea){var _0x44a3ec=[];for(var _0x2314bc=0x0;_0x2314bc<_0x449bea[_0x42fe('0x1f')];_0x2314bc++){_0x44a3ec['push'](getTimezoneData(_0x449bea[_0x2314bc],tmp_campaigns));}BPromise[_0x42fe('0x1d')](_0x44a3ec)['then'](function(){_0x1fbb24({'val':0x1});});})[_0x42fe('0x61')](function(_0x2fcfbd){logger[_0x42fe('0x59')](_0x2fcfbd['message']);_0x1fbb24({'val':0x0});});});}function updateTzVoiceQueues(_0x17ca2c){return new Promise(function(_0x5e76cf,_0x358f8e){var _0x310062=squel['select']()[_0x42fe('0x34')]([_0x42fe('0x66'),_0x42fe('0x67')])[_0x42fe('0x13')](_0x42fe('0x68'))[_0x42fe('0x14')](_0x42fe('0x69'),null,_0x42fe('0x6a'))[_0x42fe('0x16')]('voice_queues_has_cm_lists.CmListId='+_0x17ca2c);db[_0x42fe('0x5e')][_0x42fe('0x5f')](_0x310062[_0x42fe('0x3c')]())[_0x42fe('0x60')](function(_0x52867f){var _0x162445=[];for(var _0x15d5e7=0x0;_0x15d5e7<_0x52867f[_0x42fe('0x1f')];_0x15d5e7++){_0x162445[_0x42fe('0x1c')](getTimezoneData(_0x52867f[_0x15d5e7],tmp_voice_queues));}BPromise['all'](_0x162445)[_0x42fe('0x1b')](function(){_0x5e76cf({'val':0x1});});})['catch'](function(_0x15c019){logger[_0x42fe('0x59')](_0x15c019[_0x42fe('0x5a')]);_0x5e76cf({'val':0x0});});});}function getTimezoneData(_0x27078c,_0x5d94a4){return new Promise(function(_0x20459e,_0x585e4c){var _0x1db4a9=shared[_0x42fe('0x6b')];var _0x3ed0a7=_0x1db4a9[_0x27078c[_0x42fe('0x6c')]];if(_[_0x42fe('0x6d')](_0x3ed0a7)){_0x20459e({'ret':0x1});}else{var _0x121e24=_0x3ed0a7[_0x42fe('0x6e')];var _0x2924e9=squel['insert']()[_0x42fe('0x2c')](_0x5d94a4)['set']('id',_0x27078c['id'])['set'](_0x42fe('0x6f'),_0x121e24)[_0x42fe('0x70')]('dialTimezone',_0x27078c[_0x42fe('0x6c')])[_0x42fe('0x3c')]();return db[_0x42fe('0x5e')][_0x42fe('0x5f')](_0x2924e9)['spread'](function(_0x350e46){_0x20459e({'ret':0x1});})[_0x42fe('0x61')](function(_0x2d207d){logger['error'](_0x2d207d[_0x42fe('0x5a')]);_0x585e4c({'ret':0x1});});}});}function handleTZQuery(_0x52e8da){logger[_0x42fe('0x58')](_0x52e8da);return db[_0x42fe('0x5e')][_0x42fe('0x5f')](_0x52e8da)[_0x42fe('0x60')](function(_0x428ea0){})[_0x42fe('0x61')](function(_0x3603e5){logger[_0x42fe('0x59')](_0x3603e5[_0x42fe('0x5a')]);});}function main(_0x274a40,_0x5d7e65,_0x348954,_0x117e18){logger['info'](_0x42fe('0x71'),_0x274a40,JSON['stringify'](_0x5d7e65));process[_0x42fe('0x72')](_0x42fe('0x73'));var _0x51f5fd=_0x5d7e65[_0x42fe('0x74')];var _0x265c82=_[_0x42fe('0x75')](_0x51f5fd);var _0x48470a=_0x5d7e65[_0x42fe('0x76')];var _0x1e030d=path[_0x42fe('0x14')](config[_0x42fe('0x77')],_0x42fe('0x78'),_0x48470a+'.csv');hasTZ=_['keys'](_0x51f5fd)[_0x42fe('0x79')](_0x42fe('0x6c'));var _0x5b5ca4=_[_0x42fe('0x50')](_0x51f5fd)[_0x42fe('0x14')]();logger[_0x42fe('0x58')](_0x42fe('0x7a'),_0x5b5ca4);db[_0x42fe('0x7b')][_0x42fe('0x19')]({'raw':!![],'attributes':['id','name']})['then'](function(_0x232e0f){for(var _0x454249=0x0;_0x454249<_0x232e0f[_0x42fe('0x1f')];_0x454249++){if(_0x232e0f[_0x454249][_0x42fe('0x7c')]in _0x51f5fd){contactItemTypes[_0x42fe('0x1c')](_0x232e0f[_0x454249]);delete _0x265c82[_0x232e0f[_0x454249][_0x42fe('0x7c')]];hasAdditionalPhones=!![];}for(var _0x452834 in _0x51f5fd){if(_0x232e0f[_0x454249][_0x42fe('0x7c')]+_0x42fe('0x7d')===_0x452834){phoneDescriptions[_0x42fe('0x1c')]({'itemTypeId':_0x232e0f[_0x454249]['id'],'description':_0x452834});delete _0x265c82[_0x452834];}}}if(hasAdditionalPhones)_0x265c82[_0x42fe('0x1a')]='';var _0x124c69=_[_0x42fe('0x50')](_0x265c82)[_0x42fe('0x14')]();logger['info'](_0x42fe('0x7a'),_0x124c69);fs[_0x42fe('0x7e')](_0x1e030d,_0x124c69+'\x0a');Papa[_0x42fe('0x7f')](fs[_0x42fe('0x80')](_0x274a40),{'header':!![],'skipEmptyLines':!![],'step':function(_0x247546,_0x4cb3f8){try{for(var _0x340aef=0x0,_0x3500af=[];_0x340aef<_0x247546[_0x42fe('0x81')]['length'];_0x340aef++){stats[_0x42fe('0x82')]+=0x1;if(_0x247546[_0x42fe('0x5c')][_0x340aef]){handleError(_0x247546[_0x42fe('0x81')][_0x340aef],_0x247546['errors'][_0x340aef]);}else{var _0x458ad2=[];var _0x154ffe=[];var _0x235558={};for(var _0x1aa4d0 in _0x51f5fd){let _0x4bf134=contactItemTypes[_0x42fe('0x83')](_0x5cab02=>_0x5cab02[_0x42fe('0x7c')]===_0x1aa4d0);let _0x12a8e3=contactItemTypes['find'](_0x2465bd=>_0x2465bd[_0x42fe('0x7c')]+_0x42fe('0x7d')===_0x1aa4d0);if(_[_0x42fe('0x6d')](_0x4bf134)&&_['isNil'](_0x12a8e3)){if(_0x51f5fd[_0x42fe('0x84')](_0x1aa4d0)){if(_0x247546['data'][_0x340aef][_0x51f5fd[_0x1aa4d0]]){var _0xd06078=_[_0x42fe('0x85')](_0x247546[_0x42fe('0x81')][_0x340aef][_0x51f5fd[_0x1aa4d0]][_0x42fe('0x86')](/"/g,'\x27'));switch(_0x1aa4d0){case _0x42fe('0x2f'):var _0x4edf99=moment(_0xd06078,_0x42fe('0x10'),!![]);if(_0x4edf99[_0x42fe('0x87')]()){_0x3500af[_0x42fe('0x1c')]('\x22'+_0xd06078+'\x22');}else{_0x458ad2[_0x42fe('0x1c')](_0x42fe('0x88'));}break;case'priority':var _0x10e0f8=parseInt(_0xd06078);_0xd06078=_['isNaN'](_0x10e0f8)||_0x10e0f8<0x0||_0x10e0f8>0x4?_0x117e18?0x3:0x2:_0x10e0f8;_0x3500af['push']('\x22'+_0xd06078+'\x22');break;case _0x42fe('0x33'):var _0x2b173e=parseInt(_0xd06078);if(_['isNumber'](_0x2b173e)&&_[_0x42fe('0x79')](_0x348954,_0x2b173e)){_0x3500af[_0x42fe('0x1c')]('\x22'+_0x2b173e+'\x22');}else{_0x458ad2[_0x42fe('0x1c')](_0x42fe('0x89'));}break;case _0x42fe('0x8a'):if(isEmail(_0xd06078)){_0x3500af[_0x42fe('0x1c')]('\x22'+_0xd06078+'\x22');}else{_0x458ad2[_0x42fe('0x1c')]('email\x20wrong\x20format');}break;case'dateOfBirth':var _0x3011c1=moment(_0xd06078,_0x42fe('0x8b'),!![]);if(_0x3011c1[_0x42fe('0x87')]()){_0x3500af['push']('\x22'+_0xd06078+'\x22');}else{_0x458ad2[_0x42fe('0x1c')](_0x42fe('0x8c'));}break;case _0x42fe('0x6c'):var _0xb163e8=shared[_0x42fe('0x6b')];var _0x4676e3=_0xb163e8[_0xd06078];if(!_['isNil'](_0x4676e3)){var _0x38b6be=_0x4676e3[_0x42fe('0x6e')];_0x3500af[_0x42fe('0x1c')]('\x22'+_0xd06078+'\x22');_0x3500af[_0x42fe('0x1c')]('\x22'+_0x38b6be+'\x22');}break;default:_0x3500af['push']('\x22'+_0xd06078+'\x22');}}else{switch(_0x1aa4d0){case'firstName':case _0x42fe('0x12'):_0x458ad2['push'](_0x1aa4d0+_0x42fe('0x8d'));break;default:_0x3500af[_0x42fe('0x1c')]('\x22\x22');}}}}else{var _0x450273='';if(!_[_0x42fe('0x6d')](_0x4bf134)){if(!_0x235558['hasOwnProperty'](_0x4bf134['id'])){if(!_['isNil'](_0x247546[_0x42fe('0x81')][_0x340aef][_0x51f5fd[_0x1aa4d0]])){var _0xd06078=_['trim'](_0x247546[_0x42fe('0x81')][_0x340aef][_0x51f5fd[_0x1aa4d0]][_0x42fe('0x86')](/"/g,'\x27'));var _0x20ebe2=phoneDescriptions[_0x42fe('0x83')](_0x5e8e08=>_0x5e8e08[_0x42fe('0x8e')]===_0x4bf134['id']);if(!_['isNil'](_0x20ebe2)){var _0x3de35e=_[_0x42fe('0x85')](_0x247546[_0x42fe('0x81')][_0x340aef][_0x51f5fd[_0x20ebe2[_0x42fe('0x8f')]]][_0x42fe('0x86')](/"/g,'\x27'));if(!_[_0x42fe('0x6d')](_0x3de35e))_0xd06078=_0xd06078+'§'+_0x3de35e;}if(_0x450273=='')_0x450273=_0xd06078;else _0x450273+='|'+_0xd06078;}_0x154ffe['push'](_0x4bf134['id']+':'+_0x450273);_0x235558[_0x4bf134['id']]=0x1;}}}}if(hasAdditionalPhones){_0x3500af['push']('\x22'+_0x154ffe['join'](';')+'\x22');}if(_0x458ad2[_0x42fe('0x1f')]){handleError(_0x247546[_0x42fe('0x81')][_0x340aef],{'code':_0x42fe('0x90'),'message':_0x458ad2[_0x42fe('0x14')]()});}else{fs[_0x42fe('0x91')](_0x1e030d,_0x3500af[_0x42fe('0x14')]()+'\x0a');}_0x3500af=[];}if(!(stats[_0x42fe('0x82')]%0xc8)){socket[_0x42fe('0x92')](_0x42fe('0x93')+_0x48470a,stats);stats[_0x42fe('0x5c')]=[];}}if(stopped){logger['info'](_0x42fe('0x94'));_0x4cb3f8['abort']();}}catch(_0x4a9567){handleError(_0x247546[_0x42fe('0x81')][_0x340aef],{'code':_0x42fe('0x95'),'message':_0x4a9567[_0x42fe('0x5a')]});logger[_0x42fe('0x59')](_0x42fe('0x96'),_0x4a9567[_0x42fe('0x5a')]);}},'complete':function(){try{var _0x54e068=[];var _0x197426=[];var _0x2afae5=_0x42fe('0x35');if(_0x5d7e65['duplicates']&&_0x5d7e65[_0x42fe('0x97')][_0x42fe('0x1f')]){_0x2afae5=_0x42fe('0x98')+_0x48470a;_0x54e068[_0x42fe('0x1c')](_0x42fe('0x99')+_0x2afae5+_0x42fe('0x9a'));}tmp_campaigns='campaigns_'+_0x48470a;tmp_voice_queues='voice_queues_'+_0x48470a;_0x197426['push'](_0x42fe('0x99')+tmp_campaigns+'(id\x20int,dialTimezone\x20varchar(255),offset\x20int);');_0x197426['push'](_0x42fe('0x99')+tmp_voice_queues+_0x42fe('0x9b'));BPromise[_0x42fe('0x9c')](_0x197426,handleTZQuery)[_0x42fe('0x1b')](function(_0x2ec4df){updateTzCampaigns(_0x5d7e65['ListId'])[_0x42fe('0x1b')](function(_0xc788ca){updateTzVoiceQueues(_0x5d7e65[_0x42fe('0x30')])[_0x42fe('0x1b')](function(_0x30469d){if(hasTZ)_0x124c69=_0x124c69['replace']('dialTimezone','dialTimezone,utcOffset');var _0x11ed7d=util[_0x42fe('0xf')]('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',_0x1e030d,_0x2afae5,_0x124c69,_0x5d7e65[_0x42fe('0x30')],_0x5d7e65['CompanyId']||null,NOW,NOW);if(_['isNil'](_0x51f5fd[_0x42fe('0x2f')])){_0x11ed7d+=_0x42fe('0x9d');}_0x54e068[_0x42fe('0x1c')](_0x11ed7d);if(_0x5d7e65[_0x42fe('0x97')]&&_0x5d7e65[_0x42fe('0x97')]['length']){_0x54e068['push'](insertCmContact(_0x5d7e65[_0x42fe('0x30')],_0x2afae5,_0x5d7e65[_0x42fe('0x97')],_0x51f5fd));_0x54e068[_0x42fe('0x1c')](_0x42fe('0x9e')+_0x2afae5+';');}BPromise['each'](_0x54e068,handleQuery)['then'](function(_0x26fe75){BPromise['all']([handleAdditionalPhones()])['then'](function(){_0x54e068=[];for(var _0x5897a7=0x0;_0x5897a7<promisesAdditionalPhones[_0x42fe('0x1f')];_0x5897a7++){if(promisesAdditionalPhones[_0x5897a7]['phone']!='§'){_0x54e068[_0x42fe('0x1c')](createAdditionalPhone(promisesAdditionalPhones[_0x5897a7][_0x42fe('0x9f')],promisesAdditionalPhones[_0x5897a7]['contactTypeId'],promisesAdditionalPhones[_0x5897a7][_0x42fe('0x12')],promisesAdditionalPhones[_0x5897a7][_0x42fe('0xa0')]));}}BPromise['all'](_0x54e068)[_0x42fe('0x1b')](function(){_0x54e068=[];if(hasTZ){_0x54e068[_0x42fe('0x1c')](insertTzCmHopper(_0x5d7e65[_0x42fe('0x30')],_0x42fe('0x69'),_0x42fe('0x68'),'VoiceQueueId',_0x117e18,tmp_voice_queues));_0x54e068[_0x42fe('0x1c')](insertTzCmHopperBlack(_0x5d7e65[_0x42fe('0x30')],'voice_queues_has_cm_blacklists',_0x42fe('0x68'),'VoiceQueueId'));_0x54e068[_0x42fe('0x1c')](insertTzCmHopper(_0x5d7e65[_0x42fe('0x30')],'campaigns_has_cm_lists',_0x42fe('0xa1'),_0x42fe('0xa2'),_0x117e18,tmp_campaigns));_0x54e068[_0x42fe('0x1c')](insertTzCmHopperBlack(_0x5d7e65['ListId'],'campaigns_has_cm_blacklists','campaigns','CampaignId'));_0x54e068[_0x42fe('0x1c')](insertCmHopperAdditionalPhones(_0x5d7e65[_0x42fe('0x30')]));}else{_0x54e068[_0x42fe('0x1c')](insertCmHopper(_0x5d7e65[_0x42fe('0x30')],_0x42fe('0x69'),_0x42fe('0x68'),_0x42fe('0xa3'),_0x117e18));_0x54e068['push'](insertCmHopperBlack(_0x5d7e65['ListId'],_0x42fe('0xa4'),_0x42fe('0x68'),_0x42fe('0xa3')));_0x54e068['push'](insertCmHopper(_0x5d7e65[_0x42fe('0x30')],_0x42fe('0x63'),_0x42fe('0xa1'),'CampaignId',_0x117e18));_0x54e068['push'](insertCmHopperBlack(_0x5d7e65[_0x42fe('0x30')],_0x42fe('0xa5'),_0x42fe('0xa1'),_0x42fe('0xa2')));_0x54e068[_0x42fe('0x1c')](insertCmHopperAdditionalPhones(_0x5d7e65[_0x42fe('0x30')]));}_0x54e068[_0x42fe('0x1c')](_0x42fe('0x9e')+tmp_campaigns+';');_0x54e068[_0x42fe('0x1c')](_0x42fe('0x9e')+tmp_voice_queues+';');BPromise[_0x42fe('0x9c')](_0x54e068,handleQuery)['then'](function(_0xcb3e5f){stats[_0x42fe('0xa6')]=!![];stats[_0x42fe('0xa7')]=_0x5d7e65[_0x42fe('0x97')]&&_0x5d7e65['duplicates'][_0x42fe('0x1f')]?results[0x2][_0x42fe('0xa7')]:results[0x0][_0x42fe('0xa7')];socket[_0x42fe('0x92')](_0x42fe('0x93')+_0x48470a,stats);fs[_0x42fe('0xa8')](_0x274a40);fs[_0x42fe('0xa8')](_0x1e030d);process[_0x42fe('0x5b')](0x0);})[_0x42fe('0x61')](function(_0x2826ed){logger[_0x42fe('0x59')](_0x2826ed[_0x42fe('0x5a')]);process['exit'](0x1);});});});})[_0x42fe('0x61')](function(_0x549853){logger[_0x42fe('0x59')](_0x549853[_0x42fe('0x5a')]);process[_0x42fe('0x5b')](0x1);});});});});}catch(_0x38ba5b){logger['error']('complete',_0x38ba5b['message']);process[_0x42fe('0x5b')](0x1);}},'error':function(_0x137c35,_0x1fe6ef,_0x3dab9d,_0x54d22d){throw new Error(_0x54d22d);}});});}function validate(){if(process[_0x42fe('0xa9')]&&process[_0x42fe('0xa9')][_0x42fe('0x1f')]<0x4){throw new Error(_0x42fe('0xaa'));}var _0xa6686e=path[_0x42fe('0x14')](config[_0x42fe('0x77')],_0x42fe('0x78'),process[_0x42fe('0xa9')][0x2]);if(!fs[_0x42fe('0xab')](_0xa6686e)){throw new Error(_0x42fe('0xac'));}var _0x952d71={};try{_0x952d71=JSON[_0x42fe('0x7f')](process['argv'][0x3]);if(!_0x952d71[_0x42fe('0x74')]){throw new Error(_0x42fe('0xad'));}if(!_0x952d71[_0x42fe('0x74')][_0x42fe('0x12')]){throw new Error(_0x42fe('0xae'));}if(!_0x952d71['binding'][_0x42fe('0xaf')]){throw new Error('firstName\x20is\x20mandatory');}var _0x1c0bd4=0x0;if(_0x952d71[_0x42fe('0x74')]['UserId']){_0x1c0bd4=0x1;}if(!_0x952d71[_0x42fe('0x30')]){throw new Error('ListId\x20is\x20mandatory');}}catch(_0x1a293f){throw new Error(_0x42fe('0xb0'));}var _0x446f08=[];try{_0x446f08=_['map'](JSON[_0x42fe('0x7f')](process[_0x42fe('0xa9')][0x4]),'id');}catch(_0x38ce85){logger[_0x42fe('0x58')](_0x42fe('0xb1'));}main(_0xa6686e,_0x952d71,_0x446f08,_0x1c0bd4);}validate();process['on']('SIGINT',handleStop);process['on'](_0x42fe('0xb2'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff