Built motion from commit 9d0783e6.|2.6.13
[motion2.git] / server / api / smsMessage / smsMessage.model.js
index f159c43..9f1ac15 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x8180=['SmsAccount','find','SmsAccountId','type','twilio','authToken','phone','accountSid','messages','create','body','remote','/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/','username','password','smsMethod','sender','login?username=','&password=','GET','split','sms','POST','total_sent','internal_order_id','deliveryReport','Missing\x20parameters:\x20username,\x20password','https://smsapi.connectel.se/api/v2/send/','requestid','read','connectel','Missing\x20parameters:\x20authToken','clicksend','xCALLY\x20Motion','%s:%s','https://rest.clicksend.com/v3/sms/send','format','toString','base64','data','queued_count','head','clickSend','plivo','authId','senderString','/status?token=','Basic\x20%s','message_uuid','Missing\x20parameters:\x20authId,\x20authToken','baseUrl','/auth/1/session','/sms/2/text/advanced','application/json','IBSSO\x20','infobip','csc','crypto','apiKey','login','text','timestamp','keys','sort','createHash','md5','digest','hex','signature=','/external/get/send.php?','id_sms','Missing\x20parameters:\x20apiKey','clickatell','uuid','UTF-8','/messages','applicationId','bandwidth','https://api.intelepeer.com/_rest/v4/app/sms/send','Bearer\x20','message','refid','status','intelepeer','Token\x20not\x20received','finally','utf8mb4_unicode_ci','lodash','util','../../config/logger','api','moment','bluebird','request-promise','path','../../config/environment','./smsMessage.attributes','exports','define','SmsMessage','messageId','fti_sms_messages','FULLTEXT','get','toLowerCase','direction','secret','isNil','UserId','SmsInteraction','findOne','SmsInteractionId','then','update','createdAt','catch','error','out'];(function(_0x26d6d9,_0x431cb8){var _0x1b4875=function(_0x41111f){while(--_0x41111f){_0x26d6d9['push'](_0x26d6d9['shift']());}};_0x1b4875(++_0x431cb8);}(_0x8180,0x15b));var _0x0818=function(_0xa148b7,_0x2f3eb2){_0xa148b7=_0xa148b7-0x0;var _0x51efd3=_0x8180[_0xa148b7];return _0x51efd3;};'use strict';var _=require(_0x0818('0x0'));var util=require(_0x0818('0x1'));var logger=require(_0x0818('0x2'))(_0x0818('0x3'));var moment=require(_0x0818('0x4'));var BPromise=require(_0x0818('0x5'));var rp=require(_0x0818('0x6'));var fs=require('fs');var path=require(_0x0818('0x7'));var rimraf=require('rimraf');var config=require(_0x0818('0x8'));var attributes=require(_0x0818('0x9'));module[_0x0818('0xa')]=function(_0x5696c5,_0xf44e77){return _0x5696c5[_0x0818('0xb')](_0x0818('0xc'),attributes,{'tableName':'sms_messages','paranoid':![],'indexes':[{'name':_0x0818('0xd'),'fields':[_0x0818('0xd')]},{'name':_0x0818('0xe'),'fields':['body'],'type':_0x0818('0xf')}],'timestamps':!![],'hooks':{'afterCreate':function(_0x5cd9f0,_0x5db7c2,_0x2393b3){var _0x2400ef=_0x5696c5['models'];var _0x5b4552=_0x5cd9f0[_0x0818('0x10')]({'plain':!![]});if(_0x5b4552['direction'][_0x0818('0x11')]()==='in'||_0x5b4552[_0x0818('0x12')][_0x0818('0x11')]()==='out'&&!_0x5b4552[_0x0818('0x13')]&&!_[_0x0818('0x14')](_0x5b4552[_0x0818('0x15')])){_0x2400ef[_0x0818('0x16')][_0x0818('0x17')]({'where':{'id':_0x5b4552[_0x0818('0x18')]}})[_0x0818('0x19')](function(_0x1227f8){if(_0x1227f8){_0x1227f8[_0x0818('0x1a')]({'lastMsgAt':_0x5b4552[_0x0818('0x1b')],'lastMsgDirection':_0x5b4552[_0x0818('0x12')]['toLowerCase']()});}})[_0x0818('0x1c')](function(_0x523fb3){console[_0x0818('0x1d')](_0x523fb3);});}if(_0x5b4552[_0x0818('0x12')]===_0x0818('0x1e')&&!_0x5b4552['secret']){var _0x533f93;_0x2400ef[_0x0818('0x1f')][_0x0818('0x20')]({'where':{'id':_0x5b4552[_0x0818('0x21')]},'raw':!![]})[_0x0818('0x19')](function(_0x2362eb){_0x533f93=_0x2362eb;if(_0x533f93&&_0x533f93[_0x0818('0x22')]){switch(_0x533f93[_0x0818('0x22')]){case _0x0818('0x23'):var _0x4b43da=require(_0x0818('0x23'));if(_0x533f93['accountSid']&&_0x533f93[_0x0818('0x24')]&&_0x533f93[_0x0818('0x25')]){var _0x198ae1=new _0x4b43da(_0x533f93[_0x0818('0x26')],_0x533f93[_0x0818('0x24')]);_0x198ae1[_0x0818('0x27')][_0x0818('0x28')]({'body':_0x5b4552[_0x0818('0x29')],'to':_0x5b4552[_0x0818('0x25')],'from':_0x533f93['phone'],'statusCallback':_0x533f93[_0x0818('0x2a')]+_0x0818('0x2b')+_0x5b4552['id']+'/status?token='+_0x533f93[_0x0818('0x2c')]})['then'](function(_0x173d0b){if(_0x173d0b['sid']){return _0x5cd9f0[_0x0818('0x1a')]({'messageId':_0x173d0b[_0x0818('0x2d')]});}})[_0x0818('0x1c')](function(_0x8f8344){logger['error'](_0x0818('0x2e'),_0x0818('0x2f'),'twilio',util[_0x0818('0x30')](_0x8f8344,{'showHidden':![],'depth':null}));});}else{logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x23'),_0x0818('0x31'));}break;case _0x0818('0x32'):var _0x21448c=_0x0818('0x33');if(_0x533f93[_0x0818('0x34')]&&_0x533f93[_0x0818('0x35')]){var _0x580af9={'recipient':[_0x5b4552[_0x0818('0x25')]],'message':_0x5b4552['body'],'message_type':_0x533f93[_0x0818('0x36')]};if(_0x533f93['smsMethod']&&_0x533f93['smsMethod']!=='SI'){_0x580af9[_0x0818('0x37')]=_0x533f93['phone'];}var _0x342957={'url':_0x21448c+_0x0818('0x38')+_0x533f93[_0x0818('0x34')]+_0x0818('0x39')+_0x533f93[_0x0818('0x35')],'method':_0x0818('0x3a')};rp(_0x342957)[_0x0818('0x19')](function(_0x417b7f){var _0xc6c321=_0x417b7f[_0x0818('0x3b')](';');var _0x421a39={'user_key':_0xc6c321[0x0],'session_key':_0xc6c321[0x1]};_0x342957={'url':_0x21448c+_0x0818('0x3c'),'method':_0x0818('0x3d'),'headers':{'user_key':_0x421a39['user_key'],'Session_key':_0x421a39['session_key']},'json':!![],'body':_0x580af9};return rp(_0x342957);})[_0x0818('0x19')](function(_0x3ecad3){if(_0x3ecad3[_0x0818('0x3e')]>=0x1){var _0x28322f={'messageId':_0x3ecad3[_0x0818('0x3f')]};if(_0x533f93[_0x0818('0x36')]!=='GP'||!_0x533f93[_0x0818('0x40')]){_0x28322f['read']=!![];}return _0x5cd9f0['update'](_0x28322f);}else{return logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x32'),util[_0x0818('0x30')](_0x3ecad3,{'showHidden':![],'depth':null}));}})[_0x0818('0x1c')](function(_0x38797a){return logger['error'](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x32'),util[_0x0818('0x30')](_0x38797a,{'showHidden':![],'depth':null}));});}else{logger[_0x0818('0x1d')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x0818('0x2f'),_0x0818('0x32'),_0x0818('0x41'));}break;case'connectel':if(_0x533f93[_0x0818('0x24')]){var _0x4d7e45={'recipient':_0x5b4552[_0x0818('0x25')],'message':_0x5b4552[_0x0818('0x29')],'sender':_0x533f93['senderString']||_0x533f93[_0x0818('0x25')],'authorization':_0x533f93[_0x0818('0x24')]};var _0x5db7c2={'method':_0x0818('0x3d'),'uri':_0x0818('0x42'),'body':_0x4d7e45,'json':!![]};rp(_0x5db7c2)[_0x0818('0x19')](function(_0x94805c){var _0x430d36={'messageId':_0x94805c[_0x0818('0x43')]};if(!_0x533f93['deliveryReport']){_0x430d36[_0x0818('0x44')]=!![];}return _0x5cd9f0[_0x0818('0x1a')](_0x430d36);})['catch'](function(_0x5f26d1){logger['error'](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x45'),util[_0x0818('0x30')](_0x5f26d1,{'showHidden':![],'depth':null}));});}else{logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s',_0x0818('0x2f'),_0x0818('0x45'),_0x0818('0x46'));}break;case _0x0818('0x47'):if(_0x533f93['username']&&_0x533f93['password']){var _0x4d7e45={'messages':[{'source':_0x0818('0x48'),'to':_0x5b4552[_0x0818('0x25')],'body':_0x5b4552['body'],'from':_0x533f93['senderString']||_0x533f93[_0x0818('0x25')]}]};var _0x154204=util['format'](_0x0818('0x49'),_0x533f93['username'],_0x533f93[_0x0818('0x35')]);var _0x5db7c2={'method':_0x0818('0x3d'),'uri':_0x0818('0x4a'),'body':_0x4d7e45,'headers':{'Authorization':util[_0x0818('0x4b')]('Basic\x20%s',new Buffer(_0x154204)[_0x0818('0x4c')](_0x0818('0x4d')))},'json':!![]};rp(_0x5db7c2)[_0x0818('0x19')](function(_0x2c7f61){if(_0x2c7f61['http_code']>=0xc8&&_0x2c7f61['http_code']<=0xce){if(_0x2c7f61['data']&&_0x2c7f61[_0x0818('0x4e')][_0x0818('0x4f')]>0x0){var _0x3bde98=_[_0x0818('0x50')](_0x2c7f61[_0x0818('0x4e')][_0x0818('0x27')]);var _0x57a170={'messageId':_0x3bde98['message_id']};if(!_0x533f93[_0x0818('0x40')]){_0x57a170[_0x0818('0x44')]=!![];}return _0x5cd9f0[_0x0818('0x1a')](_0x57a170);}else{logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),'clickSend',util[_0x0818('0x30')](_0x2c7f61,{'showHidden':![],'depth':null}));}}else{logger[_0x0818('0x1d')](_0x0818('0x2e'),'afterCreate',_0x0818('0x51'),util[_0x0818('0x30')](_0x2c7f61,{'showHidden':![],'depth':null}));}})[_0x0818('0x1c')](function(_0x4e64fc){logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x51'),util[_0x0818('0x30')](_0x4e64fc,{'showHidden':![],'depth':null}));});}else{logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x51'),_0x0818('0x41'));}break;case _0x0818('0x52'):if(_0x533f93[_0x0818('0x53')]&&_0x533f93[_0x0818('0x24')]){var _0x4d7e45={'dst':_0x5b4552[_0x0818('0x25')],'text':_0x5b4552['body'],'src':_0x533f93[_0x0818('0x54')]||_0x533f93[_0x0818('0x25')],'url':_0x533f93[_0x0818('0x2a')]+_0x0818('0x2b')+_0x5b4552['id']+_0x0818('0x55')+_0x533f93[_0x0818('0x2c')]};var _0x154204=util[_0x0818('0x4b')]('%s:%s',_0x533f93['authId'],_0x533f93['authToken']);var _0x5db7c2={'method':_0x0818('0x3d'),'uri':util[_0x0818('0x4b')]('https://api.plivo.com/v1/Account/%s/Message/',_0x533f93[_0x0818('0x53')]),'body':_0x4d7e45,'headers':{'Authorization':util[_0x0818('0x4b')](_0x0818('0x56'),new Buffer(_0x154204)['toString']('base64'))},'json':!![]};rp(_0x5db7c2)['then'](function(_0x35d5f2){var _0x1d8aa8={'messageId':_0x35d5f2[_0x0818('0x57')][0x0]};return _0x5cd9f0[_0x0818('0x1a')](_0x1d8aa8);})[_0x0818('0x1c')](function(_0x3ccfe8){logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x52'),util['inspect'](_0x3ccfe8,{'showHidden':![],'depth':null}));});}else{logger[_0x0818('0x1d')](_0x0818('0x2e'),'afterCreate',_0x0818('0x52'),_0x0818('0x58'));}break;case'infobip':if(_0x533f93['username']&&_0x533f93['password']){if(_0x533f93[_0x0818('0x59')]){var _0xe43aef={'method':_0x0818('0x3d'),'uri':_0x533f93[_0x0818('0x59')]+_0x0818('0x5a'),'body':{'username':_0x533f93[_0x0818('0x34')],'password':_0x533f93[_0x0818('0x35')]},'json':!![]};return rp(_0xe43aef)['then'](function(_0x4b8425){var _0x3666a0={'method':_0x0818('0x3d'),'uri':_0x533f93[_0x0818('0x59')]+_0x0818('0x5b'),'body':{'messages':[{'from':_0x533f93[_0x0818('0x25')],'destinations':[{'to':_0x5b4552[_0x0818('0x25')]}],'text':_0x5b4552[_0x0818('0x29')],'notifyUrl':_0x533f93['remote']+_0x0818('0x2b')+_0x5b4552['id']+_0x0818('0x55')+_0x533f93[_0x0818('0x2c')],'notifyContentType':_0x0818('0x5c'),'callbackData':_0x533f93[_0x0818('0x25')]+';'+_0x5b4552[_0x0818('0x29')]}]},'headers':{'Authorization':_0x0818('0x5d')+_0x4b8425[_0x0818('0x2c')]},'json':!![]};return rp(_0x3666a0)[_0x0818('0x19')](function(_0x5268cb){if(_0x5268cb['messages']){var _0xfa406b={'messageId':_0x5268cb[_0x0818('0x27')][0x0][_0x0818('0xd')]};if(!_0x533f93[_0x0818('0x40')]){_0xfa406b[_0x0818('0x44')]=!![];}return _0x5cd9f0[_0x0818('0x1a')](_0xfa406b);}else{return logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),'infobip',util['inspect'](_0x5268cb,{'showHidden':![],'depth':null}));}});})[_0x0818('0x1c')](function(_0x235350){return logger[_0x0818('0x1d')](_0x0818('0x2e'),'afterCreate','infobip',util[_0x0818('0x30')](_0x235350,{'showHidden':![],'depth':null}));});}else{logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x5e'),'Missing\x20parameters:\x20base_url');}}else{logger[_0x0818('0x1d')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x0818('0x2f'),'infobip',_0x0818('0x41'));}break;case _0x0818('0x5f'):var _0x33de36=require(_0x0818('0x60'));if(_0x533f93[_0x0818('0x61')]){var _0x26a35f={};_0x26a35f[_0x0818('0x62')]=_0x533f93[_0x0818('0x34')];_0x26a35f[_0x0818('0x25')]=_0x5b4552['phone'];_0x26a35f[_0x0818('0x37')]=_0x533f93[_0x0818('0x25')];_0x26a35f[_0x0818('0x63')]=_0x5b4552['body'];_0x26a35f[_0x0818('0x64')]=+new Date();var _0x2baced='';var _0x1ec93d='';var _0x47a453=Object[_0x0818('0x65')](_0x26a35f);_0x47a453[_0x0818('0x66')]();for(var _0x3137ca=0x0;_0x3137ca<_0x47a453['length'];_0x3137ca++){if(_0x2baced!=''){_0x2baced+='&';}_0x2baced+=_0x47a453[_0x3137ca]+'='+encodeURIComponent(_0x26a35f[_0x47a453[_0x3137ca]]);_0x1ec93d+=_0x26a35f[_0x47a453[_0x3137ca]];}_0x1ec93d+=_0x533f93[_0x0818('0x61')];_0x1ec93d=_0x33de36[_0x0818('0x67')](_0x0818('0x68'))['update'](_0x1ec93d)[_0x0818('0x69')](_0x0818('0x6a'));if(_0x2baced!==''){_0x2baced+='&';}_0x2baced+=_0x0818('0x6b')+_0x1ec93d;var _0x342957={'method':_0x0818('0x3a'),'uri':_0x533f93['baseUrl']+_0x0818('0x6c')+_0x2baced,'json':!![]};return rp(_0x342957)[_0x0818('0x19')](function(_0x2b4eb3){var _0x2c3f62=Object[_0x0818('0x65')](_0x2b4eb3);if(_0x2b4eb3[_0x2c3f62[0x0]][_0x0818('0x1d')]&&parseInt(_0x2b4eb3[_0x2c3f62[0x0]][_0x0818('0x1d')])===0x0){var _0x2c5e3f={'messageId':_0x2b4eb3[_0x2c3f62[0x0]][_0x0818('0x6d')]};if(!_0x533f93['deliveryReport']){_0x2c5e3f[_0x0818('0x44')]=!![];}return _0x5cd9f0[_0x0818('0x1a')](_0x2c5e3f);}else{return logger[_0x0818('0x1d')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0x0818('0x5f'),util[_0x0818('0x30')](_0x2b4eb3[_0x0818('0x1d')],{'showHidden':![],'depth':null}));}})[_0x0818('0x1c')](function(_0x202c31){return logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x5f'),util['inspect'](_0x202c31,{'showHidden':![],'depth':null}));});}else{logger['error'](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x5f'),_0x0818('0x6e'));}break;case _0x0818('0x6f'):if(_0x533f93[_0x0818('0x61')]){var _0x533a13={'method':'POST','uri':'https://platform.clickatell.com/messages','headers':{'Authorization':_0x533f93[_0x0818('0x61')]},'body':{'content':_0x5b4552[_0x0818('0x29')],'to':[_0x5b4552['phone']],'from':_0x533f93[_0x0818('0x25')],'binary':![],'clientMessageId':_0x0818('0x70'),'charset':_0x0818('0x71')},'json':!![]};rp(_0x533a13)[_0x0818('0x19')](function(_0xb87a76){if(!_0xb87a76['error']){var _0x527723={'messageId':_0xb87a76['messages'][0x0]['apiMessageId']};if(!_0x533f93[_0x0818('0x40')]){_0x527723[_0x0818('0x44')]=!![];}return _0x5cd9f0[_0x0818('0x1a')](_0x527723);}else{return logger[_0x0818('0x1d')](_0x0818('0x2e'),'afterCreate',_0x0818('0x6f'),util['inspect'](_0xb87a76[_0x0818('0x1d')],{'showHidden':![],'depth':null}));}})[_0x0818('0x1c')](function(_0x1fc708){return logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0x0818('0x6f'),util[_0x0818('0x30')](_0x1fc708,{'showHidden':![],'depth':null}));});}else{logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),'clickatell',_0x0818('0x6e'));}break;case'bandwidth':if(_0x533f93[_0x0818('0x34')]&&_0x533f93[_0x0818('0x35')]){var _0x154204=util[_0x0818('0x4b')](_0x0818('0x49'),_0x533f93['username'],_0x533f93[_0x0818('0x35')]);var _0x5db7c2={'method':_0x0818('0x3d'),'uri':'https://messaging.bandwidth.com/api/v2/users/'+_0x533f93['accountId']+_0x0818('0x72'),'body':{'to':[_0x5b4552[_0x0818('0x25')]],'text':_0x5b4552[_0x0818('0x29')],'from':_0x533f93[_0x0818('0x25')],'applicationId':_0x533f93[_0x0818('0x73')]},'headers':{'Authorization':util[_0x0818('0x4b')](_0x0818('0x56'),new Buffer(_0x154204)['toString'](_0x0818('0x4d')))},'json':!![]};rp(_0x5db7c2)[_0x0818('0x19')](function(_0x2684ce){if(_0x2684ce['id']){var _0x1702fa={'messageId':_0x2684ce['id']};return _0x5cd9f0[_0x0818('0x1a')](_0x1702fa);}else{logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x74'),util[_0x0818('0x30')](_0x2684ce,{'showHidden':![],'depth':null}));}})[_0x0818('0x1c')](function(_0x511baa){logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x74'),util[_0x0818('0x30')](_0x511baa,{'showHidden':![],'depth':null}));});}else{logger[_0x0818('0x1d')](_0x0818('0x2e'),'afterCreate',_0x0818('0x74'),_0x0818('0x41'));}break;case'intelepeer':if(_0x533f93[_0x0818('0x61')]){var _0x6efc25={};var _0x342957={'method':_0x0818('0x3d'),'uri':_0x0818('0x75'),'headers':{'Authorization':_0x0818('0x76')+_0x533f93['apiKey'],'Content-Type':_0x0818('0x5c')},'body':{'from':_0x533f93[_0x0818('0x25')],'to':_0x5b4552[_0x0818('0x25')],'text':_0x5b4552[_0x0818('0x29')]},'json':!![]};return rp(_0x342957)['then'](function(_0x2d3a3a){if(_0x2d3a3a['code']==0xca){_0x6efc25[_0x0818('0x77')]=_0x2d3a3a;var _0xd6a4b7={'method':'POST','uri':'https://api.intelepeer.com/_rest/v4/app/sms/mdr','headers':{'Authorization':'Bearer\x20'+_0x533f93[_0x0818('0x61')],'Content-Type':_0x0818('0x5c')},'body':{'refid':_0x6efc25[_0x0818('0x77')][_0x0818('0x78')]},'json':!![]};return rp(_0xd6a4b7)['then'](function(_0x1d6285){_0x6efc25[_0x0818('0x79')]=_0x1d6285;var _0x174ac8={'messageId':_0x6efc25[_0x0818('0x77')][_0x0818('0x78')],'read':!![]};return _0x5cd9f0[_0x0818('0x1a')](_0x174ac8);});}else{return logger[_0x0818('0x1d')](_0x0818('0x2e'),'afterCreate',_0x0818('0x7a'),util[_0x0818('0x30')](_0x2d3a3a,{'showHidden':![],'depth':null}));}})[_0x0818('0x1c')](function(_0x544710){return logger[_0x0818('0x1d')](_0x0818('0x2e'),_0x0818('0x2f'),_0x0818('0x7a'),util['inspect'](_0x544710,{'showHidden':![],'depth':null}));});}else{return logger[_0x0818('0x1d')](_0x0818('0x2e'),'afterCreate',_0x0818('0x7a'),_0x0818('0x7b'));}break;}}})[_0x0818('0x7c')](function(){_0x2393b3();});}else{_0x2393b3();}}},'charset':'utf8mb4','collate':_0x0818('0x7d')});};
\ No newline at end of file
+var _0x35d1=['data','queued_count','head','message_id','clickSend','plivo','authId','/api/sms/messages/','https://api.plivo.com/v1/Account/%s/Message/','Basic\x20%s','message_uuid','Missing\x20parameters:\x20authId,\x20authToken','baseUrl','/auth/1/session','/sms/2/text/advanced','application/json','IBSSO\x20','infobip','csc','crypto','login','timestamp','keys','sort','length','apiKey','createHash','md5','digest','hex','signature=','id_sms','Missing\x20parameters:\x20apiKey','https://platform.clickatell.com/messages','uuid','UTF-8','apiMessageId','clickatell','bandwidth','https://messaging.bandwidth.com/api/v2/users/','intelepeer','https://api.intelepeer.com/_rest/v4/app/sms/send','Bearer\x20','code','message','https://api.intelepeer.com/_rest/v4/app/sms/mdr','Token\x20not\x20received','finally','utf8mb4','lodash','util','../../config/logger','api','request-promise','path','rimraf','./smsMessage.attributes','exports','define','SmsMessage','sms_messages','messageId','fti_sms_messages','body','FULLTEXT','get','direction','toLowerCase','out','secret','isNil','UserId','SmsInteractionId','SmsInteraction','update','createdAt','catch','SmsAccount','SmsAccountId','then','twilio','accountSid','authToken','phone','messages','create','remote','/status?token=','token','sid','SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate','inspect','error','Missing\x20parameters:\x20phone,\x20accountSid\x20or\x20authToken','skebby','https://api.skebby.it/API/v1.0/REST/','password','smsMethod','sender','login?username=','username','&password=','GET','split','sms','POST','user_key','session_key','total_sent','deliveryReport','read','Missing\x20parameters:\x20username,\x20password','connectel','senderString','https://smsapi.connectel.se/api/v2/send/','clicksend','xCALLY\x20Motion','%s:%s','format','toString','base64','http_code'];(function(_0xc82f28,_0x24e29a){var _0x5608b1=function(_0x1e1ab5){while(--_0x1e1ab5){_0xc82f28['push'](_0xc82f28['shift']());}};_0x5608b1(++_0x24e29a);}(_0x35d1,0x127));var _0x135d=function(_0x4450b1,_0x214ace){_0x4450b1=_0x4450b1-0x0;var _0x399b0b=_0x35d1[_0x4450b1];return _0x399b0b;};'use strict';var _=require(_0x135d('0x0'));var util=require(_0x135d('0x1'));var logger=require(_0x135d('0x2'))(_0x135d('0x3'));var moment=require('moment');var BPromise=require('bluebird');var rp=require(_0x135d('0x4'));var fs=require('fs');var path=require(_0x135d('0x5'));var rimraf=require(_0x135d('0x6'));var config=require('../../config/environment');var attributes=require(_0x135d('0x7'));module[_0x135d('0x8')]=function(_0xeadf6a,_0x1d7ca9){return _0xeadf6a[_0x135d('0x9')](_0x135d('0xa'),attributes,{'tableName':_0x135d('0xb'),'paranoid':![],'indexes':[{'name':_0x135d('0xc'),'fields':['messageId']},{'name':_0x135d('0xd'),'fields':[_0x135d('0xe')],'type':_0x135d('0xf')}],'timestamps':!![],'hooks':{'afterCreate':function(_0x133f3e,_0x2c8285,_0x7dab73){var _0xc76cc6=_0xeadf6a['models'];var _0x505129=_0x133f3e[_0x135d('0x10')]({'plain':!![]});if(_0x505129[_0x135d('0x11')][_0x135d('0x12')]()==='in'||_0x505129[_0x135d('0x11')][_0x135d('0x12')]()===_0x135d('0x13')&&!_0x505129[_0x135d('0x14')]&&!_[_0x135d('0x15')](_0x505129[_0x135d('0x16')])&&!_[_0x135d('0x15')](_0x505129[_0x135d('0x17')])){_0xc76cc6[_0x135d('0x18')]['findOne']({'where':{'id':_0x505129[_0x135d('0x17')]}})['then'](function(_0x4dab2c){if(_0x4dab2c){_0x4dab2c[_0x135d('0x19')]({'lastMsgAt':_0x505129[_0x135d('0x1a')],'lastMsgDirection':_0x505129[_0x135d('0x11')][_0x135d('0x12')]()});}})[_0x135d('0x1b')](function(_0x249fbb){console['error'](_0x249fbb);});}if(_0x505129['direction']===_0x135d('0x13')&&!_0x505129[_0x135d('0x14')]){var _0x431c62;_0xc76cc6[_0x135d('0x1c')]['find']({'where':{'id':_0x505129[_0x135d('0x1d')]},'raw':!![]})[_0x135d('0x1e')](function(_0x16a1f3){_0x431c62=_0x16a1f3;if(_0x431c62&&_0x431c62['type']){switch(_0x431c62['type']){case _0x135d('0x1f'):var _0x4695be=require(_0x135d('0x1f'));if(_0x431c62[_0x135d('0x20')]&&_0x431c62[_0x135d('0x21')]&&_0x431c62[_0x135d('0x22')]){var _0x436654=new _0x4695be(_0x431c62['accountSid'],_0x431c62[_0x135d('0x21')]);_0x436654[_0x135d('0x23')][_0x135d('0x24')]({'body':_0x505129[_0x135d('0xe')],'to':_0x505129[_0x135d('0x22')],'from':_0x431c62[_0x135d('0x22')],'statusCallback':_0x431c62[_0x135d('0x25')]+'/api/sms/messages/'+_0x505129['id']+_0x135d('0x26')+_0x431c62[_0x135d('0x27')]})[_0x135d('0x1e')](function(_0x129a07){if(_0x129a07[_0x135d('0x28')]){return _0x133f3e[_0x135d('0x19')]({'messageId':_0x129a07[_0x135d('0x28')]});}})[_0x135d('0x1b')](function(_0x2c0e2d){logger['error'](_0x135d('0x29'),_0x135d('0x2a'),_0x135d('0x1f'),util[_0x135d('0x2b')](_0x2c0e2d,{'showHidden':![],'depth':null}));});}else{logger[_0x135d('0x2c')](_0x135d('0x29'),_0x135d('0x2a'),'twilio',_0x135d('0x2d'));}break;case _0x135d('0x2e'):var _0x527cb1=_0x135d('0x2f');if(_0x431c62['username']&&_0x431c62[_0x135d('0x30')]){var _0xafcaa3={'recipient':[_0x505129[_0x135d('0x22')]],'message':_0x505129[_0x135d('0xe')],'message_type':_0x431c62['smsMethod']};if(_0x431c62['smsMethod']&&_0x431c62[_0x135d('0x31')]!=='SI'){_0xafcaa3[_0x135d('0x32')]=_0x431c62['phone'];}var _0x12fda9={'url':_0x527cb1+_0x135d('0x33')+_0x431c62[_0x135d('0x34')]+_0x135d('0x35')+_0x431c62[_0x135d('0x30')],'method':_0x135d('0x36')};rp(_0x12fda9)[_0x135d('0x1e')](function(_0x469e41){var _0x1d1f95=_0x469e41[_0x135d('0x37')](';');var _0x8263ae={'user_key':_0x1d1f95[0x0],'session_key':_0x1d1f95[0x1]};_0x12fda9={'url':_0x527cb1+_0x135d('0x38'),'method':_0x135d('0x39'),'headers':{'user_key':_0x8263ae[_0x135d('0x3a')],'Session_key':_0x8263ae[_0x135d('0x3b')]},'json':!![],'body':_0xafcaa3};return rp(_0x12fda9);})[_0x135d('0x1e')](function(_0x46035f){if(_0x46035f[_0x135d('0x3c')]>=0x1){var _0x48f9c7={'messageId':_0x46035f['internal_order_id']};if(_0x431c62[_0x135d('0x31')]!=='GP'||!_0x431c62[_0x135d('0x3d')]){_0x48f9c7[_0x135d('0x3e')]=!![];}return _0x133f3e['update'](_0x48f9c7);}else{return logger[_0x135d('0x2c')](_0x135d('0x29'),_0x135d('0x2a'),_0x135d('0x2e'),util[_0x135d('0x2b')](_0x46035f,{'showHidden':![],'depth':null}));}})[_0x135d('0x1b')](function(_0x29cf06){return logger['error'](_0x135d('0x29'),_0x135d('0x2a'),_0x135d('0x2e'),util['inspect'](_0x29cf06,{'showHidden':![],'depth':null}));});}else{logger['error'](_0x135d('0x29'),_0x135d('0x2a'),_0x135d('0x2e'),_0x135d('0x3f'));}break;case _0x135d('0x40'):if(_0x431c62[_0x135d('0x21')]){var _0xd417e9={'recipient':_0x505129[_0x135d('0x22')],'message':_0x505129[_0x135d('0xe')],'sender':_0x431c62[_0x135d('0x41')]||_0x431c62['phone'],'authorization':_0x431c62[_0x135d('0x21')]};var _0x2c8285={'method':'POST','uri':_0x135d('0x42'),'body':_0xd417e9,'json':!![]};rp(_0x2c8285)['then'](function(_0x1c80ae){var _0x50458d={'messageId':_0x1c80ae['requestid']};if(!_0x431c62['deliveryReport']){_0x50458d[_0x135d('0x3e')]=!![];}return _0x133f3e[_0x135d('0x19')](_0x50458d);})[_0x135d('0x1b')](function(_0x2e9422){logger[_0x135d('0x2c')](_0x135d('0x29'),_0x135d('0x2a'),'connectel',util[_0x135d('0x2b')](_0x2e9422,{'showHidden':![],'depth':null}));});}else{logger[_0x135d('0x2c')](_0x135d('0x29'),_0x135d('0x2a'),_0x135d('0x40'),'Missing\x20parameters:\x20authToken');}break;case _0x135d('0x43'):if(_0x431c62[_0x135d('0x34')]&&_0x431c62[_0x135d('0x30')]){var _0xd417e9={'messages':[{'source':_0x135d('0x44'),'to':_0x505129['phone'],'body':_0x505129[_0x135d('0xe')],'from':_0x431c62[_0x135d('0x41')]||_0x431c62['phone']}]};var _0x10dcf9=util['format'](_0x135d('0x45'),_0x431c62[_0x135d('0x34')],_0x431c62['password']);var _0x2c8285={'method':_0x135d('0x39'),'uri':'https://rest.clicksend.com/v3/sms/send','body':_0xd417e9,'headers':{'Authorization':util[_0x135d('0x46')]('Basic\x20%s',new Buffer(_0x10dcf9)[_0x135d('0x47')](_0x135d('0x48')))},'json':!![]};rp(_0x2c8285)['then'](function(_0x45d2ca){if(_0x45d2ca[_0x135d('0x49')]>=0xc8&&_0x45d2ca['http_code']<=0xce){if(_0x45d2ca[_0x135d('0x4a')]&&_0x45d2ca['data'][_0x135d('0x4b')]>0x0){var _0x574cdf=_[_0x135d('0x4c')](_0x45d2ca[_0x135d('0x4a')][_0x135d('0x23')]);var _0x2e23c1={'messageId':_0x574cdf[_0x135d('0x4d')]};if(!_0x431c62[_0x135d('0x3d')]){_0x2e23c1[_0x135d('0x3e')]=!![];}return _0x133f3e[_0x135d('0x19')](_0x2e23c1);}else{logger['error'](_0x135d('0x29'),_0x135d('0x2a'),'clickSend',util['inspect'](_0x45d2ca,{'showHidden':![],'depth':null}));}}else{logger[_0x135d('0x2c')](_0x135d('0x29'),_0x135d('0x2a'),'clickSend',util[_0x135d('0x2b')](_0x45d2ca,{'showHidden':![],'depth':null}));}})[_0x135d('0x1b')](function(_0x2a6d56){logger[_0x135d('0x2c')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0x135d('0x4e'),util[_0x135d('0x2b')](_0x2a6d56,{'showHidden':![],'depth':null}));});}else{logger[_0x135d('0x2c')](_0x135d('0x29'),_0x135d('0x2a'),_0x135d('0x4e'),_0x135d('0x3f'));}break;case _0x135d('0x4f'):if(_0x431c62[_0x135d('0x50')]&&_0x431c62[_0x135d('0x21')]){var _0xd417e9={'dst':_0x505129['phone'],'text':_0x505129[_0x135d('0xe')],'src':_0x431c62[_0x135d('0x41')]||_0x431c62[_0x135d('0x22')],'url':_0x431c62['remote']+_0x135d('0x51')+_0x505129['id']+'/status?token='+_0x431c62[_0x135d('0x27')]};var _0x10dcf9=util[_0x135d('0x46')](_0x135d('0x45'),_0x431c62[_0x135d('0x50')],_0x431c62[_0x135d('0x21')]);var _0x2c8285={'method':'POST','uri':util[_0x135d('0x46')](_0x135d('0x52'),_0x431c62[_0x135d('0x50')]),'body':_0xd417e9,'headers':{'Authorization':util[_0x135d('0x46')](_0x135d('0x53'),new Buffer(_0x10dcf9)[_0x135d('0x47')](_0x135d('0x48')))},'json':!![]};rp(_0x2c8285)['then'](function(_0x2e8329){var _0x5a29b5={'messageId':_0x2e8329[_0x135d('0x54')][0x0]};return _0x133f3e[_0x135d('0x19')](_0x5a29b5);})[_0x135d('0x1b')](function(_0x49ac71){logger[_0x135d('0x2c')](_0x135d('0x29'),'afterCreate','plivo',util[_0x135d('0x2b')](_0x49ac71,{'showHidden':![],'depth':null}));});}else{logger[_0x135d('0x2c')](_0x135d('0x29'),'afterCreate',_0x135d('0x4f'),_0x135d('0x55'));}break;case'infobip':if(_0x431c62[_0x135d('0x34')]&&_0x431c62[_0x135d('0x30')]){if(_0x431c62[_0x135d('0x56')]){var _0x32c2d1={'method':_0x135d('0x39'),'uri':_0x431c62[_0x135d('0x56')]+_0x135d('0x57'),'body':{'username':_0x431c62['username'],'password':_0x431c62['password']},'json':!![]};return rp(_0x32c2d1)[_0x135d('0x1e')](function(_0x18b20f){var _0x30962a={'method':_0x135d('0x39'),'uri':_0x431c62[_0x135d('0x56')]+_0x135d('0x58'),'body':{'messages':[{'from':_0x431c62[_0x135d('0x22')],'destinations':[{'to':_0x505129[_0x135d('0x22')]}],'text':_0x505129[_0x135d('0xe')],'notifyUrl':_0x431c62[_0x135d('0x25')]+_0x135d('0x51')+_0x505129['id']+_0x135d('0x26')+_0x431c62['token'],'notifyContentType':_0x135d('0x59'),'callbackData':_0x431c62[_0x135d('0x22')]+';'+_0x505129[_0x135d('0xe')]}]},'headers':{'Authorization':_0x135d('0x5a')+_0x18b20f[_0x135d('0x27')]},'json':!![]};return rp(_0x30962a)[_0x135d('0x1e')](function(_0x2d38d8){if(_0x2d38d8[_0x135d('0x23')]){var _0x20833d={'messageId':_0x2d38d8['messages'][0x0][_0x135d('0xc')]};if(!_0x431c62['deliveryReport']){_0x20833d[_0x135d('0x3e')]=!![];}return _0x133f3e[_0x135d('0x19')](_0x20833d);}else{return logger[_0x135d('0x2c')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0x135d('0x5b'),util[_0x135d('0x2b')](_0x2d38d8,{'showHidden':![],'depth':null}));}});})[_0x135d('0x1b')](function(_0x5015f9){return logger['error'](_0x135d('0x29'),'afterCreate',_0x135d('0x5b'),util['inspect'](_0x5015f9,{'showHidden':![],'depth':null}));});}else{logger[_0x135d('0x2c')](_0x135d('0x29'),'afterCreate',_0x135d('0x5b'),'Missing\x20parameters:\x20base_url');}}else{logger[_0x135d('0x2c')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x135d('0x2a'),_0x135d('0x5b'),_0x135d('0x3f'));}break;case _0x135d('0x5c'):var _0x3a9298=require(_0x135d('0x5d'));if(_0x431c62['apiKey']){var _0x5a00f2={};_0x5a00f2[_0x135d('0x5e')]=_0x431c62['username'];_0x5a00f2[_0x135d('0x22')]=_0x505129[_0x135d('0x22')];_0x5a00f2[_0x135d('0x32')]=_0x431c62['phone'];_0x5a00f2['text']=_0x505129[_0x135d('0xe')];_0x5a00f2[_0x135d('0x5f')]=+new Date();var _0xa659bf='';var _0x1eeba2='';var _0xb7d0c8=Object[_0x135d('0x60')](_0x5a00f2);_0xb7d0c8[_0x135d('0x61')]();for(var _0x4a4368=0x0;_0x4a4368<_0xb7d0c8[_0x135d('0x62')];_0x4a4368++){if(_0xa659bf!=''){_0xa659bf+='&';}_0xa659bf+=_0xb7d0c8[_0x4a4368]+'='+encodeURIComponent(_0x5a00f2[_0xb7d0c8[_0x4a4368]]);_0x1eeba2+=_0x5a00f2[_0xb7d0c8[_0x4a4368]];}_0x1eeba2+=_0x431c62[_0x135d('0x63')];_0x1eeba2=_0x3a9298[_0x135d('0x64')](_0x135d('0x65'))[_0x135d('0x19')](_0x1eeba2)[_0x135d('0x66')](_0x135d('0x67'));if(_0xa659bf!==''){_0xa659bf+='&';}_0xa659bf+=_0x135d('0x68')+_0x1eeba2;var _0x12fda9={'method':_0x135d('0x36'),'uri':_0x431c62[_0x135d('0x56')]+'/external/get/send.php?'+_0xa659bf,'json':!![]};return rp(_0x12fda9)[_0x135d('0x1e')](function(_0x3074c9){var _0x140239=Object['keys'](_0x3074c9);if(_0x3074c9[_0x140239[0x0]][_0x135d('0x2c')]&&parseInt(_0x3074c9[_0x140239[0x0]][_0x135d('0x2c')])===0x0){var _0x2fc167={'messageId':_0x3074c9[_0x140239[0x0]][_0x135d('0x69')]};if(!_0x431c62[_0x135d('0x3d')]){_0x2fc167['read']=!![];}return _0x133f3e[_0x135d('0x19')](_0x2fc167);}else{return logger[_0x135d('0x2c')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x135d('0x2a'),_0x135d('0x5c'),util[_0x135d('0x2b')](_0x3074c9['error'],{'showHidden':![],'depth':null}));}})[_0x135d('0x1b')](function(_0x57fdb5){return logger[_0x135d('0x2c')](_0x135d('0x29'),_0x135d('0x2a'),_0x135d('0x5c'),util[_0x135d('0x2b')](_0x57fdb5,{'showHidden':![],'depth':null}));});}else{logger[_0x135d('0x2c')](_0x135d('0x29'),_0x135d('0x2a'),_0x135d('0x5c'),_0x135d('0x6a'));}break;case'clickatell':if(_0x431c62['apiKey']){var _0x5b2eb0={'method':'POST','uri':_0x135d('0x6b'),'headers':{'Authorization':_0x431c62[_0x135d('0x63')]},'body':{'content':_0x505129[_0x135d('0xe')],'to':[_0x505129[_0x135d('0x22')]],'from':_0x431c62[_0x135d('0x22')],'binary':![],'clientMessageId':_0x135d('0x6c'),'charset':_0x135d('0x6d')},'json':!![]};rp(_0x5b2eb0)[_0x135d('0x1e')](function(_0x3f2afc){if(!_0x3f2afc[_0x135d('0x2c')]){var _0x4e09a4={'messageId':_0x3f2afc[_0x135d('0x23')][0x0][_0x135d('0x6e')]};if(!_0x431c62['deliveryReport']){_0x4e09a4[_0x135d('0x3e')]=!![];}return _0x133f3e[_0x135d('0x19')](_0x4e09a4);}else{return logger[_0x135d('0x2c')](_0x135d('0x29'),_0x135d('0x2a'),'clickatell',util[_0x135d('0x2b')](_0x3f2afc[_0x135d('0x2c')],{'showHidden':![],'depth':null}));}})[_0x135d('0x1b')](function(_0x709dc5){return logger['error'](_0x135d('0x29'),_0x135d('0x2a'),_0x135d('0x6f'),util[_0x135d('0x2b')](_0x709dc5,{'showHidden':![],'depth':null}));});}else{logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate','clickatell',_0x135d('0x6a'));}break;case _0x135d('0x70'):if(_0x431c62[_0x135d('0x34')]&&_0x431c62[_0x135d('0x30')]){var _0x10dcf9=util['format'](_0x135d('0x45'),_0x431c62['username'],_0x431c62[_0x135d('0x30')]);var _0x2c8285={'method':'POST','uri':_0x135d('0x71')+_0x431c62['accountId']+'/messages','body':{'to':[_0x505129[_0x135d('0x22')]],'text':_0x505129[_0x135d('0xe')],'from':_0x431c62[_0x135d('0x22')],'applicationId':_0x431c62['applicationId']},'headers':{'Authorization':util[_0x135d('0x46')](_0x135d('0x53'),new Buffer(_0x10dcf9)[_0x135d('0x47')](_0x135d('0x48')))},'json':!![]};rp(_0x2c8285)[_0x135d('0x1e')](function(_0x411780){if(_0x411780['id']){var _0x373058={'messageId':_0x411780['id']};return _0x133f3e['update'](_0x373058);}else{logger[_0x135d('0x2c')](_0x135d('0x29'),_0x135d('0x2a'),'bandwidth',util[_0x135d('0x2b')](_0x411780,{'showHidden':![],'depth':null}));}})[_0x135d('0x1b')](function(_0x48b0e5){logger[_0x135d('0x2c')](_0x135d('0x29'),'afterCreate',_0x135d('0x70'),util[_0x135d('0x2b')](_0x48b0e5,{'showHidden':![],'depth':null}));});}else{logger['error'](_0x135d('0x29'),_0x135d('0x2a'),_0x135d('0x70'),_0x135d('0x3f'));}break;case _0x135d('0x72'):if(_0x431c62[_0x135d('0x63')]){var _0x5dad68={};var _0x12fda9={'method':_0x135d('0x39'),'uri':_0x135d('0x73'),'headers':{'Authorization':_0x135d('0x74')+_0x431c62['apiKey'],'Content-Type':_0x135d('0x59')},'body':{'from':_0x431c62['phone'],'to':_0x505129[_0x135d('0x22')],'text':_0x505129[_0x135d('0xe')]},'json':!![]};return rp(_0x12fda9)[_0x135d('0x1e')](function(_0x4e7877){if(_0x4e7877[_0x135d('0x75')]==0xca){_0x5dad68[_0x135d('0x76')]=_0x4e7877;var _0x3d5e47={'method':_0x135d('0x39'),'uri':_0x135d('0x77'),'headers':{'Authorization':_0x135d('0x74')+_0x431c62[_0x135d('0x63')],'Content-Type':_0x135d('0x59')},'body':{'refid':_0x5dad68[_0x135d('0x76')]['refid']},'json':!![]};return rp(_0x3d5e47)[_0x135d('0x1e')](function(_0x2d35ce){_0x5dad68['status']=_0x2d35ce;var _0x1090f0={'messageId':_0x5dad68[_0x135d('0x76')]['refid'],'read':!![]};return _0x133f3e[_0x135d('0x19')](_0x1090f0);});}else{return logger['error'](_0x135d('0x29'),'afterCreate','intelepeer',util['inspect'](_0x4e7877,{'showHidden':![],'depth':null}));}})[_0x135d('0x1b')](function(_0xe03d5b){return logger['error'](_0x135d('0x29'),_0x135d('0x2a'),_0x135d('0x72'),util[_0x135d('0x2b')](_0xe03d5b,{'showHidden':![],'depth':null}));});}else{return logger['error'](_0x135d('0x29'),_0x135d('0x2a'),'intelepeer',_0x135d('0x78'));}break;}}})[_0x135d('0x79')](function(){_0x7dab73();});}else{_0x7dab73();}}},'charset':_0x135d('0x7a'),'collate':'utf8mb4_unicode_ci'});};
\ No newline at end of file