Built motion from commit 3e059bc2.|2.5.32
[motion2.git] / server / api / smsInteraction / smsInteraction.controller.js
index 0fb7de0..7108620 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x9348=['files','attachments','format','transcript-%d-%s.zip','CmContact','lastName','direction','secret','SmsAccount','Account','Owner','mkdirSync','10px','40px','<div\x20class=\x22header\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<h5>Interaction\x20Transcript</h5>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>','Sms','YYYY-MM-DD','fullname','N.A.','closed','closedAt','YYYY-MM-DD\x20HH:mm:ss','disposition','Messages','out','System','firstName','renderFile','views','downloadInteraction.html','.pdf','download','log','err','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','util','path','sox','to-csv','ejs','lodash','crypto','jsforce','desk.js','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','localhost','socket.io-emitter','./smsInteraction.socket','register','sendStatus','status','end','json','count','offset','limit','Content-Range','apply','reject','save','update','then','destroy','error','stack','name','send','Users','map','TagIds','Tags','split','forEach','push','catch','index','fieldName','type','key','model','query','keys','filters','intersection','fields','attributes','nolimit','order','where','pick','select','field','color','from','tools_tags','u.id','ui.SmsInteractionId','left_join','u.id\x20=\x20ui.UserId','sms_interactions','cm_contacts','users','sms_accounts','a.id\x20=\x20i.SmsAccountId','sms_messages','me.SmsInteractionId\x20=\x20i.id','sms_interaction_has_tags','it.SmsInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','parseSearch','conditions','length','unreadMessages','value','having','`\x20>\x200','Contact','operator','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','find','ContactId','text','Tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','UserId','buildExpression','start','some','compact','isEmpty','i.SmsAccountId\x20IN\x20?','concat','createdAt','parse','$gte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20>\x200','tag','filter','\x27\x27\x27\x27','isNumeric','i.id\x20LIKE\x20?','i.phone\x20LIKE\x20?','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','group','Sequelize','QueryTypes','SELECT','i.id','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','t.id\x20IN\x20?','resolve','SmsAccountId','journey','i.SmsAccountId\x20IS\x20NOT\x20NULL','user','getSmsAccounts','i.SmsAccountId\x20IS\x20NULL','sequelize','toString','keyBy','merge','SmsInteraction','a.key','Account.key','Account.mandatoryDisposition','i.*','c.firstName','Contact.firstName','c.lastName','c.phone','Contact.phone','c.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.SmsInteractionId\x20IN\x20?','groupBy','SmsInteractionId','rows','show','params','rawAttributes','includeAll','include','create','body','describe','SmsMessage','addMessage','ids','findOne','hasOwnProperty','sort','options','findAll','setTags','omit','spread','smsInteractionTags:save','removeTags','unix','join','root','server','tmp'];(function(_0x31991b,_0xaf75d2){var _0x307304=function(_0x2f36c5){while(--_0x2f36c5){_0x31991b['push'](_0x31991b['shift']());}};_0x307304(++_0xaf75d2);}(_0x9348,0x10d));var _0x8934=function(_0x26c9cb,_0x5a5ecc){_0x26c9cb=_0x26c9cb-0x0;var _0xcb1b4a=_0x9348[_0x26c9cb];return _0xcb1b4a;};'use strict';var pdf=require(_0x8934('0x0'));var emlformat=require(_0x8934('0x1'));var rimraf=require(_0x8934('0x2'));var zipdir=require(_0x8934('0x3'));var jsonpatch=require(_0x8934('0x4'));var rp=require('request-promise');var moment=require(_0x8934('0x5'));var BPromise=require(_0x8934('0x6'));var Mustache=require('mustache');var util=require(_0x8934('0x7'));var path=require(_0x8934('0x8'));var sox=require(_0x8934('0x9'));var csv=require(_0x8934('0xa'));var ejs=require(_0x8934('0xb'));var fs=require('fs');var _=require(_0x8934('0xc'));var squel=require('squel');var crypto=require(_0x8934('0xd'));var jsforce=require(_0x8934('0xe'));var deskjs=require(_0x8934('0xf'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x8934('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0x8934('0x11'));var hardwareService=require(_0x8934('0x12'));var logger=require(_0x8934('0x13'))(_0x8934('0x14'));var utils=require(_0x8934('0x15'));var config=require(_0x8934('0x16'));var db=require(_0x8934('0x17'))['db'];config[_0x8934('0x18')]=_['defaults'](config[_0x8934('0x18')],{'host':_0x8934('0x19'),'port':0x18eb});var socket=require(_0x8934('0x1a'))(new Redis(config[_0x8934('0x18')]));require(_0x8934('0x1b'))[_0x8934('0x1c')](socket);function respondWithStatusCode(_0x5b560f,_0x254720){_0x254720=_0x254720||0xcc;return function(_0x38230a){if(_0x38230a){return _0x5b560f[_0x8934('0x1d')](_0x254720);}return _0x5b560f[_0x8934('0x1e')](_0x254720)[_0x8934('0x1f')]();};}function respondWithResult(_0x41e6a9,_0x2a5b04){_0x2a5b04=_0x2a5b04||0xc8;return function(_0x357cf8){if(_0x357cf8){return _0x41e6a9['status'](_0x2a5b04)[_0x8934('0x20')](_0x357cf8);}};}function respondWithFilteredResult(_0x3ef798,_0x261c78){return function(_0x5de8f0){if(_0x5de8f0){var _0x47f25e=_0x5de8f0[_0x8934('0x21')],_0x597eed=_0x261c78[_0x8934('0x22')],_0x2ff9ce=_0x261c78[_0x8934('0x22')]+_0x261c78[_0x8934('0x23')],_0x51f9ed;if(_0x2ff9ce>=_0x47f25e){_0x2ff9ce=_0x47f25e;_0x51f9ed=0xc8;}else{_0x51f9ed=0xce;}_0x3ef798[_0x8934('0x1e')](_0x51f9ed);return _0x3ef798['set'](_0x8934('0x24'),_0x597eed+'-'+_0x2ff9ce+'/'+_0x47f25e)['json'](_0x5de8f0);}return null;};}function patchUpdates(_0x476c6c){return function(_0x34f4e7){try{jsonpatch[_0x8934('0x25')](_0x34f4e7,_0x476c6c,!![]);}catch(_0x379445){return BPromise[_0x8934('0x26')](_0x379445);}return _0x34f4e7[_0x8934('0x27')]();};}function saveUpdates(_0x36fe20,_0x4f4a9b){return function(_0xe763c6){if(_0xe763c6){return _0xe763c6[_0x8934('0x28')](_0x36fe20)[_0x8934('0x29')](function(_0x343e09){return _0x343e09;});}return null;};}function removeEntity(_0x43b89a,_0x5e593b){return function(_0x3cf295){if(_0x3cf295){return _0x3cf295[_0x8934('0x2a')]()[_0x8934('0x29')](function(){_0x43b89a['status'](0xcc)[_0x8934('0x1f')]();});}};}function handleEntityNotFound(_0x561df2,_0x14c5f0){return function(_0x1783ce){if(!_0x1783ce){_0x561df2[_0x8934('0x1d')](0x194);}return _0x1783ce;};}function handleError(_0x5ef0ed,_0x1fd5eb){_0x1fd5eb=_0x1fd5eb||0x1f4;return function(_0x15910b){logger[_0x8934('0x2b')](_0x15910b[_0x8934('0x2c')]);if(_0x15910b['name']){delete _0x15910b[_0x8934('0x2d')];}_0x5ef0ed[_0x8934('0x1e')](_0x1fd5eb)[_0x8934('0x2e')](_0x15910b);};}function getInteractionUsers(_0x3d93c7,_0x44972b){return new BPromise(function(_0x20d448,_0x3f328a){try{if(_0x44972b[_0x3d93c7['id']]){_0x3d93c7[_0x8934('0x2f')]=_[_0x8934('0x30')](_0x44972b[_0x3d93c7['id']],function(_0x18938a){return{'id':_0x18938a['id'],'fullname':_0x18938a['fullname']};});}}catch(_0x1d068c){_0x3f328a(_0x1d068c);}_0x20d448(_0x3d93c7);});}function getInteractionTags(_0x3e973e,_0x54d28d){return new BPromise(function(_0x2aa18e,_0x3d60f9){try{if(_0x3e973e[_0x8934('0x31')]){_0x3e973e[_0x8934('0x32')]=[];_0x3e973e['TagIds'][_0x8934('0x33')](',')[_0x8934('0x34')](function(_0x11844a){_0x3e973e[_0x8934('0x32')][_0x8934('0x35')](_0x54d28d[_0x11844a]);});}delete _0x3e973e['TagIds'];}catch(_0x15c40c){_0x3d60f9(_0x15c40c);}_0x2aa18e(_0x3e973e);});}function updateSmsInteraction(_0x59a6bf,_0x5559f1,_0xff95be){return new BPromise(function(_0x2447e6,_0x2f5880){return getInteractionUsers(_0x59a6bf,_0xff95be)[_0x8934('0x29')](function(_0x50bbb4){return getInteractionTags(_0x50bbb4,_0x5559f1);})[_0x8934('0x29')](function(_0x22aebe){_0x2447e6(_0x22aebe);})[_0x8934('0x36')](function(_0x1439ef){_0x2f5880(_0x1439ef);});});}exports[_0x8934('0x37')]=function(_0x4cd282,_0x6764f8){var _0x1ea0cd={},_0x5d5bc2={},_0x5914b9={'count':0x0,'rows':[]};var _0x845028=_[_0x8934('0x30')](db['SmsInteraction']['rawAttributes'],function(_0x1a30c1){return{'name':_0x1a30c1[_0x8934('0x38')],'type':_0x1a30c1[_0x8934('0x39')][_0x8934('0x3a')]};});_0x5d5bc2[_0x8934('0x3b')]=_[_0x8934('0x30')](_0x845028,_0x8934('0x2d'));_0x5d5bc2[_0x8934('0x3c')]=_[_0x8934('0x3d')](_0x4cd282[_0x8934('0x3c')]);_0x5d5bc2[_0x8934('0x3e')]=_['intersection'](_0x5d5bc2[_0x8934('0x3b')],_0x5d5bc2[_0x8934('0x3c')]);_0x1ea0cd['attributes']=_[_0x8934('0x3f')](_0x5d5bc2[_0x8934('0x3b')],qs[_0x8934('0x40')](_0x4cd282[_0x8934('0x3c')][_0x8934('0x40')]));_0x1ea0cd['attributes']=_0x1ea0cd['attributes']['length']?_0x1ea0cd[_0x8934('0x41')]:_0x5d5bc2[_0x8934('0x3b')];if(!_0x4cd282[_0x8934('0x3c')]['hasOwnProperty'](_0x8934('0x42'))){_0x1ea0cd['limit']=qs['limit'](_0x4cd282[_0x8934('0x3c')][_0x8934('0x23')]);_0x1ea0cd['offset']=qs['offset'](_0x4cd282[_0x8934('0x3c')][_0x8934('0x22')]);}_0x1ea0cd[_0x8934('0x43')]=qs['sort'](_0x4cd282[_0x8934('0x3c')]['sort']);_0x1ea0cd[_0x8934('0x44')]=qs['filters'](_[_0x8934('0x45')](_0x4cd282[_0x8934('0x3c')],_0x5d5bc2[_0x8934('0x3e')]),_0x845028);var _0x566d67=[];var _0xefdfab=squel[_0x8934('0x46')]()[_0x8934('0x47')]('id')[_0x8934('0x47')]('name')[_0x8934('0x47')](_0x8934('0x48'))[_0x8934('0x49')](_0x8934('0x4a'));var _0x6e63ff=squel[_0x8934('0x46')]()[_0x8934('0x47')](_0x8934('0x4b'))['field']('u.fullname')['field'](_0x8934('0x4c'))[_0x8934('0x49')]('user_has_sms_interactions','ui')[_0x8934('0x4d')]('users','u',_0x8934('0x4e'));var _0x170fbf=squel['select']()[_0x8934('0x49')](_0x8934('0x4f'),'i')[_0x8934('0x4d')](_0x8934('0x50'),'c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0x8934('0x4d')](_0x8934('0x51'),'o','o.id\x20=\x20i.UserId')[_0x8934('0x4d')](_0x8934('0x52'),'a',_0x8934('0x53'))[_0x8934('0x4d')](_0x8934('0x54'),'me',_0x8934('0x55'))[_0x8934('0x4d')](_0x8934('0x56'),'it',_0x8934('0x57'))[_0x8934('0x4d')](_0x8934('0x4a'),'t',_0x8934('0x58'));var _0x2c322d=squel[_0x8934('0x59')]();var _0x11b06f=[];var _0x245176=squel[_0x8934('0x59')]();var _0x248d88;if(_0x4cd282['query'][_0x8934('0x5a')]){_0x248d88=as[_0x8934('0x5b')](_0x4cd282['query']['search']);var _0x4a52c0=_0x248d88['sqlOperator'];for(var _0x3610a0=0x0;_0x3610a0<_0x248d88[_0x8934('0x5c')][_0x8934('0x5d')];_0x3610a0++){var _0x4d1433=_0x248d88['conditions'][_0x3610a0];var _0x16eb4d='i';var _0x5aa035=_['find'](_0x845028,[_0x8934('0x2d'),_0x4d1433[_0x8934('0x47')]]);if(!_0x5aa035){switch(_0x4d1433[_0x8934('0x47')]){case _0x8934('0x5e'):if(_0x4d1433[_0x8934('0x5f')]==0x1){_0x170fbf[_0x8934('0x60')]('`'+_0x4d1433[_0x8934('0x47')]+'`\x20=\x200');}else{_0x170fbf[_0x8934('0x60')]('`'+_0x4d1433['field']+_0x8934('0x61'));}break;case _0x8934('0x62'):if(_0x4d1433[_0x8934('0x63')]===_0x8934('0x64')){if(_0x4d1433[_0x8934('0x5f')][_0x8934('0x33')]('\x20')[_0x8934('0x5d')]>0x1){_0x2c322d[_0x4a52c0](_0x8934('0x65'),qs['getFullTextValue'](_0x4d1433[_0x8934('0x5f')]),null);}else{var _0x345a95='%'+_0x4d1433[_0x8934('0x5f')]+'%';_0x2c322d[_0x4a52c0](_0x8934('0x66'),_0x345a95,_0x345a95,_0x345a95);}}else{_0x5aa035=_[_0x8934('0x67')](_0x845028,['name',_0x8934('0x68')]);_0x4d1433[_0x8934('0x47')]=_0x8934('0x68');_0x458895=as['buildExpression'](_0x16eb4d,_0x5aa035[_0x8934('0x39')],_0x4d1433);_0x2c322d[_0x4a52c0](_0x458895[_0x8934('0x69')],_0x458895[_0x8934('0x5f')]['start'],_0x458895['value']['end']);}break;case _0x8934('0x6a'):var _0x8e3e85=_0x4d1433[_0x8934('0x5f')]['split'](',')[_0x8934('0x30')](function(_0x10ff96){return Number(_0x10ff96);});_0x8e3e85['forEach'](function(_0x5157d7){_0x245176['or'](_0x8934('0x6b'),'%,'+_0x5157d7+',%');});_0x11b06f=_[_0x8934('0x6c')](_0x11b06f,_0x8e3e85);break;case _0x8934('0x6d'):if(_0x4d1433[_0x8934('0x63')]==='$substring'){_0x2c322d[_0x4a52c0]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x4d1433['value']+'%',null);}else{_0x5aa035=_['find'](_0x845028,[_0x8934('0x2d'),_0x8934('0x6e')]);_0x4d1433[_0x8934('0x47')]=_0x8934('0x6e');_0x458895=as[_0x8934('0x6f')](_0x16eb4d,_0x5aa035[_0x8934('0x39')],_0x4d1433);_0x2c322d[_0x4a52c0](_0x458895['text'],_0x458895[_0x8934('0x5f')][_0x8934('0x70')],_0x458895['value'][_0x8934('0x1f')]);}break;case'body':_0x458895=as[_0x8934('0x6f')]('me',null,_0x4d1433);_0x2c322d[_0x4a52c0](_0x458895['text'],_0x458895[_0x8934('0x5f')][_0x8934('0x70')],_0x458895[_0x8934('0x5f')][_0x8934('0x1f')]);break;}}else{var _0x458895=as[_0x8934('0x6f')](_0x16eb4d,_0x5aa035[_0x8934('0x39')],_0x4d1433);_0x2c322d[_0x4a52c0](_0x458895['text'],_0x458895['value'][_0x8934('0x70')],_0x458895[_0x8934('0x5f')][_0x8934('0x1f')]);}}}else{var _0x458aaf=_(_0x4cd282[_0x8934('0x3c')])[_0x8934('0x3d')]()[_0x8934('0x30')](function(_0x112957){return _[_0x8934('0x71')](_0x845028,[_0x8934('0x2d'),_0x112957])?_0x112957:undefined;})[_0x8934('0x72')]()[_0x8934('0x5f')]();if(!_[_0x8934('0x73')](_0x458aaf)){_0x458aaf[_0x8934('0x34')](function(_0x5c7b96){if(_0x5c7b96==='SmsAccountId'){_0x170fbf[_0x8934('0x44')](_0x8934('0x74'),[][_0x8934('0x75')](_0x4cd282[_0x8934('0x3c')][_0x5c7b96]));}else if(_0x5c7b96===_0x8934('0x76')){var _0x1b54ed=JSON[_0x8934('0x77')](_0x4cd282['query'][_0x5c7b96])[_0x8934('0x78')];var _0x3f51dc=JSON['parse'](_0x4cd282[_0x8934('0x3c')][_0x5c7b96])['$lte'];_0x170fbf[_0x8934('0x44')](_0x8934('0x79'),_0x1b54ed,_0x3f51dc);}else{if(_0x4cd282[_0x8934('0x3c')][_0x5c7b96]==='null'){_0x170fbf[_0x8934('0x44')]('i.'+_0x5c7b96+_0x8934('0x7a'));}else{_0x170fbf['where']('i.'+_0x5c7b96+_0x8934('0x7b'),_0x4cd282['query'][_0x5c7b96]);}}});}if(_0x4cd282[_0x8934('0x3c')]['read']){if(_0x4cd282[_0x8934('0x3c')][_0x8934('0x7c')]==0x1){_0x170fbf[_0x8934('0x60')]('`unreadMessages`\x20=\x200');}else{_0x170fbf[_0x8934('0x60')](_0x8934('0x7d'));}}if(_0x4cd282[_0x8934('0x3c')][_0x8934('0x7e')]){_0x11b06f=_['isArray'](_0x4cd282[_0x8934('0x3c')]['tag'])?_0x4cd282[_0x8934('0x3c')][_0x8934('0x7e')]:new Array(_0x4cd282[_0x8934('0x3c')][_0x8934('0x7e')]);_0x11b06f['forEach'](function(_0xc2799d){_0x245176['or'](_0x8934('0x6b'),'%,'+_0xc2799d+',%');});}if(_0x4cd282[_0x8934('0x3c')]['filter']){var _0x259fcf=_0x4cd282[_0x8934('0x3c')][_0x8934('0x7f')]['replace']('\x5c','\x5c\x5c')['replace']('\x27\x27',_0x8934('0x80'));if(qs[_0x8934('0x81')](_0x259fcf)){_0x2c322d['or'](_0x8934('0x82'),_0x259fcf+'%')['or'](_0x8934('0x83'),_0x259fcf+'%');}else{_0x2c322d['or'](_0x8934('0x84'),qs[_0x8934('0x85')](_0x259fcf))['or'](_0x8934('0x86'),_0x259fcf+'%');}}}_0x170fbf[_0x8934('0x44')](_0x2c322d);_0x170fbf[_0x8934('0x87')]('i.id');var _0x334b42={'type':db[_0x8934('0x88')][_0x8934('0x89')][_0x8934('0x8a')],'raw':!![]};var _0x3a860c=_0x170fbf['clone']();_0x3a860c[_0x8934('0x47')](_0x8934('0x8b'));_0x3a860c['field'](_0x8934('0x8c'),'unreadMessages');if(_0x1ea0cd['order']){_0x1ea0cd['order'][_0x8934('0x34')](function(_0x459c41){_0x170fbf[_0x8934('0x43')]('i.'+_0x459c41[0x0],_0x459c41[0x1]==='DESC'?![]:!![]);});}if(!_[_0x8934('0x73')](_0x11b06f)){_0x170fbf[_0x8934('0x60')](_0x245176);_0x3a860c['where'](_0x8934('0x8d'),_0x11b06f);}BPromise[_0x8934('0x8e')]()[_0x8934('0x29')](function(){if(!_0x248d88){if(_0x4cd282[_0x8934('0x3c')][_0x8934('0x8f')]||_0x4cd282[_0x8934('0x3c')][_0x8934('0x90')])return;_0x3a860c[_0x8934('0x44')](_0x8934('0x91'));_0x170fbf[_0x8934('0x44')]('i.SmsAccountId\x20IS\x20NOT\x20NULL');return;}return _0x4cd282[_0x8934('0x92')][_0x8934('0x93')]({'attributes':['id'],'raw':!![]})[_0x8934('0x29')](function(_0x22a907){if(_[_0x8934('0x73')](_0x22a907)){_0x3a860c[_0x8934('0x44')](_0x8934('0x94'));_0x170fbf['where'](_0x8934('0x94'));}else{_0x3a860c[_0x8934('0x44')](_0x8934('0x74'),_[_0x8934('0x30')](_0x22a907,'id'));_0x170fbf[_0x8934('0x44')](_0x8934('0x74'),_[_0x8934('0x30')](_0x22a907,'id'));}});})[_0x8934('0x29')](function(){db[_0x8934('0x95')]['query'](_0x3a860c['toString'](),_0x334b42)[_0x8934('0x29')](function(_0x9df49d){_0x5914b9['count']=_0x9df49d[_0x8934('0x5d')];if(_0x5914b9[_0x8934('0x21')]===0x0)return[];return db[_0x8934('0x95')][_0x8934('0x3c')](_0xefdfab[_0x8934('0x96')](),_0x334b42)[_0x8934('0x29')](function(_0x2d8db7){_0x566d67=_[_0x8934('0x97')](_0x2d8db7,'id');_0x334b42=_[_0x8934('0x98')](_0x334b42,{'model':db[_0x8934('0x99')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x4cd282[_0x8934('0x3c')]['fields']){_0x1ea0cd[_0x8934('0x41')][_0x8934('0x34')](function(_0x460cef){_0x170fbf['field']('i.'+_0x460cef);});}else{_0x170fbf[_0x8934('0x47')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x8934('0x5e'));_0x170fbf[_0x8934('0x47')](_0x8934('0x9a'),_0x8934('0x9b'));_0x170fbf['field']('a.mandatoryDisposition',_0x8934('0x9c'));_0x170fbf['field'](_0x8934('0x9d'));_0x170fbf[_0x8934('0x47')](_0x8934('0x9e'),_0x8934('0x9f'));_0x170fbf['field'](_0x8934('0xa0'),'Contact.lastName');_0x170fbf['field']('c.email','Contact.email');_0x170fbf[_0x8934('0x47')](_0x8934('0xa1'),_0x8934('0xa2'));_0x170fbf[_0x8934('0x47')](_0x8934('0xa3'),'Contact.mobile');_0x170fbf['field'](_0x8934('0xa4'),_0x8934('0xa5'));_0x170fbf[_0x8934('0x47')](_0x8934('0xa6'),_0x8934('0xa7'));_0x170fbf[_0x8934('0x47')](_0x8934('0xa8'),_0x8934('0xa9'));_0x170fbf[_0x8934('0x47')](_0x8934('0xaa'),_0x8934('0x31'));}if(_0x1ea0cd[_0x8934('0x23')])_0x170fbf[_0x8934('0x23')](_0x1ea0cd[_0x8934('0x23')]);if(_0x1ea0cd[_0x8934('0x22')])_0x170fbf[_0x8934('0x22')](_0x1ea0cd['offset']);return db['sequelize'][_0x8934('0x3c')](_0x170fbf[_0x8934('0x96')](),_0x334b42);})['then'](function(_0x2313f7){_0x6e63ff[_0x8934('0x44')](_0x8934('0xab'),_[_0x8934('0x30')](_0x2313f7,'id'));return db[_0x8934('0x95')][_0x8934('0x3c')](_0x6e63ff[_0x8934('0x96')](),_0x334b42)['then'](function(_0x12fd3c){var _0x5aab65=_[_0x8934('0xac')](_0x12fd3c,_0x8934('0xad'));var _0xdd9bb3=[];_0x2313f7[_0x8934('0x34')](function(_0x5d1baf){_0xdd9bb3[_0x8934('0x35')](updateSmsInteraction(_0x5d1baf,_0x566d67,_0x5aab65));});return BPromise['all'](_0xdd9bb3);});});})['then'](function(_0x383431){_0x5914b9[_0x8934('0xae')]=_0x383431;return _0x5914b9;})['then'](respondWithFilteredResult(_0x6764f8,_0x1ea0cd));})['catch'](handleError(_0x6764f8,null));};exports[_0x8934('0xaf')]=function(_0x5e6b01,_0x22edac){var _0x79bd0d={'raw':![],'where':{'id':_0x5e6b01[_0x8934('0xb0')]['id']}},_0x4ed97b={};_0x4ed97b[_0x8934('0x3b')]=_[_0x8934('0x3d')](db['SmsInteraction'][_0x8934('0xb1')]);_0x4ed97b[_0x8934('0x3c')]=_['keys'](_0x5e6b01['query']);_0x4ed97b[_0x8934('0x3e')]=_[_0x8934('0x3f')](_0x4ed97b[_0x8934('0x3b')],_0x4ed97b['query']);_0x79bd0d['attributes']=_[_0x8934('0x3f')](_0x4ed97b['model'],qs[_0x8934('0x40')](_0x5e6b01[_0x8934('0x3c')][_0x8934('0x40')]));_0x79bd0d[_0x8934('0x41')]=_0x79bd0d[_0x8934('0x41')][_0x8934('0x5d')]?_0x79bd0d[_0x8934('0x41')]:_0x4ed97b[_0x8934('0x3b')];if(_0x5e6b01['query'][_0x8934('0xb2')]){_0x79bd0d[_0x8934('0xb3')]=[{'all':!![]}];}_0x79bd0d=_['merge']({},_0x79bd0d,_0x5e6b01['options']);return db[_0x8934('0x99')]['find'](_0x79bd0d)[_0x8934('0x29')](handleEntityNotFound(_0x22edac,null))[_0x8934('0x29')](respondWithResult(_0x22edac,null))['catch'](handleError(_0x22edac,null));};exports[_0x8934('0xb4')]=function(_0x417ca4,_0x1e8fa6){return db[_0x8934('0x99')]['create'](_0x417ca4[_0x8934('0xb5')],{})[_0x8934('0x29')](respondWithResult(_0x1e8fa6,0xc9))[_0x8934('0x36')](handleError(_0x1e8fa6,null));};exports[_0x8934('0x28')]=function(_0x542c1f,_0x78015a){if(_0x542c1f[_0x8934('0xb5')]['id']){delete _0x542c1f[_0x8934('0xb5')]['id'];}return db[_0x8934('0x99')][_0x8934('0x67')]({'where':{'id':_0x542c1f[_0x8934('0xb0')]['id']}})['then'](handleEntityNotFound(_0x78015a,null))[_0x8934('0x29')](saveUpdates(_0x542c1f['body'],null))[_0x8934('0x29')](respondWithResult(_0x78015a,null))[_0x8934('0x36')](handleError(_0x78015a,null));};exports[_0x8934('0x2a')]=function(_0x5b4cc4,_0xf8b851){return db[_0x8934('0x99')][_0x8934('0x67')]({'where':{'id':_0x5b4cc4[_0x8934('0xb0')]['id']}})['then'](handleEntityNotFound(_0xf8b851,null))[_0x8934('0x29')](removeEntity(_0xf8b851,null))[_0x8934('0x36')](handleError(_0xf8b851,null));};exports[_0x8934('0xb6')]=function(_0x510288,_0x58802c){return db['SmsInteraction']['describe']()[_0x8934('0x29')](respondWithResult(_0x58802c,null))[_0x8934('0x36')](handleError(_0x58802c,null));};exports['addMessage']=function(_0x5ac735,_0x53be62,_0x33a584){return db[_0x8934('0xb7')][_0x8934('0x67')]({'where':{'id':_0x5ac735[_0x8934('0xb0')]['id']}})[_0x8934('0x29')](handleEntityNotFound(_0x53be62,null))[_0x8934('0x29')](function(_0x3cd86b){if(_0x3cd86b){return _0x3cd86b[_0x8934('0xb8')](_0x5ac735['body'][_0x8934('0xb9')],_['omit'](_0x5ac735[_0x8934('0xb5')],[_0x8934('0xb9'),'id'])||{});}})[_0x8934('0x29')](respondWithResult(_0x53be62,null))[_0x8934('0x36')](handleError(_0x53be62,null));};exports['getMessages']=function(_0x122f82,_0x14cfce,_0x1da1cd){var _0x2eb89a={'raw':![],'where':{}};var _0x30bfc1={};var _0x512f54={'count':0x0,'rows':[]};return db[_0x8934('0x99')][_0x8934('0xba')]({'where':{'id':_0x122f82[_0x8934('0xb0')]['id']}})[_0x8934('0x29')](handleEntityNotFound(_0x14cfce,null))[_0x8934('0x29')](function(_0x18dab8){if(_0x18dab8){_0x30bfc1[_0x8934('0x3b')]=_[_0x8934('0x3d')](db[_0x8934('0xb7')]['rawAttributes']);_0x30bfc1[_0x8934('0x3c')]=_[_0x8934('0x3d')](_0x122f82[_0x8934('0x3c')]);_0x30bfc1['filters']=_[_0x8934('0x3f')](_0x30bfc1[_0x8934('0x3b')],_0x30bfc1[_0x8934('0x3c')]);_0x2eb89a[_0x8934('0x41')]=_[_0x8934('0x3f')](_0x30bfc1[_0x8934('0x3b')],qs[_0x8934('0x40')](_0x122f82[_0x8934('0x3c')]['fields']));_0x2eb89a['attributes']=_0x2eb89a[_0x8934('0x41')][_0x8934('0x5d')]?_0x2eb89a['attributes']:_0x30bfc1['model'];if(!_0x122f82[_0x8934('0x3c')][_0x8934('0xbb')](_0x8934('0x42'))){_0x2eb89a[_0x8934('0x23')]=qs[_0x8934('0x23')](_0x122f82[_0x8934('0x3c')]['limit']);_0x2eb89a[_0x8934('0x22')]=qs['offset'](_0x122f82[_0x8934('0x3c')][_0x8934('0x22')]);}_0x2eb89a[_0x8934('0x43')]=qs[_0x8934('0xbc')](_0x122f82['query'][_0x8934('0xbc')]);_0x2eb89a[_0x8934('0x44')]=qs[_0x8934('0x3e')](_[_0x8934('0x45')](_0x122f82[_0x8934('0x3c')],_0x30bfc1[_0x8934('0x3e')]));_0x2eb89a['where']['SmsInteractionId']=_0x18dab8['id'];if(_0x122f82[_0x8934('0x3c')]['filter']){_0x2eb89a['where']=_[_0x8934('0x98')](_0x2eb89a[_0x8934('0x44')],{'$or':_[_0x8934('0x30')](_0x2eb89a[_0x8934('0x41')],function(_0x8c7175){var _0x4ca9ea={};_0x4ca9ea[_0x8c7175]={'$like':'%'+_0x122f82[_0x8934('0x3c')][_0x8934('0x7f')]+'%'};return _0x4ca9ea;})});}if(_0x122f82['query'][_0x8934('0x78')]){var _0x342cfd=_0x122f82[_0x8934('0x3c')][_0x8934('0x78')]['split'](',');var _0xdff48f={};_0xdff48f[_0x342cfd[0x0]]={'$gte':moment(_0x342cfd[0x1])['format']('YYYY-MM-DD\x20HH:mm:ss')};_0x2eb89a[_0x8934('0x44')]=_['merge'](_0x2eb89a[_0x8934('0x44')],_0xdff48f);}_0x2eb89a=_[_0x8934('0x98')]({},_0x2eb89a,_0x122f82[_0x8934('0xbd')]);return db[_0x8934('0xb7')][_0x8934('0x21')]({'where':_0x2eb89a[_0x8934('0x44')]})[_0x8934('0x29')](function(_0xa01149){_0x512f54[_0x8934('0x21')]=_0xa01149;if(_0x122f82[_0x8934('0x3c')]['includeAll']){_0x2eb89a['include']=[{'all':!![]}];}return db[_0x8934('0xb7')][_0x8934('0xbe')](_0x2eb89a);})[_0x8934('0x29')](function(_0x4ec5e2){_0x512f54[_0x8934('0xae')]=_0x4ec5e2;return _0x512f54;});}})['then'](respondWithFilteredResult(_0x14cfce,_0x2eb89a))[_0x8934('0x36')](handleError(_0x14cfce,null));};exports['addTags']=function(_0x39aed1,_0x4a8cd6,_0x58bb7f){return db['SmsInteraction'][_0x8934('0x67')]({'where':{'id':_0x39aed1[_0x8934('0xb0')]['id']}})[_0x8934('0x29')](handleEntityNotFound(_0x4a8cd6,null))['then'](function(_0x5c6b41){if(_0x5c6b41){return _0x5c6b41[_0x8934('0xbf')](_0x39aed1[_0x8934('0xb5')][_0x8934('0xb9')],_[_0x8934('0xc0')](_0x39aed1['body'],[_0x8934('0xb9'),'id'])||{})[_0x8934('0xc1')](function(){return db['Tag'][_0x8934('0xbe')]({'attributes':['id',_0x8934('0x2d'),'color'],'where':{'id':_0x39aed1[_0x8934('0xb5')][_0x8934('0xb9')]}});})['then'](function(_0x28a360){socket['emit'](_0x8934('0xc2'),{'id':Number(_0x39aed1[_0x8934('0xb0')]['id']),'tags':_0x28a360||[]});return{'id':Number(_0x39aed1['params']['id']),'tags':_0x28a360||[]};});}})[_0x8934('0x29')](respondWithResult(_0x4a8cd6,null))['catch'](handleError(_0x4a8cd6,null));};exports['removeTags']=function(_0x2af43d,_0x20ca44,_0x15f400){return db[_0x8934('0x99')][_0x8934('0x67')]({'where':{'id':_0x2af43d[_0x8934('0xb0')]['id']}})[_0x8934('0x29')](handleEntityNotFound(_0x20ca44,null))['then'](function(_0x29641e){if(_0x29641e){return _0x29641e[_0x8934('0xc3')](_0x2af43d[_0x8934('0x3c')]['ids']);}})[_0x8934('0x29')](respondWithStatusCode(_0x20ca44,null))[_0x8934('0x36')](handleError(_0x20ca44,null));};exports['download']=function(_0x44cae5,_0x216f7c){var _0x31c017=moment()[_0x8934('0xc4')]()[_0x8934('0x96')]();var _0x55c5ea=path[_0x8934('0xc5')](config[_0x8934('0xc6')],_0x8934('0xc7'),'files',_0x8934('0xc8'));var _0x1e0d72=path[_0x8934('0xc5')](config[_0x8934('0xc6')],_0x8934('0xc7'),_0x8934('0xc9'),_0x8934('0xca'));var _0x3cfddb=path[_0x8934('0xc5')](_0x55c5ea,_0x31c017);var _0x95754d=util[_0x8934('0xcb')](_0x8934('0xcc'),_0x44cae5['params']['id'],_0x31c017);var _0x5bbb70=path[_0x8934('0xc5')](_0x55c5ea,_0x95754d);var _0x3af94e=[];_0x3af94e['push']({'model':db['User'],'as':_0x8934('0x6d'),'attributes':['id','fullname'],'raw':!![]});_0x3af94e[_0x8934('0x35')]({'model':db[_0x8934('0xcd')],'as':_0x8934('0x62'),'attributes':['id','firstName',_0x8934('0xce')],'raw':!![]});var _0x31c9be=[{'model':db[_0x8934('0xb7')],'as':'Messages','attributes':['id','body',_0x8934('0x76'),_0x8934('0xcf'),_0x8934('0xd0'),_0x8934('0x7c')],'include':_0x3af94e}];_0x31c9be[_0x8934('0x35')]({'model':db[_0x8934('0xd1')],'as':_0x8934('0xd2'),'attributes':['id',_0x8934('0x2d')]});_0x31c9be[_0x8934('0x35')]({'model':db[_0x8934('0x6d')],'as':_0x8934('0xd3'),'attributes':['id','fullname']});return db['SmsInteraction'][_0x8934('0x67')]({'where':{'id':_0x44cae5[_0x8934('0xb0')]['id']},'include':_0x31c9be})['then'](handleEntityNotFound(_0x216f7c,null))[_0x8934('0x29')](function(_0x35543d){if(_0x35543d){var _0x1cb741=_0x35543d['get']({'plain':!![]});fs[_0x8934('0xd4')](_0x3cfddb);var _0x279d54={'format':'A4','border':_0x8934('0xd5'),'header':{'height':_0x8934('0xd6'),'contents':{'first':_0x8934('0xd7')}},'footer':{'height':'30px','contents':{'default':util['format']('<hr\x20class=\x22separator\x22/>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22footer\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22left\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<span>%s</span>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22center\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<span>{{page}}/{{pages}}</span>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22right\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<span>%s</span>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>',util[_0x8934('0xcb')]('%s\x20#%d',_0x8934('0xd8'),_0x1cb741['id']),moment()[_0x8934('0xcb')](_0x8934('0xd9'))['toString']())}}};var _0x2913ad={'channel':'Sms','account':_0x1cb741[_0x8934('0xd2')][_0x8934('0x2d')],'agent':_0x1cb741['Owner']?_0x1cb741[_0x8934('0xd3')][_0x8934('0xda')]:_0x8934('0xdb'),'createdAt':moment(_0x1cb741[_0x8934('0x76')])[_0x8934('0xcb')]('YYYY-MM-DD\x20HH:mm:ss')[_0x8934('0x96')](),'closedAt':_0x1cb741[_0x8934('0xdc')]?moment(_0x1cb741[_0x8934('0xdd')])[_0x8934('0xcb')](_0x8934('0xde'))[_0x8934('0x96')]():'','disposition':_0x1cb741[_0x8934('0xdf')],'messages':_(_0x1cb741[_0x8934('0xe0')])[_0x8934('0x7f')]({'secret':![]})[_0x8934('0x30')](function(_0xc35284){return{'date':moment(_0xc35284[_0x8934('0x76')])[_0x8934('0xcb')](_0x8934('0xde'))[_0x8934('0x96')](),'sender':_0xc35284[_0x8934('0xcf')]===_0x8934('0xe1')?_0xc35284[_0x8934('0x6d')]?_0xc35284[_0x8934('0x6d')][_0x8934('0xda')]:_0x8934('0xe2'):_0xc35284[_0x8934('0x62')][_0x8934('0xe3')]+(_0xc35284[_0x8934('0x62')]['lastName']?'\x20'+_0xc35284[_0x8934('0x62')]['lastName']:''),'body':_0xc35284[_0x8934('0xb5')],'direction':_0xc35284['direction']===_0x8934('0xe1')?'A':'C','secret':_0xc35284[_0x8934('0xd0')],'read':_0xc35284['read']};})[_0x8934('0x5f')]()};return ejs[_0x8934('0xe4')](path['join'](config[_0x8934('0xc6')],'server',_0x8934('0xe5'),_0x8934('0xe6')),{'interaction':_0x2913ad})[_0x8934('0x29')](function(_0x35e54e){return new BPromise(function(_0x35b69d,_0x5d8e8e){pdf[_0x8934('0xb4')](_0x35e54e,_0x279d54)['toFile'](path[_0x8934('0xc5')](_0x3cfddb,'transcript-'+_0x1cb741['id']+'-'+_0x31c017+_0x8934('0xe7')),function(_0x36ede5,_0x3ae823){if(_0x36ede5)return _0x5d8e8e(_0x36ede5);_0x35b69d(_0x3ae823);});});})[_0x8934('0x29')](function(){return new BPromise(function(_0x4e53cd,_0x36740b){zipdir(_0x3cfddb,{'saveTo':_0x5bbb70},function(_0x25af33,_0x591acf){if(_0x25af33)return _0x36740b(_0x25af33);return _0x4e53cd(_0x591acf);});})[_0x8934('0x29')](function(){return new BPromise(function(_0xe50e0c,_0x508508){rimraf(_0x3cfddb,function(_0x7f8a86){if(_0x7f8a86)_0x508508(_0x7f8a86);return _0xe50e0c();});});})[_0x8934('0x29')](function(){return _0x216f7c[_0x8934('0xe8')](_0x5bbb70,_0x95754d,function(_0x4e26b1){if(_0x4e26b1){console[_0x8934('0xe9')](_0x8934('0xea'),_0x4e26b1);}else{fs['unlinkSync'](_0x5bbb70);}});});});}else{return _0x216f7c[_0x8934('0x1d')](0xc8);}})[_0x8934('0x36')](handleError(_0x216f7c,null));};
\ No newline at end of file
+var _0xf7e5=['Tag','split','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','body','some','compact','SmsAccountId','i.SmsAccountId\x20IN\x20?','concat','parse','$gte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20=\x20?','read','isArray','tag','filter','replace','isNumeric','i.id\x20LIKE\x20?','i.phone\x20LIKE\x20?','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','i.id','Sequelize','QueryTypes','SELECT','clone','DESC','isEmpty','resolve','i.SmsAccountId\x20IS\x20NOT\x20NULL','user','agent','getSmsAccounts','i.SmsAccountId\x20IS\x20NULL','role','sequelize','toString','keyBy','merge','SmsInteraction','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','a.mandatoryDisposition','Account.mandatoryDisposition','CASE\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','i.*','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','c.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','groupBy','all','rows','includeAll','include','create','update','params','destroy','describe','addMessage','SmsMessage','ids','omit','getMessages','findOne','hasOwnProperty','format','YYYY-MM-DD\x20HH:mm:ss','setTags','spread','color','emit','smsInteractionTags:save','removeTags','download','unix','join','root','server','attachments','transcript-%d-%s.zip','fullname','CmContact','Contact','firstName','lastName','createdAt','secret','SmsAccount','Account','Owner','get','mkdirSync','Sms','N.A.','closed','closedAt','disposition','Messages','out','System','direction','renderFile','downloadInteraction.ejs','createPdfFromHTML','log','err','unlinkSync','rimraf','zip-dir','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','crypto','jsforce','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../components/export/pdf','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','redis','defaults','socket.io-emitter','sendStatus','status','json','offset','undefined','count','set','Content-Range','apply','then','end','name','send','map','TagIds','Tags','forEach','push','catch','index','rawAttributes','fieldName','type','query','keys','filters','intersection','attributes','fields','model','nolimit','limit','order','sort','where','pick','field','tools_tags','select','u.id','u.fullname','ui.SmsInteractionId','from','user_has_sms_interactions','left_join','users','u.id\x20=\x20ui.UserId','sms_interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','sms_accounts','a.id\x20=\x20i.SmsAccountId','sms_messages','me.SmsInteractionId\x20=\x20i.id','sms_interaction_has_tags','it.SmsInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','parseSearch','search','sqlOperator','conditions','length','find','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','operator','$substring','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','text','start'];(function(_0x148b6f,_0x448c22){var _0x17e9c2=function(_0x31f1a9){while(--_0x31f1a9){_0x148b6f['push'](_0x148b6f['shift']());}};_0x17e9c2(++_0x448c22);}(_0xf7e5,0x7d));var _0x5f7e=function(_0x492535,_0x46524a){_0x492535=_0x492535-0x0;var _0x256620=_0xf7e5[_0x492535];return _0x256620;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x5f7e('0x0'));var zipdir=require(_0x5f7e('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x5f7e('0x2'));var BPromise=require(_0x5f7e('0x3'));var Mustache=require(_0x5f7e('0x4'));var util=require(_0x5f7e('0x5'));var path=require(_0x5f7e('0x6'));var sox=require(_0x5f7e('0x7'));var csv=require(_0x5f7e('0x8'));var ejs=require(_0x5f7e('0x9'));var fs=require('fs');var fs_extra=require(_0x5f7e('0xa'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x5f7e('0xb'));var jsforce=require(_0x5f7e('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x5f7e('0xd'));var Papa=require(_0x5f7e('0xe'));var Redis=require(_0x5f7e('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x5f7e('0x10'));var as=require(_0x5f7e('0x11'));var pdf=require(_0x5f7e('0x12'));var hardwareService=require(_0x5f7e('0x13'));var logger=require(_0x5f7e('0x14'))(_0x5f7e('0x15'));var utils=require(_0x5f7e('0x16'));var config=require('../../config/environment');var licenseUtil=require(_0x5f7e('0x17'));var db=require(_0x5f7e('0x18'))['db'];config[_0x5f7e('0x19')]=_[_0x5f7e('0x1a')](config[_0x5f7e('0x19')],{'host':'localhost','port':0x18eb});var socket=require(_0x5f7e('0x1b'))(new Redis(config['redis']));require('./smsInteraction.socket')['register'](socket);function respondWithStatusCode(_0x81514b,_0x350e85){_0x350e85=_0x350e85||0xcc;return function(_0x3b6848){if(_0x3b6848){return _0x81514b[_0x5f7e('0x1c')](_0x350e85);}return _0x81514b['status'](_0x350e85)['end']();};}function respondWithResult(_0x417ca7,_0x1faf29){_0x1faf29=_0x1faf29||0xc8;return function(_0x2da1cb){if(_0x2da1cb){return _0x417ca7[_0x5f7e('0x1d')](_0x1faf29)[_0x5f7e('0x1e')](_0x2da1cb);}};}function respondWithFilteredResult(_0x16e3bf,_0x5a2208){return function(_0x421b34){if(_0x421b34){var _0x46f3fd=typeof _0x5a2208[_0x5f7e('0x1f')]===_0x5f7e('0x20')&&typeof _0x5a2208['limit']===_0x5f7e('0x20');var _0x3937e6=_0x421b34[_0x5f7e('0x21')];var _0x41338c=_0x46f3fd?0x0:_0x5a2208[_0x5f7e('0x1f')];var _0x995408=_0x46f3fd?_0x421b34[_0x5f7e('0x21')]:_0x5a2208[_0x5f7e('0x1f')]+_0x5a2208['limit'];var _0x52024a;if(_0x995408>=_0x3937e6){_0x995408=_0x3937e6;_0x52024a=0xc8;}else{_0x52024a=0xce;}_0x16e3bf[_0x5f7e('0x1d')](_0x52024a);return _0x16e3bf[_0x5f7e('0x22')](_0x5f7e('0x23'),_0x41338c+'-'+_0x995408+'/'+_0x3937e6)[_0x5f7e('0x1e')](_0x421b34);}return null;};}function patchUpdates(_0x22d542){return function(_0x103409){try{jsonpatch[_0x5f7e('0x24')](_0x103409,_0x22d542,!![]);}catch(_0x1ea0df){return BPromise['reject'](_0x1ea0df);}return _0x103409['save']();};}function saveUpdates(_0x251e81,_0x24d221){return function(_0x1001a0){if(_0x1001a0){return _0x1001a0['update'](_0x251e81)[_0x5f7e('0x25')](function(_0x3ee6dc){return _0x3ee6dc;});}return null;};}function removeEntity(_0x2d947e,_0x1eaf85){return function(_0x3afcf9){if(_0x3afcf9){return _0x3afcf9['destroy']()[_0x5f7e('0x25')](function(){_0x2d947e[_0x5f7e('0x1d')](0xcc)[_0x5f7e('0x26')]();});}};}function handleEntityNotFound(_0xce88d7,_0x4cb173){return function(_0x520b04){if(!_0x520b04){_0xce88d7[_0x5f7e('0x1c')](0x194);}return _0x520b04;};}function handleError(_0x4c1e00,_0x4077e6){_0x4077e6=_0x4077e6||0x1f4;return function(_0x5baa4e){logger['error'](_0x5baa4e['stack']);if(_0x5baa4e[_0x5f7e('0x27')]){delete _0x5baa4e['name'];}_0x4c1e00['status'](_0x4077e6)[_0x5f7e('0x28')](_0x5baa4e);};}function getInteractionUsers(_0xaf793b,_0x125c57){return new BPromise(function(_0x381277,_0x106003){try{if(_0x125c57[_0xaf793b['id']]){_0xaf793b['Users']=_[_0x5f7e('0x29')](_0x125c57[_0xaf793b['id']],function(_0x27129c){return{'id':_0x27129c['id'],'fullname':_0x27129c['fullname']};});}}catch(_0x1a0b6d){_0x106003(_0x1a0b6d);}_0x381277(_0xaf793b);});}function getInteractionTags(_0x19bcf0,_0x54b3d1){return new BPromise(function(_0x5d2251,_0x219f08){try{if(_0x19bcf0[_0x5f7e('0x2a')]){_0x19bcf0[_0x5f7e('0x2b')]=[];_0x19bcf0[_0x5f7e('0x2a')]['split'](',')[_0x5f7e('0x2c')](function(_0xeb5592){_0x19bcf0[_0x5f7e('0x2b')][_0x5f7e('0x2d')](_0x54b3d1[_0xeb5592]);});}delete _0x19bcf0[_0x5f7e('0x2a')];}catch(_0x34af37){_0x219f08(_0x34af37);}_0x5d2251(_0x19bcf0);});}function updateSmsInteraction(_0x5651fe,_0x5cc45d,_0x2e9ec3){return new BPromise(function(_0x594593,_0x9e2f49){return getInteractionUsers(_0x5651fe,_0x2e9ec3)[_0x5f7e('0x25')](function(_0x418fe1){return getInteractionTags(_0x418fe1,_0x5cc45d);})['then'](function(_0x471df9){_0x594593(_0x471df9);})[_0x5f7e('0x2e')](function(_0x17b57d){_0x9e2f49(_0x17b57d);});});}exports[_0x5f7e('0x2f')]=function(_0x1e4cb1,_0x91b679){var _0x57c0b0={},_0xdac805={},_0x191bc8={'count':0x0,'rows':[]};var _0x39100d=_[_0x5f7e('0x29')](db['SmsInteraction'][_0x5f7e('0x30')],function(_0x468765){return{'name':_0x468765[_0x5f7e('0x31')],'type':_0x468765[_0x5f7e('0x32')]['key']};});_0xdac805['model']=_['map'](_0x39100d,_0x5f7e('0x27'));_0xdac805[_0x5f7e('0x33')]=_[_0x5f7e('0x34')](_0x1e4cb1[_0x5f7e('0x33')]);_0xdac805[_0x5f7e('0x35')]=_[_0x5f7e('0x36')](_0xdac805['model'],_0xdac805[_0x5f7e('0x33')]);_0x57c0b0[_0x5f7e('0x37')]=_[_0x5f7e('0x36')](_0xdac805['model'],qs[_0x5f7e('0x38')](_0x1e4cb1[_0x5f7e('0x33')]['fields']));_0x57c0b0[_0x5f7e('0x37')]=_0x57c0b0[_0x5f7e('0x37')]['length']?_0x57c0b0[_0x5f7e('0x37')]:_0xdac805[_0x5f7e('0x39')];if(!_0x1e4cb1[_0x5f7e('0x33')]['hasOwnProperty'](_0x5f7e('0x3a'))){_0x57c0b0[_0x5f7e('0x3b')]=qs[_0x5f7e('0x3b')](_0x1e4cb1[_0x5f7e('0x33')][_0x5f7e('0x3b')]);_0x57c0b0[_0x5f7e('0x1f')]=qs[_0x5f7e('0x1f')](_0x1e4cb1[_0x5f7e('0x33')]['offset']);}_0x57c0b0[_0x5f7e('0x3c')]=qs[_0x5f7e('0x3d')](_0x1e4cb1[_0x5f7e('0x33')][_0x5f7e('0x3d')]);_0x57c0b0[_0x5f7e('0x3e')]=qs['filters'](_[_0x5f7e('0x3f')](_0x1e4cb1[_0x5f7e('0x33')],_0xdac805['filters']),_0x39100d);var _0x17fd64=[];var _0x2048b4=squel['select']()[_0x5f7e('0x40')]('id')[_0x5f7e('0x40')](_0x5f7e('0x27'))['field']('color')['from'](_0x5f7e('0x41'));var _0x316d93=squel[_0x5f7e('0x42')]()[_0x5f7e('0x40')](_0x5f7e('0x43'))[_0x5f7e('0x40')](_0x5f7e('0x44'))['field'](_0x5f7e('0x45'))[_0x5f7e('0x46')](_0x5f7e('0x47'),'ui')[_0x5f7e('0x48')](_0x5f7e('0x49'),'u',_0x5f7e('0x4a'));var _0x4dc5de=squel[_0x5f7e('0x42')]()[_0x5f7e('0x46')](_0x5f7e('0x4b'),'i')[_0x5f7e('0x48')](_0x5f7e('0x4c'),'c',_0x5f7e('0x4d'))[_0x5f7e('0x48')](_0x5f7e('0x49'),'o',_0x5f7e('0x4e'))[_0x5f7e('0x48')](_0x5f7e('0x4f'),'a',_0x5f7e('0x50'))[_0x5f7e('0x48')](_0x5f7e('0x51'),'me',_0x5f7e('0x52'))[_0x5f7e('0x48')](_0x5f7e('0x53'),'it',_0x5f7e('0x54'))[_0x5f7e('0x48')](_0x5f7e('0x41'),'t',_0x5f7e('0x55'));var _0x2cd55a=squel['expr']();var _0x5cdb70=[];var _0x480e2b=squel[_0x5f7e('0x56')]();var _0x5083d0;if(_0x1e4cb1[_0x5f7e('0x33')]['search']){_0x5083d0=as[_0x5f7e('0x57')](_0x1e4cb1[_0x5f7e('0x33')][_0x5f7e('0x58')]);var _0x5b7396=_0x5083d0[_0x5f7e('0x59')];for(var _0x509d95=0x0;_0x509d95<_0x5083d0[_0x5f7e('0x5a')][_0x5f7e('0x5b')];_0x509d95++){var _0x4cd12a=_0x5083d0[_0x5f7e('0x5a')][_0x509d95];var _0x3b5e0c='i';var _0x52e779=_[_0x5f7e('0x5c')](_0x39100d,['name',_0x4cd12a[_0x5f7e('0x40')]]);if(!_0x52e779){switch(_0x4cd12a[_0x5f7e('0x40')]){case _0x5f7e('0x5d'):if(_0x4cd12a[_0x5f7e('0x5e')]==0x1){_0x4dc5de[_0x5f7e('0x5f')]('`'+_0x4cd12a[_0x5f7e('0x40')]+_0x5f7e('0x60'));}else{_0x4dc5de[_0x5f7e('0x5f')]('`'+_0x4cd12a['field']+_0x5f7e('0x61'));}break;case'Contact':if(_0x4cd12a[_0x5f7e('0x62')]===_0x5f7e('0x63')){if(_0x4cd12a['value']['split']('\x20')[_0x5f7e('0x5b')]>0x1){_0x2cd55a[_0x5b7396]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x4cd12a[_0x5f7e('0x5e')]),null);}else{var _0x102ba4='%'+_0x4cd12a[_0x5f7e('0x5e')]+'%';_0x2cd55a[_0x5b7396](_0x5f7e('0x64'),_0x102ba4,_0x102ba4,_0x102ba4);}}else{_0x52e779=_[_0x5f7e('0x5c')](_0x39100d,['name',_0x5f7e('0x65')]);_0x4cd12a[_0x5f7e('0x40')]=_0x5f7e('0x65');_0x5724e0=as[_0x5f7e('0x66')](_0x3b5e0c,_0x52e779[_0x5f7e('0x32')],_0x4cd12a);_0x2cd55a[_0x5b7396](_0x5724e0[_0x5f7e('0x67')],_0x5724e0[_0x5f7e('0x5e')][_0x5f7e('0x68')],_0x5724e0[_0x5f7e('0x5e')][_0x5f7e('0x26')]);}break;case _0x5f7e('0x69'):var _0x28d009=_0x4cd12a['value'][_0x5f7e('0x6a')](',')[_0x5f7e('0x29')](function(_0x29cbbe){return Number(_0x29cbbe);});_0x28d009[_0x5f7e('0x2c')](function(_0x471d05){_0x480e2b['or'](_0x5f7e('0x6b'),'%,'+_0x471d05+',%');});_0x5cdb70=_['union'](_0x5cdb70,_0x28d009);break;case _0x5f7e('0x6c'):if(_0x4cd12a['operator']===_0x5f7e('0x63')){_0x2cd55a[_0x5b7396](_0x5f7e('0x6d'),'%'+_0x4cd12a[_0x5f7e('0x5e')]+'%',null);}else{_0x52e779=_['find'](_0x39100d,[_0x5f7e('0x27'),_0x5f7e('0x6e')]);_0x4cd12a[_0x5f7e('0x40')]=_0x5f7e('0x6e');_0x5724e0=as[_0x5f7e('0x66')](_0x3b5e0c,_0x52e779[_0x5f7e('0x32')],_0x4cd12a);_0x2cd55a[_0x5b7396](_0x5724e0[_0x5f7e('0x67')],_0x5724e0[_0x5f7e('0x5e')]['start'],_0x5724e0[_0x5f7e('0x5e')][_0x5f7e('0x26')]);}break;case _0x5f7e('0x6f'):_0x5724e0=as['buildExpression']('me',null,_0x4cd12a);_0x2cd55a[_0x5b7396](_0x5724e0[_0x5f7e('0x67')],_0x5724e0[_0x5f7e('0x5e')][_0x5f7e('0x68')],_0x5724e0[_0x5f7e('0x5e')][_0x5f7e('0x26')]);break;}}else{var _0x5724e0=as[_0x5f7e('0x66')](_0x3b5e0c,_0x52e779[_0x5f7e('0x32')],_0x4cd12a);_0x2cd55a[_0x5b7396](_0x5724e0['text'],_0x5724e0[_0x5f7e('0x5e')][_0x5f7e('0x68')],_0x5724e0[_0x5f7e('0x5e')]['end']);}}}else{var _0x43550f=_(_0x1e4cb1[_0x5f7e('0x33')])[_0x5f7e('0x34')]()[_0x5f7e('0x29')](function(_0x301336){return _[_0x5f7e('0x70')](_0x39100d,[_0x5f7e('0x27'),_0x301336])?_0x301336:undefined;})[_0x5f7e('0x71')]()['value']();if(!_['isEmpty'](_0x43550f)){_0x43550f[_0x5f7e('0x2c')](function(_0x2c89dd){if(_0x2c89dd===_0x5f7e('0x72')){_0x4dc5de[_0x5f7e('0x3e')](_0x5f7e('0x73'),[][_0x5f7e('0x74')](_0x1e4cb1[_0x5f7e('0x33')][_0x2c89dd]));}else if(_0x2c89dd==='createdAt'){var _0x23f9f1=JSON[_0x5f7e('0x75')](_0x1e4cb1[_0x5f7e('0x33')][_0x2c89dd])[_0x5f7e('0x76')];var _0x278705=JSON[_0x5f7e('0x75')](_0x1e4cb1['query'][_0x2c89dd])['$lte'];_0x4dc5de[_0x5f7e('0x3e')](_0x5f7e('0x77'),_0x23f9f1,_0x278705);}else{if(_0x1e4cb1[_0x5f7e('0x33')][_0x2c89dd]===_0x5f7e('0x78')){_0x4dc5de['where']('i.'+_0x2c89dd+'\x20IS\x20NULL');}else{_0x4dc5de[_0x5f7e('0x3e')]('i.'+_0x2c89dd+_0x5f7e('0x79'),_0x1e4cb1['query'][_0x2c89dd]);}}});}if(_0x1e4cb1['query']['read']){if(_0x1e4cb1['query'][_0x5f7e('0x7a')]==0x1){_0x4dc5de[_0x5f7e('0x5f')]('`unreadMessages`\x20=\x200');}else{_0x4dc5de['having']('`unreadMessages`\x20>\x200');}}if(_0x1e4cb1[_0x5f7e('0x33')]['tag']){_0x5cdb70=_[_0x5f7e('0x7b')](_0x1e4cb1[_0x5f7e('0x33')]['tag'])?_0x1e4cb1['query'][_0x5f7e('0x7c')]:new Array(_0x1e4cb1['query'][_0x5f7e('0x7c')]);_0x5cdb70[_0x5f7e('0x2c')](function(_0x27bd70){_0x480e2b['or'](_0x5f7e('0x6b'),'%,'+_0x27bd70+',%');});}if(_0x1e4cb1[_0x5f7e('0x33')][_0x5f7e('0x7d')]){var _0x3c02bd=_0x1e4cb1[_0x5f7e('0x33')][_0x5f7e('0x7d')]['replace']('\x5c','\x5c\x5c')[_0x5f7e('0x7e')](/'/g,'\x27\x27');if(qs[_0x5f7e('0x7f')](_0x3c02bd)){_0x2cd55a['or'](_0x5f7e('0x80'),_0x3c02bd+'%')['or'](_0x5f7e('0x81'),_0x3c02bd+'%');}else{_0x2cd55a['or'](_0x5f7e('0x82'),qs[_0x5f7e('0x83')](_0x3c02bd))['or'](_0x5f7e('0x84'),_0x3c02bd+'%');}}}_0x4dc5de[_0x5f7e('0x3e')](_0x2cd55a);_0x4dc5de['group'](_0x5f7e('0x85'));var _0x177666={'type':db[_0x5f7e('0x86')][_0x5f7e('0x87')][_0x5f7e('0x88')],'raw':!![]};var _0x3de159=_0x4dc5de[_0x5f7e('0x89')]();_0x3de159['field'](_0x5f7e('0x85'));_0x3de159['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x5f7e('0x5d'));if(_0x57c0b0[_0x5f7e('0x3c')]){_0x57c0b0[_0x5f7e('0x3c')][_0x5f7e('0x2c')](function(_0x3aac7f){var _0x489921=_0x3aac7f[0x0]==='contactName'?_0x3aac7f[0x0]:'i.'+_0x3aac7f[0x0];_0x4dc5de[_0x5f7e('0x3c')](_0x489921,_0x3aac7f[0x1]===_0x5f7e('0x8a')?![]:!![]);});}if(!_[_0x5f7e('0x8b')](_0x5cdb70)){_0x4dc5de[_0x5f7e('0x5f')](_0x480e2b);_0x3de159[_0x5f7e('0x3e')]('t.id\x20IN\x20?',_0x5cdb70);}BPromise[_0x5f7e('0x8c')]()[_0x5f7e('0x25')](function(){if(!_0x5083d0){if(_0x1e4cb1['query']['SmsAccountId'])return;_0x3de159[_0x5f7e('0x3e')]('i.SmsAccountId\x20IS\x20NOT\x20NULL');_0x4dc5de['where'](_0x5f7e('0x8d'));return;}if(_0x1e4cb1[_0x5f7e('0x8e')]['role']!==_0x5f7e('0x8f'))return;return _0x1e4cb1['user'][_0x5f7e('0x90')]({'attributes':['id'],'raw':!![]})[_0x5f7e('0x25')](function(_0x2fa45b){if(_[_0x5f7e('0x8b')](_0x2fa45b)){_0x3de159['where']('i.SmsAccountId\x20IS\x20NULL');_0x4dc5de[_0x5f7e('0x3e')](_0x5f7e('0x91'));}else{_0x3de159['where'](_0x5f7e('0x73'),_[_0x5f7e('0x29')](_0x2fa45b,'id'));_0x4dc5de[_0x5f7e('0x3e')](_0x5f7e('0x73'),_[_0x5f7e('0x29')](_0x2fa45b,'id'));}});})[_0x5f7e('0x25')](function(){if(_0x1e4cb1[_0x5f7e('0x8e')][_0x5f7e('0x92')]===_0x5f7e('0x8f')&&!_0x5083d0&&!_0x1e4cb1[_0x5f7e('0x33')]['SmsAccountId'])return[];return db['sequelize'][_0x5f7e('0x33')](_0x3de159['toString'](),_0x177666);})['then'](function(_0x2cdf90){_0x191bc8[_0x5f7e('0x21')]=_0x2cdf90['length'];if(_0x191bc8['count']===0x0)return[];return db[_0x5f7e('0x93')][_0x5f7e('0x33')](_0x2048b4[_0x5f7e('0x94')](),_0x177666)['then'](function(_0x2c0a9f){_0x17fd64=_[_0x5f7e('0x95')](_0x2c0a9f,'id');_0x177666=_[_0x5f7e('0x96')](_0x177666,{'model':db[_0x5f7e('0x97')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x1e4cb1['query']['fields']){_0x57c0b0['attributes'][_0x5f7e('0x2c')](function(_0x2e25cb){_0x4dc5de[_0x5f7e('0x40')]('i.'+_0x2e25cb);});}else{_0x4dc5de['field'](_0x5f7e('0x98'),'unreadMessages');_0x4dc5de[_0x5f7e('0x40')](_0x5f7e('0x99'),'Account.key');_0x4dc5de[_0x5f7e('0x40')](_0x5f7e('0x9a'),_0x5f7e('0x9b'));_0x4dc5de[_0x5f7e('0x40')](_0x5f7e('0x9c'),'contactName');_0x4dc5de[_0x5f7e('0x40')](_0x5f7e('0x9d'));_0x4dc5de['field']('c.firstName',_0x5f7e('0x9e'));_0x4dc5de[_0x5f7e('0x40')](_0x5f7e('0x9f'),_0x5f7e('0xa0'));_0x4dc5de['field'](_0x5f7e('0xa1'),_0x5f7e('0xa2'));_0x4dc5de['field'](_0x5f7e('0xa3'),'Contact.phone');_0x4dc5de[_0x5f7e('0x40')](_0x5f7e('0xa4'),'Contact.mobile');_0x4dc5de[_0x5f7e('0x40')](_0x5f7e('0xa5'),_0x5f7e('0xa6'));_0x4dc5de['field'](_0x5f7e('0xa7'),_0x5f7e('0xa8'));_0x4dc5de[_0x5f7e('0x40')](_0x5f7e('0xa9'),_0x5f7e('0xaa'));_0x4dc5de[_0x5f7e('0x40')]('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0x57c0b0[_0x5f7e('0x3b')])_0x4dc5de[_0x5f7e('0x3b')](_0x57c0b0[_0x5f7e('0x3b')]);if(_0x57c0b0[_0x5f7e('0x1f')])_0x4dc5de['offset'](_0x57c0b0[_0x5f7e('0x1f')]);return db[_0x5f7e('0x93')][_0x5f7e('0x33')](_0x4dc5de[_0x5f7e('0x94')](),_0x177666);})[_0x5f7e('0x25')](function(_0x3da93b){if(_0x3da93b[_0x5f7e('0x5b')]>0x0)_0x316d93[_0x5f7e('0x3e')]('ui.SmsInteractionId\x20IN\x20?',_[_0x5f7e('0x29')](_0x3da93b,'id'));return db[_0x5f7e('0x93')][_0x5f7e('0x33')](_0x316d93[_0x5f7e('0x94')](),_0x177666)[_0x5f7e('0x25')](function(_0x56e86b){var _0x446c23=_[_0x5f7e('0xab')](_0x56e86b,'SmsInteractionId');var _0x242dcd=[];_0x3da93b[_0x5f7e('0x2c')](function(_0x129a16){_0x242dcd[_0x5f7e('0x2d')](updateSmsInteraction(_0x129a16,_0x17fd64,_0x446c23));});return BPromise[_0x5f7e('0xac')](_0x242dcd);});});})[_0x5f7e('0x25')](function(_0x34ee1f){_0x191bc8[_0x5f7e('0xad')]=_0x34ee1f;return _0x191bc8;})[_0x5f7e('0x25')](respondWithFilteredResult(_0x91b679,_0x57c0b0))[_0x5f7e('0x2e')](handleError(_0x91b679,null));};exports['show']=function(_0x1dcbf3,_0x1498d8){var _0x4f2eee={'raw':![],'where':{'id':_0x1dcbf3['params']['id']}},_0x3dadd8={};_0x3dadd8[_0x5f7e('0x39')]=_['keys'](db[_0x5f7e('0x97')][_0x5f7e('0x30')]);_0x3dadd8[_0x5f7e('0x33')]=_[_0x5f7e('0x34')](_0x1dcbf3[_0x5f7e('0x33')]);_0x3dadd8[_0x5f7e('0x35')]=_[_0x5f7e('0x36')](_0x3dadd8['model'],_0x3dadd8[_0x5f7e('0x33')]);_0x4f2eee[_0x5f7e('0x37')]=_[_0x5f7e('0x36')](_0x3dadd8[_0x5f7e('0x39')],qs[_0x5f7e('0x38')](_0x1dcbf3['query'][_0x5f7e('0x38')]));_0x4f2eee['attributes']=_0x4f2eee[_0x5f7e('0x37')][_0x5f7e('0x5b')]?_0x4f2eee[_0x5f7e('0x37')]:_0x3dadd8[_0x5f7e('0x39')];if(_0x1dcbf3[_0x5f7e('0x33')][_0x5f7e('0xae')]){_0x4f2eee[_0x5f7e('0xaf')]=[{'all':!![]}];}_0x4f2eee=_[_0x5f7e('0x96')]({},_0x4f2eee,_0x1dcbf3['options']);return db[_0x5f7e('0x97')][_0x5f7e('0x5c')](_0x4f2eee)[_0x5f7e('0x25')](handleEntityNotFound(_0x1498d8,null))[_0x5f7e('0x25')](respondWithResult(_0x1498d8,null))[_0x5f7e('0x2e')](handleError(_0x1498d8,null));};exports[_0x5f7e('0xb0')]=function(_0x3c83d2,_0x25aab2){return db[_0x5f7e('0x97')][_0x5f7e('0xb0')](_0x3c83d2[_0x5f7e('0x6f')],{})['then'](respondWithResult(_0x25aab2,0xc9))['catch'](handleError(_0x25aab2,null));};exports[_0x5f7e('0xb1')]=function(_0x38c032,_0x3962b6){if(_0x38c032['body']['id']){delete _0x38c032[_0x5f7e('0x6f')]['id'];}return db[_0x5f7e('0x97')]['find']({'where':{'id':_0x38c032[_0x5f7e('0xb2')]['id']}})['then'](handleEntityNotFound(_0x3962b6,null))[_0x5f7e('0x25')](saveUpdates(_0x38c032[_0x5f7e('0x6f')],null))[_0x5f7e('0x25')](respondWithResult(_0x3962b6,null))['catch'](handleError(_0x3962b6,null));};exports[_0x5f7e('0xb3')]=function(_0x14da43,_0x53cfff){return db[_0x5f7e('0x97')][_0x5f7e('0x5c')]({'where':{'id':_0x14da43[_0x5f7e('0xb2')]['id']}})[_0x5f7e('0x25')](handleEntityNotFound(_0x53cfff,null))[_0x5f7e('0x25')](removeEntity(_0x53cfff,null))[_0x5f7e('0x2e')](handleError(_0x53cfff,null));};exports[_0x5f7e('0xb4')]=function(_0x44dbd3,_0x5dc363){return db[_0x5f7e('0x97')]['describe']()[_0x5f7e('0x25')](respondWithResult(_0x5dc363,null))[_0x5f7e('0x2e')](handleError(_0x5dc363,null));};exports[_0x5f7e('0xb5')]=function(_0x41db20,_0x1f4a6d,_0x1dad7a){return db[_0x5f7e('0xb6')][_0x5f7e('0x5c')]({'where':{'id':_0x41db20[_0x5f7e('0xb2')]['id']}})[_0x5f7e('0x25')](handleEntityNotFound(_0x1f4a6d,null))[_0x5f7e('0x25')](function(_0x434a08){if(_0x434a08){return _0x434a08[_0x5f7e('0xb5')](_0x41db20[_0x5f7e('0x6f')][_0x5f7e('0xb7')],_[_0x5f7e('0xb8')](_0x41db20['body'],[_0x5f7e('0xb7'),'id'])||{});}})[_0x5f7e('0x25')](respondWithResult(_0x1f4a6d,null))[_0x5f7e('0x2e')](handleError(_0x1f4a6d,null));};exports[_0x5f7e('0xb9')]=function(_0x3a7287,_0x25a658,_0x1f437d){var _0x372c39={'raw':![],'where':{}};var _0x5499c6={};var _0x5e5e48={'count':0x0,'rows':[]};return db[_0x5f7e('0x97')][_0x5f7e('0xba')]({'where':{'id':_0x3a7287[_0x5f7e('0xb2')]['id']}})[_0x5f7e('0x25')](handleEntityNotFound(_0x25a658,null))[_0x5f7e('0x25')](function(_0x428594){if(_0x428594){_0x5499c6[_0x5f7e('0x39')]=_[_0x5f7e('0x34')](db[_0x5f7e('0xb6')][_0x5f7e('0x30')]);_0x5499c6[_0x5f7e('0x33')]=_['keys'](_0x3a7287[_0x5f7e('0x33')]);_0x5499c6[_0x5f7e('0x35')]=_[_0x5f7e('0x36')](_0x5499c6[_0x5f7e('0x39')],_0x5499c6[_0x5f7e('0x33')]);_0x372c39[_0x5f7e('0x37')]=_[_0x5f7e('0x36')](_0x5499c6[_0x5f7e('0x39')],qs[_0x5f7e('0x38')](_0x3a7287[_0x5f7e('0x33')][_0x5f7e('0x38')]));_0x372c39[_0x5f7e('0x37')]=_0x372c39['attributes'][_0x5f7e('0x5b')]?_0x372c39['attributes']:_0x5499c6[_0x5f7e('0x39')];if(!_0x3a7287['query'][_0x5f7e('0xbb')]('nolimit')){_0x372c39[_0x5f7e('0x3b')]=qs[_0x5f7e('0x3b')](_0x3a7287[_0x5f7e('0x33')][_0x5f7e('0x3b')]);_0x372c39[_0x5f7e('0x1f')]=qs['offset'](_0x3a7287[_0x5f7e('0x33')][_0x5f7e('0x1f')]);}_0x372c39['order']=qs[_0x5f7e('0x3d')](_0x3a7287[_0x5f7e('0x33')][_0x5f7e('0x3d')]);_0x372c39[_0x5f7e('0x3e')]=qs[_0x5f7e('0x35')](_[_0x5f7e('0x3f')](_0x3a7287[_0x5f7e('0x33')],_0x5499c6[_0x5f7e('0x35')]));_0x372c39[_0x5f7e('0x3e')]['SmsInteractionId']=_0x428594['id'];if(_0x3a7287[_0x5f7e('0x33')][_0x5f7e('0x7d')]){_0x372c39[_0x5f7e('0x3e')]=_['merge'](_0x372c39[_0x5f7e('0x3e')],{'$or':_[_0x5f7e('0x29')](_0x372c39[_0x5f7e('0x37')],function(_0x278e63){var _0x372133={};_0x372133[_0x278e63]={'$like':'%'+_0x3a7287[_0x5f7e('0x33')][_0x5f7e('0x7d')]+'%'};return _0x372133;})});}if(_0x3a7287[_0x5f7e('0x33')][_0x5f7e('0x76')]){var _0x3daf74=_0x3a7287[_0x5f7e('0x33')][_0x5f7e('0x76')][_0x5f7e('0x6a')](',');var _0x47b3ab={};_0x47b3ab[_0x3daf74[0x0]]={'$gte':moment(_0x3daf74[0x1])[_0x5f7e('0xbc')](_0x5f7e('0xbd'))};_0x372c39[_0x5f7e('0x3e')]=_[_0x5f7e('0x96')](_0x372c39[_0x5f7e('0x3e')],_0x47b3ab);}_0x372c39=_[_0x5f7e('0x96')]({},_0x372c39,_0x3a7287['options']);return db[_0x5f7e('0xb6')]['count']({'where':_0x372c39[_0x5f7e('0x3e')]})['then'](function(_0x2f1d81){_0x5e5e48[_0x5f7e('0x21')]=_0x2f1d81;if(_0x3a7287[_0x5f7e('0x33')][_0x5f7e('0xae')]){_0x372c39['include']=[{'all':!![]}];}return db['SmsMessage']['findAll'](_0x372c39);})[_0x5f7e('0x25')](function(_0x2d8684){_0x5e5e48['rows']=_0x2d8684;return _0x5e5e48;});}})['then'](respondWithFilteredResult(_0x25a658,_0x372c39))[_0x5f7e('0x2e')](handleError(_0x25a658,null));};exports['addTags']=function(_0xf2e506,_0x49b240,_0x108a96){return db['SmsInteraction'][_0x5f7e('0x5c')]({'where':{'id':_0xf2e506[_0x5f7e('0xb2')]['id']}})[_0x5f7e('0x25')](handleEntityNotFound(_0x49b240,null))[_0x5f7e('0x25')](function(_0x26f219){if(_0x26f219){return _0x26f219[_0x5f7e('0xbe')](_0xf2e506[_0x5f7e('0x6f')][_0x5f7e('0xb7')],_[_0x5f7e('0xb8')](_0xf2e506[_0x5f7e('0x6f')],['ids','id'])||{})[_0x5f7e('0xbf')](function(){return db[_0x5f7e('0x69')]['findAll']({'attributes':['id',_0x5f7e('0x27'),_0x5f7e('0xc0')],'where':{'id':_0xf2e506[_0x5f7e('0x6f')][_0x5f7e('0xb7')]}});})[_0x5f7e('0x25')](function(_0x50cae1){socket[_0x5f7e('0xc1')](_0x5f7e('0xc2'),{'id':Number(_0xf2e506[_0x5f7e('0xb2')]['id']),'tags':_0x50cae1||[]});return{'id':Number(_0xf2e506[_0x5f7e('0xb2')]['id']),'tags':_0x50cae1||[]};});}})[_0x5f7e('0x25')](respondWithResult(_0x49b240,null))['catch'](handleError(_0x49b240,null));};exports[_0x5f7e('0xc3')]=function(_0x2ad175,_0x42a8a4,_0x489de8){return db[_0x5f7e('0x97')][_0x5f7e('0x5c')]({'where':{'id':_0x2ad175[_0x5f7e('0xb2')]['id']}})[_0x5f7e('0x25')](handleEntityNotFound(_0x42a8a4,null))['then'](function(_0x173739){if(_0x173739){return _0x173739[_0x5f7e('0xc3')](_0x2ad175[_0x5f7e('0x33')][_0x5f7e('0xb7')]);}})['then'](respondWithStatusCode(_0x42a8a4,null))['catch'](handleError(_0x42a8a4,null));};exports[_0x5f7e('0xc4')]=function(_0xce5b56,_0x407f7f){var _0x574a2a=moment()[_0x5f7e('0xc5')]()['toString']();var _0x332952=path[_0x5f7e('0xc6')](config[_0x5f7e('0xc7')],_0x5f7e('0xc8'),'files','tmp');var _0x2e8c83=path[_0x5f7e('0xc6')](config[_0x5f7e('0xc7')],'server','files',_0x5f7e('0xc9'));var _0x24c037=path[_0x5f7e('0xc6')](_0x332952,_0x574a2a);var _0x410eed=util[_0x5f7e('0xbc')](_0x5f7e('0xca'),_0xce5b56['params']['id'],_0x574a2a);var _0x1161c1=path['join'](_0x332952,_0x410eed);var _0x2141c0=[];_0x2141c0[_0x5f7e('0x2d')]({'model':db[_0x5f7e('0x6c')],'as':_0x5f7e('0x6c'),'attributes':['id',_0x5f7e('0xcb')],'raw':!![]});_0x2141c0[_0x5f7e('0x2d')]({'model':db[_0x5f7e('0xcc')],'as':_0x5f7e('0xcd'),'attributes':['id',_0x5f7e('0xce'),_0x5f7e('0xcf')],'raw':!![]});var _0x541ba3=[{'model':db[_0x5f7e('0xb6')],'as':'Messages','attributes':['id',_0x5f7e('0x6f'),_0x5f7e('0xd0'),'direction',_0x5f7e('0xd1'),'read'],'include':_0x2141c0}];_0x541ba3['push']({'model':db[_0x5f7e('0xd2')],'as':_0x5f7e('0xd3'),'attributes':['id',_0x5f7e('0x27')]});_0x541ba3[_0x5f7e('0x2d')]({'model':db['User'],'as':_0x5f7e('0xd4'),'attributes':['id','fullname']});return db[_0x5f7e('0x97')][_0x5f7e('0x5c')]({'where':{'id':_0xce5b56[_0x5f7e('0xb2')]['id']},'include':_0x541ba3})[_0x5f7e('0x25')](handleEntityNotFound(_0x407f7f,null))[_0x5f7e('0x25')](function(_0x271377){if(_0x271377){var _0x4bf0c9=_0x271377[_0x5f7e('0xd5')]({'plain':!![]});fs[_0x5f7e('0xd6')](_0x24c037);var _0x2f0bf2={'channel':_0x5f7e('0xd7'),'account':_0x4bf0c9[_0x5f7e('0xd3')][_0x5f7e('0x27')],'agent':_0x4bf0c9[_0x5f7e('0xd4')]?_0x4bf0c9[_0x5f7e('0xd4')]['fullname']:_0x5f7e('0xd8'),'createdAt':moment(_0x4bf0c9[_0x5f7e('0xd0')])[_0x5f7e('0xbc')](_0x5f7e('0xbd'))[_0x5f7e('0x94')](),'closedAt':_0x4bf0c9[_0x5f7e('0xd9')]?moment(_0x4bf0c9[_0x5f7e('0xda')])[_0x5f7e('0xbc')]('YYYY-MM-DD\x20HH:mm:ss')[_0x5f7e('0x94')]():'','disposition':_0x4bf0c9[_0x5f7e('0xdb')],'messages':_(_0x4bf0c9[_0x5f7e('0xdc')])[_0x5f7e('0x7d')]({'secret':![]})['map'](function(_0x5da792){return{'date':moment(_0x5da792[_0x5f7e('0xd0')])['format'](_0x5f7e('0xbd'))[_0x5f7e('0x94')](),'sender':_0x5da792['direction']===_0x5f7e('0xdd')?_0x5da792[_0x5f7e('0x6c')]?_0x5da792[_0x5f7e('0x6c')][_0x5f7e('0xcb')]:_0x5f7e('0xde'):_0x5da792['Contact']['firstName']+(_0x5da792['Contact']['lastName']?'\x20'+_0x5da792[_0x5f7e('0xcd')][_0x5f7e('0xcf')]:''),'body':_0x5da792['body'],'direction':_0x5da792[_0x5f7e('0xdf')]===_0x5f7e('0xdd')?'A':'C','secret':_0x5da792[_0x5f7e('0xd1')],'read':_0x5da792[_0x5f7e('0x7a')]};})[_0x5f7e('0x5e')]()};return ejs[_0x5f7e('0xe0')](path['join'](config[_0x5f7e('0xc7')],'server','views',_0x5f7e('0xe1')),{'interaction':_0x2f0bf2})[_0x5f7e('0x25')](function(_0x450ee7){var _0x4f419d=path['join'](_0x24c037,'transcript-'+_0x4bf0c9['id']+'-'+_0x574a2a+'.pdf');var _0x164e51={'path':_0x4f419d,'channel':'Sms','interactionId':_0x4bf0c9['id']};return pdf[_0x5f7e('0xe2')](_0x450ee7,_0x164e51);})[_0x5f7e('0x25')](function(){return new BPromise(function(_0x57b962,_0x20a2d5){zipdir(_0x24c037,{'saveTo':_0x1161c1},function(_0x4fde4b,_0x48c905){if(_0x4fde4b)return _0x20a2d5(_0x4fde4b);return _0x57b962(_0x48c905);});})[_0x5f7e('0x25')](function(){return new BPromise(function(_0x2e62ec,_0x481019){rimraf(_0x24c037,function(_0x5700b9){if(_0x5700b9)_0x481019(_0x5700b9);return _0x2e62ec();});});})[_0x5f7e('0x25')](function(){return _0x407f7f[_0x5f7e('0xc4')](_0x1161c1,_0x410eed,function(_0x2532a2){if(_0x2532a2){console[_0x5f7e('0xe3')](_0x5f7e('0xe4'),_0x2532a2);}else{fs[_0x5f7e('0xe5')](_0x1161c1);}});});});}else{return _0x407f7f['sendStatus'](0xc8);}})['catch'](handleError(_0x407f7f,null));};
\ No newline at end of file