Built motion from commit 980b26c3.|2.6.29
[motion2.git] / server / api / smsMessage / smsMessage.controller.js
1 // *************************************************************************
2 // *                                                                       *
3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
5 // *                                                                       *
6 // *************************************************************************
7 // *                                                                       *
8 // * Email: info@xcally.com                                                *
9 // * Website: https://www.xcally.com                                       *
10 // *                                                                       *
11 // *************************************************************************
12 // *                                                                       *
13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
14 // * copyright treaties, as well as other intellectual property laws and   *
15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
16 // *                                                                       *
17 // *************************************************************************
18 var _0x4f3d=['length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','options','includeAll','findAll','params','keys','include','find','create','body','update','sms-interactions','accept','sms','read','readAt','YYYY-MM-DD\x20HH:mm:ss','UserId','user','agent','SmsInteraction','SmsInteractionId','read1stAt','interaction','get','[SMSMESSAGE:ACCEPT]\x20id=%s\x20name=%s\x20role=%s\x20interaction=%s\x20body=%s','role','stringify','null','AcceptMessage','acceptMessage','SELECT\x20*\x20FROM\x20cm_contacts\x20WHERE\x20id\x20=\x20','sequelize','Sequelize','QueryTypes','SELECT','fullname','email','manual','format','channel','motionChannel','EventManager','acceptmessage','[SMSMESSAGE:REJECT]\x20id=%s\x20name=%s\x20role=%s\x20interaction=%s\x20body=%s','RejectMessage','rejectMessage','ContactId','contact','internal','interface','event','rejectmessage','SmsAccount','SmsAccountId','MessageSid','SmsAccount,\x20%s,\x20%s,\x20%s','inspect','plivo','MessageUUID','messageId','delivered','Status','plivio','infobip','groupName','DELIVERED','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','redis','localhost','socket.io-emitter','./smsMessage.socket','register','jayson/promise','client','http','then','info','SmsMessage,\x20%s,\x20%s','request\x20sent','debug','SmsMessage,\x20%s,\x20%s,\x20%s','error','code','message','result','catch','sendStatus','status','end','json','undefined','limit','count','offset','set','Content-Range','reject','save','stack','name','send','index','SmsMessage','rawAttributes','type','key','model','map','query','filters','intersection','attributes','fields'];(function(_0x10fc9f,_0x30f8c0){var _0x4e6892=function(_0x5b9bd9){while(--_0x5b9bd9){_0x10fc9f['push'](_0x10fc9f['shift']());}};_0x4e6892(++_0x30f8c0);}(_0x4f3d,0x171));var _0xd4f3=function(_0x54b284,_0x19d746){_0x54b284=_0x54b284-0x0;var _0x22a0cd=_0x4f3d[_0x54b284];return _0x22a0cd;};'use strict';var emlformat=require(_0xd4f3('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xd4f3('0x1'));var jsonpatch=require(_0xd4f3('0x2'));var rp=require(_0xd4f3('0x3'));var moment=require(_0xd4f3('0x4'));var BPromise=require(_0xd4f3('0x5'));var Mustache=require('mustache');var util=require(_0xd4f3('0x6'));var path=require(_0xd4f3('0x7'));var sox=require(_0xd4f3('0x8'));var csv=require(_0xd4f3('0x9'));var ejs=require(_0xd4f3('0xa'));var fs=require('fs');var fs_extra=require(_0xd4f3('0xb'));var _=require(_0xd4f3('0xc'));var squel=require(_0xd4f3('0xd'));var crypto=require('crypto');var jsforce=require(_0xd4f3('0xe'));var deskjs=require(_0xd4f3('0xf'));var toCsv=require(_0xd4f3('0x9'));var querystring=require(_0xd4f3('0x10'));var Papa=require(_0xd4f3('0x11'));var Redis=require(_0xd4f3('0x12'));var authService=require(_0xd4f3('0x13'));var qs=require(_0xd4f3('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xd4f3('0x15'));var logger=require(_0xd4f3('0x16'))('api');var utils=require(_0xd4f3('0x17'));var config=require(_0xd4f3('0x18'));var licenseUtil=require('../../config/license/util');var db=require(_0xd4f3('0x19'))['db'];config[_0xd4f3('0x1a')]=_['defaults'](config['redis'],{'host':_0xd4f3('0x1b'),'port':0x18eb});var socket=require(_0xd4f3('0x1c'))(new Redis(config['redis']));require(_0xd4f3('0x1d'))[_0xd4f3('0x1e')](socket);var jayson=require(_0xd4f3('0x1f'));var client=jayson[_0xd4f3('0x20')]['http']({'port':0x232c});var client9002=jayson[_0xd4f3('0x20')][_0xd4f3('0x21')]({'port':0x232a});function respondWithRpcPromise(_0xdee08d,_0x25a89d,_0x340498,_0x3d64a6){return new BPromise(function(_0x2b3a23,_0x2ad6e2){var _0x2c0292=_0x3d64a6||client;return _0x2c0292['request'](_0xdee08d,_0x340498)[_0xd4f3('0x22')](function(_0x566e40){logger[_0xd4f3('0x23')](_0xd4f3('0x24'),_0x25a89d,_0xd4f3('0x25'));logger[_0xd4f3('0x26')](_0xd4f3('0x27'),_0x25a89d,_0xd4f3('0x25'),JSON['stringify'](_0x566e40));if(_0x566e40[_0xd4f3('0x28')]){if(_0x566e40[_0xd4f3('0x28')][_0xd4f3('0x29')]===0x1f4){logger[_0xd4f3('0x28')](_0xd4f3('0x24'),_0x25a89d,_0x566e40['error']['message']);return _0x2ad6e2(_0x566e40['error']['message']);}logger['error'](_0xd4f3('0x24'),_0x25a89d,_0x566e40[_0xd4f3('0x28')]['message']);return _0x2b3a23(_0x566e40[_0xd4f3('0x28')][_0xd4f3('0x2a')]);}else{logger['info'](_0xd4f3('0x24'),_0x25a89d,_0xd4f3('0x25'));_0x2b3a23(_0x566e40[_0xd4f3('0x2b')][_0xd4f3('0x2a')]);}})[_0xd4f3('0x2c')](function(_0x31da07){logger[_0xd4f3('0x28')]('SmsMessage,\x20%s,\x20%s',_0x25a89d,_0x31da07);_0x2ad6e2(_0x31da07);});});}function respondWithStatusCode(_0x1aac38,_0x38dff7){_0x38dff7=_0x38dff7||0xcc;return function(_0x55278c){if(_0x55278c){return _0x1aac38[_0xd4f3('0x2d')](_0x38dff7);}return _0x1aac38[_0xd4f3('0x2e')](_0x38dff7)[_0xd4f3('0x2f')]();};}function respondWithResult(_0x2e6172,_0x53ac0c){_0x53ac0c=_0x53ac0c||0xc8;return function(_0x58dd3f){if(_0x58dd3f){return _0x2e6172['status'](_0x53ac0c)[_0xd4f3('0x30')](_0x58dd3f);}};}function respondWithFilteredResult(_0x560bb3,_0x907989){return function(_0x567404){if(_0x567404){var _0x152426=typeof _0x907989['offset']===_0xd4f3('0x31')&&typeof _0x907989[_0xd4f3('0x32')]==='undefined';var _0x258788=_0x567404[_0xd4f3('0x33')];var _0x447b86=_0x152426?0x0:_0x907989[_0xd4f3('0x34')];var _0x3c4c49=_0x152426?_0x567404[_0xd4f3('0x33')]:_0x907989[_0xd4f3('0x34')]+_0x907989[_0xd4f3('0x32')];var _0x21c129;if(_0x3c4c49>=_0x258788){_0x3c4c49=_0x258788;_0x21c129=0xc8;}else{_0x21c129=0xce;}_0x560bb3[_0xd4f3('0x2e')](_0x21c129);return _0x560bb3[_0xd4f3('0x35')](_0xd4f3('0x36'),_0x447b86+'-'+_0x3c4c49+'/'+_0x258788)['json'](_0x567404);}return null;};}function patchUpdates(_0x3f5aa0){return function(_0x32edc9){try{jsonpatch['apply'](_0x32edc9,_0x3f5aa0,!![]);}catch(_0x399dff){return BPromise[_0xd4f3('0x37')](_0x399dff);}return _0x32edc9[_0xd4f3('0x38')]();};}function saveUpdates(_0xe995b4,_0xf317f7){return function(_0x4c37f7){if(_0x4c37f7){return _0x4c37f7['update'](_0xe995b4)['then'](function(_0x17d39b){return _0x17d39b;});}return null;};}function removeEntity(_0xd5a9be,_0x580fc9){return function(_0x255cdb){if(_0x255cdb){return _0x255cdb['destroy']()[_0xd4f3('0x22')](function(){_0xd5a9be[_0xd4f3('0x2e')](0xcc)[_0xd4f3('0x2f')]();});}};}function handleEntityNotFound(_0x4ea095,_0x466620){return function(_0x4c5473){if(!_0x4c5473){_0x4ea095[_0xd4f3('0x2d')](0x194);}return _0x4c5473;};}function handleError(_0x17de9a,_0x388217){_0x388217=_0x388217||0x1f4;return function(_0x5274aa){logger[_0xd4f3('0x28')](_0x5274aa[_0xd4f3('0x39')]);if(_0x5274aa[_0xd4f3('0x3a')]){delete _0x5274aa[_0xd4f3('0x3a')];}_0x17de9a[_0xd4f3('0x2e')](_0x388217)[_0xd4f3('0x3b')](_0x5274aa);};}exports[_0xd4f3('0x3c')]=function(_0x41d25f,_0x187814){var _0x4a2e62={},_0x18aa55={},_0x44068e={'count':0x0,'rows':[]};var _0x4978af=_['map'](db[_0xd4f3('0x3d')][_0xd4f3('0x3e')],function(_0x30cf0b){return{'name':_0x30cf0b['fieldName'],'type':_0x30cf0b[_0xd4f3('0x3f')][_0xd4f3('0x40')]};});_0x18aa55[_0xd4f3('0x41')]=_[_0xd4f3('0x42')](_0x4978af,_0xd4f3('0x3a'));_0x18aa55[_0xd4f3('0x43')]=_['keys'](_0x41d25f[_0xd4f3('0x43')]);_0x18aa55[_0xd4f3('0x44')]=_[_0xd4f3('0x45')](_0x18aa55[_0xd4f3('0x41')],_0x18aa55[_0xd4f3('0x43')]);_0x4a2e62[_0xd4f3('0x46')]=_['intersection'](_0x18aa55[_0xd4f3('0x41')],qs[_0xd4f3('0x47')](_0x41d25f[_0xd4f3('0x43')][_0xd4f3('0x47')]));_0x4a2e62[_0xd4f3('0x46')]=_0x4a2e62['attributes'][_0xd4f3('0x48')]?_0x4a2e62[_0xd4f3('0x46')]:_0x18aa55[_0xd4f3('0x41')];if(!_0x41d25f[_0xd4f3('0x43')][_0xd4f3('0x49')](_0xd4f3('0x4a'))){_0x4a2e62['limit']=qs[_0xd4f3('0x32')](_0x41d25f['query'][_0xd4f3('0x32')]);_0x4a2e62[_0xd4f3('0x34')]=qs[_0xd4f3('0x34')](_0x41d25f[_0xd4f3('0x43')][_0xd4f3('0x34')]);}_0x4a2e62[_0xd4f3('0x4b')]=qs[_0xd4f3('0x4c')](_0x41d25f[_0xd4f3('0x43')][_0xd4f3('0x4c')]);_0x4a2e62[_0xd4f3('0x4d')]=qs['filters'](_[_0xd4f3('0x4e')](_0x41d25f[_0xd4f3('0x43')],_0x18aa55['filters']),_0x4978af);if(_0x41d25f[_0xd4f3('0x43')][_0xd4f3('0x4f')]){_0x4a2e62['where']=_['merge'](_0x4a2e62[_0xd4f3('0x4d')],{'$or':_[_0xd4f3('0x42')](_0x4978af,function(_0x274ef6){if(_0x274ef6[_0xd4f3('0x3f')]!=='VIRTUAL'){var _0x291f9b={};_0x291f9b[_0x274ef6[_0xd4f3('0x3a')]]={'$like':'%'+_0x41d25f[_0xd4f3('0x43')][_0xd4f3('0x4f')]+'%'};return _0x291f9b;}})});}_0x4a2e62=_[_0xd4f3('0x50')]({},_0x4a2e62,_0x41d25f[_0xd4f3('0x51')]);var _0x458938={'where':_0x4a2e62[_0xd4f3('0x4d')]};return db[_0xd4f3('0x3d')][_0xd4f3('0x33')](_0x458938)[_0xd4f3('0x22')](function(_0x20968b){_0x44068e[_0xd4f3('0x33')]=_0x20968b;if(_0x41d25f['query'][_0xd4f3('0x52')]){_0x4a2e62['include']=[{'all':!![]}];}return db[_0xd4f3('0x3d')][_0xd4f3('0x53')](_0x4a2e62);})['then'](function(_0x3f9841){_0x44068e['rows']=_0x3f9841;return _0x44068e;})[_0xd4f3('0x22')](respondWithFilteredResult(_0x187814,_0x4a2e62))[_0xd4f3('0x2c')](handleError(_0x187814,null));};exports['show']=function(_0x225972,_0x15c6f4){var _0x28085f={'raw':!![],'where':{'id':_0x225972[_0xd4f3('0x54')]['id']}},_0x49ce83={};_0x49ce83[_0xd4f3('0x41')]=_[_0xd4f3('0x55')](db['SmsMessage']['rawAttributes']);_0x49ce83['query']=_[_0xd4f3('0x55')](_0x225972['query']);_0x49ce83[_0xd4f3('0x44')]=_[_0xd4f3('0x45')](_0x49ce83['model'],_0x49ce83[_0xd4f3('0x43')]);_0x28085f[_0xd4f3('0x46')]=_[_0xd4f3('0x45')](_0x49ce83['model'],qs[_0xd4f3('0x47')](_0x225972[_0xd4f3('0x43')][_0xd4f3('0x47')]));_0x28085f['attributes']=_0x28085f[_0xd4f3('0x46')][_0xd4f3('0x48')]?_0x28085f[_0xd4f3('0x46')]:_0x49ce83[_0xd4f3('0x41')];if(_0x225972['query'][_0xd4f3('0x52')]){_0x28085f[_0xd4f3('0x56')]=[{'all':!![]}];}_0x28085f=_['merge']({},_0x28085f,_0x225972[_0xd4f3('0x51')]);return db[_0xd4f3('0x3d')][_0xd4f3('0x57')](_0x28085f)[_0xd4f3('0x22')](handleEntityNotFound(_0x15c6f4,null))[_0xd4f3('0x22')](respondWithResult(_0x15c6f4,null))[_0xd4f3('0x2c')](handleError(_0x15c6f4,null));};exports[_0xd4f3('0x58')]=function(_0x492772,_0xfce22e){return db[_0xd4f3('0x3d')][_0xd4f3('0x58')](_0x492772[_0xd4f3('0x59')],{})['then'](respondWithResult(_0xfce22e,0xc9))[_0xd4f3('0x2c')](handleError(_0xfce22e,null));};exports[_0xd4f3('0x5a')]=function(_0x205e54,_0x357ada){if(_0x205e54[_0xd4f3('0x59')]['id']){delete _0x205e54[_0xd4f3('0x59')]['id'];}return db[_0xd4f3('0x3d')][_0xd4f3('0x57')]({'where':{'id':_0x205e54[_0xd4f3('0x54')]['id']}})[_0xd4f3('0x22')](handleEntityNotFound(_0x357ada,null))[_0xd4f3('0x22')](saveUpdates(_0x205e54[_0xd4f3('0x59')],null))['then'](respondWithResult(_0x357ada,null))[_0xd4f3('0x2c')](handleError(_0x357ada,null));};exports['destroy']=function(_0x19ddcd,_0x4bb8e5){return db[_0xd4f3('0x3d')][_0xd4f3('0x57')]({'where':{'id':_0x19ddcd['params']['id']}})[_0xd4f3('0x22')](handleEntityNotFound(_0x4bb8e5,null))['then'](removeEntity(_0x4bb8e5,null))[_0xd4f3('0x2c')](handleError(_0x4bb8e5,null));};exports['describe']=function(_0x3df7d6,_0x35064a){return db[_0xd4f3('0x3d')]['describe']()['then'](respondWithResult(_0x35064a,null))[_0xd4f3('0x2c')](handleError(_0x35064a,null));};var interaction_log=require(_0xd4f3('0x16'))(_0xd4f3('0x5b'));exports[_0xd4f3('0x5c')]=function(_0x1042a2,_0x4b0a9c,_0x21c490){var _0x4f1550={'agent':{},'channel':_0xd4f3('0x5d')};if(_0x1042a2[_0xd4f3('0x59')]['id']){delete _0x1042a2['body']['id'];}_0x1042a2[_0xd4f3('0x59')][_0xd4f3('0x5e')]=!![];_0x1042a2[_0xd4f3('0x59')][_0xd4f3('0x5f')]=moment()['format'](_0xd4f3('0x60'));_0x1042a2['body'][_0xd4f3('0x61')]=_0x1042a2['body'][_0xd4f3('0x61')]||_0x1042a2[_0xd4f3('0x62')]['id'];_0x4f1550[_0xd4f3('0x63')]['id']=_0x1042a2[_0xd4f3('0x59')][_0xd4f3('0x61')];return db['SmsMessage'][_0xd4f3('0x57')]({'where':{'id':_0x1042a2['params']['id'],'UserId':null}})[_0xd4f3('0x22')](handleEntityNotFound(_0x4b0a9c,null))[_0xd4f3('0x22')](saveUpdates(_0x1042a2[_0xd4f3('0x59')],null))[_0xd4f3('0x22')](function(_0x2dd888){if(_0x2dd888){_0x4f1550['message']=_0x2dd888['get']({'plain':!![]});return db[_0xd4f3('0x64')][_0xd4f3('0x57')]({'where':{'id':_0x2dd888[_0xd4f3('0x65')]}});}return null;})[_0xd4f3('0x22')](handleEntityNotFound(_0x4b0a9c,null))['then'](function(_0x3d6ca4){if(_0x3d6ca4){return _0x3d6ca4[_0xd4f3('0x5a')]({'UserId':_0x1042a2[_0xd4f3('0x59')][_0xd4f3('0x61')],'read1stAt':_['isNil'](_0x3d6ca4[_0xd4f3('0x66')])?moment()['format'](_0xd4f3('0x60')):undefined});}return null;})['then'](function(_0x1ac7c7){if(_0x1ac7c7){_0x4f1550[_0xd4f3('0x67')]=_0x1ac7c7[_0xd4f3('0x68')]({'plain':!![]});interaction_log[_0xd4f3('0x23')](_0xd4f3('0x69'),_0x1042a2[_0xd4f3('0x62')]['id'],_0x1042a2[_0xd4f3('0x62')][_0xd4f3('0x3a')],_0x1042a2['user'][_0xd4f3('0x6a')],_0x4f1550['interaction']['id'],_0x1042a2[_0xd4f3('0x59')]?JSON[_0xd4f3('0x6b')](_0x1042a2[_0xd4f3('0x59')]):_0xd4f3('0x6c'));return respondWithRpcPromise(_0xd4f3('0x6d'),_0xd4f3('0x6e'),_0x4f1550);}return null;})[_0xd4f3('0x22')](function(_0x158703){var _0x79b057=_0xd4f3('0x6f')+_0x158703[_0xd4f3('0x2a')]['ContactId'];return db[_0xd4f3('0x70')][_0xd4f3('0x43')](_0x79b057,{'type':db[_0xd4f3('0x71')][_0xd4f3('0x72')][_0xd4f3('0x73')],'raw':!![]})[_0xd4f3('0x22')](function(_0x27aee1){return _0x27aee1;});})[_0xd4f3('0x22')](function(_0x1662ea){if(_0x1662ea){_0x4f1550['message']['contact']=_0x1662ea[0x0];if(!_0x1042a2[_0xd4f3('0x59')][_0xd4f3('0x61')])return;return db['User'][_0xd4f3('0x57')]({'where':{'id':_0x1042a2[_0xd4f3('0x59')]['UserId'],'role':_0xd4f3('0x63')},'attributes':['id','name',_0xd4f3('0x74'),_0xd4f3('0x75'),'internal'],'raw':!![]});}return null;})[_0xd4f3('0x22')](function(_0x26625c){if(!_0x26625c)return null;_0x4f1550[_0xd4f3('0x2a')][_0xd4f3('0x63')]=_0x26625c;return _0x4f1550;})[_0xd4f3('0x22')](function(_0x429bff){if(_0x429bff){if(_0x1042a2[_0xd4f3('0x59')][_0xd4f3('0x76')]){_0x4f1550['message']['interface']=util[_0xd4f3('0x77')]('SIP/%s',_0x1042a2[_0xd4f3('0x62')]['name']);_0x4f1550['message'][_0xd4f3('0x78')]=_0x4f1550['channel'];_0x4f1550[_0xd4f3('0x2a')][_0xd4f3('0x79')]=_0x4f1550['channel'];_0x4f1550[_0xd4f3('0x2a')]['event']=_0xd4f3('0x5c');return respondWithRpcPromise(_0xd4f3('0x7a'),_0xd4f3('0x7a'),{'event':_0xd4f3('0x7b'),'message':_0x4f1550[_0xd4f3('0x2a')]},client9002)[_0xd4f3('0x22')](function(){return _0x4f1550;});}return _0x4f1550;}return null;})[_0xd4f3('0x22')](respondWithResult(_0x4b0a9c,null))[_0xd4f3('0x2c')](handleError(_0x4b0a9c,null));};var interaction_log=require(_0xd4f3('0x16'))(_0xd4f3('0x5b'));exports[_0xd4f3('0x37')]=function(_0x236d3e,_0x1e814c,_0x198c8e){var _0x18c573={'agent':{},'channel':'sms'};if(_0x236d3e[_0xd4f3('0x59')]['id']){delete _0x236d3e[_0xd4f3('0x59')]['id'];}_0x236d3e[_0xd4f3('0x59')][_0xd4f3('0x61')]=_0x236d3e[_0xd4f3('0x59')][_0xd4f3('0x61')]||_0x236d3e[_0xd4f3('0x62')]['id'];_0x18c573[_0xd4f3('0x63')]['id']=_0x236d3e['body'][_0xd4f3('0x61')];return db[_0xd4f3('0x3d')][_0xd4f3('0x57')]({'where':{'id':_0x236d3e['params']['id'],'UserId':null}})[_0xd4f3('0x22')](handleEntityNotFound(_0x1e814c,null))[_0xd4f3('0x22')](function(_0x56b628){if(_0x56b628){_0x18c573[_0xd4f3('0x2a')]=_0x56b628[_0xd4f3('0x68')]({'plain':!![]});return db[_0xd4f3('0x64')][_0xd4f3('0x57')]({'where':{'id':_0x56b628[_0xd4f3('0x65')]}});}return null;})[_0xd4f3('0x22')](handleEntityNotFound(_0x1e814c,null))['then'](function(_0x49a706){if(_0x49a706){_0x18c573[_0xd4f3('0x67')]=_0x49a706[_0xd4f3('0x68')]({'plain':!![]});interaction_log[_0xd4f3('0x23')](_0xd4f3('0x7c'),_0x236d3e[_0xd4f3('0x62')]['id'],_0x236d3e[_0xd4f3('0x62')]['name'],_0x236d3e[_0xd4f3('0x62')][_0xd4f3('0x6a')],_0x18c573[_0xd4f3('0x67')]['id'],_0x236d3e[_0xd4f3('0x59')]?JSON[_0xd4f3('0x6b')](_0x236d3e['body']):_0xd4f3('0x6c'));return respondWithRpcPromise(_0xd4f3('0x7d'),_0xd4f3('0x7e'),_0x18c573);}return null;})['then'](function(_0x531836){var _0x19f112='SELECT\x20*\x20FROM\x20cm_contacts\x20WHERE\x20id\x20=\x20'+_0x531836[_0xd4f3('0x2a')][_0xd4f3('0x7f')];return db[_0xd4f3('0x70')]['query'](_0x19f112,{'type':db['Sequelize'][_0xd4f3('0x72')]['SELECT'],'raw':!![]})[_0xd4f3('0x22')](function(_0x21416f){return _0x21416f;});})[_0xd4f3('0x22')](function(_0x21fd43){if(_0x21fd43){_0x18c573[_0xd4f3('0x2a')][_0xd4f3('0x80')]=_0x21fd43[0x0];if(!_0x236d3e[_0xd4f3('0x59')][_0xd4f3('0x61')])return;return db['User'][_0xd4f3('0x57')]({'where':{'id':_0x236d3e['body'][_0xd4f3('0x61')],'role':_0xd4f3('0x63')},'attributes':['id',_0xd4f3('0x3a'),_0xd4f3('0x74'),_0xd4f3('0x75'),_0xd4f3('0x81')],'raw':!![]});}return null;})[_0xd4f3('0x22')](function(_0x470e01){if(!_0x470e01)return null;_0x18c573[_0xd4f3('0x2a')][_0xd4f3('0x63')]=_0x470e01;return _0x18c573;})[_0xd4f3('0x22')](function(_0x3888ea){if(_0x3888ea){_0x3888ea[_0xd4f3('0x2a')][_0xd4f3('0x82')]=util[_0xd4f3('0x77')]('SIP/%s',_0x236d3e[_0xd4f3('0x62')][_0xd4f3('0x3a')]);_0x3888ea['message'][_0xd4f3('0x78')]=_0x18c573[_0xd4f3('0x78')];_0x3888ea['message'][_0xd4f3('0x79')]=_0x18c573[_0xd4f3('0x78')];_0x3888ea['message'][_0xd4f3('0x83')]=_0xd4f3('0x37');respondWithRpcPromise(_0xd4f3('0x7a'),_0xd4f3('0x7a'),{'event':_0xd4f3('0x84'),'message':_0x3888ea[_0xd4f3('0x2a')]},client9002);return _0x18c573;}return null;})[_0xd4f3('0x22')](respondWithResult(_0x1e814c,null))[_0xd4f3('0x2c')](handleError(_0x1e814c,null));};exports[_0xd4f3('0x2e')]=function(_0x2e6c3a,_0x4804f9,_0x4a7026){if(_0x2e6c3a[_0xd4f3('0x59')]['id']){delete _0x2e6c3a[_0xd4f3('0x59')]['id'];}var _0x1a0926;return db[_0xd4f3('0x3d')][_0xd4f3('0x57')]({'where':{'id':_0x2e6c3a[_0xd4f3('0x54')]['id']}})[_0xd4f3('0x22')](handleEntityNotFound(_0x4804f9,null))['then'](function(_0x4df32f){if(_0x4df32f){_0x1a0926=_0x4df32f;return db[_0xd4f3('0x85')][_0xd4f3('0x57')]({'where':{'id':_0x4df32f[_0xd4f3('0x86')]}});}})[_0xd4f3('0x22')](handleEntityNotFound(_0x4804f9,null))[_0xd4f3('0x22')](function(_0x283e96){if(_0x283e96){logger[_0xd4f3('0x26')]('SmsMessage,\x20%s,\x20%s,\x20%s','status','received\x20delivery\x20report\x20from',_0x283e96['type'],util['inspect'](_0x2e6c3a['body'],{'showHidden':![],'depth':null}));switch(_0x283e96[_0xd4f3('0x3f')]){case'twilio':if(_0x2e6c3a[_0xd4f3('0x59')][_0xd4f3('0x87')]&&_0x2e6c3a[_0xd4f3('0x59')][_0xd4f3('0x87')]===_0x1a0926['messageId']){return _0x1a0926['update']({'read':!![]});}else{logger[_0xd4f3('0x28')](_0xd4f3('0x88'),_0xd4f3('0x2e'),'twilio',util[_0xd4f3('0x89')](_0x2e6c3a[_0xd4f3('0x59')],{'showHidden':![],'depth':null}));}break;case _0xd4f3('0x8a'):if(_0x2e6c3a['body'][_0xd4f3('0x8b')]&&_0x2e6c3a[_0xd4f3('0x59')][_0xd4f3('0x8b')]===_0x1a0926[_0xd4f3('0x8c')]&&_['indexOf'](['sent',_0xd4f3('0x8d')],_0x2e6c3a['body'][_0xd4f3('0x8e')])>=0x0){return _0x1a0926[_0xd4f3('0x5a')]({'read':!![]});}else{logger[_0xd4f3('0x28')](_0xd4f3('0x88'),_0xd4f3('0x2e'),_0xd4f3('0x8f'),util['inspect'](_0x2e6c3a[_0xd4f3('0x59')],{'showHidden':![],'depth':null}));}break;case _0xd4f3('0x90'):var _0x38f872=_0x2e6c3a[_0xd4f3('0x59')]['results'][0x0];if(_0x38f872['status'][_0xd4f3('0x91')]===_0xd4f3('0x92')){return _0x1a0926['update']({'read':!![]});}else{logger[_0xd4f3('0x28')](_0xd4f3('0x88'),_0xd4f3('0x2e'),_0xd4f3('0x90'),util[_0xd4f3('0x89')](_0x2e6c3a[_0xd4f3('0x59')],{'showHidden':![],'depth':null}));}break;}return _0x1a0926;}})[_0xd4f3('0x22')](respondWithResult(_0x4804f9,null))['catch'](handleError(_0x4804f9,null));};