Built motion from commit (unavailable).|2.5.21
[motion2.git] / server / api / smsInteraction / smsInteraction.controller.js
index 0431ffc..a35cbb2 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x6e44=['keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','offset','order','sort','where','pick','filters','field','from','select','u.id','u.fullname','ui.SmsInteractionId','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','a.id\x20=\x20i.SmsAccountId','sms_messages','me.SmsInteractionId\x20=\x20i.id','sms_interaction_has_tags','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','find','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','Contact','operator','$substring','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','text','start','union','User','UserId','buildExpression','body','some','compact','isEmpty','SmsAccountId','i.SmsAccountId\x20IN\x20?','createdAt','parse','$gte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','\x20=\x20?','read','tag','isArray','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','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','SELECT','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','contactName','DESC','t.id\x20IN\x20?','resolve','journey','i.SmsAccountId\x20IS\x20NOT\x20NULL','user','getSmsAccounts','i.SmsAccountId\x20IS\x20NULL','role','agent','toString','sequelize','keyBy','merge','Account.key','Account.mandatoryDisposition','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','c.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','ui.SmsInteractionId\x20IN\x20?','all','rows','show','params','rawAttributes','include','options','create','describe','addMessage','SmsMessage','omit','ids','findOne','SmsInteractionId','count','includeAll','findAll','setTags','spread','color','emit','smsInteractionTags:save','removeTags','unix','join','root','server','files','tmp','attachments','transcript-%d-%s.zip','CmContact','firstName','lastName','Messages','direction','secret','SmsAccount','Owner','get','mkdirSync','10px','<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>','30px','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>','%s\x20#%d','Sms','YYYY-MM-DD','Account','N.A.','YYYY-MM-DD\x20HH:mm:ss','closedAt','disposition','out','System','renderFile','downloadInteraction.html','.pdf','download','err','unlinkSync','eml-format','rimraf','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','crypto','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/license/util','redis','defaults','localhost','socket.io-emitter','./smsInteraction.socket','sendStatus','status','end','set','Content-Range','json','reject','save','update','destroy','then','stack','name','send','Users','map','fullname','TagIds','split','forEach','push','catch','index','SmsInteraction','fieldName','type','key','model','query'];(function(_0x1e74c6,_0x56a205){var _0x495599=function(_0x341c03){while(--_0x341c03){_0x1e74c6['push'](_0x1e74c6['shift']());}};_0x495599(++_0x56a205);}(_0x6e44,0xb1));var _0x46e4=function(_0x27a45d,_0x14499a){_0x27a45d=_0x27a45d-0x0;var _0x5aee32=_0x6e44[_0x27a45d];return _0x5aee32;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x46e4('0x0'));var rimraf=require(_0x46e4('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x46e4('0x2'));var moment=require(_0x46e4('0x3'));var BPromise=require(_0x46e4('0x4'));var Mustache=require(_0x46e4('0x5'));var util=require('util');var path=require(_0x46e4('0x6'));var sox=require(_0x46e4('0x7'));var csv=require(_0x46e4('0x8'));var ejs=require(_0x46e4('0x9'));var fs=require('fs');var _=require(_0x46e4('0xa'));var squel=require('squel');var crypto=require(_0x46e4('0xb'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x46e4('0x8'));var querystring=require(_0x46e4('0xc'));var Papa=require(_0x46e4('0xd'));var Redis=require(_0x46e4('0xe'));var authService=require(_0x46e4('0xf'));var qs=require(_0x46e4('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x46e4('0x11'))(_0x46e4('0x12'));var utils=require('../../config/utils');var config=require(_0x46e4('0x13'));var licenseUtil=require(_0x46e4('0x14'));var db=require('../../mysqldb')['db'];config[_0x46e4('0x15')]=_[_0x46e4('0x16')](config[_0x46e4('0x15')],{'host':_0x46e4('0x17'),'port':0x18eb});var socket=require(_0x46e4('0x18'))(new Redis(config[_0x46e4('0x15')]));require(_0x46e4('0x19'))['register'](socket);function respondWithStatusCode(_0x19eb91,_0x537188){_0x537188=_0x537188||0xcc;return function(_0x108352){if(_0x108352){return _0x19eb91[_0x46e4('0x1a')](_0x537188);}return _0x19eb91[_0x46e4('0x1b')](_0x537188)[_0x46e4('0x1c')]();};}function respondWithResult(_0x4f93cb,_0x22a738){_0x22a738=_0x22a738||0xc8;return function(_0x1c8358){if(_0x1c8358){return _0x4f93cb[_0x46e4('0x1b')](_0x22a738)['json'](_0x1c8358);}};}function respondWithFilteredResult(_0xddbb47,_0x3aa746){return function(_0x3ff6f6){if(_0x3ff6f6){var _0x57dbaa=_0x3ff6f6['count'],_0x5314ad=_0x3aa746['offset'],_0x1fdd62=_0x3aa746['offset']+_0x3aa746['limit'],_0x1ab677;if(_0x1fdd62>=_0x57dbaa){_0x1fdd62=_0x57dbaa;_0x1ab677=0xc8;}else{_0x1ab677=0xce;}_0xddbb47['status'](_0x1ab677);return _0xddbb47[_0x46e4('0x1d')](_0x46e4('0x1e'),_0x5314ad+'-'+_0x1fdd62+'/'+_0x57dbaa)[_0x46e4('0x1f')](_0x3ff6f6);}return null;};}function patchUpdates(_0x3eb5e8){return function(_0x1875f8){try{jsonpatch['apply'](_0x1875f8,_0x3eb5e8,!![]);}catch(_0x3f1b8e){return BPromise[_0x46e4('0x20')](_0x3f1b8e);}return _0x1875f8[_0x46e4('0x21')]();};}function saveUpdates(_0x1d9111,_0x93927d){return function(_0x1bc7a0){if(_0x1bc7a0){return _0x1bc7a0[_0x46e4('0x22')](_0x1d9111)['then'](function(_0x2b499e){return _0x2b499e;});}return null;};}function removeEntity(_0x41c679,_0x18130c){return function(_0x488368){if(_0x488368){return _0x488368[_0x46e4('0x23')]()[_0x46e4('0x24')](function(){_0x41c679[_0x46e4('0x1b')](0xcc)[_0x46e4('0x1c')]();});}};}function handleEntityNotFound(_0x836856,_0x5ef318){return function(_0x38d1f1){if(!_0x38d1f1){_0x836856[_0x46e4('0x1a')](0x194);}return _0x38d1f1;};}function handleError(_0x40b1ea,_0x2b19a9){_0x2b19a9=_0x2b19a9||0x1f4;return function(_0x5c512b){logger['error'](_0x5c512b[_0x46e4('0x25')]);if(_0x5c512b[_0x46e4('0x26')]){delete _0x5c512b[_0x46e4('0x26')];}_0x40b1ea[_0x46e4('0x1b')](_0x2b19a9)[_0x46e4('0x27')](_0x5c512b);};}function getInteractionUsers(_0x30a68b,_0x2b2fc6){return new BPromise(function(_0xeb456b,_0x43c6d5){try{if(_0x2b2fc6[_0x30a68b['id']]){_0x30a68b[_0x46e4('0x28')]=_[_0x46e4('0x29')](_0x2b2fc6[_0x30a68b['id']],function(_0x351229){return{'id':_0x351229['id'],'fullname':_0x351229[_0x46e4('0x2a')]};});}}catch(_0x3262f3){_0x43c6d5(_0x3262f3);}_0xeb456b(_0x30a68b);});}function getInteractionTags(_0x36efa5,_0x3d3d00){return new BPromise(function(_0x4d1660,_0x130fa4){try{if(_0x36efa5[_0x46e4('0x2b')]){_0x36efa5['Tags']=[];_0x36efa5[_0x46e4('0x2b')][_0x46e4('0x2c')](',')[_0x46e4('0x2d')](function(_0x4f77d5){_0x36efa5['Tags'][_0x46e4('0x2e')](_0x3d3d00[_0x4f77d5]);});}delete _0x36efa5[_0x46e4('0x2b')];}catch(_0x4e11c4){_0x130fa4(_0x4e11c4);}_0x4d1660(_0x36efa5);});}function updateSmsInteraction(_0x1ba37a,_0x316b20,_0x37b402){return new BPromise(function(_0x19151f,_0x2e5982){return getInteractionUsers(_0x1ba37a,_0x37b402)[_0x46e4('0x24')](function(_0x2effe2){return getInteractionTags(_0x2effe2,_0x316b20);})[_0x46e4('0x24')](function(_0xf6417b){_0x19151f(_0xf6417b);})[_0x46e4('0x2f')](function(_0x5da396){_0x2e5982(_0x5da396);});});}exports[_0x46e4('0x30')]=function(_0x3c011f,_0x188b1f){var _0x3be540={},_0x5770d0={},_0x23bdc0={'count':0x0,'rows':[]};var _0x3605df=_[_0x46e4('0x29')](db[_0x46e4('0x31')]['rawAttributes'],function(_0x1f752b){return{'name':_0x1f752b[_0x46e4('0x32')],'type':_0x1f752b[_0x46e4('0x33')][_0x46e4('0x34')]};});_0x5770d0[_0x46e4('0x35')]=_[_0x46e4('0x29')](_0x3605df,_0x46e4('0x26'));_0x5770d0[_0x46e4('0x36')]=_[_0x46e4('0x37')](_0x3c011f[_0x46e4('0x36')]);_0x5770d0['filters']=_[_0x46e4('0x38')](_0x5770d0[_0x46e4('0x35')],_0x5770d0[_0x46e4('0x36')]);_0x3be540[_0x46e4('0x39')]=_[_0x46e4('0x38')](_0x5770d0['model'],qs['fields'](_0x3c011f[_0x46e4('0x36')][_0x46e4('0x3a')]));_0x3be540[_0x46e4('0x39')]=_0x3be540[_0x46e4('0x39')][_0x46e4('0x3b')]?_0x3be540[_0x46e4('0x39')]:_0x5770d0[_0x46e4('0x35')];if(!_0x3c011f[_0x46e4('0x36')][_0x46e4('0x3c')](_0x46e4('0x3d'))){_0x3be540[_0x46e4('0x3e')]=qs[_0x46e4('0x3e')](_0x3c011f[_0x46e4('0x36')][_0x46e4('0x3e')]);_0x3be540[_0x46e4('0x3f')]=qs['offset'](_0x3c011f[_0x46e4('0x36')]['offset']);}_0x3be540[_0x46e4('0x40')]=qs[_0x46e4('0x41')](_0x3c011f['query'][_0x46e4('0x41')]);_0x3be540[_0x46e4('0x42')]=qs['filters'](_[_0x46e4('0x43')](_0x3c011f[_0x46e4('0x36')],_0x5770d0[_0x46e4('0x44')]),_0x3605df);var _0x57ac00=[];var _0x1e901b=squel['select']()['field']('id')[_0x46e4('0x45')](_0x46e4('0x26'))[_0x46e4('0x45')]('color')[_0x46e4('0x46')]('tools_tags');var _0xc7f7ee=squel[_0x46e4('0x47')]()[_0x46e4('0x45')](_0x46e4('0x48'))[_0x46e4('0x45')](_0x46e4('0x49'))[_0x46e4('0x45')](_0x46e4('0x4a'))[_0x46e4('0x46')]('user_has_sms_interactions','ui')[_0x46e4('0x4b')](_0x46e4('0x4c'),'u',_0x46e4('0x4d'));var _0x21734f=squel[_0x46e4('0x47')]()['from'](_0x46e4('0x4e'),'i')[_0x46e4('0x4b')](_0x46e4('0x4f'),'c',_0x46e4('0x50'))[_0x46e4('0x4b')](_0x46e4('0x4c'),'o',_0x46e4('0x51'))[_0x46e4('0x4b')]('sms_accounts','a',_0x46e4('0x52'))[_0x46e4('0x4b')](_0x46e4('0x53'),'me',_0x46e4('0x54'))[_0x46e4('0x4b')](_0x46e4('0x55'),'it','it.SmsInteractionId\x20=\x20i.id')['left_join']('tools_tags','t',_0x46e4('0x56'));var _0x4289bc=squel[_0x46e4('0x57')]();var _0x25c295=[];var _0x5ba7c6=squel['expr']();var _0x276ea5;if(_0x3c011f[_0x46e4('0x36')][_0x46e4('0x58')]){_0x276ea5=as[_0x46e4('0x59')](_0x3c011f[_0x46e4('0x36')]['search']);var _0x5e62b0=_0x276ea5[_0x46e4('0x5a')];for(var _0x391289=0x0;_0x391289<_0x276ea5[_0x46e4('0x5b')][_0x46e4('0x3b')];_0x391289++){var _0x2c4e55=_0x276ea5['conditions'][_0x391289];var _0x167cd6='i';var _0x2a17b3=_[_0x46e4('0x5c')](_0x3605df,[_0x46e4('0x26'),_0x2c4e55[_0x46e4('0x45')]]);if(!_0x2a17b3){switch(_0x2c4e55['field']){case _0x46e4('0x5d'):if(_0x2c4e55[_0x46e4('0x5e')]==0x1){_0x21734f[_0x46e4('0x5f')]('`'+_0x2c4e55[_0x46e4('0x45')]+_0x46e4('0x60'));}else{_0x21734f[_0x46e4('0x5f')]('`'+_0x2c4e55[_0x46e4('0x45')]+_0x46e4('0x61'));}break;case _0x46e4('0x62'):if(_0x2c4e55[_0x46e4('0x63')]===_0x46e4('0x64')){if(_0x2c4e55['value'][_0x46e4('0x2c')]('\x20')[_0x46e4('0x3b')]>0x1){_0x4289bc[_0x5e62b0]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x2c4e55[_0x46e4('0x5e')]),null);}else{var _0xc89c9d='%'+_0x2c4e55[_0x46e4('0x5e')]+'%';_0x4289bc[_0x5e62b0](_0x46e4('0x65'),_0xc89c9d,_0xc89c9d,_0xc89c9d);}}else{_0x2a17b3=_[_0x46e4('0x5c')](_0x3605df,[_0x46e4('0x26'),_0x46e4('0x66')]);_0x2c4e55[_0x46e4('0x45')]=_0x46e4('0x66');_0x1dc157=as['buildExpression'](_0x167cd6,_0x2a17b3['type'],_0x2c4e55);_0x4289bc[_0x5e62b0](_0x1dc157[_0x46e4('0x67')],_0x1dc157[_0x46e4('0x5e')][_0x46e4('0x68')],_0x1dc157['value']['end']);}break;case'Tag':var _0x856338=_0x2c4e55[_0x46e4('0x5e')][_0x46e4('0x2c')](',')[_0x46e4('0x29')](function(_0x1949a3){return Number(_0x1949a3);});_0x856338[_0x46e4('0x2d')](function(_0x5c1587){_0x5ba7c6['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x5c1587+',%');});_0x25c295=_[_0x46e4('0x69')](_0x25c295,_0x856338);break;case _0x46e4('0x6a'):if(_0x2c4e55[_0x46e4('0x63')]==='$substring'){_0x4289bc[_0x5e62b0]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x2c4e55['value']+'%',null);}else{_0x2a17b3=_['find'](_0x3605df,[_0x46e4('0x26'),_0x46e4('0x6b')]);_0x2c4e55[_0x46e4('0x45')]=_0x46e4('0x6b');_0x1dc157=as[_0x46e4('0x6c')](_0x167cd6,_0x2a17b3['type'],_0x2c4e55);_0x4289bc[_0x5e62b0](_0x1dc157[_0x46e4('0x67')],_0x1dc157['value'][_0x46e4('0x68')],_0x1dc157[_0x46e4('0x5e')][_0x46e4('0x1c')]);}break;case _0x46e4('0x6d'):_0x1dc157=as['buildExpression']('me',null,_0x2c4e55);_0x4289bc[_0x5e62b0](_0x1dc157[_0x46e4('0x67')],_0x1dc157['value'][_0x46e4('0x68')],_0x1dc157[_0x46e4('0x5e')][_0x46e4('0x1c')]);break;}}else{var _0x1dc157=as[_0x46e4('0x6c')](_0x167cd6,_0x2a17b3['type'],_0x2c4e55);_0x4289bc[_0x5e62b0](_0x1dc157['text'],_0x1dc157[_0x46e4('0x5e')][_0x46e4('0x68')],_0x1dc157[_0x46e4('0x5e')]['end']);}}}else{var _0xf1fa2a=_(_0x3c011f['query'])[_0x46e4('0x37')]()[_0x46e4('0x29')](function(_0x36d08f){return _[_0x46e4('0x6e')](_0x3605df,[_0x46e4('0x26'),_0x36d08f])?_0x36d08f:undefined;})[_0x46e4('0x6f')]()[_0x46e4('0x5e')]();if(!_[_0x46e4('0x70')](_0xf1fa2a)){_0xf1fa2a['forEach'](function(_0xcb4303){if(_0xcb4303===_0x46e4('0x71')){_0x21734f[_0x46e4('0x42')](_0x46e4('0x72'),[]['concat'](_0x3c011f[_0x46e4('0x36')][_0xcb4303]));}else if(_0xcb4303===_0x46e4('0x73')){var _0xc7e3df=JSON[_0x46e4('0x74')](_0x3c011f[_0x46e4('0x36')][_0xcb4303])[_0x46e4('0x75')];var _0x35417e=JSON[_0x46e4('0x74')](_0x3c011f['query'][_0xcb4303])['$lte'];_0x21734f[_0x46e4('0x42')](_0x46e4('0x76'),_0xc7e3df,_0x35417e);}else{if(_0x3c011f[_0x46e4('0x36')][_0xcb4303]==='null'){_0x21734f[_0x46e4('0x42')]('i.'+_0xcb4303+_0x46e4('0x77'));}else{_0x21734f['where']('i.'+_0xcb4303+_0x46e4('0x78'),_0x3c011f[_0x46e4('0x36')][_0xcb4303]);}}});}if(_0x3c011f[_0x46e4('0x36')]['read']){if(_0x3c011f['query'][_0x46e4('0x79')]==0x1){_0x21734f[_0x46e4('0x5f')]('`unreadMessages`\x20=\x200');}else{_0x21734f[_0x46e4('0x5f')]('`unreadMessages`\x20>\x200');}}if(_0x3c011f[_0x46e4('0x36')][_0x46e4('0x7a')]){_0x25c295=_[_0x46e4('0x7b')](_0x3c011f[_0x46e4('0x36')][_0x46e4('0x7a')])?_0x3c011f['query']['tag']:new Array(_0x3c011f['query']['tag']);_0x25c295[_0x46e4('0x2d')](function(_0x1e9360){_0x5ba7c6['or'](_0x46e4('0x7c'),'%,'+_0x1e9360+',%');});}if(_0x3c011f[_0x46e4('0x36')][_0x46e4('0x7d')]){var _0x9dc470=_0x3c011f[_0x46e4('0x36')][_0x46e4('0x7d')][_0x46e4('0x7e')]('\x5c','\x5c\x5c')[_0x46e4('0x7e')](/'/g,'\x27\x27');if(qs[_0x46e4('0x7f')](_0x9dc470)){_0x4289bc['or'](_0x46e4('0x80'),_0x9dc470+'%')['or'](_0x46e4('0x81'),_0x9dc470+'%');}else{_0x4289bc['or'](_0x46e4('0x82'),qs[_0x46e4('0x83')](_0x9dc470))['or'](_0x46e4('0x84'),_0x9dc470+'%');}}}_0x21734f[_0x46e4('0x42')](_0x4289bc);_0x21734f['group'](_0x46e4('0x85'));var _0x1f3510={'type':db[_0x46e4('0x86')]['QueryTypes'][_0x46e4('0x87')],'raw':!![]};var _0x5c9508=_0x21734f[_0x46e4('0x88')]();_0x5c9508[_0x46e4('0x45')]('i.id');_0x5c9508[_0x46e4('0x45')](_0x46e4('0x89'),_0x46e4('0x5d'));if(_0x3be540[_0x46e4('0x40')]){_0x3be540['order']['forEach'](function(_0x3978ba){var _0x576299=_0x3978ba[0x0]===_0x46e4('0x8a')?_0x3978ba[0x0]:'i.'+_0x3978ba[0x0];_0x21734f[_0x46e4('0x40')](_0x576299,_0x3978ba[0x1]===_0x46e4('0x8b')?![]:!![]);});}if(!_[_0x46e4('0x70')](_0x25c295)){_0x21734f['having'](_0x5ba7c6);_0x5c9508[_0x46e4('0x42')](_0x46e4('0x8c'),_0x25c295);}BPromise[_0x46e4('0x8d')]()[_0x46e4('0x24')](function(){if(!_0x276ea5){if(_0x3c011f['query']['SmsAccountId']||_0x3c011f['query'][_0x46e4('0x8e')])return;_0x5c9508[_0x46e4('0x42')]('i.SmsAccountId\x20IS\x20NOT\x20NULL');_0x21734f[_0x46e4('0x42')](_0x46e4('0x8f'));return;}if(_0x3c011f[_0x46e4('0x90')]['role']!=='agent')return;return _0x3c011f[_0x46e4('0x90')][_0x46e4('0x91')]({'attributes':['id'],'raw':!![]})[_0x46e4('0x24')](function(_0x35a5f5){if(_[_0x46e4('0x70')](_0x35a5f5)){_0x5c9508[_0x46e4('0x42')](_0x46e4('0x92'));_0x21734f['where'](_0x46e4('0x92'));}else{_0x5c9508[_0x46e4('0x42')](_0x46e4('0x72'),_[_0x46e4('0x29')](_0x35a5f5,'id'));_0x21734f['where']('i.SmsAccountId\x20IN\x20?',_[_0x46e4('0x29')](_0x35a5f5,'id'));}});})['then'](function(){if(_0x3c011f[_0x46e4('0x90')][_0x46e4('0x93')]===_0x46e4('0x94')&&!_0x276ea5&&!_0x3c011f['query'][_0x46e4('0x71')])return[];return db['sequelize'][_0x46e4('0x36')](_0x5c9508[_0x46e4('0x95')](),_0x1f3510);})[_0x46e4('0x24')](function(_0x128d35){_0x23bdc0['count']=_0x128d35['length'];if(_0x23bdc0['count']===0x0)return[];return db[_0x46e4('0x96')]['query'](_0x1e901b[_0x46e4('0x95')](),_0x1f3510)[_0x46e4('0x24')](function(_0x1f0635){_0x57ac00=_[_0x46e4('0x97')](_0x1f0635,'id');_0x1f3510=_[_0x46e4('0x98')](_0x1f3510,{'model':db[_0x46e4('0x31')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x3c011f[_0x46e4('0x36')][_0x46e4('0x3a')]){_0x3be540[_0x46e4('0x39')][_0x46e4('0x2d')](function(_0x5ed83f){_0x21734f[_0x46e4('0x45')]('i.'+_0x5ed83f);});}else{_0x21734f[_0x46e4('0x45')](_0x46e4('0x89'),'unreadMessages');_0x21734f[_0x46e4('0x45')]('a.key',_0x46e4('0x99'));_0x21734f[_0x46e4('0x45')]('a.mandatoryDisposition',_0x46e4('0x9a'));_0x21734f['field']('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',_0x46e4('0x8a'));_0x21734f['field']('i.*');_0x21734f[_0x46e4('0x45')](_0x46e4('0x9b'),_0x46e4('0x9c'));_0x21734f[_0x46e4('0x45')](_0x46e4('0x9d'),_0x46e4('0x9e'));_0x21734f[_0x46e4('0x45')](_0x46e4('0x9f'),_0x46e4('0xa0'));_0x21734f[_0x46e4('0x45')](_0x46e4('0xa1'),'Contact.phone');_0x21734f[_0x46e4('0x45')](_0x46e4('0xa2'),'Contact.mobile');_0x21734f['field'](_0x46e4('0xa3'),_0x46e4('0xa4'));_0x21734f[_0x46e4('0x45')](_0x46e4('0xa5'),_0x46e4('0xa6'));_0x21734f[_0x46e4('0x45')](_0x46e4('0xa7'),'Owner.internal');_0x21734f[_0x46e4('0x45')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0x46e4('0x2b'));}if(_0x3be540[_0x46e4('0x3e')])_0x21734f[_0x46e4('0x3e')](_0x3be540['limit']);if(_0x3be540[_0x46e4('0x3f')])_0x21734f[_0x46e4('0x3f')](_0x3be540[_0x46e4('0x3f')]);return db[_0x46e4('0x96')][_0x46e4('0x36')](_0x21734f['toString'](),_0x1f3510);})['then'](function(_0x479c00){_0xc7f7ee[_0x46e4('0x42')](_0x46e4('0xa8'),_['map'](_0x479c00,'id'));return db['sequelize'][_0x46e4('0x36')](_0xc7f7ee[_0x46e4('0x95')](),_0x1f3510)[_0x46e4('0x24')](function(_0x1c5a9a){var _0x28c070=_['groupBy'](_0x1c5a9a,'SmsInteractionId');var _0x5a1829=[];_0x479c00['forEach'](function(_0xa6595a){_0x5a1829[_0x46e4('0x2e')](updateSmsInteraction(_0xa6595a,_0x57ac00,_0x28c070));});return BPromise[_0x46e4('0xa9')](_0x5a1829);});});})[_0x46e4('0x24')](function(_0x4e3f21){_0x23bdc0[_0x46e4('0xaa')]=_0x4e3f21;return _0x23bdc0;})[_0x46e4('0x24')](respondWithFilteredResult(_0x188b1f,_0x3be540))[_0x46e4('0x2f')](handleError(_0x188b1f,null));};exports[_0x46e4('0xab')]=function(_0x46c4b6,_0x31e7ce){var _0x59d75d={'raw':![],'where':{'id':_0x46c4b6[_0x46e4('0xac')]['id']}},_0x199650={};_0x199650['model']=_[_0x46e4('0x37')](db['SmsInteraction'][_0x46e4('0xad')]);_0x199650[_0x46e4('0x36')]=_[_0x46e4('0x37')](_0x46c4b6[_0x46e4('0x36')]);_0x199650[_0x46e4('0x44')]=_[_0x46e4('0x38')](_0x199650[_0x46e4('0x35')],_0x199650['query']);_0x59d75d[_0x46e4('0x39')]=_[_0x46e4('0x38')](_0x199650[_0x46e4('0x35')],qs[_0x46e4('0x3a')](_0x46c4b6[_0x46e4('0x36')]['fields']));_0x59d75d[_0x46e4('0x39')]=_0x59d75d['attributes'][_0x46e4('0x3b')]?_0x59d75d[_0x46e4('0x39')]:_0x199650[_0x46e4('0x35')];if(_0x46c4b6['query']['includeAll']){_0x59d75d[_0x46e4('0xae')]=[{'all':!![]}];}_0x59d75d=_[_0x46e4('0x98')]({},_0x59d75d,_0x46c4b6[_0x46e4('0xaf')]);return db[_0x46e4('0x31')][_0x46e4('0x5c')](_0x59d75d)['then'](handleEntityNotFound(_0x31e7ce,null))[_0x46e4('0x24')](respondWithResult(_0x31e7ce,null))[_0x46e4('0x2f')](handleError(_0x31e7ce,null));};exports[_0x46e4('0xb0')]=function(_0x57a940,_0x507759){return db[_0x46e4('0x31')][_0x46e4('0xb0')](_0x57a940[_0x46e4('0x6d')],{})[_0x46e4('0x24')](respondWithResult(_0x507759,0xc9))[_0x46e4('0x2f')](handleError(_0x507759,null));};exports[_0x46e4('0x22')]=function(_0x523b68,_0x428f80){if(_0x523b68[_0x46e4('0x6d')]['id']){delete _0x523b68[_0x46e4('0x6d')]['id'];}return db[_0x46e4('0x31')][_0x46e4('0x5c')]({'where':{'id':_0x523b68[_0x46e4('0xac')]['id']}})[_0x46e4('0x24')](handleEntityNotFound(_0x428f80,null))[_0x46e4('0x24')](saveUpdates(_0x523b68[_0x46e4('0x6d')],null))[_0x46e4('0x24')](respondWithResult(_0x428f80,null))[_0x46e4('0x2f')](handleError(_0x428f80,null));};exports[_0x46e4('0x23')]=function(_0x48259b,_0x5f5983){return db['SmsInteraction']['find']({'where':{'id':_0x48259b['params']['id']}})[_0x46e4('0x24')](handleEntityNotFound(_0x5f5983,null))[_0x46e4('0x24')](removeEntity(_0x5f5983,null))['catch'](handleError(_0x5f5983,null));};exports[_0x46e4('0xb1')]=function(_0x20fe78,_0x192b52){return db['SmsInteraction']['describe']()[_0x46e4('0x24')](respondWithResult(_0x192b52,null))['catch'](handleError(_0x192b52,null));};exports[_0x46e4('0xb2')]=function(_0x150049,_0x6422af,_0x16e586){return db[_0x46e4('0xb3')][_0x46e4('0x5c')]({'where':{'id':_0x150049['params']['id']}})[_0x46e4('0x24')](handleEntityNotFound(_0x6422af,null))[_0x46e4('0x24')](function(_0x464415){if(_0x464415){return _0x464415[_0x46e4('0xb2')](_0x150049[_0x46e4('0x6d')]['ids'],_[_0x46e4('0xb4')](_0x150049[_0x46e4('0x6d')],[_0x46e4('0xb5'),'id'])||{});}})['then'](respondWithResult(_0x6422af,null))['catch'](handleError(_0x6422af,null));};exports['getMessages']=function(_0x3ef619,_0xc3e4c,_0x4886d2){var _0x50f263={'raw':![],'where':{}};var _0x313304={};var _0x3a0cd1={'count':0x0,'rows':[]};return db[_0x46e4('0x31')][_0x46e4('0xb6')]({'where':{'id':_0x3ef619['params']['id']}})['then'](handleEntityNotFound(_0xc3e4c,null))[_0x46e4('0x24')](function(_0x68aa56){if(_0x68aa56){_0x313304[_0x46e4('0x35')]=_[_0x46e4('0x37')](db['SmsMessage'][_0x46e4('0xad')]);_0x313304['query']=_[_0x46e4('0x37')](_0x3ef619[_0x46e4('0x36')]);_0x313304[_0x46e4('0x44')]=_[_0x46e4('0x38')](_0x313304['model'],_0x313304[_0x46e4('0x36')]);_0x50f263['attributes']=_[_0x46e4('0x38')](_0x313304['model'],qs[_0x46e4('0x3a')](_0x3ef619[_0x46e4('0x36')][_0x46e4('0x3a')]));_0x50f263[_0x46e4('0x39')]=_0x50f263['attributes']['length']?_0x50f263['attributes']:_0x313304[_0x46e4('0x35')];if(!_0x3ef619[_0x46e4('0x36')][_0x46e4('0x3c')](_0x46e4('0x3d'))){_0x50f263[_0x46e4('0x3e')]=qs['limit'](_0x3ef619['query']['limit']);_0x50f263[_0x46e4('0x3f')]=qs['offset'](_0x3ef619['query'][_0x46e4('0x3f')]);}_0x50f263[_0x46e4('0x40')]=qs['sort'](_0x3ef619['query'][_0x46e4('0x41')]);_0x50f263[_0x46e4('0x42')]=qs['filters'](_['pick'](_0x3ef619[_0x46e4('0x36')],_0x313304[_0x46e4('0x44')]));_0x50f263[_0x46e4('0x42')][_0x46e4('0xb7')]=_0x68aa56['id'];if(_0x3ef619[_0x46e4('0x36')][_0x46e4('0x7d')]){_0x50f263[_0x46e4('0x42')]=_[_0x46e4('0x98')](_0x50f263[_0x46e4('0x42')],{'$or':_[_0x46e4('0x29')](_0x50f263['attributes'],function(_0x2e68ff){var _0x3f9fc7={};_0x3f9fc7[_0x2e68ff]={'$like':'%'+_0x3ef619[_0x46e4('0x36')][_0x46e4('0x7d')]+'%'};return _0x3f9fc7;})});}if(_0x3ef619['query']['$gte']){var _0x35c260=_0x3ef619['query'][_0x46e4('0x75')][_0x46e4('0x2c')](',');var _0x4ffe31={};_0x4ffe31[_0x35c260[0x0]]={'$gte':moment(_0x35c260[0x1])['format']('YYYY-MM-DD\x20HH:mm:ss')};_0x50f263[_0x46e4('0x42')]=_[_0x46e4('0x98')](_0x50f263[_0x46e4('0x42')],_0x4ffe31);}_0x50f263=_[_0x46e4('0x98')]({},_0x50f263,_0x3ef619['options']);return db[_0x46e4('0xb3')][_0x46e4('0xb8')]({'where':_0x50f263['where']})[_0x46e4('0x24')](function(_0x11873f){_0x3a0cd1[_0x46e4('0xb8')]=_0x11873f;if(_0x3ef619['query'][_0x46e4('0xb9')]){_0x50f263[_0x46e4('0xae')]=[{'all':!![]}];}return db[_0x46e4('0xb3')][_0x46e4('0xba')](_0x50f263);})[_0x46e4('0x24')](function(_0x39a63b){_0x3a0cd1[_0x46e4('0xaa')]=_0x39a63b;return _0x3a0cd1;});}})[_0x46e4('0x24')](respondWithFilteredResult(_0xc3e4c,_0x50f263))[_0x46e4('0x2f')](handleError(_0xc3e4c,null));};exports['addTags']=function(_0x56eb97,_0x48bf7b,_0x264be3){return db[_0x46e4('0x31')][_0x46e4('0x5c')]({'where':{'id':_0x56eb97['params']['id']}})['then'](handleEntityNotFound(_0x48bf7b,null))[_0x46e4('0x24')](function(_0x34dcec){if(_0x34dcec){return _0x34dcec[_0x46e4('0xbb')](_0x56eb97[_0x46e4('0x6d')]['ids'],_[_0x46e4('0xb4')](_0x56eb97['body'],[_0x46e4('0xb5'),'id'])||{})[_0x46e4('0xbc')](function(){return db['Tag'][_0x46e4('0xba')]({'attributes':['id',_0x46e4('0x26'),_0x46e4('0xbd')],'where':{'id':_0x56eb97['body'][_0x46e4('0xb5')]}});})[_0x46e4('0x24')](function(_0x471dcf){socket[_0x46e4('0xbe')](_0x46e4('0xbf'),{'id':Number(_0x56eb97[_0x46e4('0xac')]['id']),'tags':_0x471dcf||[]});return{'id':Number(_0x56eb97[_0x46e4('0xac')]['id']),'tags':_0x471dcf||[]};});}})[_0x46e4('0x24')](respondWithResult(_0x48bf7b,null))[_0x46e4('0x2f')](handleError(_0x48bf7b,null));};exports['removeTags']=function(_0xa95f0c,_0x65b96e,_0x53a786){return db[_0x46e4('0x31')][_0x46e4('0x5c')]({'where':{'id':_0xa95f0c[_0x46e4('0xac')]['id']}})[_0x46e4('0x24')](handleEntityNotFound(_0x65b96e,null))[_0x46e4('0x24')](function(_0xf9e012){if(_0xf9e012){return _0xf9e012[_0x46e4('0xc0')](_0xa95f0c[_0x46e4('0x36')][_0x46e4('0xb5')]);}})['then'](respondWithStatusCode(_0x65b96e,null))[_0x46e4('0x2f')](handleError(_0x65b96e,null));};exports['download']=function(_0x534522,_0x158901){var _0x54ebab=moment()[_0x46e4('0xc1')]()[_0x46e4('0x95')]();var _0x222378=path[_0x46e4('0xc2')](config[_0x46e4('0xc3')],_0x46e4('0xc4'),_0x46e4('0xc5'),_0x46e4('0xc6'));var _0x1c03d0=path[_0x46e4('0xc2')](config[_0x46e4('0xc3')],_0x46e4('0xc4'),_0x46e4('0xc5'),_0x46e4('0xc7'));var _0x2ad5fa=path[_0x46e4('0xc2')](_0x222378,_0x54ebab);var _0xa1970a=util['format'](_0x46e4('0xc8'),_0x534522[_0x46e4('0xac')]['id'],_0x54ebab);var _0x131c2a=path[_0x46e4('0xc2')](_0x222378,_0xa1970a);var _0x113d46=[];_0x113d46[_0x46e4('0x2e')]({'model':db[_0x46e4('0x6a')],'as':'User','attributes':['id',_0x46e4('0x2a')],'raw':!![]});_0x113d46[_0x46e4('0x2e')]({'model':db[_0x46e4('0xc9')],'as':_0x46e4('0x62'),'attributes':['id',_0x46e4('0xca'),_0x46e4('0xcb')],'raw':!![]});var _0x3f722b=[{'model':db[_0x46e4('0xb3')],'as':_0x46e4('0xcc'),'attributes':['id','body','createdAt',_0x46e4('0xcd'),_0x46e4('0xce'),'read'],'include':_0x113d46}];_0x3f722b[_0x46e4('0x2e')]({'model':db[_0x46e4('0xcf')],'as':'Account','attributes':['id',_0x46e4('0x26')]});_0x3f722b[_0x46e4('0x2e')]({'model':db[_0x46e4('0x6a')],'as':_0x46e4('0xd0'),'attributes':['id',_0x46e4('0x2a')]});return db[_0x46e4('0x31')][_0x46e4('0x5c')]({'where':{'id':_0x534522[_0x46e4('0xac')]['id']},'include':_0x3f722b})[_0x46e4('0x24')](handleEntityNotFound(_0x158901,null))[_0x46e4('0x24')](function(_0x43234a){if(_0x43234a){var _0x177d48=_0x43234a[_0x46e4('0xd1')]({'plain':!![]});fs[_0x46e4('0xd2')](_0x2ad5fa);var _0x2652ff={'format':'A4','border':_0x46e4('0xd3'),'header':{'height':'40px','contents':{'first':_0x46e4('0xd4')}},'footer':{'height':_0x46e4('0xd5'),'contents':{'default':util[_0x46e4('0xd6')](_0x46e4('0xd7'),util[_0x46e4('0xd6')](_0x46e4('0xd8'),_0x46e4('0xd9'),_0x177d48['id']),moment()['format'](_0x46e4('0xda'))[_0x46e4('0x95')]())}}};var _0x49e978={'channel':_0x46e4('0xd9'),'account':_0x177d48[_0x46e4('0xdb')][_0x46e4('0x26')],'agent':_0x177d48[_0x46e4('0xd0')]?_0x177d48['Owner'][_0x46e4('0x2a')]:_0x46e4('0xdc'),'createdAt':moment(_0x177d48[_0x46e4('0x73')])[_0x46e4('0xd6')](_0x46e4('0xdd'))['toString'](),'closedAt':_0x177d48['closed']?moment(_0x177d48[_0x46e4('0xde')])[_0x46e4('0xd6')](_0x46e4('0xdd'))[_0x46e4('0x95')]():'','disposition':_0x177d48[_0x46e4('0xdf')],'messages':_(_0x177d48[_0x46e4('0xcc')])[_0x46e4('0x7d')]({'secret':![]})[_0x46e4('0x29')](function(_0x3847cf){return{'date':moment(_0x3847cf[_0x46e4('0x73')])[_0x46e4('0xd6')](_0x46e4('0xdd'))[_0x46e4('0x95')](),'sender':_0x3847cf[_0x46e4('0xcd')]===_0x46e4('0xe0')?_0x3847cf[_0x46e4('0x6a')]?_0x3847cf[_0x46e4('0x6a')][_0x46e4('0x2a')]:_0x46e4('0xe1'):_0x3847cf[_0x46e4('0x62')][_0x46e4('0xca')]+(_0x3847cf[_0x46e4('0x62')][_0x46e4('0xcb')]?'\x20'+_0x3847cf[_0x46e4('0x62')][_0x46e4('0xcb')]:''),'body':_0x3847cf[_0x46e4('0x6d')],'direction':_0x3847cf[_0x46e4('0xcd')]===_0x46e4('0xe0')?'A':'C','secret':_0x3847cf[_0x46e4('0xce')],'read':_0x3847cf[_0x46e4('0x79')]};})[_0x46e4('0x5e')]()};return ejs[_0x46e4('0xe2')](path['join'](config[_0x46e4('0xc3')],_0x46e4('0xc4'),'views',_0x46e4('0xe3')),{'interaction':_0x49e978})[_0x46e4('0x24')](function(_0x3a9536){return new BPromise(function(_0x124553,_0x3fcd41){pdf[_0x46e4('0xb0')](_0x3a9536,_0x2652ff)['toFile'](path['join'](_0x2ad5fa,'transcript-'+_0x177d48['id']+'-'+_0x54ebab+_0x46e4('0xe4')),function(_0x3f80b2,_0x575a9d){if(_0x3f80b2)return _0x3fcd41(_0x3f80b2);_0x124553(_0x575a9d);});});})['then'](function(){return new BPromise(function(_0x21ef28,_0x53bbe3){zipdir(_0x2ad5fa,{'saveTo':_0x131c2a},function(_0x425b9c,_0x5a4605){if(_0x425b9c)return _0x53bbe3(_0x425b9c);return _0x21ef28(_0x5a4605);});})[_0x46e4('0x24')](function(){return new BPromise(function(_0x4343b8,_0x3baec1){rimraf(_0x2ad5fa,function(_0x25ea63){if(_0x25ea63)_0x3baec1(_0x25ea63);return _0x4343b8();});});})['then'](function(){return _0x158901[_0x46e4('0xe5')](_0x131c2a,_0xa1970a,function(_0x1b8a9e){if(_0x1b8a9e){console['log'](_0x46e4('0xe6'),_0x1b8a9e);}else{fs[_0x46e4('0xe7')](_0x131c2a);}});});});}else{return _0x158901[_0x46e4('0x1a')](0xc8);}})['catch'](handleError(_0x158901,null));};
\ No newline at end of file
+var _0xa9e0=['params','keys','includeAll','include','options','create','body','describe','SmsMessage','addMessage','ids','omit','getMessages','format','rows','addTags','setTags','spread','Tag','emit','smsInteractionTags:save','removeTags','download','unix','root','server','files','tmp','join','transcript-%d-%s.zip','CmContact','lastName','direction','SmsAccount','Owner','mkdirSync','10px','<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','Account','N.A.','YYYY-MM-DD\x20HH:mm:ss','closed','disposition','Messages','out','System','secret','renderFile','views','downloadInteraction.html','toFile','transcript-','.pdf','log','unlinkSync','html-pdf','eml-format','rimraf','request-promise','bluebird','mustache','util','path','sox','ejs','lodash','squel','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/license/util','../../mysqldb','redis','defaults','localhost','./smsInteraction.socket','register','status','count','offset','limit','set','Content-Range','update','destroy','then','sendStatus','stack','name','send','Users','fullname','TagIds','Tags','split','forEach','catch','index','map','SmsInteraction','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','pick','select','field','color','from','u.id','u.fullname','ui.SmsInteractionId','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','a.id\x20=\x20i.SmsAccountId','sms_messages','sms_interaction_has_tags','it.SmsInteractionId\x20=\x20i.id','tools_tags','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','find','unreadMessages','`\x20=\x200','having','Contact','operator','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','value','ContactId','buildExpression','text','start','end','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','$substring','UserId','some','isEmpty','SmsAccountId','i.SmsAccountId\x20IN\x20?','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20=\x200','tag','isArray','filter','replace','isNumeric','i.id\x20LIKE\x20?','i.phone\x20LIKE\x20?','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','group','QueryTypes','SELECT','clone','i.id','contactName','DESC','t.id\x20IN\x20?','resolve','i.SmsAccountId\x20IS\x20NOT\x20NULL','user','role','agent','getSmsAccounts','i.SmsAccountId\x20IS\x20NULL','sequelize','toString','length','merge','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','Account.mandatoryDisposition','i.*','c.firstName','Contact.firstName','Contact.lastName','c.email','Contact.email','c.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.SmsInteractionId\x20IN\x20?','groupBy','SmsInteractionId','push','all','show'];(function(_0x2d7f0e,_0x3e6fbd){var _0x110b07=function(_0x557b00){while(--_0x557b00){_0x2d7f0e['push'](_0x2d7f0e['shift']());}};_0x110b07(++_0x3e6fbd);}(_0xa9e0,0x123));var _0x0a9e=function(_0x5b561d,_0x422b7c){_0x5b561d=_0x5b561d-0x0;var _0x431060=_0xa9e0[_0x5b561d];return _0x431060;};'use strict';var pdf=require(_0x0a9e('0x0'));var emlformat=require(_0x0a9e('0x1'));var rimraf=require(_0x0a9e('0x2'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x0a9e('0x3'));var moment=require('moment');var BPromise=require(_0x0a9e('0x4'));var Mustache=require(_0x0a9e('0x5'));var util=require(_0x0a9e('0x6'));var path=require(_0x0a9e('0x7'));var sox=require(_0x0a9e('0x8'));var csv=require('to-csv');var ejs=require(_0x0a9e('0x9'));var fs=require('fs');var _=require(_0x0a9e('0xa'));var squel=require(_0x0a9e('0xb'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x0a9e('0xc'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x0a9e('0xd'));var Redis=require(_0x0a9e('0xe'));var authService=require(_0x0a9e('0xf'));var qs=require(_0x0a9e('0x10'));var as=require(_0x0a9e('0x11'));var hardwareService=require(_0x0a9e('0x12'));var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x0a9e('0x13'));var db=require(_0x0a9e('0x14'))['db'];config[_0x0a9e('0x15')]=_[_0x0a9e('0x16')](config[_0x0a9e('0x15')],{'host':_0x0a9e('0x17'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x0a9e('0x15')]));require(_0x0a9e('0x18'))[_0x0a9e('0x19')](socket);function respondWithStatusCode(_0x281129,_0x44dcfd){_0x44dcfd=_0x44dcfd||0xcc;return function(_0x4d5611){if(_0x4d5611){return _0x281129['sendStatus'](_0x44dcfd);}return _0x281129[_0x0a9e('0x1a')](_0x44dcfd)['end']();};}function respondWithResult(_0x1985b6,_0x519dfd){_0x519dfd=_0x519dfd||0xc8;return function(_0x16033c){if(_0x16033c){return _0x1985b6[_0x0a9e('0x1a')](_0x519dfd)['json'](_0x16033c);}};}function respondWithFilteredResult(_0x225616,_0x5a0a06){return function(_0x459eb1){if(_0x459eb1){var _0x478723=_0x459eb1[_0x0a9e('0x1b')],_0x106033=_0x5a0a06[_0x0a9e('0x1c')],_0x205fd6=_0x5a0a06[_0x0a9e('0x1c')]+_0x5a0a06[_0x0a9e('0x1d')],_0x31b1ca;if(_0x205fd6>=_0x478723){_0x205fd6=_0x478723;_0x31b1ca=0xc8;}else{_0x31b1ca=0xce;}_0x225616[_0x0a9e('0x1a')](_0x31b1ca);return _0x225616[_0x0a9e('0x1e')](_0x0a9e('0x1f'),_0x106033+'-'+_0x205fd6+'/'+_0x478723)['json'](_0x459eb1);}return null;};}function patchUpdates(_0x2c3407){return function(_0x155cce){try{jsonpatch['apply'](_0x155cce,_0x2c3407,!![]);}catch(_0x20f109){return BPromise['reject'](_0x20f109);}return _0x155cce['save']();};}function saveUpdates(_0x3a02e1,_0x432e56){return function(_0x38e7c4){if(_0x38e7c4){return _0x38e7c4[_0x0a9e('0x20')](_0x3a02e1)['then'](function(_0xfb6e48){return _0xfb6e48;});}return null;};}function removeEntity(_0x2fb0e4,_0x3b45bc){return function(_0x4d00e6){if(_0x4d00e6){return _0x4d00e6[_0x0a9e('0x21')]()[_0x0a9e('0x22')](function(){_0x2fb0e4[_0x0a9e('0x1a')](0xcc)['end']();});}};}function handleEntityNotFound(_0x59181e,_0x197ec0){return function(_0x3a8e58){if(!_0x3a8e58){_0x59181e[_0x0a9e('0x23')](0x194);}return _0x3a8e58;};}function handleError(_0x33161b,_0x526cf3){_0x526cf3=_0x526cf3||0x1f4;return function(_0x384319){logger['error'](_0x384319[_0x0a9e('0x24')]);if(_0x384319['name']){delete _0x384319[_0x0a9e('0x25')];}_0x33161b[_0x0a9e('0x1a')](_0x526cf3)[_0x0a9e('0x26')](_0x384319);};}function getInteractionUsers(_0x14433c,_0x140511){return new BPromise(function(_0x1538a4,_0x11c3b6){try{if(_0x140511[_0x14433c['id']]){_0x14433c[_0x0a9e('0x27')]=_['map'](_0x140511[_0x14433c['id']],function(_0x3652a7){return{'id':_0x3652a7['id'],'fullname':_0x3652a7[_0x0a9e('0x28')]};});}}catch(_0x2b1f27){_0x11c3b6(_0x2b1f27);}_0x1538a4(_0x14433c);});}function getInteractionTags(_0x2ec755,_0x5c877d){return new BPromise(function(_0x15b200,_0x40e7a3){try{if(_0x2ec755[_0x0a9e('0x29')]){_0x2ec755[_0x0a9e('0x2a')]=[];_0x2ec755[_0x0a9e('0x29')][_0x0a9e('0x2b')](',')[_0x0a9e('0x2c')](function(_0x2e8759){_0x2ec755[_0x0a9e('0x2a')]['push'](_0x5c877d[_0x2e8759]);});}delete _0x2ec755[_0x0a9e('0x29')];}catch(_0x5d1e0e){_0x40e7a3(_0x5d1e0e);}_0x15b200(_0x2ec755);});}function updateSmsInteraction(_0x2407f9,_0x3ae878,_0x1122db){return new BPromise(function(_0x33bdb7,_0x25ce3a){return getInteractionUsers(_0x2407f9,_0x1122db)['then'](function(_0x66c1d2){return getInteractionTags(_0x66c1d2,_0x3ae878);})[_0x0a9e('0x22')](function(_0x40cb85){_0x33bdb7(_0x40cb85);})[_0x0a9e('0x2d')](function(_0x2b45ea){_0x25ce3a(_0x2b45ea);});});}exports[_0x0a9e('0x2e')]=function(_0x332d35,_0x39e565){var _0x5583a4={},_0x44295a={},_0x5e7238={'count':0x0,'rows':[]};var _0x2cc7a0=_[_0x0a9e('0x2f')](db[_0x0a9e('0x30')][_0x0a9e('0x31')],function(_0x567193){return{'name':_0x567193[_0x0a9e('0x32')],'type':_0x567193[_0x0a9e('0x33')][_0x0a9e('0x34')]};});_0x44295a[_0x0a9e('0x35')]=_['map'](_0x2cc7a0,'name');_0x44295a[_0x0a9e('0x36')]=_['keys'](_0x332d35[_0x0a9e('0x36')]);_0x44295a[_0x0a9e('0x37')]=_[_0x0a9e('0x38')](_0x44295a[_0x0a9e('0x35')],_0x44295a['query']);_0x5583a4[_0x0a9e('0x39')]=_[_0x0a9e('0x38')](_0x44295a[_0x0a9e('0x35')],qs['fields'](_0x332d35[_0x0a9e('0x36')][_0x0a9e('0x3a')]));_0x5583a4[_0x0a9e('0x39')]=_0x5583a4['attributes']['length']?_0x5583a4[_0x0a9e('0x39')]:_0x44295a[_0x0a9e('0x35')];if(!_0x332d35['query'][_0x0a9e('0x3b')](_0x0a9e('0x3c'))){_0x5583a4[_0x0a9e('0x1d')]=qs[_0x0a9e('0x1d')](_0x332d35['query']['limit']);_0x5583a4[_0x0a9e('0x1c')]=qs[_0x0a9e('0x1c')](_0x332d35['query'][_0x0a9e('0x1c')]);}_0x5583a4[_0x0a9e('0x3d')]=qs[_0x0a9e('0x3e')](_0x332d35['query'][_0x0a9e('0x3e')]);_0x5583a4[_0x0a9e('0x3f')]=qs[_0x0a9e('0x37')](_[_0x0a9e('0x40')](_0x332d35[_0x0a9e('0x36')],_0x44295a[_0x0a9e('0x37')]),_0x2cc7a0);var _0x2881b3=[];var _0x45a9b8=squel[_0x0a9e('0x41')]()[_0x0a9e('0x42')]('id')[_0x0a9e('0x42')](_0x0a9e('0x25'))[_0x0a9e('0x42')](_0x0a9e('0x43'))[_0x0a9e('0x44')]('tools_tags');var _0x52628e=squel[_0x0a9e('0x41')]()[_0x0a9e('0x42')](_0x0a9e('0x45'))[_0x0a9e('0x42')](_0x0a9e('0x46'))[_0x0a9e('0x42')](_0x0a9e('0x47'))[_0x0a9e('0x44')](_0x0a9e('0x48'),'ui')[_0x0a9e('0x49')](_0x0a9e('0x4a'),'u',_0x0a9e('0x4b'));var _0x5026aa=squel[_0x0a9e('0x41')]()[_0x0a9e('0x44')](_0x0a9e('0x4c'),'i')[_0x0a9e('0x49')](_0x0a9e('0x4d'),'c',_0x0a9e('0x4e'))[_0x0a9e('0x49')](_0x0a9e('0x4a'),'o','o.id\x20=\x20i.UserId')[_0x0a9e('0x49')]('sms_accounts','a',_0x0a9e('0x4f'))[_0x0a9e('0x49')](_0x0a9e('0x50'),'me','me.SmsInteractionId\x20=\x20i.id')[_0x0a9e('0x49')](_0x0a9e('0x51'),'it',_0x0a9e('0x52'))[_0x0a9e('0x49')](_0x0a9e('0x53'),'t',_0x0a9e('0x54'));var _0x45bf7f=squel['expr']();var _0x13f44d=[];var _0x1bde3c=squel[_0x0a9e('0x55')]();var _0x16f976;if(_0x332d35[_0x0a9e('0x36')][_0x0a9e('0x56')]){_0x16f976=as[_0x0a9e('0x57')](_0x332d35[_0x0a9e('0x36')][_0x0a9e('0x56')]);var _0x58a5c2=_0x16f976[_0x0a9e('0x58')];for(var _0x3fe430=0x0;_0x3fe430<_0x16f976['conditions']['length'];_0x3fe430++){var _0x5ddf84=_0x16f976[_0x0a9e('0x59')][_0x3fe430];var _0x4317e3='i';var _0x37edaa=_[_0x0a9e('0x5a')](_0x2cc7a0,[_0x0a9e('0x25'),_0x5ddf84[_0x0a9e('0x42')]]);if(!_0x37edaa){switch(_0x5ddf84[_0x0a9e('0x42')]){case _0x0a9e('0x5b'):if(_0x5ddf84['value']==0x1){_0x5026aa['having']('`'+_0x5ddf84['field']+_0x0a9e('0x5c'));}else{_0x5026aa[_0x0a9e('0x5d')]('`'+_0x5ddf84[_0x0a9e('0x42')]+'`\x20>\x200');}break;case _0x0a9e('0x5e'):if(_0x5ddf84[_0x0a9e('0x5f')]==='$substring'){if(_0x5ddf84['value'][_0x0a9e('0x2b')]('\x20')['length']>0x1){_0x45bf7f[_0x58a5c2](_0x0a9e('0x60'),qs['getFullTextValue'](_0x5ddf84[_0x0a9e('0x61')]),null);}else{var _0x3c20b2='%'+_0x5ddf84[_0x0a9e('0x61')]+'%';_0x45bf7f[_0x58a5c2]('c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?',_0x3c20b2,_0x3c20b2,_0x3c20b2);}}else{_0x37edaa=_[_0x0a9e('0x5a')](_0x2cc7a0,[_0x0a9e('0x25'),'ContactId']);_0x5ddf84['field']=_0x0a9e('0x62');_0x261adb=as[_0x0a9e('0x63')](_0x4317e3,_0x37edaa['type'],_0x5ddf84);_0x45bf7f[_0x58a5c2](_0x261adb[_0x0a9e('0x64')],_0x261adb['value'][_0x0a9e('0x65')],_0x261adb['value'][_0x0a9e('0x66')]);}break;case'Tag':var _0x5da27d=_0x5ddf84['value'][_0x0a9e('0x2b')](',')['map'](function(_0x2f7092){return Number(_0x2f7092);});_0x5da27d[_0x0a9e('0x2c')](function(_0x3cfd00){_0x1bde3c['or'](_0x0a9e('0x67'),'%,'+_0x3cfd00+',%');});_0x13f44d=_[_0x0a9e('0x68')](_0x13f44d,_0x5da27d);break;case _0x0a9e('0x69'):if(_0x5ddf84[_0x0a9e('0x5f')]===_0x0a9e('0x6a')){_0x45bf7f[_0x58a5c2]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x5ddf84[_0x0a9e('0x61')]+'%',null);}else{_0x37edaa=_[_0x0a9e('0x5a')](_0x2cc7a0,[_0x0a9e('0x25'),_0x0a9e('0x6b')]);_0x5ddf84[_0x0a9e('0x42')]=_0x0a9e('0x6b');_0x261adb=as['buildExpression'](_0x4317e3,_0x37edaa[_0x0a9e('0x33')],_0x5ddf84);_0x45bf7f[_0x58a5c2](_0x261adb[_0x0a9e('0x64')],_0x261adb['value'][_0x0a9e('0x65')],_0x261adb['value'][_0x0a9e('0x66')]);}break;case'body':_0x261adb=as['buildExpression']('me',null,_0x5ddf84);_0x45bf7f[_0x58a5c2](_0x261adb['text'],_0x261adb[_0x0a9e('0x61')]['start'],_0x261adb[_0x0a9e('0x61')][_0x0a9e('0x66')]);break;}}else{var _0x261adb=as[_0x0a9e('0x63')](_0x4317e3,_0x37edaa[_0x0a9e('0x33')],_0x5ddf84);_0x45bf7f[_0x58a5c2](_0x261adb[_0x0a9e('0x64')],_0x261adb['value'][_0x0a9e('0x65')],_0x261adb['value'][_0x0a9e('0x66')]);}}}else{var _0x1f07cb=_(_0x332d35[_0x0a9e('0x36')])['keys']()[_0x0a9e('0x2f')](function(_0x156f1c){return _[_0x0a9e('0x6c')](_0x2cc7a0,[_0x0a9e('0x25'),_0x156f1c])?_0x156f1c:undefined;})['compact']()[_0x0a9e('0x61')]();if(!_[_0x0a9e('0x6d')](_0x1f07cb)){_0x1f07cb['forEach'](function(_0x797b45){if(_0x797b45===_0x0a9e('0x6e')){_0x5026aa[_0x0a9e('0x3f')](_0x0a9e('0x6f'),[][_0x0a9e('0x70')](_0x332d35['query'][_0x797b45]));}else if(_0x797b45===_0x0a9e('0x71')){var _0x2937e0=JSON[_0x0a9e('0x72')](_0x332d35['query'][_0x797b45])[_0x0a9e('0x73')];var _0x4f1e60=JSON['parse'](_0x332d35[_0x0a9e('0x36')][_0x797b45])[_0x0a9e('0x74')];_0x5026aa[_0x0a9e('0x3f')](_0x0a9e('0x75'),_0x2937e0,_0x4f1e60);}else{if(_0x332d35[_0x0a9e('0x36')][_0x797b45]===_0x0a9e('0x76')){_0x5026aa[_0x0a9e('0x3f')]('i.'+_0x797b45+_0x0a9e('0x77'));}else{_0x5026aa[_0x0a9e('0x3f')]('i.'+_0x797b45+_0x0a9e('0x78'),_0x332d35[_0x0a9e('0x36')][_0x797b45]);}}});}if(_0x332d35[_0x0a9e('0x36')][_0x0a9e('0x79')]){if(_0x332d35[_0x0a9e('0x36')][_0x0a9e('0x79')]==0x1){_0x5026aa[_0x0a9e('0x5d')](_0x0a9e('0x7a'));}else{_0x5026aa[_0x0a9e('0x5d')]('`unreadMessages`\x20>\x200');}}if(_0x332d35[_0x0a9e('0x36')][_0x0a9e('0x7b')]){_0x13f44d=_[_0x0a9e('0x7c')](_0x332d35['query'][_0x0a9e('0x7b')])?_0x332d35[_0x0a9e('0x36')]['tag']:new Array(_0x332d35[_0x0a9e('0x36')][_0x0a9e('0x7b')]);_0x13f44d[_0x0a9e('0x2c')](function(_0x427946){_0x1bde3c['or'](_0x0a9e('0x67'),'%,'+_0x427946+',%');});}if(_0x332d35['query']['filter']){var _0x4a2438=_0x332d35[_0x0a9e('0x36')][_0x0a9e('0x7d')][_0x0a9e('0x7e')]('\x5c','\x5c\x5c')[_0x0a9e('0x7e')](/'/g,'\x27\x27');if(qs[_0x0a9e('0x7f')](_0x4a2438)){_0x45bf7f['or'](_0x0a9e('0x80'),_0x4a2438+'%')['or'](_0x0a9e('0x81'),_0x4a2438+'%');}else{_0x45bf7f['or'](_0x0a9e('0x82'),qs['getFullTextValue'](_0x4a2438))['or'](_0x0a9e('0x83'),_0x4a2438+'%');}}}_0x5026aa[_0x0a9e('0x3f')](_0x45bf7f);_0x5026aa[_0x0a9e('0x84')]('i.id');var _0x2bdc44={'type':db['Sequelize'][_0x0a9e('0x85')][_0x0a9e('0x86')],'raw':!![]};var _0x4c46c1=_0x5026aa[_0x0a9e('0x87')]();_0x4c46c1[_0x0a9e('0x42')](_0x0a9e('0x88'));_0x4c46c1[_0x0a9e('0x42')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x0a9e('0x5b'));if(_0x5583a4[_0x0a9e('0x3d')]){_0x5583a4[_0x0a9e('0x3d')][_0x0a9e('0x2c')](function(_0x5b7fc3){var _0x109ccb=_0x5b7fc3[0x0]===_0x0a9e('0x89')?_0x5b7fc3[0x0]:'i.'+_0x5b7fc3[0x0];_0x5026aa[_0x0a9e('0x3d')](_0x109ccb,_0x5b7fc3[0x1]===_0x0a9e('0x8a')?![]:!![]);});}if(!_['isEmpty'](_0x13f44d)){_0x5026aa[_0x0a9e('0x5d')](_0x1bde3c);_0x4c46c1[_0x0a9e('0x3f')](_0x0a9e('0x8b'),_0x13f44d);}BPromise[_0x0a9e('0x8c')]()[_0x0a9e('0x22')](function(){if(!_0x16f976){if(_0x332d35[_0x0a9e('0x36')][_0x0a9e('0x6e')])return;_0x4c46c1[_0x0a9e('0x3f')](_0x0a9e('0x8d'));_0x5026aa[_0x0a9e('0x3f')](_0x0a9e('0x8d'));return;}if(_0x332d35[_0x0a9e('0x8e')][_0x0a9e('0x8f')]!==_0x0a9e('0x90'))return;return _0x332d35['user'][_0x0a9e('0x91')]({'attributes':['id'],'raw':!![]})[_0x0a9e('0x22')](function(_0xc599b3){if(_['isEmpty'](_0xc599b3)){_0x4c46c1[_0x0a9e('0x3f')](_0x0a9e('0x92'));_0x5026aa[_0x0a9e('0x3f')](_0x0a9e('0x92'));}else{_0x4c46c1['where']('i.SmsAccountId\x20IN\x20?',_[_0x0a9e('0x2f')](_0xc599b3,'id'));_0x5026aa[_0x0a9e('0x3f')]('i.SmsAccountId\x20IN\x20?',_[_0x0a9e('0x2f')](_0xc599b3,'id'));}});})['then'](function(){if(_0x332d35[_0x0a9e('0x8e')][_0x0a9e('0x8f')]==='agent'&&!_0x16f976&&!_0x332d35[_0x0a9e('0x36')][_0x0a9e('0x6e')])return[];return db[_0x0a9e('0x93')][_0x0a9e('0x36')](_0x4c46c1[_0x0a9e('0x94')](),_0x2bdc44);})[_0x0a9e('0x22')](function(_0x444f1f){_0x5e7238['count']=_0x444f1f[_0x0a9e('0x95')];if(_0x5e7238[_0x0a9e('0x1b')]===0x0)return[];return db[_0x0a9e('0x93')][_0x0a9e('0x36')](_0x45a9b8['toString'](),_0x2bdc44)[_0x0a9e('0x22')](function(_0xf0db1){_0x2881b3=_['keyBy'](_0xf0db1,'id');_0x2bdc44=_[_0x0a9e('0x96')](_0x2bdc44,{'model':db['SmsInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x332d35[_0x0a9e('0x36')][_0x0a9e('0x3a')]){_0x5583a4[_0x0a9e('0x39')][_0x0a9e('0x2c')](function(_0x5af453){_0x5026aa['field']('i.'+_0x5af453);});}else{_0x5026aa[_0x0a9e('0x42')](_0x0a9e('0x97'),_0x0a9e('0x5b'));_0x5026aa['field'](_0x0a9e('0x98'),_0x0a9e('0x99'));_0x5026aa['field']('a.mandatoryDisposition',_0x0a9e('0x9a'));_0x5026aa['field']('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','contactName');_0x5026aa[_0x0a9e('0x42')](_0x0a9e('0x9b'));_0x5026aa[_0x0a9e('0x42')](_0x0a9e('0x9c'),_0x0a9e('0x9d'));_0x5026aa[_0x0a9e('0x42')]('c.lastName',_0x0a9e('0x9e'));_0x5026aa['field'](_0x0a9e('0x9f'),_0x0a9e('0xa0'));_0x5026aa[_0x0a9e('0x42')](_0x0a9e('0xa1'),'Contact.phone');_0x5026aa[_0x0a9e('0x42')](_0x0a9e('0xa2'),_0x0a9e('0xa3'));_0x5026aa['field'](_0x0a9e('0xa4'),_0x0a9e('0xa5'));_0x5026aa[_0x0a9e('0x42')](_0x0a9e('0xa6'),_0x0a9e('0xa7'));_0x5026aa[_0x0a9e('0x42')](_0x0a9e('0xa8'),_0x0a9e('0xa9'));_0x5026aa['field'](_0x0a9e('0xaa'),_0x0a9e('0x29'));}if(_0x5583a4['limit'])_0x5026aa[_0x0a9e('0x1d')](_0x5583a4[_0x0a9e('0x1d')]);if(_0x5583a4[_0x0a9e('0x1c')])_0x5026aa['offset'](_0x5583a4[_0x0a9e('0x1c')]);return db['sequelize'][_0x0a9e('0x36')](_0x5026aa[_0x0a9e('0x94')](),_0x2bdc44);})[_0x0a9e('0x22')](function(_0x1f29bd){_0x52628e[_0x0a9e('0x3f')](_0x0a9e('0xab'),_[_0x0a9e('0x2f')](_0x1f29bd,'id'));return db[_0x0a9e('0x93')]['query'](_0x52628e[_0x0a9e('0x94')](),_0x2bdc44)[_0x0a9e('0x22')](function(_0x17f692){var _0x30ef6e=_[_0x0a9e('0xac')](_0x17f692,_0x0a9e('0xad'));var _0x6803d6=[];_0x1f29bd[_0x0a9e('0x2c')](function(_0x1808ba){_0x6803d6[_0x0a9e('0xae')](updateSmsInteraction(_0x1808ba,_0x2881b3,_0x30ef6e));});return BPromise[_0x0a9e('0xaf')](_0x6803d6);});});})[_0x0a9e('0x22')](function(_0x18273f){_0x5e7238['rows']=_0x18273f;return _0x5e7238;})[_0x0a9e('0x22')](respondWithFilteredResult(_0x39e565,_0x5583a4))[_0x0a9e('0x2d')](handleError(_0x39e565,null));};exports[_0x0a9e('0xb0')]=function(_0x2ed526,_0xb0599a){var _0x5d9ddb={'raw':![],'where':{'id':_0x2ed526[_0x0a9e('0xb1')]['id']}},_0x3afc8c={};_0x3afc8c['model']=_[_0x0a9e('0xb2')](db['SmsInteraction'][_0x0a9e('0x31')]);_0x3afc8c[_0x0a9e('0x36')]=_[_0x0a9e('0xb2')](_0x2ed526[_0x0a9e('0x36')]);_0x3afc8c['filters']=_[_0x0a9e('0x38')](_0x3afc8c['model'],_0x3afc8c[_0x0a9e('0x36')]);_0x5d9ddb[_0x0a9e('0x39')]=_['intersection'](_0x3afc8c[_0x0a9e('0x35')],qs[_0x0a9e('0x3a')](_0x2ed526[_0x0a9e('0x36')]['fields']));_0x5d9ddb['attributes']=_0x5d9ddb[_0x0a9e('0x39')][_0x0a9e('0x95')]?_0x5d9ddb[_0x0a9e('0x39')]:_0x3afc8c[_0x0a9e('0x35')];if(_0x2ed526[_0x0a9e('0x36')][_0x0a9e('0xb3')]){_0x5d9ddb[_0x0a9e('0xb4')]=[{'all':!![]}];}_0x5d9ddb=_[_0x0a9e('0x96')]({},_0x5d9ddb,_0x2ed526[_0x0a9e('0xb5')]);return db['SmsInteraction'][_0x0a9e('0x5a')](_0x5d9ddb)['then'](handleEntityNotFound(_0xb0599a,null))[_0x0a9e('0x22')](respondWithResult(_0xb0599a,null))[_0x0a9e('0x2d')](handleError(_0xb0599a,null));};exports[_0x0a9e('0xb6')]=function(_0x28ce92,_0x1b61d5){return db['SmsInteraction'][_0x0a9e('0xb6')](_0x28ce92[_0x0a9e('0xb7')],{})[_0x0a9e('0x22')](respondWithResult(_0x1b61d5,0xc9))[_0x0a9e('0x2d')](handleError(_0x1b61d5,null));};exports[_0x0a9e('0x20')]=function(_0x5c66ef,_0x4f074c){if(_0x5c66ef[_0x0a9e('0xb7')]['id']){delete _0x5c66ef['body']['id'];}return db[_0x0a9e('0x30')][_0x0a9e('0x5a')]({'where':{'id':_0x5c66ef[_0x0a9e('0xb1')]['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x4f074c,null))[_0x0a9e('0x22')](saveUpdates(_0x5c66ef[_0x0a9e('0xb7')],null))['then'](respondWithResult(_0x4f074c,null))['catch'](handleError(_0x4f074c,null));};exports[_0x0a9e('0x21')]=function(_0x5dfbe2,_0x2469d1){return db['SmsInteraction'][_0x0a9e('0x5a')]({'where':{'id':_0x5dfbe2['params']['id']}})['then'](handleEntityNotFound(_0x2469d1,null))[_0x0a9e('0x22')](removeEntity(_0x2469d1,null))[_0x0a9e('0x2d')](handleError(_0x2469d1,null));};exports['describe']=function(_0x170af6,_0x17cb30){return db[_0x0a9e('0x30')][_0x0a9e('0xb8')]()[_0x0a9e('0x22')](respondWithResult(_0x17cb30,null))['catch'](handleError(_0x17cb30,null));};exports['addMessage']=function(_0x16449b,_0x22286c,_0x41c8cd){return db[_0x0a9e('0xb9')][_0x0a9e('0x5a')]({'where':{'id':_0x16449b['params']['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x22286c,null))[_0x0a9e('0x22')](function(_0x5416a9){if(_0x5416a9){return _0x5416a9[_0x0a9e('0xba')](_0x16449b[_0x0a9e('0xb7')][_0x0a9e('0xbb')],_[_0x0a9e('0xbc')](_0x16449b[_0x0a9e('0xb7')],[_0x0a9e('0xbb'),'id'])||{});}})[_0x0a9e('0x22')](respondWithResult(_0x22286c,null))[_0x0a9e('0x2d')](handleError(_0x22286c,null));};exports[_0x0a9e('0xbd')]=function(_0x16afb3,_0x4bdebb,_0x1065a7){var _0x301047={'raw':![],'where':{}};var _0x2ada60={};var _0x1c4232={'count':0x0,'rows':[]};return db[_0x0a9e('0x30')]['findOne']({'where':{'id':_0x16afb3['params']['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x4bdebb,null))[_0x0a9e('0x22')](function(_0x466bbf){if(_0x466bbf){_0x2ada60[_0x0a9e('0x35')]=_[_0x0a9e('0xb2')](db['SmsMessage'][_0x0a9e('0x31')]);_0x2ada60[_0x0a9e('0x36')]=_[_0x0a9e('0xb2')](_0x16afb3['query']);_0x2ada60[_0x0a9e('0x37')]=_['intersection'](_0x2ada60[_0x0a9e('0x35')],_0x2ada60['query']);_0x301047[_0x0a9e('0x39')]=_[_0x0a9e('0x38')](_0x2ada60[_0x0a9e('0x35')],qs['fields'](_0x16afb3[_0x0a9e('0x36')]['fields']));_0x301047[_0x0a9e('0x39')]=_0x301047[_0x0a9e('0x39')][_0x0a9e('0x95')]?_0x301047[_0x0a9e('0x39')]:_0x2ada60[_0x0a9e('0x35')];if(!_0x16afb3[_0x0a9e('0x36')][_0x0a9e('0x3b')](_0x0a9e('0x3c'))){_0x301047[_0x0a9e('0x1d')]=qs[_0x0a9e('0x1d')](_0x16afb3[_0x0a9e('0x36')][_0x0a9e('0x1d')]);_0x301047[_0x0a9e('0x1c')]=qs[_0x0a9e('0x1c')](_0x16afb3[_0x0a9e('0x36')][_0x0a9e('0x1c')]);}_0x301047['order']=qs['sort'](_0x16afb3[_0x0a9e('0x36')]['sort']);_0x301047[_0x0a9e('0x3f')]=qs[_0x0a9e('0x37')](_['pick'](_0x16afb3[_0x0a9e('0x36')],_0x2ada60[_0x0a9e('0x37')]));_0x301047[_0x0a9e('0x3f')][_0x0a9e('0xad')]=_0x466bbf['id'];if(_0x16afb3['query'][_0x0a9e('0x7d')]){_0x301047[_0x0a9e('0x3f')]=_[_0x0a9e('0x96')](_0x301047[_0x0a9e('0x3f')],{'$or':_['map'](_0x301047[_0x0a9e('0x39')],function(_0x1a0b08){var _0x2b7092={};_0x2b7092[_0x1a0b08]={'$like':'%'+_0x16afb3['query'][_0x0a9e('0x7d')]+'%'};return _0x2b7092;})});}if(_0x16afb3[_0x0a9e('0x36')][_0x0a9e('0x73')]){var _0x54b107=_0x16afb3[_0x0a9e('0x36')][_0x0a9e('0x73')][_0x0a9e('0x2b')](',');var _0x1a7f58={};_0x1a7f58[_0x54b107[0x0]]={'$gte':moment(_0x54b107[0x1])[_0x0a9e('0xbe')]('YYYY-MM-DD\x20HH:mm:ss')};_0x301047[_0x0a9e('0x3f')]=_[_0x0a9e('0x96')](_0x301047['where'],_0x1a7f58);}_0x301047=_[_0x0a9e('0x96')]({},_0x301047,_0x16afb3[_0x0a9e('0xb5')]);return db[_0x0a9e('0xb9')]['count']({'where':_0x301047['where']})['then'](function(_0x1015aa){_0x1c4232[_0x0a9e('0x1b')]=_0x1015aa;if(_0x16afb3['query'][_0x0a9e('0xb3')]){_0x301047[_0x0a9e('0xb4')]=[{'all':!![]}];}return db[_0x0a9e('0xb9')]['findAll'](_0x301047);})[_0x0a9e('0x22')](function(_0x30e037){_0x1c4232[_0x0a9e('0xbf')]=_0x30e037;return _0x1c4232;});}})[_0x0a9e('0x22')](respondWithFilteredResult(_0x4bdebb,_0x301047))[_0x0a9e('0x2d')](handleError(_0x4bdebb,null));};exports[_0x0a9e('0xc0')]=function(_0x40e6e7,_0x328ec5,_0x3b5bda){return db['SmsInteraction'][_0x0a9e('0x5a')]({'where':{'id':_0x40e6e7['params']['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x328ec5,null))[_0x0a9e('0x22')](function(_0x2097d8){if(_0x2097d8){return _0x2097d8[_0x0a9e('0xc1')](_0x40e6e7[_0x0a9e('0xb7')][_0x0a9e('0xbb')],_['omit'](_0x40e6e7[_0x0a9e('0xb7')],[_0x0a9e('0xbb'),'id'])||{})[_0x0a9e('0xc2')](function(){return db[_0x0a9e('0xc3')]['findAll']({'attributes':['id',_0x0a9e('0x25'),_0x0a9e('0x43')],'where':{'id':_0x40e6e7[_0x0a9e('0xb7')][_0x0a9e('0xbb')]}});})[_0x0a9e('0x22')](function(_0x2be526){socket[_0x0a9e('0xc4')](_0x0a9e('0xc5'),{'id':Number(_0x40e6e7[_0x0a9e('0xb1')]['id']),'tags':_0x2be526||[]});return{'id':Number(_0x40e6e7[_0x0a9e('0xb1')]['id']),'tags':_0x2be526||[]};});}})['then'](respondWithResult(_0x328ec5,null))[_0x0a9e('0x2d')](handleError(_0x328ec5,null));};exports[_0x0a9e('0xc6')]=function(_0x2ff265,_0x26b826,_0xea8bd1){return db[_0x0a9e('0x30')][_0x0a9e('0x5a')]({'where':{'id':_0x2ff265[_0x0a9e('0xb1')]['id']}})['then'](handleEntityNotFound(_0x26b826,null))[_0x0a9e('0x22')](function(_0xd2391){if(_0xd2391){return _0xd2391[_0x0a9e('0xc6')](_0x2ff265['query'][_0x0a9e('0xbb')]);}})[_0x0a9e('0x22')](respondWithStatusCode(_0x26b826,null))[_0x0a9e('0x2d')](handleError(_0x26b826,null));};exports[_0x0a9e('0xc7')]=function(_0x370b5e,_0x1ba457){var _0x424f1b=moment()[_0x0a9e('0xc8')]()[_0x0a9e('0x94')]();var _0x451010=path['join'](config[_0x0a9e('0xc9')],_0x0a9e('0xca'),_0x0a9e('0xcb'),_0x0a9e('0xcc'));var _0x2b624e=path[_0x0a9e('0xcd')](config['root'],_0x0a9e('0xca'),'files','attachments');var _0x573df6=path[_0x0a9e('0xcd')](_0x451010,_0x424f1b);var _0x3fa3f2=util[_0x0a9e('0xbe')](_0x0a9e('0xce'),_0x370b5e['params']['id'],_0x424f1b);var _0x4156a5=path[_0x0a9e('0xcd')](_0x451010,_0x3fa3f2);var _0x3ddbc7=[];_0x3ddbc7[_0x0a9e('0xae')]({'model':db[_0x0a9e('0x69')],'as':'User','attributes':['id','fullname'],'raw':!![]});_0x3ddbc7[_0x0a9e('0xae')]({'model':db[_0x0a9e('0xcf')],'as':_0x0a9e('0x5e'),'attributes':['id','firstName',_0x0a9e('0xd0')],'raw':!![]});var _0x248a9a=[{'model':db[_0x0a9e('0xb9')],'as':'Messages','attributes':['id',_0x0a9e('0xb7'),_0x0a9e('0x71'),_0x0a9e('0xd1'),'secret',_0x0a9e('0x79')],'include':_0x3ddbc7}];_0x248a9a[_0x0a9e('0xae')]({'model':db[_0x0a9e('0xd2')],'as':'Account','attributes':['id','name']});_0x248a9a['push']({'model':db[_0x0a9e('0x69')],'as':_0x0a9e('0xd3'),'attributes':['id',_0x0a9e('0x28')]});return db[_0x0a9e('0x30')]['find']({'where':{'id':_0x370b5e[_0x0a9e('0xb1')]['id']},'include':_0x248a9a})['then'](handleEntityNotFound(_0x1ba457,null))[_0x0a9e('0x22')](function(_0x2ff2ab){if(_0x2ff2ab){var _0x242f23=_0x2ff2ab['get']({'plain':!![]});fs[_0x0a9e('0xd4')](_0x573df6);var _0x33a26c={'format':'A4','border':_0x0a9e('0xd5'),'header':{'height':'40px','contents':{'first':_0x0a9e('0xd6')}},'footer':{'height':'30px','contents':{'default':util[_0x0a9e('0xbe')]('<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[_0x0a9e('0xbe')]('%s\x20#%d',_0x0a9e('0xd7'),_0x242f23['id']),moment()[_0x0a9e('0xbe')](_0x0a9e('0xd8'))[_0x0a9e('0x94')]())}}};var _0x1e306c={'channel':_0x0a9e('0xd7'),'account':_0x242f23[_0x0a9e('0xd9')]['name'],'agent':_0x242f23[_0x0a9e('0xd3')]?_0x242f23[_0x0a9e('0xd3')]['fullname']:_0x0a9e('0xda'),'createdAt':moment(_0x242f23[_0x0a9e('0x71')])['format'](_0x0a9e('0xdb'))[_0x0a9e('0x94')](),'closedAt':_0x242f23[_0x0a9e('0xdc')]?moment(_0x242f23['closedAt'])[_0x0a9e('0xbe')](_0x0a9e('0xdb'))[_0x0a9e('0x94')]():'','disposition':_0x242f23[_0x0a9e('0xdd')],'messages':_(_0x242f23[_0x0a9e('0xde')])[_0x0a9e('0x7d')]({'secret':![]})[_0x0a9e('0x2f')](function(_0x74d9b8){return{'date':moment(_0x74d9b8[_0x0a9e('0x71')])[_0x0a9e('0xbe')]('YYYY-MM-DD\x20HH:mm:ss')[_0x0a9e('0x94')](),'sender':_0x74d9b8['direction']===_0x0a9e('0xdf')?_0x74d9b8[_0x0a9e('0x69')]?_0x74d9b8[_0x0a9e('0x69')][_0x0a9e('0x28')]:_0x0a9e('0xe0'):_0x74d9b8[_0x0a9e('0x5e')]['firstName']+(_0x74d9b8[_0x0a9e('0x5e')][_0x0a9e('0xd0')]?'\x20'+_0x74d9b8[_0x0a9e('0x5e')]['lastName']:''),'body':_0x74d9b8[_0x0a9e('0xb7')],'direction':_0x74d9b8[_0x0a9e('0xd1')]===_0x0a9e('0xdf')?'A':'C','secret':_0x74d9b8[_0x0a9e('0xe1')],'read':_0x74d9b8[_0x0a9e('0x79')]};})[_0x0a9e('0x61')]()};return ejs[_0x0a9e('0xe2')](path['join'](config[_0x0a9e('0xc9')],_0x0a9e('0xca'),_0x0a9e('0xe3'),_0x0a9e('0xe4')),{'interaction':_0x1e306c})[_0x0a9e('0x22')](function(_0x241404){return new BPromise(function(_0x8120e,_0x5d6a48){pdf['create'](_0x241404,_0x33a26c)[_0x0a9e('0xe5')](path[_0x0a9e('0xcd')](_0x573df6,_0x0a9e('0xe6')+_0x242f23['id']+'-'+_0x424f1b+_0x0a9e('0xe7')),function(_0x40e2da,_0x131da8){if(_0x40e2da)return _0x5d6a48(_0x40e2da);_0x8120e(_0x131da8);});});})[_0x0a9e('0x22')](function(){return new BPromise(function(_0x584854,_0x39ea62){zipdir(_0x573df6,{'saveTo':_0x4156a5},function(_0x1d7fc4,_0x2d8e91){if(_0x1d7fc4)return _0x39ea62(_0x1d7fc4);return _0x584854(_0x2d8e91);});})[_0x0a9e('0x22')](function(){return new BPromise(function(_0x1b1757,_0x3c6082){rimraf(_0x573df6,function(_0x16be7e){if(_0x16be7e)_0x3c6082(_0x16be7e);return _0x1b1757();});});})['then'](function(){return _0x1ba457[_0x0a9e('0xc7')](_0x4156a5,_0x3fa3f2,function(_0x294310){if(_0x294310){console[_0x0a9e('0xe8')]('err',_0x294310);}else{fs[_0x0a9e('0xe9')](_0x4156a5);}});});});}else{return _0x1ba457[_0x0a9e('0x23')](0xc8);}})[_0x0a9e('0x2d')](handleError(_0x1ba457,null));};
\ No newline at end of file