// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1d1e=['YYYY-MM-DD\x20HH:mm:ss','test','select','field','phone','from','join','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','CmContact','findAll','AdditionalPhones','then','length','all','split','filter','push','CmContactHasItem','findOne','update','updated','PHONE','inserted','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.createdAt','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','insert','into','cm_hopper','scheduledat','ContactId','ListId','createdAt','updatedAt','priority','UserId','recallme','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','.id\x20=\x20','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22always\x22','\x22onlyIfOpen\x22','toString','cm_contacts.ListId','cm_hopper_black','fromQuery','.CmListId\x20=\x20?','ListId\x20=\x20?','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','CmHopperId','OrderBy','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contact_has_items','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','concat','keys',')\x20NOT\x20IN\x20?','MIN(id)','min_id','group','info','Received\x20SIGINT','error','message','errors','sequelize','spread','catch','main','stringify','start','binding','clone','socket_timestamp','root','server/files/tmp','.csv','body','name','header','writeFileSync','parse','createReadStream','data','find','isNil','hasOwnProperty','replace','isValid','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)','firstName','\x20not\x20specified','trim','SystemRow','appendFileSync','contact:import:','Abort\x20parser','abort','SystemError','step','duplicates','cm_contacts_','\x20LIKE\x20cm_contacts;','CIS\x20len',',\x20scheduledAt\x20=\x20NOW()','DROP\x20TABLE\x20','each','contactId','contactTypeId','orderBy','voice_queues','VoiceQueueId','voice_queues_has_cm_blacklists','campaigns_has_cm_lists','campaigns','campaigns_has_cm_blacklists','CampaignId','finish','affectedRows','emit','unlink','exit','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','firstName\x20is\x20mandatory','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','No\x20agent\x20available','SIGINT','uncaughtException','path','lodash','papaparse','util','bluebird','moment','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','import','redis','defaults','localhost','socket.io-emitter','format'];(function(_0x317bf0,_0x277c03){var _0x225932=function(_0x2c280e){while(--_0x2c280e){_0x317bf0['push'](_0x317bf0['shift']());}};_0x225932(++_0x277c03);}(_0x1d1e,0x9a));var _0xe1d1=function(_0x21205e,_0x7eb8e7){_0x21205e=_0x21205e-0x0;var _0x136ebb=_0x1d1e[_0x21205e];return _0x136ebb;};'use strict';var fs=require('fs');var path=require(_0xe1d1('0x0'));var _=require(_0xe1d1('0x1'));var Papa=require(_0xe1d1('0x2'));var util=require(_0xe1d1('0x3'));var BPromise=require(_0xe1d1('0x4'));var moment=require(_0xe1d1('0x5'));var squel=require('squel');var Redis=require(_0xe1d1('0x6'));var db=require(_0xe1d1('0x7'))['db'];var config=require(_0xe1d1('0x8'));var logger=require(_0xe1d1('0x9'))(_0xe1d1('0xa'));config[_0xe1d1('0xb')]=_[_0xe1d1('0xc')](config['redis'],{'host':_0xe1d1('0xd'),'port':0x18eb});var socket=require(_0xe1d1('0xe'))(new Redis(config[_0xe1d1('0xb')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()[_0xe1d1('0xf')](_0xe1d1('0x10'));var contactItemTypes=[];var hasAdditionalPhones=![];function isEmail(_0x2690d5){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))*$/[_0xe1d1('0x11')](_0x2690d5);}function selectNotIn(_0x2dabc0,_0x393058,_0x4f614d,_0x598b20,_0x2066e6){return squel[_0xe1d1('0x12')]()[_0xe1d1('0x13')](_0xe1d1('0x14'))[_0xe1d1('0x15')](_0x598b20)[_0xe1d1('0x16')](_0x393058,null,_0x393058+'.id\x20=\x20'+_0x598b20+'.'+_0x4f614d)['where'](_0x598b20+'.'+_0x4f614d+_0xe1d1('0x17')+_0x2dabc0+'.'+_0x4f614d)[_0xe1d1('0x18')](_0x393058+_0xe1d1('0x19')+_0x2066e6[_0xe1d1('0x16')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x176214,_0x252cd0){promisesAdditionalPhones=[];return db[_0xe1d1('0x1a')][_0xe1d1('0x1b')]({'raw':!![],'attributes':['id',_0xe1d1('0x1c')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})[_0xe1d1('0x1d')](function(_0x1826a7){if(_0x1826a7!==null){var _0x2c193f=[];for(var _0xab253b=0x0;_0xab253b<_0x1826a7[_0xe1d1('0x1e')];_0xab253b++){var _0x16db6c=_0x1826a7[_0xab253b];_0x2c193f['push'](insertAdditionalPhones(_0x16db6c));}}Promise[_0xe1d1('0x1f')](_0x2c193f)[_0xe1d1('0x1d')](function(){_0x176214({'val':0x1});});});});}function insertAdditionalPhones(_0x2fe357){return new Promise(function(_0x470805,_0x3fd4e7){var _0x5914fa=_0x2fe357[_0xe1d1('0x1c')];var _0x3046a9=_0x5914fa[_0xe1d1('0x20')](';');var _0x5a77b7=[];orderBy=0x0;for(var _0x10b584=0x0;_0x10b584<_0x3046a9[_0xe1d1('0x1e')];_0x10b584++){_0x5a77b7['push'](splitAdditionalPhone(_0x2fe357['id'],_0x3046a9[_0x10b584]));}Promise[_0xe1d1('0x1f')](_0x5a77b7)[_0xe1d1('0x1d')](function(){_0x470805({'val':_0x3046a9['length']});});});}function splitAdditionalPhone(_0xe575bc,_0x276440){return new Promise(function(_0x164af3,_0x25a263){var _0x34b925=_0x276440['split'](':');var _0x9ff9f0=_0x34b925[0x0];var _0x4929b0=_0x34b925[0x1];if(_0x4929b0!==''){var _0x5e39d2=_0x4929b0['split']('|');var _0x16c63e=[];for(var _0x57cc2c=0x0;_0x57cc2c<_0x5e39d2['length'];_0x57cc2c++){if(_0x5e39d2[_0x57cc2c]!==''){var _0x4193c8=_[_0xe1d1('0x21')](promisesAdditionalPhones,{'contactId':_0xe575bc,'phone':_0x5e39d2[_0x57cc2c]});if(_0x4193c8[_0xe1d1('0x1e')]==0x0){orderBy++;promisesAdditionalPhones[_0xe1d1('0x22')]({'contactId':_0xe575bc,'contactTypeId':_0x9ff9f0,'phone':_0x5e39d2[_0x57cc2c],'orderBy':orderBy});}}}_0x164af3({'ok':0x1});}else _0x164af3({'res':0x0});});}function createAdditionalPhone(_0x267d89,_0x35af6c,_0x45eb05,_0x1836b6){return new Promise(function(_0x1f591d,_0x2b3515){return db[_0xe1d1('0x23')][_0xe1d1('0x24')]({'where':{'CmContactId':_0x267d89,'item':_0x45eb05}})[_0xe1d1('0x1d')](function(_0x2a6fc4){if(_0x2a6fc4){return db[_0xe1d1('0x23')][_0xe1d1('0x25')]({'ItemTypeId':_0x35af6c,'OrderBy':_0x1836b6},{'where':{'CmContactId':_0x267d89,'item':_0x45eb05}})[_0xe1d1('0x1d')](function(_0x4973bd){_0x1f591d({'res':_0xe1d1('0x26')});});}else{return db['CmContactHasItem']['create']({'CmContactId':_0x267d89,'item':_0x45eb05,'ItemTypeId':_0x35af6c,'OrderBy':_0x1836b6,'ItemClass':_0xe1d1('0x27')})['then'](function(_0x25f7dc){_0x1f591d({'res':_0xe1d1('0x28')});});}});});}function insertCmHopper(_0xc82587,_0x494f0b,_0x17577c,_0xe76e77,_0x45547f){var _0x5d01ba=[_0xe1d1('0x29'),_0xe1d1('0x2a'),_0xe1d1('0x2b'),'cm_contacts.ListId',_0x494f0b+'.'+_0xe76e77,_0xe1d1('0x2c'),_0xe1d1('0x2d'),_0xe1d1('0x2e'),_0xe1d1('0x2f'),'\x22'+_0x45547f+'\x22'];return squel[_0xe1d1('0x30')]()[_0xe1d1('0x31')](_0xe1d1('0x32'))['fromQuery']([_0xe1d1('0x14'),_0xe1d1('0x33'),_0xe1d1('0x34'),_0xe1d1('0x35'),_0xe76e77,_0xe1d1('0x36'),_0xe1d1('0x37'),_0xe1d1('0x38'),_0xe1d1('0x39'),_0xe1d1('0x3a')],squel['select']()[_0xe1d1('0x3b')](_0x5d01ba)[_0xe1d1('0x15')](_0x494f0b)[_0xe1d1('0x16')](_0xe1d1('0x3c'),null,_0xe1d1('0x3d')+_0x494f0b+_0xe1d1('0x3e'))[_0xe1d1('0x16')](_0x17577c,null,_0x17577c+_0xe1d1('0x3f')+_0x494f0b+'.'+_0xe76e77)[_0xe1d1('0x18')](_0x494f0b+'.CmListId\x20=\x20?',_0xc82587)['where'](_0xe1d1('0x40'),NOW)[_0xe1d1('0x18')](_0xe1d1('0x41'),selectNotIn(_0x494f0b,_0x17577c,_0xe76e77,_0xe1d1('0x32'),[_0xe1d1('0x42'),_0xe1d1('0x43')]))[_0xe1d1('0x18')](_0xe1d1('0x41'),selectNotIn(_0x494f0b,_0x17577c,_0xe76e77,_0xe1d1('0x32'),[_0xe1d1('0x42')])))[_0xe1d1('0x44')]();}function insertCmHopperBlack(_0x47614d,_0x33eaba,_0x48a5f7,_0xce84){var _0x2aa308=[_0xe1d1('0x29'),_0xe1d1('0x2b'),_0xe1d1('0x45'),_0x33eaba+'.'+_0xce84,_0xe1d1('0x2c'),'cm_contacts.updatedAt'];return squel[_0xe1d1('0x30')]()[_0xe1d1('0x31')](_0xe1d1('0x46'))[_0xe1d1('0x47')](['phone',_0xe1d1('0x34'),_0xe1d1('0x35'),_0xce84,_0xe1d1('0x36'),_0xe1d1('0x37')],squel['select']()[_0xe1d1('0x3b')](_0x2aa308)[_0xe1d1('0x15')](_0x33eaba)[_0xe1d1('0x16')]('cm_contacts',null,_0xe1d1('0x3d')+_0x33eaba+_0xe1d1('0x3e'))['join'](_0x48a5f7,null,_0x48a5f7+_0xe1d1('0x3f')+_0x33eaba+'.'+_0xce84)[_0xe1d1('0x18')](_0x33eaba+_0xe1d1('0x48'),_0x47614d)[_0xe1d1('0x18')](_0xe1d1('0x40'),NOW)[_0xe1d1('0x18')](_0xe1d1('0x41'),squel[_0xe1d1('0x12')]()[_0xe1d1('0x13')](_0xe1d1('0x14'))['from'](_0xe1d1('0x46'))[_0xe1d1('0x18')](_0xe1d1('0x49'),_0x47614d)[_0xe1d1('0x18')](_0xce84+'\x20=\x20?',_0x33eaba+'.'+_0xce84)))[_0xe1d1('0x44')]();}function insertCmHopperAdditionalPhones(_0xe9a59a){var _0x4f0e6e=['cm_hopper.id',_0xe1d1('0x4a'),_0xe1d1('0x4b'),_0xe1d1('0x4c'),_0xe1d1('0x4d')];return squel[_0xe1d1('0x30')]()[_0xe1d1('0x31')](_0xe1d1('0x4e'))[_0xe1d1('0x47')]([_0xe1d1('0x4f'),_0xe1d1('0x14'),_0xe1d1('0x50'),_0xe1d1('0x36'),'updatedAt'],squel[_0xe1d1('0x12')]()[_0xe1d1('0x3b')](_0x4f0e6e)[_0xe1d1('0x15')]('cm_hopper')[_0xe1d1('0x16')](_0xe1d1('0x3c'),null,_0xe1d1('0x51'))['join'](_0xe1d1('0x52'),null,_0xe1d1('0x53'))[_0xe1d1('0x18')]('cm_hopper.ListId\x20=\x20?',_0xe9a59a)[_0xe1d1('0x18')](_0xe1d1('0x40'),NOW))[_0xe1d1('0x44')]();}function insertCmContact(_0x293dc6,_0x2b0f3f,_0x3f5adc,_0x1246ac){var _0xb17667=_[_0xe1d1('0x54')](_[_0xe1d1('0x55')](_0x1246ac),[_0xe1d1('0x35'),'CompanyId',_0xe1d1('0x36'),_0xe1d1('0x37')]);return squel[_0xe1d1('0x30')]()[_0xe1d1('0x31')]('cm_contacts')['fromQuery'](_0xb17667,squel['select']()[_0xe1d1('0x3b')](_0xb17667)[_0xe1d1('0x15')](_0x2b0f3f)[_0xe1d1('0x18')]('('+_0x3f5adc[_0xe1d1('0x16')](',')+_0xe1d1('0x56'),squel[_0xe1d1('0x12')]()['fields'](_0x3f5adc)[_0xe1d1('0x15')](_0xe1d1('0x3c'))['where']('ListId\x20=\x20?',_0x293dc6)[_0xe1d1('0x18')]('deletedAt\x20IS\x20NULL'))[_0xe1d1('0x18')]('id\x20IN\x20?',squel[_0xe1d1('0x12')]()['field'](_0xe1d1('0x57'),_0xe1d1('0x58'))[_0xe1d1('0x15')](_0x2b0f3f)[_0xe1d1('0x59')](_0x3f5adc[_0xe1d1('0x16')](','))))['toString']();}function handleStop(){logger[_0xe1d1('0x5a')](_0xe1d1('0x5b'));stopped=!![];}function handleUncaughtException(_0x22609a){logger[_0xe1d1('0x5c')](_0x22609a[_0xe1d1('0x5d')]);process['exit'](0x1);}function handleError(_0x1f3da6,_0x37645b){stats[_0xe1d1('0x5e')][_0xe1d1('0x22')]({'name':_0x37645b['code'],'message':_0x37645b[_0xe1d1('0x5d')],'row':_0x1f3da6});}function handleQuery(_0x588bdb){logger[_0xe1d1('0x5a')](_0x588bdb);return db[_0xe1d1('0x5f')]['query'](_0x588bdb)[_0xe1d1('0x60')](function(_0x1c6fa7){results[_0xe1d1('0x22')](_0x1c6fa7);})[_0xe1d1('0x61')](function(_0x4e0944){logger[_0xe1d1('0x5c')](_0x4e0944[_0xe1d1('0x5d')]);});}function main(_0x4a17dd,_0x1132c2,_0x4fb55e,_0x361d27){logger[_0xe1d1('0x5a')](_0xe1d1('0x62'),_0x4a17dd,JSON[_0xe1d1('0x63')](_0x1132c2));process['send'](_0xe1d1('0x64'));var _0x2772f6=_0x1132c2[_0xe1d1('0x65')];var _0x3e234b=_[_0xe1d1('0x66')](_0x2772f6);var _0xcaec55=_0x1132c2[_0xe1d1('0x67')];var _0x54d778=path[_0xe1d1('0x16')](config[_0xe1d1('0x68')],_0xe1d1('0x69'),_0xcaec55+_0xe1d1('0x6a'));logger['info'](_0xe1d1('0x6b'),_0x1132c2);db['ContactItemType'][_0xe1d1('0x1b')]({'raw':!![],'attributes':['id',_0xe1d1('0x6c')]})[_0xe1d1('0x1d')](function(_0x9023f1){for(var _0x3b5ddc=0x0;_0x3b5ddc<_0x9023f1['length'];_0x3b5ddc++){if(_0x9023f1[_0x3b5ddc][_0xe1d1('0x6c')]in _0x2772f6){contactItemTypes[_0xe1d1('0x22')](_0x9023f1[_0x3b5ddc]);delete _0x3e234b[_0x9023f1[_0x3b5ddc]['name']];hasAdditionalPhones=!![];}else{}}if(hasAdditionalPhones)_0x3e234b[_0xe1d1('0x1c')]='';var _0x4811f5=_[_0xe1d1('0x55')](_0x3e234b)[_0xe1d1('0x16')]();logger[_0xe1d1('0x5a')](_0xe1d1('0x6d'),_0x4811f5);fs[_0xe1d1('0x6e')](_0x54d778,_0x4811f5+'\x0a');Papa[_0xe1d1('0x6f')](fs[_0xe1d1('0x70')](_0x4a17dd),{'header':!![],'skipEmptyLines':!![],'step':function(_0x13e9b8,_0x232a4b){try{for(var _0x47e969=0x0,_0x17b3d6=[];_0x47e969<_0x13e9b8['data'][_0xe1d1('0x1e')];_0x47e969++){stats['rows']+=0x1;if(_0x13e9b8['errors'][_0x47e969]){handleError(_0x13e9b8[_0xe1d1('0x71')][_0x47e969],_0x13e9b8[_0xe1d1('0x5e')][_0x47e969]);}else{var _0x59120e=[];var _0x580c14=[];for(var _0x203982 in _0x2772f6){let _0x5e7727=contactItemTypes[_0xe1d1('0x72')](_0x57df3e=>_0x57df3e['name']===_0x203982);if(_[_0xe1d1('0x73')](_0x5e7727)){if(_0x2772f6[_0xe1d1('0x74')](_0x203982)){if(_0x13e9b8['data'][_0x47e969][_0x2772f6[_0x203982]]){var _0x4698b8=_['trim'](_0x13e9b8['data'][_0x47e969][_0x2772f6[_0x203982]][_0xe1d1('0x75')](/"/g,'\x27'));switch(_0x203982){case _0xe1d1('0x33'):var _0x18ce08=moment(_0x4698b8,_0xe1d1('0x10'),!![]);if(_0x18ce08[_0xe1d1('0x76')]()){_0x17b3d6[_0xe1d1('0x22')]('\x22'+_0x4698b8+'\x22');}else{_0x59120e[_0xe1d1('0x22')](_0xe1d1('0x77'));}break;case _0xe1d1('0x38'):var _0x28590c=parseInt(_0x4698b8);_0x4698b8=_[_0xe1d1('0x78')](_0x28590c)||_0x28590c<0x0||_0x28590c>0x4?_0x361d27?0x3:0x2:_0x28590c;_0x17b3d6[_0xe1d1('0x22')]('\x22'+_0x4698b8+'\x22');break;case _0xe1d1('0x39'):var _0x23b985=parseInt(_0x4698b8);if(_[_0xe1d1('0x79')](_0x23b985)&&_['includes'](_0x4fb55e,_0x23b985)){_0x17b3d6[_0xe1d1('0x22')]('\x22'+_0x23b985+'\x22');}else{_0x59120e[_0xe1d1('0x22')]('agent\x20not\x20exists');}break;case _0xe1d1('0x7a'):if(isEmail(_0x4698b8)){_0x17b3d6[_0xe1d1('0x22')]('\x22'+_0x4698b8+'\x22');}else{_0x59120e[_0xe1d1('0x22')](_0xe1d1('0x7b'));}break;case _0xe1d1('0x7c'):var _0x5d6296=moment(_0x4698b8,_0xe1d1('0x7d'),!![]);if(_0x5d6296['isValid']()){_0x17b3d6[_0xe1d1('0x22')]('\x22'+_0x4698b8+'\x22');}else{_0x59120e['push'](_0xe1d1('0x7e'));}break;default:_0x17b3d6[_0xe1d1('0x22')]('\x22'+_0x4698b8+'\x22');}}else{switch(_0x203982){case _0xe1d1('0x7f'):case _0xe1d1('0x14'):_0x59120e[_0xe1d1('0x22')](_0x203982+_0xe1d1('0x80'));break;default:_0x17b3d6[_0xe1d1('0x22')]('\x22\x22');}}}}else{var _0x2bfd75='';for(var _0x370c48=0x0;_0x370c48<_0x2772f6[_0x203982][_0xe1d1('0x1e')];_0x370c48++){var _0x4698b8=_[_0xe1d1('0x81')](_0x13e9b8[_0xe1d1('0x71')][_0x47e969][_0x2772f6[_0x203982][_0x370c48]][_0xe1d1('0x75')](/"/g,'\x27'));if(_0x2bfd75=='')_0x2bfd75=_0x4698b8;else _0x2bfd75+='|'+_0x4698b8;}_0x580c14['push'](_0x5e7727['id']+':'+_0x2bfd75);}}if(hasAdditionalPhones){_0x17b3d6[_0xe1d1('0x22')]('\x22'+_0x580c14[_0xe1d1('0x16')](';')+'\x22');}if(_0x59120e[_0xe1d1('0x1e')]){handleError(_0x13e9b8['data'][_0x47e969],{'code':_0xe1d1('0x82'),'message':_0x59120e[_0xe1d1('0x16')]()});}else{fs[_0xe1d1('0x83')](_0x54d778,_0x17b3d6['join']()+'\x0a');}_0x17b3d6=[];}if(!(stats['rows']%0xc8)){socket['emit'](_0xe1d1('0x84')+_0xcaec55,stats);stats[_0xe1d1('0x5e')]=[];}}if(stopped){logger[_0xe1d1('0x5a')](_0xe1d1('0x85'));_0x232a4b[_0xe1d1('0x86')]();}}catch(_0x20a291){handleError(_0x13e9b8[_0xe1d1('0x71')][_0x47e969],{'code':_0xe1d1('0x87'),'message':_0x20a291[_0xe1d1('0x5d')]});logger[_0xe1d1('0x5c')](_0xe1d1('0x88'),_0x20a291[_0xe1d1('0x5d')]);}},'complete':function(){try{var _0x59785e=[];var _0x4b5ae2=_0xe1d1('0x3c');if(_0x1132c2['duplicates']&&_0x1132c2[_0xe1d1('0x89')][_0xe1d1('0x1e')]){_0x4b5ae2=_0xe1d1('0x8a')+_0xcaec55;_0x59785e[_0xe1d1('0x22')]('CREATE\x20TABLE\x20'+_0x4b5ae2+_0xe1d1('0x8b'));}logger[_0xe1d1('0x5a')](_0xe1d1('0x8c'),contactItemTypes[_0xe1d1('0x1e')]);var _0xbf042=util[_0xe1d1('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',_0x54d778,_0x4b5ae2,_0x4811f5,_0x1132c2[_0xe1d1('0x35')],_0x1132c2['CompanyId']||null,NOW,NOW);if(_[_0xe1d1('0x73')](_0x2772f6[_0xe1d1('0x33')])){_0xbf042+=_0xe1d1('0x8d');}_0x59785e['push'](_0xbf042);if(_0x1132c2[_0xe1d1('0x89')]&&_0x1132c2[_0xe1d1('0x89')][_0xe1d1('0x1e')]){_0x59785e['push'](insertCmContact(_0x1132c2[_0xe1d1('0x35')],_0x4b5ae2,_0x1132c2[_0xe1d1('0x89')],_0x2772f6));_0x59785e[_0xe1d1('0x22')](_0xe1d1('0x8e')+_0x4b5ae2+';');}BPromise[_0xe1d1('0x8f')](_0x59785e,handleQuery)[_0xe1d1('0x1d')](function(_0x3a4d84){BPromise[_0xe1d1('0x1f')]([handleAdditionalPhones()])[_0xe1d1('0x1d')](function(){_0x59785e=[];for(var _0x53c1f1=0x0;_0x53c1f1<promisesAdditionalPhones[_0xe1d1('0x1e')];_0x53c1f1++){_0x59785e[_0xe1d1('0x22')](createAdditionalPhone(promisesAdditionalPhones[_0x53c1f1][_0xe1d1('0x90')],promisesAdditionalPhones[_0x53c1f1][_0xe1d1('0x91')],promisesAdditionalPhones[_0x53c1f1][_0xe1d1('0x14')],promisesAdditionalPhones[_0x53c1f1][_0xe1d1('0x92')]));}BPromise['all'](_0x59785e)[_0xe1d1('0x1d')](function(){_0x59785e=[];_0x59785e[_0xe1d1('0x22')](insertCmHopper(_0x1132c2['ListId'],'voice_queues_has_cm_lists',_0xe1d1('0x93'),_0xe1d1('0x94'),_0x361d27));_0x59785e[_0xe1d1('0x22')](insertCmHopperBlack(_0x1132c2[_0xe1d1('0x35')],_0xe1d1('0x95'),_0xe1d1('0x93'),'VoiceQueueId'));_0x59785e[_0xe1d1('0x22')](insertCmHopper(_0x1132c2['ListId'],_0xe1d1('0x96'),_0xe1d1('0x97'),'CampaignId',_0x361d27));_0x59785e[_0xe1d1('0x22')](insertCmHopperBlack(_0x1132c2[_0xe1d1('0x35')],_0xe1d1('0x98'),_0xe1d1('0x97'),_0xe1d1('0x99')));_0x59785e[_0xe1d1('0x22')](insertCmHopperAdditionalPhones(_0x1132c2['ListId']));BPromise['each'](_0x59785e,handleQuery)[_0xe1d1('0x1d')](function(_0x2f7a9c){stats[_0xe1d1('0x9a')]=!![];stats['affectedRows']=_0x1132c2['duplicates']&&_0x1132c2['duplicates']['length']?results[0x2][_0xe1d1('0x9b')]:results[0x0]['affectedRows'];socket[_0xe1d1('0x9c')]('contact:import:'+_0xcaec55,stats);fs[_0xe1d1('0x9d')](_0x4a17dd);fs['unlink'](_0x54d778);process[_0xe1d1('0x9e')](0x0);})[_0xe1d1('0x61')](function(_0x43dabe){logger['error'](_0x43dabe[_0xe1d1('0x5d')]);process[_0xe1d1('0x9e')](0x1);});});});})[_0xe1d1('0x61')](function(_0x3b3efa){logger[_0xe1d1('0x5c')](_0x3b3efa[_0xe1d1('0x5d')]);process[_0xe1d1('0x9e')](0x1);});}catch(_0x48e96d){logger[_0xe1d1('0x5c')]('complete',_0x48e96d[_0xe1d1('0x5d')]);process['exit'](0x1);}},'error':function(_0x839355,_0x79e5c6,_0x715b4f,_0xf562fb){throw new Error(_0xf562fb);}});});}function validate(){if(process[_0xe1d1('0x9f')]&&process[_0xe1d1('0x9f')][_0xe1d1('0x1e')]<0x4){throw new Error(_0xe1d1('0xa0'));}var _0x1900a0=path[_0xe1d1('0x16')](config[_0xe1d1('0x68')],_0xe1d1('0x69'),process[_0xe1d1('0x9f')][0x2]);if(!fs['existsSync'](_0x1900a0)){throw new Error(_0xe1d1('0xa1'));}var _0x1b692c={};try{_0x1b692c=JSON['parse'](process['argv'][0x3]);if(!_0x1b692c[_0xe1d1('0x65')]){throw new Error(_0xe1d1('0xa2'));}if(!_0x1b692c[_0xe1d1('0x65')][_0xe1d1('0x14')]){throw new Error('phone\x20is\x20mandatory');}if(!_0x1b692c['binding'][_0xe1d1('0x7f')]){throw new Error(_0xe1d1('0xa3'));}var _0x179daf=0x0;if(_0x1b692c[_0xe1d1('0x65')]['UserId']){_0x179daf=0x1;}if(!_0x1b692c['ListId']){throw new Error(_0xe1d1('0xa4'));}}catch(_0x96417e){throw new Error(_0xe1d1('0xa5'));}var _0x57200e=[];try{_0x57200e=_[_0xe1d1('0xa6')](JSON[_0xe1d1('0x6f')](process[_0xe1d1('0x9f')][0x4]),'id');}catch(_0x4055e5){logger['info'](_0xe1d1('0xa7'));}main(_0x1900a0,_0x1b692c,_0x57200e,_0x179daf);}validate();process['on'](_0xe1d1('0xa8'),handleStop);process['on'](_0xe1d1('0xa9'),handleUncaughtException);
\ No newline at end of file
+var _0xc826=['../../../config/logger','import','redis','defaults','localhost','format','YYYY-MM-DD\x20HH:mm:ss','test','field','phone','from','join','.id\x20=\x20','where','CmContact','findAll','AdditionalPhones','push','all','then','split','length','filter','CmContactHasItem','updated','PHONE','inserted','cm_contacts.phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.ListId','cm_contacts.createdAt','cm_contacts.priority','cm_contacts.UserId','insert','into','cm_hopper','fromQuery','scheduledat','ContactId','ListId','createdAt','priority','UserId','recallme','fields','cm_contacts','cm_contacts.ListId\x20=\x20','.CmListId','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22onlyIfOpen\x22','\x22always\x22','toString','cm_contacts.updatedAt','cm_hopper_black','updatedAt','select','\x20=\x20?','cm_hopper.id','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','OrderBy','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys','CompanyId',')\x20NOT\x20IN\x20?','ListId\x20=\x20?','deletedAt\x20IS\x20NULL','MIN(id)','min_id','group','Received\x20SIGINT','exit','errors','info','sequelize','query','spread','catch','error','message','main','stringify','send','binding','clone','root','.csv','body','ContactItemType','name','header','writeFileSync','parse','rows','find','isNil','hasOwnProperty','data','trim','replace','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','isNaN','isNumber','includes','agent\x20not\x20exists','email','email\x20wrong\x20format','dateOfBirth','YYYY-MM-DD','firstName','\x20not\x20specified','emit','Abort\x20parser','SystemError','step','duplicates','\x20LIKE\x20cm_contacts;','LOAD\x20DATA\x20LOCAL\x20INFILE\x20\x27%s\x27\x20INTO\x20TABLE\x20%s\x20CHARACTER\x20SET\x20UTF8\x20FIELDS\x20TERMINATED\x20BY\x20\x27,\x27\x20ENCLOSED\x20BY\x20\x27\x22\x27\x20LINES\x20TERMINATED\x20BY\x20\x27\x0a\x27\x20IGNORE\x201\x20ROWS\x20(%s)\x20SET\x20id\x20=\x20NULL,\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27',',\x20scheduledAt\x20=\x20NOW()','DROP\x20TABLE\x20','each','contactId','orderBy','voice_queues','VoiceQueueId','voice_queues_has_cm_blacklists','campaigns_has_cm_lists','campaigns','CampaignId','campaigns_has_cm_blacklists','finish','affectedRows','unlink','complete','argv','server/files/tmp','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','body\x20id\x20mandatory','map','No\x20agent\x20available','SIGINT','uncaughtException','lodash','util','bluebird','moment','ioredis','../../../config/environment'];(function(_0x4a060e,_0x27b3b3){var _0x22510f=function(_0x578680){while(--_0x578680){_0x4a060e['push'](_0x4a060e['shift']());}};_0x22510f(++_0x27b3b3);}(_0xc826,0x1da));var _0x6c82=function(_0x998e0a,_0x4a21be){_0x998e0a=_0x998e0a-0x0;var _0x50a737=_0xc826[_0x998e0a];return _0x50a737;};'use strict';var fs=require('fs');var path=require('path');var _=require(_0x6c82('0x0'));var Papa=require('papaparse');var util=require(_0x6c82('0x1'));var BPromise=require(_0x6c82('0x2'));var moment=require(_0x6c82('0x3'));var squel=require('squel');var Redis=require(_0x6c82('0x4'));var db=require('../../../mysqldb')['db'];var config=require(_0x6c82('0x5'));var logger=require(_0x6c82('0x6'))(_0x6c82('0x7'));config[_0x6c82('0x8')]=_[_0x6c82('0x9')](config[_0x6c82('0x8')],{'host':_0x6c82('0xa'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x6c82('0x8')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var orderBy=0x0;var stopped=![];var NOW=moment()[_0x6c82('0xb')](_0x6c82('0xc'));var contactItemTypes=[];var hasAdditionalPhones=![];function isEmail(_0x924124){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))*$/[_0x6c82('0xd')](_0x924124);}function selectNotIn(_0xbf2d20,_0x2ce2f5,_0x4a7ead,_0x529f2d,_0x56acd9){return squel['select']()[_0x6c82('0xe')](_0x6c82('0xf'))[_0x6c82('0x10')](_0x529f2d)[_0x6c82('0x11')](_0x2ce2f5,null,_0x2ce2f5+_0x6c82('0x12')+_0x529f2d+'.'+_0x4a7ead)['where'](_0x529f2d+'.'+_0x4a7ead+'\x20=\x20'+_0xbf2d20+'.'+_0x4a7ead)[_0x6c82('0x13')](_0x2ce2f5+'.dialCheckDuplicateType\x20IN\x20('+_0x56acd9[_0x6c82('0x11')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x1aa2b7,_0x2ac40a){promisesAdditionalPhones=[];return db[_0x6c82('0x14')][_0x6c82('0x15')]({'raw':!![],'attributes':['id',_0x6c82('0x16')],'where':{'createdAt':NOW,'AdditionalPhones':{'$ne':null}}})['then'](function(_0x29c573){if(_0x29c573!==null){var _0xf67446=[];for(var _0xf185bc=0x0;_0xf185bc<_0x29c573['length'];_0xf185bc++){var _0x2cbce7=_0x29c573[_0xf185bc];_0xf67446[_0x6c82('0x17')](insertAdditionalPhones(_0x2cbce7));}}Promise[_0x6c82('0x18')](_0xf67446)[_0x6c82('0x19')](function(){_0x1aa2b7({'val':0x1});});});});}function insertAdditionalPhones(_0x3e6d11){return new Promise(function(_0x420299,_0x4abaa8){var _0x40f98f=_0x3e6d11['AdditionalPhones'];var _0x48394d=_0x40f98f[_0x6c82('0x1a')](';');var _0x47637d=[];orderBy=0x0;for(var _0x514750=0x0;_0x514750<_0x48394d[_0x6c82('0x1b')];_0x514750++){_0x47637d[_0x6c82('0x17')](splitAdditionalPhone(_0x3e6d11['id'],_0x48394d[_0x514750]));}Promise[_0x6c82('0x18')](_0x47637d)[_0x6c82('0x19')](function(){_0x420299({'val':_0x48394d[_0x6c82('0x1b')]});});});}function splitAdditionalPhone(_0x4f0abd,_0x1e6c1f){return new Promise(function(_0x2155b6,_0x12a923){var _0xd06075=_0x1e6c1f[_0x6c82('0x1a')](':');var _0x23319d=_0xd06075[0x0];var _0x3173f0=_0xd06075[0x1];if(_0x3173f0!==''){var _0x47b46b=_0x3173f0['split']('|');var _0x246a11=[];for(var _0x50a0f7=0x0;_0x50a0f7<_0x47b46b['length'];_0x50a0f7++){if(_0x47b46b[_0x50a0f7]!==''){var _0x5e2fe6=_[_0x6c82('0x1c')](promisesAdditionalPhones,{'contactId':_0x4f0abd,'phone':_0x47b46b[_0x50a0f7]});if(_0x5e2fe6[_0x6c82('0x1b')]==0x0){orderBy++;promisesAdditionalPhones[_0x6c82('0x17')]({'contactId':_0x4f0abd,'contactTypeId':_0x23319d,'phone':_0x47b46b[_0x50a0f7],'orderBy':orderBy});}}}_0x2155b6({'ok':0x1});}else _0x2155b6({'res':0x0});});}function createAdditionalPhone(_0x402587,_0x52371a,_0x40ff5a,_0x1234c5){return new Promise(function(_0x2b8c2e,_0x3c06eb){return db[_0x6c82('0x1d')]['findOne']({'where':{'CmContactId':_0x402587,'item':_0x40ff5a}})[_0x6c82('0x19')](function(_0x8fd783){if(_0x8fd783){return db[_0x6c82('0x1d')]['update']({'ItemTypeId':_0x52371a,'OrderBy':_0x1234c5},{'where':{'CmContactId':_0x402587,'item':_0x40ff5a}})[_0x6c82('0x19')](function(_0x5c37df){_0x2b8c2e({'res':_0x6c82('0x1e')});});}else{return db[_0x6c82('0x1d')]['create']({'CmContactId':_0x402587,'item':_0x40ff5a,'ItemTypeId':_0x52371a,'OrderBy':_0x1234c5,'ItemClass':_0x6c82('0x1f')})['then'](function(_0x2512aa){_0x2b8c2e({'res':_0x6c82('0x20')});});}});});}function insertCmHopper(_0x501204,_0x550758,_0x59679c,_0x2df4ba,_0x43425b){var _0x5f3628=[_0x6c82('0x21'),_0x6c82('0x22'),_0x6c82('0x23'),_0x6c82('0x24'),_0x550758+'.'+_0x2df4ba,_0x6c82('0x25'),'cm_contacts.updatedAt',_0x6c82('0x26'),_0x6c82('0x27'),'\x22'+_0x43425b+'\x22'];return squel[_0x6c82('0x28')]()[_0x6c82('0x29')](_0x6c82('0x2a'))[_0x6c82('0x2b')](['phone',_0x6c82('0x2c'),_0x6c82('0x2d'),_0x6c82('0x2e'),_0x2df4ba,_0x6c82('0x2f'),'updatedAt',_0x6c82('0x30'),_0x6c82('0x31'),_0x6c82('0x32')],squel['select']()[_0x6c82('0x33')](_0x5f3628)[_0x6c82('0x10')](_0x550758)[_0x6c82('0x11')](_0x6c82('0x34'),null,_0x6c82('0x35')+_0x550758+_0x6c82('0x36'))[_0x6c82('0x11')](_0x59679c,null,_0x59679c+_0x6c82('0x12')+_0x550758+'.'+_0x2df4ba)[_0x6c82('0x13')](_0x550758+_0x6c82('0x37'),_0x501204)['where'](_0x6c82('0x38'),NOW)['where'](_0x6c82('0x39'),selectNotIn(_0x550758,_0x59679c,_0x2df4ba,_0x6c82('0x2a'),['\x22always\x22',_0x6c82('0x3a')]))[_0x6c82('0x13')](_0x6c82('0x39'),selectNotIn(_0x550758,_0x59679c,_0x2df4ba,_0x6c82('0x2a'),[_0x6c82('0x3b')])))[_0x6c82('0x3c')]();}function insertCmHopperBlack(_0x19912c,_0x10b65e,_0x1375f7,_0x2c31e6){var _0x1a840c=[_0x6c82('0x21'),_0x6c82('0x23'),'cm_contacts.ListId',_0x10b65e+'.'+_0x2c31e6,_0x6c82('0x25'),_0x6c82('0x3d')];return squel['insert']()['into'](_0x6c82('0x3e'))['fromQuery']([_0x6c82('0xf'),'ContactId',_0x6c82('0x2e'),_0x2c31e6,_0x6c82('0x2f'),_0x6c82('0x3f')],squel[_0x6c82('0x40')]()[_0x6c82('0x33')](_0x1a840c)['from'](_0x10b65e)[_0x6c82('0x11')]('cm_contacts',null,'cm_contacts.ListId\x20=\x20'+_0x10b65e+'.CmListId')[_0x6c82('0x11')](_0x1375f7,null,_0x1375f7+_0x6c82('0x12')+_0x10b65e+'.'+_0x2c31e6)[_0x6c82('0x13')](_0x10b65e+_0x6c82('0x37'),_0x19912c)[_0x6c82('0x13')](_0x6c82('0x38'),NOW)[_0x6c82('0x13')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel[_0x6c82('0x40')]()[_0x6c82('0xe')]('phone')[_0x6c82('0x10')]('cm_hopper_black')[_0x6c82('0x13')]('ListId\x20=\x20?',_0x19912c)[_0x6c82('0x13')](_0x2c31e6+_0x6c82('0x41'),_0x10b65e+'.'+_0x2c31e6)))[_0x6c82('0x3c')]();}function insertCmHopperAdditionalPhones(_0x5eb902){var _0x416b36=[_0x6c82('0x42'),_0x6c82('0x43'),_0x6c82('0x44'),_0x6c82('0x45'),_0x6c82('0x46')];return squel['insert']()[_0x6c82('0x29')](_0x6c82('0x47'))[_0x6c82('0x2b')](['CmHopperId',_0x6c82('0xf'),_0x6c82('0x48'),_0x6c82('0x2f'),_0x6c82('0x3f')],squel['select']()['fields'](_0x416b36)['from'](_0x6c82('0x2a'))['join'](_0x6c82('0x34'),null,_0x6c82('0x49'))[_0x6c82('0x11')]('cm_contact_has_items',null,_0x6c82('0x4a'))[_0x6c82('0x13')](_0x6c82('0x4b'),_0x5eb902)[_0x6c82('0x13')](_0x6c82('0x38'),NOW))['toString']();}function insertCmContact(_0x3c085d,_0x34c90e,_0x24fff2,_0x18e568){var _0x8c77ef=_[_0x6c82('0x4c')](_[_0x6c82('0x4d')](_0x18e568),[_0x6c82('0x2e'),_0x6c82('0x4e'),_0x6c82('0x2f'),'updatedAt']);return squel[_0x6c82('0x28')]()[_0x6c82('0x29')](_0x6c82('0x34'))[_0x6c82('0x2b')](_0x8c77ef,squel[_0x6c82('0x40')]()['fields'](_0x8c77ef)['from'](_0x34c90e)[_0x6c82('0x13')]('('+_0x24fff2[_0x6c82('0x11')](',')+_0x6c82('0x4f'),squel[_0x6c82('0x40')]()[_0x6c82('0x33')](_0x24fff2)[_0x6c82('0x10')]('cm_contacts')[_0x6c82('0x13')](_0x6c82('0x50'),_0x3c085d)['where'](_0x6c82('0x51')))[_0x6c82('0x13')]('id\x20IN\x20?',squel[_0x6c82('0x40')]()[_0x6c82('0xe')](_0x6c82('0x52'),_0x6c82('0x53'))['from'](_0x34c90e)[_0x6c82('0x54')](_0x24fff2[_0x6c82('0x11')](','))))[_0x6c82('0x3c')]();}function handleStop(){logger['info'](_0x6c82('0x55'));stopped=!![];}function handleUncaughtException(_0x26e09f){logger['error'](_0x26e09f['message']);process[_0x6c82('0x56')](0x1);}function handleError(_0x1085e8,_0x22ba57){stats[_0x6c82('0x57')]['push']({'name':_0x22ba57['code'],'message':_0x22ba57['message'],'row':_0x1085e8});}function handleQuery(_0x215f7c){logger[_0x6c82('0x58')](_0x215f7c);return db[_0x6c82('0x59')][_0x6c82('0x5a')](_0x215f7c)[_0x6c82('0x5b')](function(_0x27c851){results['push'](_0x27c851);})[_0x6c82('0x5c')](function(_0x2947b6){logger[_0x6c82('0x5d')](_0x2947b6[_0x6c82('0x5e')]);});}function main(_0x4c6e8a,_0x1aaaee,_0x311662,_0x196adc){logger[_0x6c82('0x58')](_0x6c82('0x5f'),_0x4c6e8a,JSON[_0x6c82('0x60')](_0x1aaaee));process[_0x6c82('0x61')]('start');var _0x4708ce=_0x1aaaee[_0x6c82('0x62')];var _0x2bca82=_[_0x6c82('0x63')](_0x4708ce);var _0x349055=_0x1aaaee['socket_timestamp'];var _0x36fd94=path[_0x6c82('0x11')](config[_0x6c82('0x64')],'server/files/tmp',_0x349055+_0x6c82('0x65'));logger[_0x6c82('0x58')](_0x6c82('0x66'),_0x1aaaee);db[_0x6c82('0x67')][_0x6c82('0x15')]({'raw':!![],'attributes':['id',_0x6c82('0x68')]})['then'](function(_0x1c6af6){for(var _0x5f27c8=0x0;_0x5f27c8<_0x1c6af6[_0x6c82('0x1b')];_0x5f27c8++){if(_0x1c6af6[_0x5f27c8][_0x6c82('0x68')]in _0x4708ce){contactItemTypes['push'](_0x1c6af6[_0x5f27c8]);delete _0x2bca82[_0x1c6af6[_0x5f27c8][_0x6c82('0x68')]];hasAdditionalPhones=!![];}else{}}if(hasAdditionalPhones)_0x2bca82[_0x6c82('0x16')]='';var _0x2e72ea=_['keys'](_0x2bca82)['join']();logger[_0x6c82('0x58')](_0x6c82('0x69'),_0x2e72ea);fs[_0x6c82('0x6a')](_0x36fd94,_0x2e72ea+'\x0a');Papa[_0x6c82('0x6b')](fs['createReadStream'](_0x4c6e8a),{'header':!![],'skipEmptyLines':!![],'step':function(_0x17c971,_0x47d613){try{for(var _0x184b03=0x0,_0x1242d4=[];_0x184b03<_0x17c971['data'][_0x6c82('0x1b')];_0x184b03++){stats[_0x6c82('0x6c')]+=0x1;if(_0x17c971[_0x6c82('0x57')][_0x184b03]){handleError(_0x17c971['data'][_0x184b03],_0x17c971[_0x6c82('0x57')][_0x184b03]);}else{var _0x43c0b8=[];var _0x3c69e1=[];for(var _0x343bb4 in _0x4708ce){let _0x15c5bd=contactItemTypes[_0x6c82('0x6d')](_0x449619=>_0x449619[_0x6c82('0x68')]===_0x343bb4);if(_[_0x6c82('0x6e')](_0x15c5bd)){if(_0x4708ce[_0x6c82('0x6f')](_0x343bb4)){if(_0x17c971[_0x6c82('0x70')][_0x184b03][_0x4708ce[_0x343bb4]]){var _0x3b8e86=_[_0x6c82('0x71')](_0x17c971[_0x6c82('0x70')][_0x184b03][_0x4708ce[_0x343bb4]][_0x6c82('0x72')](/"/g,'\x27'));switch(_0x343bb4){case _0x6c82('0x2c'):var _0x26c757=moment(_0x3b8e86,_0x6c82('0xc'),!![]);if(_0x26c757[_0x6c82('0x73')]()){_0x1242d4[_0x6c82('0x17')]('\x22'+_0x3b8e86+'\x22');}else{_0x43c0b8['push'](_0x6c82('0x74'));}break;case _0x6c82('0x30'):var _0x4bd73c=parseInt(_0x3b8e86);_0x3b8e86=_[_0x6c82('0x75')](_0x4bd73c)||_0x4bd73c<0x0||_0x4bd73c>0x4?_0x196adc?0x3:0x2:_0x4bd73c;_0x1242d4['push']('\x22'+_0x3b8e86+'\x22');break;case _0x6c82('0x31'):var _0x11883e=parseInt(_0x3b8e86);if(_[_0x6c82('0x76')](_0x11883e)&&_[_0x6c82('0x77')](_0x311662,_0x11883e)){_0x1242d4[_0x6c82('0x17')]('\x22'+_0x11883e+'\x22');}else{_0x43c0b8[_0x6c82('0x17')](_0x6c82('0x78'));}break;case _0x6c82('0x79'):if(isEmail(_0x3b8e86)){_0x1242d4[_0x6c82('0x17')]('\x22'+_0x3b8e86+'\x22');}else{_0x43c0b8['push'](_0x6c82('0x7a'));}break;case _0x6c82('0x7b'):var _0x2f9c40=moment(_0x3b8e86,_0x6c82('0x7c'),!![]);if(_0x2f9c40[_0x6c82('0x73')]()){_0x1242d4[_0x6c82('0x17')]('\x22'+_0x3b8e86+'\x22');}else{_0x43c0b8[_0x6c82('0x17')]('dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)');}break;default:_0x1242d4[_0x6c82('0x17')]('\x22'+_0x3b8e86+'\x22');}}else{switch(_0x343bb4){case _0x6c82('0x7d'):case _0x6c82('0xf'):_0x43c0b8['push'](_0x343bb4+_0x6c82('0x7e'));break;default:_0x1242d4['push']('\x22\x22');}}}}else{var _0x59b200='';for(var _0x26b2ab=0x0;_0x26b2ab<_0x4708ce[_0x343bb4][_0x6c82('0x1b')];_0x26b2ab++){var _0x3b8e86=_['trim'](_0x17c971['data'][_0x184b03][_0x4708ce[_0x343bb4][_0x26b2ab]]['replace'](/"/g,'\x27'));if(_0x59b200=='')_0x59b200=_0x3b8e86;else _0x59b200+='|'+_0x3b8e86;}_0x3c69e1[_0x6c82('0x17')](_0x15c5bd['id']+':'+_0x59b200);}}if(hasAdditionalPhones){_0x1242d4['push']('\x22'+_0x3c69e1[_0x6c82('0x11')](';')+'\x22');}if(_0x43c0b8[_0x6c82('0x1b')]){handleError(_0x17c971['data'][_0x184b03],{'code':'SystemRow','message':_0x43c0b8[_0x6c82('0x11')]()});}else{fs['appendFileSync'](_0x36fd94,_0x1242d4[_0x6c82('0x11')]()+'\x0a');}_0x1242d4=[];}if(!(stats[_0x6c82('0x6c')]%0xc8)){socket[_0x6c82('0x7f')]('contact:import:'+_0x349055,stats);stats[_0x6c82('0x57')]=[];}}if(stopped){logger[_0x6c82('0x58')](_0x6c82('0x80'));_0x47d613['abort']();}}catch(_0x266e66){handleError(_0x17c971[_0x6c82('0x70')][_0x184b03],{'code':_0x6c82('0x81'),'message':_0x266e66['message']});logger['error'](_0x6c82('0x82'),_0x266e66[_0x6c82('0x5e')]);}},'complete':function(){try{var _0x178088=[];var _0x49e37d=_0x6c82('0x34');if(_0x1aaaee[_0x6c82('0x83')]&&_0x1aaaee[_0x6c82('0x83')][_0x6c82('0x1b')]){_0x49e37d='cm_contacts_'+_0x349055;_0x178088[_0x6c82('0x17')]('CREATE\x20TABLE\x20'+_0x49e37d+_0x6c82('0x84'));}logger[_0x6c82('0x58')]('CIS\x20len',contactItemTypes[_0x6c82('0x1b')]);var _0x46ded9=util[_0x6c82('0xb')](_0x6c82('0x85'),_0x36fd94,_0x49e37d,_0x2e72ea,_0x1aaaee[_0x6c82('0x2e')],_0x1aaaee[_0x6c82('0x4e')]||null,NOW,NOW);if(_[_0x6c82('0x6e')](_0x4708ce[_0x6c82('0x2c')])){_0x46ded9+=_0x6c82('0x86');}_0x178088[_0x6c82('0x17')](_0x46ded9);if(_0x1aaaee[_0x6c82('0x83')]&&_0x1aaaee[_0x6c82('0x83')][_0x6c82('0x1b')]){_0x178088[_0x6c82('0x17')](insertCmContact(_0x1aaaee[_0x6c82('0x2e')],_0x49e37d,_0x1aaaee[_0x6c82('0x83')],_0x4708ce));_0x178088['push'](_0x6c82('0x87')+_0x49e37d+';');}BPromise[_0x6c82('0x88')](_0x178088,handleQuery)[_0x6c82('0x19')](function(_0x40390b){BPromise[_0x6c82('0x18')]([handleAdditionalPhones()])['then'](function(){_0x178088=[];for(var _0x38e5b0=0x0;_0x38e5b0<promisesAdditionalPhones['length'];_0x38e5b0++){_0x178088[_0x6c82('0x17')](createAdditionalPhone(promisesAdditionalPhones[_0x38e5b0][_0x6c82('0x89')],promisesAdditionalPhones[_0x38e5b0]['contactTypeId'],promisesAdditionalPhones[_0x38e5b0][_0x6c82('0xf')],promisesAdditionalPhones[_0x38e5b0][_0x6c82('0x8a')]));}BPromise[_0x6c82('0x18')](_0x178088)['then'](function(){_0x178088=[];_0x178088[_0x6c82('0x17')](insertCmHopper(_0x1aaaee[_0x6c82('0x2e')],'voice_queues_has_cm_lists',_0x6c82('0x8b'),_0x6c82('0x8c'),_0x196adc));_0x178088[_0x6c82('0x17')](insertCmHopperBlack(_0x1aaaee[_0x6c82('0x2e')],_0x6c82('0x8d'),'voice_queues',_0x6c82('0x8c')));_0x178088[_0x6c82('0x17')](insertCmHopper(_0x1aaaee[_0x6c82('0x2e')],_0x6c82('0x8e'),_0x6c82('0x8f'),_0x6c82('0x90'),_0x196adc));_0x178088[_0x6c82('0x17')](insertCmHopperBlack(_0x1aaaee['ListId'],_0x6c82('0x91'),_0x6c82('0x8f'),_0x6c82('0x90')));_0x178088[_0x6c82('0x17')](insertCmHopperAdditionalPhones(_0x1aaaee['ListId']));BPromise['each'](_0x178088,handleQuery)['then'](function(_0x5006b4){stats[_0x6c82('0x92')]=!![];stats['affectedRows']=_0x1aaaee[_0x6c82('0x83')]&&_0x1aaaee['duplicates'][_0x6c82('0x1b')]?results[0x2][_0x6c82('0x93')]:results[0x0]['affectedRows'];socket[_0x6c82('0x7f')]('contact:import:'+_0x349055,stats);fs[_0x6c82('0x94')](_0x4c6e8a);fs[_0x6c82('0x94')](_0x36fd94);process[_0x6c82('0x56')](0x0);})['catch'](function(_0x2f830b){logger[_0x6c82('0x5d')](_0x2f830b['message']);process[_0x6c82('0x56')](0x1);});});});})[_0x6c82('0x5c')](function(_0x4bf91b){logger[_0x6c82('0x5d')](_0x4bf91b[_0x6c82('0x5e')]);process[_0x6c82('0x56')](0x1);});}catch(_0x1edc41){logger['error'](_0x6c82('0x95'),_0x1edc41[_0x6c82('0x5e')]);process[_0x6c82('0x56')](0x1);}},'error':function(_0x3c63ad,_0x3254f5,_0x1340c9,_0x1516f4){throw new Error(_0x1516f4);}});});}function validate(){if(process['argv']&&process[_0x6c82('0x96')][_0x6c82('0x1b')]<0x4){throw new Error('arguments\x20<filename>\x20<parameters>\x20<agents>');}var _0xed974b=path['join'](config['root'],_0x6c82('0x97'),process[_0x6c82('0x96')][0x2]);if(!fs[_0x6c82('0x98')](_0xed974b)){throw new Error(_0x6c82('0x99'));}var _0xf3fe0={};try{_0xf3fe0=JSON[_0x6c82('0x6b')](process[_0x6c82('0x96')][0x3]);if(!_0xf3fe0[_0x6c82('0x62')]){throw new Error(_0x6c82('0x9a'));}if(!_0xf3fe0[_0x6c82('0x62')][_0x6c82('0xf')]){throw new Error('phone\x20is\x20mandatory');}if(!_0xf3fe0[_0x6c82('0x62')][_0x6c82('0x7d')]){throw new Error('firstName\x20is\x20mandatory');}var _0x3cdf48=0x0;if(_0xf3fe0[_0x6c82('0x62')]['UserId']){_0x3cdf48=0x1;}if(!_0xf3fe0['ListId']){throw new Error('ListId\x20is\x20mandatory');}}catch(_0x2675dc){throw new Error(_0x6c82('0x9b'));}var _0x22b5e6=[];try{_0x22b5e6=_[_0x6c82('0x9c')](JSON[_0x6c82('0x6b')](process[_0x6c82('0x96')][0x4]),'id');}catch(_0x219cb2){logger[_0x6c82('0x58')](_0x6c82('0x9d'));}main(_0xed974b,_0xf3fe0,_0x22b5e6,_0x3cdf48);}validate();process['on'](_0x6c82('0x9e'),handleStop);process['on'](_0x6c82('0x9f'),handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff