db3b6ea90d2c1834fd0404d52253cbfca12ea991
[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 _0x3667=['end','json','count','offset','set','Content-Range','reject','save','update','then','destroy','sendStatus','error','stack','name','send','Users','map','fullname','split','forEach','Tags','TagIds','catch','index','SmsInteraction','rawAttributes','type','model','query','filters','attributes','intersection','fields','hasOwnProperty','nolimit','limit','order','where','select','field','color','from','tools_tags','u.id','ui.SmsInteractionId','user_has_sms_interactions','left_join','users','cm_contacts','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','sms_accounts','sms_messages','me.SmsInteractionId\x20=\x20i.id','sms_interaction_has_tags','it.SmsInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','sqlOperator','conditions','length','find','unreadMessages','value','`\x20>\x200','operator','$substring','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','text','start','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','UserId','body','keys','compact','SmsAccountId','concat','createdAt','parse','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','\x20=\x20?','read','`unreadMessages`\x20=\x200','having','`unreadMessages`\x20>\x200','tag','filter','replace','isNumeric','i.id\x20LIKE\x20?','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','group','i.id','Sequelize','QueryTypes','SELECT','clone','DESC','isEmpty','t.id\x20IN\x20?','resolve','journey','i.SmsAccountId\x20IS\x20NOT\x20NULL','user','getSmsAccounts','i.SmsAccountId\x20IS\x20NULL','i.SmsAccountId\x20IN\x20?','sequelize','toString','merge','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','i.*','c.firstName','Contact.firstName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.SmsInteractionId\x20IN\x20?','groupBy','SmsInteractionId','push','all','rows','show','params','include','create','describe','addMessage','ids','omit','getMessages','findOne','SmsMessage','sort','YYYY-MM-DD\x20HH:mm:ss','options','includeAll','findAll','addTags','setTags','spread','emit','download','unix','root','tmp','server','files','attachments','join','format','transcript-%d-%s.zip','User','CmContact','firstName','lastName','Messages','direction','secret','Account','Owner','get','mkdirSync','10px','40px','30px','Sms','YYYY-MM-DD','closed','closedAt','disposition','System','Contact','out','renderFile','views','downloadInteraction.html','toFile','transcript-','log','err','unlinkSync','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','util','path','sox','to-csv','ejs','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./smsInteraction.socket','register','status'];(function(_0x2a9197,_0x5225eb){var _0x588c8a=function(_0x4698ee){while(--_0x4698ee){_0x2a9197['push'](_0x2a9197['shift']());}};_0x588c8a(++_0x5225eb);}(_0x3667,0xcd));var _0x7366=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x3667[_0x3dd15e];return _0x231fd0;};'use strict';var pdf=require(_0x7366('0x0'));var emlformat=require(_0x7366('0x1'));var rimraf=require(_0x7366('0x2'));var zipdir=require(_0x7366('0x3'));var jsonpatch=require(_0x7366('0x4'));var rp=require('request-promise');var moment=require(_0x7366('0x5'));var BPromise=require(_0x7366('0x6'));var Mustache=require('mustache');var util=require(_0x7366('0x7'));var path=require(_0x7366('0x8'));var sox=require(_0x7366('0x9'));var csv=require(_0x7366('0xa'));var ejs=require(_0x7366('0xb'));var fs=require('fs');var _=require('lodash');var squel=require(_0x7366('0xc'));var crypto=require(_0x7366('0xd'));var jsforce=require(_0x7366('0xe'));var deskjs=require(_0x7366('0xf'));var toCsv=require(_0x7366('0xa'));var querystring=require(_0x7366('0x10'));var Papa=require(_0x7366('0x11'));var Redis=require(_0x7366('0x12'));var authService=require(_0x7366('0x13'));var qs=require(_0x7366('0x14'));var as=require(_0x7366('0x15'));var hardwareService=require(_0x7366('0x16'));var logger=require(_0x7366('0x17'))(_0x7366('0x18'));var utils=require(_0x7366('0x19'));var config=require(_0x7366('0x1a'));var db=require(_0x7366('0x1b'))['db'];config[_0x7366('0x1c')]=_[_0x7366('0x1d')](config[_0x7366('0x1c')],{'host':_0x7366('0x1e'),'port':0x18eb});var socket=require(_0x7366('0x1f'))(new Redis(config[_0x7366('0x1c')]));require(_0x7366('0x20'))[_0x7366('0x21')](socket);function respondWithStatusCode(_0x27500c,_0x22562f){_0x22562f=_0x22562f||0xcc;return function(_0xf4114){if(_0xf4114){return _0x27500c['sendStatus'](_0x22562f);}return _0x27500c[_0x7366('0x22')](_0x22562f)[_0x7366('0x23')]();};}function respondWithResult(_0x338719,_0x2c0422){_0x2c0422=_0x2c0422||0xc8;return function(_0xe2c87b){if(_0xe2c87b){return _0x338719[_0x7366('0x22')](_0x2c0422)[_0x7366('0x24')](_0xe2c87b);}};}function respondWithFilteredResult(_0x22d348,_0x83e5d5){return function(_0x41113f){if(_0x41113f){var _0x1a71f5=_0x41113f[_0x7366('0x25')],_0x49e50b=_0x83e5d5[_0x7366('0x26')],_0x208ac8=_0x83e5d5[_0x7366('0x26')]+_0x83e5d5['limit'],_0x4ffbc7;if(_0x208ac8>=_0x1a71f5){_0x208ac8=_0x1a71f5;_0x4ffbc7=0xc8;}else{_0x4ffbc7=0xce;}_0x22d348[_0x7366('0x22')](_0x4ffbc7);return _0x22d348[_0x7366('0x27')](_0x7366('0x28'),_0x49e50b+'-'+_0x208ac8+'/'+_0x1a71f5)['json'](_0x41113f);}return null;};}function patchUpdates(_0x16e038){return function(_0x1946c6){try{jsonpatch['apply'](_0x1946c6,_0x16e038,!![]);}catch(_0x3bfbca){return BPromise[_0x7366('0x29')](_0x3bfbca);}return _0x1946c6[_0x7366('0x2a')]();};}function saveUpdates(_0x1a12d2,_0x3c30a2){return function(_0x1d3139){if(_0x1d3139){return _0x1d3139[_0x7366('0x2b')](_0x1a12d2)[_0x7366('0x2c')](function(_0x2095a1){return _0x2095a1;});}return null;};}function removeEntity(_0x301220,_0x12aed6){return function(_0x1dc875){if(_0x1dc875){return _0x1dc875[_0x7366('0x2d')]()['then'](function(){_0x301220[_0x7366('0x22')](0xcc)['end']();});}};}function handleEntityNotFound(_0x379146,_0x4ab987){return function(_0x5e30fb){if(!_0x5e30fb){_0x379146[_0x7366('0x2e')](0x194);}return _0x5e30fb;};}function handleError(_0x4d4cb5,_0x254374){_0x254374=_0x254374||0x1f4;return function(_0x4ac138){logger[_0x7366('0x2f')](_0x4ac138[_0x7366('0x30')]);if(_0x4ac138['name']){delete _0x4ac138[_0x7366('0x31')];}_0x4d4cb5['status'](_0x254374)[_0x7366('0x32')](_0x4ac138);};}function getInteractionUsers(_0x2b61af,_0x4a4e67){return new BPromise(function(_0x3cef4a,_0x507baf){try{if(_0x4a4e67[_0x2b61af['id']]){_0x2b61af[_0x7366('0x33')]=_[_0x7366('0x34')](_0x4a4e67[_0x2b61af['id']],function(_0x39d6ea){return{'id':_0x39d6ea['id'],'fullname':_0x39d6ea[_0x7366('0x35')]};});}}catch(_0x2dda4b){_0x507baf(_0x2dda4b);}_0x3cef4a(_0x2b61af);});}function getInteractionTags(_0x5e075c,_0x166628){return new BPromise(function(_0x447807,_0x538d42){try{if(_0x5e075c['TagIds']){_0x5e075c['Tags']=[];_0x5e075c['TagIds'][_0x7366('0x36')](',')[_0x7366('0x37')](function(_0x163a29){_0x5e075c[_0x7366('0x38')]['push'](_0x166628[_0x163a29]);});}delete _0x5e075c[_0x7366('0x39')];}catch(_0x2abf10){_0x538d42(_0x2abf10);}_0x447807(_0x5e075c);});}function updateSmsInteraction(_0xdaffd3,_0x21547f,_0x5214bc){return new BPromise(function(_0x3ab373,_0x311dab){return getInteractionUsers(_0xdaffd3,_0x5214bc)['then'](function(_0x2befc7){return getInteractionTags(_0x2befc7,_0x21547f);})[_0x7366('0x2c')](function(_0x1de991){_0x3ab373(_0x1de991);})[_0x7366('0x3a')](function(_0x7779c7){_0x311dab(_0x7779c7);});});}exports[_0x7366('0x3b')]=function(_0x3a69fa,_0x26858b){var _0x437713={},_0x59dead={},_0x45db2a={'count':0x0,'rows':[]};var _0x83b879=_['map'](db[_0x7366('0x3c')][_0x7366('0x3d')],function(_0x3ca8e9){return{'name':_0x3ca8e9['fieldName'],'type':_0x3ca8e9[_0x7366('0x3e')]['key']};});_0x59dead[_0x7366('0x3f')]=_['map'](_0x83b879,'name');_0x59dead[_0x7366('0x40')]=_['keys'](_0x3a69fa[_0x7366('0x40')]);_0x59dead[_0x7366('0x41')]=_['intersection'](_0x59dead[_0x7366('0x3f')],_0x59dead['query']);_0x437713[_0x7366('0x42')]=_[_0x7366('0x43')](_0x59dead[_0x7366('0x3f')],qs[_0x7366('0x44')](_0x3a69fa['query'][_0x7366('0x44')]));_0x437713[_0x7366('0x42')]=_0x437713[_0x7366('0x42')]['length']?_0x437713[_0x7366('0x42')]:_0x59dead[_0x7366('0x3f')];if(!_0x3a69fa[_0x7366('0x40')][_0x7366('0x45')](_0x7366('0x46'))){_0x437713[_0x7366('0x47')]=qs[_0x7366('0x47')](_0x3a69fa['query']['limit']);_0x437713[_0x7366('0x26')]=qs[_0x7366('0x26')](_0x3a69fa['query'][_0x7366('0x26')]);}_0x437713[_0x7366('0x48')]=qs['sort'](_0x3a69fa[_0x7366('0x40')]['sort']);_0x437713[_0x7366('0x49')]=qs[_0x7366('0x41')](_['pick'](_0x3a69fa['query'],_0x59dead[_0x7366('0x41')]),_0x83b879);var _0xedc3c7=[];var _0x2ac2e6=squel[_0x7366('0x4a')]()['field']('id')[_0x7366('0x4b')](_0x7366('0x31'))[_0x7366('0x4b')](_0x7366('0x4c'))[_0x7366('0x4d')](_0x7366('0x4e'));var _0x37fcd6=squel['select']()[_0x7366('0x4b')](_0x7366('0x4f'))[_0x7366('0x4b')]('u.fullname')[_0x7366('0x4b')](_0x7366('0x50'))['from'](_0x7366('0x51'),'ui')[_0x7366('0x52')](_0x7366('0x53'),'u','u.id\x20=\x20ui.UserId');var _0x1909d4=squel[_0x7366('0x4a')]()[_0x7366('0x4d')]('sms_interactions','i')[_0x7366('0x52')](_0x7366('0x54'),'c',_0x7366('0x55'))['left_join'](_0x7366('0x53'),'o',_0x7366('0x56'))[_0x7366('0x52')](_0x7366('0x57'),'a','a.id\x20=\x20i.SmsAccountId')[_0x7366('0x52')](_0x7366('0x58'),'me',_0x7366('0x59'))[_0x7366('0x52')](_0x7366('0x5a'),'it',_0x7366('0x5b'))[_0x7366('0x52')](_0x7366('0x4e'),'t',_0x7366('0x5c'));var _0x59f078=squel[_0x7366('0x5d')]();var _0x1b8dcd=[];var _0x5db903=squel[_0x7366('0x5d')]();var _0x33a804;if(_0x3a69fa['query'][_0x7366('0x5e')]){_0x33a804=as['parseSearch'](_0x3a69fa[_0x7366('0x40')][_0x7366('0x5e')]);var _0x1295ca=_0x33a804[_0x7366('0x5f')];for(var _0x588b31=0x0;_0x588b31<_0x33a804[_0x7366('0x60')][_0x7366('0x61')];_0x588b31++){var _0x390bd7=_0x33a804[_0x7366('0x60')][_0x588b31];var _0x1de0a7='i';var _0x2146dc=_[_0x7366('0x62')](_0x83b879,[_0x7366('0x31'),_0x390bd7[_0x7366('0x4b')]]);if(!_0x2146dc){switch(_0x390bd7[_0x7366('0x4b')]){case _0x7366('0x63'):if(_0x390bd7[_0x7366('0x64')]==0x1){_0x1909d4['having']('`'+_0x390bd7[_0x7366('0x4b')]+'`\x20=\x200');}else{_0x1909d4['having']('`'+_0x390bd7[_0x7366('0x4b')]+_0x7366('0x65'));}break;case'Contact':if(_0x390bd7[_0x7366('0x66')]===_0x7366('0x67')){if(_0x390bd7['value']['split']('\x20')[_0x7366('0x61')]>0x1){_0x59f078[_0x1295ca]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x7366('0x68')](_0x390bd7[_0x7366('0x64')]),null);}else{var _0x4ca4f7='%'+_0x390bd7[_0x7366('0x64')]+'%';_0x59f078[_0x1295ca](_0x7366('0x69'),_0x4ca4f7,_0x4ca4f7,_0x4ca4f7);}}else{_0x2146dc=_[_0x7366('0x62')](_0x83b879,['name',_0x7366('0x6a')]);_0x390bd7[_0x7366('0x4b')]=_0x7366('0x6a');_0x523016=as[_0x7366('0x6b')](_0x1de0a7,_0x2146dc['type'],_0x390bd7);_0x59f078[_0x1295ca](_0x523016[_0x7366('0x6c')],_0x523016[_0x7366('0x64')][_0x7366('0x6d')],_0x523016[_0x7366('0x64')][_0x7366('0x23')]);}break;case'Tag':var _0x1249a7=_0x390bd7[_0x7366('0x64')][_0x7366('0x36')](',')[_0x7366('0x34')](function(_0x54c117){return Number(_0x54c117);});_0x1249a7[_0x7366('0x37')](function(_0x5cbefc){_0x5db903['or'](_0x7366('0x6e'),'%,'+_0x5cbefc+',%');});_0x1b8dcd=_[_0x7366('0x6f')](_0x1b8dcd,_0x1249a7);break;case'User':if(_0x390bd7[_0x7366('0x66')]===_0x7366('0x67')){_0x59f078[_0x1295ca](_0x7366('0x70'),'%'+_0x390bd7[_0x7366('0x64')]+'%',null);}else{_0x2146dc=_['find'](_0x83b879,['name',_0x7366('0x71')]);_0x390bd7['field']=_0x7366('0x71');_0x523016=as[_0x7366('0x6b')](_0x1de0a7,_0x2146dc[_0x7366('0x3e')],_0x390bd7);_0x59f078[_0x1295ca](_0x523016[_0x7366('0x6c')],_0x523016[_0x7366('0x64')][_0x7366('0x6d')],_0x523016[_0x7366('0x64')][_0x7366('0x23')]);}break;case _0x7366('0x72'):_0x523016=as['buildExpression']('me',null,_0x390bd7);_0x59f078[_0x1295ca](_0x523016[_0x7366('0x6c')],_0x523016['value']['start'],_0x523016['value'][_0x7366('0x23')]);break;}}else{var _0x523016=as[_0x7366('0x6b')](_0x1de0a7,_0x2146dc['type'],_0x390bd7);_0x59f078[_0x1295ca](_0x523016[_0x7366('0x6c')],_0x523016['value'][_0x7366('0x6d')],_0x523016[_0x7366('0x64')]['end']);}}}else{var _0x4793c6=_(_0x3a69fa[_0x7366('0x40')])[_0x7366('0x73')]()[_0x7366('0x34')](function(_0x37a599){return _['some'](_0x83b879,[_0x7366('0x31'),_0x37a599])?_0x37a599:undefined;})[_0x7366('0x74')]()[_0x7366('0x64')]();if(!_['isEmpty'](_0x4793c6)){_0x4793c6['forEach'](function(_0x26ab9b){if(_0x26ab9b===_0x7366('0x75')){_0x1909d4[_0x7366('0x49')]('i.SmsAccountId\x20IN\x20?',[][_0x7366('0x76')](_0x3a69fa[_0x7366('0x40')][_0x26ab9b]));}else if(_0x26ab9b===_0x7366('0x77')){var _0x236180=JSON[_0x7366('0x78')](_0x3a69fa[_0x7366('0x40')][_0x26ab9b])[_0x7366('0x79')];var _0x38c65b=JSON[_0x7366('0x78')](_0x3a69fa[_0x7366('0x40')][_0x26ab9b])[_0x7366('0x7a')];_0x1909d4['where'](_0x7366('0x7b'),_0x236180,_0x38c65b);}else{if(_0x3a69fa[_0x7366('0x40')][_0x26ab9b]==='null'){_0x1909d4[_0x7366('0x49')]('i.'+_0x26ab9b+'\x20IS\x20NULL');}else{_0x1909d4['where']('i.'+_0x26ab9b+_0x7366('0x7c'),_0x3a69fa[_0x7366('0x40')][_0x26ab9b]);}}});}if(_0x3a69fa[_0x7366('0x40')][_0x7366('0x7d')]){if(_0x3a69fa[_0x7366('0x40')][_0x7366('0x7d')]==0x1){_0x1909d4['having'](_0x7366('0x7e'));}else{_0x1909d4[_0x7366('0x7f')](_0x7366('0x80'));}}if(_0x3a69fa['query'][_0x7366('0x81')]){_0x1b8dcd=_['isArray'](_0x3a69fa['query'][_0x7366('0x81')])?_0x3a69fa['query'][_0x7366('0x81')]:new Array(_0x3a69fa[_0x7366('0x40')][_0x7366('0x81')]);_0x1b8dcd[_0x7366('0x37')](function(_0x4b9045){_0x5db903['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x4b9045+',%');});}if(_0x3a69fa[_0x7366('0x40')][_0x7366('0x82')]){var _0x1a2c88=_0x3a69fa[_0x7366('0x40')]['filter'][_0x7366('0x83')]('\x5c','\x5c\x5c')['replace']('\x27\x27','\x27\x27\x27\x27');if(qs[_0x7366('0x84')](_0x1a2c88)){_0x59f078['or'](_0x7366('0x85'),_0x1a2c88+'%')['or']('i.phone\x20LIKE\x20?',_0x1a2c88+'%');}else{_0x59f078['or'](_0x7366('0x86'),qs[_0x7366('0x68')](_0x1a2c88))['or']('CONCAT(c.firstName,\x20\x27\x20\x27,\x20c.lastName)\x20LIKE\x20?',_0x1a2c88+'%');}}}_0x1909d4[_0x7366('0x49')](_0x59f078);_0x1909d4[_0x7366('0x87')](_0x7366('0x88'));var _0x3cad9e={'type':db[_0x7366('0x89')][_0x7366('0x8a')][_0x7366('0x8b')],'raw':!![]};var _0x16b3a=_0x1909d4[_0x7366('0x8c')]();_0x16b3a[_0x7366('0x4b')]('i.id');_0x16b3a['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x7366('0x63'));if(_0x437713[_0x7366('0x48')]){_0x437713[_0x7366('0x48')]['forEach'](function(_0x2754ae){_0x1909d4[_0x7366('0x48')]('i.'+_0x2754ae[0x0],_0x2754ae[0x1]===_0x7366('0x8d')?![]:!![]);});}if(!_[_0x7366('0x8e')](_0x1b8dcd)){_0x1909d4[_0x7366('0x7f')](_0x5db903);_0x16b3a['where'](_0x7366('0x8f'),_0x1b8dcd);}BPromise[_0x7366('0x90')]()['then'](function(){if(!_0x33a804){if(_0x3a69fa[_0x7366('0x40')][_0x7366('0x75')]||_0x3a69fa[_0x7366('0x40')][_0x7366('0x91')])return;_0x16b3a[_0x7366('0x49')]('i.SmsAccountId\x20IS\x20NOT\x20NULL');_0x1909d4['where'](_0x7366('0x92'));return;}return _0x3a69fa[_0x7366('0x93')][_0x7366('0x94')]({'attributes':['id'],'raw':!![]})[_0x7366('0x2c')](function(_0x3bc663){if(_[_0x7366('0x8e')](_0x3bc663)){_0x16b3a[_0x7366('0x49')](_0x7366('0x95'));_0x1909d4[_0x7366('0x49')](_0x7366('0x95'));}else{_0x16b3a[_0x7366('0x49')](_0x7366('0x96'),_[_0x7366('0x34')](_0x3bc663,'id'));_0x1909d4[_0x7366('0x49')]('i.SmsAccountId\x20IN\x20?',_[_0x7366('0x34')](_0x3bc663,'id'));}});})['then'](function(){db[_0x7366('0x97')]['query'](_0x16b3a[_0x7366('0x98')](),_0x3cad9e)['then'](function(_0x313478){_0x45db2a[_0x7366('0x25')]=_0x313478['length'];if(_0x45db2a[_0x7366('0x25')]===0x0)return[];return db[_0x7366('0x97')]['query'](_0x2ac2e6['toString'](),_0x3cad9e)[_0x7366('0x2c')](function(_0x1821e1){_0xedc3c7=_['keyBy'](_0x1821e1,'id');_0x3cad9e=_[_0x7366('0x99')](_0x3cad9e,{'model':db['SmsInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x3a69fa[_0x7366('0x40')]['fields']){_0x437713['attributes'][_0x7366('0x37')](function(_0x40a7a3){_0x1909d4[_0x7366('0x4b')]('i.'+_0x40a7a3);});}else{_0x1909d4['field'](_0x7366('0x9a'),_0x7366('0x63'));_0x1909d4[_0x7366('0x4b')]('a.key',_0x7366('0x9b'));_0x1909d4[_0x7366('0x4b')](_0x7366('0x9c'),_0x7366('0x9d'));_0x1909d4[_0x7366('0x4b')](_0x7366('0x9e'));_0x1909d4['field'](_0x7366('0x9f'),_0x7366('0xa0'));_0x1909d4[_0x7366('0x4b')]('c.lastName',_0x7366('0xa1'));_0x1909d4['field'](_0x7366('0xa2'),_0x7366('0xa3'));_0x1909d4[_0x7366('0x4b')](_0x7366('0xa4'),_0x7366('0xa5'));_0x1909d4[_0x7366('0x4b')](_0x7366('0xa6'),_0x7366('0xa7'));_0x1909d4[_0x7366('0x4b')](_0x7366('0xa8'),_0x7366('0xa9'));_0x1909d4[_0x7366('0x4b')](_0x7366('0xaa'),'Owner.fullname');_0x1909d4[_0x7366('0x4b')](_0x7366('0xab'),_0x7366('0xac'));_0x1909d4[_0x7366('0x4b')](_0x7366('0xad'),'TagIds');}if(_0x437713[_0x7366('0x47')])_0x1909d4[_0x7366('0x47')](_0x437713['limit']);if(_0x437713[_0x7366('0x26')])_0x1909d4[_0x7366('0x26')](_0x437713[_0x7366('0x26')]);return db['sequelize'][_0x7366('0x40')](_0x1909d4['toString'](),_0x3cad9e);})['then'](function(_0x5d3a75){_0x37fcd6[_0x7366('0x49')](_0x7366('0xae'),_[_0x7366('0x34')](_0x5d3a75,'id'));return db[_0x7366('0x97')][_0x7366('0x40')](_0x37fcd6[_0x7366('0x98')](),_0x3cad9e)['then'](function(_0x506c11){var _0x133be0=_[_0x7366('0xaf')](_0x506c11,_0x7366('0xb0'));var _0xe26771=[];_0x5d3a75['forEach'](function(_0x2c69bf){_0xe26771[_0x7366('0xb1')](updateSmsInteraction(_0x2c69bf,_0xedc3c7,_0x133be0));});return BPromise[_0x7366('0xb2')](_0xe26771);});});})[_0x7366('0x2c')](function(_0x12b3e2){_0x45db2a[_0x7366('0xb3')]=_0x12b3e2;return _0x45db2a;})['then'](respondWithFilteredResult(_0x26858b,_0x437713));})[_0x7366('0x3a')](handleError(_0x26858b,null));};exports[_0x7366('0xb4')]=function(_0x2e52a7,_0x33ae81){var _0x108dba={'raw':![],'where':{'id':_0x2e52a7[_0x7366('0xb5')]['id']}},_0x123d0a={};_0x123d0a['model']=_[_0x7366('0x73')](db[_0x7366('0x3c')]['rawAttributes']);_0x123d0a[_0x7366('0x40')]=_[_0x7366('0x73')](_0x2e52a7[_0x7366('0x40')]);_0x123d0a[_0x7366('0x41')]=_[_0x7366('0x43')](_0x123d0a['model'],_0x123d0a['query']);_0x108dba['attributes']=_[_0x7366('0x43')](_0x123d0a[_0x7366('0x3f')],qs[_0x7366('0x44')](_0x2e52a7[_0x7366('0x40')][_0x7366('0x44')]));_0x108dba[_0x7366('0x42')]=_0x108dba[_0x7366('0x42')][_0x7366('0x61')]?_0x108dba['attributes']:_0x123d0a[_0x7366('0x3f')];if(_0x2e52a7[_0x7366('0x40')]['includeAll']){_0x108dba[_0x7366('0xb6')]=[{'all':!![]}];}_0x108dba=_['merge']({},_0x108dba,_0x2e52a7['options']);return db['SmsInteraction'][_0x7366('0x62')](_0x108dba)[_0x7366('0x2c')](handleEntityNotFound(_0x33ae81,null))[_0x7366('0x2c')](respondWithResult(_0x33ae81,null))[_0x7366('0x3a')](handleError(_0x33ae81,null));};exports[_0x7366('0xb7')]=function(_0x29640b,_0x313ea8){return db[_0x7366('0x3c')][_0x7366('0xb7')](_0x29640b[_0x7366('0x72')],{})['then'](respondWithResult(_0x313ea8,0xc9))[_0x7366('0x3a')](handleError(_0x313ea8,null));};exports[_0x7366('0x2b')]=function(_0x5e0556,_0x57df7b){if(_0x5e0556[_0x7366('0x72')]['id']){delete _0x5e0556[_0x7366('0x72')]['id'];}return db[_0x7366('0x3c')][_0x7366('0x62')]({'where':{'id':_0x5e0556[_0x7366('0xb5')]['id']}})['then'](handleEntityNotFound(_0x57df7b,null))[_0x7366('0x2c')](saveUpdates(_0x5e0556[_0x7366('0x72')],null))[_0x7366('0x2c')](respondWithResult(_0x57df7b,null))[_0x7366('0x3a')](handleError(_0x57df7b,null));};exports[_0x7366('0x2d')]=function(_0x57a6b7,_0x18c2bf){return db[_0x7366('0x3c')][_0x7366('0x62')]({'where':{'id':_0x57a6b7[_0x7366('0xb5')]['id']}})[_0x7366('0x2c')](handleEntityNotFound(_0x18c2bf,null))[_0x7366('0x2c')](removeEntity(_0x18c2bf,null))[_0x7366('0x3a')](handleError(_0x18c2bf,null));};exports[_0x7366('0xb8')]=function(_0x5c1ec2,_0x544935){return db[_0x7366('0x3c')][_0x7366('0xb8')]()[_0x7366('0x2c')](respondWithResult(_0x544935,null))[_0x7366('0x3a')](handleError(_0x544935,null));};exports[_0x7366('0xb9')]=function(_0x36fdb0,_0x1844f8,_0x31138d){return db['SmsMessage'][_0x7366('0x62')]({'where':{'id':_0x36fdb0['params']['id']}})[_0x7366('0x2c')](handleEntityNotFound(_0x1844f8,null))[_0x7366('0x2c')](function(_0x172ee4){if(_0x172ee4){return _0x172ee4[_0x7366('0xb9')](_0x36fdb0[_0x7366('0x72')][_0x7366('0xba')],_[_0x7366('0xbb')](_0x36fdb0[_0x7366('0x72')],[_0x7366('0xba'),'id'])||{});}})[_0x7366('0x2c')](respondWithResult(_0x1844f8,null))[_0x7366('0x3a')](handleError(_0x1844f8,null));};exports[_0x7366('0xbc')]=function(_0x576751,_0x1acf3b,_0xd4246a){var _0x2ff830={'raw':![],'where':{}};var _0x145519={};var _0x3c36db={'count':0x0,'rows':[]};return db[_0x7366('0x3c')][_0x7366('0xbd')]({'where':{'id':_0x576751[_0x7366('0xb5')]['id']}})['then'](handleEntityNotFound(_0x1acf3b,null))[_0x7366('0x2c')](function(_0x2e0ccb){if(_0x2e0ccb){_0x145519[_0x7366('0x3f')]=_[_0x7366('0x73')](db[_0x7366('0xbe')][_0x7366('0x3d')]);_0x145519[_0x7366('0x40')]=_[_0x7366('0x73')](_0x576751[_0x7366('0x40')]);_0x145519[_0x7366('0x41')]=_[_0x7366('0x43')](_0x145519[_0x7366('0x3f')],_0x145519[_0x7366('0x40')]);_0x2ff830['attributes']=_[_0x7366('0x43')](_0x145519[_0x7366('0x3f')],qs['fields'](_0x576751['query']['fields']));_0x2ff830['attributes']=_0x2ff830[_0x7366('0x42')]['length']?_0x2ff830[_0x7366('0x42')]:_0x145519[_0x7366('0x3f')];if(!_0x576751['query'][_0x7366('0x45')](_0x7366('0x46'))){_0x2ff830[_0x7366('0x47')]=qs['limit'](_0x576751[_0x7366('0x40')][_0x7366('0x47')]);_0x2ff830['offset']=qs[_0x7366('0x26')](_0x576751[_0x7366('0x40')][_0x7366('0x26')]);}_0x2ff830[_0x7366('0x48')]=qs[_0x7366('0xbf')](_0x576751[_0x7366('0x40')]['sort']);_0x2ff830[_0x7366('0x49')]=qs[_0x7366('0x41')](_['pick'](_0x576751[_0x7366('0x40')],_0x145519[_0x7366('0x41')]));_0x2ff830[_0x7366('0x49')]['SmsInteractionId']=_0x2e0ccb['id'];if(_0x576751[_0x7366('0x40')][_0x7366('0x82')]){_0x2ff830['where']=_[_0x7366('0x99')](_0x2ff830[_0x7366('0x49')],{'$or':_[_0x7366('0x34')](_0x2ff830[_0x7366('0x42')],function(_0x54d697){var _0x4aaba8={};_0x4aaba8[_0x54d697]={'$like':'%'+_0x576751[_0x7366('0x40')][_0x7366('0x82')]+'%'};return _0x4aaba8;})});}if(_0x576751['query']['$gte']){var _0x4f0e41=_0x576751[_0x7366('0x40')][_0x7366('0x79')]['split'](',');var _0x20930e={};_0x20930e[_0x4f0e41[0x0]]={'$gte':moment(_0x4f0e41[0x1])['format'](_0x7366('0xc0'))};_0x2ff830[_0x7366('0x49')]=_[_0x7366('0x99')](_0x2ff830['where'],_0x20930e);}_0x2ff830=_[_0x7366('0x99')]({},_0x2ff830,_0x576751[_0x7366('0xc1')]);return db[_0x7366('0xbe')]['count']({'where':_0x2ff830[_0x7366('0x49')]})[_0x7366('0x2c')](function(_0x20a10b){_0x3c36db[_0x7366('0x25')]=_0x20a10b;if(_0x576751[_0x7366('0x40')][_0x7366('0xc2')]){_0x2ff830[_0x7366('0xb6')]=[{'all':!![]}];}return db[_0x7366('0xbe')][_0x7366('0xc3')](_0x2ff830);})[_0x7366('0x2c')](function(_0x58a5b5){_0x3c36db[_0x7366('0xb3')]=_0x58a5b5;return _0x3c36db;});}})['then'](respondWithFilteredResult(_0x1acf3b,_0x2ff830))[_0x7366('0x3a')](handleError(_0x1acf3b,null));};exports[_0x7366('0xc4')]=function(_0x26ef04,_0x328b4a,_0x17b9e5){return db[_0x7366('0x3c')][_0x7366('0x62')]({'where':{'id':_0x26ef04['params']['id']}})[_0x7366('0x2c')](handleEntityNotFound(_0x328b4a,null))[_0x7366('0x2c')](function(_0x540c12){if(_0x540c12){return _0x540c12[_0x7366('0xc5')](_0x26ef04[_0x7366('0x72')][_0x7366('0xba')],_[_0x7366('0xbb')](_0x26ef04[_0x7366('0x72')],[_0x7366('0xba'),'id'])||{})[_0x7366('0xc6')](function(){return db['Tag'][_0x7366('0xc3')]({'attributes':['id',_0x7366('0x31'),'color'],'where':{'id':_0x26ef04[_0x7366('0x72')][_0x7366('0xba')]}});})[_0x7366('0x2c')](function(_0x49139e){socket[_0x7366('0xc7')]('smsInteractionTags:save',{'id':Number(_0x26ef04[_0x7366('0xb5')]['id']),'tags':_0x49139e||[]});return{'id':Number(_0x26ef04[_0x7366('0xb5')]['id']),'tags':_0x49139e||[]};});}})[_0x7366('0x2c')](respondWithResult(_0x328b4a,null))['catch'](handleError(_0x328b4a,null));};exports['removeTags']=function(_0x19414f,_0x432daf,_0x1d5a79){return db[_0x7366('0x3c')][_0x7366('0x62')]({'where':{'id':_0x19414f[_0x7366('0xb5')]['id']}})[_0x7366('0x2c')](handleEntityNotFound(_0x432daf,null))[_0x7366('0x2c')](function(_0x433172){if(_0x433172){return _0x433172['removeTags'](_0x19414f[_0x7366('0x40')][_0x7366('0xba')]);}})[_0x7366('0x2c')](respondWithStatusCode(_0x432daf,null))['catch'](handleError(_0x432daf,null));};exports[_0x7366('0xc8')]=function(_0x1f21e7,_0x652bd2){var _0x4c42fa=moment()[_0x7366('0xc9')]()['toString']();var _0x3a9cdd=path['join'](config[_0x7366('0xca')],'server','files',_0x7366('0xcb'));var _0x368452=path['join'](config[_0x7366('0xca')],_0x7366('0xcc'),_0x7366('0xcd'),_0x7366('0xce'));var _0x3774be=path[_0x7366('0xcf')](_0x3a9cdd,_0x4c42fa);var _0x41d8ae=util[_0x7366('0xd0')](_0x7366('0xd1'),_0x1f21e7[_0x7366('0xb5')]['id'],_0x4c42fa);var _0xbeb315=path['join'](_0x3a9cdd,_0x41d8ae);var _0x3dd418=[];_0x3dd418['push']({'model':db[_0x7366('0xd2')],'as':_0x7366('0xd2'),'attributes':['id',_0x7366('0x35')],'raw':!![]});_0x3dd418[_0x7366('0xb1')]({'model':db[_0x7366('0xd3')],'as':'Contact','attributes':['id',_0x7366('0xd4'),_0x7366('0xd5')],'raw':!![]});var _0x237485=[{'model':db[_0x7366('0xbe')],'as':_0x7366('0xd6'),'attributes':['id',_0x7366('0x72'),_0x7366('0x77'),_0x7366('0xd7'),_0x7366('0xd8'),'read'],'include':_0x3dd418}];_0x237485['push']({'model':db['SmsAccount'],'as':_0x7366('0xd9'),'attributes':['id','name']});_0x237485['push']({'model':db[_0x7366('0xd2')],'as':_0x7366('0xda'),'attributes':['id',_0x7366('0x35')]});return db[_0x7366('0x3c')][_0x7366('0x62')]({'where':{'id':_0x1f21e7[_0x7366('0xb5')]['id']},'include':_0x237485})['then'](handleEntityNotFound(_0x652bd2,null))[_0x7366('0x2c')](function(_0x5ed9eb){if(_0x5ed9eb){var _0x4c6f72=_0x5ed9eb[_0x7366('0xdb')]({'plain':!![]});fs[_0x7366('0xdc')](_0x3774be);var _0x17571a={'format':'A4','border':_0x7366('0xdd'),'header':{'height':_0x7366('0xde'),'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':_0x7366('0xdf'),'contents':{'default':util[_0x7366('0xd0')]('<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[_0x7366('0xd0')]('%s\x20#%d',_0x7366('0xe0'),_0x4c6f72['id']),moment()[_0x7366('0xd0')](_0x7366('0xe1'))[_0x7366('0x98')]())}}};var _0x402781={'channel':_0x7366('0xe0'),'account':_0x4c6f72[_0x7366('0xd9')]['name'],'agent':_0x4c6f72[_0x7366('0xda')]?_0x4c6f72[_0x7366('0xda')]['fullname']:'N.A.','createdAt':moment(_0x4c6f72[_0x7366('0x77')])[_0x7366('0xd0')](_0x7366('0xc0'))[_0x7366('0x98')](),'closedAt':_0x4c6f72[_0x7366('0xe2')]?moment(_0x4c6f72[_0x7366('0xe3')])['format'](_0x7366('0xc0'))[_0x7366('0x98')]():'','disposition':_0x4c6f72[_0x7366('0xe4')],'messages':_(_0x4c6f72[_0x7366('0xd6')])['filter']({'secret':![]})[_0x7366('0x34')](function(_0x33d651){return{'date':moment(_0x33d651[_0x7366('0x77')])[_0x7366('0xd0')](_0x7366('0xc0'))[_0x7366('0x98')](),'sender':_0x33d651[_0x7366('0xd7')]==='out'?_0x33d651[_0x7366('0xd2')]?_0x33d651['User']['fullname']:_0x7366('0xe5'):_0x33d651['Contact'][_0x7366('0xd4')]+(_0x33d651[_0x7366('0xe6')]['lastName']?'\x20'+_0x33d651[_0x7366('0xe6')][_0x7366('0xd5')]:''),'body':_0x33d651[_0x7366('0x72')],'direction':_0x33d651[_0x7366('0xd7')]===_0x7366('0xe7')?'A':'C','secret':_0x33d651['secret'],'read':_0x33d651['read']};})[_0x7366('0x64')]()};return ejs[_0x7366('0xe8')](path['join'](config['root'],_0x7366('0xcc'),_0x7366('0xe9'),_0x7366('0xea')),{'interaction':_0x402781})[_0x7366('0x2c')](function(_0x286bb4){return new BPromise(function(_0x5c264f,_0x2e9f64){pdf['create'](_0x286bb4,_0x17571a)[_0x7366('0xeb')](path[_0x7366('0xcf')](_0x3774be,_0x7366('0xec')+_0x4c6f72['id']+'-'+_0x4c42fa+'.pdf'),function(_0x28096d,_0x1d8808){if(_0x28096d)return _0x2e9f64(_0x28096d);_0x5c264f(_0x1d8808);});});})[_0x7366('0x2c')](function(){return new BPromise(function(_0x5660cf,_0x42e7ad){zipdir(_0x3774be,{'saveTo':_0xbeb315},function(_0x37c6b2,_0x56e058){if(_0x37c6b2)return _0x42e7ad(_0x37c6b2);return _0x5660cf(_0x56e058);});})[_0x7366('0x2c')](function(){return new BPromise(function(_0x581897,_0x3de2a6){rimraf(_0x3774be,function(_0x5073d9){if(_0x5073d9)_0x3de2a6(_0x5073d9);return _0x581897();});});})[_0x7366('0x2c')](function(){return _0x652bd2[_0x7366('0xc8')](_0xbeb315,_0x41d8ae,function(_0x35e024){if(_0x35e024){console[_0x7366('0xed')](_0x7366('0xee'),_0x35e024);}else{fs[_0x7366('0xef')](_0xbeb315);}});});});}else{return _0x652bd2[_0x7366('0x2e')](0xc8);}})[_0x7366('0x3a')](handleError(_0x652bd2,null));};