ea5924ef5c5460e53d793ce11a64dd30b49201cf
[motion2.git] / server / api / intFreshdeskAccount / intFreshdeskAccount.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 _0xc686=['path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','querystring','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','error','stack','name','send','index','map','FreshdeskAccount','fieldName','type','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','order','sort','where','pick','filter','merge','VIRTUAL','options','include','findAll','rows','catch','show','params','rawAttributes','includeAll','find','create','body','FreshdeskConfiguration','getConfigurations','nolimit','addConfiguration','AccountId','Subjects','getSubjects','channel','Descriptions','findOne','remoteUri','apiKey','lastIndexOf','format','%s/%s','api/v2/ticket_fields','Basic\x20%s','requester','subject','agent','description','priority','group','ticket_type','remove','custom_dropdown','label','default','choices','capitalize','test','statusCode','getFields,\x20%s,\x20%s,\x20%s','getFields','stringify','Wrong\x20credentials','zip-dir','request-promise','bluebird','mustache','util'];(function(_0x315861,_0x735b4){var _0x3e2b76=function(_0x436457){while(--_0x436457){_0x315861['push'](_0x315861['shift']());}};_0x3e2b76(++_0x735b4);}(_0xc686,0x148));var _0x6c68=function(_0x5b644e,_0x2e5e07){_0x5b644e=_0x5b644e-0x0;var _0x49c6bf=_0xc686[_0x5b644e];return _0x49c6bf;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x6c68('0x0'));var jsonpatch=require('fast-json-patch');var rp=require(_0x6c68('0x1'));var moment=require('moment');var BPromise=require(_0x6c68('0x2'));var Mustache=require(_0x6c68('0x3'));var util=require(_0x6c68('0x4'));var path=require(_0x6c68('0x5'));var sox=require(_0x6c68('0x6'));var csv=require(_0x6c68('0x7'));var ejs=require(_0x6c68('0x8'));var fs=require('fs');var fs_extra=require(_0x6c68('0x9'));var _=require(_0x6c68('0xa'));var squel=require(_0x6c68('0xb'));var crypto=require(_0x6c68('0xc'));var jsforce=require(_0x6c68('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x6c68('0x7'));var querystring=require(_0x6c68('0xe'));var Papa=require('papaparse');var Redis=require(_0x6c68('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x6c68('0x10'));var as=require(_0x6c68('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x6c68('0x12'))('api');var utils=require(_0x6c68('0x13'));var config=require(_0x6c68('0x14'));var licenseUtil=require('../../config/license/util');var db=require(_0x6c68('0x15'))['db'];var integrations=require('../../components/integrations/configuration');function respondWithStatusCode(_0x4f947a,_0x29e0a5){_0x29e0a5=_0x29e0a5||0xcc;return function(_0x5c9dc5){if(_0x5c9dc5){return _0x4f947a[_0x6c68('0x16')](_0x29e0a5);}return _0x4f947a[_0x6c68('0x17')](_0x29e0a5)[_0x6c68('0x18')]();};}function respondWithResult(_0x4c4f5d,_0x25a4dc){_0x25a4dc=_0x25a4dc||0xc8;return function(_0xe1192c){if(_0xe1192c){return _0x4c4f5d[_0x6c68('0x17')](_0x25a4dc)[_0x6c68('0x19')](_0xe1192c);}};}function respondWithFilteredResult(_0x2dc30b,_0x494b6e){return function(_0x5a0a84){if(_0x5a0a84){var _0x49520f=typeof _0x494b6e[_0x6c68('0x1a')]===_0x6c68('0x1b')&&typeof _0x494b6e[_0x6c68('0x1c')]===_0x6c68('0x1b');var _0x50e459=_0x5a0a84[_0x6c68('0x1d')];var _0x16a4a0=_0x49520f?0x0:_0x494b6e['offset'];var _0x54a792=_0x49520f?_0x5a0a84[_0x6c68('0x1d')]:_0x494b6e[_0x6c68('0x1a')]+_0x494b6e[_0x6c68('0x1c')];var _0x5d7efc;if(_0x54a792>=_0x50e459){_0x54a792=_0x50e459;_0x5d7efc=0xc8;}else{_0x5d7efc=0xce;}_0x2dc30b[_0x6c68('0x17')](_0x5d7efc);return _0x2dc30b[_0x6c68('0x1e')](_0x6c68('0x1f'),_0x16a4a0+'-'+_0x54a792+'/'+_0x50e459)[_0x6c68('0x19')](_0x5a0a84);}return null;};}function patchUpdates(_0x153edb){return function(_0x232a63){try{jsonpatch[_0x6c68('0x20')](_0x232a63,_0x153edb,!![]);}catch(_0x3a5043){return BPromise[_0x6c68('0x21')](_0x3a5043);}return _0x232a63[_0x6c68('0x22')]();};}function saveUpdates(_0x5974e8,_0x201d7d){return function(_0x3879a2){if(_0x3879a2){return _0x3879a2[_0x6c68('0x23')](_0x5974e8)[_0x6c68('0x24')](function(_0xb06428){return _0xb06428;});}return null;};}function removeEntity(_0x2a4aba,_0x3e680a){return function(_0x47560e){if(_0x47560e){return _0x47560e[_0x6c68('0x25')]()[_0x6c68('0x24')](function(){_0x2a4aba[_0x6c68('0x17')](0xcc)[_0x6c68('0x18')]();});}};}function handleEntityNotFound(_0x1efc4e,_0x3b105c){return function(_0x45e351){if(!_0x45e351){_0x1efc4e[_0x6c68('0x16')](0x194);}return _0x45e351;};}function handleError(_0x69310b,_0x5c9c19){_0x5c9c19=_0x5c9c19||0x1f4;return function(_0x35eaa3){logger[_0x6c68('0x26')](_0x35eaa3[_0x6c68('0x27')]);if(_0x35eaa3[_0x6c68('0x28')]){delete _0x35eaa3[_0x6c68('0x28')];}_0x69310b[_0x6c68('0x17')](_0x5c9c19)[_0x6c68('0x29')](_0x35eaa3);};}exports[_0x6c68('0x2a')]=function(_0x111723,_0x4ec904){var _0x1321d1={},_0x43bf40={},_0x56b684={'count':0x0,'rows':[]};var _0x5a3f37=_[_0x6c68('0x2b')](db[_0x6c68('0x2c')]['rawAttributes'],function(_0x18f087){return{'name':_0x18f087[_0x6c68('0x2d')],'type':_0x18f087[_0x6c68('0x2e')]['key']};});_0x43bf40[_0x6c68('0x2f')]=_[_0x6c68('0x2b')](_0x5a3f37,_0x6c68('0x28'));_0x43bf40[_0x6c68('0x30')]=_[_0x6c68('0x31')](_0x111723[_0x6c68('0x30')]);_0x43bf40[_0x6c68('0x32')]=_[_0x6c68('0x33')](_0x43bf40[_0x6c68('0x2f')],_0x43bf40[_0x6c68('0x30')]);_0x1321d1[_0x6c68('0x34')]=_[_0x6c68('0x33')](_0x43bf40[_0x6c68('0x2f')],qs[_0x6c68('0x35')](_0x111723[_0x6c68('0x30')][_0x6c68('0x35')]));_0x1321d1['attributes']=_0x1321d1['attributes'][_0x6c68('0x36')]?_0x1321d1[_0x6c68('0x34')]:_0x43bf40[_0x6c68('0x2f')];if(!_0x111723[_0x6c68('0x30')][_0x6c68('0x37')]('nolimit')){_0x1321d1[_0x6c68('0x1c')]=qs[_0x6c68('0x1c')](_0x111723[_0x6c68('0x30')][_0x6c68('0x1c')]);_0x1321d1[_0x6c68('0x1a')]=qs[_0x6c68('0x1a')](_0x111723['query']['offset']);}_0x1321d1[_0x6c68('0x38')]=qs[_0x6c68('0x39')](_0x111723['query']['sort']);_0x1321d1[_0x6c68('0x3a')]=qs['filters'](_[_0x6c68('0x3b')](_0x111723[_0x6c68('0x30')],_0x43bf40['filters']),_0x5a3f37);if(_0x111723[_0x6c68('0x30')][_0x6c68('0x3c')]){_0x1321d1[_0x6c68('0x3a')]=_[_0x6c68('0x3d')](_0x1321d1[_0x6c68('0x3a')],{'$or':_[_0x6c68('0x2b')](_0x5a3f37,function(_0x32a716){if(_0x32a716[_0x6c68('0x2e')]!==_0x6c68('0x3e')){var _0x1bdadd={};_0x1bdadd[_0x32a716[_0x6c68('0x28')]]={'$like':'%'+_0x111723[_0x6c68('0x30')][_0x6c68('0x3c')]+'%'};return _0x1bdadd;}})});}_0x1321d1=_[_0x6c68('0x3d')]({},_0x1321d1,_0x111723[_0x6c68('0x3f')]);var _0x285292={'where':_0x1321d1[_0x6c68('0x3a')]};return db[_0x6c68('0x2c')][_0x6c68('0x1d')](_0x285292)[_0x6c68('0x24')](function(_0x10ea12){_0x56b684[_0x6c68('0x1d')]=_0x10ea12;if(_0x111723[_0x6c68('0x30')]['includeAll']){_0x1321d1[_0x6c68('0x40')]=[{'all':!![]}];}return db[_0x6c68('0x2c')][_0x6c68('0x41')](_0x1321d1);})['then'](function(_0x42bc91){_0x56b684[_0x6c68('0x42')]=_0x42bc91;return _0x56b684;})[_0x6c68('0x24')](respondWithFilteredResult(_0x4ec904,_0x1321d1))[_0x6c68('0x43')](handleError(_0x4ec904,null));};exports[_0x6c68('0x44')]=function(_0x154139,_0x13968a){var _0x388d2c={'raw':![],'where':{'id':_0x154139[_0x6c68('0x45')]['id']}},_0x17103f={};_0x17103f[_0x6c68('0x2f')]=_[_0x6c68('0x31')](db[_0x6c68('0x2c')][_0x6c68('0x46')]);_0x17103f[_0x6c68('0x30')]=_[_0x6c68('0x31')](_0x154139['query']);_0x17103f[_0x6c68('0x32')]=_[_0x6c68('0x33')](_0x17103f[_0x6c68('0x2f')],_0x17103f[_0x6c68('0x30')]);_0x388d2c['attributes']=_[_0x6c68('0x33')](_0x17103f[_0x6c68('0x2f')],qs['fields'](_0x154139[_0x6c68('0x30')][_0x6c68('0x35')]));_0x388d2c[_0x6c68('0x34')]=_0x388d2c['attributes'][_0x6c68('0x36')]?_0x388d2c[_0x6c68('0x34')]:_0x17103f[_0x6c68('0x2f')];if(_0x154139[_0x6c68('0x30')][_0x6c68('0x47')]){_0x388d2c[_0x6c68('0x40')]=[{'all':!![]}];}_0x388d2c=_['merge']({},_0x388d2c,_0x154139[_0x6c68('0x3f')]);return db['FreshdeskAccount'][_0x6c68('0x48')](_0x388d2c)['then'](handleEntityNotFound(_0x13968a,null))[_0x6c68('0x24')](respondWithResult(_0x13968a,null))['catch'](handleError(_0x13968a,null));};exports[_0x6c68('0x49')]=function(_0x40b3ed,_0x131344){return db[_0x6c68('0x2c')][_0x6c68('0x49')](_0x40b3ed[_0x6c68('0x4a')],{})[_0x6c68('0x24')](respondWithResult(_0x131344,0xc9))[_0x6c68('0x43')](handleError(_0x131344,null));};exports['update']=function(_0x19f1fc,_0x49b046){if(_0x19f1fc['body']['id']){delete _0x19f1fc[_0x6c68('0x4a')]['id'];}return db[_0x6c68('0x2c')][_0x6c68('0x48')]({'where':{'id':_0x19f1fc[_0x6c68('0x45')]['id']}})[_0x6c68('0x24')](handleEntityNotFound(_0x49b046,null))['then'](saveUpdates(_0x19f1fc[_0x6c68('0x4a')],null))[_0x6c68('0x24')](respondWithResult(_0x49b046,null))[_0x6c68('0x43')](handleError(_0x49b046,null));};exports['destroy']=function(_0x30defa,_0x42bda2){return db[_0x6c68('0x2c')][_0x6c68('0x48')]({'where':{'id':_0x30defa['params']['id']}})['then'](handleEntityNotFound(_0x42bda2,null))[_0x6c68('0x24')](removeEntity(_0x42bda2,null))[_0x6c68('0x43')](handleError(_0x42bda2,null));};exports['getConfigurations']=function(_0x41d4c9,_0x506198,_0x501353){var _0x472e49={};var _0x53c905={};var _0x42c8c1;var _0x1cf860;return db[_0x6c68('0x2c')]['findOne']({'where':{'id':_0x41d4c9['params']['id']}})['then'](handleEntityNotFound(_0x506198,null))[_0x6c68('0x24')](function(_0x3a56dd){if(_0x3a56dd){_0x42c8c1=_0x3a56dd;_0x53c905[_0x6c68('0x2f')]=_[_0x6c68('0x31')](db[_0x6c68('0x4b')][_0x6c68('0x46')]);_0x53c905[_0x6c68('0x30')]=_[_0x6c68('0x31')](_0x41d4c9['query']);_0x53c905[_0x6c68('0x32')]=_['intersection'](_0x53c905[_0x6c68('0x2f')],_0x53c905[_0x6c68('0x30')]);_0x472e49[_0x6c68('0x34')]=_[_0x6c68('0x33')](_0x53c905['model'],qs[_0x6c68('0x35')](_0x41d4c9[_0x6c68('0x30')]['fields']));_0x472e49[_0x6c68('0x34')]=_0x472e49[_0x6c68('0x34')][_0x6c68('0x36')]?_0x472e49[_0x6c68('0x34')]:_0x53c905[_0x6c68('0x2f')];_0x472e49['order']=qs[_0x6c68('0x39')](_0x41d4c9[_0x6c68('0x30')]['sort']);_0x472e49['where']=qs[_0x6c68('0x32')](_['pick'](_0x41d4c9[_0x6c68('0x30')],_0x53c905[_0x6c68('0x32')]));if(_0x41d4c9[_0x6c68('0x30')][_0x6c68('0x3c')]){_0x472e49[_0x6c68('0x3a')]=_[_0x6c68('0x3d')](_0x472e49['where'],{'$or':_['map'](_0x472e49[_0x6c68('0x34')],function(_0x2526bd){var _0x109187={};_0x109187[_0x2526bd]={'$like':'%'+_0x41d4c9[_0x6c68('0x30')][_0x6c68('0x3c')]+'%'};return _0x109187;})});}_0x472e49=_[_0x6c68('0x3d')]({},_0x472e49,_0x41d4c9[_0x6c68('0x3f')]);return _0x42c8c1[_0x6c68('0x4c')](_0x472e49);}})['then'](function(_0x509852){if(_0x509852){_0x1cf860=_0x509852['length'];if(!_0x41d4c9[_0x6c68('0x30')]['hasOwnProperty'](_0x6c68('0x4d'))){_0x472e49[_0x6c68('0x1c')]=qs['limit'](_0x41d4c9[_0x6c68('0x30')][_0x6c68('0x1c')]);_0x472e49[_0x6c68('0x1a')]=qs[_0x6c68('0x1a')](_0x41d4c9[_0x6c68('0x30')][_0x6c68('0x1a')]);}return _0x42c8c1[_0x6c68('0x4c')](_0x472e49);}})[_0x6c68('0x24')](function(_0x1b1d29){if(_0x1b1d29){return _0x1b1d29?{'count':_0x1cf860,'rows':_0x1b1d29}:null;}})['then'](respondWithResult(_0x506198,null))[_0x6c68('0x43')](handleError(_0x506198,null));};exports[_0x6c68('0x4e')]=function(_0x156061,_0x649c35,_0x3b803f){if(_0x156061[_0x6c68('0x4a')]['id']){delete _0x156061[_0x6c68('0x4a')]['id'];}return db['FreshdeskAccount']['findOne']({'where':{'id':_0x156061[_0x6c68('0x45')]['id']}})[_0x6c68('0x24')](handleEntityNotFound(_0x649c35,null))[_0x6c68('0x24')](function(_0x4afb5c){if(_0x4afb5c){_0x156061['body'][_0x6c68('0x4f')]=_0x4afb5c['id'];_0x156061['body'][_0x6c68('0x50')]=integrations[_0x6c68('0x51')](_0x156061[_0x6c68('0x4a')][_0x6c68('0x52')],_0x156061['body'][_0x6c68('0x2e')]);_0x156061[_0x6c68('0x4a')][_0x6c68('0x53')]=integrations['getDescriptions'](_0x156061[_0x6c68('0x4a')]['channel'],_0x156061[_0x6c68('0x4a')][_0x6c68('0x2e')]);return db[_0x6c68('0x4b')][_0x6c68('0x49')](_0x156061[_0x6c68('0x4a')],{'include':[{'model':db['FreshdeskField'],'as':_0x6c68('0x50')},{'model':db['FreshdeskField'],'as':_0x6c68('0x53')}]});}return null;})[_0x6c68('0x24')](respondWithResult(_0x649c35,null))[_0x6c68('0x43')](handleError(_0x649c35,null));};exports['getFields']=function(_0x109f24,_0x13c411,_0x2571b3){var _0x1ead1d='';return db[_0x6c68('0x2c')][_0x6c68('0x54')]({'where':{'id':_0x109f24['params']['id']},'attributes':['id',_0x6c68('0x55'),_0x6c68('0x56')]})[_0x6c68('0x24')](handleEntityNotFound(_0x13c411,null))['then'](function(_0x821b3f){if(_0x821b3f){_0x1ead1d=_0x821b3f[_0x6c68('0x55')];var _0x452fa9=_0x1ead1d['slice'](-0x1);if(_0x452fa9==='/'){_0x1ead1d=_0x1ead1d['substring'](0x0,_0x1ead1d[_0x6c68('0x57')](_0x452fa9));}return rp({'method':'GET','uri':util[_0x6c68('0x58')](_0x6c68('0x59'),_0x1ead1d,_0x6c68('0x5a')),'headers':{'Authorization':util[_0x6c68('0x58')](_0x6c68('0x5b'),new Buffer(util[_0x6c68('0x58')]('%s:X',_0x821b3f[_0x6c68('0x56')]))['toString']('base64'))},'json':!![]});}})['then'](function(_0x11338a){if(_0x11338a){var _0x4325ce=[_0x6c68('0x5c'),_0x6c68('0x5d'),_0x6c68('0x5e'),_0x6c68('0x5f'),_0x6c68('0x17'),_0x6c68('0x60'),_0x6c68('0x61'),'source',_0x6c68('0x62'),_0x6c68('0x61'),'company'];_[_0x6c68('0x63')](_0x11338a,function(_0x4e20cd){return _0x4325ce['includes'](_0x4e20cd[_0x6c68('0x28')])||!_0x4e20cd['default']&&_0x4e20cd[_0x6c68('0x2e')]!=='custom_text'&&_0x4e20cd[_0x6c68('0x2e')]!==_0x6c68('0x64');});return{'count':_0x11338a['length'],'rows':_[_0x6c68('0x2b')](_0x11338a,function(_0x15d769){return{'id':_0x15d769[_0x6c68('0x28')],'name':_0x15d769[_0x6c68('0x65')],'custom':!_0x15d769[_0x6c68('0x66')],'options':_0x15d769[_0x6c68('0x67')]?_['map'](_0x15d769[_0x6c68('0x67')],function(_0x43eb0e){return{'name':_[_0x6c68('0x68')](_0x43eb0e),'value':_0x43eb0e};}):[]};})};}})['then'](respondWithResult(_0x13c411,null))[_0x6c68('0x43')](function(_0x1e900f){var _0x20ed9c=_0x109f24['query'][_0x6c68('0x69')]?0x1f4:_0x1e900f[_0x6c68('0x6a')]||0x1f4;logger[_0x6c68('0x26')](_0x6c68('0x6b'),_0x6c68('0x6c'),_0x20ed9c,JSON[_0x6c68('0x6d')](_0x1e900f));delete _0x1e900f[_0x6c68('0x28')];if(_0x20ed9c===0x191){_0x20ed9c=0x190;}_0x13c411[_0x6c68('0x17')](_0x20ed9c)[_0x6c68('0x29')](_0x109f24[_0x6c68('0x30')]['test']?{'message':_0x6c68('0x6e'),'statusCode':_0x1e900f[_0x6c68('0x6a')]}:_0x1e900f);});};