Built motion from commit 52c8a02d.|2.6.29
[motion2.git] / server / api / smsMessage / smsMessage.model.js
index c3b8a94..ef40b74 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x4d38=['smsMethod','sender','username','&password=','sms','POST','session_key','total_sent','internal_order_id','deliveryReport','read','update','Missing\x20parameters:\x20username,\x20password','connectel','requestid','clicksend','xCALLY\x20Motion','senderString','%s:%s','format','toString','base64','http_code','data','queued_count','message_id','clickSend','plivo','authId','remote','/status?token=','Basic\x20%s','message_uuid','infobip','baseUrl','/sms/2/text/advanced','application/json','IBSSO\x20','Missing\x20parameters:\x20base_url','csc','crypto','apiKey','login','text','timestamp','keys','sort','length','md5','signature=','GET','/external/get/send.php?','id_sms','clickatell','https://platform.clickatell.com/messages','UTF-8','apiMessageId','Missing\x20parameters:\x20apiKey','accountId','/messages','applicationId','bandwidth','intelepeer','https://api.intelepeer.com/_rest/v4/app/sms/send','Bearer\x20','code','refid','status','message','utf8mb4','utf8mb4_unicode_ci','lodash','../../config/logger','api','moment','bluebird','rimraf','../../config/environment','exports','sms_messages','messageId','body','FULLTEXT','models','get','direction','toLowerCase','secret','UserId','SmsInteraction','findOne','SmsInteractionId','then','createdAt','catch','error','SmsAccount','find','type','twilio','accountSid','phone','authToken','messages','create','/api/sms/messages/','token','sid','SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate','inspect','Missing\x20parameters:\x20phone,\x20accountSid\x20or\x20authToken','skebby','https://api.skebby.it/API/v1.0/REST/','password'];(function(_0x5d4a2b,_0xaabd31){var _0x34529b=function(_0x35b06f){while(--_0x35b06f){_0x5d4a2b['push'](_0x5d4a2b['shift']());}};_0x34529b(++_0xaabd31);}(_0x4d38,0xba));var _0x84d3=function(_0x2a1dc3,_0x2bcbcc){_0x2a1dc3=_0x2a1dc3-0x0;var _0x4f0d17=_0x4d38[_0x2a1dc3];return _0x4f0d17;};'use strict';var _=require(_0x84d3('0x0'));var util=require('util');var logger=require(_0x84d3('0x1'))(_0x84d3('0x2'));var moment=require(_0x84d3('0x3'));var BPromise=require(_0x84d3('0x4'));var rp=require('request-promise');var fs=require('fs');var path=require('path');var rimraf=require(_0x84d3('0x5'));var config=require(_0x84d3('0x6'));var attributes=require('./smsMessage.attributes');module[_0x84d3('0x7')]=function(_0x5815a1,_0x523bc7){return _0x5815a1['define']('SmsMessage',attributes,{'tableName':_0x84d3('0x8'),'paranoid':![],'indexes':[{'name':_0x84d3('0x9'),'fields':[_0x84d3('0x9')]},{'name':'fti_sms_messages','fields':[_0x84d3('0xa')],'type':_0x84d3('0xb')}],'timestamps':!![],'hooks':{'afterCreate':function(_0x256c7b,_0x4c71b8,_0x5b9062){var _0x6e2842=_0x5815a1[_0x84d3('0xc')];var _0x429524=_0x256c7b[_0x84d3('0xd')]({'plain':!![]});if(_0x429524[_0x84d3('0xe')][_0x84d3('0xf')]()==='in'||_0x429524[_0x84d3('0xe')][_0x84d3('0xf')]()==='out'&&!_0x429524[_0x84d3('0x10')]&&!_['isNil'](_0x429524[_0x84d3('0x11')])){_0x6e2842[_0x84d3('0x12')][_0x84d3('0x13')]({'where':{'id':_0x429524[_0x84d3('0x14')]}})[_0x84d3('0x15')](function(_0x1d76e3){if(_0x1d76e3){_0x1d76e3['update']({'lastMsgAt':_0x429524[_0x84d3('0x16')],'lastMsgDirection':_0x429524[_0x84d3('0xe')][_0x84d3('0xf')]()});}})[_0x84d3('0x17')](function(_0x15176c){console[_0x84d3('0x18')](_0x15176c);});}if(_0x429524['direction']==='out'&&!_0x429524[_0x84d3('0x10')]){var _0x539871;_0x6e2842[_0x84d3('0x19')][_0x84d3('0x1a')]({'where':{'id':_0x429524['SmsAccountId']},'raw':!![]})[_0x84d3('0x15')](function(_0x4b4945){_0x539871=_0x4b4945;if(_0x539871&&_0x539871[_0x84d3('0x1b')]){switch(_0x539871[_0x84d3('0x1b')]){case _0x84d3('0x1c'):var _0x47f9c2=require(_0x84d3('0x1c'));if(_0x539871[_0x84d3('0x1d')]&&_0x539871['authToken']&&_0x539871[_0x84d3('0x1e')]){var _0x10d973=new _0x47f9c2(_0x539871[_0x84d3('0x1d')],_0x539871[_0x84d3('0x1f')]);_0x10d973[_0x84d3('0x20')][_0x84d3('0x21')]({'body':_0x429524[_0x84d3('0xa')],'to':_0x429524[_0x84d3('0x1e')],'from':_0x539871['phone'],'statusCallback':_0x539871['remote']+_0x84d3('0x22')+_0x429524['id']+'/status?token='+_0x539871[_0x84d3('0x23')]})[_0x84d3('0x15')](function(_0x58fb05){if(_0x58fb05[_0x84d3('0x24')]){return _0x256c7b['update']({'messageId':_0x58fb05[_0x84d3('0x24')]});}})[_0x84d3('0x17')](function(_0x2c09b6){logger['error'](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x1c'),util[_0x84d3('0x27')](_0x2c09b6,{'showHidden':![],'depth':null}));});}else{logger['error'](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x1c'),_0x84d3('0x28'));}break;case _0x84d3('0x29'):var _0x1920c7=_0x84d3('0x2a');if(_0x539871['username']&&_0x539871[_0x84d3('0x2b')]){var _0x598684={'recipient':[_0x429524['phone']],'message':_0x429524['body'],'message_type':_0x539871[_0x84d3('0x2c')]};if(_0x539871['smsMethod']&&_0x539871[_0x84d3('0x2c')]!=='SI'){_0x598684[_0x84d3('0x2d')]=_0x539871['phone'];}var _0x1bc3fc={'url':_0x1920c7+'login?username='+_0x539871[_0x84d3('0x2e')]+_0x84d3('0x2f')+_0x539871[_0x84d3('0x2b')],'method':'GET'};rp(_0x1bc3fc)[_0x84d3('0x15')](function(_0x48c1b1){var _0x40775f=_0x48c1b1['split'](';');var _0x390485={'user_key':_0x40775f[0x0],'session_key':_0x40775f[0x1]};_0x1bc3fc={'url':_0x1920c7+_0x84d3('0x30'),'method':_0x84d3('0x31'),'headers':{'user_key':_0x390485['user_key'],'Session_key':_0x390485[_0x84d3('0x32')]},'json':!![],'body':_0x598684};return rp(_0x1bc3fc);})[_0x84d3('0x15')](function(_0x664522){if(_0x664522[_0x84d3('0x33')]>=0x1){var _0x254893={'messageId':_0x664522[_0x84d3('0x34')]};if(_0x539871['smsMethod']!=='GP'||!_0x539871[_0x84d3('0x35')]){_0x254893[_0x84d3('0x36')]=!![];}return _0x256c7b[_0x84d3('0x37')](_0x254893);}else{return logger['error'](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x29'),util[_0x84d3('0x27')](_0x664522,{'showHidden':![],'depth':null}));}})[_0x84d3('0x17')](function(_0x4bff9d){return logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0x84d3('0x29'),util[_0x84d3('0x27')](_0x4bff9d,{'showHidden':![],'depth':null}));});}else{logger[_0x84d3('0x18')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x84d3('0x26'),_0x84d3('0x29'),_0x84d3('0x38'));}break;case _0x84d3('0x39'):if(_0x539871[_0x84d3('0x1f')]){var _0x1ad741={'recipient':_0x429524[_0x84d3('0x1e')],'message':_0x429524[_0x84d3('0xa')],'sender':_0x539871['senderString']||_0x539871['phone'],'authorization':_0x539871['authToken']};var _0x4c71b8={'method':'POST','uri':'https://smsapi.connectel.se/api/v2/send/','body':_0x1ad741,'json':!![]};rp(_0x4c71b8)[_0x84d3('0x15')](function(_0x5486c9){var _0x9992bc={'messageId':_0x5486c9[_0x84d3('0x3a')]};if(!_0x539871['deliveryReport']){_0x9992bc[_0x84d3('0x36')]=!![];}return _0x256c7b['update'](_0x9992bc);})[_0x84d3('0x17')](function(_0x589585){logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),'connectel',util[_0x84d3('0x27')](_0x589585,{'showHidden':![],'depth':null}));});}else{logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x39'),'Missing\x20parameters:\x20authToken');}break;case _0x84d3('0x3b'):if(_0x539871['username']&&_0x539871[_0x84d3('0x2b')]){var _0x1ad741={'messages':[{'source':_0x84d3('0x3c'),'to':_0x429524[_0x84d3('0x1e')],'body':_0x429524[_0x84d3('0xa')],'from':_0x539871[_0x84d3('0x3d')]||_0x539871[_0x84d3('0x1e')]}]};var _0x34a9bc=util['format'](_0x84d3('0x3e'),_0x539871[_0x84d3('0x2e')],_0x539871[_0x84d3('0x2b')]);var _0x4c71b8={'method':_0x84d3('0x31'),'uri':'https://rest.clicksend.com/v3/sms/send','body':_0x1ad741,'headers':{'Authorization':util[_0x84d3('0x3f')]('Basic\x20%s',new Buffer(_0x34a9bc)[_0x84d3('0x40')](_0x84d3('0x41')))},'json':!![]};rp(_0x4c71b8)[_0x84d3('0x15')](function(_0x32b676){if(_0x32b676[_0x84d3('0x42')]>=0xc8&&_0x32b676[_0x84d3('0x42')]<=0xce){if(_0x32b676['data']&&_0x32b676[_0x84d3('0x43')][_0x84d3('0x44')]>0x0){var _0x8f29c6=_['head'](_0x32b676['data']['messages']);var _0x14fbc0={'messageId':_0x8f29c6[_0x84d3('0x45')]};if(!_0x539871[_0x84d3('0x35')]){_0x14fbc0[_0x84d3('0x36')]=!![];}return _0x256c7b[_0x84d3('0x37')](_0x14fbc0);}else{logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x46'),util['inspect'](_0x32b676,{'showHidden':![],'depth':null}));}}else{logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x46'),util['inspect'](_0x32b676,{'showHidden':![],'depth':null}));}})['catch'](function(_0x1f2f95){logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x46'),util[_0x84d3('0x27')](_0x1f2f95,{'showHidden':![],'depth':null}));});}else{logger['error'](_0x84d3('0x25'),_0x84d3('0x26'),'clickSend',_0x84d3('0x38'));}break;case _0x84d3('0x47'):if(_0x539871[_0x84d3('0x48')]&&_0x539871[_0x84d3('0x1f')]){var _0x1ad741={'dst':_0x429524[_0x84d3('0x1e')],'text':_0x429524[_0x84d3('0xa')],'src':_0x539871[_0x84d3('0x3d')]||_0x539871['phone'],'url':_0x539871[_0x84d3('0x49')]+'/api/sms/messages/'+_0x429524['id']+_0x84d3('0x4a')+_0x539871[_0x84d3('0x23')]};var _0x34a9bc=util[_0x84d3('0x3f')](_0x84d3('0x3e'),_0x539871[_0x84d3('0x48')],_0x539871[_0x84d3('0x1f')]);var _0x4c71b8={'method':_0x84d3('0x31'),'uri':util['format']('https://api.plivo.com/v1/Account/%s/Message/',_0x539871[_0x84d3('0x48')]),'body':_0x1ad741,'headers':{'Authorization':util[_0x84d3('0x3f')](_0x84d3('0x4b'),new Buffer(_0x34a9bc)['toString']('base64'))},'json':!![]};rp(_0x4c71b8)[_0x84d3('0x15')](function(_0x18ac65){var _0x3d4d4b={'messageId':_0x18ac65[_0x84d3('0x4c')][0x0]};return _0x256c7b[_0x84d3('0x37')](_0x3d4d4b);})[_0x84d3('0x17')](function(_0x38ff4){logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x47'),util[_0x84d3('0x27')](_0x38ff4,{'showHidden':![],'depth':null}));});}else{logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x47'),'Missing\x20parameters:\x20authId,\x20authToken');}break;case _0x84d3('0x4d'):if(_0x539871[_0x84d3('0x2e')]&&_0x539871['password']){if(_0x539871[_0x84d3('0x4e')]){var _0x26a28e={'method':_0x84d3('0x31'),'uri':_0x539871[_0x84d3('0x4e')]+'/auth/1/session','body':{'username':_0x539871[_0x84d3('0x2e')],'password':_0x539871['password']},'json':!![]};return rp(_0x26a28e)[_0x84d3('0x15')](function(_0x5b645a){var _0x258db4={'method':'POST','uri':_0x539871['baseUrl']+_0x84d3('0x4f'),'body':{'messages':[{'from':_0x539871['phone'],'destinations':[{'to':_0x429524[_0x84d3('0x1e')]}],'text':_0x429524[_0x84d3('0xa')],'notifyUrl':_0x539871['remote']+'/api/sms/messages/'+_0x429524['id']+'/status?token='+_0x539871[_0x84d3('0x23')],'notifyContentType':_0x84d3('0x50'),'callbackData':_0x539871[_0x84d3('0x1e')]+';'+_0x429524[_0x84d3('0xa')]}]},'headers':{'Authorization':_0x84d3('0x51')+_0x5b645a[_0x84d3('0x23')]},'json':!![]};return rp(_0x258db4)[_0x84d3('0x15')](function(_0x29fc27){if(_0x29fc27[_0x84d3('0x20')]){var _0x40d4ce={'messageId':_0x29fc27[_0x84d3('0x20')][0x0][_0x84d3('0x9')]};if(!_0x539871[_0x84d3('0x35')]){_0x40d4ce[_0x84d3('0x36')]=!![];}return _0x256c7b[_0x84d3('0x37')](_0x40d4ce);}else{return logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s',_0x84d3('0x26'),_0x84d3('0x4d'),util[_0x84d3('0x27')](_0x29fc27,{'showHidden':![],'depth':null}));}});})[_0x84d3('0x17')](function(_0x4c59fc){return logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x4d'),util[_0x84d3('0x27')](_0x4c59fc,{'showHidden':![],'depth':null}));});}else{logger[_0x84d3('0x18')](_0x84d3('0x25'),'afterCreate',_0x84d3('0x4d'),_0x84d3('0x52'));}}else{logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x4d'),_0x84d3('0x38'));}break;case _0x84d3('0x53'):var _0x251c48=require(_0x84d3('0x54'));if(_0x539871[_0x84d3('0x55')]){var _0x391f77={};_0x391f77[_0x84d3('0x56')]=_0x539871[_0x84d3('0x2e')];_0x391f77[_0x84d3('0x1e')]=_0x429524[_0x84d3('0x1e')];_0x391f77[_0x84d3('0x2d')]=_0x539871[_0x84d3('0x1e')];_0x391f77[_0x84d3('0x57')]=_0x429524[_0x84d3('0xa')];_0x391f77[_0x84d3('0x58')]=+new Date();var _0x46f036='';var _0x4f3160='';var _0x3ae7d5=Object[_0x84d3('0x59')](_0x391f77);_0x3ae7d5[_0x84d3('0x5a')]();for(var _0x28d498=0x0;_0x28d498<_0x3ae7d5[_0x84d3('0x5b')];_0x28d498++){if(_0x46f036!=''){_0x46f036+='&';}_0x46f036+=_0x3ae7d5[_0x28d498]+'='+encodeURIComponent(_0x391f77[_0x3ae7d5[_0x28d498]]);_0x4f3160+=_0x391f77[_0x3ae7d5[_0x28d498]];}_0x4f3160+=_0x539871[_0x84d3('0x55')];_0x4f3160=_0x251c48['createHash'](_0x84d3('0x5c'))['update'](_0x4f3160)['digest']('hex');if(_0x46f036!==''){_0x46f036+='&';}_0x46f036+=_0x84d3('0x5d')+_0x4f3160;var _0x1bc3fc={'method':_0x84d3('0x5e'),'uri':_0x539871[_0x84d3('0x4e')]+_0x84d3('0x5f')+_0x46f036,'json':!![]};return rp(_0x1bc3fc)['then'](function(_0x12baab){var _0x1a001a=Object[_0x84d3('0x59')](_0x12baab);if(_0x12baab[_0x1a001a[0x0]]['error']&&parseInt(_0x12baab[_0x1a001a[0x0]][_0x84d3('0x18')])===0x0){var _0xeb82f1={'messageId':_0x12baab[_0x1a001a[0x0]][_0x84d3('0x60')]};if(!_0x539871[_0x84d3('0x35')]){_0xeb82f1[_0x84d3('0x36')]=!![];}return _0x256c7b['update'](_0xeb82f1);}else{return logger[_0x84d3('0x18')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0x84d3('0x53'),util[_0x84d3('0x27')](_0x12baab[_0x84d3('0x18')],{'showHidden':![],'depth':null}));}})['catch'](function(_0x51fc39){return logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x53'),util['inspect'](_0x51fc39,{'showHidden':![],'depth':null}));});}else{logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0x84d3('0x53'),'Missing\x20parameters:\x20apiKey');}break;case _0x84d3('0x61'):if(_0x539871['apiKey']){var _0x339f26={'method':_0x84d3('0x31'),'uri':_0x84d3('0x62'),'headers':{'Authorization':_0x539871[_0x84d3('0x55')]},'body':{'content':_0x429524[_0x84d3('0xa')],'to':[_0x429524['phone']],'from':_0x539871[_0x84d3('0x1e')],'binary':![],'clientMessageId':'uuid','charset':_0x84d3('0x63')},'json':!![]};rp(_0x339f26)['then'](function(_0x5b90de){if(!_0x5b90de[_0x84d3('0x18')]){var _0x4b4932={'messageId':_0x5b90de[_0x84d3('0x20')][0x0][_0x84d3('0x64')]};if(!_0x539871[_0x84d3('0x35')]){_0x4b4932['read']=!![];}return _0x256c7b[_0x84d3('0x37')](_0x4b4932);}else{return logger[_0x84d3('0x18')](_0x84d3('0x25'),'afterCreate',_0x84d3('0x61'),util[_0x84d3('0x27')](_0x5b90de['error'],{'showHidden':![],'depth':null}));}})[_0x84d3('0x17')](function(_0x40f509){return logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x61'),util[_0x84d3('0x27')](_0x40f509,{'showHidden':![],'depth':null}));});}else{logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x61'),_0x84d3('0x65'));}break;case'bandwidth':if(_0x539871['username']&&_0x539871['password']){var _0x34a9bc=util[_0x84d3('0x3f')](_0x84d3('0x3e'),_0x539871[_0x84d3('0x2e')],_0x539871[_0x84d3('0x2b')]);var _0x4c71b8={'method':'POST','uri':'https://messaging.bandwidth.com/api/v2/users/'+_0x539871[_0x84d3('0x66')]+_0x84d3('0x67'),'body':{'to':[_0x429524['phone']],'text':_0x429524[_0x84d3('0xa')],'from':_0x539871['phone'],'applicationId':_0x539871[_0x84d3('0x68')]},'headers':{'Authorization':util['format']('Basic\x20%s',new Buffer(_0x34a9bc)['toString'](_0x84d3('0x41')))},'json':!![]};rp(_0x4c71b8)[_0x84d3('0x15')](function(_0x1a1b32){if(_0x1a1b32['id']){var _0x26f03a={'messageId':_0x1a1b32['id']};return _0x256c7b[_0x84d3('0x37')](_0x26f03a);}else{logger[_0x84d3('0x18')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x84d3('0x26'),_0x84d3('0x69'),util[_0x84d3('0x27')](_0x1a1b32,{'showHidden':![],'depth':null}));}})[_0x84d3('0x17')](function(_0x239e1b){logger[_0x84d3('0x18')](_0x84d3('0x25'),'afterCreate','bandwidth',util[_0x84d3('0x27')](_0x239e1b,{'showHidden':![],'depth':null}));});}else{logger[_0x84d3('0x18')](_0x84d3('0x25'),'afterCreate',_0x84d3('0x69'),_0x84d3('0x38'));}break;case _0x84d3('0x6a'):if(_0x539871['apiKey']){var _0x4fbf7c={};var _0x1bc3fc={'method':_0x84d3('0x31'),'uri':_0x84d3('0x6b'),'headers':{'Authorization':_0x84d3('0x6c')+_0x539871[_0x84d3('0x55')],'Content-Type':'application/json'},'body':{'from':_0x539871[_0x84d3('0x1e')],'to':_0x429524[_0x84d3('0x1e')],'text':_0x429524[_0x84d3('0xa')]},'json':!![]};return rp(_0x1bc3fc)[_0x84d3('0x15')](function(_0x2ad3ca){if(_0x2ad3ca[_0x84d3('0x6d')]==0xca){_0x4fbf7c['message']=_0x2ad3ca;var _0x25e11c={'method':_0x84d3('0x31'),'uri':'https://api.intelepeer.com/_rest/v4/app/sms/mdr','headers':{'Authorization':_0x84d3('0x6c')+_0x539871[_0x84d3('0x55')],'Content-Type':_0x84d3('0x50')},'body':{'refid':_0x4fbf7c['message'][_0x84d3('0x6e')]},'json':!![]};return rp(_0x25e11c)[_0x84d3('0x15')](function(_0x13781d){_0x4fbf7c[_0x84d3('0x6f')]=_0x13781d;var _0x3a5574={'messageId':_0x4fbf7c[_0x84d3('0x70')][_0x84d3('0x6e')],'read':!![]};return _0x256c7b[_0x84d3('0x37')](_0x3a5574);});}else{return logger['error'](_0x84d3('0x25'),_0x84d3('0x26'),_0x84d3('0x6a'),util[_0x84d3('0x27')](_0x2ad3ca,{'showHidden':![],'depth':null}));}})[_0x84d3('0x17')](function(_0x54c828){return logger['error'](_0x84d3('0x25'),'afterCreate',_0x84d3('0x6a'),util[_0x84d3('0x27')](_0x54c828,{'showHidden':![],'depth':null}));});}else{return logger[_0x84d3('0x18')](_0x84d3('0x25'),_0x84d3('0x26'),'intelepeer','Token\x20not\x20received');}break;}}})['finally'](function(){_0x5b9062();});}else{_0x5b9062();}}},'charset':_0x84d3('0x71'),'collate':_0x84d3('0x72')});};
\ No newline at end of file
+var _0x63b2=['refid','Token\x20not\x20received','finally','utf8mb4','lodash','util','../../config/logger','api','moment','request-promise','rimraf','../../config/environment','./smsMessage.attributes','exports','define','SmsMessage','sms_messages','messageId','body','FULLTEXT','models','get','toLowerCase','direction','out','secret','isNil','SmsInteractionId','SmsInteraction','findOne','then','createdAt','find','type','twilio','accountSid','phone','remote','/api/sms/messages/','/status?token=','token','sid','error','SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate','inspect','Missing\x20parameters:\x20phone,\x20accountSid\x20or\x20authToken','skebby','https://api.skebby.it/API/v1.0/REST/','username','password','smsMethod','sender','login?username=','&password=','GET','split','sms','POST','user_key','session_key','total_sent','internal_order_id','read','update','catch','Missing\x20parameters:\x20username,\x20password','connectel','authToken','https://smsapi.connectel.se/api/v2/send/','requestid','deliveryReport','Missing\x20parameters:\x20authToken','clicksend','xCALLY\x20Motion','senderString','format','%s:%s','Basic\x20%s','toString','base64','http_code','data','queued_count','head','messages','clickSend','authId','https://api.plivo.com/v1/Account/%s/Message/','message_uuid','plivo','infobip','/auth/1/session','baseUrl','/sms/2/text/advanced','application/json','IBSSO\x20','Missing\x20parameters:\x20base_url','crypto','apiKey','login','text','timestamp','keys','length','createHash','digest','/external/get/send.php?','id_sms','csc','Missing\x20parameters:\x20apiKey','clickatell','https://platform.clickatell.com/messages','uuid','apiMessageId','bandwidth','https://messaging.bandwidth.com/api/v2/users/','accountId','intelepeer','https://api.intelepeer.com/_rest/v4/app/sms/send','Bearer\x20','code','https://api.intelepeer.com/_rest/v4/app/sms/mdr','message'];(function(_0x25aee9,_0x131f27){var _0x8a6913=function(_0x1573dd){while(--_0x1573dd){_0x25aee9['push'](_0x25aee9['shift']());}};_0x8a6913(++_0x131f27);}(_0x63b2,0x80));var _0x263b=function(_0x6333cd,_0x4917d2){_0x6333cd=_0x6333cd-0x0;var _0x19e6ca=_0x63b2[_0x6333cd];return _0x19e6ca;};'use strict';var _=require(_0x263b('0x0'));var util=require(_0x263b('0x1'));var logger=require(_0x263b('0x2'))(_0x263b('0x3'));var moment=require(_0x263b('0x4'));var BPromise=require('bluebird');var rp=require(_0x263b('0x5'));var fs=require('fs');var path=require('path');var rimraf=require(_0x263b('0x6'));var config=require(_0x263b('0x7'));var attributes=require(_0x263b('0x8'));module[_0x263b('0x9')]=function(_0xcd6093,_0xfb0345){return _0xcd6093[_0x263b('0xa')](_0x263b('0xb'),attributes,{'tableName':_0x263b('0xc'),'paranoid':![],'indexes':[{'name':_0x263b('0xd'),'fields':[_0x263b('0xd')]},{'name':'fti_sms_messages','fields':[_0x263b('0xe')],'type':_0x263b('0xf')}],'timestamps':!![],'hooks':{'afterCreate':function(_0x3fbade,_0x1545f4,_0x8a384f){var _0x5d545c=_0xcd6093[_0x263b('0x10')];var _0x6f30b=_0x3fbade[_0x263b('0x11')]({'plain':!![]});if(_0x6f30b['direction'][_0x263b('0x12')]()==='in'||_0x6f30b[_0x263b('0x13')][_0x263b('0x12')]()===_0x263b('0x14')&&!_0x6f30b[_0x263b('0x15')]&&!_['isNil'](_0x6f30b['UserId'])&&!_[_0x263b('0x16')](_0x6f30b[_0x263b('0x17')])){_0x5d545c[_0x263b('0x18')][_0x263b('0x19')]({'where':{'id':_0x6f30b['SmsInteractionId']}})[_0x263b('0x1a')](function(_0x213e95){if(_0x213e95){_0x213e95['update']({'lastMsgAt':_0x6f30b[_0x263b('0x1b')],'lastMsgDirection':_0x6f30b[_0x263b('0x13')]['toLowerCase']()});}})['catch'](function(_0x437453){console['error'](_0x437453);});}if(_0x6f30b[_0x263b('0x13')]===_0x263b('0x14')&&!_0x6f30b[_0x263b('0x15')]){var _0x1101d5;_0x5d545c['SmsAccount'][_0x263b('0x1c')]({'where':{'id':_0x6f30b['SmsAccountId']},'raw':!![]})[_0x263b('0x1a')](function(_0x124948){_0x1101d5=_0x124948;if(_0x1101d5&&_0x1101d5[_0x263b('0x1d')]){switch(_0x1101d5[_0x263b('0x1d')]){case _0x263b('0x1e'):var _0x223115=require(_0x263b('0x1e'));if(_0x1101d5[_0x263b('0x1f')]&&_0x1101d5['authToken']&&_0x1101d5[_0x263b('0x20')]){var _0x2b335c=new _0x223115(_0x1101d5[_0x263b('0x1f')],_0x1101d5['authToken']);_0x2b335c['messages']['create']({'body':_0x6f30b['body'],'to':_0x6f30b['phone'],'from':_0x1101d5[_0x263b('0x20')],'statusCallback':_0x1101d5[_0x263b('0x21')]+_0x263b('0x22')+_0x6f30b['id']+_0x263b('0x23')+_0x1101d5[_0x263b('0x24')]})['then'](function(_0x489423){if(_0x489423[_0x263b('0x25')]){return _0x3fbade['update']({'messageId':_0x489423[_0x263b('0x25')]});}})['catch'](function(_0x884d99){logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),_0x263b('0x1e'),util[_0x263b('0x29')](_0x884d99,{'showHidden':![],'depth':null}));});}else{logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),_0x263b('0x1e'),_0x263b('0x2a'));}break;case _0x263b('0x2b'):var _0x547efc=_0x263b('0x2c');if(_0x1101d5[_0x263b('0x2d')]&&_0x1101d5[_0x263b('0x2e')]){var _0xb1bd55={'recipient':[_0x6f30b['phone']],'message':_0x6f30b[_0x263b('0xe')],'message_type':_0x1101d5[_0x263b('0x2f')]};if(_0x1101d5[_0x263b('0x2f')]&&_0x1101d5[_0x263b('0x2f')]!=='SI'){_0xb1bd55[_0x263b('0x30')]=_0x1101d5[_0x263b('0x20')];}var _0x2ff2f5={'url':_0x547efc+_0x263b('0x31')+_0x1101d5[_0x263b('0x2d')]+_0x263b('0x32')+_0x1101d5[_0x263b('0x2e')],'method':_0x263b('0x33')};rp(_0x2ff2f5)[_0x263b('0x1a')](function(_0x1fc5f9){var _0x16980a=_0x1fc5f9[_0x263b('0x34')](';');var _0x1e11e2={'user_key':_0x16980a[0x0],'session_key':_0x16980a[0x1]};_0x2ff2f5={'url':_0x547efc+_0x263b('0x35'),'method':_0x263b('0x36'),'headers':{'user_key':_0x1e11e2[_0x263b('0x37')],'Session_key':_0x1e11e2[_0x263b('0x38')]},'json':!![],'body':_0xb1bd55};return rp(_0x2ff2f5);})['then'](function(_0x483913){if(_0x483913[_0x263b('0x39')]>=0x1){var _0x589e17={'messageId':_0x483913[_0x263b('0x3a')]};if(_0x1101d5[_0x263b('0x2f')]!=='GP'||!_0x1101d5['deliveryReport']){_0x589e17[_0x263b('0x3b')]=!![];}return _0x3fbade[_0x263b('0x3c')](_0x589e17);}else{return logger[_0x263b('0x26')](_0x263b('0x27'),'afterCreate',_0x263b('0x2b'),util[_0x263b('0x29')](_0x483913,{'showHidden':![],'depth':null}));}})[_0x263b('0x3d')](function(_0x89afc4){return logger[_0x263b('0x26')](_0x263b('0x27'),'afterCreate',_0x263b('0x2b'),util['inspect'](_0x89afc4,{'showHidden':![],'depth':null}));});}else{logger[_0x263b('0x26')](_0x263b('0x27'),'afterCreate',_0x263b('0x2b'),_0x263b('0x3e'));}break;case _0x263b('0x3f'):if(_0x1101d5['authToken']){var _0x24d376={'recipient':_0x6f30b[_0x263b('0x20')],'message':_0x6f30b[_0x263b('0xe')],'sender':_0x1101d5['senderString']||_0x1101d5[_0x263b('0x20')],'authorization':_0x1101d5[_0x263b('0x40')]};var _0x1545f4={'method':'POST','uri':_0x263b('0x41'),'body':_0x24d376,'json':!![]};rp(_0x1545f4)['then'](function(_0xc7299a){var _0x1b9c1a={'messageId':_0xc7299a[_0x263b('0x42')]};if(!_0x1101d5[_0x263b('0x43')]){_0x1b9c1a['read']=!![];}return _0x3fbade[_0x263b('0x3c')](_0x1b9c1a);})['catch'](function(_0x164eb7){logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),_0x263b('0x3f'),util['inspect'](_0x164eb7,{'showHidden':![],'depth':null}));});}else{logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),'connectel',_0x263b('0x44'));}break;case _0x263b('0x45'):if(_0x1101d5['username']&&_0x1101d5[_0x263b('0x2e')]){var _0x24d376={'messages':[{'source':_0x263b('0x46'),'to':_0x6f30b['phone'],'body':_0x6f30b[_0x263b('0xe')],'from':_0x1101d5[_0x263b('0x47')]||_0x1101d5['phone']}]};var _0x304c4d=util[_0x263b('0x48')](_0x263b('0x49'),_0x1101d5[_0x263b('0x2d')],_0x1101d5[_0x263b('0x2e')]);var _0x1545f4={'method':_0x263b('0x36'),'uri':'https://rest.clicksend.com/v3/sms/send','body':_0x24d376,'headers':{'Authorization':util[_0x263b('0x48')](_0x263b('0x4a'),new Buffer(_0x304c4d)[_0x263b('0x4b')](_0x263b('0x4c')))},'json':!![]};rp(_0x1545f4)[_0x263b('0x1a')](function(_0x2bcd1e){if(_0x2bcd1e[_0x263b('0x4d')]>=0xc8&&_0x2bcd1e[_0x263b('0x4d')]<=0xce){if(_0x2bcd1e[_0x263b('0x4e')]&&_0x2bcd1e[_0x263b('0x4e')][_0x263b('0x4f')]>0x0){var _0x6bbba0=_[_0x263b('0x50')](_0x2bcd1e[_0x263b('0x4e')][_0x263b('0x51')]);var _0x43b53b={'messageId':_0x6bbba0['message_id']};if(!_0x1101d5['deliveryReport']){_0x43b53b['read']=!![];}return _0x3fbade[_0x263b('0x3c')](_0x43b53b);}else{logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),_0x263b('0x52'),util[_0x263b('0x29')](_0x2bcd1e,{'showHidden':![],'depth':null}));}}else{logger[_0x263b('0x26')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0x263b('0x52'),util['inspect'](_0x2bcd1e,{'showHidden':![],'depth':null}));}})[_0x263b('0x3d')](function(_0x4ea193){logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s',_0x263b('0x28'),_0x263b('0x52'),util[_0x263b('0x29')](_0x4ea193,{'showHidden':![],'depth':null}));});}else{logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),_0x263b('0x52'),_0x263b('0x3e'));}break;case'plivo':if(_0x1101d5[_0x263b('0x53')]&&_0x1101d5[_0x263b('0x40')]){var _0x24d376={'dst':_0x6f30b[_0x263b('0x20')],'text':_0x6f30b[_0x263b('0xe')],'src':_0x1101d5['senderString']||_0x1101d5[_0x263b('0x20')],'url':_0x1101d5['remote']+_0x263b('0x22')+_0x6f30b['id']+_0x263b('0x23')+_0x1101d5[_0x263b('0x24')]};var _0x304c4d=util['format'](_0x263b('0x49'),_0x1101d5[_0x263b('0x53')],_0x1101d5[_0x263b('0x40')]);var _0x1545f4={'method':_0x263b('0x36'),'uri':util[_0x263b('0x48')](_0x263b('0x54'),_0x1101d5[_0x263b('0x53')]),'body':_0x24d376,'headers':{'Authorization':util[_0x263b('0x48')]('Basic\x20%s',new Buffer(_0x304c4d)[_0x263b('0x4b')](_0x263b('0x4c')))},'json':!![]};rp(_0x1545f4)[_0x263b('0x1a')](function(_0x4ff2d6){var _0x2b9b12={'messageId':_0x4ff2d6[_0x263b('0x55')][0x0]};return _0x3fbade[_0x263b('0x3c')](_0x2b9b12);})[_0x263b('0x3d')](function(_0x1a99b0){logger['error'](_0x263b('0x27'),'afterCreate','plivo',util[_0x263b('0x29')](_0x1a99b0,{'showHidden':![],'depth':null}));});}else{logger['error'](_0x263b('0x27'),_0x263b('0x28'),_0x263b('0x56'),'Missing\x20parameters:\x20authId,\x20authToken');}break;case _0x263b('0x57'):if(_0x1101d5[_0x263b('0x2d')]&&_0x1101d5['password']){if(_0x1101d5['baseUrl']){var _0x4c1e5e={'method':_0x263b('0x36'),'uri':_0x1101d5['baseUrl']+_0x263b('0x58'),'body':{'username':_0x1101d5[_0x263b('0x2d')],'password':_0x1101d5['password']},'json':!![]};return rp(_0x4c1e5e)[_0x263b('0x1a')](function(_0x19caea){var _0x3f57cd={'method':_0x263b('0x36'),'uri':_0x1101d5[_0x263b('0x59')]+_0x263b('0x5a'),'body':{'messages':[{'from':_0x1101d5[_0x263b('0x20')],'destinations':[{'to':_0x6f30b[_0x263b('0x20')]}],'text':_0x6f30b[_0x263b('0xe')],'notifyUrl':_0x1101d5[_0x263b('0x21')]+_0x263b('0x22')+_0x6f30b['id']+_0x263b('0x23')+_0x1101d5[_0x263b('0x24')],'notifyContentType':_0x263b('0x5b'),'callbackData':_0x1101d5[_0x263b('0x20')]+';'+_0x6f30b[_0x263b('0xe')]}]},'headers':{'Authorization':_0x263b('0x5c')+_0x19caea[_0x263b('0x24')]},'json':!![]};return rp(_0x3f57cd)['then'](function(_0x405947){if(_0x405947[_0x263b('0x51')]){var _0x42db41={'messageId':_0x405947['messages'][0x0]['messageId']};if(!_0x1101d5['deliveryReport']){_0x42db41['read']=!![];}return _0x3fbade[_0x263b('0x3c')](_0x42db41);}else{return logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),'infobip',util[_0x263b('0x29')](_0x405947,{'showHidden':![],'depth':null}));}});})[_0x263b('0x3d')](function(_0x22c5ae){return logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),_0x263b('0x57'),util[_0x263b('0x29')](_0x22c5ae,{'showHidden':![],'depth':null}));});}else{logger['error'](_0x263b('0x27'),_0x263b('0x28'),_0x263b('0x57'),_0x263b('0x5d'));}}else{logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),_0x263b('0x57'),_0x263b('0x3e'));}break;case'csc':var _0x14dac7=require(_0x263b('0x5e'));if(_0x1101d5[_0x263b('0x5f')]){var _0x825447={};_0x825447[_0x263b('0x60')]=_0x1101d5['username'];_0x825447[_0x263b('0x20')]=_0x6f30b[_0x263b('0x20')];_0x825447['sender']=_0x1101d5[_0x263b('0x20')];_0x825447[_0x263b('0x61')]=_0x6f30b[_0x263b('0xe')];_0x825447[_0x263b('0x62')]=+new Date();var _0x53f363='';var _0x50e330='';var _0x405ccc=Object[_0x263b('0x63')](_0x825447);_0x405ccc['sort']();for(var _0x5db731=0x0;_0x5db731<_0x405ccc[_0x263b('0x64')];_0x5db731++){if(_0x53f363!=''){_0x53f363+='&';}_0x53f363+=_0x405ccc[_0x5db731]+'='+encodeURIComponent(_0x825447[_0x405ccc[_0x5db731]]);_0x50e330+=_0x825447[_0x405ccc[_0x5db731]];}_0x50e330+=_0x1101d5[_0x263b('0x5f')];_0x50e330=_0x14dac7[_0x263b('0x65')]('md5')[_0x263b('0x3c')](_0x50e330)[_0x263b('0x66')]('hex');if(_0x53f363!==''){_0x53f363+='&';}_0x53f363+='signature='+_0x50e330;var _0x2ff2f5={'method':_0x263b('0x33'),'uri':_0x1101d5[_0x263b('0x59')]+_0x263b('0x67')+_0x53f363,'json':!![]};return rp(_0x2ff2f5)[_0x263b('0x1a')](function(_0x50bca0){var _0x58ce72=Object[_0x263b('0x63')](_0x50bca0);if(_0x50bca0[_0x58ce72[0x0]][_0x263b('0x26')]&&parseInt(_0x50bca0[_0x58ce72[0x0]][_0x263b('0x26')])===0x0){var _0x2b9bac={'messageId':_0x50bca0[_0x58ce72[0x0]][_0x263b('0x68')]};if(!_0x1101d5[_0x263b('0x43')]){_0x2b9bac[_0x263b('0x3b')]=!![];}return _0x3fbade['update'](_0x2b9bac);}else{return logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),'csc',util[_0x263b('0x29')](_0x50bca0[_0x263b('0x26')],{'showHidden':![],'depth':null}));}})[_0x263b('0x3d')](function(_0x2a215e){return logger[_0x263b('0x26')](_0x263b('0x27'),'afterCreate',_0x263b('0x69'),util[_0x263b('0x29')](_0x2a215e,{'showHidden':![],'depth':null}));});}else{logger[_0x263b('0x26')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x263b('0x28'),'csc',_0x263b('0x6a'));}break;case _0x263b('0x6b'):if(_0x1101d5['apiKey']){var _0x368fa6={'method':_0x263b('0x36'),'uri':_0x263b('0x6c'),'headers':{'Authorization':_0x1101d5[_0x263b('0x5f')]},'body':{'content':_0x6f30b[_0x263b('0xe')],'to':[_0x6f30b['phone']],'from':_0x1101d5[_0x263b('0x20')],'binary':![],'clientMessageId':_0x263b('0x6d'),'charset':'UTF-8'},'json':!![]};rp(_0x368fa6)[_0x263b('0x1a')](function(_0x5d948a){if(!_0x5d948a['error']){var _0x898f0d={'messageId':_0x5d948a[_0x263b('0x51')][0x0][_0x263b('0x6e')]};if(!_0x1101d5['deliveryReport']){_0x898f0d[_0x263b('0x3b')]=!![];}return _0x3fbade['update'](_0x898f0d);}else{return logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),'clickatell',util[_0x263b('0x29')](_0x5d948a[_0x263b('0x26')],{'showHidden':![],'depth':null}));}})[_0x263b('0x3d')](function(_0x566729){return logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),_0x263b('0x6b'),util['inspect'](_0x566729,{'showHidden':![],'depth':null}));});}else{logger[_0x263b('0x26')](_0x263b('0x27'),'afterCreate',_0x263b('0x6b'),_0x263b('0x6a'));}break;case _0x263b('0x6f'):if(_0x1101d5['username']&&_0x1101d5['password']){var _0x304c4d=util[_0x263b('0x48')](_0x263b('0x49'),_0x1101d5[_0x263b('0x2d')],_0x1101d5[_0x263b('0x2e')]);var _0x1545f4={'method':_0x263b('0x36'),'uri':_0x263b('0x70')+_0x1101d5[_0x263b('0x71')]+'/messages','body':{'to':[_0x6f30b[_0x263b('0x20')]],'text':_0x6f30b[_0x263b('0xe')],'from':_0x1101d5[_0x263b('0x20')],'applicationId':_0x1101d5['applicationId']},'headers':{'Authorization':util[_0x263b('0x48')](_0x263b('0x4a'),new Buffer(_0x304c4d)[_0x263b('0x4b')]('base64'))},'json':!![]};rp(_0x1545f4)[_0x263b('0x1a')](function(_0x22f69f){if(_0x22f69f['id']){var _0x1bb46b={'messageId':_0x22f69f['id']};return _0x3fbade[_0x263b('0x3c')](_0x1bb46b);}else{logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),'bandwidth',util[_0x263b('0x29')](_0x22f69f,{'showHidden':![],'depth':null}));}})[_0x263b('0x3d')](function(_0x307909){logger[_0x263b('0x26')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x263b('0x28'),_0x263b('0x6f'),util[_0x263b('0x29')](_0x307909,{'showHidden':![],'depth':null}));});}else{logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),_0x263b('0x6f'),_0x263b('0x3e'));}break;case _0x263b('0x72'):if(_0x1101d5[_0x263b('0x5f')]){var _0x2ac16e={};var _0x2ff2f5={'method':_0x263b('0x36'),'uri':_0x263b('0x73'),'headers':{'Authorization':_0x263b('0x74')+_0x1101d5[_0x263b('0x5f')],'Content-Type':_0x263b('0x5b')},'body':{'from':_0x1101d5['phone'],'to':_0x6f30b[_0x263b('0x20')],'text':_0x6f30b['body']},'json':!![]};return rp(_0x2ff2f5)[_0x263b('0x1a')](function(_0x2a86a3){if(_0x2a86a3[_0x263b('0x75')]==0xca){_0x2ac16e['message']=_0x2a86a3;var _0x187381={'method':'POST','uri':_0x263b('0x76'),'headers':{'Authorization':_0x263b('0x74')+_0x1101d5[_0x263b('0x5f')],'Content-Type':_0x263b('0x5b')},'body':{'refid':_0x2ac16e[_0x263b('0x77')][_0x263b('0x78')]},'json':!![]};return rp(_0x187381)['then'](function(_0x2aedde){_0x2ac16e['status']=_0x2aedde;var _0x5c394b={'messageId':_0x2ac16e['message'][_0x263b('0x78')],'read':!![]};return _0x3fbade[_0x263b('0x3c')](_0x5c394b);});}else{return logger[_0x263b('0x26')](_0x263b('0x27'),'afterCreate',_0x263b('0x72'),util[_0x263b('0x29')](_0x2a86a3,{'showHidden':![],'depth':null}));}})[_0x263b('0x3d')](function(_0x51c054){return logger[_0x263b('0x26')](_0x263b('0x27'),'afterCreate',_0x263b('0x72'),util[_0x263b('0x29')](_0x51c054,{'showHidden':![],'depth':null}));});}else{return logger[_0x263b('0x26')](_0x263b('0x27'),_0x263b('0x28'),'intelepeer',_0x263b('0x79'));}break;}}})[_0x263b('0x7a')](function(){_0x8a384f();});}else{_0x8a384f();}}},'charset':_0x263b('0x7b'),'collate':'utf8mb4_unicode_ci'});};
\ No newline at end of file