// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xf636=['set','Content-Range','apply','reject','save','then','destroy','sendStatus','stack','name','send','Users','map','Tags','TagIds','split','forEach','push','WhatsappInteraction','rawAttributes','fieldName','type','key','query','keys','filters','intersection','attributes','fields','model','nolimit','order','sort','where','pick','field','color','u.fullname','ui.WhatsappInteractionId','from','left_join','users','u.id\x20=\x20ui.UserId','select','whatsapp_interactions','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','whatsapp_accounts','a.id\x20=\x20i.WhatsappAccountId','me.WhatsappInteractionId\x20=\x20i.id','whatsapp_interaction_has_tags','it.WhatsappInteractionId\x20=\x20i.id','tools_tags','t.id\x20=\x20it.TagId','expr','search','conditions','find','unreadMessages','value','having','`\x20>\x200','Contact','operator','$substring','length','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','text','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','body','start','some','isEmpty','i.WhatsappAccountId\x20IN\x20?','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20>\x200','tag','filter','replace','i.id\x20LIKE\x20?','i.phone\x20LIKE\x20?','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','QueryTypes','SELECT','contactName','DESC','t.id\x20IN\x20?','resolve','WhatsappAccountId','journey','i.WhatsappAccountId\x20IS\x20NOT\x20NULL','user','getWhatsappAccounts','sequelize','toString','keyBy','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','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','c.firstName','Contact.firstName','c.lastName','Contact.lastName','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','o.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.WhatsappInteractionId\x20IN\x20?','groupBy','WhatsappInteractionId','all','rows','catch','show','params','includeAll','merge','create','describe','addMessage','WhatsappMessage','ids','getMessages','findOne','format','YYYY-MM-DD\x20HH:mm:ss','options','findAll','setTags','spread','emit','whatsappInteractionTags:save','removeTags','unix','join','files','root','attachments','transcript-%d-%s.zip','fullname','CmContact','firstName','Attachment','Messages','direction','secret','WhatsappAccount','Account','mkdirSync','<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','%s\x20#%d','Whatsapp','YYYY-MM-DD','Owner','closed','closedAt','disposition','basename','existsSync','createReadStream','pipe','System','lastName','out','server','views','downloadInteraction.html','toFile','transcript-','.pdf','download','log','err','unlinkSync','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','lodash','squel','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','defaults','redis','localhost','socket.io-emitter','./whatsappInteraction.socket','register','status','end','json','count','offset','limit'];(function(_0x568a70,_0x1f10ee){var _0x293d2a=function(_0x2fb0c8){while(--_0x2fb0c8){_0x568a70['push'](_0x568a70['shift']());}};_0x293d2a(++_0x1f10ee);}(_0xf636,0x1b6));var _0x6f63=function(_0x5d8e3b,_0x59e6aa){_0x5d8e3b=_0x5d8e3b-0x0;var _0x42e192=_0xf636[_0x5d8e3b];return _0x42e192;};'use strict';var pdf=require(_0x6f63('0x0'));var emlformat=require(_0x6f63('0x1'));var rimraf=require(_0x6f63('0x2'));var zipdir=require(_0x6f63('0x3'));var jsonpatch=require(_0x6f63('0x4'));var rp=require(_0x6f63('0x5'));var moment=require(_0x6f63('0x6'));var BPromise=require('bluebird');var Mustache=require(_0x6f63('0x7'));var util=require(_0x6f63('0x8'));var path=require(_0x6f63('0x9'));var sox=require(_0x6f63('0xa'));var csv=require(_0x6f63('0xb'));var ejs=require(_0x6f63('0xc'));var fs=require('fs');var _=require(_0x6f63('0xd'));var squel=require(_0x6f63('0xe'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x6f63('0xf'));var toCsv=require(_0x6f63('0xb'));var querystring=require('querystring');var Papa=require(_0x6f63('0x10'));var Redis=require(_0x6f63('0x11'));var authService=require(_0x6f63('0x12'));var qs=require(_0x6f63('0x13'));var as=require(_0x6f63('0x14'));var hardwareService=require(_0x6f63('0x15'));var logger=require(_0x6f63('0x16'))(_0x6f63('0x17'));var utils=require(_0x6f63('0x18'));var config=require(_0x6f63('0x19'));var licenseUtil=require(_0x6f63('0x1a'));var db=require(_0x6f63('0x1b'))['db'];config['redis']=_[_0x6f63('0x1c')](config[_0x6f63('0x1d')],{'host':_0x6f63('0x1e'),'port':0x18eb});var socket=require(_0x6f63('0x1f'))(new Redis(config[_0x6f63('0x1d')]));require(_0x6f63('0x20'))[_0x6f63('0x21')](socket);function respondWithStatusCode(_0x3e55a2,_0x4b93ed){_0x4b93ed=_0x4b93ed||0xcc;return function(_0x3d2032){if(_0x3d2032){return _0x3e55a2['sendStatus'](_0x4b93ed);}return _0x3e55a2[_0x6f63('0x22')](_0x4b93ed)[_0x6f63('0x23')]();};}function respondWithResult(_0x13379d,_0x3cfc36){_0x3cfc36=_0x3cfc36||0xc8;return function(_0x1c80e4){if(_0x1c80e4){return _0x13379d['status'](_0x3cfc36)[_0x6f63('0x24')](_0x1c80e4);}};}function respondWithFilteredResult(_0x11a717,_0x565134){return function(_0x508d75){if(_0x508d75){var _0x5a1682=_0x508d75[_0x6f63('0x25')],_0x2d52b6=_0x565134[_0x6f63('0x26')],_0x4e4e77=_0x565134[_0x6f63('0x26')]+_0x565134[_0x6f63('0x27')],_0xd124b3;if(_0x4e4e77>=_0x5a1682){_0x4e4e77=_0x5a1682;_0xd124b3=0xc8;}else{_0xd124b3=0xce;}_0x11a717[_0x6f63('0x22')](_0xd124b3);return _0x11a717[_0x6f63('0x28')](_0x6f63('0x29'),_0x2d52b6+'-'+_0x4e4e77+'/'+_0x5a1682)[_0x6f63('0x24')](_0x508d75);}return null;};}function patchUpdates(_0x1efa62){return function(_0x55035b){try{jsonpatch[_0x6f63('0x2a')](_0x55035b,_0x1efa62,!![]);}catch(_0x3e234a){return BPromise[_0x6f63('0x2b')](_0x3e234a);}return _0x55035b[_0x6f63('0x2c')]();};}function saveUpdates(_0x2cabe3,_0x2a36df){return function(_0x202ade){if(_0x202ade){return _0x202ade['update'](_0x2cabe3)[_0x6f63('0x2d')](function(_0x48e146){return _0x48e146;});}return null;};}function removeEntity(_0xf47706,_0x4b9161){return function(_0x542ea0){if(_0x542ea0){return _0x542ea0[_0x6f63('0x2e')]()['then'](function(){_0xf47706[_0x6f63('0x22')](0xcc)['end']();});}};}function handleEntityNotFound(_0x21f383,_0xf04384){return function(_0x2b553a){if(!_0x2b553a){_0x21f383[_0x6f63('0x2f')](0x194);}return _0x2b553a;};}function handleError(_0x205c3e,_0x5560f8){_0x5560f8=_0x5560f8||0x1f4;return function(_0x5ea5c7){logger['error'](_0x5ea5c7[_0x6f63('0x30')]);if(_0x5ea5c7[_0x6f63('0x31')]){delete _0x5ea5c7[_0x6f63('0x31')];}_0x205c3e['status'](_0x5560f8)[_0x6f63('0x32')](_0x5ea5c7);};}function getInteractionUsers(_0x46bf70,_0x35ff3c){return new BPromise(function(_0x48b0f7,_0x200ef6){try{if(_0x35ff3c[_0x46bf70['id']]){_0x46bf70[_0x6f63('0x33')]=_[_0x6f63('0x34')](_0x35ff3c[_0x46bf70['id']],function(_0x546759){return{'id':_0x546759['id'],'fullname':_0x546759['fullname']};});}}catch(_0x139126){_0x200ef6(_0x139126);}_0x48b0f7(_0x46bf70);});}function getInteractionTags(_0x12854d,_0x5aa394){return new BPromise(function(_0x5492b9,_0x15122b){try{if(_0x12854d['TagIds']){_0x12854d[_0x6f63('0x35')]=[];_0x12854d[_0x6f63('0x36')][_0x6f63('0x37')](',')[_0x6f63('0x38')](function(_0xa7643d){_0x12854d[_0x6f63('0x35')][_0x6f63('0x39')](_0x5aa394[_0xa7643d]);});}delete _0x12854d[_0x6f63('0x36')];}catch(_0x51b285){_0x15122b(_0x51b285);}_0x5492b9(_0x12854d);});}function updateWhatsappInteraction(_0xa15c22,_0x415edf,_0x53cc10){return new BPromise(function(_0x810376,_0x2b0927){return getInteractionUsers(_0xa15c22,_0x53cc10)[_0x6f63('0x2d')](function(_0x2165ef){return getInteractionTags(_0x2165ef,_0x415edf);})[_0x6f63('0x2d')](function(_0x1f0fca){_0x810376(_0x1f0fca);})['catch'](function(_0x15d8f8){_0x2b0927(_0x15d8f8);});});}exports['index']=function(_0x535ba2,_0x1a68a6){var _0x2af91a={},_0x4fc127={},_0x225c30={'count':0x0,'rows':[]};var _0x3233a6=_[_0x6f63('0x34')](db[_0x6f63('0x3a')][_0x6f63('0x3b')],function(_0x112943){return{'name':_0x112943[_0x6f63('0x3c')],'type':_0x112943[_0x6f63('0x3d')][_0x6f63('0x3e')]};});_0x4fc127['model']=_[_0x6f63('0x34')](_0x3233a6,'name');_0x4fc127[_0x6f63('0x3f')]=_[_0x6f63('0x40')](_0x535ba2[_0x6f63('0x3f')]);_0x4fc127[_0x6f63('0x41')]=_[_0x6f63('0x42')](_0x4fc127['model'],_0x4fc127['query']);_0x2af91a[_0x6f63('0x43')]=_[_0x6f63('0x42')](_0x4fc127['model'],qs['fields'](_0x535ba2['query'][_0x6f63('0x44')]));_0x2af91a[_0x6f63('0x43')]=_0x2af91a[_0x6f63('0x43')]['length']?_0x2af91a[_0x6f63('0x43')]:_0x4fc127[_0x6f63('0x45')];if(!_0x535ba2['query']['hasOwnProperty'](_0x6f63('0x46'))){_0x2af91a['limit']=qs[_0x6f63('0x27')](_0x535ba2['query'][_0x6f63('0x27')]);_0x2af91a['offset']=qs[_0x6f63('0x26')](_0x535ba2[_0x6f63('0x3f')][_0x6f63('0x26')]);}_0x2af91a[_0x6f63('0x47')]=qs[_0x6f63('0x48')](_0x535ba2['query']['sort']);_0x2af91a[_0x6f63('0x49')]=qs[_0x6f63('0x41')](_[_0x6f63('0x4a')](_0x535ba2['query'],_0x4fc127[_0x6f63('0x41')]),_0x3233a6);var _0x2c134c=[];var _0x46923d=squel['select']()[_0x6f63('0x4b')]('id')[_0x6f63('0x4b')]('name')['field'](_0x6f63('0x4c'))['from']('tools_tags');var _0x4b2da6=squel['select']()[_0x6f63('0x4b')]('u.id')['field'](_0x6f63('0x4d'))['field'](_0x6f63('0x4e'))[_0x6f63('0x4f')]('user_has_whatsapp_interactions','ui')[_0x6f63('0x50')](_0x6f63('0x51'),'u',_0x6f63('0x52'));var _0xa2d330=squel[_0x6f63('0x53')]()[_0x6f63('0x4f')](_0x6f63('0x54'),'i')['left_join'](_0x6f63('0x55'),'c',_0x6f63('0x56'))[_0x6f63('0x50')]('users','o',_0x6f63('0x57'))[_0x6f63('0x50')](_0x6f63('0x58'),'a',_0x6f63('0x59'))[_0x6f63('0x50')]('whatsapp_messages','me',_0x6f63('0x5a'))['left_join'](_0x6f63('0x5b'),'it',_0x6f63('0x5c'))['left_join'](_0x6f63('0x5d'),'t',_0x6f63('0x5e'));var _0x4678ac=squel['expr']();var _0x2d07a9=[];var _0x1a554a=squel[_0x6f63('0x5f')]();var _0x43d7e8;if(_0x535ba2[_0x6f63('0x3f')][_0x6f63('0x60')]){_0x43d7e8=as['parseSearch'](_0x535ba2[_0x6f63('0x3f')][_0x6f63('0x60')]);var _0x2cab6b=_0x43d7e8['sqlOperator'];for(var _0x28ec90=0x0;_0x28ec90<_0x43d7e8[_0x6f63('0x61')]['length'];_0x28ec90++){var _0x17e283=_0x43d7e8[_0x6f63('0x61')][_0x28ec90];var _0x2b3449='i';var _0x1961f7=_[_0x6f63('0x62')](_0x3233a6,['name',_0x17e283[_0x6f63('0x4b')]]);if(!_0x1961f7){switch(_0x17e283[_0x6f63('0x4b')]){case _0x6f63('0x63'):if(_0x17e283[_0x6f63('0x64')]==0x1){_0xa2d330[_0x6f63('0x65')]('`'+_0x17e283[_0x6f63('0x4b')]+'`\x20=\x200');}else{_0xa2d330[_0x6f63('0x65')]('`'+_0x17e283['field']+_0x6f63('0x66'));}break;case _0x6f63('0x67'):if(_0x17e283[_0x6f63('0x68')]===_0x6f63('0x69')){if(_0x17e283[_0x6f63('0x64')][_0x6f63('0x37')]('\x20')[_0x6f63('0x6a')]>0x1){_0x4678ac[_0x2cab6b](_0x6f63('0x6b'),qs[_0x6f63('0x6c')](_0x17e283[_0x6f63('0x64')]),null);}else{var _0xbb20ce='%'+_0x17e283[_0x6f63('0x64')]+'%';_0x4678ac[_0x2cab6b](_0x6f63('0x6d'),_0xbb20ce,_0xbb20ce,_0xbb20ce);}}else{_0x1961f7=_[_0x6f63('0x62')](_0x3233a6,['name',_0x6f63('0x6e')]);_0x17e283[_0x6f63('0x4b')]='ContactId';_0x9bb871=as[_0x6f63('0x6f')](_0x2b3449,_0x1961f7['type'],_0x17e283);_0x4678ac[_0x2cab6b](_0x9bb871[_0x6f63('0x70')],_0x9bb871[_0x6f63('0x64')]['start'],_0x9bb871['value'][_0x6f63('0x23')]);}break;case'Tag':var _0x3a8448=_0x17e283['value'][_0x6f63('0x37')](',')[_0x6f63('0x34')](function(_0x4f7abd){return Number(_0x4f7abd);});_0x3a8448['forEach'](function(_0x5524ad){_0x1a554a['or'](_0x6f63('0x71'),'%,'+_0x5524ad+',%');});_0x2d07a9=_[_0x6f63('0x72')](_0x2d07a9,_0x3a8448);break;case _0x6f63('0x73'):if(_0x17e283[_0x6f63('0x68')]===_0x6f63('0x69')){_0x4678ac[_0x2cab6b](_0x6f63('0x74'),'%'+_0x17e283[_0x6f63('0x64')]+'%',null);}else{_0x1961f7=_[_0x6f63('0x62')](_0x3233a6,[_0x6f63('0x31'),_0x6f63('0x75')]);_0x17e283[_0x6f63('0x4b')]='UserId';_0x9bb871=as['buildExpression'](_0x2b3449,_0x1961f7[_0x6f63('0x3d')],_0x17e283);_0x4678ac[_0x2cab6b](_0x9bb871[_0x6f63('0x70')],_0x9bb871[_0x6f63('0x64')]['start'],_0x9bb871[_0x6f63('0x64')][_0x6f63('0x23')]);}break;case _0x6f63('0x76'):_0x9bb871=as[_0x6f63('0x6f')]('me',null,_0x17e283);_0x4678ac[_0x2cab6b](_0x9bb871[_0x6f63('0x70')],_0x9bb871[_0x6f63('0x64')]['start'],_0x9bb871[_0x6f63('0x64')][_0x6f63('0x23')]);break;}}else{var _0x9bb871=as[_0x6f63('0x6f')](_0x2b3449,_0x1961f7[_0x6f63('0x3d')],_0x17e283);_0x4678ac[_0x2cab6b](_0x9bb871['text'],_0x9bb871['value'][_0x6f63('0x77')],_0x9bb871[_0x6f63('0x64')]['end']);}}}else{var _0x488636=_(_0x535ba2[_0x6f63('0x3f')])[_0x6f63('0x40')]()[_0x6f63('0x34')](function(_0x4663){return _[_0x6f63('0x78')](_0x3233a6,[_0x6f63('0x31'),_0x4663])?_0x4663:undefined;})['compact']()[_0x6f63('0x64')]();if(!_[_0x6f63('0x79')](_0x488636)){_0x488636['forEach'](function(_0x41c44f){if(_0x41c44f==='WhatsappAccountId'){_0xa2d330[_0x6f63('0x49')](_0x6f63('0x7a'),[][_0x6f63('0x7b')](_0x535ba2['query'][_0x41c44f]));}else if(_0x41c44f===_0x6f63('0x7c')){var _0x58f532=JSON[_0x6f63('0x7d')](_0x535ba2[_0x6f63('0x3f')][_0x41c44f])[_0x6f63('0x7e')];var _0x86c578=JSON['parse'](_0x535ba2[_0x6f63('0x3f')][_0x41c44f])[_0x6f63('0x7f')];_0xa2d330[_0x6f63('0x49')](_0x6f63('0x80'),_0x58f532,_0x86c578);}else{if(_0x535ba2[_0x6f63('0x3f')][_0x41c44f]==='null'){_0xa2d330['where']('i.'+_0x41c44f+_0x6f63('0x81'));}else{_0xa2d330['where']('i.'+_0x41c44f+_0x6f63('0x82'),_0x535ba2[_0x6f63('0x3f')][_0x41c44f]);}}});}if(_0x535ba2[_0x6f63('0x3f')][_0x6f63('0x83')]){if(_0x535ba2[_0x6f63('0x3f')][_0x6f63('0x83')]==0x1){_0xa2d330[_0x6f63('0x65')]('`unreadMessages`\x20=\x200');}else{_0xa2d330[_0x6f63('0x65')](_0x6f63('0x84'));}}if(_0x535ba2['query'][_0x6f63('0x85')]){_0x2d07a9=_['isArray'](_0x535ba2[_0x6f63('0x3f')][_0x6f63('0x85')])?_0x535ba2[_0x6f63('0x3f')][_0x6f63('0x85')]:new Array(_0x535ba2[_0x6f63('0x3f')][_0x6f63('0x85')]);_0x2d07a9['forEach'](function(_0x58ff0e){_0x1a554a['or'](_0x6f63('0x71'),'%,'+_0x58ff0e+',%');});}if(_0x535ba2[_0x6f63('0x3f')][_0x6f63('0x86')]){var _0x3a21e6=_0x535ba2[_0x6f63('0x3f')][_0x6f63('0x86')][_0x6f63('0x87')]('\x5c','\x5c\x5c')[_0x6f63('0x87')](/'/g,'\x27\x27');if(qs['isNumeric'](_0x3a21e6)){_0x4678ac['or'](_0x6f63('0x88'),_0x3a21e6+'%')['or'](_0x6f63('0x89'),_0x3a21e6+'%');}else{_0x4678ac['or']('MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x6f63('0x6c')](_0x3a21e6))['or'](_0x6f63('0x8a'),_0x3a21e6+'%');}}}_0xa2d330[_0x6f63('0x49')](_0x4678ac);_0xa2d330['group']('i.id');var _0x4d14a5={'type':db['Sequelize'][_0x6f63('0x8b')][_0x6f63('0x8c')],'raw':!![]};var _0x4f145e=_0xa2d330['clone']();_0x4f145e['field']('i.id');_0x4f145e[_0x6f63('0x4b')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x6f63('0x63'));if(_0x2af91a['order']){_0x2af91a['order']['forEach'](function(_0x39753c){var _0x436d8f=_0x39753c[0x0]===_0x6f63('0x8d')?_0x39753c[0x0]:'i.'+_0x39753c[0x0];_0xa2d330[_0x6f63('0x47')](_0x436d8f,_0x39753c[0x1]===_0x6f63('0x8e')?![]:!![]);});}if(!_['isEmpty'](_0x2d07a9)){_0xa2d330['having'](_0x1a554a);_0x4f145e[_0x6f63('0x49')](_0x6f63('0x8f'),_0x2d07a9);}BPromise[_0x6f63('0x90')]()['then'](function(){if(!_0x43d7e8){if(_0x535ba2[_0x6f63('0x3f')][_0x6f63('0x91')]||_0x535ba2['query'][_0x6f63('0x92')])return;_0x4f145e['where']('i.WhatsappAccountId\x20IS\x20NOT\x20NULL');_0xa2d330[_0x6f63('0x49')](_0x6f63('0x93'));return;}return _0x535ba2[_0x6f63('0x94')][_0x6f63('0x95')]({'attributes':['id'],'raw':!![]})[_0x6f63('0x2d')](function(_0x1e140b){if(_[_0x6f63('0x79')](_0x1e140b)){_0x4f145e[_0x6f63('0x49')]('i.WhatsappAccountId\x20IS\x20NULL');_0xa2d330[_0x6f63('0x49')]('i.WhatsappAccountId\x20IS\x20NULL');}else{_0x4f145e[_0x6f63('0x49')]('i.WhatsappAccountId\x20IN\x20?',_[_0x6f63('0x34')](_0x1e140b,'id'));_0xa2d330[_0x6f63('0x49')](_0x6f63('0x7a'),_[_0x6f63('0x34')](_0x1e140b,'id'));}});})[_0x6f63('0x2d')](function(){db[_0x6f63('0x96')][_0x6f63('0x3f')](_0x4f145e[_0x6f63('0x97')](),_0x4d14a5)[_0x6f63('0x2d')](function(_0x33942a){_0x225c30[_0x6f63('0x25')]=_0x33942a['length'];if(_0x225c30[_0x6f63('0x25')]===0x0)return[];return db[_0x6f63('0x96')][_0x6f63('0x3f')](_0x46923d[_0x6f63('0x97')](),_0x4d14a5)[_0x6f63('0x2d')](function(_0x20a22f){_0x2c134c=_[_0x6f63('0x98')](_0x20a22f,'id');_0x4d14a5=_['merge'](_0x4d14a5,{'model':db['WhatsappInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x535ba2['query'][_0x6f63('0x44')]){_0x2af91a[_0x6f63('0x43')][_0x6f63('0x38')](function(_0x1058b1){_0xa2d330['field']('i.'+_0x1058b1);});}else{_0xa2d330[_0x6f63('0x4b')](_0x6f63('0x99'),_0x6f63('0x63'));_0xa2d330[_0x6f63('0x4b')](_0x6f63('0x9a'),_0x6f63('0x9b'));_0xa2d330['field']('a.mandatoryDisposition','Account.mandatoryDisposition');_0xa2d330[_0x6f63('0x4b')](_0x6f63('0x9c'),_0x6f63('0x8d'));_0xa2d330[_0x6f63('0x4b')]('i.*');_0xa2d330[_0x6f63('0x4b')](_0x6f63('0x9d'),_0x6f63('0x9e'));_0xa2d330[_0x6f63('0x4b')](_0x6f63('0x9f'),_0x6f63('0xa0'));_0xa2d330[_0x6f63('0x4b')]('c.email',_0x6f63('0xa1'));_0xa2d330[_0x6f63('0x4b')](_0x6f63('0xa2'),_0x6f63('0xa3'));_0xa2d330[_0x6f63('0x4b')](_0x6f63('0xa4'),_0x6f63('0xa5'));_0xa2d330['field'](_0x6f63('0xa6'),'Contact.fax');_0xa2d330[_0x6f63('0x4b')](_0x6f63('0xa7'),'Owner.fullname');_0xa2d330[_0x6f63('0x4b')](_0x6f63('0xa8'),_0x6f63('0xa9'));_0xa2d330[_0x6f63('0x4b')](_0x6f63('0xaa'),_0x6f63('0x36'));}if(_0x2af91a[_0x6f63('0x27')])_0xa2d330[_0x6f63('0x27')](_0x2af91a[_0x6f63('0x27')]);if(_0x2af91a[_0x6f63('0x26')])_0xa2d330[_0x6f63('0x26')](_0x2af91a[_0x6f63('0x26')]);return db['sequelize']['query'](_0xa2d330[_0x6f63('0x97')](),_0x4d14a5);})[_0x6f63('0x2d')](function(_0x1ac649){_0x4b2da6[_0x6f63('0x49')](_0x6f63('0xab'),_[_0x6f63('0x34')](_0x1ac649,'id'));return db['sequelize'][_0x6f63('0x3f')](_0x4b2da6[_0x6f63('0x97')](),_0x4d14a5)[_0x6f63('0x2d')](function(_0x494e43){var _0x36ad43=_[_0x6f63('0xac')](_0x494e43,_0x6f63('0xad'));var _0x5272e6=[];_0x1ac649['forEach'](function(_0x7dada9){_0x5272e6[_0x6f63('0x39')](updateWhatsappInteraction(_0x7dada9,_0x2c134c,_0x36ad43));});return BPromise[_0x6f63('0xae')](_0x5272e6);});});})[_0x6f63('0x2d')](function(_0x51e27a){_0x225c30[_0x6f63('0xaf')]=_0x51e27a;return _0x225c30;})[_0x6f63('0x2d')](respondWithFilteredResult(_0x1a68a6,_0x2af91a));})[_0x6f63('0xb0')](handleError(_0x1a68a6,null));};exports[_0x6f63('0xb1')]=function(_0x351496,_0x225f0d){var _0x2cafd2={'raw':![],'where':{'id':_0x351496[_0x6f63('0xb2')]['id']}},_0x39e56d={};_0x39e56d[_0x6f63('0x45')]=_[_0x6f63('0x40')](db[_0x6f63('0x3a')][_0x6f63('0x3b')]);_0x39e56d[_0x6f63('0x3f')]=_[_0x6f63('0x40')](_0x351496[_0x6f63('0x3f')]);_0x39e56d[_0x6f63('0x41')]=_['intersection'](_0x39e56d[_0x6f63('0x45')],_0x39e56d[_0x6f63('0x3f')]);_0x2cafd2[_0x6f63('0x43')]=_['intersection'](_0x39e56d[_0x6f63('0x45')],qs['fields'](_0x351496[_0x6f63('0x3f')][_0x6f63('0x44')]));_0x2cafd2[_0x6f63('0x43')]=_0x2cafd2['attributes'][_0x6f63('0x6a')]?_0x2cafd2[_0x6f63('0x43')]:_0x39e56d[_0x6f63('0x45')];if(_0x351496['query'][_0x6f63('0xb3')]){_0x2cafd2['include']=[{'all':!![]}];}_0x2cafd2=_[_0x6f63('0xb4')]({},_0x2cafd2,_0x351496['options']);return db[_0x6f63('0x3a')][_0x6f63('0x62')](_0x2cafd2)[_0x6f63('0x2d')](handleEntityNotFound(_0x225f0d,null))[_0x6f63('0x2d')](respondWithResult(_0x225f0d,null))['catch'](handleError(_0x225f0d,null));};exports['create']=function(_0x4e1220,_0x2290b8){return db[_0x6f63('0x3a')][_0x6f63('0xb5')](_0x4e1220[_0x6f63('0x76')],{})[_0x6f63('0x2d')](respondWithResult(_0x2290b8,0xc9))[_0x6f63('0xb0')](handleError(_0x2290b8,null));};exports['update']=function(_0x1282ea,_0x5b0b86){if(_0x1282ea[_0x6f63('0x76')]['id']){delete _0x1282ea['body']['id'];}return db[_0x6f63('0x3a')][_0x6f63('0x62')]({'where':{'id':_0x1282ea[_0x6f63('0xb2')]['id']}})[_0x6f63('0x2d')](handleEntityNotFound(_0x5b0b86,null))[_0x6f63('0x2d')](saveUpdates(_0x1282ea[_0x6f63('0x76')],null))[_0x6f63('0x2d')](respondWithResult(_0x5b0b86,null))[_0x6f63('0xb0')](handleError(_0x5b0b86,null));};exports[_0x6f63('0x2e')]=function(_0x4040b0,_0x4c0efc){return db['WhatsappInteraction'][_0x6f63('0x62')]({'where':{'id':_0x4040b0[_0x6f63('0xb2')]['id']}})[_0x6f63('0x2d')](handleEntityNotFound(_0x4c0efc,null))['then'](removeEntity(_0x4c0efc,null))['catch'](handleError(_0x4c0efc,null));};exports[_0x6f63('0xb6')]=function(_0x2d2591,_0x46aedc){return db[_0x6f63('0x3a')][_0x6f63('0xb6')]()[_0x6f63('0x2d')](respondWithResult(_0x46aedc,null))[_0x6f63('0xb0')](handleError(_0x46aedc,null));};exports[_0x6f63('0xb7')]=function(_0x5bca32,_0x19f1ba,_0x35fc37){return db[_0x6f63('0xb8')][_0x6f63('0x62')]({'where':{'id':_0x5bca32[_0x6f63('0xb2')]['id']}})['then'](handleEntityNotFound(_0x19f1ba,null))['then'](function(_0x675c25){if(_0x675c25){return _0x675c25['addMessage'](_0x5bca32[_0x6f63('0x76')][_0x6f63('0xb9')],_['omit'](_0x5bca32['body'],[_0x6f63('0xb9'),'id'])||{});}})[_0x6f63('0x2d')](respondWithResult(_0x19f1ba,null))[_0x6f63('0xb0')](handleError(_0x19f1ba,null));};exports[_0x6f63('0xba')]=function(_0x302486,_0x524247,_0x119e05){var _0x1d70a5={'raw':![],'where':{}};var _0x900de8={};var _0x264384={'count':0x0,'rows':[]};return db[_0x6f63('0x3a')][_0x6f63('0xbb')]({'where':{'id':_0x302486['params']['id']}})[_0x6f63('0x2d')](handleEntityNotFound(_0x524247,null))[_0x6f63('0x2d')](function(_0x101004){if(_0x101004){_0x900de8[_0x6f63('0x45')]=_[_0x6f63('0x40')](db[_0x6f63('0xb8')][_0x6f63('0x3b')]);_0x900de8[_0x6f63('0x3f')]=_['keys'](_0x302486['query']);_0x900de8[_0x6f63('0x41')]=_['intersection'](_0x900de8[_0x6f63('0x45')],_0x900de8[_0x6f63('0x3f')]);_0x1d70a5['attributes']=_['intersection'](_0x900de8['model'],qs[_0x6f63('0x44')](_0x302486[_0x6f63('0x3f')][_0x6f63('0x44')]));_0x1d70a5[_0x6f63('0x43')]=_0x1d70a5[_0x6f63('0x43')]['length']?_0x1d70a5['attributes']:_0x900de8[_0x6f63('0x45')];if(!_0x302486[_0x6f63('0x3f')]['hasOwnProperty'](_0x6f63('0x46'))){_0x1d70a5[_0x6f63('0x27')]=qs[_0x6f63('0x27')](_0x302486[_0x6f63('0x3f')]['limit']);_0x1d70a5[_0x6f63('0x26')]=qs[_0x6f63('0x26')](_0x302486['query']['offset']);}_0x1d70a5[_0x6f63('0x47')]=qs[_0x6f63('0x48')](_0x302486['query']['sort']);_0x1d70a5[_0x6f63('0x49')]=qs[_0x6f63('0x41')](_[_0x6f63('0x4a')](_0x302486[_0x6f63('0x3f')],_0x900de8[_0x6f63('0x41')]));_0x1d70a5[_0x6f63('0x49')][_0x6f63('0xad')]=_0x101004['id'];if(_0x302486[_0x6f63('0x3f')][_0x6f63('0x86')]){_0x1d70a5['where']=_[_0x6f63('0xb4')](_0x1d70a5[_0x6f63('0x49')],{'$or':_[_0x6f63('0x34')](_0x1d70a5[_0x6f63('0x43')],function(_0xd0c19f){var _0x17ced0={};_0x17ced0[_0xd0c19f]={'$like':'%'+_0x302486[_0x6f63('0x3f')][_0x6f63('0x86')]+'%'};return _0x17ced0;})});}if(_0x302486[_0x6f63('0x3f')][_0x6f63('0x7e')]){var _0x14ca16=_0x302486[_0x6f63('0x3f')]['$gte'][_0x6f63('0x37')](',');var _0x3aad89={};_0x3aad89[_0x14ca16[0x0]]={'$gte':moment(_0x14ca16[0x1])[_0x6f63('0xbc')](_0x6f63('0xbd'))};_0x1d70a5['where']=_[_0x6f63('0xb4')](_0x1d70a5[_0x6f63('0x49')],_0x3aad89);}_0x1d70a5=_[_0x6f63('0xb4')]({},_0x1d70a5,_0x302486[_0x6f63('0xbe')]);return db[_0x6f63('0xb8')]['count']({'where':_0x1d70a5['where']})[_0x6f63('0x2d')](function(_0x360721){_0x264384[_0x6f63('0x25')]=_0x360721;if(_0x302486['query']['includeAll']){_0x1d70a5['include']=[{'all':!![]}];}return db[_0x6f63('0xb8')][_0x6f63('0xbf')](_0x1d70a5);})[_0x6f63('0x2d')](function(_0x240bcf){_0x264384[_0x6f63('0xaf')]=_0x240bcf;return _0x264384;});}})[_0x6f63('0x2d')](respondWithFilteredResult(_0x524247,_0x1d70a5))[_0x6f63('0xb0')](handleError(_0x524247,null));};exports['addTags']=function(_0x24aace,_0x1f3c9a,_0x1e5db7){return db['WhatsappInteraction'][_0x6f63('0x62')]({'where':{'id':_0x24aace[_0x6f63('0xb2')]['id']}})[_0x6f63('0x2d')](handleEntityNotFound(_0x1f3c9a,null))[_0x6f63('0x2d')](function(_0x388b9c){if(_0x388b9c){return _0x388b9c[_0x6f63('0xc0')](_0x24aace['body'][_0x6f63('0xb9')],_['omit'](_0x24aace[_0x6f63('0x76')],[_0x6f63('0xb9'),'id'])||{})[_0x6f63('0xc1')](function(){return db['Tag'][_0x6f63('0xbf')]({'attributes':['id',_0x6f63('0x31'),_0x6f63('0x4c')],'where':{'id':_0x24aace[_0x6f63('0x76')][_0x6f63('0xb9')]}});})[_0x6f63('0x2d')](function(_0x19c8d4){socket[_0x6f63('0xc2')](_0x6f63('0xc3'),{'id':Number(_0x24aace[_0x6f63('0xb2')]['id']),'tags':_0x19c8d4||[]});return{'id':Number(_0x24aace[_0x6f63('0xb2')]['id']),'tags':_0x19c8d4||[]};});}})[_0x6f63('0x2d')](respondWithResult(_0x1f3c9a,null))['catch'](handleError(_0x1f3c9a,null));};exports[_0x6f63('0xc4')]=function(_0xe37646,_0x1a47c2,_0x173f55){return db['WhatsappInteraction'][_0x6f63('0x62')]({'where':{'id':_0xe37646[_0x6f63('0xb2')]['id']}})['then'](handleEntityNotFound(_0x1a47c2,null))[_0x6f63('0x2d')](function(_0x347020){if(_0x347020){return _0x347020[_0x6f63('0xc4')](_0xe37646[_0x6f63('0x3f')][_0x6f63('0xb9')]);}})[_0x6f63('0x2d')](respondWithStatusCode(_0x1a47c2,null))['catch'](handleError(_0x1a47c2,null));};exports['download']=function(_0x23465a,_0x2fd57b){var _0x58edff=moment()[_0x6f63('0xc5')]()[_0x6f63('0x97')]();var _0x7609b2=path[_0x6f63('0xc6')](config['root'],'server',_0x6f63('0xc7'),'tmp');var _0x5dfe2c=path[_0x6f63('0xc6')](config[_0x6f63('0xc8')],'server',_0x6f63('0xc7'),_0x6f63('0xc9'));var _0x3b948c=path[_0x6f63('0xc6')](_0x7609b2,_0x58edff);var _0x4396cc=util[_0x6f63('0xbc')](_0x6f63('0xca'),_0x23465a[_0x6f63('0xb2')]['id'],_0x58edff);var _0x2e29a1=path[_0x6f63('0xc6')](_0x7609b2,_0x4396cc);var _0x54ba98=[];_0x54ba98[_0x6f63('0x39')]({'model':db[_0x6f63('0x73')],'as':_0x6f63('0x73'),'attributes':['id',_0x6f63('0xcb')],'raw':!![]});_0x54ba98['push']({'model':db[_0x6f63('0xcc')],'as':_0x6f63('0x67'),'attributes':['id',_0x6f63('0xcd'),'lastName'],'raw':!![]});if(_0x23465a['query']['attachments']){_0x54ba98[_0x6f63('0x39')]({'model':db['Attachment'],'as':_0x6f63('0xce'),'raw':!![]});}var _0x47f22f=[{'model':db[_0x6f63('0xb8')],'as':_0x6f63('0xcf'),'attributes':['id',_0x6f63('0x76'),_0x6f63('0x7c'),_0x6f63('0xd0'),_0x6f63('0xd1'),_0x6f63('0x83')],'include':_0x54ba98}];_0x47f22f['push']({'model':db[_0x6f63('0xd2')],'as':_0x6f63('0xd3'),'attributes':['id',_0x6f63('0x31')]});_0x47f22f[_0x6f63('0x39')]({'model':db[_0x6f63('0x73')],'as':'Owner','attributes':['id',_0x6f63('0xcb')]});return db[_0x6f63('0x3a')][_0x6f63('0x62')]({'where':{'id':_0x23465a[_0x6f63('0xb2')]['id']},'include':_0x47f22f})[_0x6f63('0x2d')](handleEntityNotFound(_0x2fd57b,null))[_0x6f63('0x2d')](function(_0x56558c){if(_0x56558c){var _0x1d6e99=_0x56558c['get']({'plain':!![]});fs[_0x6f63('0xd4')](_0x3b948c);var _0x84f29c={'format':'A4','border':'10px','header':{'height':'40px','contents':{'first':_0x6f63('0xd5')}},'footer':{'height':_0x6f63('0xd6'),'contents':{'default':util[_0x6f63('0xbc')]('<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['format'](_0x6f63('0xd7'),_0x6f63('0xd8'),_0x1d6e99['id']),moment()[_0x6f63('0xbc')](_0x6f63('0xd9'))[_0x6f63('0x97')]())}}};var _0x3799e9={'channel':_0x6f63('0xd8'),'account':_0x1d6e99['Account'][_0x6f63('0x31')],'agent':_0x1d6e99['Owner']?_0x1d6e99[_0x6f63('0xda')][_0x6f63('0xcb')]:'N.A.','createdAt':moment(_0x1d6e99['createdAt'])[_0x6f63('0xbc')](_0x6f63('0xbd'))['toString'](),'closedAt':_0x1d6e99[_0x6f63('0xdb')]?moment(_0x1d6e99[_0x6f63('0xdc')])['format'](_0x6f63('0xbd'))[_0x6f63('0x97')]():'','disposition':_0x1d6e99[_0x6f63('0xdd')],'messages':_(_0x1d6e99[_0x6f63('0xcf')])[_0x6f63('0x86')]({'secret':![]})['map'](function(_0x17fd26){if(_0x17fd26[_0x6f63('0xce')]){var _0x4e05a0=path[_0x6f63('0xc6')](_0x5dfe2c,_0x17fd26[_0x6f63('0xce')][_0x6f63('0xde')]);if(fs[_0x6f63('0xdf')](_0x4e05a0)){fs[_0x6f63('0xe0')](_0x4e05a0)[_0x6f63('0xe1')](fs['createWriteStream'](path[_0x6f63('0xc6')](_0x3b948c,_0x17fd26[_0x6f63('0xce')][_0x6f63('0xde')])));}}return{'date':moment(_0x17fd26[_0x6f63('0x7c')])[_0x6f63('0xbc')](_0x6f63('0xbd'))[_0x6f63('0x97')](),'sender':_0x17fd26[_0x6f63('0xd0')]==='out'?_0x17fd26[_0x6f63('0x73')]?_0x17fd26[_0x6f63('0x73')][_0x6f63('0xcb')]:_0x6f63('0xe2'):_0x17fd26[_0x6f63('0x67')][_0x6f63('0xcd')]+(_0x17fd26['Contact'][_0x6f63('0xe3')]?'\x20'+_0x17fd26[_0x6f63('0x67')]['lastName']:''),'body':_0x17fd26[_0x6f63('0xce')]?_0x17fd26[_0x6f63('0xce')][_0x6f63('0xde')]:_0x17fd26[_0x6f63('0x76')],'direction':_0x17fd26[_0x6f63('0xd0')]===_0x6f63('0xe4')?'A':'C','secret':_0x17fd26[_0x6f63('0xd1')],'read':_0x17fd26[_0x6f63('0x83')],'attachment':_0x17fd26['Attachment']};})[_0x6f63('0x64')]()};return ejs['renderFile'](path['join'](config[_0x6f63('0xc8')],_0x6f63('0xe5'),_0x6f63('0xe6'),_0x6f63('0xe7')),{'interaction':_0x3799e9})[_0x6f63('0x2d')](function(_0x3fe215){return new BPromise(function(_0x26a18b,_0x710c23){pdf[_0x6f63('0xb5')](_0x3fe215,_0x84f29c)[_0x6f63('0xe8')](path[_0x6f63('0xc6')](_0x3b948c,_0x6f63('0xe9')+_0x1d6e99['id']+'-'+_0x58edff+_0x6f63('0xea')),function(_0x3ba734,_0x57d5e3){if(_0x3ba734)return _0x710c23(_0x3ba734);_0x26a18b(_0x57d5e3);});});})['then'](function(){return new BPromise(function(_0x201a35,_0x583ff7){zipdir(_0x3b948c,{'saveTo':_0x2e29a1},function(_0x570f19,_0x440672){if(_0x570f19)return _0x583ff7(_0x570f19);return _0x201a35(_0x440672);});})['then'](function(){return new BPromise(function(_0x42978d,_0x4983b8){rimraf(_0x3b948c,function(_0x4cfef1){if(_0x4cfef1)_0x4983b8(_0x4cfef1);return _0x42978d();});});})[_0x6f63('0x2d')](function(){return _0x2fd57b[_0x6f63('0xeb')](_0x2e29a1,_0x4396cc,function(_0x56c8d1){if(_0x56c8d1){console[_0x6f63('0xec')](_0x6f63('0xed'),_0x56c8d1);}else{fs[_0x6f63('0xee')](_0x2e29a1);}});});});}else{return _0x2fd57b['sendStatus'](0xc8);}})[_0x6f63('0xb0')](handleError(_0x2fd57b,null));};
\ No newline at end of file
+var _0x5a7d=['fields','length','hasOwnProperty','limit','sort','where','filters','pick','select','field','from','tools_tags','u.id','u.fullname','ui.WhatsappInteractionId','user_has_whatsapp_interactions','left_join','users','u.id\x20=\x20ui.UserId','whatsapp_interactions','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','whatsapp_accounts','whatsapp_messages','me.WhatsappInteractionId\x20=\x20i.id','whatsapp_interaction_has_tags','it.WhatsappInteractionId\x20=\x20i.id','expr','search','parseSearch','sqlOperator','conditions','find','value','having','`\x20>\x200','Contact','operator','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','text','start','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','buildExpression','keys','WhatsappAccountId','concat','$gte','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20=\x200','tag','isArray','filter','replace','isNumeric','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','i.id','SELECT','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','unreadMessages','order','contactName','DESC','isEmpty','t.id\x20IN\x20?','resolve','journey','i.WhatsappAccountId\x20IS\x20NOT\x20NULL','user','role','agent','getWhatsappAccounts','i.WhatsappAccountId\x20IS\x20NULL','i.WhatsappAccountId\x20IN\x20?','sequelize','toString','merge','a.mandatoryDisposition','Account.mandatoryDisposition','c.firstName','Contact.firstName','c.lastName','Contact.lastName','Contact.email','Contact.phone','Contact.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.WhatsappInteractionId\x20IN\x20?','groupBy','WhatsappInteractionId','forEach','push','all','catch','show','params','includeAll','include','options','body','update','describe','addMessage','WhatsappMessage','omit','getMessages','findOne','nolimit','format','findAll','rows','setTags','ids','spread','whatsappInteractionTags:save','root','server','files','tmp','join','transcript-%d-%s.zip','CmContact','lastName','attachments','Attachment','Messages','createdAt','direction','WhatsappAccount','Account','get','mkdirSync','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>','<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','Whatsapp','YYYY-MM-DD','Owner','N.A.','YYYY-MM-DD\x20HH:mm:ss','closed','closedAt','disposition','basename','existsSync','createReadStream','createWriteStream','out','System','firstName','secret','renderFile','views','toFile','transcript-','.pdf','download','err','unlinkSync','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','sox','to-csv','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/license/util','redis','defaults','socket.io-emitter','./whatsappInteraction.socket','register','status','end','count','offset','set','Content-Range','json','apply','reject','save','then','destroy','sendStatus','error','name','Users','map','fullname','TagIds','split','Tags','index','WhatsappInteraction','rawAttributes','type','key','model','query','intersection','attributes'];(function(_0x4cf98e,_0xba4b79){var _0x1623ac=function(_0x459bc0){while(--_0x459bc0){_0x4cf98e['push'](_0x4cf98e['shift']());}};_0x1623ac(++_0xba4b79);}(_0x5a7d,0xb2));var _0xd5a7=function(_0x35ce45,_0x57c22a){_0x35ce45=_0x35ce45-0x0;var _0x5cd865=_0x5a7d[_0x35ce45];return _0x5cd865;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require(_0xd5a7('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0xd5a7('0x1'));var rp=require(_0xd5a7('0x2'));var moment=require(_0xd5a7('0x3'));var BPromise=require(_0xd5a7('0x4'));var Mustache=require(_0xd5a7('0x5'));var util=require('util');var path=require('path');var sox=require(_0xd5a7('0x6'));var csv=require(_0xd5a7('0x7'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xd5a7('0x8'));var squel=require('squel');var crypto=require(_0xd5a7('0x9'));var jsforce=require(_0xd5a7('0xa'));var deskjs=require(_0xd5a7('0xb'));var toCsv=require(_0xd5a7('0x7'));var querystring=require(_0xd5a7('0xc'));var Papa=require(_0xd5a7('0xd'));var Redis=require(_0xd5a7('0xe'));var authService=require(_0xd5a7('0xf'));var qs=require(_0xd5a7('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xd5a7('0x11'))(_0xd5a7('0x12'));var utils=require('../../config/utils');var config=require(_0xd5a7('0x13'));var licenseUtil=require(_0xd5a7('0x14'));var db=require('../../mysqldb')['db'];config[_0xd5a7('0x15')]=_[_0xd5a7('0x16')](config[_0xd5a7('0x15')],{'host':'localhost','port':0x18eb});var socket=require(_0xd5a7('0x17'))(new Redis(config[_0xd5a7('0x15')]));require(_0xd5a7('0x18'))[_0xd5a7('0x19')](socket);function respondWithStatusCode(_0x3cdd10,_0x527c5a){_0x527c5a=_0x527c5a||0xcc;return function(_0x5d72c7){if(_0x5d72c7){return _0x3cdd10['sendStatus'](_0x527c5a);}return _0x3cdd10[_0xd5a7('0x1a')](_0x527c5a)[_0xd5a7('0x1b')]();};}function respondWithResult(_0x107254,_0x42a2ed){_0x42a2ed=_0x42a2ed||0xc8;return function(_0xe6ef56){if(_0xe6ef56){return _0x107254['status'](_0x42a2ed)['json'](_0xe6ef56);}};}function respondWithFilteredResult(_0xb08a03,_0x5a5c31){return function(_0x35a3cd){if(_0x35a3cd){var _0x5368d1=_0x35a3cd[_0xd5a7('0x1c')],_0x40e728=_0x5a5c31[_0xd5a7('0x1d')],_0x128ec6=_0x5a5c31[_0xd5a7('0x1d')]+_0x5a5c31['limit'],_0x1af7d3;if(_0x128ec6>=_0x5368d1){_0x128ec6=_0x5368d1;_0x1af7d3=0xc8;}else{_0x1af7d3=0xce;}_0xb08a03['status'](_0x1af7d3);return _0xb08a03[_0xd5a7('0x1e')](_0xd5a7('0x1f'),_0x40e728+'-'+_0x128ec6+'/'+_0x5368d1)[_0xd5a7('0x20')](_0x35a3cd);}return null;};}function patchUpdates(_0x5c7d2f){return function(_0x1346bc){try{jsonpatch[_0xd5a7('0x21')](_0x1346bc,_0x5c7d2f,!![]);}catch(_0x52c302){return BPromise[_0xd5a7('0x22')](_0x52c302);}return _0x1346bc[_0xd5a7('0x23')]();};}function saveUpdates(_0x3a7201,_0xbf6f35){return function(_0xc835a3){if(_0xc835a3){return _0xc835a3['update'](_0x3a7201)[_0xd5a7('0x24')](function(_0x40fe32){return _0x40fe32;});}return null;};}function removeEntity(_0x2a9527,_0x2ef4dc){return function(_0xb7c271){if(_0xb7c271){return _0xb7c271[_0xd5a7('0x25')]()['then'](function(){_0x2a9527[_0xd5a7('0x1a')](0xcc)[_0xd5a7('0x1b')]();});}};}function handleEntityNotFound(_0x5413e0,_0xcbda6b){return function(_0x5a7489){if(!_0x5a7489){_0x5413e0[_0xd5a7('0x26')](0x194);}return _0x5a7489;};}function handleError(_0x7e0488,_0x23d3d8){_0x23d3d8=_0x23d3d8||0x1f4;return function(_0xae9076){logger[_0xd5a7('0x27')](_0xae9076['stack']);if(_0xae9076[_0xd5a7('0x28')]){delete _0xae9076['name'];}_0x7e0488['status'](_0x23d3d8)['send'](_0xae9076);};}function getInteractionUsers(_0x2a8c8a,_0x2b248b){return new BPromise(function(_0x309698,_0x425ad3){try{if(_0x2b248b[_0x2a8c8a['id']]){_0x2a8c8a[_0xd5a7('0x29')]=_[_0xd5a7('0x2a')](_0x2b248b[_0x2a8c8a['id']],function(_0x5a6a17){return{'id':_0x5a6a17['id'],'fullname':_0x5a6a17[_0xd5a7('0x2b')]};});}}catch(_0x2edf15){_0x425ad3(_0x2edf15);}_0x309698(_0x2a8c8a);});}function getInteractionTags(_0x3949c2,_0x4c07cd){return new BPromise(function(_0x5d6236,_0x2e2bca){try{if(_0x3949c2[_0xd5a7('0x2c')]){_0x3949c2['Tags']=[];_0x3949c2['TagIds'][_0xd5a7('0x2d')](',')['forEach'](function(_0x175239){_0x3949c2[_0xd5a7('0x2e')]['push'](_0x4c07cd[_0x175239]);});}delete _0x3949c2['TagIds'];}catch(_0x531417){_0x2e2bca(_0x531417);}_0x5d6236(_0x3949c2);});}function updateWhatsappInteraction(_0x2d0d09,_0x259ca7,_0x1e893c){return new BPromise(function(_0x3094ed,_0x418ec8){return getInteractionUsers(_0x2d0d09,_0x1e893c)['then'](function(_0x473222){return getInteractionTags(_0x473222,_0x259ca7);})[_0xd5a7('0x24')](function(_0x38b76e){_0x3094ed(_0x38b76e);})['catch'](function(_0x14d0f0){_0x418ec8(_0x14d0f0);});});}exports[_0xd5a7('0x2f')]=function(_0x25f027,_0x52cfaf){var _0x445754={},_0x437266={},_0x564869={'count':0x0,'rows':[]};var _0x2fcf7c=_['map'](db[_0xd5a7('0x30')][_0xd5a7('0x31')],function(_0x4868a0){return{'name':_0x4868a0['fieldName'],'type':_0x4868a0[_0xd5a7('0x32')][_0xd5a7('0x33')]};});_0x437266[_0xd5a7('0x34')]=_[_0xd5a7('0x2a')](_0x2fcf7c,_0xd5a7('0x28'));_0x437266[_0xd5a7('0x35')]=_['keys'](_0x25f027[_0xd5a7('0x35')]);_0x437266['filters']=_[_0xd5a7('0x36')](_0x437266[_0xd5a7('0x34')],_0x437266['query']);_0x445754[_0xd5a7('0x37')]=_[_0xd5a7('0x36')](_0x437266[_0xd5a7('0x34')],qs[_0xd5a7('0x38')](_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x38')]));_0x445754[_0xd5a7('0x37')]=_0x445754[_0xd5a7('0x37')][_0xd5a7('0x39')]?_0x445754[_0xd5a7('0x37')]:_0x437266['model'];if(!_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x3a')]('nolimit')){_0x445754[_0xd5a7('0x3b')]=qs['limit'](_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x3b')]);_0x445754[_0xd5a7('0x1d')]=qs[_0xd5a7('0x1d')](_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x1d')]);}_0x445754['order']=qs['sort'](_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x3c')]);_0x445754[_0xd5a7('0x3d')]=qs[_0xd5a7('0x3e')](_[_0xd5a7('0x3f')](_0x25f027[_0xd5a7('0x35')],_0x437266[_0xd5a7('0x3e')]),_0x2fcf7c);var _0x31881a=[];var _0x287a43=squel[_0xd5a7('0x40')]()[_0xd5a7('0x41')]('id')[_0xd5a7('0x41')]('name')['field']('color')[_0xd5a7('0x42')](_0xd5a7('0x43'));var _0x5eea21=squel[_0xd5a7('0x40')]()['field'](_0xd5a7('0x44'))[_0xd5a7('0x41')](_0xd5a7('0x45'))[_0xd5a7('0x41')](_0xd5a7('0x46'))[_0xd5a7('0x42')](_0xd5a7('0x47'),'ui')[_0xd5a7('0x48')](_0xd5a7('0x49'),'u',_0xd5a7('0x4a'));var _0x3c1148=squel['select']()[_0xd5a7('0x42')](_0xd5a7('0x4b'),'i')[_0xd5a7('0x48')]('cm_contacts','c',_0xd5a7('0x4c'))[_0xd5a7('0x48')](_0xd5a7('0x49'),'o',_0xd5a7('0x4d'))[_0xd5a7('0x48')](_0xd5a7('0x4e'),'a','a.id\x20=\x20i.WhatsappAccountId')['left_join'](_0xd5a7('0x4f'),'me',_0xd5a7('0x50'))['left_join'](_0xd5a7('0x51'),'it',_0xd5a7('0x52'))[_0xd5a7('0x48')](_0xd5a7('0x43'),'t','t.id\x20=\x20it.TagId');var _0x277c6c=squel['expr']();var _0x38ea3d=[];var _0x12e8c9=squel[_0xd5a7('0x53')]();var _0x394520;if(_0x25f027['query'][_0xd5a7('0x54')]){_0x394520=as[_0xd5a7('0x55')](_0x25f027['query'][_0xd5a7('0x54')]);var _0x1cdfba=_0x394520[_0xd5a7('0x56')];for(var _0x510740=0x0;_0x510740<_0x394520['conditions'][_0xd5a7('0x39')];_0x510740++){var _0x3f3bce=_0x394520[_0xd5a7('0x57')][_0x510740];var _0xc07f71='i';var _0x44690d=_[_0xd5a7('0x58')](_0x2fcf7c,[_0xd5a7('0x28'),_0x3f3bce[_0xd5a7('0x41')]]);if(!_0x44690d){switch(_0x3f3bce['field']){case'unreadMessages':if(_0x3f3bce[_0xd5a7('0x59')]==0x1){_0x3c1148['having']('`'+_0x3f3bce[_0xd5a7('0x41')]+'`\x20=\x200');}else{_0x3c1148[_0xd5a7('0x5a')]('`'+_0x3f3bce[_0xd5a7('0x41')]+_0xd5a7('0x5b'));}break;case _0xd5a7('0x5c'):if(_0x3f3bce[_0xd5a7('0x5d')]===_0xd5a7('0x5e')){if(_0x3f3bce[_0xd5a7('0x59')][_0xd5a7('0x2d')]('\x20')[_0xd5a7('0x39')]>0x1){_0x277c6c[_0x1cdfba](_0xd5a7('0x5f'),qs[_0xd5a7('0x60')](_0x3f3bce[_0xd5a7('0x59')]),null);}else{var _0x17a6ed='%'+_0x3f3bce[_0xd5a7('0x59')]+'%';_0x277c6c[_0x1cdfba](_0xd5a7('0x61'),_0x17a6ed,_0x17a6ed,_0x17a6ed);}}else{_0x44690d=_[_0xd5a7('0x58')](_0x2fcf7c,[_0xd5a7('0x28'),_0xd5a7('0x62')]);_0x3f3bce[_0xd5a7('0x41')]=_0xd5a7('0x62');_0x41a6b3=as['buildExpression'](_0xc07f71,_0x44690d['type'],_0x3f3bce);_0x277c6c[_0x1cdfba](_0x41a6b3[_0xd5a7('0x63')],_0x41a6b3['value'][_0xd5a7('0x64')],_0x41a6b3[_0xd5a7('0x59')][_0xd5a7('0x1b')]);}break;case'Tag':var _0x3b59a0=_0x3f3bce[_0xd5a7('0x59')][_0xd5a7('0x2d')](',')[_0xd5a7('0x2a')](function(_0x2a0b78){return Number(_0x2a0b78);});_0x3b59a0['forEach'](function(_0x415f1c){_0x12e8c9['or'](_0xd5a7('0x65'),'%,'+_0x415f1c+',%');});_0x38ea3d=_[_0xd5a7('0x66')](_0x38ea3d,_0x3b59a0);break;case _0xd5a7('0x67'):if(_0x3f3bce[_0xd5a7('0x5d')]===_0xd5a7('0x5e')){_0x277c6c[_0x1cdfba](_0xd5a7('0x68'),'%'+_0x3f3bce['value']+'%',null);}else{_0x44690d=_[_0xd5a7('0x58')](_0x2fcf7c,[_0xd5a7('0x28'),_0xd5a7('0x69')]);_0x3f3bce['field']='UserId';_0x41a6b3=as[_0xd5a7('0x6a')](_0xc07f71,_0x44690d[_0xd5a7('0x32')],_0x3f3bce);_0x277c6c[_0x1cdfba](_0x41a6b3[_0xd5a7('0x63')],_0x41a6b3[_0xd5a7('0x59')][_0xd5a7('0x64')],_0x41a6b3['value'][_0xd5a7('0x1b')]);}break;case'body':_0x41a6b3=as[_0xd5a7('0x6a')]('me',null,_0x3f3bce);_0x277c6c[_0x1cdfba](_0x41a6b3[_0xd5a7('0x63')],_0x41a6b3[_0xd5a7('0x59')][_0xd5a7('0x64')],_0x41a6b3[_0xd5a7('0x59')][_0xd5a7('0x1b')]);break;}}else{var _0x41a6b3=as[_0xd5a7('0x6a')](_0xc07f71,_0x44690d['type'],_0x3f3bce);_0x277c6c[_0x1cdfba](_0x41a6b3[_0xd5a7('0x63')],_0x41a6b3[_0xd5a7('0x59')][_0xd5a7('0x64')],_0x41a6b3[_0xd5a7('0x59')][_0xd5a7('0x1b')]);}}}else{var _0xb7e739=_(_0x25f027[_0xd5a7('0x35')])[_0xd5a7('0x6b')]()[_0xd5a7('0x2a')](function(_0x3cac46){return _['some'](_0x2fcf7c,[_0xd5a7('0x28'),_0x3cac46])?_0x3cac46:undefined;})['compact']()[_0xd5a7('0x59')]();if(!_['isEmpty'](_0xb7e739)){_0xb7e739['forEach'](function(_0x332884){if(_0x332884===_0xd5a7('0x6c')){_0x3c1148[_0xd5a7('0x3d')]('i.WhatsappAccountId\x20IN\x20?',[][_0xd5a7('0x6d')](_0x25f027['query'][_0x332884]));}else if(_0x332884==='createdAt'){var _0x46384e=JSON['parse'](_0x25f027[_0xd5a7('0x35')][_0x332884])[_0xd5a7('0x6e')];var _0x556888=JSON['parse'](_0x25f027[_0xd5a7('0x35')][_0x332884])['$lte'];_0x3c1148[_0xd5a7('0x3d')]('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x46384e,_0x556888);}else{if(_0x25f027['query'][_0x332884]===_0xd5a7('0x6f')){_0x3c1148[_0xd5a7('0x3d')]('i.'+_0x332884+_0xd5a7('0x70'));}else{_0x3c1148[_0xd5a7('0x3d')]('i.'+_0x332884+_0xd5a7('0x71'),_0x25f027['query'][_0x332884]);}}});}if(_0x25f027['query']['read']){if(_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x72')]==0x1){_0x3c1148[_0xd5a7('0x5a')](_0xd5a7('0x73'));}else{_0x3c1148[_0xd5a7('0x5a')]('`unreadMessages`\x20>\x200');}}if(_0x25f027['query'][_0xd5a7('0x74')]){_0x38ea3d=_[_0xd5a7('0x75')](_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x74')])?_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x74')]:new Array(_0x25f027['query']['tag']);_0x38ea3d['forEach'](function(_0x44ebb6){_0x12e8c9['or'](_0xd5a7('0x65'),'%,'+_0x44ebb6+',%');});}if(_0x25f027['query'][_0xd5a7('0x76')]){var _0x3555af=_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x76')][_0xd5a7('0x77')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs[_0xd5a7('0x78')](_0x3555af)){_0x277c6c['or']('i.id\x20LIKE\x20?',_0x3555af+'%')['or'](_0xd5a7('0x79'),_0x3555af+'%');}else{_0x277c6c['or'](_0xd5a7('0x7a'),qs[_0xd5a7('0x60')](_0x3555af))['or'](_0xd5a7('0x7b'),_0x3555af+'%');}}}_0x3c1148[_0xd5a7('0x3d')](_0x277c6c);_0x3c1148[_0xd5a7('0x7c')](_0xd5a7('0x7d'));var _0x3fef71={'type':db['Sequelize']['QueryTypes'][_0xd5a7('0x7e')],'raw':!![]};var _0x258112=_0x3c1148['clone']();_0x258112['field'](_0xd5a7('0x7d'));_0x258112['field'](_0xd5a7('0x7f'),_0xd5a7('0x80'));if(_0x445754[_0xd5a7('0x81')]){_0x445754[_0xd5a7('0x81')]['forEach'](function(_0x481c9a){var _0x16dd8b=_0x481c9a[0x0]===_0xd5a7('0x82')?_0x481c9a[0x0]:'i.'+_0x481c9a[0x0];_0x3c1148[_0xd5a7('0x81')](_0x16dd8b,_0x481c9a[0x1]===_0xd5a7('0x83')?![]:!![]);});}if(!_[_0xd5a7('0x84')](_0x38ea3d)){_0x3c1148[_0xd5a7('0x5a')](_0x12e8c9);_0x258112[_0xd5a7('0x3d')](_0xd5a7('0x85'),_0x38ea3d);}BPromise[_0xd5a7('0x86')]()[_0xd5a7('0x24')](function(){if(!_0x394520){if(_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x6c')]||_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x87')])return;_0x258112[_0xd5a7('0x3d')]('i.WhatsappAccountId\x20IS\x20NOT\x20NULL');_0x3c1148[_0xd5a7('0x3d')](_0xd5a7('0x88'));return;}if(_0x25f027[_0xd5a7('0x89')][_0xd5a7('0x8a')]!==_0xd5a7('0x8b'))return;return _0x25f027[_0xd5a7('0x89')][_0xd5a7('0x8c')]({'attributes':['id'],'raw':!![]})[_0xd5a7('0x24')](function(_0x2cb829){if(_['isEmpty'](_0x2cb829)){_0x258112[_0xd5a7('0x3d')](_0xd5a7('0x8d'));_0x3c1148[_0xd5a7('0x3d')]('i.WhatsappAccountId\x20IS\x20NULL');}else{_0x258112['where']('i.WhatsappAccountId\x20IN\x20?',_[_0xd5a7('0x2a')](_0x2cb829,'id'));_0x3c1148[_0xd5a7('0x3d')](_0xd5a7('0x8e'),_[_0xd5a7('0x2a')](_0x2cb829,'id'));}});})['then'](function(){if(_0x25f027['user'][_0xd5a7('0x8a')]===_0xd5a7('0x8b')&&!_0x394520&&!_0x25f027[_0xd5a7('0x35')][_0xd5a7('0x6c')])return[];return db[_0xd5a7('0x8f')][_0xd5a7('0x35')](_0x258112[_0xd5a7('0x90')](),_0x3fef71);})[_0xd5a7('0x24')](function(_0x231db3){_0x564869[_0xd5a7('0x1c')]=_0x231db3['length'];if(_0x564869[_0xd5a7('0x1c')]===0x0)return[];return db[_0xd5a7('0x8f')][_0xd5a7('0x35')](_0x287a43[_0xd5a7('0x90')](),_0x3fef71)[_0xd5a7('0x24')](function(_0x58c932){_0x31881a=_['keyBy'](_0x58c932,'id');_0x3fef71=_[_0xd5a7('0x91')](_0x3fef71,{'model':db[_0xd5a7('0x30')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x25f027[_0xd5a7('0x35')]['fields']){_0x445754['attributes']['forEach'](function(_0x113447){_0x3c1148['field']('i.'+_0x113447);});}else{_0x3c1148[_0xd5a7('0x41')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0xd5a7('0x80'));_0x3c1148[_0xd5a7('0x41')]('a.key','Account.key');_0x3c1148['field'](_0xd5a7('0x92'),_0xd5a7('0x93'));_0x3c1148['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');_0x3c1148[_0xd5a7('0x41')]('i.*');_0x3c1148[_0xd5a7('0x41')](_0xd5a7('0x94'),_0xd5a7('0x95'));_0x3c1148[_0xd5a7('0x41')](_0xd5a7('0x96'),_0xd5a7('0x97'));_0x3c1148[_0xd5a7('0x41')]('c.email',_0xd5a7('0x98'));_0x3c1148[_0xd5a7('0x41')]('c.phone',_0xd5a7('0x99'));_0x3c1148[_0xd5a7('0x41')]('c.mobile',_0xd5a7('0x9a'));_0x3c1148[_0xd5a7('0x41')](_0xd5a7('0x9b'),_0xd5a7('0x9c'));_0x3c1148[_0xd5a7('0x41')](_0xd5a7('0x9d'),_0xd5a7('0x9e'));_0x3c1148['field']('o.internal',_0xd5a7('0x9f'));_0x3c1148[_0xd5a7('0x41')](_0xd5a7('0xa0'),_0xd5a7('0x2c'));}if(_0x445754[_0xd5a7('0x3b')])_0x3c1148['limit'](_0x445754['limit']);if(_0x445754[_0xd5a7('0x1d')])_0x3c1148[_0xd5a7('0x1d')](_0x445754['offset']);return db[_0xd5a7('0x8f')][_0xd5a7('0x35')](_0x3c1148[_0xd5a7('0x90')](),_0x3fef71);})['then'](function(_0x3a9e56){_0x5eea21[_0xd5a7('0x3d')](_0xd5a7('0xa1'),_['map'](_0x3a9e56,'id'));return db['sequelize'][_0xd5a7('0x35')](_0x5eea21[_0xd5a7('0x90')](),_0x3fef71)['then'](function(_0x52babe){var _0x15a4e2=_[_0xd5a7('0xa2')](_0x52babe,_0xd5a7('0xa3'));var _0x502df3=[];_0x3a9e56[_0xd5a7('0xa4')](function(_0x2cb0b3){_0x502df3[_0xd5a7('0xa5')](updateWhatsappInteraction(_0x2cb0b3,_0x31881a,_0x15a4e2));});return BPromise[_0xd5a7('0xa6')](_0x502df3);});});})[_0xd5a7('0x24')](function(_0x277aa6){_0x564869['rows']=_0x277aa6;return _0x564869;})['then'](respondWithFilteredResult(_0x52cfaf,_0x445754))[_0xd5a7('0xa7')](handleError(_0x52cfaf,null));};exports[_0xd5a7('0xa8')]=function(_0x2c5275,_0xdfdf57){var _0x101941={'raw':![],'where':{'id':_0x2c5275[_0xd5a7('0xa9')]['id']}},_0x322232={};_0x322232[_0xd5a7('0x34')]=_['keys'](db['WhatsappInteraction']['rawAttributes']);_0x322232['query']=_['keys'](_0x2c5275[_0xd5a7('0x35')]);_0x322232[_0xd5a7('0x3e')]=_[_0xd5a7('0x36')](_0x322232[_0xd5a7('0x34')],_0x322232[_0xd5a7('0x35')]);_0x101941[_0xd5a7('0x37')]=_['intersection'](_0x322232[_0xd5a7('0x34')],qs[_0xd5a7('0x38')](_0x2c5275['query']['fields']));_0x101941[_0xd5a7('0x37')]=_0x101941['attributes'][_0xd5a7('0x39')]?_0x101941['attributes']:_0x322232[_0xd5a7('0x34')];if(_0x2c5275['query'][_0xd5a7('0xaa')]){_0x101941[_0xd5a7('0xab')]=[{'all':!![]}];}_0x101941=_[_0xd5a7('0x91')]({},_0x101941,_0x2c5275[_0xd5a7('0xac')]);return db[_0xd5a7('0x30')][_0xd5a7('0x58')](_0x101941)[_0xd5a7('0x24')](handleEntityNotFound(_0xdfdf57,null))[_0xd5a7('0x24')](respondWithResult(_0xdfdf57,null))[_0xd5a7('0xa7')](handleError(_0xdfdf57,null));};exports['create']=function(_0x57234b,_0x19159a){return db[_0xd5a7('0x30')]['create'](_0x57234b[_0xd5a7('0xad')],{})[_0xd5a7('0x24')](respondWithResult(_0x19159a,0xc9))[_0xd5a7('0xa7')](handleError(_0x19159a,null));};exports[_0xd5a7('0xae')]=function(_0x494818,_0x49f6ee){if(_0x494818['body']['id']){delete _0x494818[_0xd5a7('0xad')]['id'];}return db[_0xd5a7('0x30')][_0xd5a7('0x58')]({'where':{'id':_0x494818[_0xd5a7('0xa9')]['id']}})[_0xd5a7('0x24')](handleEntityNotFound(_0x49f6ee,null))[_0xd5a7('0x24')](saveUpdates(_0x494818['body'],null))['then'](respondWithResult(_0x49f6ee,null))[_0xd5a7('0xa7')](handleError(_0x49f6ee,null));};exports[_0xd5a7('0x25')]=function(_0x590990,_0x4d0be8){return db[_0xd5a7('0x30')][_0xd5a7('0x58')]({'where':{'id':_0x590990[_0xd5a7('0xa9')]['id']}})[_0xd5a7('0x24')](handleEntityNotFound(_0x4d0be8,null))[_0xd5a7('0x24')](removeEntity(_0x4d0be8,null))[_0xd5a7('0xa7')](handleError(_0x4d0be8,null));};exports[_0xd5a7('0xaf')]=function(_0x3cf0ef,_0x3543c3){return db[_0xd5a7('0x30')][_0xd5a7('0xaf')]()['then'](respondWithResult(_0x3543c3,null))[_0xd5a7('0xa7')](handleError(_0x3543c3,null));};exports[_0xd5a7('0xb0')]=function(_0x3bc6d5,_0x444f65,_0x2591ae){return db[_0xd5a7('0xb1')]['find']({'where':{'id':_0x3bc6d5[_0xd5a7('0xa9')]['id']}})[_0xd5a7('0x24')](handleEntityNotFound(_0x444f65,null))[_0xd5a7('0x24')](function(_0x3e0040){if(_0x3e0040){return _0x3e0040[_0xd5a7('0xb0')](_0x3bc6d5[_0xd5a7('0xad')]['ids'],_[_0xd5a7('0xb2')](_0x3bc6d5[_0xd5a7('0xad')],['ids','id'])||{});}})[_0xd5a7('0x24')](respondWithResult(_0x444f65,null))['catch'](handleError(_0x444f65,null));};exports[_0xd5a7('0xb3')]=function(_0x5c90dc,_0x56cde3,_0x60c3b){var _0x562c39={'raw':![],'where':{}};var _0x5423c9={};var _0x59222c={'count':0x0,'rows':[]};return db['WhatsappInteraction'][_0xd5a7('0xb4')]({'where':{'id':_0x5c90dc[_0xd5a7('0xa9')]['id']}})[_0xd5a7('0x24')](handleEntityNotFound(_0x56cde3,null))[_0xd5a7('0x24')](function(_0x19e782){if(_0x19e782){_0x5423c9[_0xd5a7('0x34')]=_['keys'](db[_0xd5a7('0xb1')][_0xd5a7('0x31')]);_0x5423c9[_0xd5a7('0x35')]=_[_0xd5a7('0x6b')](_0x5c90dc['query']);_0x5423c9['filters']=_['intersection'](_0x5423c9['model'],_0x5423c9['query']);_0x562c39['attributes']=_[_0xd5a7('0x36')](_0x5423c9['model'],qs['fields'](_0x5c90dc['query']['fields']));_0x562c39[_0xd5a7('0x37')]=_0x562c39[_0xd5a7('0x37')][_0xd5a7('0x39')]?_0x562c39[_0xd5a7('0x37')]:_0x5423c9[_0xd5a7('0x34')];if(!_0x5c90dc[_0xd5a7('0x35')][_0xd5a7('0x3a')](_0xd5a7('0xb5'))){_0x562c39[_0xd5a7('0x3b')]=qs['limit'](_0x5c90dc[_0xd5a7('0x35')][_0xd5a7('0x3b')]);_0x562c39[_0xd5a7('0x1d')]=qs[_0xd5a7('0x1d')](_0x5c90dc[_0xd5a7('0x35')][_0xd5a7('0x1d')]);}_0x562c39[_0xd5a7('0x81')]=qs[_0xd5a7('0x3c')](_0x5c90dc[_0xd5a7('0x35')][_0xd5a7('0x3c')]);_0x562c39['where']=qs[_0xd5a7('0x3e')](_[_0xd5a7('0x3f')](_0x5c90dc['query'],_0x5423c9[_0xd5a7('0x3e')]));_0x562c39[_0xd5a7('0x3d')][_0xd5a7('0xa3')]=_0x19e782['id'];if(_0x5c90dc[_0xd5a7('0x35')]['filter']){_0x562c39[_0xd5a7('0x3d')]=_[_0xd5a7('0x91')](_0x562c39['where'],{'$or':_[_0xd5a7('0x2a')](_0x562c39[_0xd5a7('0x37')],function(_0x3147e5){var _0x376ad1={};_0x376ad1[_0x3147e5]={'$like':'%'+_0x5c90dc[_0xd5a7('0x35')]['filter']+'%'};return _0x376ad1;})});}if(_0x5c90dc[_0xd5a7('0x35')][_0xd5a7('0x6e')]){var _0x58d856=_0x5c90dc[_0xd5a7('0x35')][_0xd5a7('0x6e')]['split'](',');var _0x343b37={};_0x343b37[_0x58d856[0x0]]={'$gte':moment(_0x58d856[0x1])[_0xd5a7('0xb6')]('YYYY-MM-DD\x20HH:mm:ss')};_0x562c39[_0xd5a7('0x3d')]=_[_0xd5a7('0x91')](_0x562c39['where'],_0x343b37);}_0x562c39=_['merge']({},_0x562c39,_0x5c90dc[_0xd5a7('0xac')]);return db[_0xd5a7('0xb1')]['count']({'where':_0x562c39[_0xd5a7('0x3d')]})[_0xd5a7('0x24')](function(_0x240d98){_0x59222c['count']=_0x240d98;if(_0x5c90dc['query']['includeAll']){_0x562c39[_0xd5a7('0xab')]=[{'all':!![]}];}return db['WhatsappMessage'][_0xd5a7('0xb7')](_0x562c39);})['then'](function(_0x454e95){_0x59222c[_0xd5a7('0xb8')]=_0x454e95;return _0x59222c;});}})[_0xd5a7('0x24')](respondWithFilteredResult(_0x56cde3,_0x562c39))['catch'](handleError(_0x56cde3,null));};exports['addTags']=function(_0x34d1df,_0x137c2d,_0x580fc1){return db[_0xd5a7('0x30')]['find']({'where':{'id':_0x34d1df[_0xd5a7('0xa9')]['id']}})[_0xd5a7('0x24')](handleEntityNotFound(_0x137c2d,null))[_0xd5a7('0x24')](function(_0x103596){if(_0x103596){return _0x103596[_0xd5a7('0xb9')](_0x34d1df['body'][_0xd5a7('0xba')],_[_0xd5a7('0xb2')](_0x34d1df[_0xd5a7('0xad')],[_0xd5a7('0xba'),'id'])||{})[_0xd5a7('0xbb')](function(){return db['Tag']['findAll']({'attributes':['id',_0xd5a7('0x28'),'color'],'where':{'id':_0x34d1df[_0xd5a7('0xad')][_0xd5a7('0xba')]}});})['then'](function(_0x5e9e7f){socket['emit'](_0xd5a7('0xbc'),{'id':Number(_0x34d1df[_0xd5a7('0xa9')]['id']),'tags':_0x5e9e7f||[]});return{'id':Number(_0x34d1df['params']['id']),'tags':_0x5e9e7f||[]};});}})[_0xd5a7('0x24')](respondWithResult(_0x137c2d,null))[_0xd5a7('0xa7')](handleError(_0x137c2d,null));};exports['removeTags']=function(_0x3a0463,_0x5d612c,_0x501b8b){return db[_0xd5a7('0x30')][_0xd5a7('0x58')]({'where':{'id':_0x3a0463['params']['id']}})[_0xd5a7('0x24')](handleEntityNotFound(_0x5d612c,null))['then'](function(_0x5cbc47){if(_0x5cbc47){return _0x5cbc47['removeTags'](_0x3a0463['query'][_0xd5a7('0xba')]);}})['then'](respondWithStatusCode(_0x5d612c,null))['catch'](handleError(_0x5d612c,null));};exports['download']=function(_0x32b37d,_0x29176a){var _0x254ff8=moment()['unix']()[_0xd5a7('0x90')]();var _0x22f7af=path['join'](config[_0xd5a7('0xbd')],_0xd5a7('0xbe'),_0xd5a7('0xbf'),_0xd5a7('0xc0'));var _0x3169fa=path['join'](config['root'],_0xd5a7('0xbe'),_0xd5a7('0xbf'),'attachments');var _0xa54082=path[_0xd5a7('0xc1')](_0x22f7af,_0x254ff8);var _0x56c24b=util[_0xd5a7('0xb6')](_0xd5a7('0xc2'),_0x32b37d['params']['id'],_0x254ff8);var _0x13c572=path[_0xd5a7('0xc1')](_0x22f7af,_0x56c24b);var _0x2b0df7=[];_0x2b0df7[_0xd5a7('0xa5')]({'model':db[_0xd5a7('0x67')],'as':_0xd5a7('0x67'),'attributes':['id',_0xd5a7('0x2b')],'raw':!![]});_0x2b0df7[_0xd5a7('0xa5')]({'model':db[_0xd5a7('0xc3')],'as':_0xd5a7('0x5c'),'attributes':['id','firstName',_0xd5a7('0xc4')],'raw':!![]});if(_0x32b37d[_0xd5a7('0x35')][_0xd5a7('0xc5')]){_0x2b0df7[_0xd5a7('0xa5')]({'model':db['Attachment'],'as':_0xd5a7('0xc6'),'raw':!![]});}var _0x165ba7=[{'model':db[_0xd5a7('0xb1')],'as':_0xd5a7('0xc7'),'attributes':['id',_0xd5a7('0xad'),_0xd5a7('0xc8'),_0xd5a7('0xc9'),'secret',_0xd5a7('0x72')],'include':_0x2b0df7}];_0x165ba7[_0xd5a7('0xa5')]({'model':db[_0xd5a7('0xca')],'as':_0xd5a7('0xcb'),'attributes':['id',_0xd5a7('0x28')]});_0x165ba7[_0xd5a7('0xa5')]({'model':db[_0xd5a7('0x67')],'as':'Owner','attributes':['id','fullname']});return db[_0xd5a7('0x30')]['find']({'where':{'id':_0x32b37d['params']['id']},'include':_0x165ba7})['then'](handleEntityNotFound(_0x29176a,null))[_0xd5a7('0x24')](function(_0x4fbe31){if(_0x4fbe31){var _0x485452=_0x4fbe31[_0xd5a7('0xcc')]({'plain':!![]});fs[_0xd5a7('0xcd')](_0xa54082);var _0x4ee648={'format':'A4','border':'10px','header':{'height':_0xd5a7('0xce'),'contents':{'first':_0xd5a7('0xcf')}},'footer':{'height':'30px','contents':{'default':util['format'](_0xd5a7('0xd0'),util[_0xd5a7('0xb6')](_0xd5a7('0xd1'),_0xd5a7('0xd2'),_0x485452['id']),moment()[_0xd5a7('0xb6')](_0xd5a7('0xd3'))['toString']())}}};var _0x94f927={'channel':_0xd5a7('0xd2'),'account':_0x485452[_0xd5a7('0xcb')][_0xd5a7('0x28')],'agent':_0x485452[_0xd5a7('0xd4')]?_0x485452['Owner'][_0xd5a7('0x2b')]:_0xd5a7('0xd5'),'createdAt':moment(_0x485452[_0xd5a7('0xc8')])['format'](_0xd5a7('0xd6'))[_0xd5a7('0x90')](),'closedAt':_0x485452[_0xd5a7('0xd7')]?moment(_0x485452[_0xd5a7('0xd8')])[_0xd5a7('0xb6')](_0xd5a7('0xd6'))[_0xd5a7('0x90')]():'','disposition':_0x485452[_0xd5a7('0xd9')],'messages':_(_0x485452['Messages'])['filter']({'secret':![]})[_0xd5a7('0x2a')](function(_0x435d5d){if(_0x435d5d['Attachment']){var _0x45f0d8=path[_0xd5a7('0xc1')](_0x3169fa,_0x435d5d[_0xd5a7('0xc6')][_0xd5a7('0xda')]);if(fs[_0xd5a7('0xdb')](_0x45f0d8)){fs[_0xd5a7('0xdc')](_0x45f0d8)['pipe'](fs[_0xd5a7('0xdd')](path[_0xd5a7('0xc1')](_0xa54082,_0x435d5d[_0xd5a7('0xc6')][_0xd5a7('0xda')])));}}return{'date':moment(_0x435d5d['createdAt'])[_0xd5a7('0xb6')](_0xd5a7('0xd6'))[_0xd5a7('0x90')](),'sender':_0x435d5d[_0xd5a7('0xc9')]===_0xd5a7('0xde')?_0x435d5d[_0xd5a7('0x67')]?_0x435d5d[_0xd5a7('0x67')][_0xd5a7('0x2b')]:_0xd5a7('0xdf'):_0x435d5d[_0xd5a7('0x5c')][_0xd5a7('0xe0')]+(_0x435d5d[_0xd5a7('0x5c')][_0xd5a7('0xc4')]?'\x20'+_0x435d5d[_0xd5a7('0x5c')][_0xd5a7('0xc4')]:''),'body':_0x435d5d[_0xd5a7('0xc6')]?_0x435d5d[_0xd5a7('0xc6')]['basename']:_0x435d5d[_0xd5a7('0xad')],'direction':_0x435d5d[_0xd5a7('0xc9')]===_0xd5a7('0xde')?'A':'C','secret':_0x435d5d[_0xd5a7('0xe1')],'read':_0x435d5d[_0xd5a7('0x72')],'attachment':_0x435d5d[_0xd5a7('0xc6')]};})[_0xd5a7('0x59')]()};return ejs[_0xd5a7('0xe2')](path[_0xd5a7('0xc1')](config[_0xd5a7('0xbd')],_0xd5a7('0xbe'),_0xd5a7('0xe3'),'downloadInteraction.html'),{'interaction':_0x94f927})[_0xd5a7('0x24')](function(_0x5e7bd7){return new BPromise(function(_0x32ec6e,_0x1c3713){pdf['create'](_0x5e7bd7,_0x4ee648)[_0xd5a7('0xe4')](path['join'](_0xa54082,_0xd5a7('0xe5')+_0x485452['id']+'-'+_0x254ff8+_0xd5a7('0xe6')),function(_0x598d5e,_0xb64a59){if(_0x598d5e)return _0x1c3713(_0x598d5e);_0x32ec6e(_0xb64a59);});});})[_0xd5a7('0x24')](function(){return new BPromise(function(_0x2790e3,_0x1c27b4){zipdir(_0xa54082,{'saveTo':_0x13c572},function(_0x2046c3,_0x57d466){if(_0x2046c3)return _0x1c27b4(_0x2046c3);return _0x2790e3(_0x57d466);});})[_0xd5a7('0x24')](function(){return new BPromise(function(_0x8b57ee,_0x63f362){rimraf(_0xa54082,function(_0xb7570a){if(_0xb7570a)_0x63f362(_0xb7570a);return _0x8b57ee();});});})['then'](function(){return _0x29176a[_0xd5a7('0xe7')](_0x13c572,_0x56c24b,function(_0x26e1b3){if(_0x26e1b3){console['log'](_0xd5a7('0xe8'),_0x26e1b3);}else{fs[_0xd5a7('0xe9')](_0x13c572);}});});});}else{return _0x29176a['sendStatus'](0xc8);}})['catch'](handleError(_0x29176a,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff