18 var _0x9bde=['util','path','sox','ejs','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','redis','socket.io-emitter','./smsInteraction.socket','sendStatus','status','end','json','count','offset','set','Content-Range','apply','reject','save','update','then','destroy','stack','name','send','map','fullname','TagIds','Tags','split','forEach','push','catch','index','SmsInteraction','rawAttributes','type','key','query','filters','model','attributes','fields','hasOwnProperty','nolimit','limit','sort','pick','select','field','color','from','tools_tags','u.id','ui.SmsInteractionId','user_has_sms_interactions','u.id\x20=\x20ui.UserId','sms_interactions','left_join','cm_contacts','o.id\x20=\x20i.UserId','sms_accounts','a.id\x20=\x20i.SmsAccountId','me.SmsInteractionId\x20=\x20i.id','sms_interaction_has_tags','t.id\x20=\x20it.TagId','expr','search','sqlOperator','length','conditions','value','having','`\x20=\x200','`\x20>\x200','Contact','$substring','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','find','ContactId','buildExpression','text','start','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','operator','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','keys','compact','SmsAccountId','where','i.SmsAccountId\x20IN\x20?','concat','createdAt','parse','$gte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','`unreadMessages`\x20=\x200','`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)','getFullTextValue','Sequelize','SELECT','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','order','DESC','isEmpty','t.id\x20IN\x20?','resolve','journey','i.SmsAccountId\x20IS\x20NOT\x20NULL','user','getSmsAccounts','i.SmsAccountId\x20IS\x20NULL','toString','sequelize','keyBy','merge','unreadMessages','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','i.*','c.firstName','c.lastName','Contact.lastName','c.email','Contact.phone','Contact.mobile','c.fax','Contact.fax','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.SmsInteractionId\x20IN\x20?','all','rows','show','intersection','includeAll','options','create','body','params','describe','SmsMessage','addMessage','ids','omit','SmsInteractionId','format','YYYY-MM-DD\x20HH:mm:ss','include','addTags','spread','findAll','smsInteractionTags:save','removeTags','download','unix','join','root','server','tmp','files','attachments','transcript-%d-%s.zip','CmContact','firstName','lastName','secret','read','SmsAccount','Account','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','<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','N.A.','closed','closedAt','disposition','Messages','out','direction','renderFile','views','downloadInteraction.html','transcript-','.pdf','log','err','eml-format','zip-dir','request-promise','moment','bluebird','mustache'];(function(_0x14bc11,_0x37fd94){var _0x2a9521=function(_0x31fe07){while(--_0x31fe07){_0x14bc11['push'](_0x14bc11['shift']());}};_0x2a9521(++_0x37fd94);}(_0x9bde,0xe1));var _0xe9bd=function(_0x5b02d7,_0x1bfd05){_0x5b02d7=_0x5b02d7-0x0;var _0x59ccc6=_0x9bde[_0x5b02d7];return _0x59ccc6;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xe9bd('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xe9bd('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0xe9bd('0x2'));var moment=require(_0xe9bd('0x3'));var BPromise=require(_0xe9bd('0x4'));var Mustache=require(_0xe9bd('0x5'));var util=require(_0xe9bd('0x6'));var path=require(_0xe9bd('0x7'));var sox=require(_0xe9bd('0x8'));var csv=require('to-csv');var ejs=require(_0xe9bd('0x9'));var fs=require('fs');var _=require(_0xe9bd('0xa'));var squel=require(_0xe9bd('0xb'));var crypto=require(_0xe9bd('0xc'));var jsforce=require(_0xe9bd('0xd'));var deskjs=require(_0xe9bd('0xe'));var toCsv=require(_0xe9bd('0xf'));var querystring=require(_0xe9bd('0x10'));var Papa=require(_0xe9bd('0x11'));var Redis=require(_0xe9bd('0x12'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0xe9bd('0x13'));var hardwareService=require(_0xe9bd('0x14'));var logger=require(_0xe9bd('0x15'))('api');var utils=require(_0xe9bd('0x16'));var config=require(_0xe9bd('0x17'));var db=require(_0xe9bd('0x18'))['db'];config[_0xe9bd('0x19')]=_['defaults'](config[_0xe9bd('0x19')],{'host':'localhost','port':0x18eb});var socket=require(_0xe9bd('0x1a'))(new Redis(config[_0xe9bd('0x19')]));require(_0xe9bd('0x1b'))['register'](socket);function respondWithStatusCode(_0x47ba5e,_0x46a95e){_0x46a95e=_0x46a95e||0xcc;return function(_0x248818){if(_0x248818){return _0x47ba5e[_0xe9bd('0x1c')](_0x46a95e);}return _0x47ba5e[_0xe9bd('0x1d')](_0x46a95e)[_0xe9bd('0x1e')]();};}function respondWithResult(_0x389e7b,_0x45a9f2){_0x45a9f2=_0x45a9f2||0xc8;return function(_0x573350){if(_0x573350){return _0x389e7b[_0xe9bd('0x1d')](_0x45a9f2)[_0xe9bd('0x1f')](_0x573350);}};}function respondWithFilteredResult(_0x160281,_0x494b27){return function(_0x36f03d){if(_0x36f03d){var _0x3bae08=_0x36f03d[_0xe9bd('0x20')],_0x34ba2b=_0x494b27['offset'],_0x330733=_0x494b27[_0xe9bd('0x21')]+_0x494b27['limit'],_0x5cf674;if(_0x330733>=_0x3bae08){_0x330733=_0x3bae08;_0x5cf674=0xc8;}else{_0x5cf674=0xce;}_0x160281[_0xe9bd('0x1d')](_0x5cf674);return _0x160281[_0xe9bd('0x22')](_0xe9bd('0x23'),_0x34ba2b+'-'+_0x330733+'/'+_0x3bae08)[_0xe9bd('0x1f')](_0x36f03d);}return null;};}function patchUpdates(_0x1acb82){return function(_0x34ffed){try{jsonpatch[_0xe9bd('0x24')](_0x34ffed,_0x1acb82,!![]);}catch(_0x49165b){return BPromise[_0xe9bd('0x25')](_0x49165b);}return _0x34ffed[_0xe9bd('0x26')]();};}function saveUpdates(_0x4ecaf5,_0x37aec1){return function(_0x505c23){if(_0x505c23){return _0x505c23[_0xe9bd('0x27')](_0x4ecaf5)[_0xe9bd('0x28')](function(_0x36f8c0){return _0x36f8c0;});}return null;};}function removeEntity(_0xf02209,_0x5bc4bf){return function(_0x24cf25){if(_0x24cf25){return _0x24cf25[_0xe9bd('0x29')]()[_0xe9bd('0x28')](function(){_0xf02209[_0xe9bd('0x1d')](0xcc)[_0xe9bd('0x1e')]();});}};}function handleEntityNotFound(_0xb52d45,_0x399f3c){return function(_0x43ea90){if(!_0x43ea90){_0xb52d45[_0xe9bd('0x1c')](0x194);}return _0x43ea90;};}function handleError(_0x5987af,_0x3c211a){_0x3c211a=_0x3c211a||0x1f4;return function(_0x38fdfa){logger['error'](_0x38fdfa[_0xe9bd('0x2a')]);if(_0x38fdfa[_0xe9bd('0x2b')]){delete _0x38fdfa[_0xe9bd('0x2b')];}_0x5987af[_0xe9bd('0x1d')](_0x3c211a)[_0xe9bd('0x2c')](_0x38fdfa);};}function getInteractionUsers(_0x183601,_0x519f48){return new BPromise(function(_0x5b7f1d,_0x1de54c){try{if(_0x519f48[_0x183601['id']]){_0x183601['Users']=_[_0xe9bd('0x2d')](_0x519f48[_0x183601['id']],function(_0x1f2c0e){return{'id':_0x1f2c0e['id'],'fullname':_0x1f2c0e[_0xe9bd('0x2e')]};});}}catch(_0x36aa80){_0x1de54c(_0x36aa80);}_0x5b7f1d(_0x183601);});}function getInteractionTags(_0x4057df,_0x509e36){return new BPromise(function(_0x4b7bc2,_0x7f2c5){try{if(_0x4057df[_0xe9bd('0x2f')]){_0x4057df[_0xe9bd('0x30')]=[];_0x4057df[_0xe9bd('0x2f')][_0xe9bd('0x31')](',')[_0xe9bd('0x32')](function(_0x3c31ee){_0x4057df[_0xe9bd('0x30')][_0xe9bd('0x33')](_0x509e36[_0x3c31ee]);});}delete _0x4057df['TagIds'];}catch(_0x426004){_0x7f2c5(_0x426004);}_0x4b7bc2(_0x4057df);});}function updateSmsInteraction(_0x81a31f,_0x390a43,_0x5117bc){return new BPromise(function(_0x524e08,_0x25eeab){return getInteractionUsers(_0x81a31f,_0x5117bc)[_0xe9bd('0x28')](function(_0x601649){return getInteractionTags(_0x601649,_0x390a43);})[_0xe9bd('0x28')](function(_0x1dda43){_0x524e08(_0x1dda43);})[_0xe9bd('0x34')](function(_0x1e50ac){_0x25eeab(_0x1e50ac);});});}exports[_0xe9bd('0x35')]=function(_0x1a1a29,_0x32b3e3){var _0x46576b={},_0x549dd1={},_0x2ad46e={'count':0x0,'rows':[]};var _0x199477=_[_0xe9bd('0x2d')](db[_0xe9bd('0x36')][_0xe9bd('0x37')],function(_0x147da5){return{'name':_0x147da5['fieldName'],'type':_0x147da5[_0xe9bd('0x38')][_0xe9bd('0x39')]};});_0x549dd1['model']=_[_0xe9bd('0x2d')](_0x199477,_0xe9bd('0x2b'));_0x549dd1['query']=_['keys'](_0x1a1a29[_0xe9bd('0x3a')]);_0x549dd1[_0xe9bd('0x3b')]=_['intersection'](_0x549dd1[_0xe9bd('0x3c')],_0x549dd1[_0xe9bd('0x3a')]);_0x46576b[_0xe9bd('0x3d')]=_['intersection'](_0x549dd1[_0xe9bd('0x3c')],qs['fields'](_0x1a1a29[_0xe9bd('0x3a')][_0xe9bd('0x3e')]));_0x46576b[_0xe9bd('0x3d')]=_0x46576b[_0xe9bd('0x3d')]['length']?_0x46576b[_0xe9bd('0x3d')]:_0x549dd1[_0xe9bd('0x3c')];if(!_0x1a1a29[_0xe9bd('0x3a')][_0xe9bd('0x3f')](_0xe9bd('0x40'))){_0x46576b[_0xe9bd('0x41')]=qs[_0xe9bd('0x41')](_0x1a1a29[_0xe9bd('0x3a')][_0xe9bd('0x41')]);_0x46576b[_0xe9bd('0x21')]=qs['offset'](_0x1a1a29['query'][_0xe9bd('0x21')]);}_0x46576b['order']=qs[_0xe9bd('0x42')](_0x1a1a29[_0xe9bd('0x3a')][_0xe9bd('0x42')]);_0x46576b['where']=qs[_0xe9bd('0x3b')](_[_0xe9bd('0x43')](_0x1a1a29[_0xe9bd('0x3a')],_0x549dd1['filters']),_0x199477);var _0x2ef01b=[];var _0x3a5703=squel[_0xe9bd('0x44')]()[_0xe9bd('0x45')]('id')[_0xe9bd('0x45')](_0xe9bd('0x2b'))[_0xe9bd('0x45')](_0xe9bd('0x46'))[_0xe9bd('0x47')](_0xe9bd('0x48'));var _0x3817ab=squel[_0xe9bd('0x44')]()[_0xe9bd('0x45')](_0xe9bd('0x49'))[_0xe9bd('0x45')]('u.fullname')['field'](_0xe9bd('0x4a'))[_0xe9bd('0x47')](_0xe9bd('0x4b'),'ui')['left_join']('users','u',_0xe9bd('0x4c'));var _0x3f6f22=squel[_0xe9bd('0x44')]()[_0xe9bd('0x47')](_0xe9bd('0x4d'),'i')[_0xe9bd('0x4e')](_0xe9bd('0x4f'),'c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0xe9bd('0x4e')]('users','o',_0xe9bd('0x50'))[_0xe9bd('0x4e')](_0xe9bd('0x51'),'a',_0xe9bd('0x52'))[_0xe9bd('0x4e')]('sms_messages','me',_0xe9bd('0x53'))[_0xe9bd('0x4e')](_0xe9bd('0x54'),'it','it.SmsInteractionId\x20=\x20i.id')[_0xe9bd('0x4e')](_0xe9bd('0x48'),'t',_0xe9bd('0x55'));var _0x5a466b=squel[_0xe9bd('0x56')]();var _0x27e7b0=[];var _0x2e634d=squel[_0xe9bd('0x56')]();var _0x1ee09c;if(_0x1a1a29['query'][_0xe9bd('0x57')]){_0x1ee09c=as['parseSearch'](_0x1a1a29[_0xe9bd('0x3a')][_0xe9bd('0x57')]);var _0xa8d80c=_0x1ee09c[_0xe9bd('0x58')];for(var _0x194b7d=0x0;_0x194b7d<_0x1ee09c['conditions'][_0xe9bd('0x59')];_0x194b7d++){var _0x485e95=_0x1ee09c[_0xe9bd('0x5a')][_0x194b7d];var _0x222427='i';var _0x5e08ae=_['find'](_0x199477,[_0xe9bd('0x2b'),_0x485e95['field']]);if(!_0x5e08ae){switch(_0x485e95[_0xe9bd('0x45')]){case'unreadMessages':if(_0x485e95[_0xe9bd('0x5b')]==0x1){_0x3f6f22[_0xe9bd('0x5c')]('`'+_0x485e95['field']+_0xe9bd('0x5d'));}else{_0x3f6f22['having']('`'+_0x485e95[_0xe9bd('0x45')]+_0xe9bd('0x5e'));}break;case _0xe9bd('0x5f'):if(_0x485e95['operator']===_0xe9bd('0x60')){if(_0x485e95[_0xe9bd('0x5b')][_0xe9bd('0x31')]('\x20')[_0xe9bd('0x59')]>0x1){_0x5a466b[_0xa8d80c]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x485e95[_0xe9bd('0x5b')]),null);}else{var _0x493aae='%'+_0x485e95[_0xe9bd('0x5b')]+'%';_0x5a466b[_0xa8d80c](_0xe9bd('0x61'),_0x493aae,_0x493aae,_0x493aae);}}else{_0x5e08ae=_[_0xe9bd('0x62')](_0x199477,[_0xe9bd('0x2b'),_0xe9bd('0x63')]);_0x485e95[_0xe9bd('0x45')]=_0xe9bd('0x63');_0x305efa=as[_0xe9bd('0x64')](_0x222427,_0x5e08ae[_0xe9bd('0x38')],_0x485e95);_0x5a466b[_0xa8d80c](_0x305efa[_0xe9bd('0x65')],_0x305efa[_0xe9bd('0x5b')][_0xe9bd('0x66')],_0x305efa['value']['end']);}break;case'Tag':var _0x10e685=_0x485e95['value'][_0xe9bd('0x31')](',')[_0xe9bd('0x2d')](function(_0x90db01){return Number(_0x90db01);});_0x10e685[_0xe9bd('0x32')](function(_0x1c9328){_0x2e634d['or'](_0xe9bd('0x67'),'%,'+_0x1c9328+',%');});_0x27e7b0=_[_0xe9bd('0x68')](_0x27e7b0,_0x10e685);break;case _0xe9bd('0x69'):if(_0x485e95[_0xe9bd('0x6a')]==='$substring'){_0x5a466b[_0xa8d80c](_0xe9bd('0x6b'),'%'+_0x485e95[_0xe9bd('0x5b')]+'%',null);}else{_0x5e08ae=_[_0xe9bd('0x62')](_0x199477,[_0xe9bd('0x2b'),'UserId']);_0x485e95[_0xe9bd('0x45')]=_0xe9bd('0x6c');_0x305efa=as[_0xe9bd('0x64')](_0x222427,_0x5e08ae['type'],_0x485e95);_0x5a466b[_0xa8d80c](_0x305efa[_0xe9bd('0x65')],_0x305efa[_0xe9bd('0x5b')][_0xe9bd('0x66')],_0x305efa[_0xe9bd('0x5b')]['end']);}break;case'body':_0x305efa=as[_0xe9bd('0x64')]('me',null,_0x485e95);_0x5a466b[_0xa8d80c](_0x305efa[_0xe9bd('0x65')],_0x305efa[_0xe9bd('0x5b')][_0xe9bd('0x66')],_0x305efa['value']['end']);break;}}else{var _0x305efa=as[_0xe9bd('0x64')](_0x222427,_0x5e08ae[_0xe9bd('0x38')],_0x485e95);_0x5a466b[_0xa8d80c](_0x305efa[_0xe9bd('0x65')],_0x305efa[_0xe9bd('0x5b')][_0xe9bd('0x66')],_0x305efa['value'][_0xe9bd('0x1e')]);}}}else{var _0x5681ab=_(_0x1a1a29[_0xe9bd('0x3a')])[_0xe9bd('0x6d')]()[_0xe9bd('0x2d')](function(_0x436983){return _['some'](_0x199477,[_0xe9bd('0x2b'),_0x436983])?_0x436983:undefined;})[_0xe9bd('0x6e')]()[_0xe9bd('0x5b')]();if(!_['isEmpty'](_0x5681ab)){_0x5681ab[_0xe9bd('0x32')](function(_0x1a9d0c){if(_0x1a9d0c===_0xe9bd('0x6f')){_0x3f6f22[_0xe9bd('0x70')](_0xe9bd('0x71'),[][_0xe9bd('0x72')](_0x1a1a29[_0xe9bd('0x3a')][_0x1a9d0c]));}else if(_0x1a9d0c===_0xe9bd('0x73')){var _0x38e2bf=JSON[_0xe9bd('0x74')](_0x1a1a29[_0xe9bd('0x3a')][_0x1a9d0c])[_0xe9bd('0x75')];var _0x5d1e4b=JSON[_0xe9bd('0x74')](_0x1a1a29[_0xe9bd('0x3a')][_0x1a9d0c])['$lte'];_0x3f6f22[_0xe9bd('0x70')](_0xe9bd('0x76'),_0x38e2bf,_0x5d1e4b);}else{if(_0x1a1a29['query'][_0x1a9d0c]==='null'){_0x3f6f22[_0xe9bd('0x70')]('i.'+_0x1a9d0c+_0xe9bd('0x77'));}else{_0x3f6f22['where']('i.'+_0x1a9d0c+'\x20=\x20?',_0x1a1a29['query'][_0x1a9d0c]);}}});}if(_0x1a1a29[_0xe9bd('0x3a')]['read']){if(_0x1a1a29['query']['read']==0x1){_0x3f6f22['having'](_0xe9bd('0x78'));}else{_0x3f6f22[_0xe9bd('0x5c')](_0xe9bd('0x79'));}}if(_0x1a1a29['query'][_0xe9bd('0x7a')]){_0x27e7b0=_[_0xe9bd('0x7b')](_0x1a1a29[_0xe9bd('0x3a')][_0xe9bd('0x7a')])?_0x1a1a29['query'][_0xe9bd('0x7a')]:new Array(_0x1a1a29[_0xe9bd('0x3a')][_0xe9bd('0x7a')]);_0x27e7b0['forEach'](function(_0x5248fd){_0x2e634d['or'](_0xe9bd('0x67'),'%,'+_0x5248fd+',%');});}if(_0x1a1a29[_0xe9bd('0x3a')][_0xe9bd('0x7c')]){var _0x40d9e0=_0x1a1a29[_0xe9bd('0x3a')][_0xe9bd('0x7c')][_0xe9bd('0x7d')]('\x5c','\x5c\x5c')[_0xe9bd('0x7d')]('\x27\x27','\x27\x27\x27\x27');if(qs[_0xe9bd('0x7e')](_0x40d9e0)){_0x5a466b['or'](_0xe9bd('0x7f'),_0x40d9e0+'%')['or'](_0xe9bd('0x80'),_0x40d9e0+'%');}else{_0x5a466b['or'](_0xe9bd('0x81'),qs[_0xe9bd('0x82')](_0x40d9e0))['or']('CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?',_0x40d9e0+'%');}}}_0x3f6f22[_0xe9bd('0x70')](_0x5a466b);_0x3f6f22['group']('i.id');var _0x12aef8={'type':db[_0xe9bd('0x83')]['QueryTypes'][_0xe9bd('0x84')],'raw':!![]};var _0x2d1e63=_0x3f6f22[_0xe9bd('0x85')]();_0x2d1e63[_0xe9bd('0x45')]('i.id');_0x2d1e63[_0xe9bd('0x45')](_0xe9bd('0x86'),'unreadMessages');if(_0x46576b[_0xe9bd('0x87')]){_0x46576b[_0xe9bd('0x87')][_0xe9bd('0x32')](function(_0x22fd20){_0x3f6f22[_0xe9bd('0x87')]('i.'+_0x22fd20[0x0],_0x22fd20[0x1]===_0xe9bd('0x88')?![]:!![]);});}if(!_[_0xe9bd('0x89')](_0x27e7b0)){_0x3f6f22['having'](_0x2e634d);_0x2d1e63[_0xe9bd('0x70')](_0xe9bd('0x8a'),_0x27e7b0);}BPromise[_0xe9bd('0x8b')]()[_0xe9bd('0x28')](function(){if(!_0x1ee09c){if(_0x1a1a29[_0xe9bd('0x3a')][_0xe9bd('0x6f')]||_0x1a1a29[_0xe9bd('0x3a')][_0xe9bd('0x8c')])return;_0x2d1e63[_0xe9bd('0x70')]('i.SmsAccountId\x20IS\x20NOT\x20NULL');_0x3f6f22[_0xe9bd('0x70')](_0xe9bd('0x8d'));return;}return _0x1a1a29[_0xe9bd('0x8e')][_0xe9bd('0x8f')]({'attributes':['id'],'raw':!![]})[_0xe9bd('0x28')](function(_0x7354df){if(_[_0xe9bd('0x89')](_0x7354df)){_0x2d1e63['where'](_0xe9bd('0x90'));_0x3f6f22[_0xe9bd('0x70')]('i.SmsAccountId\x20IS\x20NULL');}else{_0x2d1e63[_0xe9bd('0x70')](_0xe9bd('0x71'),_[_0xe9bd('0x2d')](_0x7354df,'id'));_0x3f6f22[_0xe9bd('0x70')](_0xe9bd('0x71'),_[_0xe9bd('0x2d')](_0x7354df,'id'));}});})[_0xe9bd('0x28')](function(){db['sequelize']['query'](_0x2d1e63[_0xe9bd('0x91')](),_0x12aef8)[_0xe9bd('0x28')](function(_0x3d0163){_0x2ad46e[_0xe9bd('0x20')]=_0x3d0163[_0xe9bd('0x59')];if(_0x2ad46e[_0xe9bd('0x20')]===0x0)return[];return db[_0xe9bd('0x92')]['query'](_0x3a5703[_0xe9bd('0x91')](),_0x12aef8)[_0xe9bd('0x28')](function(_0x29833b){_0x2ef01b=_[_0xe9bd('0x93')](_0x29833b,'id');_0x12aef8=_[_0xe9bd('0x94')](_0x12aef8,{'model':db[_0xe9bd('0x36')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x1a1a29[_0xe9bd('0x3a')]['fields']){_0x46576b['attributes']['forEach'](function(_0x274e83){_0x3f6f22['field']('i.'+_0x274e83);});}else{_0x3f6f22['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0xe9bd('0x95'));_0x3f6f22[_0xe9bd('0x45')](_0xe9bd('0x96'),_0xe9bd('0x97'));_0x3f6f22[_0xe9bd('0x45')](_0xe9bd('0x98'),_0xe9bd('0x99'));_0x3f6f22[_0xe9bd('0x45')](_0xe9bd('0x9a'));_0x3f6f22['field'](_0xe9bd('0x9b'),'Contact.firstName');_0x3f6f22[_0xe9bd('0x45')](_0xe9bd('0x9c'),_0xe9bd('0x9d'));_0x3f6f22[_0xe9bd('0x45')](_0xe9bd('0x9e'),'Contact.email');_0x3f6f22['field']('c.phone',_0xe9bd('0x9f'));_0x3f6f22[_0xe9bd('0x45')]('c.mobile',_0xe9bd('0xa0'));_0x3f6f22[_0xe9bd('0x45')](_0xe9bd('0xa1'),_0xe9bd('0xa2'));_0x3f6f22[_0xe9bd('0x45')]('o.fullname',_0xe9bd('0xa3'));_0x3f6f22[_0xe9bd('0x45')](_0xe9bd('0xa4'),_0xe9bd('0xa5'));_0x3f6f22[_0xe9bd('0x45')](_0xe9bd('0xa6'),_0xe9bd('0x2f'));}if(_0x46576b[_0xe9bd('0x41')])_0x3f6f22[_0xe9bd('0x41')](_0x46576b[_0xe9bd('0x41')]);if(_0x46576b['offset'])_0x3f6f22['offset'](_0x46576b['offset']);return db['sequelize'][_0xe9bd('0x3a')](_0x3f6f22[_0xe9bd('0x91')](),_0x12aef8);})[_0xe9bd('0x28')](function(_0x4d2083){_0x3817ab[_0xe9bd('0x70')](_0xe9bd('0xa7'),_['map'](_0x4d2083,'id'));return db['sequelize'][_0xe9bd('0x3a')](_0x3817ab[_0xe9bd('0x91')](),_0x12aef8)[_0xe9bd('0x28')](function(_0x938121){var _0x23a145=_['groupBy'](_0x938121,'SmsInteractionId');var _0x499771=[];_0x4d2083[_0xe9bd('0x32')](function(_0x2c7a14){_0x499771[_0xe9bd('0x33')](updateSmsInteraction(_0x2c7a14,_0x2ef01b,_0x23a145));});return BPromise[_0xe9bd('0xa8')](_0x499771);});});})[_0xe9bd('0x28')](function(_0x351226){_0x2ad46e[_0xe9bd('0xa9')]=_0x351226;return _0x2ad46e;})[_0xe9bd('0x28')](respondWithFilteredResult(_0x32b3e3,_0x46576b));})[_0xe9bd('0x34')](handleError(_0x32b3e3,null));};exports[_0xe9bd('0xaa')]=function(_0x59a31e,_0xb1203d){var _0x5b8938={'raw':![],'where':{'id':_0x59a31e['params']['id']}},_0x116815={};_0x116815['model']=_[_0xe9bd('0x6d')](db['SmsInteraction'][_0xe9bd('0x37')]);_0x116815['query']=_[_0xe9bd('0x6d')](_0x59a31e[_0xe9bd('0x3a')]);_0x116815[_0xe9bd('0x3b')]=_[_0xe9bd('0xab')](_0x116815[_0xe9bd('0x3c')],_0x116815[_0xe9bd('0x3a')]);_0x5b8938['attributes']=_[_0xe9bd('0xab')](_0x116815[_0xe9bd('0x3c')],qs['fields'](_0x59a31e[_0xe9bd('0x3a')][_0xe9bd('0x3e')]));_0x5b8938[_0xe9bd('0x3d')]=_0x5b8938['attributes'][_0xe9bd('0x59')]?_0x5b8938[_0xe9bd('0x3d')]:_0x116815[_0xe9bd('0x3c')];if(_0x59a31e[_0xe9bd('0x3a')][_0xe9bd('0xac')]){_0x5b8938['include']=[{'all':!![]}];}_0x5b8938=_[_0xe9bd('0x94')]({},_0x5b8938,_0x59a31e[_0xe9bd('0xad')]);return db['SmsInteraction'][_0xe9bd('0x62')](_0x5b8938)[_0xe9bd('0x28')](handleEntityNotFound(_0xb1203d,null))[_0xe9bd('0x28')](respondWithResult(_0xb1203d,null))[_0xe9bd('0x34')](handleError(_0xb1203d,null));};exports['create']=function(_0x3e35ab,_0x2115d8){return db[_0xe9bd('0x36')][_0xe9bd('0xae')](_0x3e35ab[_0xe9bd('0xaf')],{})[_0xe9bd('0x28')](respondWithResult(_0x2115d8,0xc9))[_0xe9bd('0x34')](handleError(_0x2115d8,null));};exports['update']=function(_0x7c3e0a,_0x59719e){if(_0x7c3e0a[_0xe9bd('0xaf')]['id']){delete _0x7c3e0a[_0xe9bd('0xaf')]['id'];}return db[_0xe9bd('0x36')]['find']({'where':{'id':_0x7c3e0a[_0xe9bd('0xb0')]['id']}})['then'](handleEntityNotFound(_0x59719e,null))[_0xe9bd('0x28')](saveUpdates(_0x7c3e0a[_0xe9bd('0xaf')],null))[_0xe9bd('0x28')](respondWithResult(_0x59719e,null))[_0xe9bd('0x34')](handleError(_0x59719e,null));};exports[_0xe9bd('0x29')]=function(_0x2e2f30,_0x4f6a50){return db[_0xe9bd('0x36')][_0xe9bd('0x62')]({'where':{'id':_0x2e2f30[_0xe9bd('0xb0')]['id']}})[_0xe9bd('0x28')](handleEntityNotFound(_0x4f6a50,null))['then'](removeEntity(_0x4f6a50,null))[_0xe9bd('0x34')](handleError(_0x4f6a50,null));};exports[_0xe9bd('0xb1')]=function(_0x261af6,_0x5dad5e){return db[_0xe9bd('0x36')][_0xe9bd('0xb1')]()['then'](respondWithResult(_0x5dad5e,null))['catch'](handleError(_0x5dad5e,null));};exports['addMessage']=function(_0x52df8f,_0x458bff,_0x3b32a9){return db[_0xe9bd('0xb2')]['find']({'where':{'id':_0x52df8f[_0xe9bd('0xb0')]['id']}})[_0xe9bd('0x28')](handleEntityNotFound(_0x458bff,null))['then'](function(_0x8b7a95){if(_0x8b7a95){return _0x8b7a95[_0xe9bd('0xb3')](_0x52df8f[_0xe9bd('0xaf')][_0xe9bd('0xb4')],_[_0xe9bd('0xb5')](_0x52df8f['body'],[_0xe9bd('0xb4'),'id'])||{});}})[_0xe9bd('0x28')](respondWithResult(_0x458bff,null))['catch'](handleError(_0x458bff,null));};exports['getMessages']=function(_0x54ffbd,_0x4fbbd6,_0x411ae0){var _0x26b67a={'raw':![],'where':{}};var _0x365b7f={};var _0xae352d={'count':0x0,'rows':[]};return db['SmsInteraction']['findOne']({'where':{'id':_0x54ffbd[_0xe9bd('0xb0')]['id']}})[_0xe9bd('0x28')](handleEntityNotFound(_0x4fbbd6,null))[_0xe9bd('0x28')](function(_0x4ee46c){if(_0x4ee46c){_0x365b7f[_0xe9bd('0x3c')]=_[_0xe9bd('0x6d')](db['SmsMessage']['rawAttributes']);_0x365b7f[_0xe9bd('0x3a')]=_[_0xe9bd('0x6d')](_0x54ffbd[_0xe9bd('0x3a')]);_0x365b7f[_0xe9bd('0x3b')]=_[_0xe9bd('0xab')](_0x365b7f[_0xe9bd('0x3c')],_0x365b7f[_0xe9bd('0x3a')]);_0x26b67a[_0xe9bd('0x3d')]=_[_0xe9bd('0xab')](_0x365b7f['model'],qs[_0xe9bd('0x3e')](_0x54ffbd[_0xe9bd('0x3a')][_0xe9bd('0x3e')]));_0x26b67a[_0xe9bd('0x3d')]=_0x26b67a[_0xe9bd('0x3d')][_0xe9bd('0x59')]?_0x26b67a['attributes']:_0x365b7f[_0xe9bd('0x3c')];if(!_0x54ffbd['query'][_0xe9bd('0x3f')]('nolimit')){_0x26b67a[_0xe9bd('0x41')]=qs[_0xe9bd('0x41')](_0x54ffbd['query'][_0xe9bd('0x41')]);_0x26b67a[_0xe9bd('0x21')]=qs['offset'](_0x54ffbd[_0xe9bd('0x3a')][_0xe9bd('0x21')]);}_0x26b67a[_0xe9bd('0x87')]=qs[_0xe9bd('0x42')](_0x54ffbd['query'][_0xe9bd('0x42')]);_0x26b67a[_0xe9bd('0x70')]=qs['filters'](_[_0xe9bd('0x43')](_0x54ffbd[_0xe9bd('0x3a')],_0x365b7f[_0xe9bd('0x3b')]));_0x26b67a['where'][_0xe9bd('0xb6')]=_0x4ee46c['id'];if(_0x54ffbd[_0xe9bd('0x3a')][_0xe9bd('0x7c')]){_0x26b67a[_0xe9bd('0x70')]=_[_0xe9bd('0x94')](_0x26b67a[_0xe9bd('0x70')],{'$or':_[_0xe9bd('0x2d')](_0x26b67a['attributes'],function(_0x121498){var _0x2e1c0f={};_0x2e1c0f[_0x121498]={'$like':'%'+_0x54ffbd[_0xe9bd('0x3a')]['filter']+'%'};return _0x2e1c0f;})});}if(_0x54ffbd[_0xe9bd('0x3a')]['$gte']){var _0x5ba105=_0x54ffbd['query'][_0xe9bd('0x75')]['split'](',');var _0x516080={};_0x516080[_0x5ba105[0x0]]={'$gte':moment(_0x5ba105[0x1])[_0xe9bd('0xb7')](_0xe9bd('0xb8'))};_0x26b67a['where']=_[_0xe9bd('0x94')](_0x26b67a[_0xe9bd('0x70')],_0x516080);}_0x26b67a=_['merge']({},_0x26b67a,_0x54ffbd['options']);return db[_0xe9bd('0xb2')]['count']({'where':_0x26b67a['where']})[_0xe9bd('0x28')](function(_0x1771b1){_0xae352d[_0xe9bd('0x20')]=_0x1771b1;if(_0x54ffbd[_0xe9bd('0x3a')][_0xe9bd('0xac')]){_0x26b67a[_0xe9bd('0xb9')]=[{'all':!![]}];}return db[_0xe9bd('0xb2')]['findAll'](_0x26b67a);})[_0xe9bd('0x28')](function(_0x521dec){_0xae352d['rows']=_0x521dec;return _0xae352d;});}})[_0xe9bd('0x28')](respondWithFilteredResult(_0x4fbbd6,_0x26b67a))[_0xe9bd('0x34')](handleError(_0x4fbbd6,null));};exports[_0xe9bd('0xba')]=function(_0x3d168b,_0x3e5f25,_0x55dc1d){return db[_0xe9bd('0x36')][_0xe9bd('0x62')]({'where':{'id':_0x3d168b[_0xe9bd('0xb0')]['id']}})[_0xe9bd('0x28')](handleEntityNotFound(_0x3e5f25,null))[_0xe9bd('0x28')](function(_0x1279a9){if(_0x1279a9){return _0x1279a9['setTags'](_0x3d168b[_0xe9bd('0xaf')][_0xe9bd('0xb4')],_[_0xe9bd('0xb5')](_0x3d168b[_0xe9bd('0xaf')],[_0xe9bd('0xb4'),'id'])||{})[_0xe9bd('0xbb')](function(){return db['Tag'][_0xe9bd('0xbc')]({'attributes':['id',_0xe9bd('0x2b'),'color'],'where':{'id':_0x3d168b[_0xe9bd('0xaf')][_0xe9bd('0xb4')]}});})[_0xe9bd('0x28')](function(_0x1e63d3){socket['emit'](_0xe9bd('0xbd'),{'id':Number(_0x3d168b[_0xe9bd('0xb0')]['id']),'tags':_0x1e63d3||[]});return{'id':Number(_0x3d168b[_0xe9bd('0xb0')]['id']),'tags':_0x1e63d3||[]};});}})[_0xe9bd('0x28')](respondWithResult(_0x3e5f25,null))[_0xe9bd('0x34')](handleError(_0x3e5f25,null));};exports[_0xe9bd('0xbe')]=function(_0x43557b,_0x1940e7,_0x41506b){return db['SmsInteraction'][_0xe9bd('0x62')]({'where':{'id':_0x43557b[_0xe9bd('0xb0')]['id']}})[_0xe9bd('0x28')](handleEntityNotFound(_0x1940e7,null))[_0xe9bd('0x28')](function(_0x1e25e8){if(_0x1e25e8){return _0x1e25e8[_0xe9bd('0xbe')](_0x43557b[_0xe9bd('0x3a')]['ids']);}})[_0xe9bd('0x28')](respondWithStatusCode(_0x1940e7,null))['catch'](handleError(_0x1940e7,null));};exports[_0xe9bd('0xbf')]=function(_0xbc686e,_0x2db271){var _0x1c2d6d=moment()[_0xe9bd('0xc0')]()[_0xe9bd('0x91')]();var _0x5bf65b=path[_0xe9bd('0xc1')](config[_0xe9bd('0xc2')],_0xe9bd('0xc3'),'files',_0xe9bd('0xc4'));var _0x2c3474=path[_0xe9bd('0xc1')](config[_0xe9bd('0xc2')],_0xe9bd('0xc3'),_0xe9bd('0xc5'),_0xe9bd('0xc6'));var _0x1c3af9=path[_0xe9bd('0xc1')](_0x5bf65b,_0x1c2d6d);var _0x3b0874=util['format'](_0xe9bd('0xc7'),_0xbc686e[_0xe9bd('0xb0')]['id'],_0x1c2d6d);var _0x31aae8=path['join'](_0x5bf65b,_0x3b0874);var _0x28a6b6=[];_0x28a6b6[_0xe9bd('0x33')]({'model':db[_0xe9bd('0x69')],'as':'User','attributes':['id','fullname'],'raw':!![]});_0x28a6b6[_0xe9bd('0x33')]({'model':db[_0xe9bd('0xc8')],'as':_0xe9bd('0x5f'),'attributes':['id',_0xe9bd('0xc9'),_0xe9bd('0xca')],'raw':!![]});var _0x464102=[{'model':db[_0xe9bd('0xb2')],'as':'Messages','attributes':['id',_0xe9bd('0xaf'),_0xe9bd('0x73'),'direction',_0xe9bd('0xcb'),_0xe9bd('0xcc')],'include':_0x28a6b6}];_0x464102[_0xe9bd('0x33')]({'model':db[_0xe9bd('0xcd')],'as':_0xe9bd('0xce'),'attributes':['id',_0xe9bd('0x2b')]});_0x464102[_0xe9bd('0x33')]({'model':db[_0xe9bd('0x69')],'as':_0xe9bd('0xcf'),'attributes':['id',_0xe9bd('0x2e')]});return db[_0xe9bd('0x36')][_0xe9bd('0x62')]({'where':{'id':_0xbc686e[_0xe9bd('0xb0')]['id']},'include':_0x464102})[_0xe9bd('0x28')](handleEntityNotFound(_0x2db271,null))[_0xe9bd('0x28')](function(_0x58f68a){if(_0x58f68a){var _0x17c8e8=_0x58f68a[_0xe9bd('0xd0')]({'plain':!![]});fs[_0xe9bd('0xd1')](_0x1c3af9);var _0x1b159a={'format':'A4','border':_0xe9bd('0xd2'),'header':{'height':'40px','contents':{'first':_0xe9bd('0xd3')}},'footer':{'height':_0xe9bd('0xd4'),'contents':{'default':util[_0xe9bd('0xb7')](_0xe9bd('0xd5'),util[_0xe9bd('0xb7')](_0xe9bd('0xd6'),_0xe9bd('0xd7'),_0x17c8e8['id']),moment()[_0xe9bd('0xb7')](_0xe9bd('0xd8'))[_0xe9bd('0x91')]())}}};var _0x2a8861={'channel':_0xe9bd('0xd7'),'account':_0x17c8e8[_0xe9bd('0xce')]['name'],'agent':_0x17c8e8[_0xe9bd('0xcf')]?_0x17c8e8[_0xe9bd('0xcf')][_0xe9bd('0x2e')]:_0xe9bd('0xd9'),'createdAt':moment(_0x17c8e8[_0xe9bd('0x73')])[_0xe9bd('0xb7')](_0xe9bd('0xb8'))[_0xe9bd('0x91')](),'closedAt':_0x17c8e8[_0xe9bd('0xda')]?moment(_0x17c8e8[_0xe9bd('0xdb')])[_0xe9bd('0xb7')](_0xe9bd('0xb8'))['toString']():'','disposition':_0x17c8e8[_0xe9bd('0xdc')],'messages':_(_0x17c8e8[_0xe9bd('0xdd')])[_0xe9bd('0x7c')]({'secret':![]})[_0xe9bd('0x2d')](function(_0x1958fa){return{'date':moment(_0x1958fa['createdAt'])[_0xe9bd('0xb7')](_0xe9bd('0xb8'))[_0xe9bd('0x91')](),'sender':_0x1958fa['direction']===_0xe9bd('0xde')?_0x1958fa[_0xe9bd('0x69')]?_0x1958fa['User']['fullname']:'System':_0x1958fa[_0xe9bd('0x5f')][_0xe9bd('0xc9')]+(_0x1958fa['Contact'][_0xe9bd('0xca')]?'\x20'+_0x1958fa[_0xe9bd('0x5f')][_0xe9bd('0xca')]:''),'body':_0x1958fa['body'],'direction':_0x1958fa[_0xe9bd('0xdf')]===_0xe9bd('0xde')?'A':'C','secret':_0x1958fa[_0xe9bd('0xcb')],'read':_0x1958fa[_0xe9bd('0xcc')]};})['value']()};return ejs[_0xe9bd('0xe0')](path[_0xe9bd('0xc1')](config['root'],_0xe9bd('0xc3'),_0xe9bd('0xe1'),_0xe9bd('0xe2')),{'interaction':_0x2a8861})[_0xe9bd('0x28')](function(_0x5103d0){return new BPromise(function(_0x4b381e,_0x5bad39){pdf[_0xe9bd('0xae')](_0x5103d0,_0x1b159a)['toFile'](path[_0xe9bd('0xc1')](_0x1c3af9,_0xe9bd('0xe3')+_0x17c8e8['id']+'-'+_0x1c2d6d+_0xe9bd('0xe4')),function(_0x41b16f,_0x1d5b7e){if(_0x41b16f)return _0x5bad39(_0x41b16f);_0x4b381e(_0x1d5b7e);});});})[_0xe9bd('0x28')](function(){return new BPromise(function(_0x53b73c,_0x117c16){zipdir(_0x1c3af9,{'saveTo':_0x31aae8},function(_0x389b87,_0x39cf76){if(_0x389b87)return _0x117c16(_0x389b87);return _0x53b73c(_0x39cf76);});})[_0xe9bd('0x28')](function(){return new BPromise(function(_0x30f512,_0x27740c){rimraf(_0x1c3af9,function(_0x25def7){if(_0x25def7)_0x27740c(_0x25def7);return _0x30f512();});});})['then'](function(){return _0x2db271[_0xe9bd('0xbf')](_0x31aae8,_0x3b0874,function(_0x40abfd){if(_0x40abfd){console[_0xe9bd('0xe5')](_0xe9bd('0xe6'),_0x40abfd);}else{fs['unlinkSync'](_0x31aae8);}});});});}else{return _0x2db271[_0xe9bd('0x1c')](0xc8);}})[_0xe9bd('0x34')](handleError(_0x2db271,null));};
git://repos.xcallymotion.com / motion2.git / blob