// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x2906=['error','exit','errors','code','query','spread','stringify','send','start','root','server/files/tmp','.csv','body','findAll','name','_description','header','writeFileSync','parse','createReadStream','data','rows','find','hasOwnProperty','trim','replace','isValid','scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)','priority','isNaN','isNumber','includes','agent\x20not\x20exists','email','dateOfBirth','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','itemTypeId','SystemRow','appendFileSync','contact:import:','Abort\x20parser','abort','SystemError','step','CREATE\x20TABLE\x20','\x20LIKE\x20cm_contacts;','CIS\x20len','CompanyId',',\x20scheduledAt\x20=\x20NOW()','each','contactId','orderBy','affectedRows','emit','unlink','argv','existsSync','file\x20doesn\x27t\x20exists','binding','UserId','ListId\x20is\x20mandatory','body\x20id\x20mandatory','map','No\x20agent\x20available','SIGINT','uncaughtException','path','lodash','util','moment','squel','ioredis','../../../mysqldb','redis','socket.io-emitter','YYYY-MM-DD\x20HH:mm:ss','cm_contacts_temp_','format','YYYYMMDDHHmmss','test','select','field','from','.id\x20=\x20','\x20=\x20','where','.dialCheckDuplicateType\x20IN\x20(','join','sequelize','select\x20*\x20from\x20','length','isNil','AdditionalPhones','push','then','catch','message','split','all','CmContactHasItem','updated','create','inserted','CmContact','update','CmHopper','phone','cm_contacts.scheduledat','cm_contacts.id','cm_contacts.createdAt','cm_contacts.updatedAt','cm_contacts.priority','cm_contacts.UserId','into','cm_hopper','fromQuery','scheduledat','ContactId','ListId','updatedAt','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','cm_contacts.phone','cm_contacts.ListId','insert','cm_hopper_black','createdAt','ListId\x20=\x20?','toString','cm_contact_has_items.item','cm_contact_has_items.OrderBy','cm_contact_has_items.createdAt','cm_hopper_additional_phones','OrderBy','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contact_has_items','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys',')\x20NOT\x20IN\x20?','id\x20IN\x20?','MIN(id)','group','info','Received\x20SIGINT'];(function(_0x2062f2,_0x5d03bb){var _0x24327e=function(_0x4a3a65){while(--_0x4a3a65){_0x2062f2['push'](_0x2062f2['shift']());}};_0x24327e(++_0x5d03bb);}(_0x2906,0xe0));var _0x6290=function(_0x562cc9,_0x1cb01e){_0x562cc9=_0x562cc9-0x0;var _0x5ddbf8=_0x2906[_0x562cc9];return _0x5ddbf8;};'use strict';var fs=require('fs');var path=require(_0x6290('0x0'));var _=require(_0x6290('0x1'));var Papa=require('papaparse');var util=require(_0x6290('0x2'));var BPromise=require('bluebird');var moment=require(_0x6290('0x3'));var squel=require(_0x6290('0x4'));var Redis=require(_0x6290('0x5'));var db=require(_0x6290('0x6'))['db'];var config=require('../../../config/environment');var logger=require('../../../config/logger')('import');config[_0x6290('0x7')]=_['defaults'](config[_0x6290('0x7')],{'host':'localhost','port':0x18eb});var socket=require(_0x6290('0x8'))(new Redis(config[_0x6290('0x7')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var promisesContact=[];var orderBy=0x0;var updatedRows=0x0;var stopped=![];var NOW=moment()['format'](_0x6290('0x9'));var tempTableName=_0x6290('0xa')+moment()[_0x6290('0xb')](_0x6290('0xc'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];function isEmail(_0x24fb23){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))*$/[_0x6290('0xd')](_0x24fb23);}function selectNotIn(_0x1634f7,_0x1975bb,_0x311f9a,_0x1951cb,_0x5697c0){return squel[_0x6290('0xe')]()[_0x6290('0xf')]('phone')[_0x6290('0x10')](_0x1951cb)['join'](_0x1975bb,null,_0x1975bb+_0x6290('0x11')+_0x1951cb+'.'+_0x311f9a)['where'](_0x1951cb+'.'+_0x311f9a+_0x6290('0x12')+_0x1634f7+'.'+_0x311f9a)[_0x6290('0x13')](_0x1975bb+_0x6290('0x14')+_0x5697c0[_0x6290('0x15')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x151db9,_0x5037c2){promisesAdditionalPhones=[];promisesContact=[];return db[_0x6290('0x16')]['query'](_0x6290('0x17')+tempTableName)['spread'](function(_0x204336){if(_0x204336!==null){var _0x5cf917=[];for(var _0x7b7a23=0x0;_0x7b7a23<_0x204336[_0x6290('0x18')];_0x7b7a23++){var _0x3490d6=_0x204336[_0x7b7a23];if(!_[_0x6290('0x19')](_0x3490d6['phone'])){if(!_[_0x6290('0x19')](_0x3490d6[_0x6290('0x1a')]))_0x5cf917['push'](insertAdditionalPhones(_0x3490d6));promisesContact[_0x6290('0x1b')]({'contact':_0x3490d6});}}}Promise['all'](_0x5cf917)[_0x6290('0x1c')](function(){_0x151db9({'val':0x1});});})[_0x6290('0x1d')](function(_0x10dc17){logger['error'](_0x10dc17[_0x6290('0x1e')]);});});}function insertAdditionalPhones(_0x405f7e){return new Promise(function(_0x54100b,_0x14ac6b){var _0x7b9efa=_0x405f7e[_0x6290('0x1a')];if(_['isNil'](_0x7b9efa))_0x14ac6b({'val':0x0});else{var _0x539452=_0x7b9efa[_0x6290('0x1f')](';');var _0x161526=[];orderBy=0x0;for(var _0x4f9424=0x0;_0x4f9424<_0x539452[_0x6290('0x18')];_0x4f9424++){_0x161526[_0x6290('0x1b')](splitAdditionalPhone(_0x405f7e['id'],_0x539452[_0x4f9424]));}Promise[_0x6290('0x20')](_0x161526)[_0x6290('0x1c')](function(){_0x54100b({'val':_0x539452[_0x6290('0x18')]});});}});}function splitAdditionalPhone(_0x20f26a,_0x4d83b8){return new Promise(function(_0x51bbcf,_0x4da5a3){var _0x2fef63=_0x4d83b8[_0x6290('0x1f')](':');var _0x2fecc4=_0x2fef63[0x0];var _0x5eaa99=_0x2fef63[0x1];if(_0x5eaa99!==''){var _0x53c5a8=_0x5eaa99['split']('|');var _0x198e1f=[];for(var _0x1be6ad=0x0;_0x1be6ad<_0x53c5a8[_0x6290('0x18')];_0x1be6ad++){if(_0x53c5a8[_0x1be6ad]!==''){var _0x38597d=_['filter'](promisesAdditionalPhones,{'contactId':_0x20f26a,'phone':_0x53c5a8[_0x1be6ad]});if(_0x38597d[_0x6290('0x18')]==0x0){orderBy++;promisesAdditionalPhones[_0x6290('0x1b')]({'contactId':_0x20f26a,'contactTypeId':_0x2fecc4,'phone':_0x53c5a8[_0x1be6ad],'orderBy':orderBy});}}}_0x51bbcf({'ok':0x1});}else _0x51bbcf({'res':0x0});});}function createAdditionalPhone(_0xdbe366,_0x94c561,_0x5452f7,_0x3f1570){var _0x26bdf0='';var _0x142b05='';var _0x130d86=_0x5452f7[_0x6290('0x1f')]('§');_0x26bdf0=_0x130d86[0x0];if(_0x130d86[_0x6290('0x18')]==0x2)_0x142b05=_0x130d86[0x1];return new Promise(function(_0x56e89c,_0x118904){return db['CmContactHasItem']['findOne']({'where':{'CmContactId':_0xdbe366,'item':_0x26bdf0}})[_0x6290('0x1c')](function(_0x2eefa0){if(_0x2eefa0){return db[_0x6290('0x21')]['update']({'ItemTypeId':_0x94c561,'description':_0x142b05,'OrderBy':_0x3f1570},{'where':{'CmContactId':_0xdbe366,'item':_0x26bdf0}})['then'](function(_0x48f27b){_0x56e89c({'res':_0x6290('0x22')});});}else{return db['CmContactHasItem'][_0x6290('0x23')]({'CmContactId':_0xdbe366,'item':_0x26bdf0,'ItemTypeId':_0x94c561,'description':_0x142b05,'OrderBy':_0x3f1570,'ItemClass':'PHONE'})[_0x6290('0x1c')](function(_0x52f0ee){_0x56e89c({'res':_0x6290('0x24')});});}});});}function updateContact(_0x7290e3){return new Promise(function(_0x5857bd,_0x52682c){var _0x1cd318=_0x7290e3['id'];delete _0x7290e3['id'];return db[_0x6290('0x25')][_0x6290('0x26')](_0x7290e3,{'where':{'id':_0x1cd318}})[_0x6290('0x1c')](function(_0x3be268){updatedRows+=0x1;return db[_0x6290('0x27')][_0x6290('0x26')]({'phone':_0x7290e3[_0x6290('0x28')]},{'where':{'ContactId':_0x1cd318}})['then'](function(_0x8c153d){_0x5857bd({'ret':'OK'});});});});}function insertCmHopper(_0x6688a0,_0x4d5561,_0x22077f,_0x30d045,_0x26da00){var _0x4ea561=['cm_contacts.phone',_0x6290('0x29'),_0x6290('0x2a'),'cm_contacts.ListId',_0x4d5561+'.'+_0x30d045,_0x6290('0x2b'),_0x6290('0x2c'),_0x6290('0x2d'),_0x6290('0x2e'),'\x22'+_0x26da00+'\x22'];return squel['insert']()[_0x6290('0x2f')](_0x6290('0x30'))[_0x6290('0x31')]([_0x6290('0x28'),_0x6290('0x32'),_0x6290('0x33'),_0x6290('0x34'),_0x30d045,'createdAt',_0x6290('0x35'),'priority','UserId',_0x6290('0x36')],squel[_0x6290('0xe')]()[_0x6290('0x37')](_0x4ea561)[_0x6290('0x10')](_0x4d5561)['join'](_0x6290('0x38'),null,_0x6290('0x39')+_0x4d5561+_0x6290('0x3a'))[_0x6290('0x15')](_0x22077f,null,_0x22077f+_0x6290('0x11')+_0x4d5561+'.'+_0x30d045)[_0x6290('0x13')](_0x4d5561+_0x6290('0x3b'),_0x6688a0)[_0x6290('0x13')](_0x6290('0x3c'),NOW)['where'](_0x6290('0x3d'),selectNotIn(_0x4d5561,_0x22077f,_0x30d045,'cm_hopper',['\x22always\x22',_0x6290('0x3e')]))[_0x6290('0x13')](_0x6290('0x3d'),selectNotIn(_0x4d5561,_0x22077f,_0x30d045,_0x6290('0x30'),[_0x6290('0x3f')])))['toString']();}function insertCmHopperBlack(_0x5cbb6f,_0x278c5a,_0xfaa27e,_0x464347){var _0x308752=[_0x6290('0x40'),_0x6290('0x2a'),_0x6290('0x41'),_0x278c5a+'.'+_0x464347,'cm_contacts.createdAt',_0x6290('0x2c')];return squel[_0x6290('0x42')]()[_0x6290('0x2f')](_0x6290('0x43'))[_0x6290('0x31')]([_0x6290('0x28'),_0x6290('0x33'),_0x6290('0x34'),_0x464347,_0x6290('0x44'),_0x6290('0x35')],squel['select']()[_0x6290('0x37')](_0x308752)[_0x6290('0x10')](_0x278c5a)[_0x6290('0x15')]('cm_contacts',null,_0x6290('0x39')+_0x278c5a+'.CmListId')['join'](_0xfaa27e,null,_0xfaa27e+_0x6290('0x11')+_0x278c5a+'.'+_0x464347)[_0x6290('0x13')](_0x278c5a+'.CmListId\x20=\x20?',_0x5cbb6f)[_0x6290('0x13')]('cm_contacts.createdAt\x20=\x20?',NOW)[_0x6290('0x13')]('cm_contacts.phone\x20NOT\x20IN\x20(?)',squel[_0x6290('0xe')]()['field'](_0x6290('0x28'))[_0x6290('0x10')](_0x6290('0x43'))[_0x6290('0x13')](_0x6290('0x45'),_0x5cbb6f)[_0x6290('0x13')](_0x464347+'\x20=\x20?',_0x278c5a+'.'+_0x464347)))[_0x6290('0x46')]();}function insertCmHopperAdditionalPhones(_0x298571){var _0x56c138=['cm_hopper.id',_0x6290('0x47'),_0x6290('0x48'),_0x6290('0x49'),'cm_contact_has_items.updatedAt'];return squel['insert']()[_0x6290('0x2f')](_0x6290('0x4a'))['fromQuery'](['CmHopperId',_0x6290('0x28'),_0x6290('0x4b'),_0x6290('0x44'),_0x6290('0x35')],squel[_0x6290('0xe')]()[_0x6290('0x37')](_0x56c138)['from'](_0x6290('0x30'))[_0x6290('0x15')](_0x6290('0x38'),null,_0x6290('0x4c'))[_0x6290('0x15')](_0x6290('0x4d'),null,_0x6290('0x4e'))['where'](_0x6290('0x4f'),_0x298571)[_0x6290('0x13')](_0x6290('0x3c'),NOW))['toString']();}function insertCmContact(_0x1f9f4a,_0x2c01d2,_0x474619,_0x3aab53){var _0xb66bbb=_[_0x6290('0x50')](_[_0x6290('0x51')](_0x3aab53),[_0x6290('0x34'),'CompanyId','createdAt',_0x6290('0x35')]);return squel[_0x6290('0x42')]()[_0x6290('0x2f')](_0x6290('0x38'))[_0x6290('0x31')](_0xb66bbb,squel[_0x6290('0xe')]()['fields'](_0xb66bbb)[_0x6290('0x10')](_0x2c01d2)['where']('('+_0x474619[_0x6290('0x15')](',')+_0x6290('0x52'),squel[_0x6290('0xe')]()['fields'](_0x474619)[_0x6290('0x10')](_0x6290('0x38'))[_0x6290('0x13')]('ListId\x20=\x20?',_0x1f9f4a))[_0x6290('0x13')](_0x6290('0x53'),squel[_0x6290('0xe')]()[_0x6290('0xf')](_0x6290('0x54'),'min_id')[_0x6290('0x10')](_0x2c01d2)[_0x6290('0x55')](_0x474619[_0x6290('0x15')](','))))[_0x6290('0x46')]();}function handleStop(){logger[_0x6290('0x56')](_0x6290('0x57'));stopped=!![];}function handleUncaughtException(_0x30e9de){logger[_0x6290('0x58')](_0x30e9de['message']);process[_0x6290('0x59')](0x1);}function handleError(_0x3c986f,_0x46133f){stats[_0x6290('0x5a')]['push']({'name':_0x46133f[_0x6290('0x5b')],'message':_0x46133f[_0x6290('0x1e')],'row':_0x3c986f});}function handleQuery(_0x5ae9e2){logger[_0x6290('0x56')](_0x5ae9e2);return db[_0x6290('0x16')][_0x6290('0x5c')](_0x5ae9e2)[_0x6290('0x5d')](function(_0x596b17){results[_0x6290('0x1b')](_0x596b17);})['catch'](function(_0x4c499e){logger[_0x6290('0x58')](_0x4c499e[_0x6290('0x1e')]);});}function main(_0x49bde1,_0x12b527,_0x5dba8b,_0x1c16b5){logger['info']('main',_0x49bde1,JSON[_0x6290('0x5e')](_0x12b527));process[_0x6290('0x5f')](_0x6290('0x60'));var _0x10461e=_0x12b527['binding'];var _0x11a3f3=_['clone'](_0x10461e);var _0x3de687=_0x12b527['socket_timestamp'];var _0x36e1f2=path[_0x6290('0x15')](config[_0x6290('0x61')],_0x6290('0x62'),_0x3de687+_0x6290('0x63'));logger[_0x6290('0x56')](_0x6290('0x64'),_0x12b527);db['ContactItemType'][_0x6290('0x65')]({'raw':!![],'attributes':['id',_0x6290('0x66')]})['then'](function(_0x24da9a){for(var _0x4bfe96=0x0;_0x4bfe96<_0x24da9a[_0x6290('0x18')];_0x4bfe96++){if(_0x24da9a[_0x4bfe96][_0x6290('0x66')]in _0x10461e){contactItemTypes[_0x6290('0x1b')](_0x24da9a[_0x4bfe96]);delete _0x11a3f3[_0x24da9a[_0x4bfe96]['name']];hasAdditionalPhones=!![];}for(var _0x3a2912 in _0x10461e){if(_0x24da9a[_0x4bfe96][_0x6290('0x66')]+_0x6290('0x67')===_0x3a2912){phoneDescriptions[_0x6290('0x1b')]({'itemTypeId':_0x24da9a[_0x4bfe96]['id'],'description':_0x3a2912});delete _0x11a3f3[_0x3a2912];}}}if(hasAdditionalPhones)_0x11a3f3['AdditionalPhones']='';var _0x39147e=_['keys'](_0x11a3f3)[_0x6290('0x15')]();logger[_0x6290('0x56')](_0x6290('0x68'),_0x39147e);fs[_0x6290('0x69')](_0x36e1f2,_0x39147e+'\x0a');Papa[_0x6290('0x6a')](fs[_0x6290('0x6b')](_0x49bde1),{'header':!![],'skipEmptyLines':!![],'step':function(_0x4b1239,_0x4d55b7){try{for(var _0x8c9d29=0x0,_0x25c731=[];_0x8c9d29<_0x4b1239[_0x6290('0x6c')][_0x6290('0x18')];_0x8c9d29++){stats[_0x6290('0x6d')]+=0x1;if(_0x4b1239['errors'][_0x8c9d29]){handleError(_0x4b1239[_0x6290('0x6c')][_0x8c9d29],_0x4b1239[_0x6290('0x5a')][_0x8c9d29]);}else{var _0x561e31=[];var _0x4d4cfa=[];var _0x275c49={};for(var _0x265b38 in _0x10461e){let _0x366d4e=contactItemTypes[_0x6290('0x6e')](_0x284d42=>_0x284d42[_0x6290('0x66')]===_0x265b38);let _0x4a01b1=contactItemTypes[_0x6290('0x6e')](_0x181244=>_0x181244[_0x6290('0x66')]+_0x6290('0x67')===_0x265b38);if(_['isNil'](_0x366d4e)&&_[_0x6290('0x19')](_0x4a01b1)){if(_0x10461e[_0x6290('0x6f')](_0x265b38)){if(_0x4b1239[_0x6290('0x6c')][_0x8c9d29][_0x10461e[_0x265b38]]){var _0xdd9408=_[_0x6290('0x70')](_0x4b1239[_0x6290('0x6c')][_0x8c9d29][_0x10461e[_0x265b38]][_0x6290('0x71')](/"/g,'\x27'));switch(_0x265b38){case _0x6290('0x32'):var _0x43a16d=moment(_0xdd9408,_0x6290('0x9'),!![]);if(_0x43a16d[_0x6290('0x72')]()){_0x25c731['push']('\x22'+_0xdd9408+'\x22');}else{_0x561e31[_0x6290('0x1b')](_0x6290('0x73'));}break;case _0x6290('0x74'):var _0x30371f=parseInt(_0xdd9408);_0xdd9408=_[_0x6290('0x75')](_0x30371f)||_0x30371f<0x0||_0x30371f>0x4?_0x1c16b5?0x3:0x2:_0x30371f;_0x25c731[_0x6290('0x1b')]('\x22'+_0xdd9408+'\x22');break;case'UserId':var _0x245ad7=parseInt(_0xdd9408);if(_[_0x6290('0x76')](_0x245ad7)&&_[_0x6290('0x77')](_0x5dba8b,_0x245ad7)){_0x25c731[_0x6290('0x1b')]('\x22'+_0x245ad7+'\x22');}else{_0x561e31['push'](_0x6290('0x78'));}break;case _0x6290('0x79'):if(isEmail(_0xdd9408)){_0x25c731[_0x6290('0x1b')]('\x22'+_0xdd9408+'\x22');}else{_0x561e31[_0x6290('0x1b')]('email\x20wrong\x20format');}break;case _0x6290('0x7a'):var _0x1d7b8d=moment(_0xdd9408,'YYYY-MM-DD',!![]);if(_0x1d7b8d['isValid']()){_0x25c731[_0x6290('0x1b')]('\x22'+_0xdd9408+'\x22');}else{_0x561e31[_0x6290('0x1b')](_0x6290('0x7b'));}break;default:_0x25c731[_0x6290('0x1b')]('\x22'+_0xdd9408+'\x22');}}else{switch(_0x265b38){case _0x6290('0x7c'):case _0x6290('0x28'):_0x561e31[_0x6290('0x1b')](_0x265b38+_0x6290('0x7d'));break;default:_0x25c731[_0x6290('0x1b')]('\x22\x22');}}}}else{var _0x411fb3='';if(!_[_0x6290('0x19')](_0x366d4e)){if(!_0x275c49[_0x6290('0x6f')](_0x366d4e['id'])){for(var _0x43381d=0x0;_0x43381d<_0x10461e[_0x265b38][_0x6290('0x18')];_0x43381d++){var _0xdd9408=_[_0x6290('0x70')](_0x4b1239[_0x6290('0x6c')][_0x8c9d29][_0x10461e[_0x265b38][_0x43381d]]['replace'](/"/g,'\x27'));var _0x1ce880=phoneDescriptions['find'](_0x3964c6=>_0x3964c6[_0x6290('0x7e')]===_0x366d4e['id']);if(!_[_0x6290('0x19')](_0x1ce880)){var _0x348470=_['trim'](_0x4b1239['data'][_0x8c9d29][_0x10461e[_0x1ce880['description']][0x0]][_0x6290('0x71')](/"/g,'\x27'));if(!_[_0x6290('0x19')](_0x348470))_0xdd9408=_0xdd9408+'§'+_0x348470;}if(_0x411fb3=='')_0x411fb3=_0xdd9408;else _0x411fb3+='|'+_0xdd9408;}_0x4d4cfa[_0x6290('0x1b')](_0x366d4e['id']+':'+_0x411fb3);_0x275c49[_0x366d4e['id']]=0x1;}}}}if(hasAdditionalPhones){_0x25c731[_0x6290('0x1b')]('\x22'+_0x4d4cfa[_0x6290('0x15')](';')+'\x22');}if(_0x561e31[_0x6290('0x18')]){handleError(_0x4b1239[_0x6290('0x6c')][_0x8c9d29],{'code':_0x6290('0x7f'),'message':_0x561e31[_0x6290('0x15')]()});}else{fs[_0x6290('0x80')](_0x36e1f2,_0x25c731[_0x6290('0x15')]()+'\x0a');}_0x25c731=[];}if(!(stats[_0x6290('0x6d')]%0xc8)){socket['emit'](_0x6290('0x81')+_0x3de687,stats);stats[_0x6290('0x5a')]=[];}}if(stopped){logger[_0x6290('0x56')](_0x6290('0x82'));_0x4d55b7[_0x6290('0x83')]();}}catch(_0x489a48){handleError(_0x4b1239['data'][_0x8c9d29],{'code':_0x6290('0x84'),'message':_0x489a48[_0x6290('0x1e')]});logger[_0x6290('0x58')](_0x6290('0x85'),_0x489a48['message']);}},'complete':function(){try{var _0x24bf97=[];var _0x4436f4=tempTableName;_0x24bf97[_0x6290('0x1b')](_0x6290('0x86')+_0x4436f4+_0x6290('0x87'));logger[_0x6290('0x56')](_0x6290('0x88'),contactItemTypes['length']);var _0x13a47f=util[_0x6290('0xb')]('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\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27',_0x36e1f2,_0x4436f4,_0x39147e,_0x12b527[_0x6290('0x34')],_0x12b527[_0x6290('0x89')]||null,NOW,NOW);if(_[_0x6290('0x19')](_0x10461e[_0x6290('0x32')])){_0x13a47f+=_0x6290('0x8a');}_0x24bf97[_0x6290('0x1b')](_0x13a47f);BPromise[_0x6290('0x8b')](_0x24bf97,handleQuery)[_0x6290('0x1c')](function(_0x5c56f6){BPromise[_0x6290('0x20')]([handleAdditionalPhones()])[_0x6290('0x1c')](function(){_0x24bf97=[];for(var _0x332658=0x0;_0x332658<promisesContact[_0x6290('0x18')];_0x332658++){_0x24bf97[_0x6290('0x1b')](updateContact(promisesContact[_0x332658]['contact']));}BPromise[_0x6290('0x20')](_0x24bf97)[_0x6290('0x1c')](function(){_0x24bf97=[];for(var _0x3c8c86=0x0;_0x3c8c86<promisesAdditionalPhones[_0x6290('0x18')];_0x3c8c86++){_0x24bf97[_0x6290('0x1b')](createAdditionalPhone(promisesAdditionalPhones[_0x3c8c86][_0x6290('0x8c')],promisesAdditionalPhones[_0x3c8c86]['contactTypeId'],promisesAdditionalPhones[_0x3c8c86]['phone'],promisesAdditionalPhones[_0x3c8c86][_0x6290('0x8d')]));}BPromise[_0x6290('0x20')](_0x24bf97)[_0x6290('0x1c')](function(){_0x24bf97=[];_0x24bf97[_0x6290('0x1b')](insertCmHopperAdditionalPhones(_0x12b527[_0x6290('0x34')]));_0x24bf97[_0x6290('0x1b')]('DROP\x20TABLE\x20'+_0x4436f4+';');BPromise['each'](_0x24bf97,handleQuery)[_0x6290('0x1c')](function(_0x24749a){stats['finish']=!![];stats[_0x6290('0x8e')]=updatedRows;socket[_0x6290('0x8f')](_0x6290('0x81')+_0x3de687,stats);fs[_0x6290('0x90')](_0x49bde1);fs['unlink'](_0x36e1f2);process[_0x6290('0x59')](0x0);})[_0x6290('0x1d')](function(_0x34b2d8){logger[_0x6290('0x58')](_0x34b2d8['message']);process[_0x6290('0x59')](0x1);});});});});})[_0x6290('0x1d')](function(_0x1c82a0){logger[_0x6290('0x58')](_0x1c82a0['message']);process[_0x6290('0x59')](0x1);});}catch(_0x1e8b25){logger[_0x6290('0x58')]('complete',_0x1e8b25[_0x6290('0x1e')]);process[_0x6290('0x59')](0x1);}},'error':function(_0x4ac10c,_0x253e28,_0xc0cb3c,_0x3d6427){throw new Error(_0x3d6427);}});});}function validate(){if(process[_0x6290('0x91')]&&process[_0x6290('0x91')]['length']<0x4){throw new Error('arguments\x20<filename>\x20<parameters>\x20<agents>');}var _0x37c276=path['join'](config[_0x6290('0x61')],_0x6290('0x62'),process[_0x6290('0x91')][0x2]);if(!fs[_0x6290('0x92')](_0x37c276)){throw new Error(_0x6290('0x93'));}var _0x2da8b5={};try{_0x2da8b5=JSON[_0x6290('0x6a')](process[_0x6290('0x91')][0x3]);if(!_0x2da8b5[_0x6290('0x94')]){throw new Error('binding\x20doesn\x27t\x20exists');}var _0x4a8658=0x0;if(_0x2da8b5['binding'][_0x6290('0x95')]){_0x4a8658=0x1;}if(!_0x2da8b5[_0x6290('0x34')]){throw new Error(_0x6290('0x96'));}}catch(_0x304cbe){throw new Error(_0x6290('0x97'));}var _0x4a1a63=[];try{_0x4a1a63=_[_0x6290('0x98')](JSON['parse'](process[_0x6290('0x91')][0x4]),'id');}catch(_0x2119de){logger['info'](_0x6290('0x99'));}main(_0x37c276,_0x2da8b5,_0x4a1a63,_0x4a8658);}validate();process['on'](_0x6290('0x9a'),handleStop);process['on'](_0x6290('0x9b'),handleUncaughtException);
\ No newline at end of file
+var _0x7a40=['cm_contacts.ListId','cm_contacts.updatedAt','cm_contacts.UserId','insert','into','cm_hopper','fromQuery','scheduledat','ContactId','createdAt','priority','UserId','recallme','select','fields','cm_contacts.ListId\x20=\x20','.CmListId','.id\x20=\x20','.CmListId\x20=\x20?','cm_contacts.createdAt\x20=\x20?','cm_contacts.phone\x20NOT\x20IN\x20(?)','\x22always\x22','\x22onlyIfOpen\x22','toString','cm_contacts.phone','cm_contacts.createdAt','cm_hopper_black','ListId','updatedAt','cm_contacts','ListId\x20=\x20?','cm_hopper.id','cm_contact_has_items.OrderBy','cm_contact_has_items.updatedAt','cm_hopper_additional_phones','CmHopperId','cm_contacts.id\x20=\x20cm_hopper.ContactId','cm_contacts.id\x20=\x20cm_contact_has_items.CmContactId','cm_hopper.ListId\x20=\x20?','concat','keys',')\x20NOT\x20IN\x20?','MIN(id)','group','info','Received\x20SIGINT','exit','errors','catch','stringify','send','binding','clone','socket_timestamp','root','server/files/tmp','.csv','body','findAll','name','_description','header','writeFileSync','parse','data','rows','find','hasOwnProperty','replace','isValid','isNaN','isNumber','includes','email','email\x20wrong\x20format','dateOfBirth','dateOfBirth\x20wrong\x20format\x20(YYYY-MM-DD)','firstName','\x20not\x20specified','itemTypeId','trim','description','SystemRow','emit','Abort\x20parser','abort','SystemError','step','CIS\x20len','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\x20ListId\x20=\x20%s,\x20CompanyId\x20=\x20%s,\x20createdAt\x20=\x20\x27%s\x27,\x20updatedAt\x20=\x20\x27%s\x27','CompanyId',',\x20scheduledAt\x20=\x20NOW()','each','all','contactId','orderBy','finish','affectedRows','contact:import:','unlink','argv','arguments\x20<filename>\x20<parameters>\x20<agents>','existsSync','file\x20doesn\x27t\x20exists','binding\x20doesn\x27t\x20exists','ListId\x20is\x20mandatory','No\x20agent\x20available','path','lodash','papaparse','bluebird','moment','squel','ioredis','../../../mysqldb','../../../config/logger','import','redis','defaults','socket.io-emitter','format','YYYYMMDDHHmmss','field','phone','from','join','where','\x20=\x20','sequelize','query','select\x20*\x20from\x20','spread','isNil','AdditionalPhones','push','error','message','split','length','filter','CmContactHasItem','then','updated','PHONE','inserted','CmContact','update','CmHopper','cm_contacts.scheduledat','cm_contacts.id'];(function(_0x3c5e8b,_0x17513d){var _0x1784b6=function(_0x31cb23){while(--_0x31cb23){_0x3c5e8b['push'](_0x3c5e8b['shift']());}};_0x1784b6(++_0x17513d);}(_0x7a40,0x197));var _0x07a4=function(_0x22e9a1,_0x1d3a53){_0x22e9a1=_0x22e9a1-0x0;var _0x5bff12=_0x7a40[_0x22e9a1];return _0x5bff12;};'use strict';var fs=require('fs');var path=require(_0x07a4('0x0'));var _=require(_0x07a4('0x1'));var Papa=require(_0x07a4('0x2'));var util=require('util');var BPromise=require(_0x07a4('0x3'));var moment=require(_0x07a4('0x4'));var squel=require(_0x07a4('0x5'));var Redis=require(_0x07a4('0x6'));var db=require(_0x07a4('0x7'))['db'];var config=require('../../../config/environment');var logger=require(_0x07a4('0x8'))(_0x07a4('0x9'));config[_0x07a4('0xa')]=_[_0x07a4('0xb')](config[_0x07a4('0xa')],{'host':'localhost','port':0x18eb});var socket=require(_0x07a4('0xc'))(new Redis(config[_0x07a4('0xa')]));var stats={'finish':![],'errors':[],'rows':0x0,'affectedRows':0x0};var results=[];var promisesAdditionalPhones=[];var promisesContact=[];var orderBy=0x0;var updatedRows=0x0;var stopped=![];var NOW=moment()[_0x07a4('0xd')]('YYYY-MM-DD\x20HH:mm:ss');var tempTableName='cm_contacts_temp_'+moment()[_0x07a4('0xd')](_0x07a4('0xe'));var contactItemTypes=[];var phoneDescriptions=[];var hasAdditionalPhones=![];function isEmail(_0x495e43){return/^([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x22([^\x0d\x22\x5c\x80-\xff]|\x5c[\x00-\x7f])*\x22)(\x2e([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x22([^\x0d\x22\x5c\x80-\xff]|\x5c[\x00-\x7f])*\x22))*\x40([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x5b([^\x0d\x5b-\x5d\x80-\xff]|\x5c[\x00-\x7f])*\x5d)(\x2e([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x5b([^\x0d\x5b-\x5d\x80-\xff]|\x5c[\x00-\x7f])*\x5d))*$/['test'](_0x495e43);}function selectNotIn(_0x3ce657,_0x52e8ce,_0x44342a,_0x56b2e2,_0x77165b){return squel['select']()[_0x07a4('0xf')](_0x07a4('0x10'))[_0x07a4('0x11')](_0x56b2e2)[_0x07a4('0x12')](_0x52e8ce,null,_0x52e8ce+'.id\x20=\x20'+_0x56b2e2+'.'+_0x44342a)[_0x07a4('0x13')](_0x56b2e2+'.'+_0x44342a+_0x07a4('0x14')+_0x3ce657+'.'+_0x44342a)[_0x07a4('0x13')](_0x52e8ce+'.dialCheckDuplicateType\x20IN\x20('+_0x77165b[_0x07a4('0x12')]()+')');}function handleAdditionalPhones(){return new Promise(function(_0x4c1893,_0x2af9c7){promisesAdditionalPhones=[];promisesContact=[];return db[_0x07a4('0x15')][_0x07a4('0x16')](_0x07a4('0x17')+tempTableName)[_0x07a4('0x18')](function(_0x97372b){if(_0x97372b!==null){var _0x2c5481=[];for(var _0x42443d=0x0;_0x42443d<_0x97372b['length'];_0x42443d++){var _0x3777ae=_0x97372b[_0x42443d];if(!_[_0x07a4('0x19')](_0x3777ae[_0x07a4('0x10')])){if(!_[_0x07a4('0x19')](_0x3777ae[_0x07a4('0x1a')]))_0x2c5481['push'](insertAdditionalPhones(_0x3777ae));promisesContact[_0x07a4('0x1b')]({'contact':_0x3777ae});}}}Promise['all'](_0x2c5481)['then'](function(){_0x4c1893({'val':0x1});});})['catch'](function(_0x417fda){logger[_0x07a4('0x1c')](_0x417fda[_0x07a4('0x1d')]);});});}function insertAdditionalPhones(_0x4d8450){return new Promise(function(_0x2dcb30,_0x464a98){var _0x1090e9=_0x4d8450[_0x07a4('0x1a')];if(_[_0x07a4('0x19')](_0x1090e9))_0x464a98({'val':0x0});else{var _0x162367=_0x1090e9[_0x07a4('0x1e')](';');var _0x38a411=[];orderBy=0x0;for(var _0xdea92f=0x0;_0xdea92f<_0x162367['length'];_0xdea92f++){_0x38a411[_0x07a4('0x1b')](splitAdditionalPhone(_0x4d8450['id'],_0x162367[_0xdea92f]));}Promise['all'](_0x38a411)['then'](function(){_0x2dcb30({'val':_0x162367[_0x07a4('0x1f')]});});}});}function splitAdditionalPhone(_0x36760b,_0x34b133){return new Promise(function(_0x4bb70f,_0x223dd2){var _0x1287ab=_0x34b133[_0x07a4('0x1e')](':');var _0x16a84a=_0x1287ab[0x0];var _0x517ae2=_0x1287ab[0x1];if(_0x517ae2!==''){var _0x364700=_0x517ae2['split']('|');var _0x955cee=[];for(var _0x2b2cb9=0x0;_0x2b2cb9<_0x364700[_0x07a4('0x1f')];_0x2b2cb9++){if(_0x364700[_0x2b2cb9]!==''){var _0x4a0b36=_[_0x07a4('0x20')](promisesAdditionalPhones,{'contactId':_0x36760b,'phone':_0x364700[_0x2b2cb9]});if(_0x4a0b36['length']==0x0){orderBy++;promisesAdditionalPhones[_0x07a4('0x1b')]({'contactId':_0x36760b,'contactTypeId':_0x16a84a,'phone':_0x364700[_0x2b2cb9],'orderBy':orderBy});}}}_0x4bb70f({'ok':0x1});}else _0x4bb70f({'res':0x0});});}function createAdditionalPhone(_0x52e6e2,_0x570232,_0x5593b9,_0x11e048){var _0x425802='';var _0x154676='';var _0x51e6ff=_0x5593b9[_0x07a4('0x1e')]('§');_0x425802=_0x51e6ff[0x0];if(_0x51e6ff['length']==0x2)_0x154676=_0x51e6ff[0x1];return new Promise(function(_0x30313b,_0x1dcdf7){return db[_0x07a4('0x21')]['findOne']({'where':{'CmContactId':_0x52e6e2,'item':_0x425802}})[_0x07a4('0x22')](function(_0x4d9308){if(_0x4d9308){return db['CmContactHasItem']['update']({'ItemTypeId':_0x570232,'description':_0x154676,'OrderBy':_0x11e048},{'where':{'CmContactId':_0x52e6e2,'item':_0x425802}})[_0x07a4('0x22')](function(_0x440b65){_0x30313b({'res':_0x07a4('0x23')});});}else{return db['CmContactHasItem']['create']({'CmContactId':_0x52e6e2,'item':_0x425802,'ItemTypeId':_0x570232,'description':_0x154676,'OrderBy':_0x11e048,'ItemClass':_0x07a4('0x24')})[_0x07a4('0x22')](function(_0x455cc2){_0x30313b({'res':_0x07a4('0x25')});});}});});}function updateContact(_0xa42c7e){return new Promise(function(_0x4878e0,_0x40d338){var _0x546443=_0xa42c7e['id'];delete _0xa42c7e['id'];return db[_0x07a4('0x26')][_0x07a4('0x27')](_0xa42c7e,{'where':{'id':_0x546443}})[_0x07a4('0x22')](function(_0x3400bd){updatedRows+=0x1;return db[_0x07a4('0x28')][_0x07a4('0x27')]({'phone':_0xa42c7e['phone']},{'where':{'ContactId':_0x546443}})['then'](function(_0x4cd280){_0x4878e0({'ret':'OK'});});});});}function insertCmHopper(_0x1d15ea,_0x7f74ea,_0x47e3ce,_0x2b1f3c,_0x449836){var _0x338951=['cm_contacts.phone',_0x07a4('0x29'),_0x07a4('0x2a'),_0x07a4('0x2b'),_0x7f74ea+'.'+_0x2b1f3c,'cm_contacts.createdAt',_0x07a4('0x2c'),'cm_contacts.priority',_0x07a4('0x2d'),'\x22'+_0x449836+'\x22'];return squel[_0x07a4('0x2e')]()[_0x07a4('0x2f')](_0x07a4('0x30'))[_0x07a4('0x31')]([_0x07a4('0x10'),_0x07a4('0x32'),_0x07a4('0x33'),'ListId',_0x2b1f3c,_0x07a4('0x34'),'updatedAt',_0x07a4('0x35'),_0x07a4('0x36'),_0x07a4('0x37')],squel[_0x07a4('0x38')]()[_0x07a4('0x39')](_0x338951)[_0x07a4('0x11')](_0x7f74ea)['join']('cm_contacts',null,_0x07a4('0x3a')+_0x7f74ea+_0x07a4('0x3b'))['join'](_0x47e3ce,null,_0x47e3ce+_0x07a4('0x3c')+_0x7f74ea+'.'+_0x2b1f3c)[_0x07a4('0x13')](_0x7f74ea+_0x07a4('0x3d'),_0x1d15ea)['where'](_0x07a4('0x3e'),NOW)[_0x07a4('0x13')](_0x07a4('0x3f'),selectNotIn(_0x7f74ea,_0x47e3ce,_0x2b1f3c,_0x07a4('0x30'),[_0x07a4('0x40'),_0x07a4('0x41')]))[_0x07a4('0x13')](_0x07a4('0x3f'),selectNotIn(_0x7f74ea,_0x47e3ce,_0x2b1f3c,_0x07a4('0x30'),[_0x07a4('0x40')])))[_0x07a4('0x42')]();}function insertCmHopperBlack(_0xedc859,_0x213d38,_0x5def49,_0x109450){var _0x311f17=[_0x07a4('0x43'),'cm_contacts.id','cm_contacts.ListId',_0x213d38+'.'+_0x109450,_0x07a4('0x44'),_0x07a4('0x2c')];return squel[_0x07a4('0x2e')]()[_0x07a4('0x2f')](_0x07a4('0x45'))[_0x07a4('0x31')](['phone',_0x07a4('0x33'),_0x07a4('0x46'),_0x109450,'createdAt',_0x07a4('0x47')],squel['select']()[_0x07a4('0x39')](_0x311f17)[_0x07a4('0x11')](_0x213d38)[_0x07a4('0x12')](_0x07a4('0x48'),null,_0x07a4('0x3a')+_0x213d38+_0x07a4('0x3b'))['join'](_0x5def49,null,_0x5def49+_0x07a4('0x3c')+_0x213d38+'.'+_0x109450)[_0x07a4('0x13')](_0x213d38+'.CmListId\x20=\x20?',_0xedc859)[_0x07a4('0x13')](_0x07a4('0x3e'),NOW)[_0x07a4('0x13')](_0x07a4('0x3f'),squel['select']()[_0x07a4('0xf')](_0x07a4('0x10'))[_0x07a4('0x11')](_0x07a4('0x45'))[_0x07a4('0x13')](_0x07a4('0x49'),_0xedc859)[_0x07a4('0x13')](_0x109450+'\x20=\x20?',_0x213d38+'.'+_0x109450)))['toString']();}function insertCmHopperAdditionalPhones(_0x57c9ff){var _0x56c09a=[_0x07a4('0x4a'),'cm_contact_has_items.item',_0x07a4('0x4b'),'cm_contact_has_items.createdAt',_0x07a4('0x4c')];return squel[_0x07a4('0x2e')]()[_0x07a4('0x2f')](_0x07a4('0x4d'))[_0x07a4('0x31')]([_0x07a4('0x4e'),_0x07a4('0x10'),'OrderBy',_0x07a4('0x34'),_0x07a4('0x47')],squel['select']()[_0x07a4('0x39')](_0x56c09a)[_0x07a4('0x11')](_0x07a4('0x30'))[_0x07a4('0x12')](_0x07a4('0x48'),null,_0x07a4('0x4f'))[_0x07a4('0x12')]('cm_contact_has_items',null,_0x07a4('0x50'))['where'](_0x07a4('0x51'),_0x57c9ff)[_0x07a4('0x13')](_0x07a4('0x3e'),NOW))['toString']();}function insertCmContact(_0x20e06f,_0x13134b,_0x595a27,_0x191b9e){var _0xa1b8e3=_[_0x07a4('0x52')](_[_0x07a4('0x53')](_0x191b9e),['ListId','CompanyId',_0x07a4('0x34'),_0x07a4('0x47')]);return squel[_0x07a4('0x2e')]()[_0x07a4('0x2f')]('cm_contacts')[_0x07a4('0x31')](_0xa1b8e3,squel[_0x07a4('0x38')]()[_0x07a4('0x39')](_0xa1b8e3)[_0x07a4('0x11')](_0x13134b)[_0x07a4('0x13')]('('+_0x595a27[_0x07a4('0x12')](',')+_0x07a4('0x54'),squel['select']()[_0x07a4('0x39')](_0x595a27)[_0x07a4('0x11')](_0x07a4('0x48'))['where'](_0x07a4('0x49'),_0x20e06f))[_0x07a4('0x13')]('id\x20IN\x20?',squel[_0x07a4('0x38')]()['field'](_0x07a4('0x55'),'min_id')[_0x07a4('0x11')](_0x13134b)[_0x07a4('0x56')](_0x595a27[_0x07a4('0x12')](','))))[_0x07a4('0x42')]();}function handleStop(){logger[_0x07a4('0x57')](_0x07a4('0x58'));stopped=!![];}function handleUncaughtException(_0x20197d){logger[_0x07a4('0x1c')](_0x20197d[_0x07a4('0x1d')]);process[_0x07a4('0x59')](0x1);}function handleError(_0x30b10f,_0x5ab336){stats[_0x07a4('0x5a')][_0x07a4('0x1b')]({'name':_0x5ab336['code'],'message':_0x5ab336['message'],'row':_0x30b10f});}function handleQuery(_0x2d79dc){logger['info'](_0x2d79dc);return db['sequelize']['query'](_0x2d79dc)['spread'](function(_0x800cb7){results[_0x07a4('0x1b')](_0x800cb7);})[_0x07a4('0x5b')](function(_0x47df70){logger[_0x07a4('0x1c')](_0x47df70[_0x07a4('0x1d')]);});}function main(_0x55f3f6,_0x86c34f,_0x264836,_0x28b996){logger[_0x07a4('0x57')]('main',_0x55f3f6,JSON[_0x07a4('0x5c')](_0x86c34f));process[_0x07a4('0x5d')]('start');var _0x5a821d=_0x86c34f[_0x07a4('0x5e')];var _0x36253a=_[_0x07a4('0x5f')](_0x5a821d);var _0x9b2144=_0x86c34f[_0x07a4('0x60')];var _0x2608ad=path[_0x07a4('0x12')](config[_0x07a4('0x61')],_0x07a4('0x62'),_0x9b2144+_0x07a4('0x63'));logger[_0x07a4('0x57')](_0x07a4('0x64'),_0x86c34f);db['ContactItemType'][_0x07a4('0x65')]({'raw':!![],'attributes':['id',_0x07a4('0x66')]})['then'](function(_0x484b4b){for(var _0x291ee5=0x0;_0x291ee5<_0x484b4b['length'];_0x291ee5++){if(_0x484b4b[_0x291ee5]['name']in _0x5a821d){contactItemTypes['push'](_0x484b4b[_0x291ee5]);delete _0x36253a[_0x484b4b[_0x291ee5][_0x07a4('0x66')]];hasAdditionalPhones=!![];}for(var _0x23baf2 in _0x5a821d){if(_0x484b4b[_0x291ee5][_0x07a4('0x66')]+_0x07a4('0x67')===_0x23baf2){phoneDescriptions[_0x07a4('0x1b')]({'itemTypeId':_0x484b4b[_0x291ee5]['id'],'description':_0x23baf2});delete _0x36253a[_0x23baf2];}}}if(hasAdditionalPhones)_0x36253a[_0x07a4('0x1a')]='';var _0x4255dd=_[_0x07a4('0x53')](_0x36253a)[_0x07a4('0x12')]();logger[_0x07a4('0x57')](_0x07a4('0x68'),_0x4255dd);fs[_0x07a4('0x69')](_0x2608ad,_0x4255dd+'\x0a');Papa[_0x07a4('0x6a')](fs['createReadStream'](_0x55f3f6),{'header':!![],'skipEmptyLines':!![],'step':function(_0x120662,_0x2003ec){try{for(var _0x4880fc=0x0,_0x4963e1=[];_0x4880fc<_0x120662[_0x07a4('0x6b')][_0x07a4('0x1f')];_0x4880fc++){stats[_0x07a4('0x6c')]+=0x1;if(_0x120662[_0x07a4('0x5a')][_0x4880fc]){handleError(_0x120662[_0x07a4('0x6b')][_0x4880fc],_0x120662[_0x07a4('0x5a')][_0x4880fc]);}else{var _0x2f4e8c=[];var _0x32fe4c=[];var _0x34fd8b={};for(var _0x1b0338 in _0x5a821d){let _0x5acb7d=contactItemTypes[_0x07a4('0x6d')](_0x942ce7=>_0x942ce7[_0x07a4('0x66')]===_0x1b0338);let _0x1f8e24=contactItemTypes[_0x07a4('0x6d')](_0x4437ec=>_0x4437ec[_0x07a4('0x66')]+'_description'===_0x1b0338);if(_['isNil'](_0x5acb7d)&&_[_0x07a4('0x19')](_0x1f8e24)){if(_0x5a821d[_0x07a4('0x6e')](_0x1b0338)){if(_0x120662[_0x07a4('0x6b')][_0x4880fc][_0x5a821d[_0x1b0338]]){var _0x3fdbaf=_['trim'](_0x120662[_0x07a4('0x6b')][_0x4880fc][_0x5a821d[_0x1b0338]][_0x07a4('0x6f')](/"/g,'\x27'));switch(_0x1b0338){case'scheduledat':var _0x5e8739=moment(_0x3fdbaf,'YYYY-MM-DD\x20HH:mm:ss',!![]);if(_0x5e8739[_0x07a4('0x70')]()){_0x4963e1[_0x07a4('0x1b')]('\x22'+_0x3fdbaf+'\x22');}else{_0x2f4e8c[_0x07a4('0x1b')]('scheduledat\x20wrong\x20format\x20(YYYY-MM-DD\x20HH:mm:ss)');}break;case _0x07a4('0x35'):var _0x465c4a=parseInt(_0x3fdbaf);_0x3fdbaf=_[_0x07a4('0x71')](_0x465c4a)||_0x465c4a<0x0||_0x465c4a>0x4?_0x28b996?0x3:0x2:_0x465c4a;_0x4963e1[_0x07a4('0x1b')]('\x22'+_0x3fdbaf+'\x22');break;case _0x07a4('0x36'):var _0x191645=parseInt(_0x3fdbaf);if(_[_0x07a4('0x72')](_0x191645)&&_[_0x07a4('0x73')](_0x264836,_0x191645)){_0x4963e1['push']('\x22'+_0x191645+'\x22');}else{_0x2f4e8c[_0x07a4('0x1b')]('agent\x20not\x20exists');}break;case _0x07a4('0x74'):if(isEmail(_0x3fdbaf)){_0x4963e1[_0x07a4('0x1b')]('\x22'+_0x3fdbaf+'\x22');}else{_0x2f4e8c[_0x07a4('0x1b')](_0x07a4('0x75'));}break;case _0x07a4('0x76'):var _0x132b24=moment(_0x3fdbaf,'YYYY-MM-DD',!![]);if(_0x132b24[_0x07a4('0x70')]()){_0x4963e1['push']('\x22'+_0x3fdbaf+'\x22');}else{_0x2f4e8c[_0x07a4('0x1b')](_0x07a4('0x77'));}break;default:_0x4963e1[_0x07a4('0x1b')]('\x22'+_0x3fdbaf+'\x22');}}else{switch(_0x1b0338){case _0x07a4('0x78'):case _0x07a4('0x10'):_0x2f4e8c['push'](_0x1b0338+_0x07a4('0x79'));break;default:_0x4963e1[_0x07a4('0x1b')]('\x22\x22');}}}}else{var _0x344008='';if(!_['isNil'](_0x5acb7d)){if(!_0x34fd8b[_0x07a4('0x6e')](_0x5acb7d['id'])){for(var _0x278753=0x0;_0x278753<_0x5a821d[_0x1b0338][_0x07a4('0x1f')];_0x278753++){var _0x3fdbaf=_['trim'](_0x120662[_0x07a4('0x6b')][_0x4880fc][_0x5a821d[_0x1b0338][_0x278753]][_0x07a4('0x6f')](/"/g,'\x27'));var _0x1b17fc=phoneDescriptions[_0x07a4('0x6d')](_0x5c15f1=>_0x5c15f1[_0x07a4('0x7a')]===_0x5acb7d['id']);if(!_[_0x07a4('0x19')](_0x1b17fc)){var _0x53fce3=_[_0x07a4('0x7b')](_0x120662[_0x07a4('0x6b')][_0x4880fc][_0x5a821d[_0x1b17fc[_0x07a4('0x7c')]][0x0]][_0x07a4('0x6f')](/"/g,'\x27'));if(!_['isNil'](_0x53fce3))_0x3fdbaf=_0x3fdbaf+'§'+_0x53fce3;}if(_0x344008=='')_0x344008=_0x3fdbaf;else _0x344008+='|'+_0x3fdbaf;}_0x32fe4c['push'](_0x5acb7d['id']+':'+_0x344008);_0x34fd8b[_0x5acb7d['id']]=0x1;}}}}if(hasAdditionalPhones){_0x4963e1['push']('\x22'+_0x32fe4c[_0x07a4('0x12')](';')+'\x22');}if(_0x2f4e8c[_0x07a4('0x1f')]){handleError(_0x120662[_0x07a4('0x6b')][_0x4880fc],{'code':_0x07a4('0x7d'),'message':_0x2f4e8c[_0x07a4('0x12')]()});}else{fs['appendFileSync'](_0x2608ad,_0x4963e1[_0x07a4('0x12')]()+'\x0a');}_0x4963e1=[];}if(!(stats[_0x07a4('0x6c')]%0xc8)){socket[_0x07a4('0x7e')]('contact:import:'+_0x9b2144,stats);stats[_0x07a4('0x5a')]=[];}}if(stopped){logger[_0x07a4('0x57')](_0x07a4('0x7f'));_0x2003ec[_0x07a4('0x80')]();}}catch(_0x59046f){handleError(_0x120662['data'][_0x4880fc],{'code':_0x07a4('0x81'),'message':_0x59046f[_0x07a4('0x1d')]});logger[_0x07a4('0x1c')](_0x07a4('0x82'),_0x59046f[_0x07a4('0x1d')]);}},'complete':function(){try{var _0x364d59=[];var _0x4e5b62=tempTableName;_0x364d59[_0x07a4('0x1b')]('CREATE\x20TABLE\x20'+_0x4e5b62+'\x20LIKE\x20cm_contacts;');logger[_0x07a4('0x57')](_0x07a4('0x83'),contactItemTypes['length']);var _0xe67509=util[_0x07a4('0xd')](_0x07a4('0x84'),_0x2608ad,_0x4e5b62,_0x4255dd,_0x86c34f[_0x07a4('0x46')],_0x86c34f[_0x07a4('0x85')]||null,NOW,NOW);if(_['isNil'](_0x5a821d[_0x07a4('0x32')])){_0xe67509+=_0x07a4('0x86');}_0x364d59[_0x07a4('0x1b')](_0xe67509);BPromise[_0x07a4('0x87')](_0x364d59,handleQuery)[_0x07a4('0x22')](function(_0x4db711){BPromise['all']([handleAdditionalPhones()])['then'](function(){_0x364d59=[];for(var _0x140d7f=0x0;_0x140d7f<promisesContact[_0x07a4('0x1f')];_0x140d7f++){_0x364d59[_0x07a4('0x1b')](updateContact(promisesContact[_0x140d7f]['contact']));}BPromise[_0x07a4('0x88')](_0x364d59)[_0x07a4('0x22')](function(){_0x364d59=[];for(var _0x51c1fc=0x0;_0x51c1fc<promisesAdditionalPhones['length'];_0x51c1fc++){_0x364d59[_0x07a4('0x1b')](createAdditionalPhone(promisesAdditionalPhones[_0x51c1fc][_0x07a4('0x89')],promisesAdditionalPhones[_0x51c1fc]['contactTypeId'],promisesAdditionalPhones[_0x51c1fc][_0x07a4('0x10')],promisesAdditionalPhones[_0x51c1fc][_0x07a4('0x8a')]));}BPromise[_0x07a4('0x88')](_0x364d59)['then'](function(){_0x364d59=[];_0x364d59[_0x07a4('0x1b')](insertCmHopperAdditionalPhones(_0x86c34f[_0x07a4('0x46')]));_0x364d59[_0x07a4('0x1b')]('DROP\x20TABLE\x20'+_0x4e5b62+';');BPromise[_0x07a4('0x87')](_0x364d59,handleQuery)[_0x07a4('0x22')](function(_0x1309d7){stats[_0x07a4('0x8b')]=!![];stats[_0x07a4('0x8c')]=updatedRows;socket['emit'](_0x07a4('0x8d')+_0x9b2144,stats);fs[_0x07a4('0x8e')](_0x55f3f6);fs['unlink'](_0x2608ad);process[_0x07a4('0x59')](0x0);})[_0x07a4('0x5b')](function(_0x5e3c73){logger[_0x07a4('0x1c')](_0x5e3c73['message']);process[_0x07a4('0x59')](0x1);});});});});})[_0x07a4('0x5b')](function(_0x5a475e){logger[_0x07a4('0x1c')](_0x5a475e[_0x07a4('0x1d')]);process[_0x07a4('0x59')](0x1);});}catch(_0x427290){logger[_0x07a4('0x1c')]('complete',_0x427290[_0x07a4('0x1d')]);process[_0x07a4('0x59')](0x1);}},'error':function(_0x5923fe,_0xcc0f8d,_0x4a2f06,_0x335c25){throw new Error(_0x335c25);}});});}function validate(){if(process[_0x07a4('0x8f')]&&process[_0x07a4('0x8f')][_0x07a4('0x1f')]<0x4){throw new Error(_0x07a4('0x90'));}var _0x109b11=path['join'](config['root'],'server/files/tmp',process[_0x07a4('0x8f')][0x2]);if(!fs[_0x07a4('0x91')](_0x109b11)){throw new Error(_0x07a4('0x92'));}var _0x1720d5={};try{_0x1720d5=JSON[_0x07a4('0x6a')](process[_0x07a4('0x8f')][0x3]);if(!_0x1720d5[_0x07a4('0x5e')]){throw new Error(_0x07a4('0x93'));}var _0x337461=0x0;if(_0x1720d5[_0x07a4('0x5e')][_0x07a4('0x36')]){_0x337461=0x1;}if(!_0x1720d5[_0x07a4('0x46')]){throw new Error(_0x07a4('0x94'));}}catch(_0x22adc0){throw new Error('body\x20id\x20mandatory');}var _0x34d484=[];try{_0x34d484=_['map'](JSON[_0x07a4('0x6a')](process[_0x07a4('0x8f')][0x4]),'id');}catch(_0xf2fc8f){logger[_0x07a4('0x57')](_0x07a4('0x95'));}main(_0x109b11,_0x1720d5,_0x34d484,_0x337461);}validate();process['on']('SIGINT',handleStop);process['on']('uncaughtException',handleUncaughtException);
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff