Built motion from commit 52c8a02d.|2.6.29
[motion2.git] / server / api / smsMessage / smsMessage.model.js
index 0e2a0bf..ef40b74 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x422e=['UserId','SmsInteractionId','SmsInteraction','findOne','then','update','catch','SmsAccount','SmsAccountId','twilio','accountSid','authToken','phone','remote','/api/sms/messages/','/status?token=','token','error','afterCreate','skebby','https://api.skebby.it/API/v1.0/REST/','username','password','smsMethod','sender','login?username=','&password=','GET','split','POST','total_sent','internal_order_id','deliveryReport','read','SmsMessage,\x20%s,\x20%s,\x20%s','inspect','Missing\x20parameters:\x20username,\x20password','connectel','senderString','https://smsapi.connectel.se/api/v2/send/','requestid','Missing\x20parameters:\x20authToken','xCALLY\x20Motion','format','%s:%s','https://rest.clicksend.com/v3/sms/send','Basic\x20%s','toString','base64','http_code','data','queued_count','head','messages','message_id','clickSend','authId','https://api.plivo.com/v1/Account/%s/Message/','plivo','Missing\x20parameters:\x20authId,\x20authToken','infobip','baseUrl','/auth/1/session','/sms/2/text/advanced','application/json','IBSSO\x20','csc','apiKey','timestamp','keys','sort','length','createHash','md5','digest','signature=','clickatell','https://platform.clickatell.com/messages','uuid','UTF-8','Missing\x20parameters:\x20apiKey','accountId','/messages','bandwidth','intelepeer','https://api.intelepeer.com/_rest/v4/app/sms/send','Bearer\x20','code','https://api.intelepeer.com/_rest/v4/app/sms/mdr','message','status','Token\x20not\x20received','finally','utf8mb4_unicode_ci','util','../../config/logger','api','moment','bluebird','request-promise','path','rimraf','../../config/environment','exports','define','SmsMessage','sms_messages','messageId','fti_sms_messages','body','models','get','direction','toLowerCase','secret','isNil'];(function(_0x50fda9,_0x5ee44b){var _0x36b92b=function(_0x121877){while(--_0x121877){_0x50fda9['push'](_0x50fda9['shift']());}};_0x36b92b(++_0x5ee44b);}(_0x422e,0xd2));var _0xe422=function(_0x474dc4,_0x4f02ed){_0x474dc4=_0x474dc4-0x0;var _0x7548f5=_0x422e[_0x474dc4];return _0x7548f5;};'use strict';var _=require('lodash');var util=require(_0xe422('0x0'));var logger=require(_0xe422('0x1'))(_0xe422('0x2'));var moment=require(_0xe422('0x3'));var BPromise=require(_0xe422('0x4'));var rp=require(_0xe422('0x5'));var fs=require('fs');var path=require(_0xe422('0x6'));var rimraf=require(_0xe422('0x7'));var config=require(_0xe422('0x8'));var attributes=require('./smsMessage.attributes');module[_0xe422('0x9')]=function(_0x1ac166,_0x16ad7f){return _0x1ac166[_0xe422('0xa')](_0xe422('0xb'),attributes,{'tableName':_0xe422('0xc'),'paranoid':![],'indexes':[{'name':_0xe422('0xd'),'fields':[_0xe422('0xd')]},{'name':_0xe422('0xe'),'fields':[_0xe422('0xf')],'type':'FULLTEXT'}],'timestamps':!![],'hooks':{'afterCreate':function(_0xfdd998,_0xe7c0c8,_0x2b0bfa){var _0x7c7da=_0x1ac166[_0xe422('0x10')];var _0x232bea=_0xfdd998[_0xe422('0x11')]({'plain':!![]});if(_0x232bea[_0xe422('0x12')][_0xe422('0x13')]()==='in'||_0x232bea[_0xe422('0x12')][_0xe422('0x13')]()==='out'&&!_0x232bea[_0xe422('0x14')]&&!_[_0xe422('0x15')](_0x232bea[_0xe422('0x16')])&&!_[_0xe422('0x15')](_0x232bea[_0xe422('0x17')])){_0x7c7da[_0xe422('0x18')][_0xe422('0x19')]({'where':{'id':_0x232bea['SmsInteractionId']}})[_0xe422('0x1a')](function(_0x2b24f4){if(_0x2b24f4){_0x2b24f4[_0xe422('0x1b')]({'lastMsgAt':_0x232bea['createdAt'],'lastMsgDirection':_0x232bea['direction']['toLowerCase']()});}})[_0xe422('0x1c')](function(_0x41af7c){console['error'](_0x41af7c);});}if(_0x232bea[_0xe422('0x12')]==='out'&&!_0x232bea[_0xe422('0x14')]){var _0x262534;_0x7c7da[_0xe422('0x1d')]['find']({'where':{'id':_0x232bea[_0xe422('0x1e')]},'raw':!![]})[_0xe422('0x1a')](function(_0x17312f){_0x262534=_0x17312f;if(_0x262534&&_0x262534['type']){switch(_0x262534['type']){case _0xe422('0x1f'):var _0x3116ec=require(_0xe422('0x1f'));if(_0x262534[_0xe422('0x20')]&&_0x262534[_0xe422('0x21')]&&_0x262534[_0xe422('0x22')]){var _0x3ca0be=new _0x3116ec(_0x262534[_0xe422('0x20')],_0x262534[_0xe422('0x21')]);_0x3ca0be['messages']['create']({'body':_0x232bea['body'],'to':_0x232bea[_0xe422('0x22')],'from':_0x262534['phone'],'statusCallback':_0x262534[_0xe422('0x23')]+_0xe422('0x24')+_0x232bea['id']+_0xe422('0x25')+_0x262534[_0xe422('0x26')]})[_0xe422('0x1a')](function(_0x36af76){if(_0x36af76['sid']){return _0xfdd998['update']({'messageId':_0x36af76['sid']});}})['catch'](function(_0x4fead9){logger[_0xe422('0x27')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0xe422('0x28'),_0xe422('0x1f'),util['inspect'](_0x4fead9,{'showHidden':![],'depth':null}));});}else{logger[_0xe422('0x27')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0xe422('0x28'),_0xe422('0x1f'),'Missing\x20parameters:\x20phone,\x20accountSid\x20or\x20authToken');}break;case _0xe422('0x29'):var _0x3414b7=_0xe422('0x2a');if(_0x262534[_0xe422('0x2b')]&&_0x262534[_0xe422('0x2c')]){var _0x5c6a27={'recipient':[_0x232bea[_0xe422('0x22')]],'message':_0x232bea[_0xe422('0xf')],'message_type':_0x262534['smsMethod']};if(_0x262534['smsMethod']&&_0x262534[_0xe422('0x2d')]!=='SI'){_0x5c6a27[_0xe422('0x2e')]=_0x262534[_0xe422('0x22')];}var _0x33bee1={'url':_0x3414b7+_0xe422('0x2f')+_0x262534[_0xe422('0x2b')]+_0xe422('0x30')+_0x262534['password'],'method':_0xe422('0x31')};rp(_0x33bee1)[_0xe422('0x1a')](function(_0x364849){var _0x1ae3f9=_0x364849[_0xe422('0x32')](';');var _0x100c2c={'user_key':_0x1ae3f9[0x0],'session_key':_0x1ae3f9[0x1]};_0x33bee1={'url':_0x3414b7+'sms','method':_0xe422('0x33'),'headers':{'user_key':_0x100c2c['user_key'],'Session_key':_0x100c2c['session_key']},'json':!![],'body':_0x5c6a27};return rp(_0x33bee1);})[_0xe422('0x1a')](function(_0x5f1115){if(_0x5f1115[_0xe422('0x34')]>=0x1){var _0x702e17={'messageId':_0x5f1115[_0xe422('0x35')]};if(_0x262534[_0xe422('0x2d')]!=='GP'||!_0x262534[_0xe422('0x36')]){_0x702e17[_0xe422('0x37')]=!![];}return _0xfdd998[_0xe422('0x1b')](_0x702e17);}else{return logger[_0xe422('0x27')](_0xe422('0x38'),_0xe422('0x28'),'skebby',util[_0xe422('0x39')](_0x5f1115,{'showHidden':![],'depth':null}));}})[_0xe422('0x1c')](function(_0x3d3542){return logger[_0xe422('0x27')](_0xe422('0x38'),'afterCreate','skebby',util[_0xe422('0x39')](_0x3d3542,{'showHidden':![],'depth':null}));});}else{logger['error'](_0xe422('0x38'),_0xe422('0x28'),_0xe422('0x29'),_0xe422('0x3a'));}break;case _0xe422('0x3b'):if(_0x262534[_0xe422('0x21')]){var _0x36efe3={'recipient':_0x232bea[_0xe422('0x22')],'message':_0x232bea['body'],'sender':_0x262534[_0xe422('0x3c')]||_0x262534['phone'],'authorization':_0x262534[_0xe422('0x21')]};var _0xe7c0c8={'method':_0xe422('0x33'),'uri':_0xe422('0x3d'),'body':_0x36efe3,'json':!![]};rp(_0xe7c0c8)[_0xe422('0x1a')](function(_0x17ef74){var _0x39e1f8={'messageId':_0x17ef74[_0xe422('0x3e')]};if(!_0x262534['deliveryReport']){_0x39e1f8[_0xe422('0x37')]=!![];}return _0xfdd998[_0xe422('0x1b')](_0x39e1f8);})[_0xe422('0x1c')](function(_0x37a5f8){logger[_0xe422('0x27')](_0xe422('0x38'),_0xe422('0x28'),'connectel',util[_0xe422('0x39')](_0x37a5f8,{'showHidden':![],'depth':null}));});}else{logger[_0xe422('0x27')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0xe422('0x28'),'connectel',_0xe422('0x3f'));}break;case'clicksend':if(_0x262534[_0xe422('0x2b')]&&_0x262534[_0xe422('0x2c')]){var _0x36efe3={'messages':[{'source':_0xe422('0x40'),'to':_0x232bea[_0xe422('0x22')],'body':_0x232bea[_0xe422('0xf')],'from':_0x262534[_0xe422('0x3c')]||_0x262534[_0xe422('0x22')]}]};var _0x456f65=util[_0xe422('0x41')](_0xe422('0x42'),_0x262534[_0xe422('0x2b')],_0x262534[_0xe422('0x2c')]);var _0xe7c0c8={'method':_0xe422('0x33'),'uri':_0xe422('0x43'),'body':_0x36efe3,'headers':{'Authorization':util[_0xe422('0x41')](_0xe422('0x44'),new Buffer(_0x456f65)[_0xe422('0x45')](_0xe422('0x46')))},'json':!![]};rp(_0xe7c0c8)['then'](function(_0x59bf5c){if(_0x59bf5c[_0xe422('0x47')]>=0xc8&&_0x59bf5c[_0xe422('0x47')]<=0xce){if(_0x59bf5c[_0xe422('0x48')]&&_0x59bf5c[_0xe422('0x48')][_0xe422('0x49')]>0x0){var _0x2eafe9=_[_0xe422('0x4a')](_0x59bf5c['data'][_0xe422('0x4b')]);var _0x150ed7={'messageId':_0x2eafe9[_0xe422('0x4c')]};if(!_0x262534[_0xe422('0x36')]){_0x150ed7[_0xe422('0x37')]=!![];}return _0xfdd998[_0xe422('0x1b')](_0x150ed7);}else{logger[_0xe422('0x27')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0xe422('0x28'),_0xe422('0x4d'),util[_0xe422('0x39')](_0x59bf5c,{'showHidden':![],'depth':null}));}}else{logger[_0xe422('0x27')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0xe422('0x4d'),util['inspect'](_0x59bf5c,{'showHidden':![],'depth':null}));}})[_0xe422('0x1c')](function(_0x3627a9){logger[_0xe422('0x27')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0xe422('0x28'),'clickSend',util[_0xe422('0x39')](_0x3627a9,{'showHidden':![],'depth':null}));});}else{logger[_0xe422('0x27')](_0xe422('0x38'),_0xe422('0x28'),_0xe422('0x4d'),_0xe422('0x3a'));}break;case'plivo':if(_0x262534[_0xe422('0x4e')]&&_0x262534[_0xe422('0x21')]){var _0x36efe3={'dst':_0x232bea['phone'],'text':_0x232bea[_0xe422('0xf')],'src':_0x262534['senderString']||_0x262534['phone'],'url':_0x262534['remote']+'/api/sms/messages/'+_0x232bea['id']+'/status?token='+_0x262534['token']};var _0x456f65=util[_0xe422('0x41')](_0xe422('0x42'),_0x262534[_0xe422('0x4e')],_0x262534[_0xe422('0x21')]);var _0xe7c0c8={'method':'POST','uri':util[_0xe422('0x41')](_0xe422('0x4f'),_0x262534[_0xe422('0x4e')]),'body':_0x36efe3,'headers':{'Authorization':util[_0xe422('0x41')](_0xe422('0x44'),new Buffer(_0x456f65)[_0xe422('0x45')](_0xe422('0x46')))},'json':!![]};rp(_0xe7c0c8)[_0xe422('0x1a')](function(_0x8bdb95){var _0x5146f3={'messageId':_0x8bdb95['message_uuid'][0x0]};return _0xfdd998['update'](_0x5146f3);})[_0xe422('0x1c')](function(_0x1ace4a){logger['error'](_0xe422('0x38'),_0xe422('0x28'),_0xe422('0x50'),util[_0xe422('0x39')](_0x1ace4a,{'showHidden':![],'depth':null}));});}else{logger[_0xe422('0x27')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0xe422('0x28'),_0xe422('0x50'),_0xe422('0x51'));}break;case _0xe422('0x52'):if(_0x262534[_0xe422('0x2b')]&&_0x262534[_0xe422('0x2c')]){if(_0x262534[_0xe422('0x53')]){var _0xd7214c={'method':_0xe422('0x33'),'uri':_0x262534[_0xe422('0x53')]+_0xe422('0x54'),'body':{'username':_0x262534[_0xe422('0x2b')],'password':_0x262534[_0xe422('0x2c')]},'json':!![]};return rp(_0xd7214c)[_0xe422('0x1a')](function(_0x518899){var _0x55d30a={'method':'POST','uri':_0x262534[_0xe422('0x53')]+_0xe422('0x55'),'body':{'messages':[{'from':_0x262534[_0xe422('0x22')],'destinations':[{'to':_0x232bea[_0xe422('0x22')]}],'text':_0x232bea[_0xe422('0xf')],'notifyUrl':_0x262534[_0xe422('0x23')]+'/api/sms/messages/'+_0x232bea['id']+_0xe422('0x25')+_0x262534[_0xe422('0x26')],'notifyContentType':_0xe422('0x56'),'callbackData':_0x262534['phone']+';'+_0x232bea['body']}]},'headers':{'Authorization':_0xe422('0x57')+_0x518899[_0xe422('0x26')]},'json':!![]};return rp(_0x55d30a)['then'](function(_0x356031){if(_0x356031['messages']){var _0xba6616={'messageId':_0x356031['messages'][0x0][_0xe422('0xd')]};if(!_0x262534['deliveryReport']){_0xba6616[_0xe422('0x37')]=!![];}return _0xfdd998['update'](_0xba6616);}else{return logger[_0xe422('0x27')](_0xe422('0x38'),'afterCreate',_0xe422('0x52'),util[_0xe422('0x39')](_0x356031,{'showHidden':![],'depth':null}));}});})[_0xe422('0x1c')](function(_0x120dd9){return logger[_0xe422('0x27')](_0xe422('0x38'),_0xe422('0x28'),_0xe422('0x52'),util[_0xe422('0x39')](_0x120dd9,{'showHidden':![],'depth':null}));});}else{logger[_0xe422('0x27')](_0xe422('0x38'),_0xe422('0x28'),_0xe422('0x52'),'Missing\x20parameters:\x20base_url');}}else{logger['error'](_0xe422('0x38'),'afterCreate',_0xe422('0x52'),'Missing\x20parameters:\x20username,\x20password');}break;case _0xe422('0x58'):var _0x26c819=require('crypto');if(_0x262534[_0xe422('0x59')]){var _0x341aed={};_0x341aed['login']=_0x262534[_0xe422('0x2b')];_0x341aed['phone']=_0x232bea[_0xe422('0x22')];_0x341aed[_0xe422('0x2e')]=_0x262534[_0xe422('0x22')];_0x341aed['text']=_0x232bea[_0xe422('0xf')];_0x341aed[_0xe422('0x5a')]=+new Date();var _0x2b1a3f='';var _0x47b73e='';var _0x2a3e5e=Object[_0xe422('0x5b')](_0x341aed);_0x2a3e5e[_0xe422('0x5c')]();for(var _0x1a9b8e=0x0;_0x1a9b8e<_0x2a3e5e[_0xe422('0x5d')];_0x1a9b8e++){if(_0x2b1a3f!=''){_0x2b1a3f+='&';}_0x2b1a3f+=_0x2a3e5e[_0x1a9b8e]+'='+encodeURIComponent(_0x341aed[_0x2a3e5e[_0x1a9b8e]]);_0x47b73e+=_0x341aed[_0x2a3e5e[_0x1a9b8e]];}_0x47b73e+=_0x262534[_0xe422('0x59')];_0x47b73e=_0x26c819[_0xe422('0x5e')](_0xe422('0x5f'))[_0xe422('0x1b')](_0x47b73e)[_0xe422('0x60')]('hex');if(_0x2b1a3f!==''){_0x2b1a3f+='&';}_0x2b1a3f+=_0xe422('0x61')+_0x47b73e;var _0x33bee1={'method':_0xe422('0x31'),'uri':_0x262534[_0xe422('0x53')]+'/external/get/send.php?'+_0x2b1a3f,'json':!![]};return rp(_0x33bee1)['then'](function(_0x3165d6){var _0x466a0a=Object[_0xe422('0x5b')](_0x3165d6);if(_0x3165d6[_0x466a0a[0x0]][_0xe422('0x27')]&&parseInt(_0x3165d6[_0x466a0a[0x0]][_0xe422('0x27')])===0x0){var _0x25e1c8={'messageId':_0x3165d6[_0x466a0a[0x0]]['id_sms']};if(!_0x262534['deliveryReport']){_0x25e1c8[_0xe422('0x37')]=!![];}return _0xfdd998[_0xe422('0x1b')](_0x25e1c8);}else{return logger[_0xe422('0x27')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0xe422('0x28'),_0xe422('0x58'),util['inspect'](_0x3165d6[_0xe422('0x27')],{'showHidden':![],'depth':null}));}})['catch'](function(_0x266e55){return logger[_0xe422('0x27')](_0xe422('0x38'),'afterCreate',_0xe422('0x58'),util[_0xe422('0x39')](_0x266e55,{'showHidden':![],'depth':null}));});}else{logger['error'](_0xe422('0x38'),_0xe422('0x28'),_0xe422('0x58'),'Missing\x20parameters:\x20apiKey');}break;case _0xe422('0x62'):if(_0x262534[_0xe422('0x59')]){var _0x46053b={'method':_0xe422('0x33'),'uri':_0xe422('0x63'),'headers':{'Authorization':_0x262534[_0xe422('0x59')]},'body':{'content':_0x232bea[_0xe422('0xf')],'to':[_0x232bea[_0xe422('0x22')]],'from':_0x262534[_0xe422('0x22')],'binary':![],'clientMessageId':_0xe422('0x64'),'charset':_0xe422('0x65')},'json':!![]};rp(_0x46053b)[_0xe422('0x1a')](function(_0x40ca38){if(!_0x40ca38[_0xe422('0x27')]){var _0x2f7b32={'messageId':_0x40ca38[_0xe422('0x4b')][0x0]['apiMessageId']};if(!_0x262534[_0xe422('0x36')]){_0x2f7b32[_0xe422('0x37')]=!![];}return _0xfdd998[_0xe422('0x1b')](_0x2f7b32);}else{return logger[_0xe422('0x27')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0xe422('0x28'),_0xe422('0x62'),util['inspect'](_0x40ca38['error'],{'showHidden':![],'depth':null}));}})[_0xe422('0x1c')](function(_0x528bd3){return logger[_0xe422('0x27')](_0xe422('0x38'),_0xe422('0x28'),_0xe422('0x62'),util[_0xe422('0x39')](_0x528bd3,{'showHidden':![],'depth':null}));});}else{logger[_0xe422('0x27')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0xe422('0x62'),_0xe422('0x66'));}break;case'bandwidth':if(_0x262534[_0xe422('0x2b')]&&_0x262534[_0xe422('0x2c')]){var _0x456f65=util['format'](_0xe422('0x42'),_0x262534[_0xe422('0x2b')],_0x262534[_0xe422('0x2c')]);var _0xe7c0c8={'method':_0xe422('0x33'),'uri':'https://messaging.bandwidth.com/api/v2/users/'+_0x262534[_0xe422('0x67')]+_0xe422('0x68'),'body':{'to':[_0x232bea[_0xe422('0x22')]],'text':_0x232bea[_0xe422('0xf')],'from':_0x262534[_0xe422('0x22')],'applicationId':_0x262534['applicationId']},'headers':{'Authorization':util[_0xe422('0x41')](_0xe422('0x44'),new Buffer(_0x456f65)[_0xe422('0x45')](_0xe422('0x46')))},'json':!![]};rp(_0xe7c0c8)[_0xe422('0x1a')](function(_0x1ab0e5){if(_0x1ab0e5['id']){var _0x1ae78a={'messageId':_0x1ab0e5['id']};return _0xfdd998[_0xe422('0x1b')](_0x1ae78a);}else{logger[_0xe422('0x27')](_0xe422('0x38'),_0xe422('0x28'),_0xe422('0x69'),util['inspect'](_0x1ab0e5,{'showHidden':![],'depth':null}));}})['catch'](function(_0x152468){logger[_0xe422('0x27')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0xe422('0x69'),util[_0xe422('0x39')](_0x152468,{'showHidden':![],'depth':null}));});}else{logger[_0xe422('0x27')](_0xe422('0x38'),_0xe422('0x28'),'bandwidth',_0xe422('0x3a'));}break;case _0xe422('0x6a'):if(_0x262534[_0xe422('0x59')]){var _0x1a76e3={};var _0x33bee1={'method':_0xe422('0x33'),'uri':_0xe422('0x6b'),'headers':{'Authorization':_0xe422('0x6c')+_0x262534[_0xe422('0x59')],'Content-Type':_0xe422('0x56')},'body':{'from':_0x262534[_0xe422('0x22')],'to':_0x232bea[_0xe422('0x22')],'text':_0x232bea[_0xe422('0xf')]},'json':!![]};return rp(_0x33bee1)[_0xe422('0x1a')](function(_0x4a695e){if(_0x4a695e[_0xe422('0x6d')]==0xca){_0x1a76e3['message']=_0x4a695e;var _0xde8d1={'method':_0xe422('0x33'),'uri':_0xe422('0x6e'),'headers':{'Authorization':_0xe422('0x6c')+_0x262534['apiKey'],'Content-Type':_0xe422('0x56')},'body':{'refid':_0x1a76e3[_0xe422('0x6f')]['refid']},'json':!![]};return rp(_0xde8d1)[_0xe422('0x1a')](function(_0x4bb94e){_0x1a76e3[_0xe422('0x70')]=_0x4bb94e;var _0x24bec7={'messageId':_0x1a76e3[_0xe422('0x6f')]['refid'],'read':!![]};return _0xfdd998['update'](_0x24bec7);});}else{return logger[_0xe422('0x27')](_0xe422('0x38'),_0xe422('0x28'),_0xe422('0x6a'),util['inspect'](_0x4a695e,{'showHidden':![],'depth':null}));}})[_0xe422('0x1c')](function(_0x262e02){return logger[_0xe422('0x27')](_0xe422('0x38'),_0xe422('0x28'),_0xe422('0x6a'),util[_0xe422('0x39')](_0x262e02,{'showHidden':![],'depth':null}));});}else{return logger[_0xe422('0x27')](_0xe422('0x38'),_0xe422('0x28'),_0xe422('0x6a'),_0xe422('0x71'));}break;}}})[_0xe422('0x72')](function(){_0x2b0bfa();});}else{_0x2b0bfa();}}},'charset':'utf8mb4','collate':_0xe422('0x73')});};
\ 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