// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xd0b5=['limit','count','Content-Range','apply','reject','save','update','then','destroy','sendStatus','error','stack','name','send','Users','map','fullname','Tags','TagIds','split','push','waiting','answered','unmanaged','total','UserId','closed','talking','SmsInteraction','rawAttributes','type','key','model','keys','filters','intersection','query','attributes','hasOwnProperty','nolimit','order','where','pick','select','field','color','from','tools_tags','u.fullname','ui.SmsInteractionId','user_has_sms_interactions','u.id\x20=\x20ui.UserId','left_join','cm_contacts','users','o.id\x20=\x20i.UserId','sms_accounts','a.id\x20=\x20i.SmsAccountId','sms_messages','me.SmsInteractionId\x20=\x20i.id','sms_interaction_has_tags','it.SmsInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','search','parseSearch','sqlOperator','conditions','find','unreadMessages','having','`\x20=\x200','`\x20>\x200','Contact','operator','$substring','value','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','text','start','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','buildExpression','some','compact','isEmpty','SmsAccountId','concat','createdAt','$gte','parse','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20=\x200','`unreadMessages`\x20>\x200','tag','filter','replace','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','contactName','t.id\x20IN\x20?','resolve','i.SmsAccountId\x20IS\x20NOT\x20NULL','user','i.SmsAccountId\x20IN\x20?','agent','sequelize','toString','length','keyBy','merge','fields','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.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','i.*','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','c.phone','Contact.phone','c.mobile','Contact.mobile','c.fax','Contact.fax','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','ui.SmsInteractionId\x20IN\x20?','groupBy','SmsInteractionId','catch','show','params','include','options','create','body','describe','addMessage','SmsMessage','omit','ids','getMessages','findOne','sort','format','YYYY-MM-DD\x20HH:mm:ss','includeAll','findAll','setTags','Tag','smsInteractionTags:save','removeTags','download','join','root','files','tmp','attachments','firstName','Messages','secret','SmsAccount','Account','Owner','get','mkdirSync','Sms','closedAt','System','lastName','out','renderFile','server','transcript-','.pdf','createPdfFromHTML','err','unlinkSync','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../components/export/pdf','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','defaults','redis','localhost','socket.io-emitter','./smsInteraction.socket','register','status','end','json','offset','undefined'];(function(_0x311edd,_0x35b828){var _0x5ae5ea=function(_0x1b8708){while(--_0x1b8708){_0x311edd['push'](_0x311edd['shift']());}};_0x5ae5ea(++_0x35b828);}(_0xd0b5,0x1b8));var _0x5d0b=function(_0x185041,_0x29b230){_0x185041=_0x185041-0x0;var _0x419ce7=_0xd0b5[_0x185041];return _0x419ce7;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x5d0b('0x0'));var jsonpatch=require(_0x5d0b('0x1'));var rp=require('request-promise');var moment=require(_0x5d0b('0x2'));var BPromise=require(_0x5d0b('0x3'));var Mustache=require(_0x5d0b('0x4'));var util=require(_0x5d0b('0x5'));var path=require(_0x5d0b('0x6'));var sox=require(_0x5d0b('0x7'));var csv=require(_0x5d0b('0x8'));var ejs=require(_0x5d0b('0x9'));var fs=require('fs');var fs_extra=require(_0x5d0b('0xa'));var _=require(_0x5d0b('0xb'));var squel=require(_0x5d0b('0xc'));var crypto=require(_0x5d0b('0xd'));var jsforce=require(_0x5d0b('0xe'));var deskjs=require('desk.js');var toCsv=require(_0x5d0b('0x8'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x5d0b('0xf'));var authService=require(_0x5d0b('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0x5d0b('0x11'));var pdf=require(_0x5d0b('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x5d0b('0x13'))(_0x5d0b('0x14'));var utils=require(_0x5d0b('0x15'));var config=require(_0x5d0b('0x16'));var licenseUtil=require(_0x5d0b('0x17'));var db=require(_0x5d0b('0x18'))['db'];config['redis']=_[_0x5d0b('0x19')](config[_0x5d0b('0x1a')],{'host':_0x5d0b('0x1b'),'port':0x18eb});var socket=require(_0x5d0b('0x1c'))(new Redis(config['redis']));require(_0x5d0b('0x1d'))[_0x5d0b('0x1e')](socket);function respondWithStatusCode(_0x4886f1,_0x1274e2){_0x1274e2=_0x1274e2||0xcc;return function(_0x4d5256){if(_0x4d5256){return _0x4886f1['sendStatus'](_0x1274e2);}return _0x4886f1[_0x5d0b('0x1f')](_0x1274e2)[_0x5d0b('0x20')]();};}function respondWithResult(_0x3bd719,_0x2937db){_0x2937db=_0x2937db||0xc8;return function(_0x4892a4){if(_0x4892a4){return _0x3bd719[_0x5d0b('0x1f')](_0x2937db)[_0x5d0b('0x21')](_0x4892a4);}};}function respondWithFilteredResult(_0x191589,_0x32f522){return function(_0x292b30){if(_0x292b30){var _0x2299ad=typeof _0x32f522[_0x5d0b('0x22')]===_0x5d0b('0x23')&&typeof _0x32f522[_0x5d0b('0x24')]===_0x5d0b('0x23');var _0x120b8f=_0x292b30[_0x5d0b('0x25')];var _0x5fdbc5=_0x2299ad?0x0:_0x32f522['offset'];var _0x4c6fb2=_0x2299ad?_0x292b30[_0x5d0b('0x25')]:_0x32f522[_0x5d0b('0x22')]+_0x32f522[_0x5d0b('0x24')];var _0x25d4e1;if(_0x4c6fb2>=_0x120b8f){_0x4c6fb2=_0x120b8f;_0x25d4e1=0xc8;}else{_0x25d4e1=0xce;}_0x191589[_0x5d0b('0x1f')](_0x25d4e1);return _0x191589['set'](_0x5d0b('0x26'),_0x5fdbc5+'-'+_0x4c6fb2+'/'+_0x120b8f)[_0x5d0b('0x21')](_0x292b30);}return null;};}function patchUpdates(_0x5a39f1){return function(_0x24e096){try{jsonpatch[_0x5d0b('0x27')](_0x24e096,_0x5a39f1,!![]);}catch(_0x458ae3){return BPromise[_0x5d0b('0x28')](_0x458ae3);}return _0x24e096[_0x5d0b('0x29')]();};}function saveUpdates(_0x4a6f66,_0x2c0928){return function(_0x24c044){if(_0x24c044){return _0x24c044[_0x5d0b('0x2a')](_0x4a6f66)[_0x5d0b('0x2b')](function(_0x2d9d8b){return _0x2d9d8b;});}return null;};}function removeEntity(_0x45c97f,_0x28cb69){return function(_0x482525){if(_0x482525){return _0x482525[_0x5d0b('0x2c')]()['then'](function(){_0x45c97f['status'](0xcc)[_0x5d0b('0x20')]();});}};}function handleEntityNotFound(_0x2c1b03,_0x300528){return function(_0x53b080){if(!_0x53b080){_0x2c1b03[_0x5d0b('0x2d')](0x194);}return _0x53b080;};}function handleError(_0x29d194,_0x4bfcc2){_0x4bfcc2=_0x4bfcc2||0x1f4;return function(_0x20e28b){logger[_0x5d0b('0x2e')](_0x20e28b[_0x5d0b('0x2f')]);if(_0x20e28b['name']){delete _0x20e28b[_0x5d0b('0x30')];}_0x29d194[_0x5d0b('0x1f')](_0x4bfcc2)[_0x5d0b('0x31')](_0x20e28b);};}function getInteractionUsers(_0x15e1b1,_0x2a93ec){return new BPromise(function(_0x41856f,_0x53571c){try{if(_0x2a93ec[_0x15e1b1['id']]){_0x15e1b1[_0x5d0b('0x32')]=_[_0x5d0b('0x33')](_0x2a93ec[_0x15e1b1['id']],function(_0x56a21c){return{'id':_0x56a21c['id'],'fullname':_0x56a21c[_0x5d0b('0x34')]};});}}catch(_0x21ad29){_0x53571c(_0x21ad29);}_0x41856f(_0x15e1b1);});}function getInteractionTags(_0x427bc3,_0x30adb0){return new BPromise(function(_0x1a51fb,_0x2f325f){try{if(_0x427bc3['TagIds']){_0x427bc3[_0x5d0b('0x35')]=[];_0x427bc3[_0x5d0b('0x36')][_0x5d0b('0x37')](',')['forEach'](function(_0x561a6c){_0x427bc3[_0x5d0b('0x35')][_0x5d0b('0x38')](_0x30adb0[_0x561a6c]);});}delete _0x427bc3['TagIds'];}catch(_0x37c879){_0x2f325f(_0x37c879);}_0x1a51fb(_0x427bc3);});}function updateSmsInteraction(_0xbdd1ee,_0x3b5f75,_0x437de8){return new BPromise(function(_0x23e70f,_0x2dd746){return getInteractionUsers(_0xbdd1ee,_0x437de8)[_0x5d0b('0x2b')](function(_0xe4267a){return getInteractionTags(_0xe4267a,_0x3b5f75);})['then'](function(_0x2f2e34){return getStateInteraction(_0x2f2e34);})['then'](function(_0x4fd220){_0x23e70f(_0x4fd220);})['catch'](function(_0x55d185){_0x2dd746(_0x55d185);});});}function getStateInteraction(_0x5e0ba9){return new BPromise(function(_0x14f3b2){_0x5e0ba9[_0x5d0b('0x39')]=0x0;_0x5e0ba9['talking']=0x0;_0x5e0ba9[_0x5d0b('0x3a')]=0x0;_0x5e0ba9[_0x5d0b('0x3b')]=0x0;_0x5e0ba9[_0x5d0b('0x3c')]=0x0;if(!_0x5e0ba9['closed']&&!_0x5e0ba9[_0x5d0b('0x3d')]){_0x5e0ba9[_0x5d0b('0x39')]+=0x1;}if(!_0x5e0ba9[_0x5d0b('0x3e')]&&_0x5e0ba9[_0x5d0b('0x3d')]){_0x5e0ba9['talking']+=0x1;if(_0x5e0ba9[_0x5d0b('0x39')]){_0x5e0ba9[_0x5d0b('0x39')]-=0x1;}}if(_0x5e0ba9[_0x5d0b('0x3e')]&&_0x5e0ba9[_0x5d0b('0x3d')]){_0x5e0ba9[_0x5d0b('0x3a')]+=0x1;if(_0x5e0ba9[_0x5d0b('0x3f')]){_0x5e0ba9['talking']-=0x1;}}if(_0x5e0ba9[_0x5d0b('0x3e')]&&!_0x5e0ba9['UserId']){_0x5e0ba9['unmanaged']+=0x1;if(_0x5e0ba9[_0x5d0b('0x39')]){_0x5e0ba9['waiting']-=0x1;}}_0x5e0ba9['total']+=0x1;_0x14f3b2(_0x5e0ba9);});}exports['index']=function(_0x8423dc,_0x58928d){var _0x509121={},_0x4d3129={},_0x349c84={'count':0x0,'rows':[]};var _0xe5ae0b=_[_0x5d0b('0x33')](db[_0x5d0b('0x40')][_0x5d0b('0x41')],function(_0x535def){return{'name':_0x535def['fieldName'],'type':_0x535def[_0x5d0b('0x42')][_0x5d0b('0x43')]};});_0x4d3129[_0x5d0b('0x44')]=_[_0x5d0b('0x33')](_0xe5ae0b,_0x5d0b('0x30'));_0x4d3129['query']=_[_0x5d0b('0x45')](_0x8423dc['query']);_0x4d3129[_0x5d0b('0x46')]=_[_0x5d0b('0x47')](_0x4d3129['model'],_0x4d3129[_0x5d0b('0x48')]);_0x509121['attributes']=_['intersection'](_0x4d3129[_0x5d0b('0x44')],qs['fields'](_0x8423dc[_0x5d0b('0x48')]['fields']));_0x509121[_0x5d0b('0x49')]=_0x509121['attributes']['length']?_0x509121['attributes']:_0x4d3129['model'];if(!_0x8423dc[_0x5d0b('0x48')][_0x5d0b('0x4a')](_0x5d0b('0x4b'))){_0x509121[_0x5d0b('0x24')]=qs[_0x5d0b('0x24')](_0x8423dc[_0x5d0b('0x48')][_0x5d0b('0x24')]);_0x509121['offset']=qs[_0x5d0b('0x22')](_0x8423dc['query'][_0x5d0b('0x22')]);}_0x509121[_0x5d0b('0x4c')]=qs['sort'](_0x8423dc['query']['sort']);_0x509121[_0x5d0b('0x4d')]=qs[_0x5d0b('0x46')](_[_0x5d0b('0x4e')](_0x8423dc[_0x5d0b('0x48')],_0x4d3129[_0x5d0b('0x46')]),_0xe5ae0b);var _0x578b05=[];var _0x40cfa6=squel[_0x5d0b('0x4f')]()[_0x5d0b('0x50')]('id')[_0x5d0b('0x50')](_0x5d0b('0x30'))[_0x5d0b('0x50')](_0x5d0b('0x51'))[_0x5d0b('0x52')](_0x5d0b('0x53'));var _0x250abf=squel[_0x5d0b('0x4f')]()[_0x5d0b('0x50')]('u.id')[_0x5d0b('0x50')](_0x5d0b('0x54'))['field'](_0x5d0b('0x55'))['from'](_0x5d0b('0x56'),'ui')['left_join']('users','u',_0x5d0b('0x57'));var _0x3d2f54=squel[_0x5d0b('0x4f')]()['from']('sms_interactions','i')[_0x5d0b('0x58')](_0x5d0b('0x59'),'c','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL')[_0x5d0b('0x58')](_0x5d0b('0x5a'),'o',_0x5d0b('0x5b'))[_0x5d0b('0x58')](_0x5d0b('0x5c'),'a',_0x5d0b('0x5d'))[_0x5d0b('0x58')](_0x5d0b('0x5e'),'me',_0x5d0b('0x5f'))[_0x5d0b('0x58')](_0x5d0b('0x60'),'it',_0x5d0b('0x61'))['left_join'](_0x5d0b('0x53'),'t',_0x5d0b('0x62'));var _0x41a6fd=squel[_0x5d0b('0x63')]();var _0x4610e0=[];var _0x19556f=squel[_0x5d0b('0x63')]();var _0x3127d3;if(_0x8423dc[_0x5d0b('0x48')][_0x5d0b('0x64')]){_0x3127d3=as[_0x5d0b('0x65')](_0x8423dc['query'][_0x5d0b('0x64')]);var _0x25cf99=_0x3127d3[_0x5d0b('0x66')];for(var _0x586a=0x0;_0x586a<_0x3127d3[_0x5d0b('0x67')]['length'];_0x586a++){var _0x5d19dd=_0x3127d3[_0x5d0b('0x67')][_0x586a];var _0x301794='i';var _0x20ef46=_[_0x5d0b('0x68')](_0xe5ae0b,[_0x5d0b('0x30'),_0x5d19dd['field']]);if(!_0x20ef46){switch(_0x5d19dd[_0x5d0b('0x50')]){case _0x5d0b('0x69'):if(_0x5d19dd['value']==0x1){_0x3d2f54[_0x5d0b('0x6a')]('`'+_0x5d19dd[_0x5d0b('0x50')]+_0x5d0b('0x6b'));}else{_0x3d2f54[_0x5d0b('0x6a')]('`'+_0x5d19dd[_0x5d0b('0x50')]+_0x5d0b('0x6c'));}break;case _0x5d0b('0x6d'):if(_0x5d19dd[_0x5d0b('0x6e')]===_0x5d0b('0x6f')){if(_0x5d19dd[_0x5d0b('0x70')]['split']('\x20')['length']>0x1){_0x41a6fd[_0x25cf99](_0x5d0b('0x71'),qs[_0x5d0b('0x72')](_0x5d19dd[_0x5d0b('0x70')]),null);}else{var _0x9f2398='%'+_0x5d19dd[_0x5d0b('0x70')]+'%';_0x41a6fd[_0x25cf99](_0x5d0b('0x73'),_0x9f2398,_0x9f2398,_0x9f2398);}}else{_0x20ef46=_['find'](_0xe5ae0b,['name',_0x5d0b('0x74')]);_0x5d19dd[_0x5d0b('0x50')]=_0x5d0b('0x74');_0x4e30d2=as['buildExpression'](_0x301794,_0x20ef46[_0x5d0b('0x42')],_0x5d19dd);_0x41a6fd[_0x25cf99](_0x4e30d2[_0x5d0b('0x75')],_0x4e30d2[_0x5d0b('0x70')][_0x5d0b('0x76')],_0x4e30d2[_0x5d0b('0x70')][_0x5d0b('0x20')]);}break;case'Tag':var _0x2a4ca3=_0x5d19dd[_0x5d0b('0x70')][_0x5d0b('0x37')](',')[_0x5d0b('0x33')](function(_0x3d9b2a){return Number(_0x3d9b2a);});_0x2a4ca3[_0x5d0b('0x77')](function(_0x1bd7d3){_0x19556f['or'](_0x5d0b('0x78'),'%,'+_0x1bd7d3+',%');});_0x4610e0=_[_0x5d0b('0x79')](_0x4610e0,_0x2a4ca3);break;case _0x5d0b('0x7a'):if(_0x5d19dd[_0x5d0b('0x6e')]==='$substring'){_0x41a6fd[_0x25cf99](_0x5d0b('0x7b'),'%'+_0x5d19dd[_0x5d0b('0x70')]+'%',null);}else{_0x20ef46=_[_0x5d0b('0x68')](_0xe5ae0b,[_0x5d0b('0x30'),_0x5d0b('0x3d')]);_0x5d19dd[_0x5d0b('0x50')]='UserId';_0x4e30d2=as['buildExpression'](_0x301794,_0x20ef46[_0x5d0b('0x42')],_0x5d19dd);_0x41a6fd[_0x25cf99](_0x4e30d2[_0x5d0b('0x75')],_0x4e30d2[_0x5d0b('0x70')][_0x5d0b('0x76')],_0x4e30d2[_0x5d0b('0x70')][_0x5d0b('0x20')]);}break;case'body':_0x4e30d2=as[_0x5d0b('0x7c')]('me',null,_0x5d19dd);_0x41a6fd[_0x25cf99](_0x4e30d2[_0x5d0b('0x75')],_0x4e30d2['value'][_0x5d0b('0x76')],_0x4e30d2[_0x5d0b('0x70')]['end']);break;}}else{var _0x4e30d2=as[_0x5d0b('0x7c')](_0x301794,_0x20ef46[_0x5d0b('0x42')],_0x5d19dd);_0x41a6fd[_0x25cf99](_0x4e30d2['text'],_0x4e30d2[_0x5d0b('0x70')]['start'],_0x4e30d2[_0x5d0b('0x70')][_0x5d0b('0x20')]);}}}else{var _0x211257=_(_0x8423dc[_0x5d0b('0x48')])['keys']()[_0x5d0b('0x33')](function(_0x45ce74){return _[_0x5d0b('0x7d')](_0xe5ae0b,[_0x5d0b('0x30'),_0x45ce74])?_0x45ce74:undefined;})[_0x5d0b('0x7e')]()[_0x5d0b('0x70')]();if(!_[_0x5d0b('0x7f')](_0x211257)){_0x211257[_0x5d0b('0x77')](function(_0x1f37d4){if(_0x1f37d4===_0x5d0b('0x80')){_0x3d2f54['where']('i.SmsAccountId\x20IN\x20?',[][_0x5d0b('0x81')](_0x8423dc[_0x5d0b('0x48')][_0x1f37d4]));}else if(_0x1f37d4===_0x5d0b('0x82')){var _0x112b45=JSON['parse'](_0x8423dc[_0x5d0b('0x48')][_0x1f37d4])[_0x5d0b('0x83')];var _0x45a7e1=JSON[_0x5d0b('0x84')](_0x8423dc['query'][_0x1f37d4])[_0x5d0b('0x85')];_0x3d2f54[_0x5d0b('0x4d')](_0x5d0b('0x86'),_0x112b45,_0x45a7e1);}else{if(_0x8423dc[_0x5d0b('0x48')][_0x1f37d4]===_0x5d0b('0x87')){_0x3d2f54[_0x5d0b('0x4d')]('i.'+_0x1f37d4+_0x5d0b('0x88'));}else{_0x3d2f54[_0x5d0b('0x4d')]('i.'+_0x1f37d4+_0x5d0b('0x89'),_0x8423dc[_0x5d0b('0x48')][_0x1f37d4]);}}});}if(_0x8423dc[_0x5d0b('0x48')]['read']){if(_0x8423dc['query'][_0x5d0b('0x8a')]==0x1){_0x3d2f54[_0x5d0b('0x6a')](_0x5d0b('0x8b'));}else{_0x3d2f54[_0x5d0b('0x6a')](_0x5d0b('0x8c'));}}if(_0x8423dc['query']['tag']){_0x4610e0=_['isArray'](_0x8423dc[_0x5d0b('0x48')]['tag'])?_0x8423dc[_0x5d0b('0x48')][_0x5d0b('0x8d')]:new Array(_0x8423dc[_0x5d0b('0x48')]['tag']);_0x4610e0['forEach'](function(_0x26dd0f){_0x19556f['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x26dd0f+',%');});}if(_0x8423dc[_0x5d0b('0x48')]['filter']){var _0x3aeebd=_0x8423dc['query'][_0x5d0b('0x8e')][_0x5d0b('0x8f')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(qs['isNumeric'](_0x3aeebd)){_0x41a6fd['or']('i.id\x20LIKE\x20?',_0x3aeebd+'%')['or'](_0x5d0b('0x90'),_0x3aeebd+'%');}else{_0x41a6fd['or'](_0x5d0b('0x91'),qs[_0x5d0b('0x72')](_0x3aeebd))['or'](_0x5d0b('0x92'),_0x3aeebd+'%');}}}_0x3d2f54[_0x5d0b('0x4d')](_0x41a6fd);_0x3d2f54[_0x5d0b('0x93')](_0x5d0b('0x94'));var _0x185dc1={'type':db[_0x5d0b('0x95')]['QueryTypes']['SELECT'],'raw':!![]};var _0xf6a54f=_0x3d2f54[_0x5d0b('0x96')]();_0xf6a54f['field'](_0x5d0b('0x94'));_0xf6a54f['field']('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x5d0b('0x69'));if(_0x509121[_0x5d0b('0x4c')]){_0x509121[_0x5d0b('0x4c')]['forEach'](function(_0x2e2c18){var _0x4c160c=_0x2e2c18[0x0]===_0x5d0b('0x97')?_0x2e2c18[0x0]:'i.'+_0x2e2c18[0x0];_0x3d2f54[_0x5d0b('0x4c')](_0x4c160c,_0x2e2c18[0x1]==='DESC'?![]:!![]);});}if(!_[_0x5d0b('0x7f')](_0x4610e0)){_0x3d2f54[_0x5d0b('0x6a')](_0x19556f);_0xf6a54f['where'](_0x5d0b('0x98'),_0x4610e0);}BPromise[_0x5d0b('0x99')]()[_0x5d0b('0x2b')](function(){if(!_0x3127d3){if(_0x8423dc[_0x5d0b('0x48')][_0x5d0b('0x80')])return;_0xf6a54f[_0x5d0b('0x4d')](_0x5d0b('0x9a'));_0x3d2f54[_0x5d0b('0x4d')](_0x5d0b('0x9a'));return;}if(_0x8423dc[_0x5d0b('0x9b')]['role']!=='agent')return;return _0x8423dc[_0x5d0b('0x9b')]['getSmsAccounts']({'attributes':['id'],'raw':!![]})[_0x5d0b('0x2b')](function(_0x30433b){if(_['isEmpty'](_0x30433b)){_0xf6a54f[_0x5d0b('0x4d')]('i.SmsAccountId\x20IS\x20NULL');_0x3d2f54['where']('i.SmsAccountId\x20IS\x20NULL');}else{_0xf6a54f['where'](_0x5d0b('0x9c'),_['map'](_0x30433b,'id'));_0x3d2f54[_0x5d0b('0x4d')](_0x5d0b('0x9c'),_[_0x5d0b('0x33')](_0x30433b,'id'));}});})[_0x5d0b('0x2b')](function(){if(_0x8423dc[_0x5d0b('0x9b')]['role']===_0x5d0b('0x9d')&&!_0x3127d3&&!_0x8423dc[_0x5d0b('0x48')]['SmsAccountId'])return[];return db[_0x5d0b('0x9e')][_0x5d0b('0x48')](_0xf6a54f[_0x5d0b('0x9f')](),_0x185dc1);})[_0x5d0b('0x2b')](function(_0x2d49fa){_0x349c84[_0x5d0b('0x25')]=_0x2d49fa[_0x5d0b('0xa0')];if(_0x349c84[_0x5d0b('0x25')]===0x0)return[];return db[_0x5d0b('0x9e')][_0x5d0b('0x48')](_0x40cfa6[_0x5d0b('0x9f')](),_0x185dc1)[_0x5d0b('0x2b')](function(_0x4290de){_0x578b05=_[_0x5d0b('0xa1')](_0x4290de,'id');_0x185dc1=_[_0x5d0b('0xa2')](_0x185dc1,{'model':db[_0x5d0b('0x40')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x8423dc[_0x5d0b('0x48')][_0x5d0b('0xa3')]){_0x509121['attributes']['forEach'](function(_0x5cc3ef){_0x3d2f54['field']('i.'+_0x5cc3ef);});}else{_0x3d2f54[_0x5d0b('0x50')](_0x5d0b('0xa4'),_0x5d0b('0x69'));_0x3d2f54['field'](_0x5d0b('0xa5'),_0x5d0b('0xa6'));_0x3d2f54[_0x5d0b('0x50')](_0x5d0b('0xa7'),_0x5d0b('0xa8'));_0x3d2f54[_0x5d0b('0x50')](_0x5d0b('0xa9'),'contactName');_0x3d2f54[_0x5d0b('0x50')](_0x5d0b('0xaa'));_0x3d2f54[_0x5d0b('0x50')](_0x5d0b('0xab'),_0x5d0b('0xac'));_0x3d2f54['field'](_0x5d0b('0xad'),_0x5d0b('0xae'));_0x3d2f54[_0x5d0b('0x50')](_0x5d0b('0xaf'),_0x5d0b('0xb0'));_0x3d2f54[_0x5d0b('0x50')](_0x5d0b('0xb1'),_0x5d0b('0xb2'));_0x3d2f54[_0x5d0b('0x50')](_0x5d0b('0xb3'),_0x5d0b('0xb4'));_0x3d2f54['field'](_0x5d0b('0xb5'),_0x5d0b('0xb6'));_0x3d2f54[_0x5d0b('0x50')]('o.fullname','Owner.fullname');_0x3d2f54[_0x5d0b('0x50')](_0x5d0b('0xb7'),_0x5d0b('0xb8'));_0x3d2f54[_0x5d0b('0x50')](_0x5d0b('0xb9'),_0x5d0b('0x36'));}if(_0x509121[_0x5d0b('0x24')])_0x3d2f54[_0x5d0b('0x24')](_0x509121[_0x5d0b('0x24')]);if(_0x509121[_0x5d0b('0x22')])_0x3d2f54['offset'](_0x509121['offset']);return db[_0x5d0b('0x9e')][_0x5d0b('0x48')](_0x3d2f54['toString'](),_0x185dc1);})[_0x5d0b('0x2b')](function(_0x51eaa3){if(_0x51eaa3[_0x5d0b('0xa0')]>0x0)_0x250abf[_0x5d0b('0x4d')](_0x5d0b('0xba'),_['map'](_0x51eaa3,'id'));return db['sequelize'][_0x5d0b('0x48')](_0x250abf[_0x5d0b('0x9f')](),_0x185dc1)[_0x5d0b('0x2b')](function(_0x54e6c2){var _0x4a1dca=_[_0x5d0b('0xbb')](_0x54e6c2,_0x5d0b('0xbc'));var _0x4db2ea=[];_0x51eaa3[_0x5d0b('0x77')](function(_0x3edeb7){_0x4db2ea['push'](updateSmsInteraction(_0x3edeb7,_0x578b05,_0x4a1dca));});return BPromise['all'](_0x4db2ea);});});})['then'](function(_0x5e499e){_0x349c84['rows']=_0x5e499e;return _0x349c84;})[_0x5d0b('0x2b')](respondWithFilteredResult(_0x58928d,_0x509121))[_0x5d0b('0xbd')](handleError(_0x58928d,null));};exports[_0x5d0b('0xbe')]=function(_0x88d1b5,_0x29ec10){var _0x199c7a={'raw':![],'where':{'id':_0x88d1b5[_0x5d0b('0xbf')]['id']}},_0xa209a3={};_0xa209a3[_0x5d0b('0x44')]=_[_0x5d0b('0x45')](db['SmsInteraction'][_0x5d0b('0x41')]);_0xa209a3[_0x5d0b('0x48')]=_[_0x5d0b('0x45')](_0x88d1b5['query']);_0xa209a3[_0x5d0b('0x46')]=_[_0x5d0b('0x47')](_0xa209a3['model'],_0xa209a3[_0x5d0b('0x48')]);_0x199c7a[_0x5d0b('0x49')]=_[_0x5d0b('0x47')](_0xa209a3['model'],qs['fields'](_0x88d1b5['query'][_0x5d0b('0xa3')]));_0x199c7a['attributes']=_0x199c7a['attributes']['length']?_0x199c7a[_0x5d0b('0x49')]:_0xa209a3[_0x5d0b('0x44')];if(_0x88d1b5[_0x5d0b('0x48')]['includeAll']){_0x199c7a[_0x5d0b('0xc0')]=[{'all':!![]}];}_0x199c7a=_[_0x5d0b('0xa2')]({},_0x199c7a,_0x88d1b5[_0x5d0b('0xc1')]);return db[_0x5d0b('0x40')][_0x5d0b('0x68')](_0x199c7a)[_0x5d0b('0x2b')](handleEntityNotFound(_0x29ec10,null))[_0x5d0b('0x2b')](respondWithResult(_0x29ec10,null))['catch'](handleError(_0x29ec10,null));};exports[_0x5d0b('0xc2')]=function(_0x1380d7,_0x296bc8){return db[_0x5d0b('0x40')][_0x5d0b('0xc2')](_0x1380d7[_0x5d0b('0xc3')],{})[_0x5d0b('0x2b')](respondWithResult(_0x296bc8,0xc9))[_0x5d0b('0xbd')](handleError(_0x296bc8,null));};exports[_0x5d0b('0x2a')]=function(_0x3aac3c,_0xe6e486){if(_0x3aac3c[_0x5d0b('0xc3')]['id']){delete _0x3aac3c[_0x5d0b('0xc3')]['id'];}return db[_0x5d0b('0x40')][_0x5d0b('0x68')]({'where':{'id':_0x3aac3c[_0x5d0b('0xbf')]['id']}})[_0x5d0b('0x2b')](handleEntityNotFound(_0xe6e486,null))[_0x5d0b('0x2b')](saveUpdates(_0x3aac3c[_0x5d0b('0xc3')],null))[_0x5d0b('0x2b')](respondWithResult(_0xe6e486,null))[_0x5d0b('0xbd')](handleError(_0xe6e486,null));};exports['destroy']=function(_0x11856c,_0x4c0fdf){return db['SmsInteraction'][_0x5d0b('0x68')]({'where':{'id':_0x11856c[_0x5d0b('0xbf')]['id']}})[_0x5d0b('0x2b')](handleEntityNotFound(_0x4c0fdf,null))['then'](removeEntity(_0x4c0fdf,null))[_0x5d0b('0xbd')](handleError(_0x4c0fdf,null));};exports[_0x5d0b('0xc4')]=function(_0x68727a,_0x58172b){return db['SmsInteraction'][_0x5d0b('0xc4')]()[_0x5d0b('0x2b')](respondWithResult(_0x58172b,null))[_0x5d0b('0xbd')](handleError(_0x58172b,null));};exports[_0x5d0b('0xc5')]=function(_0x1e57a6,_0x2111b6,_0xa7fc15){return db[_0x5d0b('0xc6')]['find']({'where':{'id':_0x1e57a6['params']['id']}})['then'](handleEntityNotFound(_0x2111b6,null))['then'](function(_0xbb8b58){if(_0xbb8b58){return _0xbb8b58['addMessage'](_0x1e57a6[_0x5d0b('0xc3')]['ids'],_[_0x5d0b('0xc7')](_0x1e57a6[_0x5d0b('0xc3')],[_0x5d0b('0xc8'),'id'])||{});}})['then'](respondWithResult(_0x2111b6,null))[_0x5d0b('0xbd')](handleError(_0x2111b6,null));};exports[_0x5d0b('0xc9')]=function(_0x3c3c76,_0x367004,_0x1e6715){var _0x3b9b48={'raw':![],'where':{}};var _0x1802b5={};var _0x1d56fa={'count':0x0,'rows':[]};return db[_0x5d0b('0x40')][_0x5d0b('0xca')]({'where':{'id':_0x3c3c76[_0x5d0b('0xbf')]['id']}})[_0x5d0b('0x2b')](handleEntityNotFound(_0x367004,null))['then'](function(_0x57f24e){if(_0x57f24e){_0x1802b5[_0x5d0b('0x44')]=_[_0x5d0b('0x45')](db[_0x5d0b('0xc6')]['rawAttributes']);_0x1802b5[_0x5d0b('0x48')]=_[_0x5d0b('0x45')](_0x3c3c76[_0x5d0b('0x48')]);_0x1802b5[_0x5d0b('0x46')]=_[_0x5d0b('0x47')](_0x1802b5['model'],_0x1802b5[_0x5d0b('0x48')]);_0x3b9b48[_0x5d0b('0x49')]=_[_0x5d0b('0x47')](_0x1802b5[_0x5d0b('0x44')],qs[_0x5d0b('0xa3')](_0x3c3c76['query'][_0x5d0b('0xa3')]));_0x3b9b48[_0x5d0b('0x49')]=_0x3b9b48[_0x5d0b('0x49')][_0x5d0b('0xa0')]?_0x3b9b48[_0x5d0b('0x49')]:_0x1802b5[_0x5d0b('0x44')];if(!_0x3c3c76['query'][_0x5d0b('0x4a')](_0x5d0b('0x4b'))){_0x3b9b48[_0x5d0b('0x24')]=qs[_0x5d0b('0x24')](_0x3c3c76[_0x5d0b('0x48')]['limit']);_0x3b9b48[_0x5d0b('0x22')]=qs[_0x5d0b('0x22')](_0x3c3c76[_0x5d0b('0x48')][_0x5d0b('0x22')]);}_0x3b9b48[_0x5d0b('0x4c')]=qs[_0x5d0b('0xcb')](_0x3c3c76['query']['sort']);_0x3b9b48[_0x5d0b('0x4d')]=qs[_0x5d0b('0x46')](_[_0x5d0b('0x4e')](_0x3c3c76[_0x5d0b('0x48')],_0x1802b5[_0x5d0b('0x46')]));_0x3b9b48[_0x5d0b('0x4d')][_0x5d0b('0xbc')]=_0x57f24e['id'];if(_0x3c3c76['query'][_0x5d0b('0x8e')]){_0x3b9b48[_0x5d0b('0x4d')]=_[_0x5d0b('0xa2')](_0x3b9b48['where'],{'$or':_[_0x5d0b('0x33')](_0x3b9b48[_0x5d0b('0x49')],function(_0x2756ea){var _0x1647ac={};_0x1647ac[_0x2756ea]={'$like':'%'+_0x3c3c76[_0x5d0b('0x48')]['filter']+'%'};return _0x1647ac;})});}if(_0x3c3c76[_0x5d0b('0x48')]['$gte']){var _0x537c4a=_0x3c3c76[_0x5d0b('0x48')][_0x5d0b('0x83')][_0x5d0b('0x37')](',');var _0x765dd1={};_0x765dd1[_0x537c4a[0x0]]={'$gte':moment(_0x537c4a[0x1])[_0x5d0b('0xcc')](_0x5d0b('0xcd'))};_0x3b9b48[_0x5d0b('0x4d')]=_[_0x5d0b('0xa2')](_0x3b9b48[_0x5d0b('0x4d')],_0x765dd1);}_0x3b9b48=_[_0x5d0b('0xa2')]({},_0x3b9b48,_0x3c3c76[_0x5d0b('0xc1')]);return db[_0x5d0b('0xc6')]['count']({'where':_0x3b9b48[_0x5d0b('0x4d')]})[_0x5d0b('0x2b')](function(_0x1a8c80){_0x1d56fa[_0x5d0b('0x25')]=_0x1a8c80;if(_0x3c3c76[_0x5d0b('0x48')][_0x5d0b('0xce')]){_0x3b9b48[_0x5d0b('0xc0')]=[{'all':!![]}];}return db[_0x5d0b('0xc6')][_0x5d0b('0xcf')](_0x3b9b48);})[_0x5d0b('0x2b')](function(_0x2d8045){_0x1d56fa['rows']=_0x2d8045;return _0x1d56fa;});}})[_0x5d0b('0x2b')](respondWithFilteredResult(_0x367004,_0x3b9b48))[_0x5d0b('0xbd')](handleError(_0x367004,null));};exports['addTags']=function(_0x428db1,_0x364460,_0x1145f7){return db['SmsInteraction']['find']({'where':{'id':_0x428db1[_0x5d0b('0xbf')]['id']}})[_0x5d0b('0x2b')](handleEntityNotFound(_0x364460,null))[_0x5d0b('0x2b')](function(_0x926efb){if(_0x926efb){return _0x926efb[_0x5d0b('0xd0')](_0x428db1['body'][_0x5d0b('0xc8')],_[_0x5d0b('0xc7')](_0x428db1[_0x5d0b('0xc3')],[_0x5d0b('0xc8'),'id'])||{})['spread'](function(){return db[_0x5d0b('0xd1')][_0x5d0b('0xcf')]({'attributes':['id',_0x5d0b('0x30'),_0x5d0b('0x51')],'where':{'id':_0x428db1[_0x5d0b('0xc3')]['ids']}});})[_0x5d0b('0x2b')](function(_0x16b988){socket['emit'](_0x5d0b('0xd2'),{'id':Number(_0x428db1['params']['id']),'tags':_0x16b988||[]});return{'id':Number(_0x428db1[_0x5d0b('0xbf')]['id']),'tags':_0x16b988||[]};});}})[_0x5d0b('0x2b')](respondWithResult(_0x364460,null))['catch'](handleError(_0x364460,null));};exports[_0x5d0b('0xd3')]=function(_0x3a5aee,_0xf6ec50,_0x391a87){return db[_0x5d0b('0x40')][_0x5d0b('0x68')]({'where':{'id':_0x3a5aee[_0x5d0b('0xbf')]['id']}})[_0x5d0b('0x2b')](handleEntityNotFound(_0xf6ec50,null))[_0x5d0b('0x2b')](function(_0x438b41){if(_0x438b41){return _0x438b41['removeTags'](_0x3a5aee[_0x5d0b('0x48')][_0x5d0b('0xc8')]);}})[_0x5d0b('0x2b')](respondWithStatusCode(_0xf6ec50,null))[_0x5d0b('0xbd')](handleError(_0xf6ec50,null));};exports[_0x5d0b('0xd4')]=function(_0x22b973,_0x5d47fa){var _0x300daf=moment()['unix']()['toString']();var _0x510513=path[_0x5d0b('0xd5')](config[_0x5d0b('0xd6')],'server',_0x5d0b('0xd7'),_0x5d0b('0xd8'));var _0x3259a4=path['join'](config[_0x5d0b('0xd6')],'server',_0x5d0b('0xd7'),_0x5d0b('0xd9'));var _0x11b9c6=path[_0x5d0b('0xd5')](_0x510513,_0x300daf);var _0x40d15a=util['format']('transcript-%d-%s.zip',_0x22b973[_0x5d0b('0xbf')]['id'],_0x300daf);var _0x2a9e37=path[_0x5d0b('0xd5')](_0x510513,_0x40d15a);var _0x34d427=[];_0x34d427['push']({'model':db[_0x5d0b('0x7a')],'as':'User','attributes':['id',_0x5d0b('0x34')],'raw':!![]});_0x34d427[_0x5d0b('0x38')]({'model':db['CmContact'],'as':_0x5d0b('0x6d'),'attributes':['id',_0x5d0b('0xda'),'lastName'],'raw':!![]});var _0x4f13c2=[{'model':db['SmsMessage'],'as':_0x5d0b('0xdb'),'attributes':['id',_0x5d0b('0xc3'),_0x5d0b('0x82'),'direction',_0x5d0b('0xdc'),'read'],'include':_0x34d427}];_0x4f13c2[_0x5d0b('0x38')]({'model':db[_0x5d0b('0xdd')],'as':_0x5d0b('0xde'),'attributes':['id',_0x5d0b('0x30')]});_0x4f13c2[_0x5d0b('0x38')]({'model':db[_0x5d0b('0x7a')],'as':_0x5d0b('0xdf'),'attributes':['id',_0x5d0b('0x34')]});return db[_0x5d0b('0x40')]['find']({'where':{'id':_0x22b973[_0x5d0b('0xbf')]['id']},'include':_0x4f13c2})[_0x5d0b('0x2b')](handleEntityNotFound(_0x5d47fa,null))[_0x5d0b('0x2b')](function(_0x478bdc){if(_0x478bdc){var _0x987307=_0x478bdc[_0x5d0b('0xe0')]({'plain':!![]});fs[_0x5d0b('0xe1')](_0x11b9c6);var _0x3b4a1e={'channel':_0x5d0b('0xe2'),'account':_0x987307['Account']['name'],'agent':_0x987307['Owner']?_0x987307['Owner'][_0x5d0b('0x34')]:'N.A.','createdAt':moment(_0x987307[_0x5d0b('0x82')])[_0x5d0b('0xcc')](_0x5d0b('0xcd'))[_0x5d0b('0x9f')](),'closedAt':_0x987307[_0x5d0b('0x3e')]?moment(_0x987307[_0x5d0b('0xe3')])['format']('YYYY-MM-DD\x20HH:mm:ss')[_0x5d0b('0x9f')]():'','disposition':_0x987307['disposition'],'messages':_(_0x987307['Messages'])[_0x5d0b('0x8e')]({'secret':![]})[_0x5d0b('0x33')](function(_0x45fcbf){return{'date':moment(_0x45fcbf[_0x5d0b('0x82')])[_0x5d0b('0xcc')](_0x5d0b('0xcd'))['toString'](),'sender':_0x45fcbf['direction']==='out'?_0x45fcbf[_0x5d0b('0x7a')]?_0x45fcbf[_0x5d0b('0x7a')]['fullname']:_0x5d0b('0xe4'):_0x45fcbf[_0x5d0b('0x6d')]['firstName']+(_0x45fcbf['Contact'][_0x5d0b('0xe5')]?'\x20'+_0x45fcbf[_0x5d0b('0x6d')][_0x5d0b('0xe5')]:''),'body':_0x45fcbf['body'],'direction':_0x45fcbf['direction']===_0x5d0b('0xe6')?'A':'C','secret':_0x45fcbf['secret'],'read':_0x45fcbf[_0x5d0b('0x8a')]};})[_0x5d0b('0x70')]()};return ejs[_0x5d0b('0xe7')](path[_0x5d0b('0xd5')](config[_0x5d0b('0xd6')],_0x5d0b('0xe8'),'views','downloadInteraction.ejs'),{'interaction':_0x3b4a1e})[_0x5d0b('0x2b')](function(_0x300a62){var _0x1b0571=path[_0x5d0b('0xd5')](_0x11b9c6,_0x5d0b('0xe9')+_0x987307['id']+'-'+_0x300daf+_0x5d0b('0xea'));var _0x582c36={'path':_0x1b0571,'channel':_0x5d0b('0xe2'),'interactionId':_0x987307['id']};return pdf[_0x5d0b('0xeb')](_0x300a62,_0x582c36);})['then'](function(){return new BPromise(function(_0x3e7884,_0x27cd2f){zipdir(_0x11b9c6,{'saveTo':_0x2a9e37},function(_0x56a9ef,_0x1b2fd2){if(_0x56a9ef)return _0x27cd2f(_0x56a9ef);return _0x3e7884(_0x1b2fd2);});})[_0x5d0b('0x2b')](function(){return new BPromise(function(_0x4e6c48,_0x9fb9f0){rimraf(_0x11b9c6,function(_0x25d8a5){if(_0x25d8a5)_0x9fb9f0(_0x25d8a5);return _0x4e6c48();});});})['then'](function(){return _0x5d47fa['download'](_0x2a9e37,_0x40d15a,function(_0x1653f1){if(_0x1653f1){console['log'](_0x5d0b('0xec'),_0x1653f1);}else{fs[_0x5d0b('0xed')](_0x2a9e37);}});});});}else{return _0x5d47fa[_0x5d0b('0x2d')](0xc8);}})[_0x5d0b('0xbd')](handleError(_0x5d47fa,null));};
\ No newline at end of file
+var _0xf3bb=['create','describe','SmsMessage','addMessage','ids','omit','getMessages','findOne','hasOwnProperty','pick','format','YYYY-MM-DD\x20HH:mm:ss','setTags','spread','findAll','emit','smsInteractionTags:save','removeTags','download','unix','root','server','files','tmp','join','attachments','CmContact','Contact','firstName','Messages','createdAt','direction','secret','SmsAccount','Account','Owner','get','Sms','closedAt','disposition','out','System','lastName','renderFile','views','transcript-','.pdf','createPdfFromHTML','log','err','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../components/export/pdf','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','register','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','error','stack','name','Users','fullname','TagIds','Tags','split','forEach','push','talking','total','closed','UserId','waiting','index','map','SmsInteraction','rawAttributes','fieldName','type','model','query','keys','filters','intersection','fields','attributes','length','nolimit','order','sort','select','field','color','from','tools_tags','u.id','u.fullname','ui.SmsInteractionId','left_join','users','u.id\x20=\x20ui.UserId','sms_interactions','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','sms_messages','me.SmsInteractionId\x20=\x20i.id','sms_interaction_has_tags','it.SmsInteractionId\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','parseSearch','search','sqlOperator','conditions','find','unreadMessages','value','`\x20=\x200','having','`\x20>\x200','operator','$substring','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','buildExpression','text','start','Tag','User','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname)\x20LIKE\x20?','body','some','compact','isEmpty','SmsAccountId','i.SmsAccountId\x20IN\x20?','concat','parse','$gte','$lte','where','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','read','`unreadMessages`\x20>\x200','isArray','tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','filter','replace','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','Sequelize','QueryTypes','SELECT','clone','i.id','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','contactName','DESC','resolve','i.SmsAccountId\x20IS\x20NOT\x20NULL','user','role','agent','getSmsAccounts','i.SmsAccountId\x20IS\x20NULL','sequelize','toString','keyBy','merge','a.key','Account.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','i.*','c.firstName','Contact.firstName','c.lastName','Contact.lastName','Contact.email','c.phone','Contact.mobile','c.fax','o.fullname','Owner.fullname','GROUP_CONCAT(DISTINCT\x20t.id)','ui.SmsInteractionId\x20IN\x20?','groupBy','SmsInteractionId','all','rows','catch','params','includeAll','include','options'];(function(_0x523b30,_0x5381f8){var _0x135f8c=function(_0x5766ec){while(--_0x5766ec){_0x523b30['push'](_0x523b30['shift']());}};_0x135f8c(++_0x5381f8);}(_0xf3bb,0x129));var _0xbf3b=function(_0x8f1751,_0xa961fa){_0x8f1751=_0x8f1751-0x0;var _0x13bca7=_0xf3bb[_0x8f1751];return _0x13bca7;};'use strict';var emlformat=require(_0xbf3b('0x0'));var rimraf=require(_0xbf3b('0x1'));var zipdir=require(_0xbf3b('0x2'));var jsonpatch=require(_0xbf3b('0x3'));var rp=require(_0xbf3b('0x4'));var moment=require(_0xbf3b('0x5'));var BPromise=require('bluebird');var Mustache=require(_0xbf3b('0x6'));var util=require(_0xbf3b('0x7'));var path=require(_0xbf3b('0x8'));var sox=require(_0xbf3b('0x9'));var csv=require(_0xbf3b('0xa'));var ejs=require(_0xbf3b('0xb'));var fs=require('fs');var fs_extra=require(_0xbf3b('0xc'));var _=require(_0xbf3b('0xd'));var squel=require(_0xbf3b('0xe'));var crypto=require(_0xbf3b('0xf'));var jsforce=require('jsforce');var deskjs=require(_0xbf3b('0x10'));var toCsv=require(_0xbf3b('0xa'));var querystring=require(_0xbf3b('0x11'));var Papa=require(_0xbf3b('0x12'));var Redis=require('ioredis');var authService=require(_0xbf3b('0x13'));var qs=require(_0xbf3b('0x14'));var as=require(_0xbf3b('0x15'));var pdf=require(_0xbf3b('0x16'));var hardwareService=require(_0xbf3b('0x17'));var logger=require(_0xbf3b('0x18'))(_0xbf3b('0x19'));var utils=require(_0xbf3b('0x1a'));var config=require(_0xbf3b('0x1b'));var licenseUtil=require('../../config/license/util');var db=require(_0xbf3b('0x1c'))['db'];config[_0xbf3b('0x1d')]=_[_0xbf3b('0x1e')](config[_0xbf3b('0x1d')],{'host':_0xbf3b('0x1f'),'port':0x18eb});var socket=require(_0xbf3b('0x20'))(new Redis(config[_0xbf3b('0x1d')]));require('./smsInteraction.socket')[_0xbf3b('0x21')](socket);function respondWithStatusCode(_0x4180b0,_0x389774){_0x389774=_0x389774||0xcc;return function(_0x34b982){if(_0x34b982){return _0x4180b0[_0xbf3b('0x22')](_0x389774);}return _0x4180b0[_0xbf3b('0x23')](_0x389774)[_0xbf3b('0x24')]();};}function respondWithResult(_0x306655,_0x59e53e){_0x59e53e=_0x59e53e||0xc8;return function(_0x50a53a){if(_0x50a53a){return _0x306655[_0xbf3b('0x23')](_0x59e53e)[_0xbf3b('0x25')](_0x50a53a);}};}function respondWithFilteredResult(_0x4606ba,_0x3b7377){return function(_0x282972){if(_0x282972){var _0x45b001=typeof _0x3b7377[_0xbf3b('0x26')]===_0xbf3b('0x27')&&typeof _0x3b7377[_0xbf3b('0x28')]==='undefined';var _0x1e38a5=_0x282972[_0xbf3b('0x29')];var _0x13c867=_0x45b001?0x0:_0x3b7377['offset'];var _0x2c39f4=_0x45b001?_0x282972[_0xbf3b('0x29')]:_0x3b7377[_0xbf3b('0x26')]+_0x3b7377[_0xbf3b('0x28')];var _0x2c1651;if(_0x2c39f4>=_0x1e38a5){_0x2c39f4=_0x1e38a5;_0x2c1651=0xc8;}else{_0x2c1651=0xce;}_0x4606ba[_0xbf3b('0x23')](_0x2c1651);return _0x4606ba[_0xbf3b('0x2a')](_0xbf3b('0x2b'),_0x13c867+'-'+_0x2c39f4+'/'+_0x1e38a5)[_0xbf3b('0x25')](_0x282972);}return null;};}function patchUpdates(_0x3637c6){return function(_0x4a6d18){try{jsonpatch[_0xbf3b('0x2c')](_0x4a6d18,_0x3637c6,!![]);}catch(_0x4b8c68){return BPromise[_0xbf3b('0x2d')](_0x4b8c68);}return _0x4a6d18[_0xbf3b('0x2e')]();};}function saveUpdates(_0x4d3611,_0x332f85){return function(_0x384862){if(_0x384862){return _0x384862[_0xbf3b('0x2f')](_0x4d3611)[_0xbf3b('0x30')](function(_0xd6897e){return _0xd6897e;});}return null;};}function removeEntity(_0x33bb6f,_0xe30cec){return function(_0x2fe5a9){if(_0x2fe5a9){return _0x2fe5a9[_0xbf3b('0x31')]()['then'](function(){_0x33bb6f[_0xbf3b('0x23')](0xcc)[_0xbf3b('0x24')]();});}};}function handleEntityNotFound(_0x48183a,_0x3da210){return function(_0x188fa1){if(!_0x188fa1){_0x48183a[_0xbf3b('0x22')](0x194);}return _0x188fa1;};}function handleError(_0x406021,_0x59ad1d){_0x59ad1d=_0x59ad1d||0x1f4;return function(_0x40ee9e){logger[_0xbf3b('0x32')](_0x40ee9e[_0xbf3b('0x33')]);if(_0x40ee9e[_0xbf3b('0x34')]){delete _0x40ee9e[_0xbf3b('0x34')];}_0x406021[_0xbf3b('0x23')](_0x59ad1d)['send'](_0x40ee9e);};}function getInteractionUsers(_0x1b64d5,_0x20aae4){return new BPromise(function(_0x5d3d2a,_0x3e3d0f){try{if(_0x20aae4[_0x1b64d5['id']]){_0x1b64d5[_0xbf3b('0x35')]=_['map'](_0x20aae4[_0x1b64d5['id']],function(_0x256bc8){return{'id':_0x256bc8['id'],'fullname':_0x256bc8[_0xbf3b('0x36')]};});}}catch(_0xf22fe4){_0x3e3d0f(_0xf22fe4);}_0x5d3d2a(_0x1b64d5);});}function getInteractionTags(_0x3173fb,_0x1309f4){return new BPromise(function(_0x1a990f,_0x4b97e0){try{if(_0x3173fb[_0xbf3b('0x37')]){_0x3173fb[_0xbf3b('0x38')]=[];_0x3173fb[_0xbf3b('0x37')][_0xbf3b('0x39')](',')[_0xbf3b('0x3a')](function(_0x532b3a){_0x3173fb['Tags'][_0xbf3b('0x3b')](_0x1309f4[_0x532b3a]);});}delete _0x3173fb['TagIds'];}catch(_0x27afcb){_0x4b97e0(_0x27afcb);}_0x1a990f(_0x3173fb);});}function updateSmsInteraction(_0x18e7c2,_0x20eb19,_0x420f85){return new BPromise(function(_0x1eab40,_0x198a4c){return getInteractionUsers(_0x18e7c2,_0x420f85)[_0xbf3b('0x30')](function(_0x17392c){return getInteractionTags(_0x17392c,_0x20eb19);})[_0xbf3b('0x30')](function(_0x58abc9){return getStateInteraction(_0x58abc9);})['then'](function(_0x11ec4f){_0x1eab40(_0x11ec4f);})['catch'](function(_0x1fe857){_0x198a4c(_0x1fe857);});});}function getStateInteraction(_0x5a5c7a){return new BPromise(function(_0x4d4a22){_0x5a5c7a['waiting']=0x0;_0x5a5c7a[_0xbf3b('0x3c')]=0x0;_0x5a5c7a['answered']=0x0;_0x5a5c7a['unmanaged']=0x0;_0x5a5c7a[_0xbf3b('0x3d')]=0x0;if(!_0x5a5c7a[_0xbf3b('0x3e')]&&!_0x5a5c7a[_0xbf3b('0x3f')]){_0x5a5c7a['waiting']+=0x1;}if(!_0x5a5c7a[_0xbf3b('0x3e')]&&_0x5a5c7a[_0xbf3b('0x3f')]){_0x5a5c7a[_0xbf3b('0x3c')]+=0x1;if(_0x5a5c7a['waiting']){_0x5a5c7a[_0xbf3b('0x40')]-=0x1;}}if(_0x5a5c7a[_0xbf3b('0x3e')]&&_0x5a5c7a[_0xbf3b('0x3f')]){_0x5a5c7a['answered']+=0x1;if(_0x5a5c7a[_0xbf3b('0x3c')]){_0x5a5c7a[_0xbf3b('0x3c')]-=0x1;}}if(_0x5a5c7a[_0xbf3b('0x3e')]&&!_0x5a5c7a[_0xbf3b('0x3f')]){_0x5a5c7a['unmanaged']+=0x1;if(_0x5a5c7a['waiting']){_0x5a5c7a[_0xbf3b('0x40')]-=0x1;}}_0x5a5c7a[_0xbf3b('0x3d')]+=0x1;_0x4d4a22(_0x5a5c7a);});}exports[_0xbf3b('0x41')]=function(_0x5425b9,_0x30256f){var _0xf453e8={},_0x2a7d77={},_0x1393dd={'count':0x0,'rows':[]};var _0x103990=_[_0xbf3b('0x42')](db[_0xbf3b('0x43')][_0xbf3b('0x44')],function(_0x58198e){return{'name':_0x58198e[_0xbf3b('0x45')],'type':_0x58198e[_0xbf3b('0x46')]['key']};});_0x2a7d77[_0xbf3b('0x47')]=_[_0xbf3b('0x42')](_0x103990,'name');_0x2a7d77[_0xbf3b('0x48')]=_[_0xbf3b('0x49')](_0x5425b9[_0xbf3b('0x48')]);_0x2a7d77[_0xbf3b('0x4a')]=_[_0xbf3b('0x4b')](_0x2a7d77[_0xbf3b('0x47')],_0x2a7d77[_0xbf3b('0x48')]);_0xf453e8['attributes']=_[_0xbf3b('0x4b')](_0x2a7d77[_0xbf3b('0x47')],qs[_0xbf3b('0x4c')](_0x5425b9[_0xbf3b('0x48')][_0xbf3b('0x4c')]));_0xf453e8[_0xbf3b('0x4d')]=_0xf453e8['attributes'][_0xbf3b('0x4e')]?_0xf453e8[_0xbf3b('0x4d')]:_0x2a7d77[_0xbf3b('0x47')];if(!_0x5425b9['query']['hasOwnProperty'](_0xbf3b('0x4f'))){_0xf453e8['limit']=qs['limit'](_0x5425b9[_0xbf3b('0x48')][_0xbf3b('0x28')]);_0xf453e8[_0xbf3b('0x26')]=qs[_0xbf3b('0x26')](_0x5425b9[_0xbf3b('0x48')][_0xbf3b('0x26')]);}_0xf453e8[_0xbf3b('0x50')]=qs[_0xbf3b('0x51')](_0x5425b9[_0xbf3b('0x48')]['sort']);_0xf453e8['where']=qs[_0xbf3b('0x4a')](_['pick'](_0x5425b9[_0xbf3b('0x48')],_0x2a7d77[_0xbf3b('0x4a')]),_0x103990);var _0x59ce9e=[];var _0x4f552c=squel[_0xbf3b('0x52')]()['field']('id')[_0xbf3b('0x53')]('name')[_0xbf3b('0x53')](_0xbf3b('0x54'))[_0xbf3b('0x55')](_0xbf3b('0x56'));var _0x521a24=squel[_0xbf3b('0x52')]()[_0xbf3b('0x53')](_0xbf3b('0x57'))[_0xbf3b('0x53')](_0xbf3b('0x58'))['field'](_0xbf3b('0x59'))['from']('user_has_sms_interactions','ui')[_0xbf3b('0x5a')](_0xbf3b('0x5b'),'u',_0xbf3b('0x5c'));var _0x5cd382=squel[_0xbf3b('0x52')]()[_0xbf3b('0x55')](_0xbf3b('0x5d'),'i')[_0xbf3b('0x5a')]('cm_contacts','c',_0xbf3b('0x5e'))[_0xbf3b('0x5a')]('users','o',_0xbf3b('0x5f'))['left_join']('sms_accounts','a','a.id\x20=\x20i.SmsAccountId')[_0xbf3b('0x5a')](_0xbf3b('0x60'),'me',_0xbf3b('0x61'))[_0xbf3b('0x5a')](_0xbf3b('0x62'),'it',_0xbf3b('0x63'))[_0xbf3b('0x5a')]('tools_tags','t',_0xbf3b('0x64'));var _0x57c25c=squel[_0xbf3b('0x65')]();var _0x3fc4b4=[];var _0x5e1ec6=squel[_0xbf3b('0x65')]();var _0x2fff6a;if(_0x5425b9[_0xbf3b('0x48')]['search']){_0x2fff6a=as[_0xbf3b('0x66')](_0x5425b9['query'][_0xbf3b('0x67')]);var _0x22614c=_0x2fff6a[_0xbf3b('0x68')];for(var _0x206162=0x0;_0x206162<_0x2fff6a['conditions'][_0xbf3b('0x4e')];_0x206162++){var _0x48c00f=_0x2fff6a[_0xbf3b('0x69')][_0x206162];var _0x1a2c1a='i';var _0x185a2d=_[_0xbf3b('0x6a')](_0x103990,[_0xbf3b('0x34'),_0x48c00f[_0xbf3b('0x53')]]);if(!_0x185a2d){switch(_0x48c00f[_0xbf3b('0x53')]){case _0xbf3b('0x6b'):if(_0x48c00f[_0xbf3b('0x6c')]==0x1){_0x5cd382['having']('`'+_0x48c00f[_0xbf3b('0x53')]+_0xbf3b('0x6d'));}else{_0x5cd382[_0xbf3b('0x6e')]('`'+_0x48c00f[_0xbf3b('0x53')]+_0xbf3b('0x6f'));}break;case'Contact':if(_0x48c00f[_0xbf3b('0x70')]===_0xbf3b('0x71')){if(_0x48c00f[_0xbf3b('0x6c')][_0xbf3b('0x39')]('\x20')[_0xbf3b('0x4e')]>0x1){_0x57c25c[_0x22614c](_0xbf3b('0x72'),qs[_0xbf3b('0x73')](_0x48c00f['value']),null);}else{var _0x2f6adf='%'+_0x48c00f['value']+'%';_0x57c25c[_0x22614c](_0xbf3b('0x74'),_0x2f6adf,_0x2f6adf,_0x2f6adf);}}else{_0x185a2d=_['find'](_0x103990,[_0xbf3b('0x34'),_0xbf3b('0x75')]);_0x48c00f['field']='ContactId';_0x311eab=as[_0xbf3b('0x76')](_0x1a2c1a,_0x185a2d[_0xbf3b('0x46')],_0x48c00f);_0x57c25c[_0x22614c](_0x311eab[_0xbf3b('0x77')],_0x311eab[_0xbf3b('0x6c')][_0xbf3b('0x78')],_0x311eab[_0xbf3b('0x6c')]['end']);}break;case _0xbf3b('0x79'):var _0x4327ef=_0x48c00f[_0xbf3b('0x6c')][_0xbf3b('0x39')](',')[_0xbf3b('0x42')](function(_0x5d222d){return Number(_0x5d222d);});_0x4327ef[_0xbf3b('0x3a')](function(_0x531375){_0x5e1ec6['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x531375+',%');});_0x3fc4b4=_['union'](_0x3fc4b4,_0x4327ef);break;case _0xbf3b('0x7a'):if(_0x48c00f[_0xbf3b('0x70')]===_0xbf3b('0x71')){_0x57c25c[_0x22614c](_0xbf3b('0x7b'),'%'+_0x48c00f[_0xbf3b('0x6c')]+'%',null);}else{_0x185a2d=_[_0xbf3b('0x6a')](_0x103990,[_0xbf3b('0x34'),_0xbf3b('0x3f')]);_0x48c00f['field']='UserId';_0x311eab=as[_0xbf3b('0x76')](_0x1a2c1a,_0x185a2d['type'],_0x48c00f);_0x57c25c[_0x22614c](_0x311eab[_0xbf3b('0x77')],_0x311eab[_0xbf3b('0x6c')]['start'],_0x311eab[_0xbf3b('0x6c')][_0xbf3b('0x24')]);}break;case _0xbf3b('0x7c'):_0x311eab=as['buildExpression']('me',null,_0x48c00f);_0x57c25c[_0x22614c](_0x311eab[_0xbf3b('0x77')],_0x311eab['value']['start'],_0x311eab[_0xbf3b('0x6c')][_0xbf3b('0x24')]);break;}}else{var _0x311eab=as['buildExpression'](_0x1a2c1a,_0x185a2d[_0xbf3b('0x46')],_0x48c00f);_0x57c25c[_0x22614c](_0x311eab[_0xbf3b('0x77')],_0x311eab[_0xbf3b('0x6c')][_0xbf3b('0x78')],_0x311eab[_0xbf3b('0x6c')][_0xbf3b('0x24')]);}}}else{var _0x2630e5=_(_0x5425b9['query'])[_0xbf3b('0x49')]()[_0xbf3b('0x42')](function(_0x2e217b){return _[_0xbf3b('0x7d')](_0x103990,['name',_0x2e217b])?_0x2e217b:undefined;})[_0xbf3b('0x7e')]()[_0xbf3b('0x6c')]();if(!_[_0xbf3b('0x7f')](_0x2630e5)){_0x2630e5[_0xbf3b('0x3a')](function(_0x47dafd){if(_0x47dafd===_0xbf3b('0x80')){_0x5cd382['where'](_0xbf3b('0x81'),[][_0xbf3b('0x82')](_0x5425b9[_0xbf3b('0x48')][_0x47dafd]));}else if(_0x47dafd==='createdAt'){var _0x42d3ec=JSON[_0xbf3b('0x83')](_0x5425b9['query'][_0x47dafd])[_0xbf3b('0x84')];var _0x23ad5c=JSON['parse'](_0x5425b9[_0xbf3b('0x48')][_0x47dafd])[_0xbf3b('0x85')];_0x5cd382[_0xbf3b('0x86')](_0xbf3b('0x87'),_0x42d3ec,_0x23ad5c);}else{if(_0x5425b9[_0xbf3b('0x48')][_0x47dafd]===_0xbf3b('0x88')){_0x5cd382[_0xbf3b('0x86')]('i.'+_0x47dafd+_0xbf3b('0x89'));}else{_0x5cd382[_0xbf3b('0x86')]('i.'+_0x47dafd+_0xbf3b('0x8a'),_0x5425b9[_0xbf3b('0x48')][_0x47dafd]);}}});}if(_0x5425b9[_0xbf3b('0x48')][_0xbf3b('0x8b')]){if(_0x5425b9[_0xbf3b('0x48')][_0xbf3b('0x8b')]==0x1){_0x5cd382[_0xbf3b('0x6e')]('`unreadMessages`\x20=\x200');}else{_0x5cd382['having'](_0xbf3b('0x8c'));}}if(_0x5425b9[_0xbf3b('0x48')]['tag']){_0x3fc4b4=_[_0xbf3b('0x8d')](_0x5425b9[_0xbf3b('0x48')]['tag'])?_0x5425b9[_0xbf3b('0x48')][_0xbf3b('0x8e')]:new Array(_0x5425b9['query']['tag']);_0x3fc4b4['forEach'](function(_0x28e7c0){_0x5e1ec6['or'](_0xbf3b('0x8f'),'%,'+_0x28e7c0+',%');});}if(_0x5425b9[_0xbf3b('0x48')]['filter']){var _0x514ebc=_0x5425b9[_0xbf3b('0x48')][_0xbf3b('0x90')][_0xbf3b('0x91')]('\x5c','\x5c\x5c')[_0xbf3b('0x91')](/'/g,'\x27\x27');if(qs['isNumeric'](_0x514ebc)){_0x57c25c['or'](_0xbf3b('0x92'),_0x514ebc+'%')['or'](_0xbf3b('0x93'),_0x514ebc+'%');}else{_0x57c25c['or'](_0xbf3b('0x94'),qs['getFullTextValue'](_0x514ebc))['or'](_0xbf3b('0x95'),_0x514ebc+'%');}}}_0x5cd382[_0xbf3b('0x86')](_0x57c25c);_0x5cd382[_0xbf3b('0x96')]('i.id');var _0x3e6ed7={'type':db[_0xbf3b('0x97')][_0xbf3b('0x98')][_0xbf3b('0x99')],'raw':!![]};var _0x162af6=_0x5cd382[_0xbf3b('0x9a')]();_0x162af6[_0xbf3b('0x53')](_0xbf3b('0x9b'));_0x162af6[_0xbf3b('0x53')](_0xbf3b('0x9c'),_0xbf3b('0x6b'));if(_0xf453e8[_0xbf3b('0x50')]){_0xf453e8[_0xbf3b('0x50')][_0xbf3b('0x3a')](function(_0x353b45){var _0x15ad8d=_0x353b45[0x0]===_0xbf3b('0x9d')?_0x353b45[0x0]:'i.'+_0x353b45[0x0];_0x5cd382[_0xbf3b('0x50')](_0x15ad8d,_0x353b45[0x1]===_0xbf3b('0x9e')?![]:!![]);});}if(!_[_0xbf3b('0x7f')](_0x3fc4b4)){_0x5cd382['having'](_0x5e1ec6);_0x162af6['where']('t.id\x20IN\x20?',_0x3fc4b4);}BPromise[_0xbf3b('0x9f')]()['then'](function(){if(!_0x2fff6a){if(_0x5425b9[_0xbf3b('0x48')][_0xbf3b('0x80')])return;_0x162af6[_0xbf3b('0x86')](_0xbf3b('0xa0'));_0x5cd382[_0xbf3b('0x86')](_0xbf3b('0xa0'));return;}if(_0x5425b9[_0xbf3b('0xa1')][_0xbf3b('0xa2')]!==_0xbf3b('0xa3'))return;return _0x5425b9[_0xbf3b('0xa1')][_0xbf3b('0xa4')]({'attributes':['id'],'raw':!![]})[_0xbf3b('0x30')](function(_0x10c92c){if(_[_0xbf3b('0x7f')](_0x10c92c)){_0x162af6[_0xbf3b('0x86')](_0xbf3b('0xa5'));_0x5cd382[_0xbf3b('0x86')](_0xbf3b('0xa5'));}else{_0x162af6[_0xbf3b('0x86')](_0xbf3b('0x81'),_[_0xbf3b('0x42')](_0x10c92c,'id'));_0x5cd382[_0xbf3b('0x86')](_0xbf3b('0x81'),_[_0xbf3b('0x42')](_0x10c92c,'id'));}});})[_0xbf3b('0x30')](function(){if(_0x5425b9[_0xbf3b('0xa1')][_0xbf3b('0xa2')]===_0xbf3b('0xa3')&&!_0x2fff6a&&!_0x5425b9[_0xbf3b('0x48')][_0xbf3b('0x80')])return[];return db[_0xbf3b('0xa6')][_0xbf3b('0x48')](_0x162af6['toString'](),_0x3e6ed7);})[_0xbf3b('0x30')](function(_0x21a0d1){_0x1393dd['count']=_0x21a0d1['length'];if(_0x1393dd[_0xbf3b('0x29')]===0x0)return[];return db['sequelize'][_0xbf3b('0x48')](_0x4f552c[_0xbf3b('0xa7')](),_0x3e6ed7)[_0xbf3b('0x30')](function(_0xe958d5){_0x59ce9e=_[_0xbf3b('0xa8')](_0xe958d5,'id');_0x3e6ed7=_[_0xbf3b('0xa9')](_0x3e6ed7,{'model':db['SmsInteraction'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x5425b9[_0xbf3b('0x48')][_0xbf3b('0x4c')]){_0xf453e8['attributes']['forEach'](function(_0x503bac){_0x5cd382['field']('i.'+_0x503bac);});}else{_0x5cd382[_0xbf3b('0x53')](_0xbf3b('0x9c'),_0xbf3b('0x6b'));_0x5cd382[_0xbf3b('0x53')](_0xbf3b('0xaa'),_0xbf3b('0xab'));_0x5cd382[_0xbf3b('0x53')](_0xbf3b('0xac'),_0xbf3b('0xad'));_0x5cd382[_0xbf3b('0x53')](_0xbf3b('0xae'),_0xbf3b('0x9d'));_0x5cd382['field'](_0xbf3b('0xaf'));_0x5cd382[_0xbf3b('0x53')](_0xbf3b('0xb0'),_0xbf3b('0xb1'));_0x5cd382[_0xbf3b('0x53')](_0xbf3b('0xb2'),_0xbf3b('0xb3'));_0x5cd382[_0xbf3b('0x53')]('c.email',_0xbf3b('0xb4'));_0x5cd382[_0xbf3b('0x53')](_0xbf3b('0xb5'),'Contact.phone');_0x5cd382[_0xbf3b('0x53')]('c.mobile',_0xbf3b('0xb6'));_0x5cd382[_0xbf3b('0x53')](_0xbf3b('0xb7'),'Contact.fax');_0x5cd382[_0xbf3b('0x53')](_0xbf3b('0xb8'),_0xbf3b('0xb9'));_0x5cd382['field']('o.internal','Owner.internal');_0x5cd382[_0xbf3b('0x53')](_0xbf3b('0xba'),_0xbf3b('0x37'));}if(_0xf453e8['limit'])_0x5cd382[_0xbf3b('0x28')](_0xf453e8[_0xbf3b('0x28')]);if(_0xf453e8[_0xbf3b('0x26')])_0x5cd382[_0xbf3b('0x26')](_0xf453e8[_0xbf3b('0x26')]);return db[_0xbf3b('0xa6')][_0xbf3b('0x48')](_0x5cd382['toString'](),_0x3e6ed7);})[_0xbf3b('0x30')](function(_0x59c1dc){if(_0x59c1dc[_0xbf3b('0x4e')]>0x0)_0x521a24[_0xbf3b('0x86')](_0xbf3b('0xbb'),_['map'](_0x59c1dc,'id'));return db['sequelize']['query'](_0x521a24[_0xbf3b('0xa7')](),_0x3e6ed7)[_0xbf3b('0x30')](function(_0x394cbe){var _0x5670bf=_[_0xbf3b('0xbc')](_0x394cbe,_0xbf3b('0xbd'));var _0x53cd08=[];_0x59c1dc[_0xbf3b('0x3a')](function(_0x235178){_0x53cd08[_0xbf3b('0x3b')](updateSmsInteraction(_0x235178,_0x59ce9e,_0x5670bf));});return BPromise[_0xbf3b('0xbe')](_0x53cd08);});});})[_0xbf3b('0x30')](function(_0x1fea21){_0x1393dd[_0xbf3b('0xbf')]=_0x1fea21;return _0x1393dd;})[_0xbf3b('0x30')](respondWithFilteredResult(_0x30256f,_0xf453e8))[_0xbf3b('0xc0')](handleError(_0x30256f,null));};exports['show']=function(_0x11b0a4,_0x1dc893){var _0x5adea1={'raw':![],'where':{'id':_0x11b0a4[_0xbf3b('0xc1')]['id']}},_0x176d0b={};_0x176d0b[_0xbf3b('0x47')]=_[_0xbf3b('0x49')](db[_0xbf3b('0x43')]['rawAttributes']);_0x176d0b[_0xbf3b('0x48')]=_[_0xbf3b('0x49')](_0x11b0a4[_0xbf3b('0x48')]);_0x176d0b[_0xbf3b('0x4a')]=_[_0xbf3b('0x4b')](_0x176d0b[_0xbf3b('0x47')],_0x176d0b['query']);_0x5adea1[_0xbf3b('0x4d')]=_[_0xbf3b('0x4b')](_0x176d0b[_0xbf3b('0x47')],qs['fields'](_0x11b0a4['query'][_0xbf3b('0x4c')]));_0x5adea1[_0xbf3b('0x4d')]=_0x5adea1['attributes']['length']?_0x5adea1[_0xbf3b('0x4d')]:_0x176d0b['model'];if(_0x11b0a4[_0xbf3b('0x48')][_0xbf3b('0xc2')]){_0x5adea1[_0xbf3b('0xc3')]=[{'all':!![]}];}_0x5adea1=_[_0xbf3b('0xa9')]({},_0x5adea1,_0x11b0a4[_0xbf3b('0xc4')]);return db[_0xbf3b('0x43')][_0xbf3b('0x6a')](_0x5adea1)[_0xbf3b('0x30')](handleEntityNotFound(_0x1dc893,null))[_0xbf3b('0x30')](respondWithResult(_0x1dc893,null))['catch'](handleError(_0x1dc893,null));};exports[_0xbf3b('0xc5')]=function(_0x1825f9,_0x917dc6){return db[_0xbf3b('0x43')][_0xbf3b('0xc5')](_0x1825f9[_0xbf3b('0x7c')],{})['then'](respondWithResult(_0x917dc6,0xc9))[_0xbf3b('0xc0')](handleError(_0x917dc6,null));};exports[_0xbf3b('0x2f')]=function(_0xc75428,_0x116f65){if(_0xc75428[_0xbf3b('0x7c')]['id']){delete _0xc75428['body']['id'];}return db[_0xbf3b('0x43')][_0xbf3b('0x6a')]({'where':{'id':_0xc75428[_0xbf3b('0xc1')]['id']}})[_0xbf3b('0x30')](handleEntityNotFound(_0x116f65,null))[_0xbf3b('0x30')](saveUpdates(_0xc75428[_0xbf3b('0x7c')],null))[_0xbf3b('0x30')](respondWithResult(_0x116f65,null))['catch'](handleError(_0x116f65,null));};exports[_0xbf3b('0x31')]=function(_0x4558b9,_0xd6cfb1){return db[_0xbf3b('0x43')][_0xbf3b('0x6a')]({'where':{'id':_0x4558b9[_0xbf3b('0xc1')]['id']}})[_0xbf3b('0x30')](handleEntityNotFound(_0xd6cfb1,null))[_0xbf3b('0x30')](removeEntity(_0xd6cfb1,null))['catch'](handleError(_0xd6cfb1,null));};exports[_0xbf3b('0xc6')]=function(_0x325cad,_0x586cbd){return db[_0xbf3b('0x43')][_0xbf3b('0xc6')]()[_0xbf3b('0x30')](respondWithResult(_0x586cbd,null))[_0xbf3b('0xc0')](handleError(_0x586cbd,null));};exports['addMessage']=function(_0x5a2856,_0x14edf4,_0x379ac2){return db[_0xbf3b('0xc7')]['find']({'where':{'id':_0x5a2856['params']['id']}})[_0xbf3b('0x30')](handleEntityNotFound(_0x14edf4,null))['then'](function(_0x912925){if(_0x912925){return _0x912925[_0xbf3b('0xc8')](_0x5a2856[_0xbf3b('0x7c')][_0xbf3b('0xc9')],_[_0xbf3b('0xca')](_0x5a2856[_0xbf3b('0x7c')],[_0xbf3b('0xc9'),'id'])||{});}})[_0xbf3b('0x30')](respondWithResult(_0x14edf4,null))[_0xbf3b('0xc0')](handleError(_0x14edf4,null));};exports[_0xbf3b('0xcb')]=function(_0x445235,_0x10ba91,_0x53e699){var _0x13d0c7={'raw':![],'where':{}};var _0x5db058={};var _0x359fcb={'count':0x0,'rows':[]};return db[_0xbf3b('0x43')][_0xbf3b('0xcc')]({'where':{'id':_0x445235[_0xbf3b('0xc1')]['id']}})[_0xbf3b('0x30')](handleEntityNotFound(_0x10ba91,null))['then'](function(_0x13ec1f){if(_0x13ec1f){_0x5db058[_0xbf3b('0x47')]=_[_0xbf3b('0x49')](db[_0xbf3b('0xc7')]['rawAttributes']);_0x5db058['query']=_[_0xbf3b('0x49')](_0x445235['query']);_0x5db058['filters']=_[_0xbf3b('0x4b')](_0x5db058[_0xbf3b('0x47')],_0x5db058[_0xbf3b('0x48')]);_0x13d0c7[_0xbf3b('0x4d')]=_[_0xbf3b('0x4b')](_0x5db058[_0xbf3b('0x47')],qs[_0xbf3b('0x4c')](_0x445235[_0xbf3b('0x48')][_0xbf3b('0x4c')]));_0x13d0c7[_0xbf3b('0x4d')]=_0x13d0c7[_0xbf3b('0x4d')][_0xbf3b('0x4e')]?_0x13d0c7[_0xbf3b('0x4d')]:_0x5db058['model'];if(!_0x445235['query'][_0xbf3b('0xcd')]('nolimit')){_0x13d0c7['limit']=qs[_0xbf3b('0x28')](_0x445235[_0xbf3b('0x48')][_0xbf3b('0x28')]);_0x13d0c7[_0xbf3b('0x26')]=qs[_0xbf3b('0x26')](_0x445235[_0xbf3b('0x48')][_0xbf3b('0x26')]);}_0x13d0c7[_0xbf3b('0x50')]=qs['sort'](_0x445235[_0xbf3b('0x48')][_0xbf3b('0x51')]);_0x13d0c7['where']=qs['filters'](_[_0xbf3b('0xce')](_0x445235[_0xbf3b('0x48')],_0x5db058[_0xbf3b('0x4a')]));_0x13d0c7[_0xbf3b('0x86')][_0xbf3b('0xbd')]=_0x13ec1f['id'];if(_0x445235['query']['filter']){_0x13d0c7[_0xbf3b('0x86')]=_[_0xbf3b('0xa9')](_0x13d0c7[_0xbf3b('0x86')],{'$or':_[_0xbf3b('0x42')](_0x13d0c7['attributes'],function(_0x5e6d6d){var _0xf1b67={};_0xf1b67[_0x5e6d6d]={'$like':'%'+_0x445235[_0xbf3b('0x48')][_0xbf3b('0x90')]+'%'};return _0xf1b67;})});}if(_0x445235['query'][_0xbf3b('0x84')]){var _0x539953=_0x445235[_0xbf3b('0x48')][_0xbf3b('0x84')][_0xbf3b('0x39')](',');var _0x220114={};_0x220114[_0x539953[0x0]]={'$gte':moment(_0x539953[0x1])[_0xbf3b('0xcf')](_0xbf3b('0xd0'))};_0x13d0c7[_0xbf3b('0x86')]=_[_0xbf3b('0xa9')](_0x13d0c7[_0xbf3b('0x86')],_0x220114);}_0x13d0c7=_[_0xbf3b('0xa9')]({},_0x13d0c7,_0x445235[_0xbf3b('0xc4')]);return db[_0xbf3b('0xc7')][_0xbf3b('0x29')]({'where':_0x13d0c7[_0xbf3b('0x86')]})[_0xbf3b('0x30')](function(_0x576cbd){_0x359fcb[_0xbf3b('0x29')]=_0x576cbd;if(_0x445235[_0xbf3b('0x48')][_0xbf3b('0xc2')]){_0x13d0c7[_0xbf3b('0xc3')]=[{'all':!![]}];}return db[_0xbf3b('0xc7')]['findAll'](_0x13d0c7);})[_0xbf3b('0x30')](function(_0x162cac){_0x359fcb[_0xbf3b('0xbf')]=_0x162cac;return _0x359fcb;});}})['then'](respondWithFilteredResult(_0x10ba91,_0x13d0c7))[_0xbf3b('0xc0')](handleError(_0x10ba91,null));};exports['addTags']=function(_0x5d1c88,_0x44481d,_0x3063c3){return db['SmsInteraction'][_0xbf3b('0x6a')]({'where':{'id':_0x5d1c88['params']['id']}})[_0xbf3b('0x30')](handleEntityNotFound(_0x44481d,null))[_0xbf3b('0x30')](function(_0xf7c7bd){if(_0xf7c7bd){return _0xf7c7bd[_0xbf3b('0xd1')](_0x5d1c88[_0xbf3b('0x7c')][_0xbf3b('0xc9')],_[_0xbf3b('0xca')](_0x5d1c88['body'],[_0xbf3b('0xc9'),'id'])||{})[_0xbf3b('0xd2')](function(){return db['Tag'][_0xbf3b('0xd3')]({'attributes':['id',_0xbf3b('0x34'),_0xbf3b('0x54')],'where':{'id':_0x5d1c88['body'][_0xbf3b('0xc9')]}});})['then'](function(_0xabd324){socket[_0xbf3b('0xd4')](_0xbf3b('0xd5'),{'id':Number(_0x5d1c88['params']['id']),'tags':_0xabd324||[]});return{'id':Number(_0x5d1c88[_0xbf3b('0xc1')]['id']),'tags':_0xabd324||[]};});}})[_0xbf3b('0x30')](respondWithResult(_0x44481d,null))['catch'](handleError(_0x44481d,null));};exports[_0xbf3b('0xd6')]=function(_0x1c6280,_0x14cbdd,_0x159ffc){return db['SmsInteraction']['find']({'where':{'id':_0x1c6280[_0xbf3b('0xc1')]['id']}})[_0xbf3b('0x30')](handleEntityNotFound(_0x14cbdd,null))['then'](function(_0x1ddd81){if(_0x1ddd81){return _0x1ddd81[_0xbf3b('0xd6')](_0x1c6280[_0xbf3b('0x48')]['ids']);}})[_0xbf3b('0x30')](respondWithStatusCode(_0x14cbdd,null))[_0xbf3b('0xc0')](handleError(_0x14cbdd,null));};exports[_0xbf3b('0xd7')]=function(_0x27e2bf,_0x255a92){var _0x136868=moment()[_0xbf3b('0xd8')]()[_0xbf3b('0xa7')]();var _0x5e6d1c=path['join'](config[_0xbf3b('0xd9')],_0xbf3b('0xda'),_0xbf3b('0xdb'),_0xbf3b('0xdc'));var _0x35adf0=path[_0xbf3b('0xdd')](config[_0xbf3b('0xd9')],'server',_0xbf3b('0xdb'),_0xbf3b('0xde'));var _0x387076=path[_0xbf3b('0xdd')](_0x5e6d1c,_0x136868);var _0xfe337=util['format']('transcript-%d-%s.zip',_0x27e2bf['params']['id'],_0x136868);var _0x23be88=path[_0xbf3b('0xdd')](_0x5e6d1c,_0xfe337);var _0x4e907d=[];_0x4e907d[_0xbf3b('0x3b')]({'model':db[_0xbf3b('0x7a')],'as':_0xbf3b('0x7a'),'attributes':['id',_0xbf3b('0x36')],'raw':!![]});_0x4e907d[_0xbf3b('0x3b')]({'model':db[_0xbf3b('0xdf')],'as':_0xbf3b('0xe0'),'attributes':['id',_0xbf3b('0xe1'),'lastName'],'raw':!![]});var _0x3b2b75=[{'model':db['SmsMessage'],'as':_0xbf3b('0xe2'),'attributes':['id',_0xbf3b('0x7c'),_0xbf3b('0xe3'),_0xbf3b('0xe4'),_0xbf3b('0xe5'),_0xbf3b('0x8b')],'include':_0x4e907d}];_0x3b2b75[_0xbf3b('0x3b')]({'model':db[_0xbf3b('0xe6')],'as':_0xbf3b('0xe7'),'attributes':['id','name']});_0x3b2b75[_0xbf3b('0x3b')]({'model':db['User'],'as':_0xbf3b('0xe8'),'attributes':['id',_0xbf3b('0x36')]});return db['SmsInteraction']['find']({'where':{'id':_0x27e2bf[_0xbf3b('0xc1')]['id']},'include':_0x3b2b75})['then'](handleEntityNotFound(_0x255a92,null))[_0xbf3b('0x30')](function(_0x558e44){if(_0x558e44){var _0x23f7f8=_0x558e44[_0xbf3b('0xe9')]({'plain':!![]});fs['mkdirSync'](_0x387076);var _0x5b676d={'channel':_0xbf3b('0xea'),'account':_0x23f7f8[_0xbf3b('0xe7')][_0xbf3b('0x34')],'agent':_0x23f7f8[_0xbf3b('0xe8')]?_0x23f7f8[_0xbf3b('0xe8')][_0xbf3b('0x36')]:'N.A.','createdAt':moment(_0x23f7f8['createdAt'])[_0xbf3b('0xcf')](_0xbf3b('0xd0'))[_0xbf3b('0xa7')](),'closedAt':_0x23f7f8['closed']?moment(_0x23f7f8[_0xbf3b('0xeb')])[_0xbf3b('0xcf')](_0xbf3b('0xd0'))[_0xbf3b('0xa7')]():'','disposition':_0x23f7f8[_0xbf3b('0xec')],'messages':_(_0x23f7f8['Messages'])[_0xbf3b('0x90')]({'secret':![]})[_0xbf3b('0x42')](function(_0x24787e){return{'date':moment(_0x24787e[_0xbf3b('0xe3')])['format']('YYYY-MM-DD\x20HH:mm:ss')[_0xbf3b('0xa7')](),'sender':_0x24787e[_0xbf3b('0xe4')]===_0xbf3b('0xed')?_0x24787e[_0xbf3b('0x7a')]?_0x24787e[_0xbf3b('0x7a')][_0xbf3b('0x36')]:_0xbf3b('0xee'):_0x24787e[_0xbf3b('0xe0')][_0xbf3b('0xe1')]+(_0x24787e['Contact']['lastName']?'\x20'+_0x24787e[_0xbf3b('0xe0')][_0xbf3b('0xef')]:''),'body':_0x24787e['body'],'direction':_0x24787e[_0xbf3b('0xe4')]===_0xbf3b('0xed')?'A':'C','secret':_0x24787e['secret'],'read':_0x24787e[_0xbf3b('0x8b')]};})[_0xbf3b('0x6c')]()};return ejs[_0xbf3b('0xf0')](path[_0xbf3b('0xdd')](config['root'],_0xbf3b('0xda'),_0xbf3b('0xf1'),'downloadInteraction.ejs'),{'interaction':_0x5b676d})['then'](function(_0x3e1e0f){var _0x261d25=path[_0xbf3b('0xdd')](_0x387076,_0xbf3b('0xf2')+_0x23f7f8['id']+'-'+_0x136868+_0xbf3b('0xf3'));var _0x464a4d={'path':_0x261d25,'channel':'Sms','interactionId':_0x23f7f8['id']};return pdf[_0xbf3b('0xf4')](_0x3e1e0f,_0x464a4d);})[_0xbf3b('0x30')](function(){return new BPromise(function(_0x60197b,_0x300e95){zipdir(_0x387076,{'saveTo':_0x23be88},function(_0xfc3661,_0xa43fbb){if(_0xfc3661)return _0x300e95(_0xfc3661);return _0x60197b(_0xa43fbb);});})[_0xbf3b('0x30')](function(){return new BPromise(function(_0x2daf00,_0x2450c6){rimraf(_0x387076,function(_0x194a6d){if(_0x194a6d)_0x2450c6(_0x194a6d);return _0x2daf00();});});})[_0xbf3b('0x30')](function(){return _0x255a92[_0xbf3b('0xd7')](_0x23be88,_0xfe337,function(_0x2be968){if(_0x2be968){console[_0xbf3b('0xf5')](_0xbf3b('0xf6'),_0x2be968);}else{fs['unlinkSync'](_0x23be88);}});});});}else{return _0x255a92[_0xbf3b('0x22')](0xc8);}})['catch'](handleError(_0x255a92,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff