Built motion from commit (unavailable).|2.5.19
[motion2.git] / server / api / smsMessage / smsMessage.model.js
index ba5b0e4..a479453 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x6d35=['messages','create','remote','/status?token=','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','login?username=','&password=','GET','sms','POST','user_key','session_key','total_sent','deliveryReport','read','Missing\x20parameters:\x20username,\x20password','connectel','senderString','https://smsapi.connectel.se/api/send/','Missing\x20parameters:\x20authToken','clicksend','xCALLY\x20Motion','format','%s:%s','https://rest.clicksend.com/v3/sms/send','toString','base64','http_code','data','queued_count','message_id','clickSend','plivo','authId','/api/sms/messages/','infobip','baseUrl','/auth/1/session','/sms/2/text/advanced','application/json','Missing\x20parameters:\x20base_url','csc','crypto','apiKey','login','sender','text','timestamp','sort','length','createHash','md5','hex','/external/get/send.php?','Missing\x20parameters:\x20apiKey','https://platform.clickatell.com/messages','uuid','UTF-8','clickatell','https://api.intelepeer.com/_rest/v4/app/sms/send','Bearer\x20','https://api.intelepeer.com/_rest/v4/app/sms/mdr','message','status','refid','intelepeer','Token\x20not\x20received','finally','utf8mb4','utf8mb4_unicode_ci','lodash','util','moment','request-promise','path','../../config/environment','define','sms_messages','messageId','body','FULLTEXT','models','direction','toLowerCase','out','isNil','UserId','SmsInteraction','findOne','SmsInteractionId','update','createdAt','catch','error','secret','SmsAccount','find','SmsAccountId','then','type','twilio','accountSid','authToken','phone'];(function(_0x3afe25,_0x556507){var _0x43c9d7=function(_0x36eb0b){while(--_0x36eb0b){_0x3afe25['push'](_0x3afe25['shift']());}};_0x43c9d7(++_0x556507);}(_0x6d35,0x134));var _0x56d3=function(_0x3b380d,_0x4bf247){_0x3b380d=_0x3b380d-0x0;var _0x54502b=_0x6d35[_0x3b380d];return _0x54502b;};'use strict';var _=require(_0x56d3('0x0'));var util=require(_0x56d3('0x1'));var logger=require('../../config/logger')('api');var moment=require(_0x56d3('0x2'));var BPromise=require('bluebird');var rp=require(_0x56d3('0x3'));var fs=require('fs');var path=require(_0x56d3('0x4'));var rimraf=require('rimraf');var config=require(_0x56d3('0x5'));var attributes=require('./smsMessage.attributes');module['exports']=function(_0x349f1f,_0x590df8){return _0x349f1f[_0x56d3('0x6')]('SmsMessage',attributes,{'tableName':_0x56d3('0x7'),'paranoid':![],'indexes':[{'name':_0x56d3('0x8'),'fields':[_0x56d3('0x8')]},{'name':'fti_sms_messages','fields':[_0x56d3('0x9')],'type':_0x56d3('0xa')}],'timestamps':!![],'hooks':{'afterCreate':function(_0x2ebd5c,_0x44a888,_0x5c2a65){var _0x147604=_0x349f1f[_0x56d3('0xb')];var _0x30a16b=_0x2ebd5c['get']({'plain':!![]});if(_0x30a16b[_0x56d3('0xc')][_0x56d3('0xd')]()==='in'||_0x30a16b[_0x56d3('0xc')]['toLowerCase']()===_0x56d3('0xe')&&!_0x30a16b['secret']&&!_[_0x56d3('0xf')](_0x30a16b[_0x56d3('0x10')])){_0x147604[_0x56d3('0x11')][_0x56d3('0x12')]({'where':{'id':_0x30a16b[_0x56d3('0x13')]}})['then'](function(_0x507059){if(_0x507059){_0x507059[_0x56d3('0x14')]({'lastMsgAt':_0x30a16b[_0x56d3('0x15')],'lastMsgDirection':_0x30a16b[_0x56d3('0xc')][_0x56d3('0xd')]()});}})[_0x56d3('0x16')](function(_0x1a8715){console[_0x56d3('0x17')](_0x1a8715);});}if(_0x30a16b[_0x56d3('0xc')]==='out'&&!_0x30a16b[_0x56d3('0x18')]){var _0x34ee62;_0x147604[_0x56d3('0x19')][_0x56d3('0x1a')]({'where':{'id':_0x30a16b[_0x56d3('0x1b')]},'raw':!![]})[_0x56d3('0x1c')](function(_0x5e6183){_0x34ee62=_0x5e6183;if(_0x34ee62&&_0x34ee62[_0x56d3('0x1d')]){switch(_0x34ee62[_0x56d3('0x1d')]){case _0x56d3('0x1e'):var _0x5c2bc5=require(_0x56d3('0x1e'));if(_0x34ee62[_0x56d3('0x1f')]&&_0x34ee62[_0x56d3('0x20')]&&_0x34ee62[_0x56d3('0x21')]){var _0x5a5dea=new _0x5c2bc5(_0x34ee62[_0x56d3('0x1f')],_0x34ee62[_0x56d3('0x20')]);_0x5a5dea[_0x56d3('0x22')][_0x56d3('0x23')]({'body':_0x30a16b[_0x56d3('0x9')],'to':_0x30a16b['phone'],'from':_0x34ee62['phone'],'statusCallback':_0x34ee62[_0x56d3('0x24')]+'/api/sms/messages/'+_0x30a16b['id']+_0x56d3('0x25')+_0x34ee62[_0x56d3('0x26')]})[_0x56d3('0x1c')](function(_0x153291){if(_0x153291[_0x56d3('0x27')]){return _0x2ebd5c[_0x56d3('0x14')]({'messageId':_0x153291[_0x56d3('0x27')]});}})[_0x56d3('0x16')](function(_0x5f4721){logger['error'](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x1e'),util[_0x56d3('0x2a')](_0x5f4721,{'showHidden':![],'depth':null}));});}else{logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x1e'),_0x56d3('0x2b'));}break;case _0x56d3('0x2c'):var _0x7b66e4=_0x56d3('0x2d');if(_0x34ee62[_0x56d3('0x2e')]&&_0x34ee62[_0x56d3('0x2f')]){var _0x763226={'recipient':[_0x30a16b[_0x56d3('0x21')]],'message':_0x30a16b['body'],'message_type':_0x34ee62[_0x56d3('0x30')]};if(_0x34ee62['smsMethod']&&_0x34ee62[_0x56d3('0x30')]!=='SI'){_0x763226['sender']=_0x34ee62[_0x56d3('0x21')];}var _0x2e962b={'url':_0x7b66e4+_0x56d3('0x31')+_0x34ee62[_0x56d3('0x2e')]+_0x56d3('0x32')+_0x34ee62[_0x56d3('0x2f')],'method':_0x56d3('0x33')};rp(_0x2e962b)['then'](function(_0x555215){var _0x4654d6=_0x555215['split'](';');var _0x284dd4={'user_key':_0x4654d6[0x0],'session_key':_0x4654d6[0x1]};_0x2e962b={'url':_0x7b66e4+_0x56d3('0x34'),'method':_0x56d3('0x35'),'headers':{'user_key':_0x284dd4[_0x56d3('0x36')],'Session_key':_0x284dd4[_0x56d3('0x37')]},'json':!![],'body':_0x763226};return rp(_0x2e962b);})[_0x56d3('0x1c')](function(_0x3122aa){if(_0x3122aa[_0x56d3('0x38')]>=0x1){var _0x29c978={'messageId':_0x3122aa['internal_order_id']};if(_0x34ee62['smsMethod']!=='GP'||!_0x34ee62[_0x56d3('0x39')]){_0x29c978[_0x56d3('0x3a')]=!![];}return _0x2ebd5c['update'](_0x29c978);}else{return logger[_0x56d3('0x17')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0x56d3('0x2c'),util[_0x56d3('0x2a')](_0x3122aa,{'showHidden':![],'depth':null}));}})[_0x56d3('0x16')](function(_0x1b30d0){return logger['error'](_0x56d3('0x28'),'afterCreate',_0x56d3('0x2c'),util[_0x56d3('0x2a')](_0x1b30d0,{'showHidden':![],'depth':null}));});}else{logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x2c'),_0x56d3('0x3b'));}break;case _0x56d3('0x3c'):if(_0x34ee62[_0x56d3('0x20')]){var _0x2927e8={'recipient':_0x30a16b[_0x56d3('0x21')],'message':_0x30a16b[_0x56d3('0x9')],'sender':_0x34ee62[_0x56d3('0x3d')]||_0x34ee62[_0x56d3('0x21')],'authorization':_0x34ee62['authToken']};var _0x44a888={'method':'POST','uri':_0x56d3('0x3e'),'body':_0x2927e8,'json':!![]};rp(_0x44a888)[_0x56d3('0x1c')](function(_0x45c798){var _0x4c4590={'messageId':_0x45c798['requestid']};if(!_0x34ee62[_0x56d3('0x39')]){_0x4c4590[_0x56d3('0x3a')]=!![];}return _0x2ebd5c['update'](_0x4c4590);})[_0x56d3('0x16')](function(_0x38df5b){logger['error'](_0x56d3('0x28'),_0x56d3('0x29'),'connectel',util[_0x56d3('0x2a')](_0x38df5b,{'showHidden':![],'depth':null}));});}else{logger['error'](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x3c'),_0x56d3('0x3f'));}break;case _0x56d3('0x40'):if(_0x34ee62[_0x56d3('0x2e')]&&_0x34ee62[_0x56d3('0x2f')]){var _0x2927e8={'messages':[{'source':_0x56d3('0x41'),'to':_0x30a16b[_0x56d3('0x21')],'body':_0x30a16b[_0x56d3('0x9')],'from':_0x34ee62['senderString']||_0x34ee62[_0x56d3('0x21')]}]};var _0x2ffea5=util[_0x56d3('0x42')](_0x56d3('0x43'),_0x34ee62[_0x56d3('0x2e')],_0x34ee62[_0x56d3('0x2f')]);var _0x44a888={'method':_0x56d3('0x35'),'uri':_0x56d3('0x44'),'body':_0x2927e8,'headers':{'Authorization':util[_0x56d3('0x42')]('Basic\x20%s',new Buffer(_0x2ffea5)[_0x56d3('0x45')](_0x56d3('0x46')))},'json':!![]};rp(_0x44a888)['then'](function(_0x4eb3af){if(_0x4eb3af[_0x56d3('0x47')]>=0xc8&&_0x4eb3af['http_code']<=0xce){if(_0x4eb3af[_0x56d3('0x48')]&&_0x4eb3af['data'][_0x56d3('0x49')]>0x0){var _0x2f7d24=_['head'](_0x4eb3af[_0x56d3('0x48')][_0x56d3('0x22')]);var _0x45e485={'messageId':_0x2f7d24[_0x56d3('0x4a')]};if(!_0x34ee62[_0x56d3('0x39')]){_0x45e485[_0x56d3('0x3a')]=!![];}return _0x2ebd5c[_0x56d3('0x14')](_0x45e485);}else{logger['error'](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x4b'),util['inspect'](_0x4eb3af,{'showHidden':![],'depth':null}));}}else{logger[_0x56d3('0x17')](_0x56d3('0x28'),'afterCreate',_0x56d3('0x4b'),util[_0x56d3('0x2a')](_0x4eb3af,{'showHidden':![],'depth':null}));}})[_0x56d3('0x16')](function(_0x3b101f){logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x4b'),util['inspect'](_0x3b101f,{'showHidden':![],'depth':null}));});}else{logger['error'](_0x56d3('0x28'),_0x56d3('0x29'),'clickSend',_0x56d3('0x3b'));}break;case _0x56d3('0x4c'):if(_0x34ee62[_0x56d3('0x4d')]&&_0x34ee62['authToken']){var _0x2927e8={'dst':_0x30a16b['phone'],'text':_0x30a16b['body'],'src':_0x34ee62['senderString']||_0x34ee62[_0x56d3('0x21')],'url':_0x34ee62[_0x56d3('0x24')]+_0x56d3('0x4e')+_0x30a16b['id']+_0x56d3('0x25')+_0x34ee62[_0x56d3('0x26')]};var _0x2ffea5=util[_0x56d3('0x42')]('%s:%s',_0x34ee62[_0x56d3('0x4d')],_0x34ee62[_0x56d3('0x20')]);var _0x44a888={'method':_0x56d3('0x35'),'uri':util[_0x56d3('0x42')]('https://api.plivo.com/v1/Account/%s/Message/',_0x34ee62[_0x56d3('0x4d')]),'body':_0x2927e8,'headers':{'Authorization':util[_0x56d3('0x42')]('Basic\x20%s',new Buffer(_0x2ffea5)[_0x56d3('0x45')](_0x56d3('0x46')))},'json':!![]};rp(_0x44a888)['then'](function(_0x4f6d31){var _0x1b618a={'messageId':_0x4f6d31['message_uuid'][0x0]};return _0x2ebd5c[_0x56d3('0x14')](_0x1b618a);})['catch'](function(_0x209758){logger['error'](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x4c'),util['inspect'](_0x209758,{'showHidden':![],'depth':null}));});}else{logger['error'](_0x56d3('0x28'),_0x56d3('0x29'),'plivo','Missing\x20parameters:\x20authId,\x20authToken');}break;case _0x56d3('0x4f'):if(_0x34ee62[_0x56d3('0x2e')]&&_0x34ee62['password']){if(_0x34ee62[_0x56d3('0x50')]){var _0x259a99={'method':'POST','uri':_0x34ee62[_0x56d3('0x50')]+_0x56d3('0x51'),'body':{'username':_0x34ee62[_0x56d3('0x2e')],'password':_0x34ee62[_0x56d3('0x2f')]},'json':!![]};return rp(_0x259a99)[_0x56d3('0x1c')](function(_0x4bbc63){var _0x1ea7ea={'method':_0x56d3('0x35'),'uri':_0x34ee62[_0x56d3('0x50')]+_0x56d3('0x52'),'body':{'messages':[{'from':_0x34ee62[_0x56d3('0x21')],'destinations':[{'to':_0x30a16b[_0x56d3('0x21')]}],'text':_0x30a16b['body'],'notifyUrl':_0x34ee62[_0x56d3('0x24')]+_0x56d3('0x4e')+_0x30a16b['id']+_0x56d3('0x25')+_0x34ee62[_0x56d3('0x26')],'notifyContentType':_0x56d3('0x53'),'callbackData':_0x34ee62[_0x56d3('0x21')]+';'+_0x30a16b['body']}]},'headers':{'Authorization':'IBSSO\x20'+_0x4bbc63[_0x56d3('0x26')]},'json':!![]};return rp(_0x1ea7ea)['then'](function(_0x5df620){if(_0x5df620['messages']){var _0x3e4eaf={'messageId':_0x5df620[_0x56d3('0x22')][0x0][_0x56d3('0x8')]};if(!_0x34ee62['deliveryReport']){_0x3e4eaf['read']=!![];}return _0x2ebd5c['update'](_0x3e4eaf);}else{return logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),'infobip',util[_0x56d3('0x2a')](_0x5df620,{'showHidden':![],'depth':null}));}});})[_0x56d3('0x16')](function(_0x57a025){return logger[_0x56d3('0x17')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0x56d3('0x4f'),util[_0x56d3('0x2a')](_0x57a025,{'showHidden':![],'depth':null}));});}else{logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),'infobip',_0x56d3('0x54'));}}else{logger[_0x56d3('0x17')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x56d3('0x29'),'infobip',_0x56d3('0x3b'));}break;case _0x56d3('0x55'):var _0x3ad684=require(_0x56d3('0x56'));if(_0x34ee62[_0x56d3('0x57')]){var _0x50e3ea={};_0x50e3ea[_0x56d3('0x58')]=_0x34ee62[_0x56d3('0x2e')];_0x50e3ea[_0x56d3('0x21')]=_0x30a16b[_0x56d3('0x21')];_0x50e3ea[_0x56d3('0x59')]=_0x34ee62[_0x56d3('0x21')];_0x50e3ea[_0x56d3('0x5a')]=_0x30a16b[_0x56d3('0x9')];_0x50e3ea[_0x56d3('0x5b')]=+new Date();var _0x1e4545='';var _0x2d2fcc='';var _0x4a375a=Object['keys'](_0x50e3ea);_0x4a375a[_0x56d3('0x5c')]();for(var _0x146692=0x0;_0x146692<_0x4a375a[_0x56d3('0x5d')];_0x146692++){if(_0x1e4545!=''){_0x1e4545+='&';}_0x1e4545+=_0x4a375a[_0x146692]+'='+encodeURIComponent(_0x50e3ea[_0x4a375a[_0x146692]]);_0x2d2fcc+=_0x50e3ea[_0x4a375a[_0x146692]];}_0x2d2fcc+=_0x34ee62[_0x56d3('0x57')];_0x2d2fcc=_0x3ad684[_0x56d3('0x5e')](_0x56d3('0x5f'))[_0x56d3('0x14')](_0x2d2fcc)['digest'](_0x56d3('0x60'));if(_0x1e4545!==''){_0x1e4545+='&';}_0x1e4545+='signature='+_0x2d2fcc;var _0x2e962b={'method':_0x56d3('0x33'),'uri':_0x34ee62[_0x56d3('0x50')]+_0x56d3('0x61')+_0x1e4545,'json':!![]};return rp(_0x2e962b)['then'](function(_0x1f958b){var _0x2c6bf0=Object['keys'](_0x1f958b);if(_0x1f958b[_0x2c6bf0[0x0]][_0x56d3('0x17')]&&parseInt(_0x1f958b[_0x2c6bf0[0x0]][_0x56d3('0x17')])===0x0){var _0x14fad9={'messageId':_0x1f958b[_0x2c6bf0[0x0]]['id_sms']};if(!_0x34ee62['deliveryReport']){_0x14fad9[_0x56d3('0x3a')]=!![];}return _0x2ebd5c[_0x56d3('0x14')](_0x14fad9);}else{return logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x55'),util[_0x56d3('0x2a')](_0x1f958b['error'],{'showHidden':![],'depth':null}));}})[_0x56d3('0x16')](function(_0x4d9865){return logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x55'),util[_0x56d3('0x2a')](_0x4d9865,{'showHidden':![],'depth':null}));});}else{logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),'csc',_0x56d3('0x62'));}break;case'clickatell':if(_0x34ee62['apiKey']){var _0xc87f28={'method':_0x56d3('0x35'),'uri':_0x56d3('0x63'),'headers':{'Authorization':_0x34ee62['apiKey']},'body':{'content':_0x30a16b[_0x56d3('0x9')],'to':[_0x30a16b['phone']],'from':_0x34ee62[_0x56d3('0x21')],'binary':![],'clientMessageId':_0x56d3('0x64'),'charset':_0x56d3('0x65')},'json':!![]};rp(_0xc87f28)[_0x56d3('0x1c')](function(_0x2b9186){if(!_0x2b9186[_0x56d3('0x17')]){var _0x967c22={'messageId':_0x2b9186[_0x56d3('0x22')][0x0]['apiMessageId']};if(!_0x34ee62[_0x56d3('0x39')]){_0x967c22[_0x56d3('0x3a')]=!![];}return _0x2ebd5c[_0x56d3('0x14')](_0x967c22);}else{return logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x66'),util[_0x56d3('0x2a')](_0x2b9186[_0x56d3('0x17')],{'showHidden':![],'depth':null}));}})['catch'](function(_0x33c0e4){return logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),'clickatell',util[_0x56d3('0x2a')](_0x33c0e4,{'showHidden':![],'depth':null}));});}else{logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x66'),_0x56d3('0x62'));}break;case'intelepeer':if(_0x34ee62[_0x56d3('0x57')]){var _0x2adfce={};var _0x2e962b={'method':_0x56d3('0x35'),'uri':_0x56d3('0x67'),'headers':{'Authorization':_0x56d3('0x68')+_0x34ee62[_0x56d3('0x57')],'Content-Type':_0x56d3('0x53')},'body':{'from':_0x34ee62[_0x56d3('0x21')],'to':_0x30a16b[_0x56d3('0x21')],'text':_0x30a16b[_0x56d3('0x9')]},'json':!![]};return rp(_0x2e962b)[_0x56d3('0x1c')](function(_0x369f53){if(_0x369f53['code']==0xca){_0x2adfce['message']=_0x369f53;var _0x210597={'method':_0x56d3('0x35'),'uri':_0x56d3('0x69'),'headers':{'Authorization':_0x56d3('0x68')+_0x34ee62[_0x56d3('0x57')],'Content-Type':_0x56d3('0x53')},'body':{'refid':_0x2adfce[_0x56d3('0x6a')]['refid']},'json':!![]};return rp(_0x210597)[_0x56d3('0x1c')](function(_0x2891df){_0x2adfce[_0x56d3('0x6b')]=_0x2891df;var _0x5ea281={'messageId':_0x2adfce[_0x56d3('0x6a')][_0x56d3('0x6c')],'read':!![]};return _0x2ebd5c['update'](_0x5ea281);});}else{return logger[_0x56d3('0x17')](_0x56d3('0x28'),'afterCreate',_0x56d3('0x6d'),util[_0x56d3('0x2a')](_0x369f53,{'showHidden':![],'depth':null}));}})[_0x56d3('0x16')](function(_0x210604){return logger[_0x56d3('0x17')](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x6d'),util[_0x56d3('0x2a')](_0x210604,{'showHidden':![],'depth':null}));});}else{return logger['error'](_0x56d3('0x28'),_0x56d3('0x29'),_0x56d3('0x6d'),_0x56d3('0x6e'));}break;}}})[_0x56d3('0x6f')](function(){_0x5c2a65();});}else{_0x5c2a65();}}},'charset':_0x56d3('0x70'),'collate':_0x56d3('0x71')});};
\ No newline at end of file
+var _0x0cb6=['digest','hex','signature=','/external/get/send.php?','id_sms','Missing\x20parameters:\x20apiKey','clickatell','https://platform.clickatell.com/messages','UTF-8','apiMessageId','bandwidth','https://messaging.bandwidth.com/api/v2/users/','/messages','intelepeer','https://api.intelepeer.com/_rest/v4/app/sms/send','Bearer\x20','code','message','https://api.intelepeer.com/_rest/v4/app/sms/mdr','refid','status','finally','utf8mb4','util','../../config/logger','api','bluebird','request-promise','path','rimraf','./smsMessage.attributes','exports','sms_messages','body','models','direction','toLowerCase','secret','isNil','UserId','SmsInteraction','findOne','SmsInteractionId','then','update','createdAt','catch','error','out','SmsAccount','find','type','twilio','phone','accountSid','messages','create','remote','/api/sms/messages/','/status?token=','token','afterCreate','inspect','SmsMessage,\x20%s,\x20%s,\x20%s','skebby','https://api.skebby.it/API/v1.0/REST/','username','smsMethod','login?username=','password','GET','split','sms','POST','user_key','session_key','total_sent','internal_order_id','read','Missing\x20parameters:\x20username,\x20password','connectel','senderString','authToken','https://smsapi.connectel.se/api/v2/send/','Missing\x20parameters:\x20authToken','xCALLY\x20Motion','format','%s:%s','https://rest.clicksend.com/v3/sms/send','toString','http_code','data','queued_count','head','message_id','deliveryReport','clickSend','plivo','authId','https://api.plivo.com/v1/Account/%s/Message/','Basic\x20%s','base64','Missing\x20parameters:\x20authId,\x20authToken','infobip','baseUrl','/sms/2/text/advanced','application/json','IBSSO\x20','messageId','Missing\x20parameters:\x20base_url','csc','apiKey','login','sender','text','timestamp','keys','sort','length','md5'];(function(_0x157c81,_0x2c0224){var _0x1bfb12=function(_0x4b5c5b){while(--_0x4b5c5b){_0x157c81['push'](_0x157c81['shift']());}};_0x1bfb12(++_0x2c0224);}(_0x0cb6,0x17f));var _0x60cb=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x0cb6[_0x3dd15e];return _0x231fd0;};'use strict';var _=require('lodash');var util=require(_0x60cb('0x0'));var logger=require(_0x60cb('0x1'))(_0x60cb('0x2'));var moment=require('moment');var BPromise=require(_0x60cb('0x3'));var rp=require(_0x60cb('0x4'));var fs=require('fs');var path=require(_0x60cb('0x5'));var rimraf=require(_0x60cb('0x6'));var config=require('../../config/environment');var attributes=require(_0x60cb('0x7'));module[_0x60cb('0x8')]=function(_0x43681a,_0x1bf76a){return _0x43681a['define']('SmsMessage',attributes,{'tableName':_0x60cb('0x9'),'paranoid':![],'indexes':[{'name':'messageId','fields':['messageId']},{'name':'fti_sms_messages','fields':[_0x60cb('0xa')],'type':'FULLTEXT'}],'timestamps':!![],'hooks':{'afterCreate':function(_0x1fa3ed,_0x3ed348,_0x20f2dd){var _0x87cb61=_0x43681a[_0x60cb('0xb')];var _0x3825bb=_0x1fa3ed['get']({'plain':!![]});if(_0x3825bb[_0x60cb('0xc')][_0x60cb('0xd')]()==='in'||_0x3825bb[_0x60cb('0xc')][_0x60cb('0xd')]()==='out'&&!_0x3825bb[_0x60cb('0xe')]&&!_[_0x60cb('0xf')](_0x3825bb[_0x60cb('0x10')])){_0x87cb61[_0x60cb('0x11')][_0x60cb('0x12')]({'where':{'id':_0x3825bb[_0x60cb('0x13')]}})[_0x60cb('0x14')](function(_0xb4d20f){if(_0xb4d20f){_0xb4d20f[_0x60cb('0x15')]({'lastMsgAt':_0x3825bb[_0x60cb('0x16')],'lastMsgDirection':_0x3825bb['direction'][_0x60cb('0xd')]()});}})[_0x60cb('0x17')](function(_0x399beb){console[_0x60cb('0x18')](_0x399beb);});}if(_0x3825bb['direction']===_0x60cb('0x19')&&!_0x3825bb[_0x60cb('0xe')]){var _0x5f4ae7;_0x87cb61[_0x60cb('0x1a')][_0x60cb('0x1b')]({'where':{'id':_0x3825bb['SmsAccountId']},'raw':!![]})[_0x60cb('0x14')](function(_0x226b24){_0x5f4ae7=_0x226b24;if(_0x5f4ae7&&_0x5f4ae7[_0x60cb('0x1c')]){switch(_0x5f4ae7[_0x60cb('0x1c')]){case _0x60cb('0x1d'):var _0x1a6400=require(_0x60cb('0x1d'));if(_0x5f4ae7['accountSid']&&_0x5f4ae7['authToken']&&_0x5f4ae7[_0x60cb('0x1e')]){var _0xf11986=new _0x1a6400(_0x5f4ae7[_0x60cb('0x1f')],_0x5f4ae7['authToken']);_0xf11986[_0x60cb('0x20')][_0x60cb('0x21')]({'body':_0x3825bb[_0x60cb('0xa')],'to':_0x3825bb[_0x60cb('0x1e')],'from':_0x5f4ae7[_0x60cb('0x1e')],'statusCallback':_0x5f4ae7[_0x60cb('0x22')]+_0x60cb('0x23')+_0x3825bb['id']+_0x60cb('0x24')+_0x5f4ae7[_0x60cb('0x25')]})[_0x60cb('0x14')](function(_0x409a42){if(_0x409a42['sid']){return _0x1fa3ed['update']({'messageId':_0x409a42['sid']});}})[_0x60cb('0x17')](function(_0x354763){logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s',_0x60cb('0x26'),_0x60cb('0x1d'),util[_0x60cb('0x27')](_0x354763,{'showHidden':![],'depth':null}));});}else{logger[_0x60cb('0x18')](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x1d'),'Missing\x20parameters:\x20phone,\x20accountSid\x20or\x20authToken');}break;case _0x60cb('0x29'):var _0x484667=_0x60cb('0x2a');if(_0x5f4ae7[_0x60cb('0x2b')]&&_0x5f4ae7['password']){var _0x652818={'recipient':[_0x3825bb[_0x60cb('0x1e')]],'message':_0x3825bb[_0x60cb('0xa')],'message_type':_0x5f4ae7['smsMethod']};if(_0x5f4ae7[_0x60cb('0x2c')]&&_0x5f4ae7[_0x60cb('0x2c')]!=='SI'){_0x652818['sender']=_0x5f4ae7[_0x60cb('0x1e')];}var _0x4a6908={'url':_0x484667+_0x60cb('0x2d')+_0x5f4ae7[_0x60cb('0x2b')]+'&password='+_0x5f4ae7[_0x60cb('0x2e')],'method':_0x60cb('0x2f')};rp(_0x4a6908)[_0x60cb('0x14')](function(_0x5d5f48){var _0x1bc7c6=_0x5d5f48[_0x60cb('0x30')](';');var _0x1af7a0={'user_key':_0x1bc7c6[0x0],'session_key':_0x1bc7c6[0x1]};_0x4a6908={'url':_0x484667+_0x60cb('0x31'),'method':_0x60cb('0x32'),'headers':{'user_key':_0x1af7a0[_0x60cb('0x33')],'Session_key':_0x1af7a0[_0x60cb('0x34')]},'json':!![],'body':_0x652818};return rp(_0x4a6908);})[_0x60cb('0x14')](function(_0x4dea57){if(_0x4dea57[_0x60cb('0x35')]>=0x1){var _0x5e090e={'messageId':_0x4dea57[_0x60cb('0x36')]};if(_0x5f4ae7[_0x60cb('0x2c')]!=='GP'||!_0x5f4ae7['deliveryReport']){_0x5e090e[_0x60cb('0x37')]=!![];}return _0x1fa3ed['update'](_0x5e090e);}else{return logger[_0x60cb('0x18')](_0x60cb('0x28'),_0x60cb('0x26'),'skebby',util[_0x60cb('0x27')](_0x4dea57,{'showHidden':![],'depth':null}));}})['catch'](function(_0x132f03){return logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s',_0x60cb('0x26'),_0x60cb('0x29'),util['inspect'](_0x132f03,{'showHidden':![],'depth':null}));});}else{logger[_0x60cb('0x18')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate','skebby',_0x60cb('0x38'));}break;case _0x60cb('0x39'):if(_0x5f4ae7['authToken']){var _0x3870ab={'recipient':_0x3825bb[_0x60cb('0x1e')],'message':_0x3825bb['body'],'sender':_0x5f4ae7[_0x60cb('0x3a')]||_0x5f4ae7['phone'],'authorization':_0x5f4ae7[_0x60cb('0x3b')]};var _0x3ed348={'method':_0x60cb('0x32'),'uri':_0x60cb('0x3c'),'body':_0x3870ab,'json':!![]};rp(_0x3ed348)[_0x60cb('0x14')](function(_0x40ccae){var _0x8f5303={'messageId':_0x40ccae['requestid']};if(!_0x5f4ae7['deliveryReport']){_0x8f5303['read']=!![];}return _0x1fa3ed[_0x60cb('0x15')](_0x8f5303);})[_0x60cb('0x17')](function(_0x409815){logger[_0x60cb('0x18')](_0x60cb('0x28'),_0x60cb('0x26'),'connectel',util[_0x60cb('0x27')](_0x409815,{'showHidden':![],'depth':null}));});}else{logger[_0x60cb('0x18')](_0x60cb('0x28'),'afterCreate',_0x60cb('0x39'),_0x60cb('0x3d'));}break;case'clicksend':if(_0x5f4ae7[_0x60cb('0x2b')]&&_0x5f4ae7[_0x60cb('0x2e')]){var _0x3870ab={'messages':[{'source':_0x60cb('0x3e'),'to':_0x3825bb['phone'],'body':_0x3825bb[_0x60cb('0xa')],'from':_0x5f4ae7['senderString']||_0x5f4ae7[_0x60cb('0x1e')]}]};var _0x50c7f6=util[_0x60cb('0x3f')](_0x60cb('0x40'),_0x5f4ae7[_0x60cb('0x2b')],_0x5f4ae7[_0x60cb('0x2e')]);var _0x3ed348={'method':_0x60cb('0x32'),'uri':_0x60cb('0x41'),'body':_0x3870ab,'headers':{'Authorization':util[_0x60cb('0x3f')]('Basic\x20%s',new Buffer(_0x50c7f6)[_0x60cb('0x42')]('base64'))},'json':!![]};rp(_0x3ed348)[_0x60cb('0x14')](function(_0x314dce){if(_0x314dce[_0x60cb('0x43')]>=0xc8&&_0x314dce[_0x60cb('0x43')]<=0xce){if(_0x314dce[_0x60cb('0x44')]&&_0x314dce[_0x60cb('0x44')][_0x60cb('0x45')]>0x0){var _0xe79cb8=_[_0x60cb('0x46')](_0x314dce[_0x60cb('0x44')]['messages']);var _0x2f311a={'messageId':_0xe79cb8[_0x60cb('0x47')]};if(!_0x5f4ae7[_0x60cb('0x48')]){_0x2f311a[_0x60cb('0x37')]=!![];}return _0x1fa3ed[_0x60cb('0x15')](_0x2f311a);}else{logger[_0x60cb('0x18')](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x49'),util['inspect'](_0x314dce,{'showHidden':![],'depth':null}));}}else{logger[_0x60cb('0x18')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x60cb('0x26'),_0x60cb('0x49'),util['inspect'](_0x314dce,{'showHidden':![],'depth':null}));}})[_0x60cb('0x17')](function(_0x45e4c3){logger['error'](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x49'),util[_0x60cb('0x27')](_0x45e4c3,{'showHidden':![],'depth':null}));});}else{logger[_0x60cb('0x18')](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x49'),_0x60cb('0x38'));}break;case _0x60cb('0x4a'):if(_0x5f4ae7['authId']&&_0x5f4ae7[_0x60cb('0x3b')]){var _0x3870ab={'dst':_0x3825bb[_0x60cb('0x1e')],'text':_0x3825bb['body'],'src':_0x5f4ae7['senderString']||_0x5f4ae7[_0x60cb('0x1e')],'url':_0x5f4ae7[_0x60cb('0x22')]+_0x60cb('0x23')+_0x3825bb['id']+'/status?token='+_0x5f4ae7[_0x60cb('0x25')]};var _0x50c7f6=util[_0x60cb('0x3f')](_0x60cb('0x40'),_0x5f4ae7[_0x60cb('0x4b')],_0x5f4ae7['authToken']);var _0x3ed348={'method':'POST','uri':util[_0x60cb('0x3f')](_0x60cb('0x4c'),_0x5f4ae7[_0x60cb('0x4b')]),'body':_0x3870ab,'headers':{'Authorization':util[_0x60cb('0x3f')](_0x60cb('0x4d'),new Buffer(_0x50c7f6)[_0x60cb('0x42')](_0x60cb('0x4e')))},'json':!![]};rp(_0x3ed348)[_0x60cb('0x14')](function(_0x3562ca){var _0x340042={'messageId':_0x3562ca['message_uuid'][0x0]};return _0x1fa3ed[_0x60cb('0x15')](_0x340042);})[_0x60cb('0x17')](function(_0x739570){logger[_0x60cb('0x18')]('SmsMessage,\x20%s,\x20%s,\x20%s','afterCreate',_0x60cb('0x4a'),util['inspect'](_0x739570,{'showHidden':![],'depth':null}));});}else{logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s',_0x60cb('0x26'),'plivo',_0x60cb('0x4f'));}break;case _0x60cb('0x50'):if(_0x5f4ae7[_0x60cb('0x2b')]&&_0x5f4ae7[_0x60cb('0x2e')]){if(_0x5f4ae7[_0x60cb('0x51')]){var _0x1f523f={'method':'POST','uri':_0x5f4ae7['baseUrl']+'/auth/1/session','body':{'username':_0x5f4ae7[_0x60cb('0x2b')],'password':_0x5f4ae7[_0x60cb('0x2e')]},'json':!![]};return rp(_0x1f523f)['then'](function(_0x437f72){var _0x464c06={'method':_0x60cb('0x32'),'uri':_0x5f4ae7[_0x60cb('0x51')]+_0x60cb('0x52'),'body':{'messages':[{'from':_0x5f4ae7[_0x60cb('0x1e')],'destinations':[{'to':_0x3825bb['phone']}],'text':_0x3825bb[_0x60cb('0xa')],'notifyUrl':_0x5f4ae7[_0x60cb('0x22')]+_0x60cb('0x23')+_0x3825bb['id']+_0x60cb('0x24')+_0x5f4ae7[_0x60cb('0x25')],'notifyContentType':_0x60cb('0x53'),'callbackData':_0x5f4ae7[_0x60cb('0x1e')]+';'+_0x3825bb['body']}]},'headers':{'Authorization':_0x60cb('0x54')+_0x437f72['token']},'json':!![]};return rp(_0x464c06)[_0x60cb('0x14')](function(_0x2d3365){if(_0x2d3365[_0x60cb('0x20')]){var _0x5d3bd4={'messageId':_0x2d3365[_0x60cb('0x20')][0x0][_0x60cb('0x55')]};if(!_0x5f4ae7['deliveryReport']){_0x5d3bd4[_0x60cb('0x37')]=!![];}return _0x1fa3ed[_0x60cb('0x15')](_0x5d3bd4);}else{return logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s',_0x60cb('0x26'),'infobip',util['inspect'](_0x2d3365,{'showHidden':![],'depth':null}));}});})[_0x60cb('0x17')](function(_0x2cdda0){return logger[_0x60cb('0x18')](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x50'),util[_0x60cb('0x27')](_0x2cdda0,{'showHidden':![],'depth':null}));});}else{logger['error'](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x50'),_0x60cb('0x56'));}}else{logger[_0x60cb('0x18')](_0x60cb('0x28'),'afterCreate','infobip','Missing\x20parameters:\x20username,\x20password');}break;case _0x60cb('0x57'):var _0x14fcb7=require('crypto');if(_0x5f4ae7[_0x60cb('0x58')]){var _0x3b612d={};_0x3b612d[_0x60cb('0x59')]=_0x5f4ae7[_0x60cb('0x2b')];_0x3b612d[_0x60cb('0x1e')]=_0x3825bb[_0x60cb('0x1e')];_0x3b612d[_0x60cb('0x5a')]=_0x5f4ae7[_0x60cb('0x1e')];_0x3b612d[_0x60cb('0x5b')]=_0x3825bb['body'];_0x3b612d[_0x60cb('0x5c')]=+new Date();var _0x5b99d5='';var _0x247a62='';var _0x4ecfec=Object[_0x60cb('0x5d')](_0x3b612d);_0x4ecfec[_0x60cb('0x5e')]();for(var _0x1772f4=0x0;_0x1772f4<_0x4ecfec[_0x60cb('0x5f')];_0x1772f4++){if(_0x5b99d5!=''){_0x5b99d5+='&';}_0x5b99d5+=_0x4ecfec[_0x1772f4]+'='+encodeURIComponent(_0x3b612d[_0x4ecfec[_0x1772f4]]);_0x247a62+=_0x3b612d[_0x4ecfec[_0x1772f4]];}_0x247a62+=_0x5f4ae7[_0x60cb('0x58')];_0x247a62=_0x14fcb7['createHash'](_0x60cb('0x60'))[_0x60cb('0x15')](_0x247a62)[_0x60cb('0x61')](_0x60cb('0x62'));if(_0x5b99d5!==''){_0x5b99d5+='&';}_0x5b99d5+=_0x60cb('0x63')+_0x247a62;var _0x4a6908={'method':_0x60cb('0x2f'),'uri':_0x5f4ae7[_0x60cb('0x51')]+_0x60cb('0x64')+_0x5b99d5,'json':!![]};return rp(_0x4a6908)[_0x60cb('0x14')](function(_0x578e0c){var _0x1992bf=Object[_0x60cb('0x5d')](_0x578e0c);if(_0x578e0c[_0x1992bf[0x0]][_0x60cb('0x18')]&&parseInt(_0x578e0c[_0x1992bf[0x0]][_0x60cb('0x18')])===0x0){var _0x491b07={'messageId':_0x578e0c[_0x1992bf[0x0]][_0x60cb('0x65')]};if(!_0x5f4ae7['deliveryReport']){_0x491b07['read']=!![];}return _0x1fa3ed[_0x60cb('0x15')](_0x491b07);}else{return logger[_0x60cb('0x18')](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x57'),util[_0x60cb('0x27')](_0x578e0c[_0x60cb('0x18')],{'showHidden':![],'depth':null}));}})['catch'](function(_0x152ab9){return logger[_0x60cb('0x18')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x60cb('0x26'),'csc',util['inspect'](_0x152ab9,{'showHidden':![],'depth':null}));});}else{logger[_0x60cb('0x18')](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x57'),_0x60cb('0x66'));}break;case _0x60cb('0x67'):if(_0x5f4ae7[_0x60cb('0x58')]){var _0x146382={'method':'POST','uri':_0x60cb('0x68'),'headers':{'Authorization':_0x5f4ae7[_0x60cb('0x58')]},'body':{'content':_0x3825bb[_0x60cb('0xa')],'to':[_0x3825bb[_0x60cb('0x1e')]],'from':_0x5f4ae7[_0x60cb('0x1e')],'binary':![],'clientMessageId':'uuid','charset':_0x60cb('0x69')},'json':!![]};rp(_0x146382)[_0x60cb('0x14')](function(_0x1368fa){if(!_0x1368fa[_0x60cb('0x18')]){var _0x213076={'messageId':_0x1368fa[_0x60cb('0x20')][0x0][_0x60cb('0x6a')]};if(!_0x5f4ae7['deliveryReport']){_0x213076['read']=!![];}return _0x1fa3ed[_0x60cb('0x15')](_0x213076);}else{return logger['error'](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x67'),util[_0x60cb('0x27')](_0x1368fa[_0x60cb('0x18')],{'showHidden':![],'depth':null}));}})[_0x60cb('0x17')](function(_0x369b5f){return logger['error'](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x67'),util[_0x60cb('0x27')](_0x369b5f,{'showHidden':![],'depth':null}));});}else{logger[_0x60cb('0x18')](_0x60cb('0x28'),'afterCreate',_0x60cb('0x67'),_0x60cb('0x66'));}break;case _0x60cb('0x6b'):if(_0x5f4ae7['username']&&_0x5f4ae7[_0x60cb('0x2e')]){var _0x50c7f6=util[_0x60cb('0x3f')](_0x60cb('0x40'),_0x5f4ae7['username'],_0x5f4ae7[_0x60cb('0x2e')]);var _0x3ed348={'method':'POST','uri':_0x60cb('0x6c')+_0x5f4ae7['accountId']+_0x60cb('0x6d'),'body':{'to':[_0x3825bb['phone']],'text':_0x3825bb[_0x60cb('0xa')],'from':_0x5f4ae7['phone'],'applicationId':_0x5f4ae7['applicationId']},'headers':{'Authorization':util['format']('Basic\x20%s',new Buffer(_0x50c7f6)[_0x60cb('0x42')]('base64'))},'json':!![]};rp(_0x3ed348)[_0x60cb('0x14')](function(_0x445c59){if(_0x445c59['id']){var _0x56d503={'messageId':_0x445c59['id']};return _0x1fa3ed[_0x60cb('0x15')](_0x56d503);}else{logger[_0x60cb('0x18')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x60cb('0x26'),'bandwidth',util[_0x60cb('0x27')](_0x445c59,{'showHidden':![],'depth':null}));}})[_0x60cb('0x17')](function(_0xe51917){logger[_0x60cb('0x18')]('SmsMessage,\x20%s,\x20%s,\x20%s',_0x60cb('0x26'),_0x60cb('0x6b'),util['inspect'](_0xe51917,{'showHidden':![],'depth':null}));});}else{logger['error']('SmsMessage,\x20%s,\x20%s,\x20%s',_0x60cb('0x26'),'bandwidth','Missing\x20parameters:\x20username,\x20password');}break;case _0x60cb('0x6e'):if(_0x5f4ae7[_0x60cb('0x58')]){var _0x4afc64={};var _0x4a6908={'method':_0x60cb('0x32'),'uri':_0x60cb('0x6f'),'headers':{'Authorization':_0x60cb('0x70')+_0x5f4ae7[_0x60cb('0x58')],'Content-Type':_0x60cb('0x53')},'body':{'from':_0x5f4ae7[_0x60cb('0x1e')],'to':_0x3825bb[_0x60cb('0x1e')],'text':_0x3825bb[_0x60cb('0xa')]},'json':!![]};return rp(_0x4a6908)[_0x60cb('0x14')](function(_0x14873c){if(_0x14873c[_0x60cb('0x71')]==0xca){_0x4afc64[_0x60cb('0x72')]=_0x14873c;var _0x4de628={'method':'POST','uri':_0x60cb('0x73'),'headers':{'Authorization':'Bearer\x20'+_0x5f4ae7[_0x60cb('0x58')],'Content-Type':_0x60cb('0x53')},'body':{'refid':_0x4afc64[_0x60cb('0x72')][_0x60cb('0x74')]},'json':!![]};return rp(_0x4de628)[_0x60cb('0x14')](function(_0x13a45f){_0x4afc64[_0x60cb('0x75')]=_0x13a45f;var _0x396473={'messageId':_0x4afc64['message']['refid'],'read':!![]};return _0x1fa3ed[_0x60cb('0x15')](_0x396473);});}else{return logger[_0x60cb('0x18')](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x6e'),util[_0x60cb('0x27')](_0x14873c,{'showHidden':![],'depth':null}));}})[_0x60cb('0x17')](function(_0x37d4f1){return logger[_0x60cb('0x18')](_0x60cb('0x28'),'afterCreate',_0x60cb('0x6e'),util['inspect'](_0x37d4f1,{'showHidden':![],'depth':null}));});}else{return logger['error'](_0x60cb('0x28'),_0x60cb('0x26'),_0x60cb('0x6e'),'Token\x20not\x20received');}break;}}})[_0x60cb('0x76')](function(){_0x20f2dd();});}else{_0x20f2dd();}}},'charset':_0x60cb('0x77'),'collate':'utf8mb4_unicode_ci'});};
\ No newline at end of file