Built motion from commit 87cd5f02.|2.5.48
[motion2.git] / server / api / whatsappInteraction / whatsappInteraction.controller.js
index 9f9e998..428ec88 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x7a54=['N.A.','YYYY-MM-DD\x20HH:mm:ss','closed','closedAt','disposition','Messages','existsSync','createWriteStream','out','System','firstName','basename','secret','renderFile','views','downloadInteraction.html','toFile','transcript-','.pdf','log','err','unlinkSync','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','ejs','squel','crypto','desk.js','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./whatsappInteraction.socket','register','status','end','count','offset','limit','Content-Range','json','apply','save','then','destroy','sendStatus','error','stack','name','send','Users','TagIds','Tags','index','WhatsappInteraction','fieldName','type','key','model','map','query','keys','filters','intersection','attributes','fields','nolimit','order','sort','pick','field','from','tools_tags','u.id','user_has_whatsapp_interactions','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','a.id\x20=\x20i.WhatsappAccountId','it.WhatsappInteractionId\x20=\x20i.id','expr','search','parseSearch','sqlOperator','conditions','length','find','value','having','`\x20=\x200','`\x20>\x200','Contact','operator','$substring','split','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?','User','UserId','body','start','some','compact','forEach','WhatsappAccountId','where','i.WhatsappAccountId\x20IN\x20?','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20>\x200','isArray','tag','filter','isNumeric','i.id\x20LIKE\x20?','i.phone\x20LIKE\x20?','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?','group','i.id','Sequelize','QueryTypes','SELECT','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','contactName','DESC','isEmpty','t.id\x20IN\x20?','resolve','i.WhatsappAccountId\x20IS\x20NOT\x20NULL','user','agent','getWhatsappAccounts','i.WhatsappAccountId\x20IS\x20NULL','role','toString','keyBy','merge','unreadMessages','a.key','a.mandatoryDisposition','Account.mandatoryDisposition','CASE\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','Contact.firstName','c.lastName','Contact.lastName','c.email','c.phone','Contact.phone','c.mobile','c.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.WhatsappInteractionId\x20IN\x20?','sequelize','WhatsappInteractionId','push','all','catch','show','params','include','create','describe','addMessage','WhatsappMessage','ids','omit','findOne','format','options','includeAll','findAll','rows','addTags','setTags','color','emit','whatsappInteractionTags:save','removeTags','download','unix','root','server','files','tmp','attachments','join','transcript-%d-%s.zip','fullname','lastName','Attachment','direction','Owner','get','mkdirSync','40px','30px','<hr\x20class=\x22separator\x22/>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22footer\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22left\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<span>%s</span>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22center\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<span>{{page}}/{{pages}}</span>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22right\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<span>%s</span>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>','%s\x20#%d','YYYY-MM-DD','Account'];(function(_0x4d7ca6,_0x422b3f){var _0x12ad69=function(_0x1a7afa){while(--_0x1a7afa){_0x4d7ca6['push'](_0x4d7ca6['shift']());}};_0x12ad69(++_0x422b3f);}(_0x7a54,0x106));var _0x47a5=function(_0x4e3314,_0x3e6471){_0x4e3314=_0x4e3314-0x0;var _0x45494a=_0x7a54[_0x4e3314];return _0x45494a;};'use strict';var pdf=require(_0x47a5('0x0'));var emlformat=require(_0x47a5('0x1'));var rimraf=require(_0x47a5('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x47a5('0x3'));var rp=require(_0x47a5('0x4'));var moment=require('moment');var BPromise=require(_0x47a5('0x5'));var Mustache=require(_0x47a5('0x6'));var util=require(_0x47a5('0x7'));var path=require(_0x47a5('0x8'));var sox=require(_0x47a5('0x9'));var csv=require('to-csv');var ejs=require(_0x47a5('0xa'));var fs=require('fs');var _=require('lodash');var squel=require(_0x47a5('0xb'));var crypto=require(_0x47a5('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x47a5('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x47a5('0xe'));var authService=require(_0x47a5('0xf'));var qs=require('../../components/parsers/qs');var as=require(_0x47a5('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x47a5('0x11'));var utils=require(_0x47a5('0x12'));var config=require(_0x47a5('0x13'));var licenseUtil=require(_0x47a5('0x14'));var db=require(_0x47a5('0x15'))['db'];config[_0x47a5('0x16')]=_[_0x47a5('0x17')](config['redis'],{'host':_0x47a5('0x18'),'port':0x18eb});var socket=require(_0x47a5('0x19'))(new Redis(config[_0x47a5('0x16')]));require(_0x47a5('0x1a'))[_0x47a5('0x1b')](socket);function respondWithStatusCode(_0x620ee9,_0x3c6c46){_0x3c6c46=_0x3c6c46||0xcc;return function(_0x190faa){if(_0x190faa){return _0x620ee9['sendStatus'](_0x3c6c46);}return _0x620ee9[_0x47a5('0x1c')](_0x3c6c46)[_0x47a5('0x1d')]();};}function respondWithResult(_0x3b001e,_0x2a2cbb){_0x2a2cbb=_0x2a2cbb||0xc8;return function(_0x1ef44c){if(_0x1ef44c){return _0x3b001e['status'](_0x2a2cbb)['json'](_0x1ef44c);}};}function respondWithFilteredResult(_0x138bc0,_0x4b966e){return function(_0x5247fd){if(_0x5247fd){var _0x423a81=_0x5247fd[_0x47a5('0x1e')],_0xaf70a6=_0x4b966e[_0x47a5('0x1f')],_0x2ce454=_0x4b966e[_0x47a5('0x1f')]+_0x4b966e[_0x47a5('0x20')],_0x1ef371;if(_0x2ce454>=_0x423a81){_0x2ce454=_0x423a81;_0x1ef371=0xc8;}else{_0x1ef371=0xce;}_0x138bc0[_0x47a5('0x1c')](_0x1ef371);return _0x138bc0['set'](_0x47a5('0x21'),_0xaf70a6+'-'+_0x2ce454+'/'+_0x423a81)[_0x47a5('0x22')](_0x5247fd);}return null;};}function patchUpdates(_0x47cf3c){return function(_0x2b0360){try{jsonpatch[_0x47a5('0x23')](_0x2b0360,_0x47cf3c,!![]);}catch(_0x36874d){return BPromise['reject'](_0x36874d);}return _0x2b0360[_0x47a5('0x24')]();};}function saveUpdates(_0x2f142b,_0x23db32){return function(_0x7a9f9e){if(_0x7a9f9e){return _0x7a9f9e['update'](_0x2f142b)[_0x47a5('0x25')](function(_0x385687){return _0x385687;});}return null;};}function removeEntity(_0x513981,_0x28747d){return function(_0xc4cd63){if(_0xc4cd63){return _0xc4cd63[_0x47a5('0x26')]()[_0x47a5('0x25')](function(){_0x513981[_0x47a5('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x53078a,_0x136745){return function(_0x5686db){if(!_0x5686db){_0x53078a[_0x47a5('0x27')](0x194);}return _0x5686db;};}function handleError(_0x5b6c4e,_0x23cb77){_0x23cb77=_0x23cb77||0x1f4;return function(_0x378208){logger[_0x47a5('0x28')](_0x378208[_0x47a5('0x29')]);if(_0x378208[_0x47a5('0x2a')]){delete _0x378208[_0x47a5('0x2a')];}_0x5b6c4e[_0x47a5('0x1c')](_0x23cb77)[_0x47a5('0x2b')](_0x378208);};}function getInteractionUsers(_0x16631f,_0x361bfa){return new BPromise(function(_0x1127f8,_0x11a4fa){try{if(_0x361bfa[_0x16631f['id']]){_0x16631f[_0x47a5('0x2c')]=_['map'](_0x361bfa[_0x16631f['id']],function(_0x243210){return{'id':_0x243210['id'],'fullname':_0x243210['fullname']};});}}catch(_0x2ef875){_0x11a4fa(_0x2ef875);}_0x1127f8(_0x16631f);});}function getInteractionTags(_0x9ac908,_0x16901f){return new BPromise(function(_0x4d6b57,_0x256650){try{if(_0x9ac908[_0x47a5('0x2d')]){_0x9ac908[_0x47a5('0x2e')]=[];_0x9ac908[_0x47a5('0x2d')]['split'](',')['forEach'](function(_0x6f9a12){_0x9ac908[_0x47a5('0x2e')]['push'](_0x16901f[_0x6f9a12]);});}delete _0x9ac908['TagIds'];}catch(_0x836303){_0x256650(_0x836303);}_0x4d6b57(_0x9ac908);});}function updateWhatsappInteraction(_0x51544e,_0x57bff6,_0x42f70c){return new BPromise(function(_0x53119b,_0x122ed6){return getInteractionUsers(_0x51544e,_0x42f70c)[_0x47a5('0x25')](function(_0x5c5162){return getInteractionTags(_0x5c5162,_0x57bff6);})['then'](function(_0x274e34){_0x53119b(_0x274e34);})['catch'](function(_0x403028){_0x122ed6(_0x403028);});});}exports[_0x47a5('0x2f')]=function(_0xf269a8,_0x52749b){var _0x18f7e9={},_0x50c086={},_0x53c754={'count':0x0,'rows':[]};var _0x65542e=_['map'](db[_0x47a5('0x30')]['rawAttributes'],function(_0x21ad34){return{'name':_0x21ad34[_0x47a5('0x31')],'type':_0x21ad34[_0x47a5('0x32')][_0x47a5('0x33')]};});_0x50c086[_0x47a5('0x34')]=_[_0x47a5('0x35')](_0x65542e,_0x47a5('0x2a'));_0x50c086[_0x47a5('0x36')]=_[_0x47a5('0x37')](_0xf269a8['query']);_0x50c086[_0x47a5('0x38')]=_[_0x47a5('0x39')](_0x50c086['model'],_0x50c086[_0x47a5('0x36')]);_0x18f7e9[_0x47a5('0x3a')]=_[_0x47a5('0x39')](_0x50c086['model'],qs[_0x47a5('0x3b')](_0xf269a8[_0x47a5('0x36')]['fields']));_0x18f7e9[_0x47a5('0x3a')]=_0x18f7e9[_0x47a5('0x3a')]['length']?_0x18f7e9['attributes']:_0x50c086['model'];if(!_0xf269a8[_0x47a5('0x36')]['hasOwnProperty'](_0x47a5('0x3c'))){_0x18f7e9[_0x47a5('0x20')]=qs[_0x47a5('0x20')](_0xf269a8[_0x47a5('0x36')][_0x47a5('0x20')]);_0x18f7e9[_0x47a5('0x1f')]=qs[_0x47a5('0x1f')](_0xf269a8[_0x47a5('0x36')][_0x47a5('0x1f')]);}_0x18f7e9[_0x47a5('0x3d')]=qs[_0x47a5('0x3e')](_0xf269a8[_0x47a5('0x36')][_0x47a5('0x3e')]);_0x18f7e9['where']=qs[_0x47a5('0x38')](_[_0x47a5('0x3f')](_0xf269a8[_0x47a5('0x36')],_0x50c086[_0x47a5('0x38')]),_0x65542e);var _0x586f4f=[];var _0x7de536=squel['select']()['field']('id')['field']('name')[_0x47a5('0x40')]('color')[_0x47a5('0x41')](_0x47a5('0x42'));var _0x448610=squel['select']()[_0x47a5('0x40')](_0x47a5('0x43'))['field']('u.fullname')[_0x47a5('0x40')]('ui.WhatsappInteractionId')[_0x47a5('0x41')](_0x47a5('0x44'),'ui')[_0x47a5('0x45')](_0x47a5('0x46'),'u',_0x47a5('0x47'));var _0xf0edbb=squel[_0x47a5('0x48')]()[_0x47a5('0x41')](_0x47a5('0x49'),'i')[_0x47a5('0x45')](_0x47a5('0x4a'),'c',_0x47a5('0x4b'))[_0x47a5('0x45')](_0x47a5('0x46'),'o',_0x47a5('0x4c'))[_0x47a5('0x45')]('whatsapp_accounts','a',_0x47a5('0x4d'))[_0x47a5('0x45')]('whatsapp_messages','me','me.WhatsappInteractionId\x20=\x20i.id')[_0x47a5('0x45')]('whatsapp_interaction_has_tags','it',_0x47a5('0x4e'))[_0x47a5('0x45')]('tools_tags','t','t.id\x20=\x20it.TagId');var _0x3d85cc=squel['expr']();var _0x2d147c=[];var _0x1d1039=squel[_0x47a5('0x4f')]();var _0x3e12a7;if(_0xf269a8[_0x47a5('0x36')][_0x47a5('0x50')]){_0x3e12a7=as[_0x47a5('0x51')](_0xf269a8['query']['search']);var _0x2dd1db=_0x3e12a7[_0x47a5('0x52')];for(var _0x1163e3=0x0;_0x1163e3<_0x3e12a7[_0x47a5('0x53')][_0x47a5('0x54')];_0x1163e3++){var _0x2c0c86=_0x3e12a7[_0x47a5('0x53')][_0x1163e3];var _0x492cf7='i';var _0x45cca5=_[_0x47a5('0x55')](_0x65542e,[_0x47a5('0x2a'),_0x2c0c86['field']]);if(!_0x45cca5){switch(_0x2c0c86[_0x47a5('0x40')]){case'unreadMessages':if(_0x2c0c86[_0x47a5('0x56')]==0x1){_0xf0edbb[_0x47a5('0x57')]('`'+_0x2c0c86[_0x47a5('0x40')]+_0x47a5('0x58'));}else{_0xf0edbb['having']('`'+_0x2c0c86[_0x47a5('0x40')]+_0x47a5('0x59'));}break;case _0x47a5('0x5a'):if(_0x2c0c86[_0x47a5('0x5b')]===_0x47a5('0x5c')){if(_0x2c0c86[_0x47a5('0x56')][_0x47a5('0x5d')]('\x20')['length']>0x1){_0x3d85cc[_0x2dd1db](_0x47a5('0x5e'),qs[_0x47a5('0x5f')](_0x2c0c86[_0x47a5('0x56')]),null);}else{var _0x8da9fb='%'+_0x2c0c86[_0x47a5('0x56')]+'%';_0x3d85cc[_0x2dd1db](_0x47a5('0x60'),_0x8da9fb,_0x8da9fb,_0x8da9fb);}}else{_0x45cca5=_['find'](_0x65542e,[_0x47a5('0x2a'),_0x47a5('0x61')]);_0x2c0c86[_0x47a5('0x40')]='ContactId';_0x5eb150=as[_0x47a5('0x62')](_0x492cf7,_0x45cca5[_0x47a5('0x32')],_0x2c0c86);_0x3d85cc[_0x2dd1db](_0x5eb150[_0x47a5('0x63')],_0x5eb150['value']['start'],_0x5eb150[_0x47a5('0x56')][_0x47a5('0x1d')]);}break;case'Tag':var _0x4cf792=_0x2c0c86[_0x47a5('0x56')]['split'](',')[_0x47a5('0x35')](function(_0x5d383d){return Number(_0x5d383d);});_0x4cf792['forEach'](function(_0x389ed9){_0x1d1039['or'](_0x47a5('0x64'),'%,'+_0x389ed9+',%');});_0x2d147c=_['union'](_0x2d147c,_0x4cf792);break;case _0x47a5('0x65'):if(_0x2c0c86[_0x47a5('0x5b')]==='$substring'){_0x3d85cc[_0x2dd1db]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x2c0c86[_0x47a5('0x56')]+'%',null);}else{_0x45cca5=_[_0x47a5('0x55')](_0x65542e,[_0x47a5('0x2a'),_0x47a5('0x66')]);_0x2c0c86['field']=_0x47a5('0x66');_0x5eb150=as[_0x47a5('0x62')](_0x492cf7,_0x45cca5[_0x47a5('0x32')],_0x2c0c86);_0x3d85cc[_0x2dd1db](_0x5eb150['text'],_0x5eb150[_0x47a5('0x56')]['start'],_0x5eb150[_0x47a5('0x56')][_0x47a5('0x1d')]);}break;case _0x47a5('0x67'):_0x5eb150=as[_0x47a5('0x62')]('me',null,_0x2c0c86);_0x3d85cc[_0x2dd1db](_0x5eb150[_0x47a5('0x63')],_0x5eb150['value'][_0x47a5('0x68')],_0x5eb150['value']['end']);break;}}else{var _0x5eb150=as['buildExpression'](_0x492cf7,_0x45cca5[_0x47a5('0x32')],_0x2c0c86);_0x3d85cc[_0x2dd1db](_0x5eb150[_0x47a5('0x63')],_0x5eb150[_0x47a5('0x56')]['start'],_0x5eb150['value'][_0x47a5('0x1d')]);}}}else{var _0x23020b=_(_0xf269a8[_0x47a5('0x36')])[_0x47a5('0x37')]()[_0x47a5('0x35')](function(_0x4b5d0c){return _[_0x47a5('0x69')](_0x65542e,['name',_0x4b5d0c])?_0x4b5d0c:undefined;})[_0x47a5('0x6a')]()[_0x47a5('0x56')]();if(!_['isEmpty'](_0x23020b)){_0x23020b[_0x47a5('0x6b')](function(_0x345104){if(_0x345104===_0x47a5('0x6c')){_0xf0edbb[_0x47a5('0x6d')](_0x47a5('0x6e'),[][_0x47a5('0x6f')](_0xf269a8[_0x47a5('0x36')][_0x345104]));}else if(_0x345104===_0x47a5('0x70')){var _0x57ed0a=JSON[_0x47a5('0x71')](_0xf269a8[_0x47a5('0x36')][_0x345104])[_0x47a5('0x72')];var _0x26e7fc=JSON[_0x47a5('0x71')](_0xf269a8['query'][_0x345104])[_0x47a5('0x73')];_0xf0edbb[_0x47a5('0x6d')](_0x47a5('0x74'),_0x57ed0a,_0x26e7fc);}else{if(_0xf269a8[_0x47a5('0x36')][_0x345104]===_0x47a5('0x75')){_0xf0edbb[_0x47a5('0x6d')]('i.'+_0x345104+_0x47a5('0x76'));}else{_0xf0edbb[_0x47a5('0x6d')]('i.'+_0x345104+_0x47a5('0x77'),_0xf269a8[_0x47a5('0x36')][_0x345104]);}}});}if(_0xf269a8[_0x47a5('0x36')][_0x47a5('0x78')]){if(_0xf269a8[_0x47a5('0x36')][_0x47a5('0x78')]==0x1){_0xf0edbb[_0x47a5('0x57')]('`unreadMessages`\x20=\x200');}else{_0xf0edbb[_0x47a5('0x57')](_0x47a5('0x79'));}}if(_0xf269a8[_0x47a5('0x36')]['tag']){_0x2d147c=_[_0x47a5('0x7a')](_0xf269a8[_0x47a5('0x36')][_0x47a5('0x7b')])?_0xf269a8[_0x47a5('0x36')]['tag']:new Array(_0xf269a8[_0x47a5('0x36')]['tag']);_0x2d147c[_0x47a5('0x6b')](function(_0x487e21){_0x1d1039['or'](_0x47a5('0x64'),'%,'+_0x487e21+',%');});}if(_0xf269a8['query'][_0x47a5('0x7c')]){var _0x2f27c3=_0xf269a8[_0x47a5('0x36')]['filter']['replace']('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs[_0x47a5('0x7d')](_0x2f27c3)){_0x3d85cc['or'](_0x47a5('0x7e'),_0x2f27c3+'%')['or'](_0x47a5('0x7f'),_0x2f27c3+'%');}else{_0x3d85cc['or'](_0x47a5('0x80'),qs['getFullTextValue'](_0x2f27c3))['or'](_0x47a5('0x81'),_0x2f27c3+'%');}}}_0xf0edbb[_0x47a5('0x6d')](_0x3d85cc);_0xf0edbb[_0x47a5('0x82')](_0x47a5('0x83'));var _0x308c9a={'type':db[_0x47a5('0x84')][_0x47a5('0x85')][_0x47a5('0x86')],'raw':!![]};var _0x4618a0=_0xf0edbb[_0x47a5('0x87')]();_0x4618a0[_0x47a5('0x40')](_0x47a5('0x83'));_0x4618a0['field'](_0x47a5('0x88'),'unreadMessages');if(_0x18f7e9[_0x47a5('0x3d')]){_0x18f7e9[_0x47a5('0x3d')][_0x47a5('0x6b')](function(_0x12fec9){var _0x40e584=_0x12fec9[0x0]===_0x47a5('0x89')?_0x12fec9[0x0]:'i.'+_0x12fec9[0x0];_0xf0edbb[_0x47a5('0x3d')](_0x40e584,_0x12fec9[0x1]===_0x47a5('0x8a')?![]:!![]);});}if(!_[_0x47a5('0x8b')](_0x2d147c)){_0xf0edbb[_0x47a5('0x57')](_0x1d1039);_0x4618a0[_0x47a5('0x6d')](_0x47a5('0x8c'),_0x2d147c);}BPromise[_0x47a5('0x8d')]()[_0x47a5('0x25')](function(){if(!_0x3e12a7){if(_0xf269a8[_0x47a5('0x36')]['WhatsappAccountId'])return;_0x4618a0['where']('i.WhatsappAccountId\x20IS\x20NOT\x20NULL');_0xf0edbb['where'](_0x47a5('0x8e'));return;}if(_0xf269a8[_0x47a5('0x8f')]['role']!==_0x47a5('0x90'))return;return _0xf269a8[_0x47a5('0x8f')][_0x47a5('0x91')]({'attributes':['id'],'raw':!![]})[_0x47a5('0x25')](function(_0x3cd335){if(_[_0x47a5('0x8b')](_0x3cd335)){_0x4618a0[_0x47a5('0x6d')](_0x47a5('0x92'));_0xf0edbb[_0x47a5('0x6d')](_0x47a5('0x92'));}else{_0x4618a0[_0x47a5('0x6d')]('i.WhatsappAccountId\x20IN\x20?',_[_0x47a5('0x35')](_0x3cd335,'id'));_0xf0edbb[_0x47a5('0x6d')](_0x47a5('0x6e'),_['map'](_0x3cd335,'id'));}});})[_0x47a5('0x25')](function(){if(_0xf269a8[_0x47a5('0x8f')][_0x47a5('0x93')]==='agent'&&!_0x3e12a7&&!_0xf269a8[_0x47a5('0x36')]['WhatsappAccountId'])return[];return db['sequelize'][_0x47a5('0x36')](_0x4618a0[_0x47a5('0x94')](),_0x308c9a);})[_0x47a5('0x25')](function(_0x27333e){_0x53c754[_0x47a5('0x1e')]=_0x27333e[_0x47a5('0x54')];if(_0x53c754['count']===0x0)return[];return db['sequelize'][_0x47a5('0x36')](_0x7de536['toString'](),_0x308c9a)[_0x47a5('0x25')](function(_0x3fffd1){_0x586f4f=_[_0x47a5('0x95')](_0x3fffd1,'id');_0x308c9a=_[_0x47a5('0x96')](_0x308c9a,{'model':db['WhatsappInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0xf269a8[_0x47a5('0x36')]['fields']){_0x18f7e9['attributes'][_0x47a5('0x6b')](function(_0x391f8e){_0xf0edbb['field']('i.'+_0x391f8e);});}else{_0xf0edbb[_0x47a5('0x40')](_0x47a5('0x88'),_0x47a5('0x97'));_0xf0edbb['field'](_0x47a5('0x98'),'Account.key');_0xf0edbb[_0x47a5('0x40')](_0x47a5('0x99'),_0x47a5('0x9a'));_0xf0edbb['field'](_0x47a5('0x9b'),_0x47a5('0x89'));_0xf0edbb[_0x47a5('0x40')]('i.*');_0xf0edbb[_0x47a5('0x40')]('c.firstName',_0x47a5('0x9c'));_0xf0edbb['field'](_0x47a5('0x9d'),_0x47a5('0x9e'));_0xf0edbb[_0x47a5('0x40')](_0x47a5('0x9f'),'Contact.email');_0xf0edbb[_0x47a5('0x40')](_0x47a5('0xa0'),_0x47a5('0xa1'));_0xf0edbb[_0x47a5('0x40')](_0x47a5('0xa2'),'Contact.mobile');_0xf0edbb['field'](_0x47a5('0xa3'),'Contact.fax');_0xf0edbb[_0x47a5('0x40')](_0x47a5('0xa4'),_0x47a5('0xa5'));_0xf0edbb['field'](_0x47a5('0xa6'),_0x47a5('0xa7'));_0xf0edbb['field'](_0x47a5('0xa8'),_0x47a5('0x2d'));}if(_0x18f7e9[_0x47a5('0x20')])_0xf0edbb[_0x47a5('0x20')](_0x18f7e9['limit']);if(_0x18f7e9['offset'])_0xf0edbb[_0x47a5('0x1f')](_0x18f7e9[_0x47a5('0x1f')]);return db['sequelize'][_0x47a5('0x36')](_0xf0edbb[_0x47a5('0x94')](),_0x308c9a);})['then'](function(_0x309a92){_0x448610[_0x47a5('0x6d')](_0x47a5('0xa9'),_['map'](_0x309a92,'id'));return db[_0x47a5('0xaa')]['query'](_0x448610[_0x47a5('0x94')](),_0x308c9a)['then'](function(_0x243c8b){var _0x3c620e=_['groupBy'](_0x243c8b,_0x47a5('0xab'));var _0x597cb2=[];_0x309a92[_0x47a5('0x6b')](function(_0x36f619){_0x597cb2[_0x47a5('0xac')](updateWhatsappInteraction(_0x36f619,_0x586f4f,_0x3c620e));});return BPromise[_0x47a5('0xad')](_0x597cb2);});});})['then'](function(_0x3eb5c1){_0x53c754['rows']=_0x3eb5c1;return _0x53c754;})['then'](respondWithFilteredResult(_0x52749b,_0x18f7e9))[_0x47a5('0xae')](handleError(_0x52749b,null));};exports[_0x47a5('0xaf')]=function(_0x352238,_0x96fb22){var _0x380c8b={'raw':![],'where':{'id':_0x352238[_0x47a5('0xb0')]['id']}},_0x5b1f5e={};_0x5b1f5e[_0x47a5('0x34')]=_[_0x47a5('0x37')](db[_0x47a5('0x30')]['rawAttributes']);_0x5b1f5e[_0x47a5('0x36')]=_['keys'](_0x352238[_0x47a5('0x36')]);_0x5b1f5e[_0x47a5('0x38')]=_[_0x47a5('0x39')](_0x5b1f5e[_0x47a5('0x34')],_0x5b1f5e[_0x47a5('0x36')]);_0x380c8b[_0x47a5('0x3a')]=_[_0x47a5('0x39')](_0x5b1f5e[_0x47a5('0x34')],qs[_0x47a5('0x3b')](_0x352238['query'][_0x47a5('0x3b')]));_0x380c8b[_0x47a5('0x3a')]=_0x380c8b['attributes'][_0x47a5('0x54')]?_0x380c8b[_0x47a5('0x3a')]:_0x5b1f5e[_0x47a5('0x34')];if(_0x352238['query']['includeAll']){_0x380c8b[_0x47a5('0xb1')]=[{'all':!![]}];}_0x380c8b=_[_0x47a5('0x96')]({},_0x380c8b,_0x352238['options']);return db['WhatsappInteraction'][_0x47a5('0x55')](_0x380c8b)[_0x47a5('0x25')](handleEntityNotFound(_0x96fb22,null))['then'](respondWithResult(_0x96fb22,null))[_0x47a5('0xae')](handleError(_0x96fb22,null));};exports[_0x47a5('0xb2')]=function(_0x4c9e6a,_0x16097e){return db[_0x47a5('0x30')][_0x47a5('0xb2')](_0x4c9e6a[_0x47a5('0x67')],{})[_0x47a5('0x25')](respondWithResult(_0x16097e,0xc9))[_0x47a5('0xae')](handleError(_0x16097e,null));};exports['update']=function(_0x4c9894,_0x5bd86e){if(_0x4c9894[_0x47a5('0x67')]['id']){delete _0x4c9894[_0x47a5('0x67')]['id'];}return db['WhatsappInteraction'][_0x47a5('0x55')]({'where':{'id':_0x4c9894[_0x47a5('0xb0')]['id']}})[_0x47a5('0x25')](handleEntityNotFound(_0x5bd86e,null))[_0x47a5('0x25')](saveUpdates(_0x4c9894[_0x47a5('0x67')],null))['then'](respondWithResult(_0x5bd86e,null))[_0x47a5('0xae')](handleError(_0x5bd86e,null));};exports['destroy']=function(_0x4eb534,_0x5db0ed){return db[_0x47a5('0x30')]['find']({'where':{'id':_0x4eb534[_0x47a5('0xb0')]['id']}})[_0x47a5('0x25')](handleEntityNotFound(_0x5db0ed,null))[_0x47a5('0x25')](removeEntity(_0x5db0ed,null))['catch'](handleError(_0x5db0ed,null));};exports[_0x47a5('0xb3')]=function(_0x461d32,_0x35bf37){return db[_0x47a5('0x30')][_0x47a5('0xb3')]()['then'](respondWithResult(_0x35bf37,null))[_0x47a5('0xae')](handleError(_0x35bf37,null));};exports[_0x47a5('0xb4')]=function(_0x519f0a,_0x42ba59,_0x419870){return db[_0x47a5('0xb5')][_0x47a5('0x55')]({'where':{'id':_0x519f0a[_0x47a5('0xb0')]['id']}})[_0x47a5('0x25')](handleEntityNotFound(_0x42ba59,null))['then'](function(_0x6a8174){if(_0x6a8174){return _0x6a8174[_0x47a5('0xb4')](_0x519f0a['body'][_0x47a5('0xb6')],_[_0x47a5('0xb7')](_0x519f0a[_0x47a5('0x67')],[_0x47a5('0xb6'),'id'])||{});}})['then'](respondWithResult(_0x42ba59,null))['catch'](handleError(_0x42ba59,null));};exports['getMessages']=function(_0x4eee99,_0x1946c6,_0x27793e){var _0x2c5785={'raw':![],'where':{}};var _0x30def7={};var _0x31f896={'count':0x0,'rows':[]};return db[_0x47a5('0x30')][_0x47a5('0xb8')]({'where':{'id':_0x4eee99[_0x47a5('0xb0')]['id']}})['then'](handleEntityNotFound(_0x1946c6,null))[_0x47a5('0x25')](function(_0x24e39a){if(_0x24e39a){_0x30def7[_0x47a5('0x34')]=_[_0x47a5('0x37')](db['WhatsappMessage']['rawAttributes']);_0x30def7[_0x47a5('0x36')]=_['keys'](_0x4eee99['query']);_0x30def7[_0x47a5('0x38')]=_[_0x47a5('0x39')](_0x30def7['model'],_0x30def7[_0x47a5('0x36')]);_0x2c5785[_0x47a5('0x3a')]=_[_0x47a5('0x39')](_0x30def7['model'],qs[_0x47a5('0x3b')](_0x4eee99[_0x47a5('0x36')]['fields']));_0x2c5785[_0x47a5('0x3a')]=_0x2c5785[_0x47a5('0x3a')][_0x47a5('0x54')]?_0x2c5785[_0x47a5('0x3a')]:_0x30def7[_0x47a5('0x34')];if(!_0x4eee99[_0x47a5('0x36')]['hasOwnProperty'](_0x47a5('0x3c'))){_0x2c5785['limit']=qs[_0x47a5('0x20')](_0x4eee99[_0x47a5('0x36')][_0x47a5('0x20')]);_0x2c5785[_0x47a5('0x1f')]=qs['offset'](_0x4eee99[_0x47a5('0x36')][_0x47a5('0x1f')]);}_0x2c5785[_0x47a5('0x3d')]=qs[_0x47a5('0x3e')](_0x4eee99[_0x47a5('0x36')][_0x47a5('0x3e')]);_0x2c5785[_0x47a5('0x6d')]=qs[_0x47a5('0x38')](_[_0x47a5('0x3f')](_0x4eee99[_0x47a5('0x36')],_0x30def7[_0x47a5('0x38')]));_0x2c5785[_0x47a5('0x6d')]['WhatsappInteractionId']=_0x24e39a['id'];if(_0x4eee99[_0x47a5('0x36')][_0x47a5('0x7c')]){_0x2c5785['where']=_[_0x47a5('0x96')](_0x2c5785[_0x47a5('0x6d')],{'$or':_[_0x47a5('0x35')](_0x2c5785[_0x47a5('0x3a')],function(_0x2ff467){var _0x58fac0={};_0x58fac0[_0x2ff467]={'$like':'%'+_0x4eee99[_0x47a5('0x36')][_0x47a5('0x7c')]+'%'};return _0x58fac0;})});}if(_0x4eee99[_0x47a5('0x36')][_0x47a5('0x72')]){var _0x343214=_0x4eee99[_0x47a5('0x36')][_0x47a5('0x72')]['split'](',');var _0x596562={};_0x596562[_0x343214[0x0]]={'$gte':moment(_0x343214[0x1])[_0x47a5('0xb9')]('YYYY-MM-DD\x20HH:mm:ss')};_0x2c5785[_0x47a5('0x6d')]=_['merge'](_0x2c5785[_0x47a5('0x6d')],_0x596562);}_0x2c5785=_[_0x47a5('0x96')]({},_0x2c5785,_0x4eee99[_0x47a5('0xba')]);return db[_0x47a5('0xb5')]['count']({'where':_0x2c5785[_0x47a5('0x6d')]})[_0x47a5('0x25')](function(_0xaca12c){_0x31f896['count']=_0xaca12c;if(_0x4eee99['query'][_0x47a5('0xbb')]){_0x2c5785[_0x47a5('0xb1')]=[{'all':!![]}];}return db[_0x47a5('0xb5')][_0x47a5('0xbc')](_0x2c5785);})[_0x47a5('0x25')](function(_0x402bba){_0x31f896[_0x47a5('0xbd')]=_0x402bba;return _0x31f896;});}})[_0x47a5('0x25')](respondWithFilteredResult(_0x1946c6,_0x2c5785))['catch'](handleError(_0x1946c6,null));};exports[_0x47a5('0xbe')]=function(_0x4d333b,_0x346322,_0xc3b5e1){return db['WhatsappInteraction']['find']({'where':{'id':_0x4d333b[_0x47a5('0xb0')]['id']}})[_0x47a5('0x25')](handleEntityNotFound(_0x346322,null))['then'](function(_0x4420fa){if(_0x4420fa){return _0x4420fa[_0x47a5('0xbf')](_0x4d333b[_0x47a5('0x67')][_0x47a5('0xb6')],_['omit'](_0x4d333b[_0x47a5('0x67')],['ids','id'])||{})['spread'](function(){return db['Tag'][_0x47a5('0xbc')]({'attributes':['id','name',_0x47a5('0xc0')],'where':{'id':_0x4d333b[_0x47a5('0x67')][_0x47a5('0xb6')]}});})[_0x47a5('0x25')](function(_0x267d40){socket[_0x47a5('0xc1')](_0x47a5('0xc2'),{'id':Number(_0x4d333b[_0x47a5('0xb0')]['id']),'tags':_0x267d40||[]});return{'id':Number(_0x4d333b[_0x47a5('0xb0')]['id']),'tags':_0x267d40||[]};});}})[_0x47a5('0x25')](respondWithResult(_0x346322,null))[_0x47a5('0xae')](handleError(_0x346322,null));};exports[_0x47a5('0xc3')]=function(_0x328faa,_0x1bfa3b,_0xff64fb){return db['WhatsappInteraction'][_0x47a5('0x55')]({'where':{'id':_0x328faa[_0x47a5('0xb0')]['id']}})[_0x47a5('0x25')](handleEntityNotFound(_0x1bfa3b,null))[_0x47a5('0x25')](function(_0x515580){if(_0x515580){return _0x515580[_0x47a5('0xc3')](_0x328faa['query'][_0x47a5('0xb6')]);}})['then'](respondWithStatusCode(_0x1bfa3b,null))[_0x47a5('0xae')](handleError(_0x1bfa3b,null));};exports[_0x47a5('0xc4')]=function(_0x3b894d,_0x5c20aa){var _0x35f735=moment()[_0x47a5('0xc5')]()[_0x47a5('0x94')]();var _0x4ac804=path['join'](config[_0x47a5('0xc6')],_0x47a5('0xc7'),_0x47a5('0xc8'),_0x47a5('0xc9'));var _0x204bd6=path['join'](config[_0x47a5('0xc6')],'server',_0x47a5('0xc8'),_0x47a5('0xca'));var _0x46647f=path[_0x47a5('0xcb')](_0x4ac804,_0x35f735);var _0x5b18a2=util['format'](_0x47a5('0xcc'),_0x3b894d[_0x47a5('0xb0')]['id'],_0x35f735);var _0x291383=path[_0x47a5('0xcb')](_0x4ac804,_0x5b18a2);var _0x259088=[];_0x259088[_0x47a5('0xac')]({'model':db[_0x47a5('0x65')],'as':_0x47a5('0x65'),'attributes':['id',_0x47a5('0xcd')],'raw':!![]});_0x259088['push']({'model':db['CmContact'],'as':_0x47a5('0x5a'),'attributes':['id','firstName',_0x47a5('0xce')],'raw':!![]});if(_0x3b894d[_0x47a5('0x36')][_0x47a5('0xca')]){_0x259088['push']({'model':db[_0x47a5('0xcf')],'as':_0x47a5('0xcf'),'raw':!![]});}var _0x4842c5=[{'model':db[_0x47a5('0xb5')],'as':'Messages','attributes':['id',_0x47a5('0x67'),_0x47a5('0x70'),_0x47a5('0xd0'),'secret','read'],'include':_0x259088}];_0x4842c5['push']({'model':db['WhatsappAccount'],'as':'Account','attributes':['id',_0x47a5('0x2a')]});_0x4842c5['push']({'model':db[_0x47a5('0x65')],'as':_0x47a5('0xd1'),'attributes':['id','fullname']});return db['WhatsappInteraction']['find']({'where':{'id':_0x3b894d[_0x47a5('0xb0')]['id']},'include':_0x4842c5})['then'](handleEntityNotFound(_0x5c20aa,null))['then'](function(_0x5d17dc){if(_0x5d17dc){var _0x45947c=_0x5d17dc[_0x47a5('0xd2')]({'plain':!![]});fs[_0x47a5('0xd3')](_0x46647f);var _0xdb9128={'format':'A4','border':'10px','header':{'height':_0x47a5('0xd4'),'contents':{'first':'<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>'}},'footer':{'height':_0x47a5('0xd5'),'contents':{'default':util['format'](_0x47a5('0xd6'),util[_0x47a5('0xb9')](_0x47a5('0xd7'),'Whatsapp',_0x45947c['id']),moment()[_0x47a5('0xb9')](_0x47a5('0xd8'))[_0x47a5('0x94')]())}}};var _0x31100e={'channel':'Whatsapp','account':_0x45947c[_0x47a5('0xd9')][_0x47a5('0x2a')],'agent':_0x45947c[_0x47a5('0xd1')]?_0x45947c[_0x47a5('0xd1')][_0x47a5('0xcd')]:_0x47a5('0xda'),'createdAt':moment(_0x45947c['createdAt'])[_0x47a5('0xb9')](_0x47a5('0xdb'))[_0x47a5('0x94')](),'closedAt':_0x45947c[_0x47a5('0xdc')]?moment(_0x45947c[_0x47a5('0xdd')])[_0x47a5('0xb9')](_0x47a5('0xdb'))[_0x47a5('0x94')]():'','disposition':_0x45947c[_0x47a5('0xde')],'messages':_(_0x45947c[_0x47a5('0xdf')])[_0x47a5('0x7c')]({'secret':![]})[_0x47a5('0x35')](function(_0x40dab1){if(_0x40dab1[_0x47a5('0xcf')]){var _0x29b926=path[_0x47a5('0xcb')](_0x204bd6,_0x40dab1[_0x47a5('0xcf')]['basename']);if(fs[_0x47a5('0xe0')](_0x29b926)){fs['createReadStream'](_0x29b926)['pipe'](fs[_0x47a5('0xe1')](path[_0x47a5('0xcb')](_0x46647f,_0x40dab1[_0x47a5('0xcf')]['basename'])));}}return{'date':moment(_0x40dab1[_0x47a5('0x70')])[_0x47a5('0xb9')](_0x47a5('0xdb'))[_0x47a5('0x94')](),'sender':_0x40dab1[_0x47a5('0xd0')]===_0x47a5('0xe2')?_0x40dab1[_0x47a5('0x65')]?_0x40dab1[_0x47a5('0x65')][_0x47a5('0xcd')]:_0x47a5('0xe3'):_0x40dab1[_0x47a5('0x5a')][_0x47a5('0xe4')]+(_0x40dab1[_0x47a5('0x5a')]['lastName']?'\x20'+_0x40dab1['Contact'][_0x47a5('0xce')]:''),'body':_0x40dab1['Attachment']?_0x40dab1[_0x47a5('0xcf')][_0x47a5('0xe5')]:_0x40dab1[_0x47a5('0x67')],'direction':_0x40dab1[_0x47a5('0xd0')]===_0x47a5('0xe2')?'A':'C','secret':_0x40dab1[_0x47a5('0xe6')],'read':_0x40dab1['read'],'attachment':_0x40dab1[_0x47a5('0xcf')]};})[_0x47a5('0x56')]()};return ejs[_0x47a5('0xe7')](path['join'](config[_0x47a5('0xc6')],_0x47a5('0xc7'),_0x47a5('0xe8'),_0x47a5('0xe9')),{'interaction':_0x31100e})[_0x47a5('0x25')](function(_0x23e649){return new BPromise(function(_0x35e20f,_0x46615a){pdf[_0x47a5('0xb2')](_0x23e649,_0xdb9128)[_0x47a5('0xea')](path[_0x47a5('0xcb')](_0x46647f,_0x47a5('0xeb')+_0x45947c['id']+'-'+_0x35f735+_0x47a5('0xec')),function(_0x2ac386,_0x578983){if(_0x2ac386)return _0x46615a(_0x2ac386);_0x35e20f(_0x578983);});});})[_0x47a5('0x25')](function(){return new BPromise(function(_0x272cd0,_0x150cff){zipdir(_0x46647f,{'saveTo':_0x291383},function(_0x2ee27c,_0x25ce6b){if(_0x2ee27c)return _0x150cff(_0x2ee27c);return _0x272cd0(_0x25ce6b);});})[_0x47a5('0x25')](function(){return new BPromise(function(_0x29ef50,_0x49692d){rimraf(_0x46647f,function(_0x185104){if(_0x185104)_0x49692d(_0x185104);return _0x29ef50();});});})['then'](function(){return _0x5c20aa[_0x47a5('0xc4')](_0x291383,_0x5b18a2,function(_0xf465a8){if(_0xf465a8){console[_0x47a5('0xed')](_0x47a5('0xee'),_0xf465a8);}else{fs[_0x47a5('0xef')](_0x291383);}});});});}else{return _0x5c20aa[_0x47a5('0x27')](0xc8);}})[_0x47a5('0xae')](handleError(_0x5c20aa,null));};
\ No newline at end of file
+var _0x6ab9=['whatsapp_interactions','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','whatsapp_accounts','a.id\x20=\x20i.WhatsappAccountId','whatsapp_messages','whatsapp_interaction_has_tags','it.WhatsappInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','find','unreadMessages','value','having','`\x20=\x200','`\x20>\x200','$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','Tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','operator','start','body','some','compact','WhatsappAccountId','where','concat','parse','$gte','$lte','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','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','Sequelize','clone','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','order','contactName','DESC','isEmpty','t.id\x20IN\x20?','resolve','i.WhatsappAccountId\x20IS\x20NOT\x20NULL','role','agent','user','i.WhatsappAccountId\x20IS\x20NULL','i.WhatsappAccountId\x20IN\x20?','toString','sequelize','keyBy','WhatsappInteraction','a.key','Account.key','a.mandatoryDisposition','CASE\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','c.fax','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','ui.WhatsappInteractionId\x20IN\x20?','groupBy','WhatsappInteractionId','push','rows','catch','show','params','rawAttributes','includeAll','include','merge','options','describe','addMessage','WhatsappMessage','ids','getMessages','findOne','format','findAll','addTags','omit','spread','color','emit','whatsappInteractionTags:save','removeTags','download','unix','join','root','tmp','server','attachments','transcript-%d-%s.zip','CmContact','Contact','lastName','Attachment','createdAt','direction','WhatsappAccount','Account','Owner','get','mkdirSync','Whatsapp','N.A.','YYYY-MM-DD\x20HH:mm:ss','closedAt','disposition','Messages','basename','existsSync','createReadStream','pipe','createWriteStream','out','firstName','secret','renderFile','views','transcript-','createPdfFromHTML','log','err','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../components/export/pdf','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./whatsappInteraction.socket','register','status','end','offset','undefined','limit','count','Content-Range','apply','save','update','then','destroy','sendStatus','error','stack','name','send','Users','map','fullname','Tags','TagIds','split','forEach','waiting','talking','answered','unmanaged','closed','UserId','total','index','fieldName','type','key','model','keys','intersection','attributes','fields','query','hasOwnProperty','nolimit','sort','filters','pick','field','from','tools_tags','u.id','u.fullname','ui.WhatsappInteractionId','user_has_whatsapp_interactions','left_join','users','select'];(function(_0x4855ce,_0x3fbf65){var _0x150377=function(_0x21555b){while(--_0x21555b){_0x4855ce['push'](_0x4855ce['shift']());}};_0x150377(++_0x3fbf65);}(_0x6ab9,0x19a));var _0x96ab=function(_0xda464c,_0x26e47d){_0xda464c=_0xda464c-0x0;var _0x19e222=_0x6ab9[_0xda464c];return _0x19e222;};'use strict';var emlformat=require(_0x96ab('0x0'));var rimraf=require(_0x96ab('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x96ab('0x2'));var rp=require(_0x96ab('0x3'));var moment=require(_0x96ab('0x4'));var BPromise=require(_0x96ab('0x5'));var Mustache=require(_0x96ab('0x6'));var util=require('util');var path=require('path');var sox=require(_0x96ab('0x7'));var csv=require(_0x96ab('0x8'));var ejs=require(_0x96ab('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x96ab('0xa'));var squel=require(_0x96ab('0xb'));var crypto=require('crypto');var jsforce=require(_0x96ab('0xc'));var deskjs=require(_0x96ab('0xd'));var toCsv=require(_0x96ab('0x8'));var querystring=require(_0x96ab('0xe'));var Papa=require(_0x96ab('0xf'));var Redis=require(_0x96ab('0x10'));var authService=require(_0x96ab('0x11'));var qs=require(_0x96ab('0x12'));var as=require(_0x96ab('0x13'));var pdf=require(_0x96ab('0x14'));var hardwareService=require(_0x96ab('0x15'));var logger=require(_0x96ab('0x16'))(_0x96ab('0x17'));var utils=require('../../config/utils');var config=require(_0x96ab('0x18'));var licenseUtil=require('../../config/license/util');var db=require(_0x96ab('0x19'))['db'];config[_0x96ab('0x1a')]=_[_0x96ab('0x1b')](config[_0x96ab('0x1a')],{'host':_0x96ab('0x1c'),'port':0x18eb});var socket=require(_0x96ab('0x1d'))(new Redis(config[_0x96ab('0x1a')]));require(_0x96ab('0x1e'))[_0x96ab('0x1f')](socket);function respondWithStatusCode(_0x3fb987,_0xba0d5e){_0xba0d5e=_0xba0d5e||0xcc;return function(_0x4df67b){if(_0x4df67b){return _0x3fb987['sendStatus'](_0xba0d5e);}return _0x3fb987[_0x96ab('0x20')](_0xba0d5e)[_0x96ab('0x21')]();};}function respondWithResult(_0x3843bc,_0x57237a){_0x57237a=_0x57237a||0xc8;return function(_0x43e35e){if(_0x43e35e){return _0x3843bc[_0x96ab('0x20')](_0x57237a)['json'](_0x43e35e);}};}function respondWithFilteredResult(_0x20c685,_0x4eca78){return function(_0x231ed5){if(_0x231ed5){var _0x1a502a=typeof _0x4eca78[_0x96ab('0x22')]===_0x96ab('0x23')&&typeof _0x4eca78[_0x96ab('0x24')]===_0x96ab('0x23');var _0x154fec=_0x231ed5[_0x96ab('0x25')];var _0xb746c7=_0x1a502a?0x0:_0x4eca78[_0x96ab('0x22')];var _0x2aa3c4=_0x1a502a?_0x231ed5['count']:_0x4eca78['offset']+_0x4eca78[_0x96ab('0x24')];var _0x166a78;if(_0x2aa3c4>=_0x154fec){_0x2aa3c4=_0x154fec;_0x166a78=0xc8;}else{_0x166a78=0xce;}_0x20c685[_0x96ab('0x20')](_0x166a78);return _0x20c685['set'](_0x96ab('0x26'),_0xb746c7+'-'+_0x2aa3c4+'/'+_0x154fec)['json'](_0x231ed5);}return null;};}function patchUpdates(_0xb05aa4){return function(_0x567bf1){try{jsonpatch[_0x96ab('0x27')](_0x567bf1,_0xb05aa4,!![]);}catch(_0x90fa22){return BPromise['reject'](_0x90fa22);}return _0x567bf1[_0x96ab('0x28')]();};}function saveUpdates(_0x84a7f7,_0x4475b6){return function(_0x42d20c){if(_0x42d20c){return _0x42d20c[_0x96ab('0x29')](_0x84a7f7)[_0x96ab('0x2a')](function(_0x9cb9b6){return _0x9cb9b6;});}return null;};}function removeEntity(_0x2837a7,_0x218a4c){return function(_0x53869e){if(_0x53869e){return _0x53869e[_0x96ab('0x2b')]()['then'](function(){_0x2837a7[_0x96ab('0x20')](0xcc)[_0x96ab('0x21')]();});}};}function handleEntityNotFound(_0x284156,_0x240553){return function(_0x1dd9f4){if(!_0x1dd9f4){_0x284156[_0x96ab('0x2c')](0x194);}return _0x1dd9f4;};}function handleError(_0x31568f,_0x435613){_0x435613=_0x435613||0x1f4;return function(_0x4f954c){logger[_0x96ab('0x2d')](_0x4f954c[_0x96ab('0x2e')]);if(_0x4f954c[_0x96ab('0x2f')]){delete _0x4f954c['name'];}_0x31568f[_0x96ab('0x20')](_0x435613)[_0x96ab('0x30')](_0x4f954c);};}function getInteractionUsers(_0x14469c,_0x575664){return new BPromise(function(_0xaccba6,_0x4c9a55){try{if(_0x575664[_0x14469c['id']]){_0x14469c[_0x96ab('0x31')]=_[_0x96ab('0x32')](_0x575664[_0x14469c['id']],function(_0x5520d4){return{'id':_0x5520d4['id'],'fullname':_0x5520d4[_0x96ab('0x33')]};});}}catch(_0x4f784b){_0x4c9a55(_0x4f784b);}_0xaccba6(_0x14469c);});}function getInteractionTags(_0x47c1c2,_0x5bb4b2){return new BPromise(function(_0x59d75f,_0xc25ca9){try{if(_0x47c1c2['TagIds']){_0x47c1c2[_0x96ab('0x34')]=[];_0x47c1c2[_0x96ab('0x35')][_0x96ab('0x36')](',')[_0x96ab('0x37')](function(_0x12a8a3){_0x47c1c2['Tags']['push'](_0x5bb4b2[_0x12a8a3]);});}delete _0x47c1c2[_0x96ab('0x35')];}catch(_0xa5a459){_0xc25ca9(_0xa5a459);}_0x59d75f(_0x47c1c2);});}function updateWhatsappInteraction(_0x56e3e2,_0x358c23,_0x32ccba){return new BPromise(function(_0x5d8485,_0x5e463c){return getInteractionUsers(_0x56e3e2,_0x32ccba)[_0x96ab('0x2a')](function(_0x39f56d){return getInteractionTags(_0x39f56d,_0x358c23);})[_0x96ab('0x2a')](function(_0x270d80){return getStateInteraction(_0x270d80);})['then'](function(_0x182074){_0x5d8485(_0x182074);})['catch'](function(_0x5e9020){_0x5e463c(_0x5e9020);});});}function getStateInteraction(_0x304382){return new BPromise(function(_0x4c2427){_0x304382[_0x96ab('0x38')]=0x0;_0x304382[_0x96ab('0x39')]=0x0;_0x304382[_0x96ab('0x3a')]=0x0;_0x304382[_0x96ab('0x3b')]=0x0;_0x304382['total']=0x0;if(!_0x304382[_0x96ab('0x3c')]&&!_0x304382[_0x96ab('0x3d')]){_0x304382[_0x96ab('0x38')]+=0x1;}if(!_0x304382[_0x96ab('0x3c')]&&_0x304382[_0x96ab('0x3d')]){_0x304382['talking']+=0x1;if(_0x304382[_0x96ab('0x38')]){_0x304382['waiting']-=0x1;}}if(_0x304382[_0x96ab('0x3c')]&&_0x304382['UserId']){_0x304382[_0x96ab('0x3a')]+=0x1;if(_0x304382[_0x96ab('0x39')]){_0x304382[_0x96ab('0x39')]-=0x1;}}if(_0x304382[_0x96ab('0x3c')]&&!_0x304382['UserId']){_0x304382[_0x96ab('0x3b')]+=0x1;if(_0x304382[_0x96ab('0x38')]){_0x304382[_0x96ab('0x38')]-=0x1;}}_0x304382[_0x96ab('0x3e')]+=0x1;_0x4c2427(_0x304382);});}exports[_0x96ab('0x3f')]=function(_0x38de47,_0x9e833){var _0x149078={},_0x14bcbf={},_0x1df03b={'count':0x0,'rows':[]};var _0x396a32=_[_0x96ab('0x32')](db['WhatsappInteraction']['rawAttributes'],function(_0x29ac73){return{'name':_0x29ac73[_0x96ab('0x40')],'type':_0x29ac73[_0x96ab('0x41')][_0x96ab('0x42')]};});_0x14bcbf[_0x96ab('0x43')]=_[_0x96ab('0x32')](_0x396a32,_0x96ab('0x2f'));_0x14bcbf['query']=_[_0x96ab('0x44')](_0x38de47['query']);_0x14bcbf['filters']=_[_0x96ab('0x45')](_0x14bcbf[_0x96ab('0x43')],_0x14bcbf['query']);_0x149078[_0x96ab('0x46')]=_[_0x96ab('0x45')](_0x14bcbf[_0x96ab('0x43')],qs[_0x96ab('0x47')](_0x38de47[_0x96ab('0x48')]['fields']));_0x149078[_0x96ab('0x46')]=_0x149078['attributes']['length']?_0x149078[_0x96ab('0x46')]:_0x14bcbf['model'];if(!_0x38de47[_0x96ab('0x48')][_0x96ab('0x49')](_0x96ab('0x4a'))){_0x149078['limit']=qs[_0x96ab('0x24')](_0x38de47[_0x96ab('0x48')][_0x96ab('0x24')]);_0x149078[_0x96ab('0x22')]=qs[_0x96ab('0x22')](_0x38de47['query'][_0x96ab('0x22')]);}_0x149078['order']=qs[_0x96ab('0x4b')](_0x38de47['query'][_0x96ab('0x4b')]);_0x149078['where']=qs[_0x96ab('0x4c')](_[_0x96ab('0x4d')](_0x38de47[_0x96ab('0x48')],_0x14bcbf[_0x96ab('0x4c')]),_0x396a32);var _0x25d387=[];var _0x42dbd7=squel['select']()[_0x96ab('0x4e')]('id')[_0x96ab('0x4e')]('name')[_0x96ab('0x4e')]('color')[_0x96ab('0x4f')](_0x96ab('0x50'));var _0xa07b16=squel['select']()[_0x96ab('0x4e')](_0x96ab('0x51'))['field'](_0x96ab('0x52'))[_0x96ab('0x4e')](_0x96ab('0x53'))[_0x96ab('0x4f')](_0x96ab('0x54'),'ui')[_0x96ab('0x55')](_0x96ab('0x56'),'u','u.id\x20=\x20ui.UserId');var _0x3fe014=squel[_0x96ab('0x57')]()['from'](_0x96ab('0x58'),'i')[_0x96ab('0x55')]('cm_contacts','c',_0x96ab('0x59'))[_0x96ab('0x55')](_0x96ab('0x56'),'o',_0x96ab('0x5a'))[_0x96ab('0x55')](_0x96ab('0x5b'),'a',_0x96ab('0x5c'))[_0x96ab('0x55')](_0x96ab('0x5d'),'me','me.WhatsappInteractionId\x20=\x20i.id')[_0x96ab('0x55')](_0x96ab('0x5e'),'it',_0x96ab('0x5f'))[_0x96ab('0x55')](_0x96ab('0x50'),'t',_0x96ab('0x60'));var _0x1f1a28=squel[_0x96ab('0x61')]();var _0x247b72=[];var _0x1a1bd7=squel['expr']();var _0x539bb6;if(_0x38de47[_0x96ab('0x48')][_0x96ab('0x62')]){_0x539bb6=as[_0x96ab('0x63')](_0x38de47['query'][_0x96ab('0x62')]);var _0x3367cb=_0x539bb6[_0x96ab('0x64')];for(var _0x4ae4eb=0x0;_0x4ae4eb<_0x539bb6['conditions']['length'];_0x4ae4eb++){var _0x48580a=_0x539bb6[_0x96ab('0x65')][_0x4ae4eb];var _0x2f7582='i';var _0x377909=_[_0x96ab('0x66')](_0x396a32,[_0x96ab('0x2f'),_0x48580a['field']]);if(!_0x377909){switch(_0x48580a[_0x96ab('0x4e')]){case _0x96ab('0x67'):if(_0x48580a[_0x96ab('0x68')]==0x1){_0x3fe014[_0x96ab('0x69')]('`'+_0x48580a[_0x96ab('0x4e')]+_0x96ab('0x6a'));}else{_0x3fe014[_0x96ab('0x69')]('`'+_0x48580a[_0x96ab('0x4e')]+_0x96ab('0x6b'));}break;case'Contact':if(_0x48580a['operator']===_0x96ab('0x6c')){if(_0x48580a[_0x96ab('0x68')]['split']('\x20')[_0x96ab('0x6d')]>0x1){_0x1f1a28[_0x3367cb](_0x96ab('0x6e'),qs[_0x96ab('0x6f')](_0x48580a[_0x96ab('0x68')]),null);}else{var _0x160604='%'+_0x48580a[_0x96ab('0x68')]+'%';_0x1f1a28[_0x3367cb](_0x96ab('0x70'),_0x160604,_0x160604,_0x160604);}}else{_0x377909=_[_0x96ab('0x66')](_0x396a32,[_0x96ab('0x2f'),'ContactId']);_0x48580a[_0x96ab('0x4e')]=_0x96ab('0x71');_0x189061=as[_0x96ab('0x72')](_0x2f7582,_0x377909[_0x96ab('0x41')],_0x48580a);_0x1f1a28[_0x3367cb](_0x189061[_0x96ab('0x73')],_0x189061[_0x96ab('0x68')]['start'],_0x189061[_0x96ab('0x68')][_0x96ab('0x21')]);}break;case _0x96ab('0x74'):var _0x15a21c=_0x48580a[_0x96ab('0x68')][_0x96ab('0x36')](',')['map'](function(_0x1d959d){return Number(_0x1d959d);});_0x15a21c[_0x96ab('0x37')](function(_0x28a975){_0x1a1bd7['or'](_0x96ab('0x75'),'%,'+_0x28a975+',%');});_0x247b72=_[_0x96ab('0x76')](_0x247b72,_0x15a21c);break;case _0x96ab('0x77'):if(_0x48580a[_0x96ab('0x78')]===_0x96ab('0x6c')){_0x1f1a28[_0x3367cb]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x48580a[_0x96ab('0x68')]+'%',null);}else{_0x377909=_['find'](_0x396a32,[_0x96ab('0x2f'),'UserId']);_0x48580a[_0x96ab('0x4e')]=_0x96ab('0x3d');_0x189061=as[_0x96ab('0x72')](_0x2f7582,_0x377909['type'],_0x48580a);_0x1f1a28[_0x3367cb](_0x189061['text'],_0x189061['value'][_0x96ab('0x79')],_0x189061[_0x96ab('0x68')]['end']);}break;case _0x96ab('0x7a'):_0x189061=as[_0x96ab('0x72')]('me',null,_0x48580a);_0x1f1a28[_0x3367cb](_0x189061['text'],_0x189061['value'][_0x96ab('0x79')],_0x189061[_0x96ab('0x68')][_0x96ab('0x21')]);break;}}else{var _0x189061=as[_0x96ab('0x72')](_0x2f7582,_0x377909['type'],_0x48580a);_0x1f1a28[_0x3367cb](_0x189061['text'],_0x189061[_0x96ab('0x68')][_0x96ab('0x79')],_0x189061[_0x96ab('0x68')][_0x96ab('0x21')]);}}}else{var _0x5d6993=_(_0x38de47[_0x96ab('0x48')])[_0x96ab('0x44')]()[_0x96ab('0x32')](function(_0xabfcc2){return _[_0x96ab('0x7b')](_0x396a32,[_0x96ab('0x2f'),_0xabfcc2])?_0xabfcc2:undefined;})[_0x96ab('0x7c')]()[_0x96ab('0x68')]();if(!_['isEmpty'](_0x5d6993)){_0x5d6993[_0x96ab('0x37')](function(_0x335f1b){if(_0x335f1b===_0x96ab('0x7d')){_0x3fe014[_0x96ab('0x7e')]('i.WhatsappAccountId\x20IN\x20?',[][_0x96ab('0x7f')](_0x38de47['query'][_0x335f1b]));}else if(_0x335f1b==='createdAt'){var _0x4bd111=JSON[_0x96ab('0x80')](_0x38de47['query'][_0x335f1b])[_0x96ab('0x81')];var _0x561a97=JSON['parse'](_0x38de47[_0x96ab('0x48')][_0x335f1b])[_0x96ab('0x82')];_0x3fe014['where']('i.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x4bd111,_0x561a97);}else{if(_0x38de47[_0x96ab('0x48')][_0x335f1b]==='null'){_0x3fe014[_0x96ab('0x7e')]('i.'+_0x335f1b+_0x96ab('0x83'));}else{_0x3fe014[_0x96ab('0x7e')]('i.'+_0x335f1b+_0x96ab('0x84'),_0x38de47[_0x96ab('0x48')][_0x335f1b]);}}});}if(_0x38de47[_0x96ab('0x48')][_0x96ab('0x85')]){if(_0x38de47['query'][_0x96ab('0x85')]==0x1){_0x3fe014[_0x96ab('0x69')](_0x96ab('0x86'));}else{_0x3fe014['having'](_0x96ab('0x87'));}}if(_0x38de47['query']['tag']){_0x247b72=_['isArray'](_0x38de47[_0x96ab('0x48')][_0x96ab('0x88')])?_0x38de47[_0x96ab('0x48')][_0x96ab('0x88')]:new Array(_0x38de47['query'][_0x96ab('0x88')]);_0x247b72['forEach'](function(_0x46b27d){_0x1a1bd7['or'](_0x96ab('0x75'),'%,'+_0x46b27d+',%');});}if(_0x38de47[_0x96ab('0x48')][_0x96ab('0x89')]){var _0x2484ca=_0x38de47[_0x96ab('0x48')][_0x96ab('0x89')][_0x96ab('0x8a')]('\x5c','\x5c\x5c')[_0x96ab('0x8a')](/'/g,'\x27\x27');if(qs[_0x96ab('0x8b')](_0x2484ca)){_0x1f1a28['or']('i.id\x20LIKE\x20?',_0x2484ca+'%')['or'](_0x96ab('0x8c'),_0x2484ca+'%');}else{_0x1f1a28['or'](_0x96ab('0x8d'),qs[_0x96ab('0x6f')](_0x2484ca))['or'](_0x96ab('0x8e'),_0x2484ca+'%');}}}_0x3fe014[_0x96ab('0x7e')](_0x1f1a28);_0x3fe014[_0x96ab('0x8f')](_0x96ab('0x90'));var _0x3ea5fd={'type':db[_0x96ab('0x91')]['QueryTypes']['SELECT'],'raw':!![]};var _0x51aab9=_0x3fe014[_0x96ab('0x92')]();_0x51aab9[_0x96ab('0x4e')]('i.id');_0x51aab9['field'](_0x96ab('0x93'),_0x96ab('0x67'));if(_0x149078[_0x96ab('0x94')]){_0x149078[_0x96ab('0x94')][_0x96ab('0x37')](function(_0x2bf435){var _0x544667=_0x2bf435[0x0]===_0x96ab('0x95')?_0x2bf435[0x0]:'i.'+_0x2bf435[0x0];_0x3fe014[_0x96ab('0x94')](_0x544667,_0x2bf435[0x1]===_0x96ab('0x96')?![]:!![]);});}if(!_[_0x96ab('0x97')](_0x247b72)){_0x3fe014[_0x96ab('0x69')](_0x1a1bd7);_0x51aab9[_0x96ab('0x7e')](_0x96ab('0x98'),_0x247b72);}BPromise[_0x96ab('0x99')]()[_0x96ab('0x2a')](function(){if(!_0x539bb6){if(_0x38de47[_0x96ab('0x48')][_0x96ab('0x7d')])return;_0x51aab9[_0x96ab('0x7e')](_0x96ab('0x9a'));_0x3fe014[_0x96ab('0x7e')](_0x96ab('0x9a'));return;}if(_0x38de47['user'][_0x96ab('0x9b')]!==_0x96ab('0x9c'))return;return _0x38de47[_0x96ab('0x9d')]['getWhatsappAccounts']({'attributes':['id'],'raw':!![]})[_0x96ab('0x2a')](function(_0x5136c3){if(_[_0x96ab('0x97')](_0x5136c3)){_0x51aab9[_0x96ab('0x7e')](_0x96ab('0x9e'));_0x3fe014[_0x96ab('0x7e')](_0x96ab('0x9e'));}else{_0x51aab9['where'](_0x96ab('0x9f'),_[_0x96ab('0x32')](_0x5136c3,'id'));_0x3fe014['where'](_0x96ab('0x9f'),_[_0x96ab('0x32')](_0x5136c3,'id'));}});})[_0x96ab('0x2a')](function(){if(_0x38de47[_0x96ab('0x9d')]['role']===_0x96ab('0x9c')&&!_0x539bb6&&!_0x38de47[_0x96ab('0x48')][_0x96ab('0x7d')])return[];return db['sequelize']['query'](_0x51aab9[_0x96ab('0xa0')](),_0x3ea5fd);})[_0x96ab('0x2a')](function(_0x51e83e){_0x1df03b[_0x96ab('0x25')]=_0x51e83e[_0x96ab('0x6d')];if(_0x1df03b['count']===0x0)return[];return db[_0x96ab('0xa1')]['query'](_0x42dbd7[_0x96ab('0xa0')](),_0x3ea5fd)[_0x96ab('0x2a')](function(_0x4e8008){_0x25d387=_[_0x96ab('0xa2')](_0x4e8008,'id');_0x3ea5fd=_['merge'](_0x3ea5fd,{'model':db[_0x96ab('0xa3')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x38de47[_0x96ab('0x48')]['fields']){_0x149078[_0x96ab('0x46')][_0x96ab('0x37')](function(_0x5898da){_0x3fe014[_0x96ab('0x4e')]('i.'+_0x5898da);});}else{_0x3fe014[_0x96ab('0x4e')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x96ab('0x67'));_0x3fe014[_0x96ab('0x4e')](_0x96ab('0xa4'),_0x96ab('0xa5'));_0x3fe014[_0x96ab('0x4e')](_0x96ab('0xa6'),'Account.mandatoryDisposition');_0x3fe014[_0x96ab('0x4e')](_0x96ab('0xa7'),_0x96ab('0x95'));_0x3fe014['field']('i.*');_0x3fe014[_0x96ab('0x4e')]('c.firstName',_0x96ab('0xa8'));_0x3fe014[_0x96ab('0x4e')](_0x96ab('0xa9'),_0x96ab('0xaa'));_0x3fe014['field'](_0x96ab('0xab'),_0x96ab('0xac'));_0x3fe014[_0x96ab('0x4e')](_0x96ab('0xad'),_0x96ab('0xae'));_0x3fe014[_0x96ab('0x4e')](_0x96ab('0xaf'),'Contact.mobile');_0x3fe014[_0x96ab('0x4e')](_0x96ab('0xb0'),_0x96ab('0xb1'));_0x3fe014[_0x96ab('0x4e')](_0x96ab('0xb2'),_0x96ab('0xb3'));_0x3fe014[_0x96ab('0x4e')](_0x96ab('0xb4'),_0x96ab('0xb5'));_0x3fe014['field']('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0x149078['limit'])_0x3fe014[_0x96ab('0x24')](_0x149078[_0x96ab('0x24')]);if(_0x149078[_0x96ab('0x22')])_0x3fe014[_0x96ab('0x22')](_0x149078[_0x96ab('0x22')]);return db[_0x96ab('0xa1')][_0x96ab('0x48')](_0x3fe014[_0x96ab('0xa0')](),_0x3ea5fd);})[_0x96ab('0x2a')](function(_0x3a49c4){if(_0x3a49c4[_0x96ab('0x6d')]>0x0)_0xa07b16[_0x96ab('0x7e')](_0x96ab('0xb6'),_[_0x96ab('0x32')](_0x3a49c4,'id'));return db[_0x96ab('0xa1')]['query'](_0xa07b16['toString'](),_0x3ea5fd)['then'](function(_0x5a4e84){var _0x3656ff=_[_0x96ab('0xb7')](_0x5a4e84,_0x96ab('0xb8'));var _0x299355=[];_0x3a49c4[_0x96ab('0x37')](function(_0x11a843){_0x299355[_0x96ab('0xb9')](updateWhatsappInteraction(_0x11a843,_0x25d387,_0x3656ff));});return BPromise['all'](_0x299355);});});})['then'](function(_0x4bf22c){_0x1df03b[_0x96ab('0xba')]=_0x4bf22c;return _0x1df03b;})[_0x96ab('0x2a')](respondWithFilteredResult(_0x9e833,_0x149078))[_0x96ab('0xbb')](handleError(_0x9e833,null));};exports[_0x96ab('0xbc')]=function(_0x2e86a3,_0x5e8656){var _0x27b589={'raw':![],'where':{'id':_0x2e86a3[_0x96ab('0xbd')]['id']}},_0x57ba37={};_0x57ba37[_0x96ab('0x43')]=_['keys'](db[_0x96ab('0xa3')][_0x96ab('0xbe')]);_0x57ba37[_0x96ab('0x48')]=_['keys'](_0x2e86a3['query']);_0x57ba37['filters']=_[_0x96ab('0x45')](_0x57ba37[_0x96ab('0x43')],_0x57ba37[_0x96ab('0x48')]);_0x27b589['attributes']=_['intersection'](_0x57ba37[_0x96ab('0x43')],qs[_0x96ab('0x47')](_0x2e86a3[_0x96ab('0x48')][_0x96ab('0x47')]));_0x27b589['attributes']=_0x27b589[_0x96ab('0x46')][_0x96ab('0x6d')]?_0x27b589[_0x96ab('0x46')]:_0x57ba37[_0x96ab('0x43')];if(_0x2e86a3['query'][_0x96ab('0xbf')]){_0x27b589[_0x96ab('0xc0')]=[{'all':!![]}];}_0x27b589=_[_0x96ab('0xc1')]({},_0x27b589,_0x2e86a3[_0x96ab('0xc2')]);return db[_0x96ab('0xa3')][_0x96ab('0x66')](_0x27b589)['then'](handleEntityNotFound(_0x5e8656,null))[_0x96ab('0x2a')](respondWithResult(_0x5e8656,null))[_0x96ab('0xbb')](handleError(_0x5e8656,null));};exports['create']=function(_0x5be70c,_0x23f2ec){return db[_0x96ab('0xa3')]['create'](_0x5be70c[_0x96ab('0x7a')],{})[_0x96ab('0x2a')](respondWithResult(_0x23f2ec,0xc9))[_0x96ab('0xbb')](handleError(_0x23f2ec,null));};exports['update']=function(_0x2902dc,_0x4693ab){if(_0x2902dc[_0x96ab('0x7a')]['id']){delete _0x2902dc[_0x96ab('0x7a')]['id'];}return db[_0x96ab('0xa3')][_0x96ab('0x66')]({'where':{'id':_0x2902dc['params']['id']}})[_0x96ab('0x2a')](handleEntityNotFound(_0x4693ab,null))[_0x96ab('0x2a')](saveUpdates(_0x2902dc[_0x96ab('0x7a')],null))[_0x96ab('0x2a')](respondWithResult(_0x4693ab,null))[_0x96ab('0xbb')](handleError(_0x4693ab,null));};exports[_0x96ab('0x2b')]=function(_0x5d0be1,_0x4ca1d5){return db[_0x96ab('0xa3')]['find']({'where':{'id':_0x5d0be1['params']['id']}})[_0x96ab('0x2a')](handleEntityNotFound(_0x4ca1d5,null))['then'](removeEntity(_0x4ca1d5,null))[_0x96ab('0xbb')](handleError(_0x4ca1d5,null));};exports[_0x96ab('0xc3')]=function(_0x24602a,_0x5cd5ea){return db[_0x96ab('0xa3')][_0x96ab('0xc3')]()[_0x96ab('0x2a')](respondWithResult(_0x5cd5ea,null))['catch'](handleError(_0x5cd5ea,null));};exports[_0x96ab('0xc4')]=function(_0x4201fd,_0x391689,_0x21f22a){return db[_0x96ab('0xc5')][_0x96ab('0x66')]({'where':{'id':_0x4201fd[_0x96ab('0xbd')]['id']}})['then'](handleEntityNotFound(_0x391689,null))[_0x96ab('0x2a')](function(_0x4fdcd1){if(_0x4fdcd1){return _0x4fdcd1[_0x96ab('0xc4')](_0x4201fd['body'][_0x96ab('0xc6')],_['omit'](_0x4201fd['body'],[_0x96ab('0xc6'),'id'])||{});}})['then'](respondWithResult(_0x391689,null))[_0x96ab('0xbb')](handleError(_0x391689,null));};exports[_0x96ab('0xc7')]=function(_0x4cb9be,_0x530e0b,_0xbb90c4){var _0x188c9a={'raw':![],'where':{}};var _0x144b3b={};var _0x4e94dc={'count':0x0,'rows':[]};return db['WhatsappInteraction'][_0x96ab('0xc8')]({'where':{'id':_0x4cb9be[_0x96ab('0xbd')]['id']}})[_0x96ab('0x2a')](handleEntityNotFound(_0x530e0b,null))[_0x96ab('0x2a')](function(_0x442ead){if(_0x442ead){_0x144b3b[_0x96ab('0x43')]=_[_0x96ab('0x44')](db[_0x96ab('0xc5')][_0x96ab('0xbe')]);_0x144b3b[_0x96ab('0x48')]=_[_0x96ab('0x44')](_0x4cb9be[_0x96ab('0x48')]);_0x144b3b[_0x96ab('0x4c')]=_[_0x96ab('0x45')](_0x144b3b[_0x96ab('0x43')],_0x144b3b[_0x96ab('0x48')]);_0x188c9a['attributes']=_[_0x96ab('0x45')](_0x144b3b[_0x96ab('0x43')],qs[_0x96ab('0x47')](_0x4cb9be['query'][_0x96ab('0x47')]));_0x188c9a[_0x96ab('0x46')]=_0x188c9a[_0x96ab('0x46')][_0x96ab('0x6d')]?_0x188c9a[_0x96ab('0x46')]:_0x144b3b[_0x96ab('0x43')];if(!_0x4cb9be['query'][_0x96ab('0x49')]('nolimit')){_0x188c9a[_0x96ab('0x24')]=qs[_0x96ab('0x24')](_0x4cb9be['query'][_0x96ab('0x24')]);_0x188c9a['offset']=qs[_0x96ab('0x22')](_0x4cb9be[_0x96ab('0x48')][_0x96ab('0x22')]);}_0x188c9a[_0x96ab('0x94')]=qs[_0x96ab('0x4b')](_0x4cb9be['query'][_0x96ab('0x4b')]);_0x188c9a[_0x96ab('0x7e')]=qs['filters'](_[_0x96ab('0x4d')](_0x4cb9be['query'],_0x144b3b[_0x96ab('0x4c')]));_0x188c9a[_0x96ab('0x7e')][_0x96ab('0xb8')]=_0x442ead['id'];if(_0x4cb9be['query'][_0x96ab('0x89')]){_0x188c9a[_0x96ab('0x7e')]=_[_0x96ab('0xc1')](_0x188c9a['where'],{'$or':_['map'](_0x188c9a[_0x96ab('0x46')],function(_0x4b5b87){var _0x142c78={};_0x142c78[_0x4b5b87]={'$like':'%'+_0x4cb9be[_0x96ab('0x48')]['filter']+'%'};return _0x142c78;})});}if(_0x4cb9be[_0x96ab('0x48')][_0x96ab('0x81')]){var _0x4dcab1=_0x4cb9be[_0x96ab('0x48')][_0x96ab('0x81')][_0x96ab('0x36')](',');var _0x3c7aeb={};_0x3c7aeb[_0x4dcab1[0x0]]={'$gte':moment(_0x4dcab1[0x1])[_0x96ab('0xc9')]('YYYY-MM-DD\x20HH:mm:ss')};_0x188c9a[_0x96ab('0x7e')]=_[_0x96ab('0xc1')](_0x188c9a['where'],_0x3c7aeb);}_0x188c9a=_[_0x96ab('0xc1')]({},_0x188c9a,_0x4cb9be[_0x96ab('0xc2')]);return db[_0x96ab('0xc5')][_0x96ab('0x25')]({'where':_0x188c9a[_0x96ab('0x7e')]})[_0x96ab('0x2a')](function(_0x202a98){_0x4e94dc[_0x96ab('0x25')]=_0x202a98;if(_0x4cb9be[_0x96ab('0x48')][_0x96ab('0xbf')]){_0x188c9a['include']=[{'all':!![]}];}return db[_0x96ab('0xc5')][_0x96ab('0xca')](_0x188c9a);})['then'](function(_0x37f84e){_0x4e94dc[_0x96ab('0xba')]=_0x37f84e;return _0x4e94dc;});}})[_0x96ab('0x2a')](respondWithFilteredResult(_0x530e0b,_0x188c9a))[_0x96ab('0xbb')](handleError(_0x530e0b,null));};exports[_0x96ab('0xcb')]=function(_0x6ae8c7,_0x291d39,_0x5c3d43){return db[_0x96ab('0xa3')][_0x96ab('0x66')]({'where':{'id':_0x6ae8c7[_0x96ab('0xbd')]['id']}})[_0x96ab('0x2a')](handleEntityNotFound(_0x291d39,null))[_0x96ab('0x2a')](function(_0x5d22c5){if(_0x5d22c5){return _0x5d22c5['setTags'](_0x6ae8c7['body'][_0x96ab('0xc6')],_[_0x96ab('0xcc')](_0x6ae8c7[_0x96ab('0x7a')],[_0x96ab('0xc6'),'id'])||{})[_0x96ab('0xcd')](function(){return db[_0x96ab('0x74')]['findAll']({'attributes':['id',_0x96ab('0x2f'),_0x96ab('0xce')],'where':{'id':_0x6ae8c7[_0x96ab('0x7a')][_0x96ab('0xc6')]}});})[_0x96ab('0x2a')](function(_0x1ebfa9){socket[_0x96ab('0xcf')](_0x96ab('0xd0'),{'id':Number(_0x6ae8c7[_0x96ab('0xbd')]['id']),'tags':_0x1ebfa9||[]});return{'id':Number(_0x6ae8c7['params']['id']),'tags':_0x1ebfa9||[]};});}})[_0x96ab('0x2a')](respondWithResult(_0x291d39,null))['catch'](handleError(_0x291d39,null));};exports[_0x96ab('0xd1')]=function(_0x591daa,_0x5db671,_0x17c720){return db[_0x96ab('0xa3')][_0x96ab('0x66')]({'where':{'id':_0x591daa[_0x96ab('0xbd')]['id']}})[_0x96ab('0x2a')](handleEntityNotFound(_0x5db671,null))['then'](function(_0x4defed){if(_0x4defed){return _0x4defed[_0x96ab('0xd1')](_0x591daa[_0x96ab('0x48')]['ids']);}})['then'](respondWithStatusCode(_0x5db671,null))['catch'](handleError(_0x5db671,null));};exports[_0x96ab('0xd2')]=function(_0x27fd10,_0x2bfe01){var _0x583a21=moment()[_0x96ab('0xd3')]()['toString']();var _0x4f1b71=path[_0x96ab('0xd4')](config[_0x96ab('0xd5')],'server','files',_0x96ab('0xd6'));var _0x310618=path[_0x96ab('0xd4')](config[_0x96ab('0xd5')],_0x96ab('0xd7'),'files',_0x96ab('0xd8'));var _0x1d9a3f=path[_0x96ab('0xd4')](_0x4f1b71,_0x583a21);var _0x5bacf8=util['format'](_0x96ab('0xd9'),_0x27fd10[_0x96ab('0xbd')]['id'],_0x583a21);var _0x352041=path[_0x96ab('0xd4')](_0x4f1b71,_0x5bacf8);var _0x372f0f=[];_0x372f0f[_0x96ab('0xb9')]({'model':db['User'],'as':_0x96ab('0x77'),'attributes':['id',_0x96ab('0x33')],'raw':!![]});_0x372f0f['push']({'model':db[_0x96ab('0xda')],'as':_0x96ab('0xdb'),'attributes':['id','firstName',_0x96ab('0xdc')],'raw':!![]});if(_0x27fd10[_0x96ab('0x48')][_0x96ab('0xd8')]){_0x372f0f[_0x96ab('0xb9')]({'model':db[_0x96ab('0xdd')],'as':_0x96ab('0xdd'),'raw':!![]});}var _0x396573=[{'model':db['WhatsappMessage'],'as':'Messages','attributes':['id',_0x96ab('0x7a'),_0x96ab('0xde'),_0x96ab('0xdf'),'secret',_0x96ab('0x85')],'include':_0x372f0f}];_0x396573[_0x96ab('0xb9')]({'model':db[_0x96ab('0xe0')],'as':_0x96ab('0xe1'),'attributes':['id','name']});_0x396573[_0x96ab('0xb9')]({'model':db['User'],'as':_0x96ab('0xe2'),'attributes':['id',_0x96ab('0x33')]});return db['WhatsappInteraction']['find']({'where':{'id':_0x27fd10[_0x96ab('0xbd')]['id']},'include':_0x396573})[_0x96ab('0x2a')](handleEntityNotFound(_0x2bfe01,null))['then'](function(_0x5429bf){if(_0x5429bf){var _0x5e709d=_0x5429bf[_0x96ab('0xe3')]({'plain':!![]});fs[_0x96ab('0xe4')](_0x1d9a3f);var _0x5b05a1={'channel':_0x96ab('0xe5'),'account':_0x5e709d[_0x96ab('0xe1')][_0x96ab('0x2f')],'agent':_0x5e709d['Owner']?_0x5e709d['Owner']['fullname']:_0x96ab('0xe6'),'createdAt':moment(_0x5e709d[_0x96ab('0xde')])['format'](_0x96ab('0xe7'))[_0x96ab('0xa0')](),'closedAt':_0x5e709d[_0x96ab('0x3c')]?moment(_0x5e709d[_0x96ab('0xe8')])[_0x96ab('0xc9')](_0x96ab('0xe7'))['toString']():'','disposition':_0x5e709d[_0x96ab('0xe9')],'messages':_(_0x5e709d[_0x96ab('0xea')])['filter']({'secret':![]})[_0x96ab('0x32')](function(_0x55116b){if(_0x55116b[_0x96ab('0xdd')]){var _0x2859a9=path[_0x96ab('0xd4')](_0x310618,_0x55116b['Attachment'][_0x96ab('0xeb')]);if(fs[_0x96ab('0xec')](_0x2859a9)){fs[_0x96ab('0xed')](_0x2859a9)[_0x96ab('0xee')](fs[_0x96ab('0xef')](path[_0x96ab('0xd4')](_0x1d9a3f,_0x55116b[_0x96ab('0xdd')][_0x96ab('0xeb')])));}}return{'date':moment(_0x55116b['createdAt'])[_0x96ab('0xc9')](_0x96ab('0xe7'))[_0x96ab('0xa0')](),'sender':_0x55116b[_0x96ab('0xdf')]===_0x96ab('0xf0')?_0x55116b[_0x96ab('0x77')]?_0x55116b[_0x96ab('0x77')][_0x96ab('0x33')]:'System':_0x55116b[_0x96ab('0xdb')][_0x96ab('0xf1')]+(_0x55116b[_0x96ab('0xdb')]['lastName']?'\x20'+_0x55116b[_0x96ab('0xdb')][_0x96ab('0xdc')]:''),'body':_0x55116b['Attachment']?_0x55116b[_0x96ab('0xdd')][_0x96ab('0xeb')]:_0x55116b[_0x96ab('0x7a')],'direction':_0x55116b[_0x96ab('0xdf')]===_0x96ab('0xf0')?'A':'C','secret':_0x55116b[_0x96ab('0xf2')],'read':_0x55116b['read'],'attachment':_0x55116b[_0x96ab('0xdd')]};})[_0x96ab('0x68')]()};return ejs[_0x96ab('0xf3')](path['join'](config[_0x96ab('0xd5')],'server',_0x96ab('0xf4'),'downloadInteraction.ejs'),{'interaction':_0x5b05a1})[_0x96ab('0x2a')](function(_0x19debb){var _0x55202e=path['join'](_0x1d9a3f,_0x96ab('0xf5')+_0x5e709d['id']+'-'+_0x583a21+'.pdf');var _0x29937b={'path':_0x55202e,'channel':_0x96ab('0xe5'),'interactionId':_0x5e709d['id']};return pdf[_0x96ab('0xf6')](_0x19debb,_0x29937b);})[_0x96ab('0x2a')](function(){return new BPromise(function(_0x27680e,_0x41dbe9){zipdir(_0x1d9a3f,{'saveTo':_0x352041},function(_0x5223d2,_0x33db1e){if(_0x5223d2)return _0x41dbe9(_0x5223d2);return _0x27680e(_0x33db1e);});})[_0x96ab('0x2a')](function(){return new BPromise(function(_0x3f95e8,_0x17a7f9){rimraf(_0x1d9a3f,function(_0x31d081){if(_0x31d081)_0x17a7f9(_0x31d081);return _0x3f95e8();});});})[_0x96ab('0x2a')](function(){return _0x2bfe01[_0x96ab('0xd2')](_0x352041,_0x5bacf8,function(_0x588635){if(_0x588635){console[_0x96ab('0xf7')](_0x96ab('0xf8'),_0x588635);}else{fs['unlinkSync'](_0x352041);}});});});}else{return _0x2bfe01[_0x96ab('0x2c')](0xc8);}})[_0x96ab('0xbb')](handleError(_0x2bfe01,null));};
\ No newline at end of file