-var _0xfe8d=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x62\x6C\x75\x65\x62\x69\x72\x64","\x64\x62","\x2E\x2E\x2F\x2E\x2E\x2F\x2E\x2E\x2F\x6D\x79\x73\x71\x6C\x64\x62","\x61\x70\x69","\x2E\x2E\x2F\x2E\x2E\x2F\x2E\x2E\x2F\x63\x6F\x6E\x66\x69\x67\x2F\x6C\x6F\x67\x67\x65\x72","\x75\x74\x69\x6C","\x6C\x6F\x64\x61\x73\x68","\x66\x73","\x73\x71\x75\x65\x6C","\x70\x61\x70\x61\x70\x61\x72\x73\x65","\x6C\x6F\x63\x61\x6C\x68\x6F\x73\x74","\x73\x6F\x63\x6B\x65\x74\x2E\x69\x6F\x2D\x65\x6D\x69\x74\x74\x65\x72","\x72\x65\x67\x69\x73\x74\x65\x72","\x2E\x2E\x2F\x2E\x2E\x2F\x2E\x2E\x2F\x61\x70\x69\x2F\x63\x6D\x43\x6F\x6E\x74\x61\x63\x74\x2F\x63\x6D\x43\x6F\x6E\x74\x61\x63\x74\x2E\x73\x6F\x63\x6B\x65\x74","\x61\x72\x67\x76","\x75\x6E\x64\x65\x66\x69\x6E\x65\x64","\x6E\x75\x6C\x6C","\x4D\x69\x73\x73\x69\x6E\x67\x20\x66\x69\x6C\x65\x70\x61\x74\x68\x20\x70\x61\x72\x61\x6D\x65\x74\x65\x72\x21","\x4D\x69\x73\x73\x69\x6E\x67\x20\x62\x69\x6E\x64\x69\x6E\x67\x20\x70\x61\x72\x61\x6D\x65\x74\x65\x72\x73\x21","\x2C","\x73\x70\x6C\x69\x74","\x7A\x69\x70\x4F\x62\x6A\x65\x63\x74","\x4D\x69\x73\x73\x69\x6E\x67\x20\x4C\x69\x73\x74\x49\x64\x20\x70\x61\x72\x61\x6D\x65\x74\x65\x72\x21","\x4D\x69\x73\x73\x69\x6E\x67\x20\x73\x6F\x63\x6B\x65\x74\x5F\x74\x69\x6D\x65\x73\x74\x61\x6D\x70\x20\x70\x61\x72\x61\x6D\x65\x74\x65\x72\x21","\x65\x72\x72\x6F\x72","","\x63\x6F\x6E\x74\x61\x63\x74","\x69\x6E\x64\x65\x78","\x74\x65\x73\x74","\x69\x73\x4E\x69\x6C","\x54\x68\x65\x20\x72\x6F\x77\x20\x69\x73\x20\x65\x6D\x70\x74\x79\x20\x6F\x72\x20\x74\x68\x65\x20\x6E\x75\x6D\x62\x65\x72\x20\x6F\x66\x20\x70\x61\x72\x61\x6D\x65\x74\x65\x72\x73\x20\x64\x6F\x65\x73\x20\x6E\x6F\x74\x20\x6D\x61\x74\x63\x68\x20\x74\x68\x65\x20\x63\x6F\x6C\x75\x6D\x6E\x73\x21","\x65\x72\x72\x6F\x72\x73","\x6C\x65\x6E\x67\x74\x68","\x3B","\x6A\x6F\x69\x6E","\x6D\x65\x73\x73\x61\x67\x65","\x6D\x61\x70","\x68\x61\x73\x4F\x77\x6E\x50\x72\x6F\x70\x65\x72\x74\x79","\x64\x61\x74\x61","\uFEFF","\x66\x69\x72\x73\x74\x4E\x61\x6D\x65","\x66\x69\x72\x73\x74\x4E\x61\x6D\x65\x20\x6E\x6F\x74\x20\x73\x70\x65\x63\x69\x66\x69\x65\x64\x21","\x70\x68\x6F\x6E\x65","\x70\x68\x6F\x6E\x65\x20\x6E\x6F\x74\x20\x73\x70\x65\x63\x69\x66\x69\x65\x64\x21","\x62\x69\x72\x74\x68\x44\x61\x74\x65","\x59\x59\x59\x59\x2D\x4D\x4D\x2D\x44\x44","\x69\x73\x56\x61\x6C\x69\x64","\x62\x69\x72\x74\x68\x44\x61\x74\x65\x20\x66\x6F\x72\x6D\x61\x74\x20\x69\x73\x20\x69\x6E\x76\x61\x6C\x69\x64\x2C\x20\x59\x59\x59\x59\x2D\x4D\x4D\x2D\x44\x44\x20\x66\x6F\x72\x6D\x61\x74\x20\x69\x73\x20\x73\x75\x70\x70\x6F\x72\x74\x65\x64\x21","\x65\x6D\x61\x69\x6C","\x65\x6D\x61\x69\x6C\x20\x66\x6F\x72\x6D\x61\x74\x20\x69\x73\x20\x6E\x6F\x74\x20\x76\x61\x6C\x69\x64\x21","\x4C\x69\x73\x74\x49\x64","\x43\x6F\x6D\x70\x61\x6E\x79\x49\x64","\x66\x69\x6E\x64","\x64\x75\x70\x6C\x69\x63\x61\x74\x65","\x44\x75\x70\x6C\x69\x63\x61\x74\x65\x20\x43\x6F\x6E\x74\x61\x63\x74","\x45\x72\x72\x6F\x72\x20\x77\x68\x69\x6C\x65\x20\x63\x72\x65\x61\x74\x69\x6E\x67\x20\x63\x6F\x6E\x74\x61\x63\x74\x3A\x20","\x73\x74\x72\x69\x6E\x67\x69\x66\x79","\x63\x61\x74\x63\x68","\x70\x69\x63\x6B","\x70\x75\x73\x68","\x69\x64","\x74\x68\x65\x6E","\x6B\x65\x79\x73","\x63\x72\x65\x61\x74\x65","\x43\x6D\x43\x6F\x6E\x74\x61\x63\x74","\x63\x6D\x43\x6F\x6E\x74\x61\x63\x74","\x63\x68\x65\x63\x6B\x48\x6F\x70\x70\x65\x72","\x69\x6E\x73\x70\x65\x63\x74","\x73\x63\x68\x65\x64\x75\x6C\x65\x64\x41\x74","\x43\x6F\x6E\x74\x61\x63\x74\x49\x64","\x63\x72\x65\x61\x74\x65\x64\x41\x74","\x75\x70\x64\x61\x74\x65\x64\x41\x74","\x70\x68\x6F\x6E\x65\x20\x4E\x4F\x54\x20\x49\x4E\x20\x28\x3F\x29","\x20\x3D\x20\x3F","\x77\x68\x65\x72\x65","\x63\x6D\x5F\x68\x6F\x70\x70\x65\x72","\x66\x72\x6F\x6D","\x66\x69\x65\x6C\x64","\x73\x65\x6C\x65\x63\x74","\x70\x68\x6F\x6E\x65\x20\x49\x53\x20\x4E\x4F\x54\x20\x4E\x55\x4C\x4C","\x4C\x69\x73\x74\x49\x64\x20\x3D\x20\x3F","\x64\x65\x6C\x65\x74\x65\x64\x41\x74\x20\x49\x53\x20\x4E\x55\x4C\x4C","\x63\x6D\x5F\x63\x6F\x6E\x74\x61\x63\x74\x73","\x4E\x4F\x57\x28\x29","\x66\x72\x6F\x6D\x51\x75\x65\x72\x79","\x69\x6E\x74\x6F","\x69\x6E\x73\x65\x72\x74","\x63\x6D\x5F\x68\x6F\x70\x70\x65\x72\x5F\x66\x69\x6E\x61\x6C","\x63\x61\x6C\x6C\x65\x72\x69\x64\x6E\x75\x6D","\x69\x64\x20\x49\x4E\x20\x3F","\x73\x74\x72","\x63\x6D\x5F\x68\x6F\x70\x70\x65\x72\x5F\x62\x6C\x61\x63\x6B","\x63\x6D\x43\x6F\x6E\x74\x61\x63\x74\x2C\x20\x25\x73\x2C\x20\x25\x73","\x67\x65\x6E\x65\x72\x61\x6C\x43\x68\x65\x63\x6B\x48\x6F\x70\x70\x65\x72","\x61\x6C\x6C","\x67\x65\x74","\x43\x61\x6D\x70\x61\x69\x67\x6E\x49\x64","\x71\x75\x65\x72\x79","\x73\x65\x71\x75\x65\x6C\x69\x7A\x65","\x43\x6D\x4C\x69\x73\x74","\x42\x6C\x61\x63\x6B\x4C\x69\x73\x74\x73","\x66\x69\x6E\x64\x41\x6C\x6C","\x43\x61\x6D\x70\x61\x69\x67\x6E","\x61\x6C\x77\x61\x79\x73","\x6F\x6E\x6C\x79\x49\x66\x4F\x70\x65\x6E","\x64\x69\x61\x6C\x43\x68\x65\x63\x6B\x44\x75\x70\x6C\x69\x63\x61\x74\x65\x54\x79\x70\x65","\x4C\x69\x73\x74\x73","\x56\x6F\x69\x63\x65\x51\x75\x65\x75\x65\x49\x64","\x6F\x75\x74\x62\x6F\x75\x6E\x64","\x56\x6F\x69\x63\x65\x51\x75\x65\x75\x65","\x63\x6F\x6E\x74\x61\x63\x74\x3A\x63\x73\x76\x5F","\x65\x6D\x69\x74","\x72\x65\x73\x75\x6D\x65","\x66\x69\x6E\x61\x6C\x6C\x79","\x45\x72\x72\x6F\x72\x20\x70\x72\x6F\x63\x65\x73\x73\x69\x6E\x67\x20\x72\x6F\x77\x73\x20\x62\x6C\x6F\x63\x6B\x3A","\x75\x6E\x6C\x69\x6E\x6B\x53\x79\x6E\x63","\x55\x6E\x61\x62\x6C\x65\x20\x74\x6F\x20\x64\x65\x6C\x65\x74\x65\x20\x74\x65\x6D\x70\x20\x66\x69\x6C\x65\x3A","\x65\x78\x69\x74","\x72\x65\x73\x6F\x6C\x76\x65","\x53\x49\x47\x49\x4E\x54","\x43\x53\x56\x20\x69\x6D\x70\x6F\x72\x74\x20\x70\x72\x6F\x63\x65\x73\x73\x20\x73\x74\x6F\x70\x70\x65\x64\x21","\x69\x6E\x66\x6F","\x6F\x6E","\x45\x72\x72\x6F\x72\x20\x65\x78\x65\x63\x75\x74\x69\x6E\x67\x20\x63\x6F\x6E\x74\x61\x63\x74\x20\x63\x73\x76\x20\x69\x6D\x70\x6F\x72\x74\x3A","\x63\x72\x65\x61\x74\x65\x52\x65\x61\x64\x53\x74\x72\x65\x61\x6D","\x70\x61\x75\x73\x65","\x43\x53\x56\x20\x70\x61\x72\x73\x65\x64\x20\x63\x6F\x72\x72\x65\x63\x74\x6C\x79\x21","\x43\x53\x56\x20\x70\x61\x72\x73\x65\x20\x65\x72\x72\x6F\x72","\x70\x61\x72\x73\x65"];_0xfe8d[0];var BPromise=require(_0xfe8d[1]);var db=require(_0xfe8d[3])[_0xfe8d[2]];var logger=require(_0xfe8d[5])(_0xfe8d[4]);var util=require(_0xfe8d[6]);var _=require(_0xfe8d[7]);var fs=require(_0xfe8d[8]);var squel=require(_0xfe8d[9]);var Papa=require(_0xfe8d[10]);var socket=require(_0xfe8d[12])({host:_0xfe8d[11],port:6379});require(_0xfe8d[14])[_0xfe8d[13]](socket);try{if(!process[_0xfe8d[15]][2]|| process[_0xfe8d[15]][2]=== _0xfe8d[16] || process[_0xfe8d[15]][2]=== _0xfe8d[17]){throw new Error(_0xfe8d[18])};var FILEPATH=process[_0xfe8d[15]][2];if(!process[_0xfe8d[15]][3]|| process[_0xfe8d[15]][3]=== _0xfe8d[16] || process[_0xfe8d[15]][3]=== _0xfe8d[17] || !process[_0xfe8d[15]][4] || process[_0xfe8d[15]][4]=== _0xfe8d[16] || process[_0xfe8d[15]][4]=== _0xfe8d[17]){throw new Error(_0xfe8d[19])};var FIELDS=_[_0xfe8d[22]](process[_0xfe8d[15]][3][_0xfe8d[21]](_0xfe8d[20]),process[_0xfe8d[15]][4][_0xfe8d[21]](_0xfe8d[20]));if(!process[_0xfe8d[15]][5]|| process[_0xfe8d[15]][5]=== _0xfe8d[16] || process[_0xfe8d[15]][5]=== _0xfe8d[17]){throw new Error(_0xfe8d[23])};var LISTID=process[_0xfe8d[15]][5];var COMPANYID=(process[_0xfe8d[15]][6]&& process[_0xfe8d[15]][6]!== _0xfe8d[16]&& process[_0xfe8d[15]][6]!== _0xfe8d[17])?process[_0xfe8d[15]][6]:null;var DUPLICATES=(process[_0xfe8d[15]][7]&& process[_0xfe8d[15]][7]!== _0xfe8d[16]&& process[_0xfe8d[15]][7]!== _0xfe8d[17])?process[_0xfe8d[15]][7]:null;if(!process[_0xfe8d[15]][8]|| process[_0xfe8d[15]][8]=== _0xfe8d[16] || process[_0xfe8d[15]][8]=== _0xfe8d[17]){throw new Error(_0xfe8d[24])};var SOCKET_TIMESTAMP=process[_0xfe8d[15]][8]}catch(err){logger[_0xfe8d[25]](err);endCsv()};var total=0;var pTotal=0;var success=0;var errors=0;var duplicates=0;var rows=[];var hopperContacts=_0xfe8d[26];var promises=[];var index=0;var alreadyInvalid=false;function handleCheckRowError(_0x8745x1b,_0x8745x1c,_0x8745x1d,index){var _0x8745x1e={message:_0x8745x1c};_0x8745x1e[_0x8745x1b]= true;if(_0x8745x1d){_0x8745x1e[_0xfe8d[27]]= _0x8745x1d};if(index){_0x8745x1e[_0xfe8d[28]]= index};return _0x8745x1e}function isEmail(_0x8745x20){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))*$/[_0xfe8d[29]](_0x8745x20)}function checkRow(_0x8745x22,_0x8745x23,index){return new BPromise(function(_0x8745x24,_0x8745x25){if(_[_0xfe8d[30]](_0x8745x22)){return _0x8745x25(handleCheckRowError(_0xfe8d[25],_0xfe8d[31],null,index))};if(_0x8745x22[_0xfe8d[32]]&& _0x8745x22[_0xfe8d[32]][_0xfe8d[33]]){var _0x8745x1e=_[_0xfe8d[37]](_0x8745x22[_0xfe8d[32]],_0xfe8d[36])[_0xfe8d[35]](_0xfe8d[34]);return _0x8745x25(handleCheckRowError(_0xfe8d[25],_0x8745x1e,null,index))};var _0x8745x1d={};for(var _0x8745x26 in FIELDS){if(FIELDS[_0xfe8d[38]](_0x8745x26)&& FIELDS[_0x8745x26]){_0x8745x1d[_0x8745x26]= _0x8745x22[_0xfe8d[39]][0][FIELDS[_0x8745x26]]|| _0x8745x22[_0xfe8d[39]][0][_0xfe8d[40]+ FIELDS[_0x8745x26]]}};if(!_0x8745x1d[_0xfe8d[41]]){return _0x8745x25(handleCheckRowError(_0xfe8d[25],_0xfe8d[42],null,index))};if(!_0x8745x1d[_0xfe8d[43]]){return _0x8745x25(handleCheckRowError(_0xfe8d[25],_0xfe8d[44],null,index))};if(_0x8745x1d[_0xfe8d[45]]){var _0x8745x27=moment(_0x8745x1d[_0xfe8d[45]],_0xfe8d[46]);if(!_0x8745x27[_0xfe8d[47]]()){return _0x8745x25(handleCheckRowError(_0xfe8d[25],_0xfe8d[48],null,index))}};if(_0x8745x1d[_0xfe8d[49]]){if(!isEmail(_0x8745x1d[_0xfe8d[49]])){return _0x8745x25(handleCheckRowError(_0xfe8d[25],_0xfe8d[50],null,index))}};_0x8745x1d[_0xfe8d[51]]= LISTID;_0x8745x1d[_0xfe8d[52]]= COMPANYID|| undefined;if(DUPLICATES&& DUPLICATES[_0xfe8d[33]]&& _0x8745x23){var _0x8745x28={};for(var _0x8745x29=0,_0x8745x2a=DUPLICATES[_0xfe8d[33]];_0x8745x29< _0x8745x2a;_0x8745x29+= 1){_0x8745x28[DUPLICATES[_0x8745x29]]= _0x8745x1d[DUPLICATES[_0x8745x29]]};var _0x8745x2b=_[_0xfe8d[53]](_0x8745x23,_0x8745x28);if(_0x8745x2b){return _0x8745x25(handleCheckRowError(_0xfe8d[54],_0xfe8d[55],_0x8745x2b,index))}};return db[_0xfe8d[65]][_0xfe8d[64]](_0x8745x1d,{raw:true,hooks:false,fields:_[_0xfe8d[63]](_0x8745x1d)})[_0xfe8d[62]](function(_0x8745x2d){if(DUPLICATES&& DUPLICATES[_0xfe8d[33]]&& _0x8745x23){_0x8745x23[_0xfe8d[60]](_[_0xfe8d[59]](_0x8745x1d,DUPLICATES))};hopperContacts+= (hopperContacts?_0xfe8d[20]:_0xfe8d[26])+ _0x8745x2d[_0xfe8d[61]];return _0x8745x24()})[_0xfe8d[58]](function(_0x8745x2c){return _0x8745x25(handleCheckRowError(_0xfe8d[25],_0xfe8d[56]+ (_0x8745x2c[_0xfe8d[36]]|| JSON[_0xfe8d[57]](_0x8745x2c)),null,index))})})}function checkHopper(){function _0x8745x2f(){return function(_0x8745x2c){logger[_0xfe8d[25]](_0xfe8d[66],_0xfe8d[67],util[_0xfe8d[68]](_0x8745x2c,{showHidden:false,depth:null}))}}var _0x8745x30=function(_0x8745x2d,_0x8745x31){var _0x8745x32=squel[_0xfe8d[87]]()[_0xfe8d[86]](_0xfe8d[76])[_0xfe8d[85]]([_0xfe8d[43],_0xfe8d[69],_0xfe8d[70],_0xfe8d[51],_0x8745x31,_0xfe8d[71],_0xfe8d[72]],squel[_0xfe8d[79]]()[_0xfe8d[78]](_0xfe8d[43],_0xfe8d[43])[_0xfe8d[78]](_0xfe8d[84],_0xfe8d[69])[_0xfe8d[78]](_0xfe8d[61],_0xfe8d[70])[_0xfe8d[78]](LISTID.toString(),_0xfe8d[51])[_0xfe8d[78]](_0x8745x2d[_0xfe8d[61]].toString(),_0x8745x31)[_0xfe8d[78]](_0xfe8d[84],_0xfe8d[71])[_0xfe8d[78]](_0xfe8d[84],_0xfe8d[72])[_0xfe8d[77]](_0xfe8d[83])[_0xfe8d[75]](_0xfe8d[82])[_0xfe8d[75]](_0xfe8d[81],LISTID.toString())[_0xfe8d[75]](_0xfe8d[80])[_0xfe8d[75]](_0xfe8d[73],squel[_0xfe8d[79]]()[_0xfe8d[78]](_0xfe8d[43])[_0xfe8d[77]](_0xfe8d[76])[_0xfe8d[75]](_0x8745x31+ _0xfe8d[74],_0x8745x2d[_0xfe8d[61]].toString()))).toString();return _0x8745x32};var _0x8745x33=function(_0x8745x2d,_0x8745x31){var _0x8745x32=squel[_0xfe8d[87]]()[_0xfe8d[86]](_0xfe8d[76])[_0xfe8d[85]]([_0xfe8d[43],_0xfe8d[69],_0xfe8d[70],_0xfe8d[51],_0x8745x31,_0xfe8d[71],_0xfe8d[72]],squel[_0xfe8d[79]]()[_0xfe8d[78]](_0xfe8d[43],_0xfe8d[43])[_0xfe8d[78]](_0xfe8d[84],_0xfe8d[69])[_0xfe8d[78]](_0xfe8d[61],_0xfe8d[70])[_0xfe8d[78]](LISTID.toString(),_0xfe8d[51])[_0xfe8d[78]](_0x8745x2d[_0xfe8d[61]].toString(),_0x8745x31)[_0xfe8d[78]](_0xfe8d[84],_0xfe8d[71])[_0xfe8d[78]](_0xfe8d[84],_0xfe8d[72])[_0xfe8d[77]](_0xfe8d[83])[_0xfe8d[75]](_0xfe8d[82])[_0xfe8d[75]](_0xfe8d[81],LISTID.toString())[_0xfe8d[75]](_0xfe8d[90],squel[_0xfe8d[91]](hopperContacts))[_0xfe8d[75]](_0xfe8d[80])[_0xfe8d[75]](_0xfe8d[73],squel[_0xfe8d[79]]()[_0xfe8d[78]](_0xfe8d[89])[_0xfe8d[77]](_0xfe8d[88])[_0xfe8d[75]](_0x8745x31+ _0xfe8d[74],_0x8745x2d[_0xfe8d[61]].toString()))[_0xfe8d[75]](_0xfe8d[73],squel[_0xfe8d[79]]()[_0xfe8d[78]](_0xfe8d[43])[_0xfe8d[77]](_0xfe8d[76])[_0xfe8d[75]](_0x8745x31+ _0xfe8d[74],_0x8745x2d[_0xfe8d[61]].toString()))).toString();return _0x8745x32};function _0x8745x34(_0x8745x2d,_0x8745x31){var _0x8745x32=squel[_0xfe8d[87]]()[_0xfe8d[86]](_0xfe8d[76])[_0xfe8d[85]]([_0xfe8d[43],_0xfe8d[69],_0xfe8d[70],_0xfe8d[51],_0x8745x31,_0xfe8d[71],_0xfe8d[72]],squel[_0xfe8d[79]]()[_0xfe8d[78]](_0xfe8d[43],_0xfe8d[43])[_0xfe8d[78]](_0xfe8d[84],_0xfe8d[69])[_0xfe8d[78]](_0xfe8d[61],_0xfe8d[70])[_0xfe8d[78]](LISTID.toString(),_0xfe8d[51])[_0xfe8d[78]](_0x8745x2d[_0xfe8d[61]].toString(),_0x8745x31)[_0xfe8d[78]](_0xfe8d[84],_0xfe8d[71])[_0xfe8d[78]](_0xfe8d[84],_0xfe8d[72])[_0xfe8d[77]](_0xfe8d[83])[_0xfe8d[75]](_0xfe8d[82])[_0xfe8d[75]](_0xfe8d[81],LISTID.toString())[_0xfe8d[75]](_0xfe8d[90],squel[_0xfe8d[91]](hopperContacts))[_0xfe8d[75]](_0xfe8d[80])).toString();return _0x8745x32}function _0x8745x35(_0x8745x2d,_0x8745x31){var _0x8745x32=squel[_0xfe8d[87]]()[_0xfe8d[86]](_0xfe8d[92])[_0xfe8d[85]]([_0xfe8d[43],_0xfe8d[70],_0xfe8d[51],_0x8745x31,_0xfe8d[71],_0xfe8d[72]],squel[_0xfe8d[79]]()[_0xfe8d[78]](_0xfe8d[43],_0xfe8d[43])[_0xfe8d[78]](_0xfe8d[61],_0xfe8d[70])[_0xfe8d[78]](LISTID.toString(),_0xfe8d[51])[_0xfe8d[78]](_0x8745x2d[_0xfe8d[61]].toString(),_0x8745x31)[_0xfe8d[78]](_0xfe8d[84],_0xfe8d[71])[_0xfe8d[78]](_0xfe8d[84],_0xfe8d[72])[_0xfe8d[77]](_0xfe8d[83])[_0xfe8d[75]](_0xfe8d[82])[_0xfe8d[75]](_0xfe8d[81],LISTID.toString())[_0xfe8d[75]](_0xfe8d[90],squel[_0xfe8d[91]](hopperContacts))[_0xfe8d[75]](_0xfe8d[80])).toString();return _0x8745x32}return db[_0xfe8d[110]][_0xfe8d[102]]({where:{type:_0xfe8d[109]},attributes:[_0xfe8d[61],_0xfe8d[106]],include:[{model:db[_0xfe8d[100]],as:_0xfe8d[107],where:{id:LISTID}}]})[_0xfe8d[62]](function(_0x8745x36){var promises=[];if(_0x8745x36){var _0x8745x32;for(var _0x8745x37=0,_0x8745x2d;_0x8745x37< _0x8745x36[_0xfe8d[33]];_0x8745x37+= 1){_0x8745x2d= _0x8745x36[_0x8745x37][_0xfe8d[96]]({plain:true});switch(_0x8745x2d[_0xfe8d[106]]){case _0xfe8d[104]:promises[_0xfe8d[60]](db[_0xfe8d[99]][_0xfe8d[98]](_0x8745x33(_0x8745x2d,_0xfe8d[108]))[_0xfe8d[62]](function(){})[_0xfe8d[58]](_0x8745x2f()));break;case _0xfe8d[105]:promises[_0xfe8d[60]](db[_0xfe8d[99]][_0xfe8d[98]](_0x8745x30(_0x8745x2d,_0xfe8d[108]))[_0xfe8d[62]](function(){})[_0xfe8d[58]](_0x8745x2f()));break;default:promises[_0xfe8d[60]](db[_0xfe8d[99]][_0xfe8d[98]](_0x8745x34(_0x8745x2d,_0xfe8d[108]))[_0xfe8d[62]](function(){})[_0xfe8d[58]](_0x8745x2f()))}}};return promises})[_0xfe8d[95]]()[_0xfe8d[62]](function(){return db[_0xfe8d[110]][_0xfe8d[102]]({where:{type:_0xfe8d[109]},attributes:[_0xfe8d[61]],include:[{model:db[_0xfe8d[100]],as:_0xfe8d[101],where:{id:LISTID}}]})[_0xfe8d[62]](function(_0x8745x36){var promises=[];if(_0x8745x36){var _0x8745x32;for(var _0x8745x37=0,_0x8745x2d;_0x8745x37< _0x8745x36[_0xfe8d[33]];_0x8745x37+= 1){_0x8745x2d= _0x8745x36[_0x8745x37][_0xfe8d[96]]({plain:true});promises[_0xfe8d[60]](db[_0xfe8d[99]][_0xfe8d[98]](_0x8745x35(_0x8745x2d,_0xfe8d[108]))[_0xfe8d[62]](function(){})[_0xfe8d[58]](_0x8745x2f()))}};return promises})[_0xfe8d[95]]()})[_0xfe8d[62]](function(){return db[_0xfe8d[103]][_0xfe8d[102]]({attributes:[_0xfe8d[61],_0xfe8d[106]],include:[{model:db[_0xfe8d[100]],as:_0xfe8d[107],where:{id:LISTID}}]})[_0xfe8d[62]](function(_0x8745x36){var promises=[];if(_0x8745x36){for(var _0x8745x37=0,_0x8745x2d;_0x8745x37< _0x8745x36[_0xfe8d[33]];_0x8745x37+= 1){_0x8745x2d= _0x8745x36[_0x8745x37][_0xfe8d[96]]({plain:true});switch(_0x8745x2d[_0xfe8d[106]]){case _0xfe8d[104]:promises[_0xfe8d[60]](db[_0xfe8d[99]][_0xfe8d[98]](_0x8745x33(_0x8745x2d,_0xfe8d[97]))[_0xfe8d[62]](function(){})[_0xfe8d[58]](_0x8745x2f()));break;case _0xfe8d[105]:promises[_0xfe8d[60]](db[_0xfe8d[99]][_0xfe8d[98]](_0x8745x30(_0x8745x2d,_0xfe8d[97]))[_0xfe8d[62]](function(){})[_0xfe8d[58]](_0x8745x2f()));break;default:promises[_0xfe8d[60]](db[_0xfe8d[99]][_0xfe8d[98]](_0x8745x34(_0x8745x2d,_0xfe8d[97]))[_0xfe8d[62]](function(){})[_0xfe8d[58]](_0x8745x2f()))}}};return promises})[_0xfe8d[95]]()})[_0xfe8d[62]](function(){return db[_0xfe8d[103]][_0xfe8d[102]]({attributes:[_0xfe8d[61]],include:[{model:db[_0xfe8d[100]],as:_0xfe8d[101],where:{id:LISTID}}]})[_0xfe8d[62]](function(_0x8745x36){var promises=[];if(_0x8745x36){for(var _0x8745x37=0,_0x8745x2d;_0x8745x37< _0x8745x36[_0xfe8d[33]];_0x8745x37+= 1){_0x8745x2d= _0x8745x36[_0x8745x37][_0xfe8d[96]]({plain:true});promises[_0xfe8d[60]](db[_0xfe8d[99]][_0xfe8d[98]](_0x8745x35(_0x8745x2d,_0xfe8d[97]))[_0xfe8d[62]](function(){})[_0xfe8d[58]](_0x8745x2f()))}};return promises})[_0xfe8d[95]]()})[_0xfe8d[58]](function(_0x8745x2c){logger[_0xfe8d[25]](_0xfe8d[93],_0xfe8d[94],_0x8745x2c[_0xfe8d[36]])})}var processPromises=function(_0x8745x39){return BPromise[_0xfe8d[95]](promises)[_0xfe8d[62]](function(_0x8745x3a){})[_0xfe8d[58]](function(_0x8745x2c){logger[_0xfe8d[25]](_0xfe8d[115],JSON[_0xfe8d[57]](_0x8745x2c))})[_0xfe8d[114]](function(){socket[_0xfe8d[112]](_0xfe8d[111]+ SOCKET_TIMESTAMP,{success:success,errors:errors,duplicates:duplicates,rows:rows});promises= [];success= 0;errors= 0;duplicates= 0;rows= [];if(_0x8745x39){return _0x8745x39[_0xfe8d[113]]()}})};var endCsv=function(){return BPromise[_0xfe8d[119]]()[_0xfe8d[62]](function(){if(hopperContacts){return checkHopper()}})[_0xfe8d[62]](function(){socket[_0xfe8d[112]](_0xfe8d[111]+ SOCKET_TIMESTAMP,{finished:true,success:success,errors:errors,duplicates:duplicates,rows:rows});try{fs[_0xfe8d[116]](FILEPATH)}catch(err){logger[_0xfe8d[25]](_0xfe8d[117],JSON[_0xfe8d[57]](err))}finally{process[_0xfe8d[118]](0)}})};process[_0xfe8d[123]](_0xfe8d[120],function(){logger[_0xfe8d[122]](_0xfe8d[121]);endCsv()});return BPromise[_0xfe8d[119]]()[_0xfe8d[62]](function(){if(DUPLICATES){DUPLICATES= DUPLICATES[_0xfe8d[21]](_0xfe8d[20]);return db[_0xfe8d[65]][_0xfe8d[102]]({where:{ListId:LISTID},attributes:DUPLICATES,raw:true})}})[_0xfe8d[62]](function(_0x8745x23){var _0x8745x3c=fs[_0xfe8d[125]](FILEPATH,{highWaterMark:15* 1024* 1024});Papa[_0xfe8d[129]](_0x8745x3c,{header:true,skipEmptyLines:true,step:function(_0x8745x22,_0x8745x39){total+= 1;var _0x8745x3d=total;promises[_0xfe8d[60]](checkRow(_0x8745x22,_0x8745x23,_0x8745x3d)[_0xfe8d[62]](function(){success+= 1})[_0xfe8d[58]](function(_0x8745x2c){if(_0x8745x2c[_0xfe8d[25]]){errors+= 1;delete _0x8745x2c[_0xfe8d[25]]}else {if(_0x8745x2c[_0xfe8d[54]]){duplicates+= 1;delete _0x8745x2c[_0xfe8d[54]]}};rows[_0xfe8d[60]](_0x8745x2c)}));if(total% 200=== 0){_0x8745x39[_0xfe8d[126]]();return processPromises(_0x8745x39)}},complete:function(){return processPromises()[_0xfe8d[62]](function(){logger[_0xfe8d[122]](_0xfe8d[127]);endCsv()})},error:function(_0x8745x2c,_0x8745x3e){logger[_0xfe8d[122]](_0xfe8d[128],JSON[_0xfe8d[57]](_0x8745x2c));endCsv()}})})[_0xfe8d[58]](function(_0x8745x2c){logger[_0xfe8d[25]](_0xfe8d[124],JSON[_0xfe8d[57]](_0x8745x2c))})
\ No newline at end of file
+var _0xd001=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x62\x6C\x75\x65\x62\x69\x72\x64","\x64\x62","\x2E\x2E\x2F\x2E\x2E\x2F\x2E\x2E\x2F\x6D\x79\x73\x71\x6C\x64\x62","\x61\x70\x69","\x2E\x2E\x2F\x2E\x2E\x2F\x2E\x2E\x2F\x63\x6F\x6E\x66\x69\x67\x2F\x6C\x6F\x67\x67\x65\x72","\x75\x74\x69\x6C","\x6C\x6F\x64\x61\x73\x68","\x66\x73","\x73\x71\x75\x65\x6C","\x70\x61\x70\x61\x70\x61\x72\x73\x65","\x6C\x6F\x63\x61\x6C\x68\x6F\x73\x74","\x73\x6F\x63\x6B\x65\x74\x2E\x69\x6F\x2D\x65\x6D\x69\x74\x74\x65\x72","\x72\x65\x67\x69\x73\x74\x65\x72","\x2E\x2E\x2F\x2E\x2E\x2F\x2E\x2E\x2F\x61\x70\x69\x2F\x63\x6D\x43\x6F\x6E\x74\x61\x63\x74\x2F\x63\x6D\x43\x6F\x6E\x74\x61\x63\x74\x2E\x73\x6F\x63\x6B\x65\x74","\x61\x72\x67\x76","\x75\x6E\x64\x65\x66\x69\x6E\x65\x64","\x6E\x75\x6C\x6C","\x4D\x69\x73\x73\x69\x6E\x67\x20\x66\x69\x6C\x65\x70\x61\x74\x68\x20\x70\x61\x72\x61\x6D\x65\x74\x65\x72\x21","\x4D\x69\x73\x73\x69\x6E\x67\x20\x62\x69\x6E\x64\x69\x6E\x67\x20\x70\x61\x72\x61\x6D\x65\x74\x65\x72\x73\x21","\x2C","\x73\x70\x6C\x69\x74","\x7A\x69\x70\x4F\x62\x6A\x65\x63\x74","\x4D\x69\x73\x73\x69\x6E\x67\x20\x4C\x69\x73\x74\x49\x64\x20\x70\x61\x72\x61\x6D\x65\x74\x65\x72\x21","\x4D\x69\x73\x73\x69\x6E\x67\x20\x73\x6F\x63\x6B\x65\x74\x5F\x74\x69\x6D\x65\x73\x74\x61\x6D\x70\x20\x70\x61\x72\x61\x6D\x65\x74\x65\x72\x21","\x65\x72\x72\x6F\x72","","\x63\x6F\x6E\x74\x61\x63\x74","\x69\x6E\x64\x65\x78","\x74\x65\x73\x74","\x69\x73\x4E\x69\x6C","\x54\x68\x65\x20\x72\x6F\x77\x20\x69\x73\x20\x65\x6D\x70\x74\x79\x20\x6F\x72\x20\x74\x68\x65\x20\x6E\x75\x6D\x62\x65\x72\x20\x6F\x66\x20\x70\x61\x72\x61\x6D\x65\x74\x65\x72\x73\x20\x64\x6F\x65\x73\x20\x6E\x6F\x74\x20\x6D\x61\x74\x63\x68\x20\x74\x68\x65\x20\x63\x6F\x6C\x75\x6D\x6E\x73\x21","\x65\x72\x72\x6F\x72\x73","\x6C\x65\x6E\x67\x74\x68","\x3B","\x6A\x6F\x69\x6E","\x6D\x65\x73\x73\x61\x67\x65","\x6D\x61\x70","\x68\x61\x73\x4F\x77\x6E\x50\x72\x6F\x70\x65\x72\x74\x79","\x64\x61\x74\x61","\uFEFF","\x66\x69\x72\x73\x74\x4E\x61\x6D\x65","\x66\x69\x72\x73\x74\x4E\x61\x6D\x65\x20\x6E\x6F\x74\x20\x73\x70\x65\x63\x69\x66\x69\x65\x64\x21","\x70\x68\x6F\x6E\x65","\x70\x68\x6F\x6E\x65\x20\x6E\x6F\x74\x20\x73\x70\x65\x63\x69\x66\x69\x65\x64\x21","\x62\x69\x72\x74\x68\x44\x61\x74\x65","\x59\x59\x59\x59\x2D\x4D\x4D\x2D\x44\x44","\x69\x73\x56\x61\x6C\x69\x64","\x62\x69\x72\x74\x68\x44\x61\x74\x65\x20\x66\x6F\x72\x6D\x61\x74\x20\x69\x73\x20\x69\x6E\x76\x61\x6C\x69\x64\x2C\x20\x59\x59\x59\x59\x2D\x4D\x4D\x2D\x44\x44\x20\x66\x6F\x72\x6D\x61\x74\x20\x69\x73\x20\x73\x75\x70\x70\x6F\x72\x74\x65\x64\x21","\x65\x6D\x61\x69\x6C","\x65\x6D\x61\x69\x6C\x20\x66\x6F\x72\x6D\x61\x74\x20\x69\x73\x20\x6E\x6F\x74\x20\x76\x61\x6C\x69\x64\x21","\x4C\x69\x73\x74\x49\x64","\x43\x6F\x6D\x70\x61\x6E\x79\x49\x64","\x66\x69\x6E\x64","\x64\x75\x70\x6C\x69\x63\x61\x74\x65","\x44\x75\x70\x6C\x69\x63\x61\x74\x65\x20\x43\x6F\x6E\x74\x61\x63\x74","\x45\x72\x72\x6F\x72\x20\x77\x68\x69\x6C\x65\x20\x63\x72\x65\x61\x74\x69\x6E\x67\x20\x63\x6F\x6E\x74\x61\x63\x74\x3A\x20","\x73\x74\x72\x69\x6E\x67\x69\x66\x79","\x63\x61\x74\x63\x68","\x70\x69\x63\x6B","\x70\x75\x73\x68","\x69\x64","\x74\x68\x65\x6E","\x6B\x65\x79\x73","\x63\x72\x65\x61\x74\x65","\x43\x6D\x43\x6F\x6E\x74\x61\x63\x74","\x63\x6D\x43\x6F\x6E\x74\x61\x63\x74","\x63\x68\x65\x63\x6B\x48\x6F\x70\x70\x65\x72","\x69\x6E\x73\x70\x65\x63\x74","\x73\x63\x68\x65\x64\x75\x6C\x65\x64\x41\x74","\x43\x6F\x6E\x74\x61\x63\x74\x49\x64","\x63\x72\x65\x61\x74\x65\x64\x41\x74","\x75\x70\x64\x61\x74\x65\x64\x41\x74","\x70\x68\x6F\x6E\x65\x20\x4E\x4F\x54\x20\x49\x4E\x20\x28\x3F\x29","\x20\x3D\x20\x3F","\x77\x68\x65\x72\x65","\x63\x6D\x5F\x68\x6F\x70\x70\x65\x72","\x66\x72\x6F\x6D","\x66\x69\x65\x6C\x64","\x73\x65\x6C\x65\x63\x74","\x70\x68\x6F\x6E\x65\x20\x49\x53\x20\x4E\x4F\x54\x20\x4E\x55\x4C\x4C","\x4C\x69\x73\x74\x49\x64\x20\x3D\x20\x3F","\x64\x65\x6C\x65\x74\x65\x64\x41\x74\x20\x49\x53\x20\x4E\x55\x4C\x4C","\x63\x6D\x5F\x63\x6F\x6E\x74\x61\x63\x74\x73","\x4E\x4F\x57\x28\x29","\x66\x72\x6F\x6D\x51\x75\x65\x72\x79","\x69\x6E\x74\x6F","\x69\x6E\x73\x65\x72\x74","\x63\x6D\x5F\x68\x6F\x70\x70\x65\x72\x5F\x66\x69\x6E\x61\x6C","\x63\x61\x6C\x6C\x65\x72\x69\x64\x6E\x75\x6D","\x69\x64\x20\x49\x4E\x20\x3F","\x73\x74\x72","\x63\x6D\x5F\x68\x6F\x70\x70\x65\x72\x5F\x62\x6C\x61\x63\x6B","\x63\x6D\x43\x6F\x6E\x74\x61\x63\x74\x2C\x20\x25\x73\x2C\x20\x25\x73","\x67\x65\x6E\x65\x72\x61\x6C\x43\x68\x65\x63\x6B\x48\x6F\x70\x70\x65\x72","\x61\x6C\x6C","\x67\x65\x74","\x43\x61\x6D\x70\x61\x69\x67\x6E\x49\x64","\x71\x75\x65\x72\x79","\x73\x65\x71\x75\x65\x6C\x69\x7A\x65","\x43\x6D\x4C\x69\x73\x74","\x42\x6C\x61\x63\x6B\x4C\x69\x73\x74\x73","\x66\x69\x6E\x64\x41\x6C\x6C","\x43\x61\x6D\x70\x61\x69\x67\x6E","\x61\x6C\x77\x61\x79\x73","\x6F\x6E\x6C\x79\x49\x66\x4F\x70\x65\x6E","\x64\x69\x61\x6C\x43\x68\x65\x63\x6B\x44\x75\x70\x6C\x69\x63\x61\x74\x65\x54\x79\x70\x65","\x4C\x69\x73\x74\x73","\x56\x6F\x69\x63\x65\x51\x75\x65\x75\x65\x49\x64","\x6F\x75\x74\x62\x6F\x75\x6E\x64","\x56\x6F\x69\x63\x65\x51\x75\x65\x75\x65","\x63\x6F\x6E\x74\x61\x63\x74\x3A\x63\x73\x76\x5F","\x65\x6D\x69\x74","\x72\x65\x73\x75\x6D\x65","\x66\x69\x6E\x61\x6C\x6C\x79","\x45\x72\x72\x6F\x72\x20\x70\x72\x6F\x63\x65\x73\x73\x69\x6E\x67\x20\x72\x6F\x77\x73\x20\x62\x6C\x6F\x63\x6B\x3A","\x75\x6E\x6C\x69\x6E\x6B\x53\x79\x6E\x63","\x55\x6E\x61\x62\x6C\x65\x20\x74\x6F\x20\x64\x65\x6C\x65\x74\x65\x20\x74\x65\x6D\x70\x20\x66\x69\x6C\x65\x3A","\x65\x78\x69\x74","\x72\x65\x73\x6F\x6C\x76\x65","\x53\x49\x47\x49\x4E\x54","\x43\x53\x56\x20\x69\x6D\x70\x6F\x72\x74\x20\x70\x72\x6F\x63\x65\x73\x73\x20\x73\x74\x6F\x70\x70\x65\x64\x21","\x69\x6E\x66\x6F","\x6F\x6E","\x45\x72\x72\x6F\x72\x20\x65\x78\x65\x63\x75\x74\x69\x6E\x67\x20\x63\x6F\x6E\x74\x61\x63\x74\x20\x63\x73\x76\x20\x69\x6D\x70\x6F\x72\x74\x3A","\x63\x72\x65\x61\x74\x65\x52\x65\x61\x64\x53\x74\x72\x65\x61\x6D","\x70\x61\x75\x73\x65","\x43\x53\x56\x20\x70\x61\x72\x73\x65\x64\x20\x63\x6F\x72\x72\x65\x63\x74\x6C\x79\x21","\x43\x53\x56\x20\x70\x61\x72\x73\x65\x20\x65\x72\x72\x6F\x72","\x70\x61\x72\x73\x65"];_0xd001[0];var BPromise=require(_0xd001[1]);var db=require(_0xd001[3])[_0xd001[2]];var logger=require(_0xd001[5])(_0xd001[4]);var util=require(_0xd001[6]);var _=require(_0xd001[7]);var fs=require(_0xd001[8]);var squel=require(_0xd001[9]);var Papa=require(_0xd001[10]);var socket=require(_0xd001[12])({host:_0xd001[11],port:6379});require(_0xd001[14])[_0xd001[13]](socket);try{if(!process[_0xd001[15]][2]|| process[_0xd001[15]][2]=== _0xd001[16] || process[_0xd001[15]][2]=== _0xd001[17]){throw new Error(_0xd001[18])};var FILEPATH=process[_0xd001[15]][2];if(!process[_0xd001[15]][3]|| process[_0xd001[15]][3]=== _0xd001[16] || process[_0xd001[15]][3]=== _0xd001[17] || !process[_0xd001[15]][4] || process[_0xd001[15]][4]=== _0xd001[16] || process[_0xd001[15]][4]=== _0xd001[17]){throw new Error(_0xd001[19])};var FIELDS=_[_0xd001[22]](process[_0xd001[15]][3][_0xd001[21]](_0xd001[20]),process[_0xd001[15]][4][_0xd001[21]](_0xd001[20]));if(!process[_0xd001[15]][5]|| process[_0xd001[15]][5]=== _0xd001[16] || process[_0xd001[15]][5]=== _0xd001[17]){throw new Error(_0xd001[23])};var LISTID=process[_0xd001[15]][5];var COMPANYID=(process[_0xd001[15]][6]&& process[_0xd001[15]][6]!== _0xd001[16]&& process[_0xd001[15]][6]!== _0xd001[17])?process[_0xd001[15]][6]:null;var DUPLICATES=(process[_0xd001[15]][7]&& process[_0xd001[15]][7]!== _0xd001[16]&& process[_0xd001[15]][7]!== _0xd001[17])?process[_0xd001[15]][7]:null;if(!process[_0xd001[15]][8]|| process[_0xd001[15]][8]=== _0xd001[16] || process[_0xd001[15]][8]=== _0xd001[17]){throw new Error(_0xd001[24])};var SOCKET_TIMESTAMP=process[_0xd001[15]][8]}catch(err){logger[_0xd001[25]](err);endCsv()};var total=0;var pTotal=0;var success=0;var errors=0;var duplicates=0;var rows=[];var hopperContacts=_0xd001[26];var promises=[];var index=0;var alreadyInvalid=false;function handleCheckRowError(_0x3c03x1b,_0x3c03x1c,_0x3c03x1d,index){var _0x3c03x1e={message:_0x3c03x1c};_0x3c03x1e[_0x3c03x1b]= true;if(_0x3c03x1d){_0x3c03x1e[_0xd001[27]]= _0x3c03x1d};if(index){_0x3c03x1e[_0xd001[28]]= index};return _0x3c03x1e}function isEmail(_0x3c03x20){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))*$/[_0xd001[29]](_0x3c03x20)}function checkRow(_0x3c03x22,_0x3c03x23,index){return new BPromise(function(_0x3c03x24,_0x3c03x25){if(_[_0xd001[30]](_0x3c03x22)){return _0x3c03x25(handleCheckRowError(_0xd001[25],_0xd001[31],null,index))};if(_0x3c03x22[_0xd001[32]]&& _0x3c03x22[_0xd001[32]][_0xd001[33]]){var _0x3c03x1e=_[_0xd001[37]](_0x3c03x22[_0xd001[32]],_0xd001[36])[_0xd001[35]](_0xd001[34]);return _0x3c03x25(handleCheckRowError(_0xd001[25],_0x3c03x1e,null,index))};var _0x3c03x1d={};for(var _0x3c03x26 in FIELDS){if(FIELDS[_0xd001[38]](_0x3c03x26)&& FIELDS[_0x3c03x26]){_0x3c03x1d[_0x3c03x26]= _0x3c03x22[_0xd001[39]][0][FIELDS[_0x3c03x26]]|| _0x3c03x22[_0xd001[39]][0][_0xd001[40]+ FIELDS[_0x3c03x26]]}};if(!_0x3c03x1d[_0xd001[41]]){return _0x3c03x25(handleCheckRowError(_0xd001[25],_0xd001[42],null,index))};if(!_0x3c03x1d[_0xd001[43]]){return _0x3c03x25(handleCheckRowError(_0xd001[25],_0xd001[44],null,index))};if(_0x3c03x1d[_0xd001[45]]){var _0x3c03x27=moment(_0x3c03x1d[_0xd001[45]],_0xd001[46]);if(!_0x3c03x27[_0xd001[47]]()){return _0x3c03x25(handleCheckRowError(_0xd001[25],_0xd001[48],null,index))}};if(_0x3c03x1d[_0xd001[49]]){if(!isEmail(_0x3c03x1d[_0xd001[49]])){return _0x3c03x25(handleCheckRowError(_0xd001[25],_0xd001[50],null,index))}};_0x3c03x1d[_0xd001[51]]= LISTID;_0x3c03x1d[_0xd001[52]]= COMPANYID|| undefined;if(DUPLICATES&& DUPLICATES[_0xd001[33]]&& _0x3c03x23){var _0x3c03x28={};for(var _0x3c03x29=0,_0x3c03x2a=DUPLICATES[_0xd001[33]];_0x3c03x29< _0x3c03x2a;_0x3c03x29+= 1){_0x3c03x28[DUPLICATES[_0x3c03x29]]= _0x3c03x1d[DUPLICATES[_0x3c03x29]]};var _0x3c03x2b=_[_0xd001[53]](_0x3c03x23,_0x3c03x28);if(_0x3c03x2b){return _0x3c03x25(handleCheckRowError(_0xd001[54],_0xd001[55],_0x3c03x2b,index))}};return db[_0xd001[65]][_0xd001[64]](_0x3c03x1d,{raw:true,hooks:false,fields:_[_0xd001[63]](_0x3c03x1d)})[_0xd001[62]](function(_0x3c03x2d){if(DUPLICATES&& DUPLICATES[_0xd001[33]]&& _0x3c03x23){_0x3c03x23[_0xd001[60]](_[_0xd001[59]](_0x3c03x1d,DUPLICATES))};hopperContacts+= (hopperContacts?_0xd001[20]:_0xd001[26])+ _0x3c03x2d[_0xd001[61]];return _0x3c03x24()})[_0xd001[58]](function(_0x3c03x2c){return _0x3c03x25(handleCheckRowError(_0xd001[25],_0xd001[56]+ (_0x3c03x2c[_0xd001[36]]|| JSON[_0xd001[57]](_0x3c03x2c)),null,index))})})}function checkHopper(){function _0x3c03x2f(){return function(_0x3c03x2c){logger[_0xd001[25]](_0xd001[66],_0xd001[67],util[_0xd001[68]](_0x3c03x2c,{showHidden:false,depth:null}))}}var _0x3c03x30=function(_0x3c03x2d,_0x3c03x31){var _0x3c03x32=squel[_0xd001[87]]()[_0xd001[86]](_0xd001[76])[_0xd001[85]]([_0xd001[43],_0xd001[69],_0xd001[70],_0xd001[51],_0x3c03x31,_0xd001[71],_0xd001[72]],squel[_0xd001[79]]()[_0xd001[78]](_0xd001[43],_0xd001[43])[_0xd001[78]](_0xd001[84],_0xd001[69])[_0xd001[78]](_0xd001[61],_0xd001[70])[_0xd001[78]](LISTID.toString(),_0xd001[51])[_0xd001[78]](_0x3c03x2d[_0xd001[61]].toString(),_0x3c03x31)[_0xd001[78]](_0xd001[84],_0xd001[71])[_0xd001[78]](_0xd001[84],_0xd001[72])[_0xd001[77]](_0xd001[83])[_0xd001[75]](_0xd001[82])[_0xd001[75]](_0xd001[81],LISTID.toString())[_0xd001[75]](_0xd001[80])[_0xd001[75]](_0xd001[73],squel[_0xd001[79]]()[_0xd001[78]](_0xd001[43])[_0xd001[77]](_0xd001[76])[_0xd001[75]](_0x3c03x31+ _0xd001[74],_0x3c03x2d[_0xd001[61]].toString()))).toString();return _0x3c03x32};var _0x3c03x33=function(_0x3c03x2d,_0x3c03x31){var _0x3c03x32=squel[_0xd001[87]]()[_0xd001[86]](_0xd001[76])[_0xd001[85]]([_0xd001[43],_0xd001[69],_0xd001[70],_0xd001[51],_0x3c03x31,_0xd001[71],_0xd001[72]],squel[_0xd001[79]]()[_0xd001[78]](_0xd001[43],_0xd001[43])[_0xd001[78]](_0xd001[84],_0xd001[69])[_0xd001[78]](_0xd001[61],_0xd001[70])[_0xd001[78]](LISTID.toString(),_0xd001[51])[_0xd001[78]](_0x3c03x2d[_0xd001[61]].toString(),_0x3c03x31)[_0xd001[78]](_0xd001[84],_0xd001[71])[_0xd001[78]](_0xd001[84],_0xd001[72])[_0xd001[77]](_0xd001[83])[_0xd001[75]](_0xd001[82])[_0xd001[75]](_0xd001[81],LISTID.toString())[_0xd001[75]](_0xd001[90],squel[_0xd001[91]](hopperContacts))[_0xd001[75]](_0xd001[80])[_0xd001[75]](_0xd001[73],squel[_0xd001[79]]()[_0xd001[78]](_0xd001[89])[_0xd001[77]](_0xd001[88])[_0xd001[75]](_0x3c03x31+ _0xd001[74],_0x3c03x2d[_0xd001[61]].toString()))[_0xd001[75]](_0xd001[73],squel[_0xd001[79]]()[_0xd001[78]](_0xd001[43])[_0xd001[77]](_0xd001[76])[_0xd001[75]](_0x3c03x31+ _0xd001[74],_0x3c03x2d[_0xd001[61]].toString()))).toString();return _0x3c03x32};function _0x3c03x34(_0x3c03x2d,_0x3c03x31){var _0x3c03x32=squel[_0xd001[87]]()[_0xd001[86]](_0xd001[76])[_0xd001[85]]([_0xd001[43],_0xd001[69],_0xd001[70],_0xd001[51],_0x3c03x31,_0xd001[71],_0xd001[72]],squel[_0xd001[79]]()[_0xd001[78]](_0xd001[43],_0xd001[43])[_0xd001[78]](_0xd001[84],_0xd001[69])[_0xd001[78]](_0xd001[61],_0xd001[70])[_0xd001[78]](LISTID.toString(),_0xd001[51])[_0xd001[78]](_0x3c03x2d[_0xd001[61]].toString(),_0x3c03x31)[_0xd001[78]](_0xd001[84],_0xd001[71])[_0xd001[78]](_0xd001[84],_0xd001[72])[_0xd001[77]](_0xd001[83])[_0xd001[75]](_0xd001[82])[_0xd001[75]](_0xd001[81],LISTID.toString())[_0xd001[75]](_0xd001[90],squel[_0xd001[91]](hopperContacts))[_0xd001[75]](_0xd001[80])).toString();return _0x3c03x32}function _0x3c03x35(_0x3c03x2d,_0x3c03x31){var _0x3c03x32=squel[_0xd001[87]]()[_0xd001[86]](_0xd001[92])[_0xd001[85]]([_0xd001[43],_0xd001[70],_0xd001[51],_0x3c03x31,_0xd001[71],_0xd001[72]],squel[_0xd001[79]]()[_0xd001[78]](_0xd001[43],_0xd001[43])[_0xd001[78]](_0xd001[61],_0xd001[70])[_0xd001[78]](LISTID.toString(),_0xd001[51])[_0xd001[78]](_0x3c03x2d[_0xd001[61]].toString(),_0x3c03x31)[_0xd001[78]](_0xd001[84],_0xd001[71])[_0xd001[78]](_0xd001[84],_0xd001[72])[_0xd001[77]](_0xd001[83])[_0xd001[75]](_0xd001[82])[_0xd001[75]](_0xd001[81],LISTID.toString())[_0xd001[75]](_0xd001[90],squel[_0xd001[91]](hopperContacts))[_0xd001[75]](_0xd001[80])).toString();return _0x3c03x32}return db[_0xd001[110]][_0xd001[102]]({where:{type:_0xd001[109]},attributes:[_0xd001[61],_0xd001[106]],include:[{model:db[_0xd001[100]],as:_0xd001[107],where:{id:LISTID}}]})[_0xd001[62]](function(_0x3c03x36){var promises=[];if(_0x3c03x36){var _0x3c03x32;for(var _0x3c03x37=0,_0x3c03x2d;_0x3c03x37< _0x3c03x36[_0xd001[33]];_0x3c03x37+= 1){_0x3c03x2d= _0x3c03x36[_0x3c03x37][_0xd001[96]]({plain:true});switch(_0x3c03x2d[_0xd001[106]]){case _0xd001[104]:promises[_0xd001[60]](db[_0xd001[99]][_0xd001[98]](_0x3c03x33(_0x3c03x2d,_0xd001[108]))[_0xd001[62]](function(){})[_0xd001[58]](_0x3c03x2f()));break;case _0xd001[105]:promises[_0xd001[60]](db[_0xd001[99]][_0xd001[98]](_0x3c03x30(_0x3c03x2d,_0xd001[108]))[_0xd001[62]](function(){})[_0xd001[58]](_0x3c03x2f()));break;default:promises[_0xd001[60]](db[_0xd001[99]][_0xd001[98]](_0x3c03x34(_0x3c03x2d,_0xd001[108]))[_0xd001[62]](function(){})[_0xd001[58]](_0x3c03x2f()))}}};return promises})[_0xd001[95]]()[_0xd001[62]](function(){return db[_0xd001[110]][_0xd001[102]]({where:{type:_0xd001[109]},attributes:[_0xd001[61]],include:[{model:db[_0xd001[100]],as:_0xd001[101],where:{id:LISTID}}]})[_0xd001[62]](function(_0x3c03x36){var promises=[];if(_0x3c03x36){var _0x3c03x32;for(var _0x3c03x37=0,_0x3c03x2d;_0x3c03x37< _0x3c03x36[_0xd001[33]];_0x3c03x37+= 1){_0x3c03x2d= _0x3c03x36[_0x3c03x37][_0xd001[96]]({plain:true});promises[_0xd001[60]](db[_0xd001[99]][_0xd001[98]](_0x3c03x35(_0x3c03x2d,_0xd001[108]))[_0xd001[62]](function(){})[_0xd001[58]](_0x3c03x2f()))}};return promises})[_0xd001[95]]()})[_0xd001[62]](function(){return db[_0xd001[103]][_0xd001[102]]({attributes:[_0xd001[61],_0xd001[106]],include:[{model:db[_0xd001[100]],as:_0xd001[107],where:{id:LISTID}}]})[_0xd001[62]](function(_0x3c03x36){var promises=[];if(_0x3c03x36){for(var _0x3c03x37=0,_0x3c03x2d;_0x3c03x37< _0x3c03x36[_0xd001[33]];_0x3c03x37+= 1){_0x3c03x2d= _0x3c03x36[_0x3c03x37][_0xd001[96]]({plain:true});switch(_0x3c03x2d[_0xd001[106]]){case _0xd001[104]:promises[_0xd001[60]](db[_0xd001[99]][_0xd001[98]](_0x3c03x33(_0x3c03x2d,_0xd001[97]))[_0xd001[62]](function(){})[_0xd001[58]](_0x3c03x2f()));break;case _0xd001[105]:promises[_0xd001[60]](db[_0xd001[99]][_0xd001[98]](_0x3c03x30(_0x3c03x2d,_0xd001[97]))[_0xd001[62]](function(){})[_0xd001[58]](_0x3c03x2f()));break;default:promises[_0xd001[60]](db[_0xd001[99]][_0xd001[98]](_0x3c03x34(_0x3c03x2d,_0xd001[97]))[_0xd001[62]](function(){})[_0xd001[58]](_0x3c03x2f()))}}};return promises})[_0xd001[95]]()})[_0xd001[62]](function(){return db[_0xd001[103]][_0xd001[102]]({attributes:[_0xd001[61]],include:[{model:db[_0xd001[100]],as:_0xd001[101],where:{id:LISTID}}]})[_0xd001[62]](function(_0x3c03x36){var promises=[];if(_0x3c03x36){for(var _0x3c03x37=0,_0x3c03x2d;_0x3c03x37< _0x3c03x36[_0xd001[33]];_0x3c03x37+= 1){_0x3c03x2d= _0x3c03x36[_0x3c03x37][_0xd001[96]]({plain:true});promises[_0xd001[60]](db[_0xd001[99]][_0xd001[98]](_0x3c03x35(_0x3c03x2d,_0xd001[97]))[_0xd001[62]](function(){})[_0xd001[58]](_0x3c03x2f()))}};return promises})[_0xd001[95]]()})[_0xd001[58]](function(_0x3c03x2c){logger[_0xd001[25]](_0xd001[93],_0xd001[94],_0x3c03x2c[_0xd001[36]])})}var processPromises=function(_0x3c03x39){return BPromise[_0xd001[95]](promises)[_0xd001[62]](function(_0x3c03x3a){})[_0xd001[58]](function(_0x3c03x2c){logger[_0xd001[25]](_0xd001[115],JSON[_0xd001[57]](_0x3c03x2c))})[_0xd001[114]](function(){socket[_0xd001[112]](_0xd001[111]+ SOCKET_TIMESTAMP,{success:success,errors:errors,duplicates:duplicates,rows:rows});promises= [];success= 0;errors= 0;duplicates= 0;rows= [];if(_0x3c03x39){return _0x3c03x39[_0xd001[113]]()}})};var endCsv=function(){return BPromise[_0xd001[119]]()[_0xd001[62]](function(){if(hopperContacts){return checkHopper()}})[_0xd001[62]](function(){socket[_0xd001[112]](_0xd001[111]+ SOCKET_TIMESTAMP,{finished:true,success:success,errors:errors,duplicates:duplicates,rows:rows});try{fs[_0xd001[116]](FILEPATH)}catch(err){logger[_0xd001[25]](_0xd001[117],JSON[_0xd001[57]](err))}finally{process[_0xd001[118]](0)}})};process[_0xd001[123]](_0xd001[120],function(){logger[_0xd001[122]](_0xd001[121]);endCsv()});return BPromise[_0xd001[119]]()[_0xd001[62]](function(){if(DUPLICATES){DUPLICATES= DUPLICATES[_0xd001[21]](_0xd001[20]);return db[_0xd001[65]][_0xd001[102]]({where:{ListId:LISTID},attributes:DUPLICATES,raw:true})}})[_0xd001[62]](function(_0x3c03x23){var _0x3c03x3c=fs[_0xd001[125]](FILEPATH,{highWaterMark:15* 1024* 1024});Papa[_0xd001[129]](_0x3c03x3c,{header:true,skipEmptyLines:true,step:function(_0x3c03x22,_0x3c03x39){total+= 1;var _0x3c03x3d=total;promises[_0xd001[60]](checkRow(_0x3c03x22,_0x3c03x23,_0x3c03x3d)[_0xd001[62]](function(){success+= 1})[_0xd001[58]](function(_0x3c03x2c){if(_0x3c03x2c[_0xd001[25]]){errors+= 1;delete _0x3c03x2c[_0xd001[25]]}else {if(_0x3c03x2c[_0xd001[54]]){duplicates+= 1;delete _0x3c03x2c[_0xd001[54]]}};rows[_0xd001[60]](_0x3c03x2c)}));if(total% 200=== 0){_0x3c03x39[_0xd001[126]]();return processPromises(_0x3c03x39)}},complete:function(){return processPromises()[_0xd001[62]](function(){logger[_0xd001[122]](_0xd001[127]);endCsv()})},error:function(_0x3c03x2c,_0x3c03x3e){logger[_0xd001[122]](_0xd001[128],JSON[_0xd001[57]](_0x3c03x2c));endCsv()}})})[_0xd001[58]](function(_0x3c03x2c){logger[_0xd001[25]](_0xd001[124],JSON[_0xd001[57]](_0x3c03x2c))})
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff