1 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))})
git://repos.xcallymotion.com / motion2.git / blob