// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x6c20=['error','name','send','Users','map','TagIds','Tags','split','forEach','push','index','SmsInteraction','rawAttributes','model','keys','query','filters','attributes','fields','length','hasOwnProperty','nolimit','where','select','field','color','tools_tags','COUNT(*)','from','me.SmsInteractionId\x20=\x20i.id','me.read\x20=\x20false','u.id','ui.SmsInteractionId','user_has_sms_interactions','left_join','users','u.id\x20=\x20ui.UserId','sms_interactions','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','sms_accounts','a.id\x20=\x20i.SmsAccountId','sms_messages','me.SmsInteractionId\x20=\x20i.id\x20AND\x20me.direction\x20=\x20\x27in\x27\x20AND\x20me.read\x20=\x20false','expr','advancedFilter','parse','createdAt','value','dateStart','day','utc','format','and','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','isArray','condition','TagId','unreadMessages','tableAlias','\x20IN\x20?','\x20=\x20?','LIKE','c.firstName','c.lastName','\x20LIKE\x20?','\x20>\x20?','\x20<\x20?','ContactId','c.email','filter','isEmpty','SmsAccountId','i.SmsAccountId\x20IN\x20?','concat','$gte','$lte','\x20IS\x20NULL','replace','\x27\x27\x27\x27','isNumeric','i.id\x20LIKE\x20?','join','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','order','i.id','Sequelize','clone','COUNT(me.id)','read','having','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','t.id\x20=\x20it.TagId','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','t.id\x20IN\x20?','sequelize','toString','merge','c.phone','Contact.phone','c.mobile','Contact.mobile','sms_interaction_has_tags','it.SmsInteractionId\x20=\x20i.id','groupBy','all','rows','catch','show','intersection','includeAll','include','options','find','create','body','params','describe','SmsMessage','addMessage','ids','omit','getMessages','findOne','sort','SmsInteractionId','YYYY-MM-DD\x20HH:mm:ss','findAll','setTags','spread','emit','smsInteractionTags:save','removeTags','unix','root','server','files','tmp','attachments','direction','User','fullname','CmContact','firstName','lastName','SmsAccount','Account','Owner','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\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\x20\x20\x20\x20\x20\x20</div>','30px','%s\x20#%d','YYYY-MM-DD','Sms','N.A.','closed','closedAt','disposition','out','System','Contact','secret','renderFile','downloadInteraction.html','toFile','.pdf','download','err','unlinkSync','sendStatus','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','defaults','redis','localhost','socket.io-emitter','register','status','end','count','offset','limit','set','Content-Range','json','reject','save','update','then'];(function(_0x173441,_0x26b0d9){var _0x2423a8=function(_0x4d96c2){while(--_0x4d96c2){_0x173441['push'](_0x173441['shift']());}};_0x2423a8(++_0x26b0d9);}(_0x6c20,0xaf));var _0x06c2=function(_0x11343c,_0x12857d){_0x11343c=_0x11343c-0x0;var _0x5603b2=_0x6c20[_0x11343c];return _0x5603b2;};'use strict';var pdf=require(_0x06c2('0x0'));var emlformat=require(_0x06c2('0x1'));var rimraf=require(_0x06c2('0x2'));var zipdir=require(_0x06c2('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x06c2('0x4'));var moment=require(_0x06c2('0x5'));var BPromise=require(_0x06c2('0x6'));var Mustache=require(_0x06c2('0x7'));var util=require(_0x06c2('0x8'));var path=require(_0x06c2('0x9'));var sox=require(_0x06c2('0xa'));var csv=require(_0x06c2('0xb'));var ejs=require(_0x06c2('0xc'));var fs=require('fs');var _=require(_0x06c2('0xd'));var squel=require(_0x06c2('0xe'));var crypto=require(_0x06c2('0xf'));var jsforce=require(_0x06c2('0x10'));var deskjs=require(_0x06c2('0x11'));var toCsv=require(_0x06c2('0xb'));var querystring=require(_0x06c2('0x12'));var Papa=require('papaparse');var Redis=require(_0x06c2('0x13'));var authService=require(_0x06c2('0x14'));var qs=require(_0x06c2('0x15'));var hardwareService=require(_0x06c2('0x16'));var logger=require(_0x06c2('0x17'))(_0x06c2('0x18'));var utils=require('../../config/utils');var config=require(_0x06c2('0x19'));var db=require(_0x06c2('0x1a'))['db'];config['redis']=_[_0x06c2('0x1b')](config[_0x06c2('0x1c')],{'host':_0x06c2('0x1d'),'port':0x18eb});var socket=require(_0x06c2('0x1e'))(new Redis(config[_0x06c2('0x1c')]));require('./smsInteraction.socket')[_0x06c2('0x1f')](socket);function respondWithStatusCode(_0x298ac2,_0x45751c){_0x45751c=_0x45751c||0xcc;return function(_0x5a028f){if(_0x5a028f){return _0x298ac2['sendStatus'](_0x45751c);}return _0x298ac2[_0x06c2('0x20')](_0x45751c)[_0x06c2('0x21')]();};}function respondWithResult(_0x555be9,_0x14f904){_0x14f904=_0x14f904||0xc8;return function(_0xd1f62e){if(_0xd1f62e){return _0x555be9[_0x06c2('0x20')](_0x14f904)['json'](_0xd1f62e);}};}function respondWithFilteredResult(_0x407ba8,_0x16aa29){return function(_0x3c6b06){if(_0x3c6b06){var _0x3c4eea=_0x3c6b06[_0x06c2('0x22')],_0x317c7d=_0x16aa29['offset'],_0x2b2125=_0x16aa29[_0x06c2('0x23')]+_0x16aa29[_0x06c2('0x24')],_0x1c07a6;if(_0x2b2125>=_0x3c4eea){_0x2b2125=_0x3c4eea;_0x1c07a6=0xc8;}else{_0x1c07a6=0xce;}_0x407ba8[_0x06c2('0x20')](_0x1c07a6);return _0x407ba8[_0x06c2('0x25')](_0x06c2('0x26'),_0x317c7d+'-'+_0x2b2125+'/'+_0x3c4eea)[_0x06c2('0x27')](_0x3c6b06);}return null;};}function patchUpdates(_0x774123){return function(_0x38429b){try{jsonpatch['apply'](_0x38429b,_0x774123,!![]);}catch(_0x309748){return BPromise[_0x06c2('0x28')](_0x309748);}return _0x38429b[_0x06c2('0x29')]();};}function saveUpdates(_0x3e6494,_0x5daddf){return function(_0x5906ea){if(_0x5906ea){return _0x5906ea[_0x06c2('0x2a')](_0x3e6494)['then'](function(_0x5ae93a){return _0x5ae93a;});}return null;};}function removeEntity(_0x2cf176,_0x24e5c9){return function(_0x54569c){if(_0x54569c){return _0x54569c['destroy']()[_0x06c2('0x2b')](function(){_0x2cf176[_0x06c2('0x20')](0xcc)['end']();});}};}function handleEntityNotFound(_0x3fc5a8,_0x52e0dc){return function(_0x53b70c){if(!_0x53b70c){_0x3fc5a8['sendStatus'](0x194);}return _0x53b70c;};}function handleError(_0x353699,_0x5be8d6){_0x5be8d6=_0x5be8d6||0x1f4;return function(_0x53f302){logger[_0x06c2('0x2c')](_0x53f302['stack']);if(_0x53f302['name']){delete _0x53f302[_0x06c2('0x2d')];}_0x353699['status'](_0x5be8d6)[_0x06c2('0x2e')](_0x53f302);};}function getInteractionUsers(_0x525592,_0x262f3d){return new BPromise(function(_0x39caf0,_0x2d932c){try{if(_0x262f3d[_0x525592['id']]){_0x525592[_0x06c2('0x2f')]=_[_0x06c2('0x30')](_0x262f3d[_0x525592['id']],function(_0x4177ca){return{'id':_0x4177ca['id']};});}}catch(_0x594134){_0x2d932c(_0x594134);}_0x39caf0(_0x525592);});}function getInteractionTags(_0x1fe2b1,_0x2c308c){return new BPromise(function(_0x4954a0,_0x5103e7){try{if(_0x1fe2b1[_0x06c2('0x31')]){_0x1fe2b1[_0x06c2('0x32')]=[];_0x1fe2b1[_0x06c2('0x31')][_0x06c2('0x33')](',')[_0x06c2('0x34')](function(_0x107767){_0x1fe2b1[_0x06c2('0x32')][_0x06c2('0x35')](_0x2c308c[_0x107767]);});}delete _0x1fe2b1[_0x06c2('0x31')];}catch(_0x199e9f){_0x5103e7(_0x199e9f);}_0x4954a0(_0x1fe2b1);});}function updateSmsInteraction(_0x462f62,_0x3d4ea8,_0x278f56){return new BPromise(function(_0x3b0d5e,_0x5b1bbc){return getInteractionUsers(_0x462f62,_0x278f56)[_0x06c2('0x2b')](function(_0x4c2798){return getInteractionTags(_0x4c2798,_0x3d4ea8);})[_0x06c2('0x2b')](function(_0x4532ee){_0x3b0d5e(_0x4532ee);})['catch'](function(_0x436ade){_0x5b1bbc(_0x436ade);});});}exports[_0x06c2('0x36')]=function(_0x1c5766,_0x210782){var _0x38aa98={},_0x5e8931={},_0x25f8bd={'count':0x0,'rows':[]};var _0xa0414d=db[_0x06c2('0x37')][_0x06c2('0x38')];_0x5e8931[_0x06c2('0x39')]=_[_0x06c2('0x3a')](_0xa0414d);_0x5e8931[_0x06c2('0x3b')]=_[_0x06c2('0x3a')](_0x1c5766[_0x06c2('0x3b')]);_0x5e8931[_0x06c2('0x3c')]=_['intersection'](_0x5e8931[_0x06c2('0x39')],_0x5e8931[_0x06c2('0x3b')]);_0x38aa98[_0x06c2('0x3d')]=_['intersection'](_0x5e8931[_0x06c2('0x39')],qs[_0x06c2('0x3e')](_0x1c5766[_0x06c2('0x3b')][_0x06c2('0x3e')]));_0x38aa98[_0x06c2('0x3d')]=_0x38aa98[_0x06c2('0x3d')][_0x06c2('0x3f')]?_0x38aa98[_0x06c2('0x3d')]:_0x5e8931['model'];if(!_0x1c5766[_0x06c2('0x3b')][_0x06c2('0x40')](_0x06c2('0x41'))){_0x38aa98['limit']=qs['limit'](_0x1c5766[_0x06c2('0x3b')][_0x06c2('0x24')]);_0x38aa98[_0x06c2('0x23')]=qs[_0x06c2('0x23')](_0x1c5766[_0x06c2('0x3b')][_0x06c2('0x23')]);}_0x38aa98['order']=qs['sort'](_0x1c5766[_0x06c2('0x3b')]['sort']);_0x38aa98[_0x06c2('0x42')]=qs[_0x06c2('0x3c')](_['pick'](_0x1c5766[_0x06c2('0x3b')],_0x5e8931[_0x06c2('0x3c')]));var _0x1fd8d4=[];var _0x1798ed=squel[_0x06c2('0x43')]()[_0x06c2('0x44')]('id')[_0x06c2('0x44')](_0x06c2('0x2d'))[_0x06c2('0x44')](_0x06c2('0x45'))['from'](_0x06c2('0x46'));var _0x2d2f9a=squel['select']()[_0x06c2('0x44')](_0x06c2('0x47'))[_0x06c2('0x48')]('sms_messages','me')[_0x06c2('0x42')](_0x06c2('0x49'))[_0x06c2('0x42')]('me.direction\x20=\x20\x27in\x27')[_0x06c2('0x42')](_0x06c2('0x4a'));var _0x37aa94=squel[_0x06c2('0x43')]()[_0x06c2('0x44')](_0x06c2('0x4b'))[_0x06c2('0x44')](_0x06c2('0x4c'))['from'](_0x06c2('0x4d'),'ui')[_0x06c2('0x4e')](_0x06c2('0x4f'),'u',_0x06c2('0x50'));var _0x275f10=squel[_0x06c2('0x43')]()[_0x06c2('0x48')](_0x06c2('0x51'),'i')['left_join']('cm_contacts','c',_0x06c2('0x52'))[_0x06c2('0x4e')](_0x06c2('0x4f'),'o','o.id\x20=\x20i.UserId')[_0x06c2('0x4e')](_0x06c2('0x53'),'a',_0x06c2('0x54'))[_0x06c2('0x4e')](_0x06c2('0x55'),'me',_0x06c2('0x56'));var _0x12f209=squel[_0x06c2('0x57')]();if(_0x1c5766[_0x06c2('0x3b')][_0x06c2('0x58')]){var _0x1ca21f=JSON[_0x06c2('0x59')](_0x1c5766[_0x06c2('0x3b')][_0x06c2('0x58')]);_[_0x06c2('0x3a')](_0x1ca21f)[_0x06c2('0x34')](function(_0x594824){var _0x4ae04b=_0x1ca21f[_0x594824];if(_0x594824===_0x06c2('0x5a')){var _0x5ad69b=moment(_0x4ae04b[_0x06c2('0x5b')][_0x06c2('0x5c')])['startOf'](_0x06c2('0x5d'))[_0x06c2('0x5e')]()['format']();var _0x3c05c5=moment(_0x3c05c5)[_0x06c2('0x5e')]()['endOf'](_0x06c2('0x5d'))[_0x06c2('0x5f')]();_0x12f209[_0x06c2('0x60')](_0x06c2('0x61'),_0x5ad69b,_0x3c05c5);}else{if(_[_0x06c2('0x62')](_0x4ae04b['condition'])){_0x4ae04b[_0x06c2('0x63')][_0x06c2('0x34')](function(_0x20fde8){switch(_0x4ae04b['condition'][_0x06c2('0x5b')]){case'IS':if(_0x594824!==_0x06c2('0x64')&&_0x594824!==_0x06c2('0x65')){if(_[_0x06c2('0x62')](_0x4ae04b[_0x06c2('0x5b')])&&_0x4ae04b[_0x06c2('0x5b')][_0x06c2('0x3f')]>0x1){_0x12f209[_0x06c2('0x60')](_0x4ae04b[_0x06c2('0x66')]+'.'+_0x594824+_0x06c2('0x67'),_0x4ae04b[_0x06c2('0x5b')]);}else{_0x12f209[_0x06c2('0x60')](_0x4ae04b['tableAlias']+'.'+_0x594824+'\x20=\x20?',_0x4ae04b['value'][0x0]);}}break;case'=':_0x12f209[_0x06c2('0x60')](_0x4ae04b[_0x06c2('0x66')]+'.'+_0x594824+_0x06c2('0x68'),_0x4ae04b['value']);break;case _0x06c2('0x69'):if(_0x594824==='ContactId'){_0x12f209[_0x06c2('0x60')](_0x06c2('0x6a')+'\x20LIKE\x20?','%'+_0x4ae04b[_0x06c2('0x5b')]+'%');_0x12f209['or'](_0x06c2('0x6b')+_0x06c2('0x6c'),'%'+_0x4ae04b[_0x06c2('0x5b')]+'%');_0x12f209['or']('c.email'+_0x06c2('0x6c'),'%'+_0x4ae04b[_0x06c2('0x5b')]+'%');}else{_0x12f209['and'](_0x4ae04b[_0x06c2('0x66')]+'.'+_0x594824+_0x06c2('0x6c'),'%'+_0x4ae04b[_0x06c2('0x5b')]+'%');}break;case'>':_0x12f209[_0x06c2('0x60')](_0x4ae04b[_0x06c2('0x66')]+'.'+_0x594824+_0x06c2('0x6d'),_0x4ae04b[_0x06c2('0x5b')]);break;case'<':_0x12f209[_0x06c2('0x60')](_0x4ae04b[_0x06c2('0x66')]+'.'+_0x594824+_0x06c2('0x6e'),_0x4ae04b[_0x06c2('0x5b')]);break;}});}else{switch(_0x4ae04b['condition'][_0x06c2('0x5b')]){case'IS':if(_0x594824!==_0x06c2('0x64')&&_0x594824!==_0x06c2('0x65')){if(_['isArray'](_0x4ae04b['value'])&&_0x4ae04b[_0x06c2('0x5b')][_0x06c2('0x3f')]>0x1){_0x12f209[_0x06c2('0x60')](_0x4ae04b[_0x06c2('0x66')]+'.'+_0x594824+_0x06c2('0x67'),_0x4ae04b[_0x06c2('0x5b')]);}else{_0x12f209[_0x06c2('0x60')](_0x4ae04b[_0x06c2('0x66')]+'.'+_0x594824+_0x06c2('0x68'),_0x4ae04b[_0x06c2('0x5b')][0x0]);}}break;case'=':_0x12f209['and'](_0x4ae04b[_0x06c2('0x66')]+'.'+_0x594824+_0x06c2('0x68'),_0x4ae04b[_0x06c2('0x5b')]);break;case _0x06c2('0x69'):if(_0x594824===_0x06c2('0x6f')){_0x12f209[_0x06c2('0x60')](_0x06c2('0x6a')+_0x06c2('0x6c'),'%'+_0x4ae04b[_0x06c2('0x5b')]+'%');_0x12f209['or'](_0x06c2('0x6b')+_0x06c2('0x6c'),'%'+_0x4ae04b[_0x06c2('0x5b')]+'%');_0x12f209['or'](_0x06c2('0x70')+_0x06c2('0x6c'),'%'+_0x4ae04b[_0x06c2('0x5b')]+'%');}else{_0x12f209[_0x06c2('0x60')](_0x4ae04b[_0x06c2('0x66')]+'.'+_0x594824+_0x06c2('0x6c'),'%'+_0x4ae04b[_0x06c2('0x5b')]+'%');}break;case'>':_0x12f209[_0x06c2('0x60')](_0x4ae04b[_0x06c2('0x66')]+'.'+_0x594824+_0x06c2('0x6d'),_0x4ae04b[_0x06c2('0x5b')]);break;case'<':_0x12f209[_0x06c2('0x60')](_0x4ae04b[_0x06c2('0x66')]+'.'+_0x594824+_0x06c2('0x6e'),_0x4ae04b[_0x06c2('0x5b')]);break;}}}});}else{var _0x40d0cb=_(Object[_0x06c2('0x3a')](_0x1c5766[_0x06c2('0x3b')]))[_0x06c2('0x30')](function(_0x4d82d2){return _0xa0414d[_0x06c2('0x40')](_0x4d82d2)?_0x4d82d2:undefined;})[_0x06c2('0x71')](function(_0x280c76){return!_['isNil'](_0x280c76);})[_0x06c2('0x5b')]();if(!_[_0x06c2('0x72')](_0x40d0cb)){_0x40d0cb['forEach'](function(_0x27a8c6){if(_0x27a8c6===_0x06c2('0x73')){_0x275f10[_0x06c2('0x42')](_0x06c2('0x74'),[][_0x06c2('0x75')](_0x1c5766[_0x06c2('0x3b')][_0x27a8c6]));}else if(_0x27a8c6===_0x06c2('0x5a')){var _0x4083e0=JSON[_0x06c2('0x59')](_0x1c5766[_0x06c2('0x3b')][_0x27a8c6])[_0x06c2('0x76')];var _0x3bd129=JSON[_0x06c2('0x59')](_0x1c5766['query'][_0x27a8c6])[_0x06c2('0x77')];_0x275f10['where'](_0x06c2('0x61'),_0x4083e0,_0x3bd129);}else{if(_0x1c5766[_0x06c2('0x3b')][_0x27a8c6]==='null'){_0x275f10[_0x06c2('0x42')]('i.'+_0x27a8c6+_0x06c2('0x78'));}else{_0x275f10[_0x06c2('0x42')]('i.'+_0x27a8c6+_0x06c2('0x68'),_0x1c5766[_0x06c2('0x3b')][_0x27a8c6]);}}});}if(_0x1c5766['query'][_0x06c2('0x71')]){var _0x15515e=_0x1c5766[_0x06c2('0x3b')][_0x06c2('0x71')][_0x06c2('0x79')]('\x5c','\x5c\x5c')[_0x06c2('0x79')]('\x27\x27',_0x06c2('0x7a'));if(qs[_0x06c2('0x7b')](_0x15515e)){_0x12f209['or'](_0x06c2('0x7c'),_0x15515e+'%')['or']('i.phone\x20LIKE\x20?',_0x15515e+'%');}else{var _0x5e2963=[];_0x15515e['split']('\x20')[_0x06c2('0x34')](function(_0x4a7e15){_0x5e2963['push']('+'+_0x4a7e15['toString']());});var _0x6c4233=_0x5e2963[_0x06c2('0x7d')]('\x20');_0x12f209['or'](_0x06c2('0x7e'),_0x6c4233)['or'](_0x06c2('0x7f'),_0x15515e+'%');}}}_0x275f10[_0x06c2('0x42')](_0x12f209);if(_0x38aa98[_0x06c2('0x80')]){_0x38aa98['order'][_0x06c2('0x34')](function(_0xba1b0d){_0x275f10['order']('i.'+_0xba1b0d[0x0],_0xba1b0d[0x1]==='DESC'?![]:!![]);});}_0x275f10['group'](_0x06c2('0x81'));var _0xc69173={'type':db[_0x06c2('0x82')]['QueryTypes']['SELECT'],'raw':!![]};var _0x5b8a8e=_0x275f10[_0x06c2('0x83')]()[_0x06c2('0x44')]('COUNT(*)')[_0x06c2('0x44')](_0x06c2('0x84'),'unreadMessages');if(!_0x1c5766[_0x06c2('0x3b')]['advancedFilter']){if(_0x1c5766['query'][_0x06c2('0x85')]){if(_0x1c5766[_0x06c2('0x3b')][_0x06c2('0x85')]==0x1){_0x5b8a8e[_0x06c2('0x86')](_0x06c2('0x87'));_0x275f10[_0x06c2('0x86')](_0x06c2('0x87'));}else{_0x5b8a8e[_0x06c2('0x86')](_0x06c2('0x88'));_0x275f10[_0x06c2('0x86')](_0x06c2('0x88'));}}if(_0x1c5766['query']['tag']){var _0xe69678=_[_0x06c2('0x62')](_0x1c5766['query']['tag'])?_0x1c5766[_0x06c2('0x3b')][_0x06c2('0x89')]:new Array(_0x1c5766[_0x06c2('0x3b')]['tag']);var _0x1fccd9=squel[_0x06c2('0x57')]();_0xe69678['forEach'](function(_0x2ce6a4){_0x1fccd9['or'](_0x06c2('0x8a'),'%,'+_0x2ce6a4+',%');});_0x275f10[_0x06c2('0x86')](_0x1fccd9);_0x5b8a8e[_0x06c2('0x4e')]('sms_interaction_has_tags','it','it.SmsInteractionId\x20=\x20i.id');_0x5b8a8e[_0x06c2('0x4e')]('tools_tags','t',_0x06c2('0x8b'));_0x5b8a8e[_0x06c2('0x42')]('t.id\x20IN\x20?',_0xe69678);}}else{var _0x1ca21f=JSON[_0x06c2('0x59')](_0x1c5766['query'][_0x06c2('0x58')]);_[_0x06c2('0x3a')](_0x1ca21f)[_0x06c2('0x34')](function(_0x19466a){var _0x3de6cc=_0x1ca21f[_0x19466a];if(_0x19466a===_0x06c2('0x64')){var _0x571bad=_0x3de6cc['value'];var _0x43f5f3=squel[_0x06c2('0x57')]();_0x571bad[_0x06c2('0x34')](function(_0xb76923){_0x43f5f3['or'](_0x06c2('0x8a'),'%,'+_0xb76923+',%');});_0x275f10[_0x06c2('0x86')](_0x43f5f3);_0x5b8a8e[_0x06c2('0x4e')](_0x06c2('0x8c'),'it',_0x06c2('0x8d'));_0x5b8a8e[_0x06c2('0x4e')](_0x06c2('0x46'),'t',_0x06c2('0x8b'));_0x5b8a8e[_0x06c2('0x42')](_0x06c2('0x8e'),_0x571bad);}else if(_0x19466a===_0x06c2('0x65')){if(_0x3de6cc[_0x06c2('0x5b')][_0x06c2('0x3f')]===0x1){if(_0x3de6cc[_0x06c2('0x5b')][0x0]===0x1){_0x5b8a8e['having']('`unreadMessages`\x20=\x200');_0x275f10[_0x06c2('0x86')](_0x06c2('0x87'));}else{_0x5b8a8e[_0x06c2('0x86')](_0x06c2('0x88'));_0x275f10[_0x06c2('0x86')](_0x06c2('0x88'));}}}});}db[_0x06c2('0x8f')][_0x06c2('0x3b')](_0x5b8a8e[_0x06c2('0x90')](),_0xc69173)['then'](function(_0x41c65b){_0x25f8bd['count']=_0x41c65b['length'];if(_0x25f8bd['count']===0x0)return[];return db[_0x06c2('0x8f')]['query'](_0x1798ed[_0x06c2('0x90')](),_0xc69173)[_0x06c2('0x2b')](function(_0xdeb438){_0x1fd8d4=_['keyBy'](_0xdeb438,'id');_0xc69173=_[_0x06c2('0x91')](_0xc69173,{'model':db[_0x06c2('0x37')],'mapToModel':!![],'raw':!![],'nest':!![]});_0x275f10[_0x06c2('0x44')](_0x06c2('0x84'),_0x06c2('0x65'));_0x275f10[_0x06c2('0x44')]('a.key','Account.key');_0x275f10['field']('i.*');_0x275f10[_0x06c2('0x44')]('c.firstName','Contact.firstName');_0x275f10[_0x06c2('0x44')](_0x06c2('0x6b'),'Contact.lastName');_0x275f10[_0x06c2('0x44')]('c.email','Contact.email');_0x275f10[_0x06c2('0x44')](_0x06c2('0x92'),_0x06c2('0x93'));_0x275f10[_0x06c2('0x44')](_0x06c2('0x94'),_0x06c2('0x95'));_0x275f10[_0x06c2('0x44')]('c.fax','Contact.fax');_0x275f10[_0x06c2('0x44')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0x06c2('0x31'));_0x275f10[_0x06c2('0x4e')](_0x06c2('0x96'),'it',_0x06c2('0x97'));_0x275f10['left_join'](_0x06c2('0x46'),'t',_0x06c2('0x8b'));_0x275f10[_0x06c2('0x24')](_0x38aa98[_0x06c2('0x24')]);_0x275f10[_0x06c2('0x23')](_0x38aa98['offset']);return db[_0x06c2('0x8f')][_0x06c2('0x3b')](_0x275f10[_0x06c2('0x90')](),_0xc69173);})[_0x06c2('0x2b')](function(_0x49a2d3){_0x37aa94['where']('ui.SmsInteractionId\x20IN\x20?',_['map'](_0x49a2d3,'id'));return db[_0x06c2('0x8f')][_0x06c2('0x3b')](_0x37aa94[_0x06c2('0x90')](),_0xc69173)[_0x06c2('0x2b')](function(_0x21e2c6){var _0x2beccb=_[_0x06c2('0x98')](_0x21e2c6,'SmsInteractionId');var _0x48826b=[];_0x49a2d3[_0x06c2('0x34')](function(_0x4fca0a){_0x48826b['push'](updateSmsInteraction(_0x4fca0a,_0x1fd8d4,_0x2beccb));});return BPromise[_0x06c2('0x99')](_0x48826b);});});})[_0x06c2('0x2b')](function(_0x41ae92){_0x25f8bd[_0x06c2('0x9a')]=_0x41ae92;return _0x25f8bd;})['then'](respondWithFilteredResult(_0x210782,_0x38aa98))[_0x06c2('0x9b')](handleError(_0x210782,null));};exports[_0x06c2('0x9c')]=function(_0x19479f,_0xc4c1d5){var _0x12e8a0={'raw':![],'where':{'id':_0x19479f['params']['id']}},_0xdeba07={};_0xdeba07[_0x06c2('0x39')]=_[_0x06c2('0x3a')](db[_0x06c2('0x37')]['rawAttributes']);_0xdeba07[_0x06c2('0x3b')]=_[_0x06c2('0x3a')](_0x19479f['query']);_0xdeba07[_0x06c2('0x3c')]=_[_0x06c2('0x9d')](_0xdeba07[_0x06c2('0x39')],_0xdeba07[_0x06c2('0x3b')]);_0x12e8a0[_0x06c2('0x3d')]=_[_0x06c2('0x9d')](_0xdeba07[_0x06c2('0x39')],qs[_0x06c2('0x3e')](_0x19479f[_0x06c2('0x3b')][_0x06c2('0x3e')]));_0x12e8a0[_0x06c2('0x3d')]=_0x12e8a0[_0x06c2('0x3d')]['length']?_0x12e8a0[_0x06c2('0x3d')]:_0xdeba07[_0x06c2('0x39')];if(_0x19479f[_0x06c2('0x3b')][_0x06c2('0x9e')]){_0x12e8a0[_0x06c2('0x9f')]=[{'all':!![]}];}_0x12e8a0=_[_0x06c2('0x91')]({},_0x12e8a0,_0x19479f[_0x06c2('0xa0')]);return db[_0x06c2('0x37')][_0x06c2('0xa1')](_0x12e8a0)[_0x06c2('0x2b')](handleEntityNotFound(_0xc4c1d5,null))[_0x06c2('0x2b')](respondWithResult(_0xc4c1d5,null))['catch'](handleError(_0xc4c1d5,null));};exports[_0x06c2('0xa2')]=function(_0x5be7c2,_0x38eccb){return db[_0x06c2('0x37')][_0x06c2('0xa2')](_0x5be7c2[_0x06c2('0xa3')],{})['then'](respondWithResult(_0x38eccb,0xc9))['catch'](handleError(_0x38eccb,null));};exports['update']=function(_0x1487c9,_0x3913bd){if(_0x1487c9['body']['id']){delete _0x1487c9[_0x06c2('0xa3')]['id'];}return db[_0x06c2('0x37')][_0x06c2('0xa1')]({'where':{'id':_0x1487c9[_0x06c2('0xa4')]['id']}})[_0x06c2('0x2b')](handleEntityNotFound(_0x3913bd,null))[_0x06c2('0x2b')](saveUpdates(_0x1487c9['body'],null))[_0x06c2('0x2b')](respondWithResult(_0x3913bd,null))[_0x06c2('0x9b')](handleError(_0x3913bd,null));};exports['destroy']=function(_0x326a15,_0x50c42c){return db[_0x06c2('0x37')][_0x06c2('0xa1')]({'where':{'id':_0x326a15[_0x06c2('0xa4')]['id']}})[_0x06c2('0x2b')](handleEntityNotFound(_0x50c42c,null))[_0x06c2('0x2b')](removeEntity(_0x50c42c,null))[_0x06c2('0x9b')](handleError(_0x50c42c,null));};exports[_0x06c2('0xa5')]=function(_0x4e6281,_0x1fb364){return db['SmsInteraction']['describe']()[_0x06c2('0x2b')](respondWithResult(_0x1fb364,null))[_0x06c2('0x9b')](handleError(_0x1fb364,null));};exports['addMessage']=function(_0x5c03ec,_0x40497c,_0x1ce122){return db[_0x06c2('0xa6')][_0x06c2('0xa1')]({'where':{'id':_0x5c03ec[_0x06c2('0xa4')]['id']}})['then'](handleEntityNotFound(_0x40497c,null))[_0x06c2('0x2b')](function(_0x548232){if(_0x548232){return _0x548232[_0x06c2('0xa7')](_0x5c03ec[_0x06c2('0xa3')][_0x06c2('0xa8')],_[_0x06c2('0xa9')](_0x5c03ec[_0x06c2('0xa3')],[_0x06c2('0xa8'),'id'])||{});}})[_0x06c2('0x2b')](respondWithResult(_0x40497c,null))['catch'](handleError(_0x40497c,null));};exports[_0x06c2('0xaa')]=function(_0x3830dd,_0x4379c2,_0x362126){var _0x109599={'raw':![],'where':{}};var _0x3cb759={};var _0x177fda={'count':0x0,'rows':[]};return db['SmsInteraction'][_0x06c2('0xab')]({'where':{'id':_0x3830dd[_0x06c2('0xa4')]['id']}})[_0x06c2('0x2b')](handleEntityNotFound(_0x4379c2,null))[_0x06c2('0x2b')](function(_0x472f28){if(_0x472f28){_0x3cb759[_0x06c2('0x39')]=_['keys'](db[_0x06c2('0xa6')]['rawAttributes']);_0x3cb759[_0x06c2('0x3b')]=_[_0x06c2('0x3a')](_0x3830dd[_0x06c2('0x3b')]);_0x3cb759[_0x06c2('0x3c')]=_['intersection'](_0x3cb759[_0x06c2('0x39')],_0x3cb759['query']);_0x109599[_0x06c2('0x3d')]=_['intersection'](_0x3cb759['model'],qs[_0x06c2('0x3e')](_0x3830dd[_0x06c2('0x3b')][_0x06c2('0x3e')]));_0x109599['attributes']=_0x109599[_0x06c2('0x3d')][_0x06c2('0x3f')]?_0x109599['attributes']:_0x3cb759[_0x06c2('0x39')];if(!_0x3830dd[_0x06c2('0x3b')][_0x06c2('0x40')](_0x06c2('0x41'))){_0x109599[_0x06c2('0x24')]=qs[_0x06c2('0x24')](_0x3830dd['query'][_0x06c2('0x24')]);_0x109599[_0x06c2('0x23')]=qs['offset'](_0x3830dd[_0x06c2('0x3b')][_0x06c2('0x23')]);}_0x109599['order']=qs[_0x06c2('0xac')](_0x3830dd['query'][_0x06c2('0xac')]);_0x109599['where']=qs['filters'](_['pick'](_0x3830dd['query'],_0x3cb759[_0x06c2('0x3c')]));_0x109599['where'][_0x06c2('0xad')]=_0x472f28['id'];if(_0x3830dd[_0x06c2('0x3b')][_0x06c2('0x71')]){_0x109599[_0x06c2('0x42')]=_[_0x06c2('0x91')](_0x109599[_0x06c2('0x42')],{'$or':_['map'](_0x109599['attributes'],function(_0x634c33){var _0x3a0a6e={};_0x3a0a6e[_0x634c33]={'$like':'%'+_0x3830dd['query'][_0x06c2('0x71')]+'%'};return _0x3a0a6e;})});}if(_0x3830dd[_0x06c2('0x3b')][_0x06c2('0x76')]){var _0x30414e=_0x3830dd[_0x06c2('0x3b')][_0x06c2('0x76')]['split'](',');var _0x2cebc6={};_0x2cebc6[_0x30414e[0x0]]={'$gte':moment(_0x30414e[0x1])[_0x06c2('0x5f')](_0x06c2('0xae'))};_0x109599['where']=_[_0x06c2('0x91')](_0x109599[_0x06c2('0x42')],_0x2cebc6);}_0x109599=_[_0x06c2('0x91')]({},_0x109599,_0x3830dd[_0x06c2('0xa0')]);return db['SmsMessage']['count']({'where':_0x109599['where']})[_0x06c2('0x2b')](function(_0x769344){_0x177fda[_0x06c2('0x22')]=_0x769344;if(_0x3830dd[_0x06c2('0x3b')][_0x06c2('0x9e')]){_0x109599[_0x06c2('0x9f')]=[{'all':!![]}];}return db[_0x06c2('0xa6')][_0x06c2('0xaf')](_0x109599);})['then'](function(_0x565255){_0x177fda[_0x06c2('0x9a')]=_0x565255;return _0x177fda;});}})[_0x06c2('0x2b')](respondWithFilteredResult(_0x4379c2,_0x109599))['catch'](handleError(_0x4379c2,null));};exports['addTags']=function(_0x160ec8,_0x49e82e,_0x37ca12){return db[_0x06c2('0x37')][_0x06c2('0xa1')]({'where':{'id':_0x160ec8['params']['id']}})[_0x06c2('0x2b')](handleEntityNotFound(_0x49e82e,null))[_0x06c2('0x2b')](function(_0x203562){if(_0x203562){return _0x203562[_0x06c2('0xb0')](_0x160ec8[_0x06c2('0xa3')][_0x06c2('0xa8')],_['omit'](_0x160ec8[_0x06c2('0xa3')],['ids','id'])||{})[_0x06c2('0xb1')](function(){return db['Tag'][_0x06c2('0xaf')]({'attributes':['id',_0x06c2('0x2d'),_0x06c2('0x45')],'where':{'id':_0x160ec8[_0x06c2('0xa3')][_0x06c2('0xa8')]}});})[_0x06c2('0x2b')](function(_0x4e283d){socket[_0x06c2('0xb2')](_0x06c2('0xb3'),{'id':Number(_0x160ec8[_0x06c2('0xa4')]['id']),'tags':_0x4e283d||[]});return{'id':Number(_0x160ec8['params']['id']),'tags':_0x4e283d||[]};});}})[_0x06c2('0x2b')](respondWithResult(_0x49e82e,null))['catch'](handleError(_0x49e82e,null));};exports[_0x06c2('0xb4')]=function(_0x3319cb,_0x1e25a0,_0x53091f){return db[_0x06c2('0x37')][_0x06c2('0xa1')]({'where':{'id':_0x3319cb[_0x06c2('0xa4')]['id']}})[_0x06c2('0x2b')](handleEntityNotFound(_0x1e25a0,null))['then'](function(_0x116263){if(_0x116263){return _0x116263[_0x06c2('0xb4')](_0x3319cb[_0x06c2('0x3b')][_0x06c2('0xa8')]);}})[_0x06c2('0x2b')](respondWithStatusCode(_0x1e25a0,null))[_0x06c2('0x9b')](handleError(_0x1e25a0,null));};exports['download']=function(_0x401c6e,_0x1f88b6){var _0x547623=moment()[_0x06c2('0xb5')]()[_0x06c2('0x90')]();var _0x19508f=path[_0x06c2('0x7d')](config[_0x06c2('0xb6')],_0x06c2('0xb7'),_0x06c2('0xb8'),_0x06c2('0xb9'));var _0x1e9b73=path[_0x06c2('0x7d')](config['root'],'server',_0x06c2('0xb8'),_0x06c2('0xba'));var _0x219426=path[_0x06c2('0x7d')](_0x19508f,_0x547623);var _0x693e3b=util[_0x06c2('0x5f')]('transcript-%d-%s.zip',_0x401c6e['params']['id'],_0x547623);var _0x1c4eaa=path[_0x06c2('0x7d')](_0x19508f,_0x693e3b);var _0xcf7c1b=![];return db[_0x06c2('0x37')][_0x06c2('0xa1')]({'where':{'id':_0x401c6e['params']['id']},'include':[{'model':db[_0x06c2('0xa6')],'as':'Messages','attributes':['id','body',_0x06c2('0x5a'),_0x06c2('0xbb'),'secret'],'include':[{'model':db[_0x06c2('0xbc')],'as':'User','attributes':['id',_0x06c2('0xbd')],'raw':!![]},{'model':db[_0x06c2('0xbe')],'as':'Contact','attributes':['id',_0x06c2('0xbf'),_0x06c2('0xc0')],'raw':!![]}]},{'model':db[_0x06c2('0xc1')],'as':_0x06c2('0xc2'),'attributes':['id','name']},{'model':db['User'],'as':_0x06c2('0xc3'),'attributes':['id','fullname']}]})[_0x06c2('0x2b')](handleEntityNotFound(_0x1f88b6,null))[_0x06c2('0x2b')](function(_0x4dcd27){if(_0x4dcd27){var _0x26bad0=_0x4dcd27['get']({'plain':!![]});_0xcf7c1b=!![];var _0x2ad849={'format':'A4','border':_0x06c2('0xc4'),'header':{'height':_0x06c2('0xc5'),'contents':{'first':_0x06c2('0xc6')}},'footer':{'height':_0x06c2('0xc7'),'contents':{'default':util[_0x06c2('0x5f')]('<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\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\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\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\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\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\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\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\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\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\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\x20\x20</div>',util[_0x06c2('0x5f')](_0x06c2('0xc8'),'Sms',_0x26bad0['id']),moment()[_0x06c2('0x5f')](_0x06c2('0xc9'))[_0x06c2('0x90')]())}}};fs['mkdirSync'](_0x219426);var _0x53a37f={'channel':_0x06c2('0xca'),'account':_0x26bad0[_0x06c2('0xc2')][_0x06c2('0x2d')],'agent':_0x26bad0[_0x06c2('0xc3')]?_0x26bad0[_0x06c2('0xc3')][_0x06c2('0xbd')]:_0x06c2('0xcb'),'createdAt':moment(_0x26bad0[_0x06c2('0x5a')])['format'](_0x06c2('0xae'))[_0x06c2('0x90')](),'closedAt':_0x26bad0[_0x06c2('0xcc')]?moment(_0x26bad0[_0x06c2('0xcd')])[_0x06c2('0x5f')](_0x06c2('0xae'))['toString']():'','disposition':_0x26bad0[_0x06c2('0xce')],'messages':_(_0x26bad0['Messages'])[_0x06c2('0x71')]({'secret':![]})[_0x06c2('0x30')](function(_0x14dfef){return{'date':moment(_0x14dfef[_0x06c2('0x5a')])[_0x06c2('0x5f')]('YYYY-MM-DD\x20HH:mm:ss')[_0x06c2('0x90')](),'sender':_0x14dfef[_0x06c2('0xbb')]===_0x06c2('0xcf')?_0x14dfef[_0x06c2('0xbc')]?_0x14dfef[_0x06c2('0xbc')][_0x06c2('0xbd')]:_0x06c2('0xd0'):_0x14dfef[_0x06c2('0xd1')][_0x06c2('0xbf')]+(_0x14dfef[_0x06c2('0xd1')][_0x06c2('0xc0')]?'\x20'+_0x14dfef[_0x06c2('0xd1')]['lastName']:''),'body':_0x14dfef[_0x06c2('0xa3')],'direction':_0x14dfef['direction']===_0x06c2('0xcf')?'A':'C','secret':_0x14dfef[_0x06c2('0xd2')]};})['value']()};return ejs[_0x06c2('0xd3')](path[_0x06c2('0x7d')](config[_0x06c2('0xb6')],'server','views',_0x06c2('0xd4')),{'interaction':_0x53a37f})[_0x06c2('0x2b')](function(_0x3fe942){return new BPromise(function(_0x271bec,_0x2c3694){pdf[_0x06c2('0xa2')](_0x3fe942,_0x2ad849)[_0x06c2('0xd5')](path[_0x06c2('0x7d')](_0x219426,'transcript-'+_0x26bad0['id']+'-'+_0x547623+_0x06c2('0xd6')),function(_0xb5ad,_0x1c8d0f){if(_0xb5ad)return _0x2c3694(_0xb5ad);_0x271bec(_0x1c8d0f);});});});}})[_0x06c2('0x2b')](function(){if(_0xcf7c1b){return new BPromise(function(_0x563dc5,_0x5f06e9){zipdir(_0x219426,{'saveTo':_0x1c4eaa},function(_0x5bee77,_0x1d46f1){if(_0x5bee77)return _0x5f06e9(_0x5bee77);return _0x563dc5(_0x1d46f1);});})[_0x06c2('0x2b')](function(){return new BPromise(function(_0x23f55a,_0x11f648){rimraf(_0x219426,function(_0x4481f5){if(_0x4481f5)_0x11f648(_0x4481f5);return _0x23f55a();});});})[_0x06c2('0x2b')](function(){return _0x1f88b6[_0x06c2('0xd7')](_0x1c4eaa,_0x693e3b,function(_0x35a393){if(_0x35a393){console['log'](_0x06c2('0xd8'),_0x35a393);}else{fs[_0x06c2('0xd9')](_0x1c4eaa);}});});}else{return _0x1f88b6[_0x06c2('0xda')](0xc8);}})[_0x06c2('0x9b')](handleError(_0x1f88b6,null));};
\ No newline at end of file
+var _0x2fe3=['day','utc','format','endOf','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','isArray','condition','TagId','\x20IN\x20?','and','tableAlias','\x20=\x20?','LIKE','ContactId','c.lastName','c.email','\x20LIKE\x20?','\x20<\x20?','unreadMessages','c.firstName','\x20>\x20?','filter','isNil','SmsAccountId','concat','createdAt','$gte','null','\x20IS\x20NULL','replace','\x27\x27\x27\x27','i.phone\x20LIKE\x20?','toString','join','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','DESC','group','i.id','QueryTypes','SELECT','clone','COUNT(me.id)','read','having','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','sms_interaction_has_tags','it.SmsInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','t.id\x20IN\x20?','mail_interaction_has_tags','it.MailInteractionId\x20=\x20i.id','tools_tags','sequelize','keyBy','merge','a.key','Account.key','i.*','Contact.lastName','Contact.email','c.phone','Contact.phone','Contact.mobile','c.fax','Contact.fax','all','rows','catch','show','params','includeAll','include','options','find','create','body','destroy','describe','addMessage','SmsMessage','omit','ids','findOne','SmsInteractionId','YYYY-MM-DD\x20HH:mm:ss','findAll','setTags','spread','Tag','emit','smsInteractionTags:save','removeTags','download','unix','root','server','tmp','files','transcript-%d-%s.zip','Messages','direction','secret','User','fullname','firstName','lastName','SmsAccount','Account','Owner','get','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\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\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\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\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\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\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\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\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\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\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\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\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\x20\x20</div>','%s\x20#%d','YYYY-MM-DD','mkdirSync','Sms','N.A.','closed','closedAt','disposition','out','System','Contact','renderFile','views','downloadInteraction.html','toFile','err','unlinkSync','html-pdf','eml-format','fast-json-patch','moment','util','path','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','redis','localhost','socket.io-emitter','./smsInteraction.socket','register','sendStatus','status','end','count','offset','limit','set','json','apply','save','update','then','name','send','map','TagIds','Tags','split','forEach','push','index','SmsInteraction','rawAttributes','keys','query','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','select','field','color','COUNT(*)','from','sms_messages','me.SmsInteractionId\x20=\x20i.id','me.direction\x20=\x20\x27in\x27','me.read\x20=\x20false','u.id','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','o.id\x20=\x20i.UserId','a.id\x20=\x20i.SmsAccountId','me.SmsInteractionId\x20=\x20i.id\x20AND\x20me.direction\x20=\x20\x27in\x27\x20AND\x20me.read\x20=\x20false','expr','advancedFilter','parse','value','dateStart','startOf'];(function(_0x42e7a9,_0x120974){var _0x4f4870=function(_0x237cfe){while(--_0x237cfe){_0x42e7a9['push'](_0x42e7a9['shift']());}};_0x4f4870(++_0x120974);}(_0x2fe3,0x87));var _0x32fe=function(_0x473828,_0x3a0ace){_0x473828=_0x473828-0x0;var _0x39ac77=_0x2fe3[_0x473828];return _0x39ac77;};'use strict';var pdf=require(_0x32fe('0x0'));var emlformat=require(_0x32fe('0x1'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x32fe('0x2'));var rp=require('request-promise');var moment=require(_0x32fe('0x3'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x32fe('0x4'));var path=require(_0x32fe('0x5'));var sox=require('sox');var csv=require(_0x32fe('0x6'));var ejs=require(_0x32fe('0x7'));var fs=require('fs');var _=require(_0x32fe('0x8'));var squel=require(_0x32fe('0x9'));var crypto=require(_0x32fe('0xa'));var jsforce=require(_0x32fe('0xb'));var deskjs=require('desk.js');var toCsv=require(_0x32fe('0x6'));var querystring=require(_0x32fe('0xc'));var Papa=require(_0x32fe('0xd'));var Redis=require(_0x32fe('0xe'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var hardwareService=require(_0x32fe('0xf'));var logger=require(_0x32fe('0x10'))(_0x32fe('0x11'));var utils=require(_0x32fe('0x12'));var config=require('../../config/environment');var db=require(_0x32fe('0x13'))['db'];config['redis']=_['defaults'](config[_0x32fe('0x14')],{'host':_0x32fe('0x15'),'port':0x18eb});var socket=require(_0x32fe('0x16'))(new Redis(config[_0x32fe('0x14')]));require(_0x32fe('0x17'))[_0x32fe('0x18')](socket);function respondWithStatusCode(_0x3dc281,_0x427edd){_0x427edd=_0x427edd||0xcc;return function(_0xa9ab){if(_0xa9ab){return _0x3dc281[_0x32fe('0x19')](_0x427edd);}return _0x3dc281[_0x32fe('0x1a')](_0x427edd)[_0x32fe('0x1b')]();};}function respondWithResult(_0x31a6c0,_0x625793){_0x625793=_0x625793||0xc8;return function(_0x175fd1){if(_0x175fd1){return _0x31a6c0['status'](_0x625793)['json'](_0x175fd1);}};}function respondWithFilteredResult(_0x1e9d18,_0x269a6e){return function(_0x5846ca){if(_0x5846ca){var _0x2c0157=_0x5846ca[_0x32fe('0x1c')],_0x69299f=_0x269a6e[_0x32fe('0x1d')],_0x3559c5=_0x269a6e[_0x32fe('0x1d')]+_0x269a6e[_0x32fe('0x1e')],_0x5000ee;if(_0x3559c5>=_0x2c0157){_0x3559c5=_0x2c0157;_0x5000ee=0xc8;}else{_0x5000ee=0xce;}_0x1e9d18['status'](_0x5000ee);return _0x1e9d18[_0x32fe('0x1f')]('Content-Range',_0x69299f+'-'+_0x3559c5+'/'+_0x2c0157)[_0x32fe('0x20')](_0x5846ca);}return null;};}function patchUpdates(_0x2702ad){return function(_0x23b317){try{jsonpatch[_0x32fe('0x21')](_0x23b317,_0x2702ad,!![]);}catch(_0x5964cc){return BPromise['reject'](_0x5964cc);}return _0x23b317[_0x32fe('0x22')]();};}function saveUpdates(_0x297212,_0x14ec68){return function(_0xbd0cb){if(_0xbd0cb){return _0xbd0cb[_0x32fe('0x23')](_0x297212)[_0x32fe('0x24')](function(_0x2de8ca){return _0x2de8ca;});}return null;};}function removeEntity(_0x3cb8a5,_0x521262){return function(_0x3a158e){if(_0x3a158e){return _0x3a158e['destroy']()[_0x32fe('0x24')](function(){_0x3cb8a5[_0x32fe('0x1a')](0xcc)['end']();});}};}function handleEntityNotFound(_0xd88903,_0x21d970){return function(_0x84f0c4){if(!_0x84f0c4){_0xd88903[_0x32fe('0x19')](0x194);}return _0x84f0c4;};}function handleError(_0x55a823,_0x50e340){_0x50e340=_0x50e340||0x1f4;return function(_0x4329e5){logger['error'](_0x4329e5['stack']);if(_0x4329e5[_0x32fe('0x25')]){delete _0x4329e5['name'];}_0x55a823[_0x32fe('0x1a')](_0x50e340)[_0x32fe('0x26')](_0x4329e5);};}function getInteractionUsers(_0x1f67c9,_0x382242){return new BPromise(function(_0x49bb6c,_0x2fe81f){try{if(_0x382242[_0x1f67c9['id']]){_0x1f67c9['Users']=_[_0x32fe('0x27')](_0x382242[_0x1f67c9['id']],function(_0x49c851){return{'id':_0x49c851['id']};});}}catch(_0x497131){_0x2fe81f(_0x497131);}_0x49bb6c(_0x1f67c9);});}function getInteractionTags(_0xbee08,_0x536044){return new BPromise(function(_0x45d2b1,_0x552eae){try{if(_0xbee08[_0x32fe('0x28')]){_0xbee08[_0x32fe('0x29')]=[];_0xbee08[_0x32fe('0x28')][_0x32fe('0x2a')](',')[_0x32fe('0x2b')](function(_0x242872){_0xbee08[_0x32fe('0x29')][_0x32fe('0x2c')](_0x536044[_0x242872]);});}delete _0xbee08[_0x32fe('0x28')];}catch(_0x5f5869){_0x552eae(_0x5f5869);}_0x45d2b1(_0xbee08);});}function updateSmsInteraction(_0x3c6a22,_0x287423,_0x37927b){return new BPromise(function(_0x4db275,_0x97c149){return getInteractionUsers(_0x3c6a22,_0x37927b)[_0x32fe('0x24')](function(_0x3dbd77){return getInteractionTags(_0x3dbd77,_0x287423);})[_0x32fe('0x24')](function(_0xdf0236){_0x4db275(_0xdf0236);})['catch'](function(_0x554696){_0x97c149(_0x554696);});});}exports[_0x32fe('0x2d')]=function(_0x239766,_0x596aae){var _0x2c9fa6={},_0x1a0471={},_0x5cf9c6={'count':0x0,'rows':[]};var _0x3c0d26=db[_0x32fe('0x2e')][_0x32fe('0x2f')];_0x1a0471['model']=_[_0x32fe('0x30')](_0x3c0d26);_0x1a0471[_0x32fe('0x31')]=_['keys'](_0x239766[_0x32fe('0x31')]);_0x1a0471[_0x32fe('0x32')]=_[_0x32fe('0x33')](_0x1a0471[_0x32fe('0x34')],_0x1a0471[_0x32fe('0x31')]);_0x2c9fa6[_0x32fe('0x35')]=_[_0x32fe('0x33')](_0x1a0471[_0x32fe('0x34')],qs[_0x32fe('0x36')](_0x239766[_0x32fe('0x31')][_0x32fe('0x36')]));_0x2c9fa6[_0x32fe('0x35')]=_0x2c9fa6['attributes'][_0x32fe('0x37')]?_0x2c9fa6['attributes']:_0x1a0471['model'];if(!_0x239766[_0x32fe('0x31')][_0x32fe('0x38')](_0x32fe('0x39'))){_0x2c9fa6['limit']=qs[_0x32fe('0x1e')](_0x239766['query'][_0x32fe('0x1e')]);_0x2c9fa6[_0x32fe('0x1d')]=qs[_0x32fe('0x1d')](_0x239766['query']['offset']);}_0x2c9fa6[_0x32fe('0x3a')]=qs[_0x32fe('0x3b')](_0x239766['query']['sort']);_0x2c9fa6[_0x32fe('0x3c')]=qs[_0x32fe('0x32')](_[_0x32fe('0x3d')](_0x239766['query'],_0x1a0471[_0x32fe('0x32')]));var _0x367ac5=[];var _0x4adcbe=squel[_0x32fe('0x3e')]()['field']('id')[_0x32fe('0x3f')]('name')['field'](_0x32fe('0x40'))['from']('tools_tags');var _0x4cd506=squel[_0x32fe('0x3e')]()[_0x32fe('0x3f')](_0x32fe('0x41'))[_0x32fe('0x42')](_0x32fe('0x43'),'me')[_0x32fe('0x3c')](_0x32fe('0x44'))[_0x32fe('0x3c')](_0x32fe('0x45'))[_0x32fe('0x3c')](_0x32fe('0x46'));var _0x353ba0=squel[_0x32fe('0x3e')]()[_0x32fe('0x3f')](_0x32fe('0x47'))[_0x32fe('0x3f')](_0x32fe('0x48'))[_0x32fe('0x42')](_0x32fe('0x49'),'ui')[_0x32fe('0x4a')](_0x32fe('0x4b'),'u',_0x32fe('0x4c'));var _0x55ebed=squel[_0x32fe('0x3e')]()[_0x32fe('0x42')](_0x32fe('0x4d'),'i')['left_join'](_0x32fe('0x4e'),'c',_0x32fe('0x4f'))[_0x32fe('0x4a')](_0x32fe('0x4b'),'o',_0x32fe('0x50'))[_0x32fe('0x4a')]('sms_accounts','a',_0x32fe('0x51'))[_0x32fe('0x4a')]('sms_messages','me',_0x32fe('0x52'));var _0x3e0c53=squel[_0x32fe('0x53')]();if(_0x239766[_0x32fe('0x31')][_0x32fe('0x54')]){var _0x111321=JSON[_0x32fe('0x55')](_0x239766[_0x32fe('0x31')][_0x32fe('0x54')]);_[_0x32fe('0x30')](_0x111321)[_0x32fe('0x2b')](function(_0x844907){var _0x4e24e5=_0x111321[_0x844907];if(_0x844907==='createdAt'){var _0x4c9cc5=moment(_0x4e24e5[_0x32fe('0x56')][_0x32fe('0x57')])[_0x32fe('0x58')](_0x32fe('0x59'))[_0x32fe('0x5a')]()[_0x32fe('0x5b')]();var _0x4eab43=moment(_0x4eab43)['utc']()[_0x32fe('0x5c')](_0x32fe('0x59'))[_0x32fe('0x5b')]();_0x3e0c53['and'](_0x32fe('0x5d'),_0x4c9cc5,_0x4eab43);}else{if(_[_0x32fe('0x5e')](_0x4e24e5['condition'])){_0x4e24e5[_0x32fe('0x5f')][_0x32fe('0x2b')](function(_0x242284){switch(_0x4e24e5[_0x32fe('0x5f')][_0x32fe('0x56')]){case'IS':if(_0x844907!==_0x32fe('0x60')&&_0x844907!=='unreadMessages'){if(_[_0x32fe('0x5e')](_0x4e24e5[_0x32fe('0x56')])&&_0x4e24e5[_0x32fe('0x56')][_0x32fe('0x37')]>0x1){_0x3e0c53['and'](_0x4e24e5['tableAlias']+'.'+_0x844907+_0x32fe('0x61'),_0x4e24e5[_0x32fe('0x56')]);}else{_0x3e0c53[_0x32fe('0x62')](_0x4e24e5[_0x32fe('0x63')]+'.'+_0x844907+'\x20=\x20?',_0x4e24e5[_0x32fe('0x56')][0x0]);}}break;case'=':_0x3e0c53[_0x32fe('0x62')](_0x4e24e5['tableAlias']+'.'+_0x844907+_0x32fe('0x64'),_0x4e24e5[_0x32fe('0x56')]);break;case _0x32fe('0x65'):if(_0x844907===_0x32fe('0x66')){_0x3e0c53[_0x32fe('0x62')]('c.firstName'+'\x20LIKE\x20?','%'+_0x4e24e5[_0x32fe('0x56')]+'%');_0x3e0c53['or'](_0x32fe('0x67')+'\x20LIKE\x20?','%'+_0x4e24e5[_0x32fe('0x56')]+'%');_0x3e0c53['or'](_0x32fe('0x68')+_0x32fe('0x69'),'%'+_0x4e24e5[_0x32fe('0x56')]+'%');}else{_0x3e0c53[_0x32fe('0x62')](_0x4e24e5[_0x32fe('0x63')]+'.'+_0x844907+'\x20LIKE\x20?','%'+_0x4e24e5[_0x32fe('0x56')]+'%');}break;case'>':_0x3e0c53[_0x32fe('0x62')](_0x4e24e5[_0x32fe('0x63')]+'.'+_0x844907+'\x20>\x20?',_0x4e24e5[_0x32fe('0x56')]);break;case'<':_0x3e0c53[_0x32fe('0x62')](_0x4e24e5[_0x32fe('0x63')]+'.'+_0x844907+_0x32fe('0x6a'),_0x4e24e5[_0x32fe('0x56')]);break;}});}else{switch(_0x4e24e5['condition'][_0x32fe('0x56')]){case'IS':if(_0x844907!==_0x32fe('0x60')&&_0x844907!==_0x32fe('0x6b')){if(_[_0x32fe('0x5e')](_0x4e24e5[_0x32fe('0x56')])&&_0x4e24e5['value'][_0x32fe('0x37')]>0x1){_0x3e0c53[_0x32fe('0x62')](_0x4e24e5[_0x32fe('0x63')]+'.'+_0x844907+_0x32fe('0x61'),_0x4e24e5[_0x32fe('0x56')]);}else{_0x3e0c53[_0x32fe('0x62')](_0x4e24e5['tableAlias']+'.'+_0x844907+_0x32fe('0x64'),_0x4e24e5[_0x32fe('0x56')][0x0]);}}break;case'=':_0x3e0c53[_0x32fe('0x62')](_0x4e24e5[_0x32fe('0x63')]+'.'+_0x844907+_0x32fe('0x64'),_0x4e24e5[_0x32fe('0x56')]);break;case'LIKE':if(_0x844907===_0x32fe('0x66')){_0x3e0c53[_0x32fe('0x62')](_0x32fe('0x6c')+'\x20LIKE\x20?','%'+_0x4e24e5[_0x32fe('0x56')]+'%');_0x3e0c53['or']('c.lastName'+_0x32fe('0x69'),'%'+_0x4e24e5[_0x32fe('0x56')]+'%');_0x3e0c53['or'](_0x32fe('0x68')+_0x32fe('0x69'),'%'+_0x4e24e5[_0x32fe('0x56')]+'%');}else{_0x3e0c53[_0x32fe('0x62')](_0x4e24e5[_0x32fe('0x63')]+'.'+_0x844907+_0x32fe('0x69'),'%'+_0x4e24e5[_0x32fe('0x56')]+'%');}break;case'>':_0x3e0c53['and'](_0x4e24e5['tableAlias']+'.'+_0x844907+_0x32fe('0x6d'),_0x4e24e5[_0x32fe('0x56')]);break;case'<':_0x3e0c53['and'](_0x4e24e5[_0x32fe('0x63')]+'.'+_0x844907+'\x20<\x20?',_0x4e24e5[_0x32fe('0x56')]);break;}}}});}else{var _0x40ceb4=_(Object[_0x32fe('0x30')](_0x239766[_0x32fe('0x31')]))['map'](function(_0x3f0f28){return _0x3c0d26[_0x32fe('0x38')](_0x3f0f28)?_0x3f0f28:undefined;})[_0x32fe('0x6e')](function(_0x1fa6db){return!_[_0x32fe('0x6f')](_0x1fa6db);})[_0x32fe('0x56')]();if(!_['isEmpty'](_0x40ceb4)){_0x40ceb4['forEach'](function(_0x2a9373){if(_0x2a9373===_0x32fe('0x70')){_0x55ebed[_0x32fe('0x3c')]('i.SmsAccountId\x20IN\x20?',[][_0x32fe('0x71')](_0x239766[_0x32fe('0x31')][_0x2a9373]));}else if(_0x2a9373===_0x32fe('0x72')){var _0x4dd064=JSON[_0x32fe('0x55')](_0x239766[_0x32fe('0x31')][_0x2a9373])[_0x32fe('0x73')];var _0x1c1f8a=JSON[_0x32fe('0x55')](_0x239766[_0x32fe('0x31')][_0x2a9373])['$lte'];_0x55ebed[_0x32fe('0x3c')](_0x32fe('0x5d'),_0x4dd064,_0x1c1f8a);}else{if(_0x239766[_0x32fe('0x31')][_0x2a9373]===_0x32fe('0x74')){_0x55ebed[_0x32fe('0x3c')]('i.'+_0x2a9373+_0x32fe('0x75'));}else{_0x55ebed['where']('i.'+_0x2a9373+_0x32fe('0x64'),_0x239766['query'][_0x2a9373]);}}});}if(_0x239766[_0x32fe('0x31')][_0x32fe('0x6e')]){var _0x2adca7=_0x239766[_0x32fe('0x31')][_0x32fe('0x6e')][_0x32fe('0x76')]('\x5c','\x5c\x5c')[_0x32fe('0x76')]('\x27\x27',_0x32fe('0x77'));if(qs['isNumeric'](_0x2adca7)){_0x3e0c53['or']('i.id\x20LIKE\x20?',_0x2adca7+'%')['or'](_0x32fe('0x78'),_0x2adca7+'%');}else{var _0xcd85db=[];_0x2adca7['split']('\x20')[_0x32fe('0x2b')](function(_0x103529){_0xcd85db[_0x32fe('0x2c')]('+'+_0x103529[_0x32fe('0x79')]());});var _0x30225a=_0xcd85db[_0x32fe('0x7a')]('\x20');_0x3e0c53['or'](_0x32fe('0x7b'),_0x30225a)['or'](_0x32fe('0x7c'),_0x2adca7+'%');}}}_0x55ebed['where'](_0x3e0c53);if(_0x2c9fa6[_0x32fe('0x3a')]){_0x2c9fa6[_0x32fe('0x3a')][_0x32fe('0x2b')](function(_0x5bd7ce){_0x55ebed[_0x32fe('0x3a')]('i.'+_0x5bd7ce[0x0],_0x5bd7ce[0x1]===_0x32fe('0x7d')?![]:!![]);});}_0x55ebed[_0x32fe('0x7e')](_0x32fe('0x7f'));var _0x31e720={'type':db['Sequelize'][_0x32fe('0x80')][_0x32fe('0x81')],'raw':!![]};var _0xd351ec=_0x55ebed[_0x32fe('0x82')]()['field']('COUNT(*)')[_0x32fe('0x3f')](_0x32fe('0x83'),_0x32fe('0x6b'));if(!_0x239766['query']['advancedFilter']){if(_0x239766[_0x32fe('0x31')][_0x32fe('0x84')]){if(_0x239766[_0x32fe('0x31')][_0x32fe('0x84')]==0x1){_0xd351ec[_0x32fe('0x85')]('`unreadMessages`\x20=\x200');_0x55ebed[_0x32fe('0x85')](_0x32fe('0x86'));}else{_0xd351ec['having'](_0x32fe('0x87'));_0x55ebed[_0x32fe('0x85')](_0x32fe('0x87'));}}if(_0x239766[_0x32fe('0x31')][_0x32fe('0x88')]){var _0x3f774a=_['isArray'](_0x239766['query']['tag'])?_0x239766[_0x32fe('0x31')][_0x32fe('0x88')]:new Array(_0x239766[_0x32fe('0x31')][_0x32fe('0x88')]);var _0x2c23b0=squel[_0x32fe('0x53')]();_0x3f774a[_0x32fe('0x2b')](function(_0x649ffc){_0x2c23b0['or'](_0x32fe('0x89'),'%,'+_0x649ffc+',%');});_0x55ebed[_0x32fe('0x85')](_0x2c23b0);_0xd351ec[_0x32fe('0x4a')](_0x32fe('0x8a'),'it',_0x32fe('0x8b'));_0xd351ec['left_join']('tools_tags','t',_0x32fe('0x8c'));_0xd351ec[_0x32fe('0x3c')](_0x32fe('0x8d'),_0x3f774a);}}else{var _0x111321=JSON[_0x32fe('0x55')](_0x239766[_0x32fe('0x31')][_0x32fe('0x54')]);_[_0x32fe('0x30')](_0x111321)['forEach'](function(_0x48fa91){var _0x128e27=_0x111321[_0x48fa91];if(_0x48fa91==='TagId'){var _0x56a446=_0x128e27[_0x32fe('0x56')];var _0xcf655b=squel['expr']();_0x56a446[_0x32fe('0x2b')](function(_0x1939d9){_0xcf655b['or'](_0x32fe('0x89'),'%,'+_0x1939d9+',%');});_0x55ebed[_0x32fe('0x85')](_0xcf655b);_0xd351ec[_0x32fe('0x4a')](_0x32fe('0x8e'),'it',_0x32fe('0x8f'));_0xd351ec['left_join'](_0x32fe('0x90'),'t',_0x32fe('0x8c'));_0xd351ec['where'](_0x32fe('0x8d'),_0x56a446);}else if(_0x48fa91==='unreadMessages'){if(_0x128e27[_0x32fe('0x56')][_0x32fe('0x37')]===0x1){if(_0x128e27[_0x32fe('0x56')][0x0]===0x1){_0xd351ec[_0x32fe('0x85')](_0x32fe('0x86'));_0x55ebed['having']('`unreadMessages`\x20=\x200');}else{_0xd351ec['having'](_0x32fe('0x87'));_0x55ebed[_0x32fe('0x85')]('`unreadMessages`\x20>\x200');}}}});}db[_0x32fe('0x91')]['query'](_0xd351ec['toString'](),_0x31e720)['then'](function(_0x386425){_0x5cf9c6['count']=_0x386425[_0x32fe('0x37')];if(_0x5cf9c6[_0x32fe('0x1c')]===0x0)return[];return db[_0x32fe('0x91')][_0x32fe('0x31')](_0x4adcbe[_0x32fe('0x79')](),_0x31e720)['then'](function(_0x5c6a80){_0x367ac5=_[_0x32fe('0x92')](_0x5c6a80,'id');_0x31e720=_[_0x32fe('0x93')](_0x31e720,{'model':db[_0x32fe('0x2e')],'mapToModel':!![],'raw':!![],'nest':!![]});_0x55ebed[_0x32fe('0x3f')](_0x32fe('0x83'),'unreadMessages');_0x55ebed[_0x32fe('0x3f')](_0x32fe('0x94'),_0x32fe('0x95'));_0x55ebed['field'](_0x32fe('0x96'));_0x55ebed[_0x32fe('0x3f')](_0x32fe('0x6c'),'Contact.firstName');_0x55ebed['field'](_0x32fe('0x67'),_0x32fe('0x97'));_0x55ebed[_0x32fe('0x3f')](_0x32fe('0x68'),_0x32fe('0x98'));_0x55ebed['field'](_0x32fe('0x99'),_0x32fe('0x9a'));_0x55ebed[_0x32fe('0x3f')]('c.mobile',_0x32fe('0x9b'));_0x55ebed[_0x32fe('0x3f')](_0x32fe('0x9c'),_0x32fe('0x9d'));_0x55ebed['field']('GROUP_CONCAT(DISTINCT\x20t.id)',_0x32fe('0x28'));_0x55ebed['left_join'](_0x32fe('0x8a'),'it',_0x32fe('0x8b'));_0x55ebed['left_join'](_0x32fe('0x90'),'t',_0x32fe('0x8c'));_0x55ebed[_0x32fe('0x1e')](_0x2c9fa6[_0x32fe('0x1e')]);_0x55ebed[_0x32fe('0x1d')](_0x2c9fa6['offset']);return db[_0x32fe('0x91')][_0x32fe('0x31')](_0x55ebed[_0x32fe('0x79')](),_0x31e720);})[_0x32fe('0x24')](function(_0x17992d){_0x353ba0[_0x32fe('0x3c')]('ui.SmsInteractionId\x20IN\x20?',_[_0x32fe('0x27')](_0x17992d,'id'));return db[_0x32fe('0x91')]['query'](_0x353ba0[_0x32fe('0x79')](),_0x31e720)['then'](function(_0x5dc9e6){var _0x45c4c8=_['groupBy'](_0x5dc9e6,'SmsInteractionId');var _0x22c364=[];_0x17992d[_0x32fe('0x2b')](function(_0x43280d){_0x22c364['push'](updateSmsInteraction(_0x43280d,_0x367ac5,_0x45c4c8));});return BPromise[_0x32fe('0x9e')](_0x22c364);});});})[_0x32fe('0x24')](function(_0x402795){_0x5cf9c6[_0x32fe('0x9f')]=_0x402795;return _0x5cf9c6;})[_0x32fe('0x24')](respondWithFilteredResult(_0x596aae,_0x2c9fa6))[_0x32fe('0xa0')](handleError(_0x596aae,null));};exports[_0x32fe('0xa1')]=function(_0x5b9204,_0x584942){var _0x26c359={'raw':![],'where':{'id':_0x5b9204[_0x32fe('0xa2')]['id']}},_0x13ee4f={};_0x13ee4f[_0x32fe('0x34')]=_[_0x32fe('0x30')](db[_0x32fe('0x2e')][_0x32fe('0x2f')]);_0x13ee4f[_0x32fe('0x31')]=_[_0x32fe('0x30')](_0x5b9204['query']);_0x13ee4f['filters']=_[_0x32fe('0x33')](_0x13ee4f[_0x32fe('0x34')],_0x13ee4f[_0x32fe('0x31')]);_0x26c359['attributes']=_[_0x32fe('0x33')](_0x13ee4f[_0x32fe('0x34')],qs[_0x32fe('0x36')](_0x5b9204['query'][_0x32fe('0x36')]));_0x26c359[_0x32fe('0x35')]=_0x26c359[_0x32fe('0x35')][_0x32fe('0x37')]?_0x26c359[_0x32fe('0x35')]:_0x13ee4f['model'];if(_0x5b9204[_0x32fe('0x31')][_0x32fe('0xa3')]){_0x26c359[_0x32fe('0xa4')]=[{'all':!![]}];}_0x26c359=_[_0x32fe('0x93')]({},_0x26c359,_0x5b9204[_0x32fe('0xa5')]);return db['SmsInteraction'][_0x32fe('0xa6')](_0x26c359)['then'](handleEntityNotFound(_0x584942,null))['then'](respondWithResult(_0x584942,null))[_0x32fe('0xa0')](handleError(_0x584942,null));};exports['create']=function(_0x32b02a,_0x52aa3f){return db[_0x32fe('0x2e')][_0x32fe('0xa7')](_0x32b02a[_0x32fe('0xa8')],{})[_0x32fe('0x24')](respondWithResult(_0x52aa3f,0xc9))[_0x32fe('0xa0')](handleError(_0x52aa3f,null));};exports['update']=function(_0x3980b7,_0x542b2a){if(_0x3980b7[_0x32fe('0xa8')]['id']){delete _0x3980b7[_0x32fe('0xa8')]['id'];}return db['SmsInteraction'][_0x32fe('0xa6')]({'where':{'id':_0x3980b7[_0x32fe('0xa2')]['id']}})[_0x32fe('0x24')](handleEntityNotFound(_0x542b2a,null))[_0x32fe('0x24')](saveUpdates(_0x3980b7[_0x32fe('0xa8')],null))['then'](respondWithResult(_0x542b2a,null))[_0x32fe('0xa0')](handleError(_0x542b2a,null));};exports[_0x32fe('0xa9')]=function(_0x15e31c,_0xaf57b8){return db[_0x32fe('0x2e')]['find']({'where':{'id':_0x15e31c[_0x32fe('0xa2')]['id']}})[_0x32fe('0x24')](handleEntityNotFound(_0xaf57b8,null))[_0x32fe('0x24')](removeEntity(_0xaf57b8,null))[_0x32fe('0xa0')](handleError(_0xaf57b8,null));};exports['describe']=function(_0x1c3912,_0xb149c){return db['SmsInteraction'][_0x32fe('0xaa')]()[_0x32fe('0x24')](respondWithResult(_0xb149c,null))['catch'](handleError(_0xb149c,null));};exports[_0x32fe('0xab')]=function(_0x2c6d78,_0x146e94,_0x565295){return db[_0x32fe('0xac')]['find']({'where':{'id':_0x2c6d78[_0x32fe('0xa2')]['id']}})['then'](handleEntityNotFound(_0x146e94,null))[_0x32fe('0x24')](function(_0xe74e32){if(_0xe74e32){return _0xe74e32[_0x32fe('0xab')](_0x2c6d78[_0x32fe('0xa8')]['ids'],_[_0x32fe('0xad')](_0x2c6d78[_0x32fe('0xa8')],[_0x32fe('0xae'),'id'])||{});}})[_0x32fe('0x24')](respondWithResult(_0x146e94,null))['catch'](handleError(_0x146e94,null));};exports['getMessages']=function(_0x43dc82,_0x35fe22,_0x4b346a){var _0x251f5c={'raw':![],'where':{}};var _0x2079d3={};var _0x34c196={'count':0x0,'rows':[]};return db[_0x32fe('0x2e')][_0x32fe('0xaf')]({'where':{'id':_0x43dc82[_0x32fe('0xa2')]['id']}})['then'](handleEntityNotFound(_0x35fe22,null))[_0x32fe('0x24')](function(_0x4c7ee3){if(_0x4c7ee3){_0x2079d3['model']=_[_0x32fe('0x30')](db[_0x32fe('0xac')]['rawAttributes']);_0x2079d3[_0x32fe('0x31')]=_['keys'](_0x43dc82[_0x32fe('0x31')]);_0x2079d3['filters']=_['intersection'](_0x2079d3[_0x32fe('0x34')],_0x2079d3[_0x32fe('0x31')]);_0x251f5c[_0x32fe('0x35')]=_['intersection'](_0x2079d3['model'],qs[_0x32fe('0x36')](_0x43dc82[_0x32fe('0x31')][_0x32fe('0x36')]));_0x251f5c[_0x32fe('0x35')]=_0x251f5c[_0x32fe('0x35')][_0x32fe('0x37')]?_0x251f5c[_0x32fe('0x35')]:_0x2079d3[_0x32fe('0x34')];if(!_0x43dc82['query'][_0x32fe('0x38')](_0x32fe('0x39'))){_0x251f5c[_0x32fe('0x1e')]=qs[_0x32fe('0x1e')](_0x43dc82[_0x32fe('0x31')][_0x32fe('0x1e')]);_0x251f5c[_0x32fe('0x1d')]=qs['offset'](_0x43dc82['query'][_0x32fe('0x1d')]);}_0x251f5c[_0x32fe('0x3a')]=qs['sort'](_0x43dc82[_0x32fe('0x31')]['sort']);_0x251f5c[_0x32fe('0x3c')]=qs[_0x32fe('0x32')](_[_0x32fe('0x3d')](_0x43dc82[_0x32fe('0x31')],_0x2079d3['filters']));_0x251f5c[_0x32fe('0x3c')][_0x32fe('0xb0')]=_0x4c7ee3['id'];if(_0x43dc82[_0x32fe('0x31')]['filter']){_0x251f5c['where']=_[_0x32fe('0x93')](_0x251f5c[_0x32fe('0x3c')],{'$or':_[_0x32fe('0x27')](_0x251f5c[_0x32fe('0x35')],function(_0x35c89a){var _0x13f2a1={};_0x13f2a1[_0x35c89a]={'$like':'%'+_0x43dc82[_0x32fe('0x31')][_0x32fe('0x6e')]+'%'};return _0x13f2a1;})});}if(_0x43dc82['query'][_0x32fe('0x73')]){var _0x16bebf=_0x43dc82[_0x32fe('0x31')]['$gte'][_0x32fe('0x2a')](',');var _0x37ec58={};_0x37ec58[_0x16bebf[0x0]]={'$gte':moment(_0x16bebf[0x1])[_0x32fe('0x5b')](_0x32fe('0xb1'))};_0x251f5c[_0x32fe('0x3c')]=_[_0x32fe('0x93')](_0x251f5c[_0x32fe('0x3c')],_0x37ec58);}_0x251f5c=_[_0x32fe('0x93')]({},_0x251f5c,_0x43dc82['options']);return db['SmsMessage'][_0x32fe('0x1c')]({'where':_0x251f5c['where']})['then'](function(_0xfb366f){_0x34c196[_0x32fe('0x1c')]=_0xfb366f;if(_0x43dc82[_0x32fe('0x31')][_0x32fe('0xa3')]){_0x251f5c[_0x32fe('0xa4')]=[{'all':!![]}];}return db[_0x32fe('0xac')][_0x32fe('0xb2')](_0x251f5c);})[_0x32fe('0x24')](function(_0x1adc79){_0x34c196['rows']=_0x1adc79;return _0x34c196;});}})[_0x32fe('0x24')](respondWithFilteredResult(_0x35fe22,_0x251f5c))[_0x32fe('0xa0')](handleError(_0x35fe22,null));};exports['addTags']=function(_0x41bab9,_0xc8e811,_0x2d3cff){return db[_0x32fe('0x2e')]['find']({'where':{'id':_0x41bab9[_0x32fe('0xa2')]['id']}})['then'](handleEntityNotFound(_0xc8e811,null))['then'](function(_0x42fe33){if(_0x42fe33){return _0x42fe33[_0x32fe('0xb3')](_0x41bab9[_0x32fe('0xa8')][_0x32fe('0xae')],_[_0x32fe('0xad')](_0x41bab9['body'],['ids','id'])||{})[_0x32fe('0xb4')](function(){return db[_0x32fe('0xb5')][_0x32fe('0xb2')]({'attributes':['id',_0x32fe('0x25'),_0x32fe('0x40')],'where':{'id':_0x41bab9[_0x32fe('0xa8')][_0x32fe('0xae')]}});})['then'](function(_0x3073af){socket[_0x32fe('0xb6')](_0x32fe('0xb7'),{'id':Number(_0x41bab9['params']['id']),'tags':_0x3073af||[]});return{'id':Number(_0x41bab9[_0x32fe('0xa2')]['id']),'tags':_0x3073af||[]};});}})[_0x32fe('0x24')](respondWithResult(_0xc8e811,null))[_0x32fe('0xa0')](handleError(_0xc8e811,null));};exports[_0x32fe('0xb8')]=function(_0x3f8429,_0x1148c3,_0x751fda){return db[_0x32fe('0x2e')]['find']({'where':{'id':_0x3f8429[_0x32fe('0xa2')]['id']}})[_0x32fe('0x24')](handleEntityNotFound(_0x1148c3,null))['then'](function(_0x345cbe){if(_0x345cbe){return _0x345cbe[_0x32fe('0xb8')](_0x3f8429['query']['ids']);}})[_0x32fe('0x24')](respondWithStatusCode(_0x1148c3,null))['catch'](handleError(_0x1148c3,null));};exports[_0x32fe('0xb9')]=function(_0x369c86,_0x25e295){var _0x107900=moment()[_0x32fe('0xba')]()['toString']();var _0x1c985e=path[_0x32fe('0x7a')](config[_0x32fe('0xbb')],_0x32fe('0xbc'),'files',_0x32fe('0xbd'));var _0x2d42eb=path[_0x32fe('0x7a')](config['root'],'server',_0x32fe('0xbe'),'attachments');var _0x4082c6=path[_0x32fe('0x7a')](_0x1c985e,_0x107900);var _0x2cb4ba=util[_0x32fe('0x5b')](_0x32fe('0xbf'),_0x369c86[_0x32fe('0xa2')]['id'],_0x107900);var _0x2a881b=path['join'](_0x1c985e,_0x2cb4ba);var _0x197cf6=![];return db[_0x32fe('0x2e')][_0x32fe('0xa6')]({'where':{'id':_0x369c86[_0x32fe('0xa2')]['id']},'include':[{'model':db[_0x32fe('0xac')],'as':_0x32fe('0xc0'),'attributes':['id',_0x32fe('0xa8'),'createdAt',_0x32fe('0xc1'),_0x32fe('0xc2')],'include':[{'model':db[_0x32fe('0xc3')],'as':_0x32fe('0xc3'),'attributes':['id',_0x32fe('0xc4')],'raw':!![]},{'model':db['CmContact'],'as':'Contact','attributes':['id',_0x32fe('0xc5'),_0x32fe('0xc6')],'raw':!![]}]},{'model':db[_0x32fe('0xc7')],'as':_0x32fe('0xc8'),'attributes':['id',_0x32fe('0x25')]},{'model':db[_0x32fe('0xc3')],'as':_0x32fe('0xc9'),'attributes':['id',_0x32fe('0xc4')]}]})[_0x32fe('0x24')](handleEntityNotFound(_0x25e295,null))[_0x32fe('0x24')](function(_0x42a53d){if(_0x42a53d){var _0x4499be=_0x42a53d[_0x32fe('0xca')]({'plain':!![]});_0x197cf6=!![];var _0x569a84={'format':'A4','border':_0x32fe('0xcb'),'header':{'height':'40px','contents':{'first':_0x32fe('0xcc')}},'footer':{'height':_0x32fe('0xcd'),'contents':{'default':util[_0x32fe('0x5b')](_0x32fe('0xce'),util['format'](_0x32fe('0xcf'),'Sms',_0x4499be['id']),moment()[_0x32fe('0x5b')](_0x32fe('0xd0'))[_0x32fe('0x79')]())}}};fs[_0x32fe('0xd1')](_0x4082c6);var _0x1b4e2c={'channel':_0x32fe('0xd2'),'account':_0x4499be['Account'][_0x32fe('0x25')],'agent':_0x4499be[_0x32fe('0xc9')]?_0x4499be[_0x32fe('0xc9')][_0x32fe('0xc4')]:_0x32fe('0xd3'),'createdAt':moment(_0x4499be[_0x32fe('0x72')])[_0x32fe('0x5b')](_0x32fe('0xb1'))[_0x32fe('0x79')](),'closedAt':_0x4499be[_0x32fe('0xd4')]?moment(_0x4499be[_0x32fe('0xd5')])[_0x32fe('0x5b')](_0x32fe('0xb1'))[_0x32fe('0x79')]():'','disposition':_0x4499be[_0x32fe('0xd6')],'messages':_(_0x4499be[_0x32fe('0xc0')])['filter']({'secret':![]})['map'](function(_0x487c40){return{'date':moment(_0x487c40[_0x32fe('0x72')])['format'](_0x32fe('0xb1'))[_0x32fe('0x79')](),'sender':_0x487c40[_0x32fe('0xc1')]===_0x32fe('0xd7')?_0x487c40['User']?_0x487c40['User'][_0x32fe('0xc4')]:_0x32fe('0xd8'):_0x487c40[_0x32fe('0xd9')][_0x32fe('0xc5')]+(_0x487c40[_0x32fe('0xd9')]['lastName']?'\x20'+_0x487c40[_0x32fe('0xd9')][_0x32fe('0xc6')]:''),'body':_0x487c40['body'],'direction':_0x487c40['direction']===_0x32fe('0xd7')?'A':'C','secret':_0x487c40['secret']};})['value']()};return ejs[_0x32fe('0xda')](path[_0x32fe('0x7a')](config[_0x32fe('0xbb')],_0x32fe('0xbc'),_0x32fe('0xdb'),_0x32fe('0xdc')),{'interaction':_0x1b4e2c})[_0x32fe('0x24')](function(_0x5877dd){return new BPromise(function(_0xd29473,_0xf63074){pdf[_0x32fe('0xa7')](_0x5877dd,_0x569a84)[_0x32fe('0xdd')](path['join'](_0x4082c6,'transcript-'+_0x4499be['id']+'-'+_0x107900+'.pdf'),function(_0x4fae40,_0x14aff5){if(_0x4fae40)return _0xf63074(_0x4fae40);_0xd29473(_0x14aff5);});});});}})[_0x32fe('0x24')](function(){if(_0x197cf6){return new BPromise(function(_0x38f2a4,_0x104994){zipdir(_0x4082c6,{'saveTo':_0x2a881b},function(_0x31cdb0,_0x34ce28){if(_0x31cdb0)return _0x104994(_0x31cdb0);return _0x38f2a4(_0x34ce28);});})[_0x32fe('0x24')](function(){return new BPromise(function(_0xe378e8,_0x11dd2e){rimraf(_0x4082c6,function(_0x38e578){if(_0x38e578)_0x11dd2e(_0x38e578);return _0xe378e8();});});})[_0x32fe('0x24')](function(){return _0x25e295[_0x32fe('0xb9')](_0x2a881b,_0x2cb4ba,function(_0x3cbc2e){if(_0x3cbc2e){console['log'](_0x32fe('0xde'),_0x3cbc2e);}else{fs[_0x32fe('0xdf')](_0x2a881b);}});});}else{return _0x25e295[_0x32fe('0x19')](0xc8);}})[_0x32fe('0xa0')](handleError(_0x25e295,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff