Built motion from commit (unavailable).|2.5.6
[motion2.git] / server / api / smsInteraction / smsInteraction.controller.js
1 // *************************************************************************
2 // *                                                                       *
3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
5 // *                                                                       *
6 // *************************************************************************
7 // *                                                                       *
8 // * Email: info@xcally.com                                                *
9 // * Website: https://www.xcally.com                                       *
10 // *                                                                       *
11 // *************************************************************************
12 // *                                                                       *
13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
14 // * copyright treaties, as well as other intellectual property laws and   *
15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
16 // *                                                                       *
17 // *************************************************************************
18 var _0xd785=['\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20>\x200','tag','isArray','filter','replace','\x27\x27\x27\x27','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','clone','order','DESC','resolve','journey','user','getSmsAccounts','i.SmsAccountId\x20IS\x20NULL','sequelize','toString','keyBy','merge','SmsInteraction','a.key','Account.key','a.mandatoryDisposition','i.*','c.firstName','Contact.firstName','c.email','c.mobile','Contact.mobile','Contact.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','ui.SmsInteractionId\x20IN\x20?','SmsInteractionId','all','show','params','rawAttributes','filtears','includeAll','include','options','create','destroy','describe','addMessage','SmsMessage','ids','getMessages','$gte','format','YYYY-MM-DD\x20HH:mm:ss','findAll','rows','setTags','spread','emit','smsInteractionTags:save','removeTags','download','unix','join','root','server','tmp','files','attachments','transcript-%d-%s.zip','CmContact','lastName','direction','SmsAccount','Account','Owner','get','mkdirSync','10px','<div\x20class=\x22header\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<h5>Interaction\x20Transcript</h5>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>','30px','%s\x20#%d','Sms','YYYY-MM-DD','closedAt','disposition','Messages','out','firstName','secret','views','downloadInteraction.html','transcript-','.pdf','unlinkSync','fast-json-patch','moment','bluebird','util','to-csv','ejs','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','redis','defaults','socket.io-emitter','./smsInteraction.socket','sendStatus','status','json','count','limit','set','reject','save','update','then','end','error','stack','name','Users','map','fullname','TagIds','Tags','split','push','catch','index','fieldName','type','key','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','offset','sort','where','pick','select','field','color','tools_tags','u.id','u.fullname','ui.SmsInteractionId','from','user_has_sms_interactions','left_join','u.id\x20=\x20ui.UserId','sms_interactions','users','o.id\x20=\x20i.UserId','sms_messages','me.SmsInteractionId\x20=\x20i.id','it.SmsInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','find','unreadMessages','value','having','Contact','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','text','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','User','UserId','body','start','some','compact','isEmpty','i.SmsAccountId\x20IN\x20?','concat','createdAt','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null'];(function(_0x472fd8,_0x3dacd8){var _0x4c2e7f=function(_0x5c74f3){while(--_0x5c74f3){_0x472fd8['push'](_0x472fd8['shift']());}};_0x4c2e7f(++_0x3dacd8);}(_0xd785,0x143));var _0x5d78=function(_0xa990b7,_0x26c527){_0xa990b7=_0xa990b7-0x0;var _0x52c99c=_0xd785[_0xa990b7];return _0x52c99c;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x5d78('0x0'));var rp=require('request-promise');var moment=require(_0x5d78('0x1'));var BPromise=require(_0x5d78('0x2'));var Mustache=require('mustache');var util=require(_0x5d78('0x3'));var path=require('path');var sox=require('sox');var csv=require(_0x5d78('0x4'));var ejs=require(_0x5d78('0x5'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x5d78('0x6'));var toCsv=require('to-csv');var querystring=require(_0x5d78('0x7'));var Papa=require('papaparse');var Redis=require(_0x5d78('0x8'));var authService=require(_0x5d78('0x9'));var qs=require(_0x5d78('0xa'));var as=require(_0x5d78('0xb'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x5d78('0xc'))(_0x5d78('0xd'));var utils=require(_0x5d78('0xe'));var config=require(_0x5d78('0xf'));var licenseUtil=require(_0x5d78('0x10'));var db=require('../../mysqldb')['db'];config[_0x5d78('0x11')]=_[_0x5d78('0x12')](config[_0x5d78('0x11')],{'host':'localhost','port':0x18eb});var socket=require(_0x5d78('0x13'))(new Redis(config[_0x5d78('0x11')]));require(_0x5d78('0x14'))['register'](socket);function respondWithStatusCode(_0x2fb333,_0xe2780c){_0xe2780c=_0xe2780c||0xcc;return function(_0xd54117){if(_0xd54117){return _0x2fb333[_0x5d78('0x15')](_0xe2780c);}return _0x2fb333[_0x5d78('0x16')](_0xe2780c)['end']();};}function respondWithResult(_0x2077df,_0xbbb74){_0xbbb74=_0xbbb74||0xc8;return function(_0x2aa0d0){if(_0x2aa0d0){return _0x2077df[_0x5d78('0x16')](_0xbbb74)[_0x5d78('0x17')](_0x2aa0d0);}};}function respondWithFilteredResult(_0x4da731,_0x15524b){return function(_0x335f13){if(_0x335f13){var _0x23ac51=_0x335f13[_0x5d78('0x18')],_0x4b4f95=_0x15524b['offset'],_0x43da74=_0x15524b['offset']+_0x15524b[_0x5d78('0x19')],_0xaa9a4e;if(_0x43da74>=_0x23ac51){_0x43da74=_0x23ac51;_0xaa9a4e=0xc8;}else{_0xaa9a4e=0xce;}_0x4da731[_0x5d78('0x16')](_0xaa9a4e);return _0x4da731[_0x5d78('0x1a')]('Content-Range',_0x4b4f95+'-'+_0x43da74+'/'+_0x23ac51)[_0x5d78('0x17')](_0x335f13);}return null;};}function patchUpdates(_0x441d0e){return function(_0x37ea96){try{jsonpatch['apply'](_0x37ea96,_0x441d0e,!![]);}catch(_0x460aa4){return BPromise[_0x5d78('0x1b')](_0x460aa4);}return _0x37ea96[_0x5d78('0x1c')]();};}function saveUpdates(_0x3b6296,_0x4b70a3){return function(_0x13642f){if(_0x13642f){return _0x13642f[_0x5d78('0x1d')](_0x3b6296)[_0x5d78('0x1e')](function(_0x4cb248){return _0x4cb248;});}return null;};}function removeEntity(_0x1aaf20,_0x1b90b6){return function(_0x4459c1){if(_0x4459c1){return _0x4459c1['destroy']()[_0x5d78('0x1e')](function(){_0x1aaf20[_0x5d78('0x16')](0xcc)[_0x5d78('0x1f')]();});}};}function handleEntityNotFound(_0x2ed0f2,_0x5df0ce){return function(_0x55ef2c){if(!_0x55ef2c){_0x2ed0f2[_0x5d78('0x15')](0x194);}return _0x55ef2c;};}function handleError(_0xd11d42,_0xf07978){_0xf07978=_0xf07978||0x1f4;return function(_0x44aae1){logger[_0x5d78('0x20')](_0x44aae1[_0x5d78('0x21')]);if(_0x44aae1[_0x5d78('0x22')]){delete _0x44aae1[_0x5d78('0x22')];}_0xd11d42[_0x5d78('0x16')](_0xf07978)['send'](_0x44aae1);};}function getInteractionUsers(_0x4879b8,_0x1f37d7){return new BPromise(function(_0x59c991,_0x3afefe){try{if(_0x1f37d7[_0x4879b8['id']]){_0x4879b8[_0x5d78('0x23')]=_[_0x5d78('0x24')](_0x1f37d7[_0x4879b8['id']],function(_0x3dcb70){return{'id':_0x3dcb70['id'],'fullname':_0x3dcb70[_0x5d78('0x25')]};});}}catch(_0x2c9f5a){_0x3afefe(_0x2c9f5a);}_0x59c991(_0x4879b8);});}function getInteractionTags(_0x361e65,_0x5ec173){return new BPromise(function(_0x71f45a,_0x296480){try{if(_0x361e65[_0x5d78('0x26')]){_0x361e65[_0x5d78('0x27')]=[];_0x361e65[_0x5d78('0x26')][_0x5d78('0x28')](',')['forEach'](function(_0x457d37){_0x361e65[_0x5d78('0x27')][_0x5d78('0x29')](_0x5ec173[_0x457d37]);});}delete _0x361e65['TagIds'];}catch(_0x4b81d7){_0x296480(_0x4b81d7);}_0x71f45a(_0x361e65);});}function updateSmsInteraction(_0xefcbc2,_0x43b30d,_0x258572){return new BPromise(function(_0x165e3b,_0x583e7a){return getInteractionUsers(_0xefcbc2,_0x258572)[_0x5d78('0x1e')](function(_0x47c75e){return getInteractionTags(_0x47c75e,_0x43b30d);})['then'](function(_0x113069){_0x165e3b(_0x113069);})[_0x5d78('0x2a')](function(_0x59225a){_0x583e7a(_0x59225a);});});}exports[_0x5d78('0x2b')]=function(_0x52811f,_0x325105){var _0x30d9ac={},_0x328a04={},_0x1e4928={'count':0x0,'rows':[]};var _0x35e459=_[_0x5d78('0x24')](db['SmsInteraction']['rawAttributes'],function(_0x53397d){return{'name':_0x53397d[_0x5d78('0x2c')],'type':_0x53397d[_0x5d78('0x2d')][_0x5d78('0x2e')]};});_0x328a04['model']=_[_0x5d78('0x24')](_0x35e459,'name');_0x328a04[_0x5d78('0x2f')]=_[_0x5d78('0x30')](_0x52811f[_0x5d78('0x2f')]);_0x328a04[_0x5d78('0x31')]=_[_0x5d78('0x32')](_0x328a04[_0x5d78('0x33')],_0x328a04[_0x5d78('0x2f')]);_0x30d9ac[_0x5d78('0x34')]=_[_0x5d78('0x32')](_0x328a04['model'],qs[_0x5d78('0x35')](_0x52811f['query'][_0x5d78('0x35')]));_0x30d9ac[_0x5d78('0x34')]=_0x30d9ac['attributes'][_0x5d78('0x36')]?_0x30d9ac['attributes']:_0x328a04['model'];if(!_0x52811f[_0x5d78('0x2f')][_0x5d78('0x37')](_0x5d78('0x38'))){_0x30d9ac['limit']=qs['limit'](_0x52811f[_0x5d78('0x2f')][_0x5d78('0x19')]);_0x30d9ac[_0x5d78('0x39')]=qs['offset'](_0x52811f[_0x5d78('0x2f')]['offset']);}_0x30d9ac['order']=qs[_0x5d78('0x3a')](_0x52811f[_0x5d78('0x2f')][_0x5d78('0x3a')]);_0x30d9ac[_0x5d78('0x3b')]=qs['filters'](_[_0x5d78('0x3c')](_0x52811f[_0x5d78('0x2f')],_0x328a04[_0x5d78('0x31')]),_0x35e459);var _0x3d3ed2=[];var _0x45de32=squel[_0x5d78('0x3d')]()[_0x5d78('0x3e')]('id')['field'](_0x5d78('0x22'))['field'](_0x5d78('0x3f'))['from'](_0x5d78('0x40'));var _0x37aebc=squel[_0x5d78('0x3d')]()[_0x5d78('0x3e')](_0x5d78('0x41'))[_0x5d78('0x3e')](_0x5d78('0x42'))[_0x5d78('0x3e')](_0x5d78('0x43'))[_0x5d78('0x44')](_0x5d78('0x45'),'ui')[_0x5d78('0x46')]('users','u',_0x5d78('0x47'));var _0x15e61a=squel[_0x5d78('0x3d')]()[_0x5d78('0x44')](_0x5d78('0x48'),'i')['left_join']('cm_contacts','c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')['left_join'](_0x5d78('0x49'),'o',_0x5d78('0x4a'))[_0x5d78('0x46')]('sms_accounts','a','a.id\x20=\x20i.SmsAccountId')['left_join'](_0x5d78('0x4b'),'me',_0x5d78('0x4c'))[_0x5d78('0x46')]('sms_interaction_has_tags','it',_0x5d78('0x4d'))[_0x5d78('0x46')](_0x5d78('0x40'),'t',_0x5d78('0x4e'));var _0x1e6bed=squel[_0x5d78('0x4f')]();var _0x3769ab=[];var _0x4594a4=squel['expr']();var _0x22fd44;if(_0x52811f[_0x5d78('0x2f')][_0x5d78('0x50')]){_0x22fd44=as[_0x5d78('0x51')](_0x52811f[_0x5d78('0x2f')][_0x5d78('0x50')]);var _0x3ebde4=_0x22fd44[_0x5d78('0x52')];for(var _0x35cc10=0x0;_0x35cc10<_0x22fd44[_0x5d78('0x53')]['length'];_0x35cc10++){var _0x1a30f5=_0x22fd44[_0x5d78('0x53')][_0x35cc10];var _0x318e67='i';var _0x1657b0=_[_0x5d78('0x54')](_0x35e459,['name',_0x1a30f5[_0x5d78('0x3e')]]);if(!_0x1657b0){switch(_0x1a30f5['field']){case _0x5d78('0x55'):if(_0x1a30f5[_0x5d78('0x56')]==0x1){_0x15e61a[_0x5d78('0x57')]('`'+_0x1a30f5[_0x5d78('0x3e')]+'`\x20=\x200');}else{_0x15e61a[_0x5d78('0x57')]('`'+_0x1a30f5[_0x5d78('0x3e')]+'`\x20>\x200');}break;case _0x5d78('0x58'):if(_0x1a30f5['operator']===_0x5d78('0x59')){if(_0x1a30f5['value'][_0x5d78('0x28')]('\x20')[_0x5d78('0x36')]>0x1){_0x1e6bed[_0x3ebde4](_0x5d78('0x5a'),qs['getFullTextValue'](_0x1a30f5[_0x5d78('0x56')]),null);}else{var _0x4832da='%'+_0x1a30f5[_0x5d78('0x56')]+'%';_0x1e6bed[_0x3ebde4](_0x5d78('0x5b'),_0x4832da,_0x4832da,_0x4832da);}}else{_0x1657b0=_[_0x5d78('0x54')](_0x35e459,[_0x5d78('0x22'),_0x5d78('0x5c')]);_0x1a30f5['field']=_0x5d78('0x5c');_0x32107e=as[_0x5d78('0x5d')](_0x318e67,_0x1657b0[_0x5d78('0x2d')],_0x1a30f5);_0x1e6bed[_0x3ebde4](_0x32107e[_0x5d78('0x5e')],_0x32107e[_0x5d78('0x56')]['start'],_0x32107e['value'][_0x5d78('0x1f')]);}break;case'Tag':var _0x7c3686=_0x1a30f5['value'][_0x5d78('0x28')](',')['map'](function(_0x3deee5){return Number(_0x3deee5);});_0x7c3686[_0x5d78('0x5f')](function(_0x5d0cb3){_0x4594a4['or'](_0x5d78('0x60'),'%,'+_0x5d0cb3+',%');});_0x3769ab=_['union'](_0x3769ab,_0x7c3686);break;case _0x5d78('0x61'):if(_0x1a30f5['operator']===_0x5d78('0x59')){_0x1e6bed[_0x3ebde4]('CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','%'+_0x1a30f5[_0x5d78('0x56')]+'%',null);}else{_0x1657b0=_[_0x5d78('0x54')](_0x35e459,[_0x5d78('0x22'),_0x5d78('0x62')]);_0x1a30f5[_0x5d78('0x3e')]=_0x5d78('0x62');_0x32107e=as[_0x5d78('0x5d')](_0x318e67,_0x1657b0[_0x5d78('0x2d')],_0x1a30f5);_0x1e6bed[_0x3ebde4](_0x32107e[_0x5d78('0x5e')],_0x32107e[_0x5d78('0x56')]['start'],_0x32107e[_0x5d78('0x56')][_0x5d78('0x1f')]);}break;case _0x5d78('0x63'):_0x32107e=as[_0x5d78('0x5d')]('me',null,_0x1a30f5);_0x1e6bed[_0x3ebde4](_0x32107e[_0x5d78('0x5e')],_0x32107e[_0x5d78('0x56')][_0x5d78('0x64')],_0x32107e['value'][_0x5d78('0x1f')]);break;}}else{var _0x32107e=as[_0x5d78('0x5d')](_0x318e67,_0x1657b0['type'],_0x1a30f5);_0x1e6bed[_0x3ebde4](_0x32107e[_0x5d78('0x5e')],_0x32107e[_0x5d78('0x56')][_0x5d78('0x64')],_0x32107e[_0x5d78('0x56')][_0x5d78('0x1f')]);}}}else{var _0x30c5c7=_(_0x52811f[_0x5d78('0x2f')])[_0x5d78('0x30')]()[_0x5d78('0x24')](function(_0x3b1c6b){return _[_0x5d78('0x65')](_0x35e459,[_0x5d78('0x22'),_0x3b1c6b])?_0x3b1c6b:undefined;})[_0x5d78('0x66')]()[_0x5d78('0x56')]();if(!_[_0x5d78('0x67')](_0x30c5c7)){_0x30c5c7[_0x5d78('0x5f')](function(_0x54587a){if(_0x54587a==='SmsAccountId'){_0x15e61a[_0x5d78('0x3b')](_0x5d78('0x68'),[][_0x5d78('0x69')](_0x52811f[_0x5d78('0x2f')][_0x54587a]));}else if(_0x54587a===_0x5d78('0x6a')){var _0x46642c=JSON['parse'](_0x52811f[_0x5d78('0x2f')][_0x54587a])['$gte'];var _0x186c4e=JSON[_0x5d78('0x6b')](_0x52811f[_0x5d78('0x2f')][_0x54587a])[_0x5d78('0x6c')];_0x15e61a[_0x5d78('0x3b')](_0x5d78('0x6d'),_0x46642c,_0x186c4e);}else{if(_0x52811f[_0x5d78('0x2f')][_0x54587a]===_0x5d78('0x6e')){_0x15e61a[_0x5d78('0x3b')]('i.'+_0x54587a+_0x5d78('0x6f'));}else{_0x15e61a[_0x5d78('0x3b')]('i.'+_0x54587a+_0x5d78('0x70'),_0x52811f['query'][_0x54587a]);}}});}if(_0x52811f[_0x5d78('0x2f')][_0x5d78('0x71')]){if(_0x52811f['query'][_0x5d78('0x71')]==0x1){_0x15e61a[_0x5d78('0x57')]('`unreadMessages`\x20=\x200');}else{_0x15e61a[_0x5d78('0x57')](_0x5d78('0x72'));}}if(_0x52811f[_0x5d78('0x2f')][_0x5d78('0x73')]){_0x3769ab=_[_0x5d78('0x74')](_0x52811f[_0x5d78('0x2f')][_0x5d78('0x73')])?_0x52811f[_0x5d78('0x2f')]['tag']:new Array(_0x52811f[_0x5d78('0x2f')]['tag']);_0x3769ab[_0x5d78('0x5f')](function(_0x4ec136){_0x4594a4['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x4ec136+',%');});}if(_0x52811f[_0x5d78('0x2f')][_0x5d78('0x75')]){var _0x359387=_0x52811f[_0x5d78('0x2f')][_0x5d78('0x75')][_0x5d78('0x76')]('\x5c','\x5c\x5c')[_0x5d78('0x76')]('\x27\x27',_0x5d78('0x77'));if(qs[_0x5d78('0x78')](_0x359387)){_0x1e6bed['or'](_0x5d78('0x79'),_0x359387+'%')['or'](_0x5d78('0x7a'),_0x359387+'%');}else{_0x1e6bed['or'](_0x5d78('0x7b'),qs['getFullTextValue'](_0x359387))['or'](_0x5d78('0x7c'),_0x359387+'%');}}}_0x15e61a['where'](_0x1e6bed);_0x15e61a[_0x5d78('0x7d')](_0x5d78('0x7e'));var _0x3574dc={'type':db[_0x5d78('0x7f')][_0x5d78('0x80')]['SELECT'],'raw':!![]};var _0x3184a5=_0x15e61a[_0x5d78('0x81')]();_0x3184a5[_0x5d78('0x3e')]('i.id');_0x3184a5[_0x5d78('0x3e')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x5d78('0x55'));if(_0x30d9ac[_0x5d78('0x82')]){_0x30d9ac[_0x5d78('0x82')][_0x5d78('0x5f')](function(_0x560ec6){_0x15e61a[_0x5d78('0x82')]('i.'+_0x560ec6[0x0],_0x560ec6[0x1]===_0x5d78('0x83')?![]:!![]);});}if(!_[_0x5d78('0x67')](_0x3769ab)){_0x15e61a['having'](_0x4594a4);_0x3184a5[_0x5d78('0x3b')]('t.id\x20IN\x20?',_0x3769ab);}BPromise[_0x5d78('0x84')]()[_0x5d78('0x1e')](function(){if(!_0x22fd44){if(_0x52811f['query']['SmsAccountId']||_0x52811f[_0x5d78('0x2f')][_0x5d78('0x85')])return;_0x3184a5[_0x5d78('0x3b')]('i.SmsAccountId\x20IS\x20NOT\x20NULL');_0x15e61a[_0x5d78('0x3b')]('i.SmsAccountId\x20IS\x20NOT\x20NULL');return;}return _0x52811f[_0x5d78('0x86')][_0x5d78('0x87')]({'attributes':['id'],'raw':!![]})['then'](function(_0xc09d7e){if(_['isEmpty'](_0xc09d7e)){_0x3184a5[_0x5d78('0x3b')](_0x5d78('0x88'));_0x15e61a[_0x5d78('0x3b')]('i.SmsAccountId\x20IS\x20NULL');}else{_0x3184a5[_0x5d78('0x3b')](_0x5d78('0x68'),_[_0x5d78('0x24')](_0xc09d7e,'id'));_0x15e61a[_0x5d78('0x3b')](_0x5d78('0x68'),_[_0x5d78('0x24')](_0xc09d7e,'id'));}});})[_0x5d78('0x1e')](function(){db['sequelize'][_0x5d78('0x2f')](_0x3184a5['toString'](),_0x3574dc)['then'](function(_0x3eab4b){_0x1e4928[_0x5d78('0x18')]=_0x3eab4b[_0x5d78('0x36')];if(_0x1e4928[_0x5d78('0x18')]===0x0)return[];return db[_0x5d78('0x89')][_0x5d78('0x2f')](_0x45de32[_0x5d78('0x8a')](),_0x3574dc)[_0x5d78('0x1e')](function(_0x35e59d){_0x3d3ed2=_[_0x5d78('0x8b')](_0x35e59d,'id');_0x3574dc=_[_0x5d78('0x8c')](_0x3574dc,{'model':db[_0x5d78('0x8d')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x52811f[_0x5d78('0x2f')]['fields']){_0x30d9ac[_0x5d78('0x34')][_0x5d78('0x5f')](function(_0x3179da){_0x15e61a[_0x5d78('0x3e')]('i.'+_0x3179da);});}else{_0x15e61a[_0x5d78('0x3e')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x5d78('0x55'));_0x15e61a['field'](_0x5d78('0x8e'),_0x5d78('0x8f'));_0x15e61a['field'](_0x5d78('0x90'),'Account.mandatoryDisposition');_0x15e61a[_0x5d78('0x3e')](_0x5d78('0x91'));_0x15e61a[_0x5d78('0x3e')](_0x5d78('0x92'),_0x5d78('0x93'));_0x15e61a[_0x5d78('0x3e')]('c.lastName','Contact.lastName');_0x15e61a[_0x5d78('0x3e')](_0x5d78('0x94'),'Contact.email');_0x15e61a[_0x5d78('0x3e')]('c.phone','Contact.phone');_0x15e61a[_0x5d78('0x3e')](_0x5d78('0x95'),_0x5d78('0x96'));_0x15e61a['field']('c.fax',_0x5d78('0x97'));_0x15e61a[_0x5d78('0x3e')](_0x5d78('0x98'),_0x5d78('0x99'));_0x15e61a[_0x5d78('0x3e')](_0x5d78('0x9a'),_0x5d78('0x9b'));_0x15e61a[_0x5d78('0x3e')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0x5d78('0x26'));}if(_0x30d9ac[_0x5d78('0x19')])_0x15e61a[_0x5d78('0x19')](_0x30d9ac['limit']);if(_0x30d9ac[_0x5d78('0x39')])_0x15e61a[_0x5d78('0x39')](_0x30d9ac[_0x5d78('0x39')]);return db[_0x5d78('0x89')][_0x5d78('0x2f')](_0x15e61a[_0x5d78('0x8a')](),_0x3574dc);})[_0x5d78('0x1e')](function(_0x50c135){_0x37aebc['where'](_0x5d78('0x9c'),_[_0x5d78('0x24')](_0x50c135,'id'));return db[_0x5d78('0x89')][_0x5d78('0x2f')](_0x37aebc[_0x5d78('0x8a')](),_0x3574dc)[_0x5d78('0x1e')](function(_0x1c5b72){var _0x219598=_['groupBy'](_0x1c5b72,_0x5d78('0x9d'));var _0x1d43e5=[];_0x50c135['forEach'](function(_0x1db94d){_0x1d43e5[_0x5d78('0x29')](updateSmsInteraction(_0x1db94d,_0x3d3ed2,_0x219598));});return BPromise[_0x5d78('0x9e')](_0x1d43e5);});});})['then'](function(_0x1d8864){_0x1e4928['rows']=_0x1d8864;return _0x1e4928;})[_0x5d78('0x1e')](respondWithFilteredResult(_0x325105,_0x30d9ac));})[_0x5d78('0x2a')](handleError(_0x325105,null));};exports[_0x5d78('0x9f')]=function(_0xaf93f0,_0xd20ff3){var _0x49f11b={'raw':![],'where':{'id':_0xaf93f0[_0x5d78('0xa0')]['id']}},_0x3e07d6={};_0x3e07d6[_0x5d78('0x33')]=_['keys'](db[_0x5d78('0x8d')][_0x5d78('0xa1')]);_0x3e07d6[_0x5d78('0x2f')]=_[_0x5d78('0x30')](_0xaf93f0[_0x5d78('0x2f')]);_0x3e07d6[_0x5d78('0xa2')]=_[_0x5d78('0x32')](_0x3e07d6['model'],_0x3e07d6[_0x5d78('0x2f')]);_0x49f11b[_0x5d78('0x34')]=_[_0x5d78('0x32')](_0x3e07d6[_0x5d78('0x33')],qs[_0x5d78('0x35')](_0xaf93f0[_0x5d78('0x2f')][_0x5d78('0x35')]));_0x49f11b[_0x5d78('0x34')]=_0x49f11b['attributes'][_0x5d78('0x36')]?_0x49f11b[_0x5d78('0x34')]:_0x3e07d6['model'];if(_0xaf93f0[_0x5d78('0x2f')][_0x5d78('0xa3')]){_0x49f11b[_0x5d78('0xa4')]=[{'all':!![]}];}_0x49f11b=_[_0x5d78('0x8c')]({},_0x49f11b,_0xaf93f0[_0x5d78('0xa5')]);return db[_0x5d78('0x8d')][_0x5d78('0x54')](_0x49f11b)[_0x5d78('0x1e')](handleEntityNotFound(_0xd20ff3,null))[_0x5d78('0x1e')](respondWithResult(_0xd20ff3,null))[_0x5d78('0x2a')](handleError(_0xd20ff3,null));};exports[_0x5d78('0xa6')]=function(_0x455dc3,_0x44b9e3){return db[_0x5d78('0x8d')][_0x5d78('0xa6')](_0x455dc3[_0x5d78('0x63')],{})[_0x5d78('0x1e')](respondWithResult(_0x44b9e3,0xc9))['catch'](handleError(_0x44b9e3,null));};exports[_0x5d78('0x1d')]=function(_0x2140c3,_0x36e2c1){if(_0x2140c3[_0x5d78('0x63')]['id']){delete _0x2140c3['body']['id'];}return db['SmsInteraction'][_0x5d78('0x54')]({'where':{'id':_0x2140c3[_0x5d78('0xa0')]['id']}})[_0x5d78('0x1e')](handleEntityNotFound(_0x36e2c1,null))['then'](saveUpdates(_0x2140c3[_0x5d78('0x63')],null))[_0x5d78('0x1e')](respondWithResult(_0x36e2c1,null))[_0x5d78('0x2a')](handleError(_0x36e2c1,null));};exports[_0x5d78('0xa7')]=function(_0x5ab40a,_0x326544){return db[_0x5d78('0x8d')]['find']({'where':{'id':_0x5ab40a[_0x5d78('0xa0')]['id']}})['then'](handleEntityNotFound(_0x326544,null))[_0x5d78('0x1e')](removeEntity(_0x326544,null))[_0x5d78('0x2a')](handleError(_0x326544,null));};exports[_0x5d78('0xa8')]=function(_0x1bc897,_0x2ab93f){return db[_0x5d78('0x8d')][_0x5d78('0xa8')]()[_0x5d78('0x1e')](respondWithResult(_0x2ab93f,null))[_0x5d78('0x2a')](handleError(_0x2ab93f,null));};exports[_0x5d78('0xa9')]=function(_0x4e4d0e,_0x41daa5,_0x1a4931){return db[_0x5d78('0xaa')]['find']({'where':{'id':_0x4e4d0e[_0x5d78('0xa0')]['id']}})[_0x5d78('0x1e')](handleEntityNotFound(_0x41daa5,null))[_0x5d78('0x1e')](function(_0xf0afad){if(_0xf0afad){return _0xf0afad[_0x5d78('0xa9')](_0x4e4d0e[_0x5d78('0x63')][_0x5d78('0xab')],_['omit'](_0x4e4d0e[_0x5d78('0x63')],[_0x5d78('0xab'),'id'])||{});}})[_0x5d78('0x1e')](respondWithResult(_0x41daa5,null))['catch'](handleError(_0x41daa5,null));};exports[_0x5d78('0xac')]=function(_0x19f173,_0x567fa2,_0x5f2c6e){var _0x20d622={'raw':![],'where':{}};var _0x4fc3d3={};var _0xa34331={'count':0x0,'rows':[]};return db[_0x5d78('0x8d')]['findOne']({'where':{'id':_0x19f173[_0x5d78('0xa0')]['id']}})[_0x5d78('0x1e')](handleEntityNotFound(_0x567fa2,null))[_0x5d78('0x1e')](function(_0x417132){if(_0x417132){_0x4fc3d3['model']=_[_0x5d78('0x30')](db[_0x5d78('0xaa')]['rawAttributes']);_0x4fc3d3[_0x5d78('0x2f')]=_[_0x5d78('0x30')](_0x19f173[_0x5d78('0x2f')]);_0x4fc3d3[_0x5d78('0x31')]=_[_0x5d78('0x32')](_0x4fc3d3['model'],_0x4fc3d3['query']);_0x20d622[_0x5d78('0x34')]=_[_0x5d78('0x32')](_0x4fc3d3[_0x5d78('0x33')],qs['fields'](_0x19f173[_0x5d78('0x2f')][_0x5d78('0x35')]));_0x20d622[_0x5d78('0x34')]=_0x20d622[_0x5d78('0x34')][_0x5d78('0x36')]?_0x20d622['attributes']:_0x4fc3d3[_0x5d78('0x33')];if(!_0x19f173[_0x5d78('0x2f')]['hasOwnProperty'](_0x5d78('0x38'))){_0x20d622[_0x5d78('0x19')]=qs['limit'](_0x19f173[_0x5d78('0x2f')]['limit']);_0x20d622[_0x5d78('0x39')]=qs[_0x5d78('0x39')](_0x19f173[_0x5d78('0x2f')][_0x5d78('0x39')]);}_0x20d622['order']=qs[_0x5d78('0x3a')](_0x19f173[_0x5d78('0x2f')][_0x5d78('0x3a')]);_0x20d622[_0x5d78('0x3b')]=qs[_0x5d78('0x31')](_[_0x5d78('0x3c')](_0x19f173['query'],_0x4fc3d3[_0x5d78('0x31')]));_0x20d622[_0x5d78('0x3b')][_0x5d78('0x9d')]=_0x417132['id'];if(_0x19f173[_0x5d78('0x2f')][_0x5d78('0x75')]){_0x20d622[_0x5d78('0x3b')]=_[_0x5d78('0x8c')](_0x20d622[_0x5d78('0x3b')],{'$or':_['map'](_0x20d622[_0x5d78('0x34')],function(_0x69cd89){var _0x2be710={};_0x2be710[_0x69cd89]={'$like':'%'+_0x19f173[_0x5d78('0x2f')][_0x5d78('0x75')]+'%'};return _0x2be710;})});}if(_0x19f173[_0x5d78('0x2f')][_0x5d78('0xad')]){var _0x1a08c5=_0x19f173[_0x5d78('0x2f')][_0x5d78('0xad')][_0x5d78('0x28')](',');var _0x30cfef={};_0x30cfef[_0x1a08c5[0x0]]={'$gte':moment(_0x1a08c5[0x1])[_0x5d78('0xae')](_0x5d78('0xaf'))};_0x20d622['where']=_[_0x5d78('0x8c')](_0x20d622[_0x5d78('0x3b')],_0x30cfef);}_0x20d622=_[_0x5d78('0x8c')]({},_0x20d622,_0x19f173[_0x5d78('0xa5')]);return db[_0x5d78('0xaa')]['count']({'where':_0x20d622['where']})[_0x5d78('0x1e')](function(_0x2b3ad7){_0xa34331[_0x5d78('0x18')]=_0x2b3ad7;if(_0x19f173[_0x5d78('0x2f')]['includeAll']){_0x20d622[_0x5d78('0xa4')]=[{'all':!![]}];}return db['SmsMessage'][_0x5d78('0xb0')](_0x20d622);})[_0x5d78('0x1e')](function(_0x57bf81){_0xa34331[_0x5d78('0xb1')]=_0x57bf81;return _0xa34331;});}})[_0x5d78('0x1e')](respondWithFilteredResult(_0x567fa2,_0x20d622))['catch'](handleError(_0x567fa2,null));};exports['addTags']=function(_0x52f3fe,_0x5d50ec,_0x5cc174){return db[_0x5d78('0x8d')][_0x5d78('0x54')]({'where':{'id':_0x52f3fe[_0x5d78('0xa0')]['id']}})[_0x5d78('0x1e')](handleEntityNotFound(_0x5d50ec,null))[_0x5d78('0x1e')](function(_0x3c5110){if(_0x3c5110){return _0x3c5110[_0x5d78('0xb2')](_0x52f3fe[_0x5d78('0x63')][_0x5d78('0xab')],_['omit'](_0x52f3fe[_0x5d78('0x63')],[_0x5d78('0xab'),'id'])||{})[_0x5d78('0xb3')](function(){return db['Tag'][_0x5d78('0xb0')]({'attributes':['id','name','color'],'where':{'id':_0x52f3fe[_0x5d78('0x63')][_0x5d78('0xab')]}});})[_0x5d78('0x1e')](function(_0x19bc9a){socket[_0x5d78('0xb4')](_0x5d78('0xb5'),{'id':Number(_0x52f3fe[_0x5d78('0xa0')]['id']),'tags':_0x19bc9a||[]});return{'id':Number(_0x52f3fe[_0x5d78('0xa0')]['id']),'tags':_0x19bc9a||[]};});}})['then'](respondWithResult(_0x5d50ec,null))[_0x5d78('0x2a')](handleError(_0x5d50ec,null));};exports[_0x5d78('0xb6')]=function(_0x3037a5,_0x3dd82a,_0x3954b6){return db['SmsInteraction'][_0x5d78('0x54')]({'where':{'id':_0x3037a5['params']['id']}})[_0x5d78('0x1e')](handleEntityNotFound(_0x3dd82a,null))[_0x5d78('0x1e')](function(_0x437c34){if(_0x437c34){return _0x437c34['removeTags'](_0x3037a5[_0x5d78('0x2f')][_0x5d78('0xab')]);}})[_0x5d78('0x1e')](respondWithStatusCode(_0x3dd82a,null))['catch'](handleError(_0x3dd82a,null));};exports[_0x5d78('0xb7')]=function(_0x370561,_0x32f14c){var _0x2231fa=moment()[_0x5d78('0xb8')]()[_0x5d78('0x8a')]();var _0x10214b=path[_0x5d78('0xb9')](config[_0x5d78('0xba')],_0x5d78('0xbb'),'files',_0x5d78('0xbc'));var _0x559c72=path[_0x5d78('0xb9')](config['root'],'server',_0x5d78('0xbd'),_0x5d78('0xbe'));var _0x2a4689=path[_0x5d78('0xb9')](_0x10214b,_0x2231fa);var _0x388a5a=util['format'](_0x5d78('0xbf'),_0x370561[_0x5d78('0xa0')]['id'],_0x2231fa);var _0x350e5c=path[_0x5d78('0xb9')](_0x10214b,_0x388a5a);var _0xa11f28=[];_0xa11f28[_0x5d78('0x29')]({'model':db[_0x5d78('0x61')],'as':_0x5d78('0x61'),'attributes':['id',_0x5d78('0x25')],'raw':!![]});_0xa11f28[_0x5d78('0x29')]({'model':db[_0x5d78('0xc0')],'as':_0x5d78('0x58'),'attributes':['id','firstName',_0x5d78('0xc1')],'raw':!![]});var _0x29df11=[{'model':db[_0x5d78('0xaa')],'as':'Messages','attributes':['id',_0x5d78('0x63'),_0x5d78('0x6a'),_0x5d78('0xc2'),'secret',_0x5d78('0x71')],'include':_0xa11f28}];_0x29df11['push']({'model':db[_0x5d78('0xc3')],'as':_0x5d78('0xc4'),'attributes':['id',_0x5d78('0x22')]});_0x29df11['push']({'model':db['User'],'as':_0x5d78('0xc5'),'attributes':['id',_0x5d78('0x25')]});return db[_0x5d78('0x8d')][_0x5d78('0x54')]({'where':{'id':_0x370561['params']['id']},'include':_0x29df11})[_0x5d78('0x1e')](handleEntityNotFound(_0x32f14c,null))['then'](function(_0x4d440d){if(_0x4d440d){var _0x4e26e2=_0x4d440d[_0x5d78('0xc6')]({'plain':!![]});fs[_0x5d78('0xc7')](_0x2a4689);var _0x4fae34={'format':'A4','border':_0x5d78('0xc8'),'header':{'height':'40px','contents':{'first':_0x5d78('0xc9')}},'footer':{'height':_0x5d78('0xca'),'contents':{'default':util[_0x5d78('0xae')]('<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'](_0x5d78('0xcb'),_0x5d78('0xcc'),_0x4e26e2['id']),moment()[_0x5d78('0xae')](_0x5d78('0xcd'))['toString']())}}};var _0x1da21a={'channel':_0x5d78('0xcc'),'account':_0x4e26e2[_0x5d78('0xc4')][_0x5d78('0x22')],'agent':_0x4e26e2[_0x5d78('0xc5')]?_0x4e26e2[_0x5d78('0xc5')][_0x5d78('0x25')]:'N.A.','createdAt':moment(_0x4e26e2[_0x5d78('0x6a')])['format']('YYYY-MM-DD\x20HH:mm:ss')[_0x5d78('0x8a')](),'closedAt':_0x4e26e2['closed']?moment(_0x4e26e2[_0x5d78('0xce')])[_0x5d78('0xae')]('YYYY-MM-DD\x20HH:mm:ss')[_0x5d78('0x8a')]():'','disposition':_0x4e26e2[_0x5d78('0xcf')],'messages':_(_0x4e26e2[_0x5d78('0xd0')])[_0x5d78('0x75')]({'secret':![]})[_0x5d78('0x24')](function(_0x11d2c2){return{'date':moment(_0x11d2c2[_0x5d78('0x6a')])[_0x5d78('0xae')](_0x5d78('0xaf'))[_0x5d78('0x8a')](),'sender':_0x11d2c2[_0x5d78('0xc2')]===_0x5d78('0xd1')?_0x11d2c2['User']?_0x11d2c2[_0x5d78('0x61')]['fullname']:'System':_0x11d2c2[_0x5d78('0x58')][_0x5d78('0xd2')]+(_0x11d2c2[_0x5d78('0x58')]['lastName']?'\x20'+_0x11d2c2['Contact'][_0x5d78('0xc1')]:''),'body':_0x11d2c2[_0x5d78('0x63')],'direction':_0x11d2c2[_0x5d78('0xc2')]==='out'?'A':'C','secret':_0x11d2c2[_0x5d78('0xd3')],'read':_0x11d2c2[_0x5d78('0x71')]};})[_0x5d78('0x56')]()};return ejs['renderFile'](path[_0x5d78('0xb9')](config['root'],_0x5d78('0xbb'),_0x5d78('0xd4'),_0x5d78('0xd5')),{'interaction':_0x1da21a})[_0x5d78('0x1e')](function(_0x5ca23b){return new BPromise(function(_0x32d054,_0x145f01){pdf[_0x5d78('0xa6')](_0x5ca23b,_0x4fae34)['toFile'](path[_0x5d78('0xb9')](_0x2a4689,_0x5d78('0xd6')+_0x4e26e2['id']+'-'+_0x2231fa+_0x5d78('0xd7')),function(_0xdd9cec,_0x555032){if(_0xdd9cec)return _0x145f01(_0xdd9cec);_0x32d054(_0x555032);});});})[_0x5d78('0x1e')](function(){return new BPromise(function(_0x3aedd5,_0x28a3d1){zipdir(_0x2a4689,{'saveTo':_0x350e5c},function(_0x2995ed,_0xaf0a27){if(_0x2995ed)return _0x28a3d1(_0x2995ed);return _0x3aedd5(_0xaf0a27);});})[_0x5d78('0x1e')](function(){return new BPromise(function(_0x39dffe,_0x2cec8d){rimraf(_0x2a4689,function(_0x2c924b){if(_0x2c924b)_0x2cec8d(_0x2c924b);return _0x39dffe();});});})[_0x5d78('0x1e')](function(){return _0x32f14c['download'](_0x350e5c,_0x388a5a,function(_0xa30db7){if(_0xa30db7){console['log']('err',_0xa30db7);}else{fs[_0x5d78('0xd8')](_0x350e5c);}});});});}else{return _0x32f14c['sendStatus'](0xc8);}})[_0x5d78('0x2a')](handleError(_0x32f14c,null));};