Built motion from commit (unavailable).|2.5.23
[motion2.git] / server / api / smsInteraction / smsInteraction.controller.js
index b19cff3..35c022e 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x786a=['Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','Owner.fullname','ui.SmsInteractionId\x20IN\x20?','groupBy','SmsInteractionId','all','rows','show','params','includeAll','include','options','create','body','describe','addMessage','SmsMessage','ids','omit','getMessages','format','findAll','setTags','spread','emit','removeTags','download','unix','join','root','server','files','tmp','attachments','firstName','lastName','Messages','direction','Account','Owner','fullname','get','10px','40px','<div\x20class=\x22header\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<h5>Interaction\x20Transcript</h5>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>','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','N.A.','YYYY-MM-DD\x20HH:mm:ss','closed','disposition','out','System','secret','renderFile','views','downloadInteraction.html','toFile','transcript-','.pdf','log','err','unlinkSync','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','lodash','crypto','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','../../config/license/util','redis','localhost','./smsInteraction.socket','register','sendStatus','status','offset','Content-Range','json','reject','save','update','then','destroy','end','error','stack','name','Users','map','TagIds','Tags','push','catch','index','SmsInteraction','rawAttributes','fieldName','type','key','query','keys','filters','intersection','model','fields','attributes','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','select','field','color','from','tools_tags','u.id','u.fullname','ui.SmsInteractionId','left_join','sms_interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','users','o.id\x20=\x20i.UserId','sms_accounts','a.id\x20=\x20i.SmsAccountId','sms_messages','me.SmsInteractionId\x20=\x20i.id','it.SmsInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','find','unreadMessages','value','having','`\x20>\x200','Contact','$substring','split','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','start','forEach','union','User','operator','UserId','text','buildExpression','some','isEmpty','SmsAccountId','i.SmsAccountId\x20IN\x20?','createdAt','parse','$gte','$lte','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','filter','replace','isNumeric','i.id\x20LIKE\x20?','i.phone\x20LIKE\x20?','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','group','i.id','Sequelize','QueryTypes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','contactName','t.id\x20IN\x20?','resolve','i.SmsAccountId\x20IS\x20NOT\x20NULL','role','agent','user','getSmsAccounts','i.SmsAccountId\x20IS\x20NULL','sequelize','toString','count','keyBy','merge','a.key','Account.key','Account.mandatoryDisposition','CASE\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','i.*','Contact.firstName','c.lastName','Contact.lastName','Contact.email'];(function(_0x32e8f2,_0x33cff3){var _0xefd2e6=function(_0x524abd){while(--_0x524abd){_0x32e8f2['push'](_0x32e8f2['shift']());}};_0xefd2e6(++_0x33cff3);}(_0x786a,0x12c));var _0xa786=function(_0x3cdb2d,_0x44b111){_0x3cdb2d=_0x3cdb2d-0x0;var _0x148250=_0x786a[_0x3cdb2d];return _0x148250;};'use strict';var pdf=require(_0xa786('0x0'));var emlformat=require(_0xa786('0x1'));var rimraf=require(_0xa786('0x2'));var zipdir=require(_0xa786('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0xa786('0x4'));var moment=require(_0xa786('0x5'));var BPromise=require(_0xa786('0x6'));var Mustache=require(_0xa786('0x7'));var util=require(_0xa786('0x8'));var path=require(_0xa786('0x9'));var sox=require('sox');var csv=require(_0xa786('0xa'));var ejs=require(_0xa786('0xb'));var fs=require('fs');var _=require(_0xa786('0xc'));var squel=require('squel');var crypto=require(_0xa786('0xd'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xa786('0xa'));var querystring=require(_0xa786('0xe'));var Papa=require(_0xa786('0xf'));var Redis=require(_0xa786('0x10'));var authService=require(_0xa786('0x11'));var qs=require(_0xa786('0x12'));var as=require(_0xa786('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xa786('0x14'))(_0xa786('0x15'));var utils=require('../../config/utils');var config=require(_0xa786('0x16'));var licenseUtil=require(_0xa786('0x17'));var db=require('../../mysqldb')['db'];config[_0xa786('0x18')]=_['defaults'](config['redis'],{'host':_0xa786('0x19'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xa786('0x18')]));require(_0xa786('0x1a'))[_0xa786('0x1b')](socket);function respondWithStatusCode(_0x325965,_0x4404eb){_0x4404eb=_0x4404eb||0xcc;return function(_0x13fe19){if(_0x13fe19){return _0x325965[_0xa786('0x1c')](_0x4404eb);}return _0x325965[_0xa786('0x1d')](_0x4404eb)['end']();};}function respondWithResult(_0x392ac8,_0x4195f3){_0x4195f3=_0x4195f3||0xc8;return function(_0x2b2f0e){if(_0x2b2f0e){return _0x392ac8[_0xa786('0x1d')](_0x4195f3)['json'](_0x2b2f0e);}};}function respondWithFilteredResult(_0xf84ab9,_0x2e2ca9){return function(_0xc4616){if(_0xc4616){var _0xe2985c=_0xc4616['count'],_0x3e544c=_0x2e2ca9[_0xa786('0x1e')],_0x26769b=_0x2e2ca9[_0xa786('0x1e')]+_0x2e2ca9['limit'],_0x53f69c;if(_0x26769b>=_0xe2985c){_0x26769b=_0xe2985c;_0x53f69c=0xc8;}else{_0x53f69c=0xce;}_0xf84ab9['status'](_0x53f69c);return _0xf84ab9['set'](_0xa786('0x1f'),_0x3e544c+'-'+_0x26769b+'/'+_0xe2985c)[_0xa786('0x20')](_0xc4616);}return null;};}function patchUpdates(_0x1b6943){return function(_0x1fa84a){try{jsonpatch['apply'](_0x1fa84a,_0x1b6943,!![]);}catch(_0x513001){return BPromise[_0xa786('0x21')](_0x513001);}return _0x1fa84a[_0xa786('0x22')]();};}function saveUpdates(_0x5c19f0,_0x1e7536){return function(_0x1404b5){if(_0x1404b5){return _0x1404b5[_0xa786('0x23')](_0x5c19f0)[_0xa786('0x24')](function(_0x36329b){return _0x36329b;});}return null;};}function removeEntity(_0xf97a74,_0x285209){return function(_0x59efc4){if(_0x59efc4){return _0x59efc4[_0xa786('0x25')]()['then'](function(){_0xf97a74[_0xa786('0x1d')](0xcc)[_0xa786('0x26')]();});}};}function handleEntityNotFound(_0x484498,_0x28f514){return function(_0x502f25){if(!_0x502f25){_0x484498[_0xa786('0x1c')](0x194);}return _0x502f25;};}function handleError(_0x3e89a8,_0x17264e){_0x17264e=_0x17264e||0x1f4;return function(_0xd594e6){logger[_0xa786('0x27')](_0xd594e6[_0xa786('0x28')]);if(_0xd594e6[_0xa786('0x29')]){delete _0xd594e6[_0xa786('0x29')];}_0x3e89a8['status'](_0x17264e)['send'](_0xd594e6);};}function getInteractionUsers(_0x5d6e1a,_0x1f1bae){return new BPromise(function(_0xa4df48,_0x3c03b7){try{if(_0x1f1bae[_0x5d6e1a['id']]){_0x5d6e1a[_0xa786('0x2a')]=_[_0xa786('0x2b')](_0x1f1bae[_0x5d6e1a['id']],function(_0x1bebd3){return{'id':_0x1bebd3['id'],'fullname':_0x1bebd3['fullname']};});}}catch(_0xa8efaf){_0x3c03b7(_0xa8efaf);}_0xa4df48(_0x5d6e1a);});}function getInteractionTags(_0x2506fb,_0x11743d){return new BPromise(function(_0x15b05a,_0x505480){try{if(_0x2506fb[_0xa786('0x2c')]){_0x2506fb[_0xa786('0x2d')]=[];_0x2506fb['TagIds']['split'](',')['forEach'](function(_0x218166){_0x2506fb[_0xa786('0x2d')][_0xa786('0x2e')](_0x11743d[_0x218166]);});}delete _0x2506fb[_0xa786('0x2c')];}catch(_0x1cc9c9){_0x505480(_0x1cc9c9);}_0x15b05a(_0x2506fb);});}function updateSmsInteraction(_0x4da4cb,_0x2b040f,_0x5987d1){return new BPromise(function(_0x2fda0e,_0x37cc45){return getInteractionUsers(_0x4da4cb,_0x5987d1)[_0xa786('0x24')](function(_0x5aecdd){return getInteractionTags(_0x5aecdd,_0x2b040f);})[_0xa786('0x24')](function(_0x1504e9){_0x2fda0e(_0x1504e9);})[_0xa786('0x2f')](function(_0x296eb8){_0x37cc45(_0x296eb8);});});}exports[_0xa786('0x30')]=function(_0x469d5f,_0x156554){var _0x2ea3fa={},_0x1f85af={},_0x8e8d42={'count':0x0,'rows':[]};var _0x2eca21=_[_0xa786('0x2b')](db[_0xa786('0x31')][_0xa786('0x32')],function(_0x3172ff){return{'name':_0x3172ff[_0xa786('0x33')],'type':_0x3172ff[_0xa786('0x34')][_0xa786('0x35')]};});_0x1f85af['model']=_[_0xa786('0x2b')](_0x2eca21,_0xa786('0x29'));_0x1f85af[_0xa786('0x36')]=_[_0xa786('0x37')](_0x469d5f[_0xa786('0x36')]);_0x1f85af[_0xa786('0x38')]=_[_0xa786('0x39')](_0x1f85af[_0xa786('0x3a')],_0x1f85af[_0xa786('0x36')]);_0x2ea3fa['attributes']=_[_0xa786('0x39')](_0x1f85af[_0xa786('0x3a')],qs[_0xa786('0x3b')](_0x469d5f['query']['fields']));_0x2ea3fa[_0xa786('0x3c')]=_0x2ea3fa[_0xa786('0x3c')][_0xa786('0x3d')]?_0x2ea3fa[_0xa786('0x3c')]:_0x1f85af['model'];if(!_0x469d5f[_0xa786('0x36')][_0xa786('0x3e')](_0xa786('0x3f'))){_0x2ea3fa[_0xa786('0x40')]=qs['limit'](_0x469d5f[_0xa786('0x36')][_0xa786('0x40')]);_0x2ea3fa[_0xa786('0x1e')]=qs['offset'](_0x469d5f['query'][_0xa786('0x1e')]);}_0x2ea3fa[_0xa786('0x41')]=qs[_0xa786('0x42')](_0x469d5f[_0xa786('0x36')][_0xa786('0x42')]);_0x2ea3fa[_0xa786('0x43')]=qs[_0xa786('0x38')](_[_0xa786('0x44')](_0x469d5f[_0xa786('0x36')],_0x1f85af[_0xa786('0x38')]),_0x2eca21);var _0x244dd6=[];var _0x308be9=squel[_0xa786('0x45')]()[_0xa786('0x46')]('id')[_0xa786('0x46')]('name')[_0xa786('0x46')](_0xa786('0x47'))[_0xa786('0x48')](_0xa786('0x49'));var _0xb0cd26=squel[_0xa786('0x45')]()[_0xa786('0x46')](_0xa786('0x4a'))[_0xa786('0x46')](_0xa786('0x4b'))['field'](_0xa786('0x4c'))[_0xa786('0x48')]('user_has_sms_interactions','ui')[_0xa786('0x4d')]('users','u','u.id\x20=\x20ui.UserId');var _0x25a1aa=squel['select']()[_0xa786('0x48')](_0xa786('0x4e'),'i')['left_join'](_0xa786('0x4f'),'c',_0xa786('0x50'))[_0xa786('0x4d')](_0xa786('0x51'),'o',_0xa786('0x52'))[_0xa786('0x4d')](_0xa786('0x53'),'a',_0xa786('0x54'))[_0xa786('0x4d')](_0xa786('0x55'),'me',_0xa786('0x56'))[_0xa786('0x4d')]('sms_interaction_has_tags','it',_0xa786('0x57'))[_0xa786('0x4d')](_0xa786('0x49'),'t',_0xa786('0x58'));var _0x1c908a=squel[_0xa786('0x59')]();var _0x4da4ff=[];var _0x2f2de6=squel['expr']();var _0x5989aa;if(_0x469d5f[_0xa786('0x36')][_0xa786('0x5a')]){_0x5989aa=as[_0xa786('0x5b')](_0x469d5f[_0xa786('0x36')]['search']);var _0x3756e6=_0x5989aa[_0xa786('0x5c')];for(var _0x4f4d6d=0x0;_0x4f4d6d<_0x5989aa['conditions'][_0xa786('0x3d')];_0x4f4d6d++){var _0x4395fc=_0x5989aa[_0xa786('0x5d')][_0x4f4d6d];var _0x338cf3='i';var _0xb5ebfa=_[_0xa786('0x5e')](_0x2eca21,[_0xa786('0x29'),_0x4395fc[_0xa786('0x46')]]);if(!_0xb5ebfa){switch(_0x4395fc[_0xa786('0x46')]){case _0xa786('0x5f'):if(_0x4395fc[_0xa786('0x60')]==0x1){_0x25a1aa[_0xa786('0x61')]('`'+_0x4395fc['field']+'`\x20=\x200');}else{_0x25a1aa[_0xa786('0x61')]('`'+_0x4395fc['field']+_0xa786('0x62'));}break;case _0xa786('0x63'):if(_0x4395fc['operator']===_0xa786('0x64')){if(_0x4395fc[_0xa786('0x60')][_0xa786('0x65')]('\x20')[_0xa786('0x3d')]>0x1){_0x1c908a[_0x3756e6]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xa786('0x66')](_0x4395fc[_0xa786('0x60')]),null);}else{var _0x3a2cd9='%'+_0x4395fc[_0xa786('0x60')]+'%';_0x1c908a[_0x3756e6](_0xa786('0x67'),_0x3a2cd9,_0x3a2cd9,_0x3a2cd9);}}else{_0xb5ebfa=_[_0xa786('0x5e')](_0x2eca21,[_0xa786('0x29'),_0xa786('0x68')]);_0x4395fc[_0xa786('0x46')]=_0xa786('0x68');_0x46af59=as['buildExpression'](_0x338cf3,_0xb5ebfa[_0xa786('0x34')],_0x4395fc);_0x1c908a[_0x3756e6](_0x46af59['text'],_0x46af59[_0xa786('0x60')][_0xa786('0x69')],_0x46af59[_0xa786('0x60')][_0xa786('0x26')]);}break;case'Tag':var _0x337b33=_0x4395fc['value'][_0xa786('0x65')](',')['map'](function(_0xc7ee74){return Number(_0xc7ee74);});_0x337b33[_0xa786('0x6a')](function(_0x341a63){_0x2f2de6['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x341a63+',%');});_0x4da4ff=_[_0xa786('0x6b')](_0x4da4ff,_0x337b33);break;case _0xa786('0x6c'):if(_0x4395fc[_0xa786('0x6d')]===_0xa786('0x64')){_0x1c908a[_0x3756e6]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x4395fc['value']+'%',null);}else{_0xb5ebfa=_[_0xa786('0x5e')](_0x2eca21,[_0xa786('0x29'),_0xa786('0x6e')]);_0x4395fc[_0xa786('0x46')]=_0xa786('0x6e');_0x46af59=as['buildExpression'](_0x338cf3,_0xb5ebfa[_0xa786('0x34')],_0x4395fc);_0x1c908a[_0x3756e6](_0x46af59[_0xa786('0x6f')],_0x46af59[_0xa786('0x60')][_0xa786('0x69')],_0x46af59[_0xa786('0x60')][_0xa786('0x26')]);}break;case'body':_0x46af59=as[_0xa786('0x70')]('me',null,_0x4395fc);_0x1c908a[_0x3756e6](_0x46af59[_0xa786('0x6f')],_0x46af59[_0xa786('0x60')][_0xa786('0x69')],_0x46af59[_0xa786('0x60')]['end']);break;}}else{var _0x46af59=as[_0xa786('0x70')](_0x338cf3,_0xb5ebfa[_0xa786('0x34')],_0x4395fc);_0x1c908a[_0x3756e6](_0x46af59[_0xa786('0x6f')],_0x46af59[_0xa786('0x60')][_0xa786('0x69')],_0x46af59[_0xa786('0x60')][_0xa786('0x26')]);}}}else{var _0x2a5e41=_(_0x469d5f['query'])['keys']()['map'](function(_0x45199e){return _[_0xa786('0x71')](_0x2eca21,['name',_0x45199e])?_0x45199e:undefined;})['compact']()[_0xa786('0x60')]();if(!_[_0xa786('0x72')](_0x2a5e41)){_0x2a5e41[_0xa786('0x6a')](function(_0x44aef4){if(_0x44aef4===_0xa786('0x73')){_0x25a1aa[_0xa786('0x43')](_0xa786('0x74'),[]['concat'](_0x469d5f[_0xa786('0x36')][_0x44aef4]));}else if(_0x44aef4===_0xa786('0x75')){var _0x339ecb=JSON[_0xa786('0x76')](_0x469d5f[_0xa786('0x36')][_0x44aef4])[_0xa786('0x77')];var _0x1f95d1=JSON['parse'](_0x469d5f[_0xa786('0x36')][_0x44aef4])[_0xa786('0x78')];_0x25a1aa[_0xa786('0x43')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x339ecb,_0x1f95d1);}else{if(_0x469d5f[_0xa786('0x36')][_0x44aef4]===_0xa786('0x79')){_0x25a1aa[_0xa786('0x43')]('i.'+_0x44aef4+_0xa786('0x7a'));}else{_0x25a1aa['where']('i.'+_0x44aef4+_0xa786('0x7b'),_0x469d5f[_0xa786('0x36')][_0x44aef4]);}}});}if(_0x469d5f['query']['read']){if(_0x469d5f[_0xa786('0x36')][_0xa786('0x7c')]==0x1){_0x25a1aa[_0xa786('0x61')](_0xa786('0x7d'));}else{_0x25a1aa['having'](_0xa786('0x7e'));}}if(_0x469d5f[_0xa786('0x36')][_0xa786('0x7f')]){_0x4da4ff=_['isArray'](_0x469d5f[_0xa786('0x36')][_0xa786('0x7f')])?_0x469d5f[_0xa786('0x36')][_0xa786('0x7f')]:new Array(_0x469d5f[_0xa786('0x36')][_0xa786('0x7f')]);_0x4da4ff[_0xa786('0x6a')](function(_0x3e035f){_0x2f2de6['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x3e035f+',%');});}if(_0x469d5f[_0xa786('0x36')]['filter']){var _0x5040a6=_0x469d5f[_0xa786('0x36')][_0xa786('0x80')][_0xa786('0x81')]('\x5c','\x5c\x5c')[_0xa786('0x81')](/'/g,'\x27\x27');if(qs[_0xa786('0x82')](_0x5040a6)){_0x1c908a['or'](_0xa786('0x83'),_0x5040a6+'%')['or'](_0xa786('0x84'),_0x5040a6+'%');}else{_0x1c908a['or']('MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x5040a6))['or'](_0xa786('0x85'),_0x5040a6+'%');}}}_0x25a1aa[_0xa786('0x43')](_0x1c908a);_0x25a1aa[_0xa786('0x86')](_0xa786('0x87'));var _0x35c45e={'type':db[_0xa786('0x88')][_0xa786('0x89')]['SELECT'],'raw':!![]};var _0xfe6715=_0x25a1aa['clone']();_0xfe6715[_0xa786('0x46')]('i.id');_0xfe6715[_0xa786('0x46')](_0xa786('0x8a'),_0xa786('0x5f'));if(_0x2ea3fa[_0xa786('0x41')]){_0x2ea3fa['order'][_0xa786('0x6a')](function(_0x551415){var _0xaab979=_0x551415[0x0]===_0xa786('0x8b')?_0x551415[0x0]:'i.'+_0x551415[0x0];_0x25a1aa[_0xa786('0x41')](_0xaab979,_0x551415[0x1]==='DESC'?![]:!![]);});}if(!_[_0xa786('0x72')](_0x4da4ff)){_0x25a1aa[_0xa786('0x61')](_0x2f2de6);_0xfe6715['where'](_0xa786('0x8c'),_0x4da4ff);}BPromise[_0xa786('0x8d')]()[_0xa786('0x24')](function(){if(!_0x5989aa){if(_0x469d5f['query'][_0xa786('0x73')])return;_0xfe6715['where']('i.SmsAccountId\x20IS\x20NOT\x20NULL');_0x25a1aa['where'](_0xa786('0x8e'));return;}if(_0x469d5f['user'][_0xa786('0x8f')]!==_0xa786('0x90'))return;return _0x469d5f[_0xa786('0x91')][_0xa786('0x92')]({'attributes':['id'],'raw':!![]})[_0xa786('0x24')](function(_0x427cf0){if(_[_0xa786('0x72')](_0x427cf0)){_0xfe6715[_0xa786('0x43')](_0xa786('0x93'));_0x25a1aa['where'](_0xa786('0x93'));}else{_0xfe6715[_0xa786('0x43')](_0xa786('0x74'),_['map'](_0x427cf0,'id'));_0x25a1aa['where'](_0xa786('0x74'),_['map'](_0x427cf0,'id'));}});})['then'](function(){if(_0x469d5f[_0xa786('0x91')][_0xa786('0x8f')]===_0xa786('0x90')&&!_0x5989aa&&!_0x469d5f[_0xa786('0x36')][_0xa786('0x73')])return[];return db[_0xa786('0x94')]['query'](_0xfe6715[_0xa786('0x95')](),_0x35c45e);})[_0xa786('0x24')](function(_0x1ee07){_0x8e8d42['count']=_0x1ee07[_0xa786('0x3d')];if(_0x8e8d42[_0xa786('0x96')]===0x0)return[];return db[_0xa786('0x94')][_0xa786('0x36')](_0x308be9[_0xa786('0x95')](),_0x35c45e)['then'](function(_0x3faff6){_0x244dd6=_[_0xa786('0x97')](_0x3faff6,'id');_0x35c45e=_[_0xa786('0x98')](_0x35c45e,{'model':db[_0xa786('0x31')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x469d5f['query'][_0xa786('0x3b')]){_0x2ea3fa['attributes'][_0xa786('0x6a')](function(_0x18b753){_0x25a1aa['field']('i.'+_0x18b753);});}else{_0x25a1aa['field'](_0xa786('0x8a'),_0xa786('0x5f'));_0x25a1aa[_0xa786('0x46')](_0xa786('0x99'),_0xa786('0x9a'));_0x25a1aa[_0xa786('0x46')]('a.mandatoryDisposition',_0xa786('0x9b'));_0x25a1aa[_0xa786('0x46')](_0xa786('0x9c'),_0xa786('0x8b'));_0x25a1aa['field'](_0xa786('0x9d'));_0x25a1aa[_0xa786('0x46')]('c.firstName',_0xa786('0x9e'));_0x25a1aa['field'](_0xa786('0x9f'),_0xa786('0xa0'));_0x25a1aa['field']('c.email',_0xa786('0xa1'));_0x25a1aa['field']('c.phone',_0xa786('0xa2'));_0x25a1aa[_0xa786('0x46')](_0xa786('0xa3'),_0xa786('0xa4'));_0x25a1aa['field'](_0xa786('0xa5'),_0xa786('0xa6'));_0x25a1aa[_0xa786('0x46')]('o.fullname',_0xa786('0xa7'));_0x25a1aa[_0xa786('0x46')]('o.internal','Owner.internal');_0x25a1aa[_0xa786('0x46')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0xa786('0x2c'));}if(_0x2ea3fa['limit'])_0x25a1aa[_0xa786('0x40')](_0x2ea3fa[_0xa786('0x40')]);if(_0x2ea3fa[_0xa786('0x1e')])_0x25a1aa[_0xa786('0x1e')](_0x2ea3fa[_0xa786('0x1e')]);return db[_0xa786('0x94')][_0xa786('0x36')](_0x25a1aa[_0xa786('0x95')](),_0x35c45e);})[_0xa786('0x24')](function(_0x22ebf9){_0xb0cd26['where'](_0xa786('0xa8'),_[_0xa786('0x2b')](_0x22ebf9,'id'));return db[_0xa786('0x94')][_0xa786('0x36')](_0xb0cd26[_0xa786('0x95')](),_0x35c45e)[_0xa786('0x24')](function(_0x360e3f){var _0x5f32f4=_[_0xa786('0xa9')](_0x360e3f,_0xa786('0xaa'));var _0x3493d7=[];_0x22ebf9[_0xa786('0x6a')](function(_0x1601ab){_0x3493d7[_0xa786('0x2e')](updateSmsInteraction(_0x1601ab,_0x244dd6,_0x5f32f4));});return BPromise[_0xa786('0xab')](_0x3493d7);});});})['then'](function(_0x46e01c){_0x8e8d42[_0xa786('0xac')]=_0x46e01c;return _0x8e8d42;})[_0xa786('0x24')](respondWithFilteredResult(_0x156554,_0x2ea3fa))['catch'](handleError(_0x156554,null));};exports[_0xa786('0xad')]=function(_0x4aef1d,_0x449927){var _0x2f7de7={'raw':![],'where':{'id':_0x4aef1d[_0xa786('0xae')]['id']}},_0x2e5b85={};_0x2e5b85[_0xa786('0x3a')]=_['keys'](db['SmsInteraction']['rawAttributes']);_0x2e5b85[_0xa786('0x36')]=_[_0xa786('0x37')](_0x4aef1d[_0xa786('0x36')]);_0x2e5b85['filters']=_[_0xa786('0x39')](_0x2e5b85[_0xa786('0x3a')],_0x2e5b85[_0xa786('0x36')]);_0x2f7de7['attributes']=_[_0xa786('0x39')](_0x2e5b85[_0xa786('0x3a')],qs[_0xa786('0x3b')](_0x4aef1d[_0xa786('0x36')][_0xa786('0x3b')]));_0x2f7de7[_0xa786('0x3c')]=_0x2f7de7[_0xa786('0x3c')][_0xa786('0x3d')]?_0x2f7de7[_0xa786('0x3c')]:_0x2e5b85['model'];if(_0x4aef1d[_0xa786('0x36')][_0xa786('0xaf')]){_0x2f7de7[_0xa786('0xb0')]=[{'all':!![]}];}_0x2f7de7=_[_0xa786('0x98')]({},_0x2f7de7,_0x4aef1d[_0xa786('0xb1')]);return db[_0xa786('0x31')][_0xa786('0x5e')](_0x2f7de7)[_0xa786('0x24')](handleEntityNotFound(_0x449927,null))[_0xa786('0x24')](respondWithResult(_0x449927,null))[_0xa786('0x2f')](handleError(_0x449927,null));};exports[_0xa786('0xb2')]=function(_0x2e7543,_0x56b3be){return db['SmsInteraction'][_0xa786('0xb2')](_0x2e7543[_0xa786('0xb3')],{})[_0xa786('0x24')](respondWithResult(_0x56b3be,0xc9))[_0xa786('0x2f')](handleError(_0x56b3be,null));};exports[_0xa786('0x23')]=function(_0x15d469,_0x63462b){if(_0x15d469[_0xa786('0xb3')]['id']){delete _0x15d469[_0xa786('0xb3')]['id'];}return db[_0xa786('0x31')][_0xa786('0x5e')]({'where':{'id':_0x15d469[_0xa786('0xae')]['id']}})[_0xa786('0x24')](handleEntityNotFound(_0x63462b,null))['then'](saveUpdates(_0x15d469['body'],null))[_0xa786('0x24')](respondWithResult(_0x63462b,null))[_0xa786('0x2f')](handleError(_0x63462b,null));};exports['destroy']=function(_0x58055f,_0x5e482b){return db[_0xa786('0x31')][_0xa786('0x5e')]({'where':{'id':_0x58055f[_0xa786('0xae')]['id']}})[_0xa786('0x24')](handleEntityNotFound(_0x5e482b,null))[_0xa786('0x24')](removeEntity(_0x5e482b,null))[_0xa786('0x2f')](handleError(_0x5e482b,null));};exports[_0xa786('0xb4')]=function(_0x552226,_0x21e931){return db[_0xa786('0x31')][_0xa786('0xb4')]()['then'](respondWithResult(_0x21e931,null))['catch'](handleError(_0x21e931,null));};exports[_0xa786('0xb5')]=function(_0x27d2a6,_0x18bf9e,_0x382e00){return db[_0xa786('0xb6')][_0xa786('0x5e')]({'where':{'id':_0x27d2a6['params']['id']}})[_0xa786('0x24')](handleEntityNotFound(_0x18bf9e,null))[_0xa786('0x24')](function(_0x1eb806){if(_0x1eb806){return _0x1eb806[_0xa786('0xb5')](_0x27d2a6[_0xa786('0xb3')][_0xa786('0xb7')],_[_0xa786('0xb8')](_0x27d2a6['body'],[_0xa786('0xb7'),'id'])||{});}})[_0xa786('0x24')](respondWithResult(_0x18bf9e,null))[_0xa786('0x2f')](handleError(_0x18bf9e,null));};exports[_0xa786('0xb9')]=function(_0x36b9ea,_0x3a3819,_0x31dbd1){var _0x5363d5={'raw':![],'where':{}};var _0x35eca5={};var _0x2cec88={'count':0x0,'rows':[]};return db[_0xa786('0x31')]['findOne']({'where':{'id':_0x36b9ea[_0xa786('0xae')]['id']}})['then'](handleEntityNotFound(_0x3a3819,null))[_0xa786('0x24')](function(_0x3a7b34){if(_0x3a7b34){_0x35eca5[_0xa786('0x3a')]=_[_0xa786('0x37')](db[_0xa786('0xb6')][_0xa786('0x32')]);_0x35eca5[_0xa786('0x36')]=_['keys'](_0x36b9ea[_0xa786('0x36')]);_0x35eca5[_0xa786('0x38')]=_[_0xa786('0x39')](_0x35eca5[_0xa786('0x3a')],_0x35eca5['query']);_0x5363d5[_0xa786('0x3c')]=_[_0xa786('0x39')](_0x35eca5[_0xa786('0x3a')],qs[_0xa786('0x3b')](_0x36b9ea[_0xa786('0x36')][_0xa786('0x3b')]));_0x5363d5[_0xa786('0x3c')]=_0x5363d5['attributes'][_0xa786('0x3d')]?_0x5363d5[_0xa786('0x3c')]:_0x35eca5[_0xa786('0x3a')];if(!_0x36b9ea['query'][_0xa786('0x3e')](_0xa786('0x3f'))){_0x5363d5['limit']=qs[_0xa786('0x40')](_0x36b9ea['query']['limit']);_0x5363d5[_0xa786('0x1e')]=qs['offset'](_0x36b9ea[_0xa786('0x36')][_0xa786('0x1e')]);}_0x5363d5[_0xa786('0x41')]=qs[_0xa786('0x42')](_0x36b9ea['query'][_0xa786('0x42')]);_0x5363d5['where']=qs[_0xa786('0x38')](_[_0xa786('0x44')](_0x36b9ea['query'],_0x35eca5[_0xa786('0x38')]));_0x5363d5[_0xa786('0x43')]['SmsInteractionId']=_0x3a7b34['id'];if(_0x36b9ea[_0xa786('0x36')][_0xa786('0x80')]){_0x5363d5[_0xa786('0x43')]=_[_0xa786('0x98')](_0x5363d5[_0xa786('0x43')],{'$or':_[_0xa786('0x2b')](_0x5363d5[_0xa786('0x3c')],function(_0x4b9e7a){var _0x5af88f={};_0x5af88f[_0x4b9e7a]={'$like':'%'+_0x36b9ea[_0xa786('0x36')][_0xa786('0x80')]+'%'};return _0x5af88f;})});}if(_0x36b9ea[_0xa786('0x36')][_0xa786('0x77')]){var _0x33c198=_0x36b9ea[_0xa786('0x36')]['$gte'][_0xa786('0x65')](',');var _0x413442={};_0x413442[_0x33c198[0x0]]={'$gte':moment(_0x33c198[0x1])[_0xa786('0xba')]('YYYY-MM-DD\x20HH:mm:ss')};_0x5363d5[_0xa786('0x43')]=_['merge'](_0x5363d5[_0xa786('0x43')],_0x413442);}_0x5363d5=_[_0xa786('0x98')]({},_0x5363d5,_0x36b9ea[_0xa786('0xb1')]);return db[_0xa786('0xb6')][_0xa786('0x96')]({'where':_0x5363d5['where']})['then'](function(_0x352a73){_0x2cec88[_0xa786('0x96')]=_0x352a73;if(_0x36b9ea[_0xa786('0x36')][_0xa786('0xaf')]){_0x5363d5[_0xa786('0xb0')]=[{'all':!![]}];}return db[_0xa786('0xb6')][_0xa786('0xbb')](_0x5363d5);})['then'](function(_0x1e3e16){_0x2cec88[_0xa786('0xac')]=_0x1e3e16;return _0x2cec88;});}})['then'](respondWithFilteredResult(_0x3a3819,_0x5363d5))[_0xa786('0x2f')](handleError(_0x3a3819,null));};exports['addTags']=function(_0x57f2d6,_0x50772c,_0x6e0be5){return db[_0xa786('0x31')][_0xa786('0x5e')]({'where':{'id':_0x57f2d6[_0xa786('0xae')]['id']}})[_0xa786('0x24')](handleEntityNotFound(_0x50772c,null))[_0xa786('0x24')](function(_0x22c490){if(_0x22c490){return _0x22c490[_0xa786('0xbc')](_0x57f2d6['body']['ids'],_[_0xa786('0xb8')](_0x57f2d6[_0xa786('0xb3')],['ids','id'])||{})[_0xa786('0xbd')](function(){return db['Tag'][_0xa786('0xbb')]({'attributes':['id',_0xa786('0x29'),_0xa786('0x47')],'where':{'id':_0x57f2d6[_0xa786('0xb3')]['ids']}});})[_0xa786('0x24')](function(_0x1741ec){socket[_0xa786('0xbe')]('smsInteractionTags:save',{'id':Number(_0x57f2d6[_0xa786('0xae')]['id']),'tags':_0x1741ec||[]});return{'id':Number(_0x57f2d6[_0xa786('0xae')]['id']),'tags':_0x1741ec||[]};});}})['then'](respondWithResult(_0x50772c,null))[_0xa786('0x2f')](handleError(_0x50772c,null));};exports[_0xa786('0xbf')]=function(_0x1cd694,_0x2529d5,_0x46eb24){return db[_0xa786('0x31')][_0xa786('0x5e')]({'where':{'id':_0x1cd694[_0xa786('0xae')]['id']}})[_0xa786('0x24')](handleEntityNotFound(_0x2529d5,null))[_0xa786('0x24')](function(_0x2e0631){if(_0x2e0631){return _0x2e0631[_0xa786('0xbf')](_0x1cd694['query'][_0xa786('0xb7')]);}})[_0xa786('0x24')](respondWithStatusCode(_0x2529d5,null))[_0xa786('0x2f')](handleError(_0x2529d5,null));};exports[_0xa786('0xc0')]=function(_0xbac3c4,_0x37104f){var _0x4e611c=moment()[_0xa786('0xc1')]()[_0xa786('0x95')]();var _0x1dad85=path[_0xa786('0xc2')](config[_0xa786('0xc3')],_0xa786('0xc4'),_0xa786('0xc5'),_0xa786('0xc6'));var _0x1d15ff=path[_0xa786('0xc2')](config[_0xa786('0xc3')],_0xa786('0xc4'),_0xa786('0xc5'),_0xa786('0xc7'));var _0x2102d2=path[_0xa786('0xc2')](_0x1dad85,_0x4e611c);var _0x4aaab4=util[_0xa786('0xba')]('transcript-%d-%s.zip',_0xbac3c4[_0xa786('0xae')]['id'],_0x4e611c);var _0x277b28=path[_0xa786('0xc2')](_0x1dad85,_0x4aaab4);var _0x197f84=[];_0x197f84[_0xa786('0x2e')]({'model':db['User'],'as':'User','attributes':['id','fullname'],'raw':!![]});_0x197f84[_0xa786('0x2e')]({'model':db['CmContact'],'as':_0xa786('0x63'),'attributes':['id',_0xa786('0xc8'),_0xa786('0xc9')],'raw':!![]});var _0x174f62=[{'model':db[_0xa786('0xb6')],'as':_0xa786('0xca'),'attributes':['id',_0xa786('0xb3'),_0xa786('0x75'),_0xa786('0xcb'),'secret',_0xa786('0x7c')],'include':_0x197f84}];_0x174f62[_0xa786('0x2e')]({'model':db['SmsAccount'],'as':_0xa786('0xcc'),'attributes':['id',_0xa786('0x29')]});_0x174f62['push']({'model':db[_0xa786('0x6c')],'as':_0xa786('0xcd'),'attributes':['id',_0xa786('0xce')]});return db[_0xa786('0x31')][_0xa786('0x5e')]({'where':{'id':_0xbac3c4[_0xa786('0xae')]['id']},'include':_0x174f62})[_0xa786('0x24')](handleEntityNotFound(_0x37104f,null))['then'](function(_0x54745f){if(_0x54745f){var _0x931e77=_0x54745f[_0xa786('0xcf')]({'plain':!![]});fs['mkdirSync'](_0x2102d2);var _0x1a5cb1={'format':'A4','border':_0xa786('0xd0'),'header':{'height':_0xa786('0xd1'),'contents':{'first':_0xa786('0xd2')}},'footer':{'height':_0xa786('0xd3'),'contents':{'default':util[_0xa786('0xba')](_0xa786('0xd4'),util[_0xa786('0xba')](_0xa786('0xd5'),_0xa786('0xd6'),_0x931e77['id']),moment()[_0xa786('0xba')]('YYYY-MM-DD')[_0xa786('0x95')]())}}};var _0x4ad9ae={'channel':_0xa786('0xd6'),'account':_0x931e77[_0xa786('0xcc')][_0xa786('0x29')],'agent':_0x931e77['Owner']?_0x931e77[_0xa786('0xcd')][_0xa786('0xce')]:_0xa786('0xd7'),'createdAt':moment(_0x931e77[_0xa786('0x75')])['format'](_0xa786('0xd8'))[_0xa786('0x95')](),'closedAt':_0x931e77[_0xa786('0xd9')]?moment(_0x931e77['closedAt'])['format']('YYYY-MM-DD\x20HH:mm:ss')[_0xa786('0x95')]():'','disposition':_0x931e77[_0xa786('0xda')],'messages':_(_0x931e77[_0xa786('0xca')])['filter']({'secret':![]})[_0xa786('0x2b')](function(_0x5514f1){return{'date':moment(_0x5514f1['createdAt'])['format'](_0xa786('0xd8'))[_0xa786('0x95')](),'sender':_0x5514f1[_0xa786('0xcb')]===_0xa786('0xdb')?_0x5514f1[_0xa786('0x6c')]?_0x5514f1[_0xa786('0x6c')][_0xa786('0xce')]:_0xa786('0xdc'):_0x5514f1['Contact']['firstName']+(_0x5514f1['Contact']['lastName']?'\x20'+_0x5514f1[_0xa786('0x63')]['lastName']:''),'body':_0x5514f1[_0xa786('0xb3')],'direction':_0x5514f1['direction']===_0xa786('0xdb')?'A':'C','secret':_0x5514f1[_0xa786('0xdd')],'read':_0x5514f1[_0xa786('0x7c')]};})['value']()};return ejs[_0xa786('0xde')](path['join'](config[_0xa786('0xc3')],_0xa786('0xc4'),_0xa786('0xdf'),_0xa786('0xe0')),{'interaction':_0x4ad9ae})[_0xa786('0x24')](function(_0x15b31d){return new BPromise(function(_0x3e393f,_0x26b9af){pdf[_0xa786('0xb2')](_0x15b31d,_0x1a5cb1)[_0xa786('0xe1')](path['join'](_0x2102d2,_0xa786('0xe2')+_0x931e77['id']+'-'+_0x4e611c+_0xa786('0xe3')),function(_0x40cfd2,_0x5d04cb){if(_0x40cfd2)return _0x26b9af(_0x40cfd2);_0x3e393f(_0x5d04cb);});});})['then'](function(){return new BPromise(function(_0x1de554,_0x124e13){zipdir(_0x2102d2,{'saveTo':_0x277b28},function(_0x24a24b,_0x4ecb54){if(_0x24a24b)return _0x124e13(_0x24a24b);return _0x1de554(_0x4ecb54);});})[_0xa786('0x24')](function(){return new BPromise(function(_0x2cdbc6,_0x4a56ca){rimraf(_0x2102d2,function(_0x1a5691){if(_0x1a5691)_0x4a56ca(_0x1a5691);return _0x2cdbc6();});});})[_0xa786('0x24')](function(){return _0x37104f[_0xa786('0xc0')](_0x277b28,_0x4aaab4,function(_0x1aeeb7){if(_0x1aeeb7){console[_0xa786('0xe4')](_0xa786('0xe5'),_0x1aeeb7);}else{fs[_0xa786('0xe6')](_0x277b28);}});});});}else{return _0x37104f['sendStatus'](0xc8);}})[_0xa786('0x2f')](handleError(_0x37104f,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(_0x1ac595,_0x5d2081){var _0x455fff=function(_0x3043ee){while(--_0x3043ee){_0x1ac595['push'](_0x1ac595['shift']());}};_0x455fff(++_0x5d2081);}(_0xa9e0,0x123));var _0x0a9e=function(_0x34bf97,_0xc60f9d){_0x34bf97=_0x34bf97-0x0;var _0x292719=_0xa9e0[_0x34bf97];return _0x292719;};'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