20d35e675527e5dfef6b71ba7469b482d9a2bcf8
[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 _0xb19e=['result','sendStatus','status','end','json','count','offset','set','Content-Range','apply','reject','save','update','destroy','stack','name','send','index','map','FreshdeskAccount','rawAttributes','fieldName','type','key','model','keys','filters','query','intersection','fields','attributes','hasOwnProperty','nolimit','limit','order','sort','pick','filter','where','merge','VIRTUAL','options','findAll','rows','catch','params','length','includeAll','find','create','body','getConfigurations','findOne','FreshdeskConfiguration','AccountId','Subjects','getSubjects','channel','Descriptions','getDescriptions','FreshdeskField','remoteUri','apiKey','slice','substring','format','%s/%s','api/v2/ticket_fields','Basic\x20%s','%s:X','toString','requester','subject','agent','source','group','includes','custom_text','custom_dropdown','label','choices','capitalize','test','statusCode','getFields,\x20%s,\x20%s,\x20%s','getFields','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','util','path','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','client','http','request','then','info','request\x20sent','debug','FreshdeskAccount,\x20%s,\x20%s,\x20%s','stringify','error','message','FreshdeskAccount,\x20%s,\x20%s'];(function(_0x4ea69d,_0x290f53){var _0x5318e0=function(_0x18e081){while(--_0x18e081){_0x4ea69d['push'](_0x4ea69d['shift']());}};_0x5318e0(++_0x290f53);}(_0xb19e,0x1cd));var _0xeb19=function(_0x243217,_0x522951){_0x243217=_0x243217-0x0;var _0x478029=_0xb19e[_0x243217];return _0x478029;};'use strict';var pdf=require(_0xeb19('0x0'));var emlformat=require('eml-format');var rimraf=require(_0xeb19('0x1'));var zipdir=require(_0xeb19('0x2'));var jsonpatch=require(_0xeb19('0x3'));var rp=require(_0xeb19('0x4'));var moment=require('moment');var BPromise=require(_0xeb19('0x5'));var Mustache=require('mustache');var util=require(_0xeb19('0x6'));var path=require(_0xeb19('0x7'));var sox=require('sox');var csv=require(_0xeb19('0x8'));var ejs=require(_0xeb19('0x9'));var fs=require('fs');var _=require(_0xeb19('0xa'));var squel=require(_0xeb19('0xb'));var crypto=require(_0xeb19('0xc'));var jsforce=require(_0xeb19('0xd'));var deskjs=require(_0xeb19('0xe'));var toCsv=require(_0xeb19('0x8'));var querystring=require('querystring');var Papa=require(_0xeb19('0xf'));var Redis=require(_0xeb19('0x10'));var authService=require(_0xeb19('0x11'));var qs=require(_0xeb19('0x12'));var as=require(_0xeb19('0x13'));var hardwareService=require(_0xeb19('0x14'));var logger=require(_0xeb19('0x15'))(_0xeb19('0x16'));var utils=require('../../config/utils');var config=require(_0xeb19('0x17'));var licenseUtil=require(_0xeb19('0x18'));var db=require(_0xeb19('0x19'))['db'];var integrations=require(_0xeb19('0x1a'));var jayson=require('jayson/promise');var client=jayson[_0xeb19('0x1b')][_0xeb19('0x1c')]({'port':0x232a});function respondWithRpcPromise(_0x385025,_0x2ab69f,_0x21438f,_0x174113){return new BPromise(function(_0x4453db,_0x486662){var _0x20aeb5=_0x174113||client;return _0x20aeb5[_0xeb19('0x1d')](_0x385025,_0x21438f)[_0xeb19('0x1e')](function(_0x4e7a54){logger[_0xeb19('0x1f')]('FreshdeskAccount,\x20%s,\x20%s',_0x2ab69f,_0xeb19('0x20'));logger[_0xeb19('0x21')](_0xeb19('0x22'),_0x2ab69f,'request\x20sent',JSON[_0xeb19('0x23')](_0x4e7a54));if(_0x4e7a54[_0xeb19('0x24')]){if(_0x4e7a54[_0xeb19('0x24')]['code']===0x1f4){logger[_0xeb19('0x24')]('FreshdeskAccount,\x20%s,\x20%s',_0x2ab69f,_0x4e7a54[_0xeb19('0x24')][_0xeb19('0x25')]);return _0x486662(_0x4e7a54[_0xeb19('0x24')]['message']);}logger[_0xeb19('0x24')](_0xeb19('0x26'),_0x2ab69f,_0x4e7a54['error'][_0xeb19('0x25')]);return _0x4453db(_0x4e7a54[_0xeb19('0x24')][_0xeb19('0x25')]);}else{logger[_0xeb19('0x1f')](_0xeb19('0x26'),_0x2ab69f,_0xeb19('0x20'));_0x4453db(_0x4e7a54[_0xeb19('0x27')][_0xeb19('0x25')]);}})['catch'](function(_0x4b91e1){logger[_0xeb19('0x24')]('FreshdeskAccount,\x20%s,\x20%s',_0x2ab69f,_0x4b91e1);_0x486662(_0x4b91e1);});});}function respondWithStatusCode(_0x3df11b,_0x17dd60){_0x17dd60=_0x17dd60||0xcc;return function(_0x42f62e){if(_0x42f62e){return _0x3df11b[_0xeb19('0x28')](_0x17dd60);}return _0x3df11b[_0xeb19('0x29')](_0x17dd60)[_0xeb19('0x2a')]();};}function respondWithResult(_0x370620,_0x5d2c8f){_0x5d2c8f=_0x5d2c8f||0xc8;return function(_0x5c955d){if(_0x5c955d){return _0x370620['status'](_0x5d2c8f)[_0xeb19('0x2b')](_0x5c955d);}};}function respondWithFilteredResult(_0x4bcefd,_0x1426f5){return function(_0x49885c){if(_0x49885c){var _0xf74549=_0x49885c[_0xeb19('0x2c')],_0x3383d5=_0x1426f5[_0xeb19('0x2d')],_0x44e066=_0x1426f5[_0xeb19('0x2d')]+_0x1426f5['limit'],_0x40263a;if(_0x44e066>=_0xf74549){_0x44e066=_0xf74549;_0x40263a=0xc8;}else{_0x40263a=0xce;}_0x4bcefd[_0xeb19('0x29')](_0x40263a);return _0x4bcefd[_0xeb19('0x2e')](_0xeb19('0x2f'),_0x3383d5+'-'+_0x44e066+'/'+_0xf74549)[_0xeb19('0x2b')](_0x49885c);}return null;};}function patchUpdates(_0x5f7c48){return function(_0x104e86){try{jsonpatch[_0xeb19('0x30')](_0x104e86,_0x5f7c48,!![]);}catch(_0x3615e8){return BPromise[_0xeb19('0x31')](_0x3615e8);}return _0x104e86[_0xeb19('0x32')]();};}function saveUpdates(_0x4d90c5,_0x1f6c96){return function(_0x4a3bd4){if(_0x4a3bd4){return _0x4a3bd4[_0xeb19('0x33')](_0x4d90c5)[_0xeb19('0x1e')](function(_0x2a87e2){return _0x2a87e2;});}return null;};}function removeEntity(_0x2df02d,_0x31a935){return function(_0x5ba7ce){if(_0x5ba7ce){return _0x5ba7ce[_0xeb19('0x34')]()['then'](function(){_0x2df02d[_0xeb19('0x29')](0xcc)[_0xeb19('0x2a')]();});}};}function handleEntityNotFound(_0x323672,_0x136504){return function(_0x699bc2){if(!_0x699bc2){_0x323672[_0xeb19('0x28')](0x194);}return _0x699bc2;};}function handleError(_0x127120,_0x3e2ad6){_0x3e2ad6=_0x3e2ad6||0x1f4;return function(_0x502986){logger[_0xeb19('0x24')](_0x502986[_0xeb19('0x35')]);if(_0x502986[_0xeb19('0x36')]){delete _0x502986[_0xeb19('0x36')];}_0x127120[_0xeb19('0x29')](_0x3e2ad6)[_0xeb19('0x37')](_0x502986);};}exports[_0xeb19('0x38')]=function(_0x5be184,_0xcd583c){var _0x20c8de={},_0x2ea239={},_0x8cc959={'count':0x0,'rows':[]};var _0x45be74=_[_0xeb19('0x39')](db[_0xeb19('0x3a')][_0xeb19('0x3b')],function(_0x233928){return{'name':_0x233928[_0xeb19('0x3c')],'type':_0x233928[_0xeb19('0x3d')][_0xeb19('0x3e')]};});_0x2ea239[_0xeb19('0x3f')]=_[_0xeb19('0x39')](_0x45be74,_0xeb19('0x36'));_0x2ea239['query']=_[_0xeb19('0x40')](_0x5be184['query']);_0x2ea239[_0xeb19('0x41')]=_['intersection'](_0x2ea239[_0xeb19('0x3f')],_0x2ea239[_0xeb19('0x42')]);_0x20c8de['attributes']=_[_0xeb19('0x43')](_0x2ea239['model'],qs[_0xeb19('0x44')](_0x5be184[_0xeb19('0x42')][_0xeb19('0x44')]));_0x20c8de[_0xeb19('0x45')]=_0x20c8de[_0xeb19('0x45')]['length']?_0x20c8de['attributes']:_0x2ea239[_0xeb19('0x3f')];if(!_0x5be184[_0xeb19('0x42')][_0xeb19('0x46')](_0xeb19('0x47'))){_0x20c8de[_0xeb19('0x48')]=qs[_0xeb19('0x48')](_0x5be184['query'][_0xeb19('0x48')]);_0x20c8de[_0xeb19('0x2d')]=qs[_0xeb19('0x2d')](_0x5be184['query'][_0xeb19('0x2d')]);}_0x20c8de[_0xeb19('0x49')]=qs[_0xeb19('0x4a')](_0x5be184['query'][_0xeb19('0x4a')]);_0x20c8de['where']=qs[_0xeb19('0x41')](_[_0xeb19('0x4b')](_0x5be184[_0xeb19('0x42')],_0x2ea239['filters']),_0x45be74);if(_0x5be184[_0xeb19('0x42')][_0xeb19('0x4c')]){_0x20c8de[_0xeb19('0x4d')]=_[_0xeb19('0x4e')](_0x20c8de[_0xeb19('0x4d')],{'$or':_[_0xeb19('0x39')](_0x45be74,function(_0x3ed0a8){if(_0x3ed0a8[_0xeb19('0x3d')]!==_0xeb19('0x4f')){var _0x1bb0d8={};_0x1bb0d8[_0x3ed0a8['name']]={'$like':'%'+_0x5be184[_0xeb19('0x42')]['filter']+'%'};return _0x1bb0d8;}})});}_0x20c8de=_['merge']({},_0x20c8de,_0x5be184[_0xeb19('0x50')]);var _0xcc0c4c={'where':_0x20c8de[_0xeb19('0x4d')]};return db[_0xeb19('0x3a')][_0xeb19('0x2c')](_0xcc0c4c)[_0xeb19('0x1e')](function(_0x254182){_0x8cc959['count']=_0x254182;if(_0x5be184[_0xeb19('0x42')]['includeAll']){_0x20c8de['include']=[{'all':!![]}];}return db[_0xeb19('0x3a')][_0xeb19('0x51')](_0x20c8de);})[_0xeb19('0x1e')](function(_0x18d09a){_0x8cc959[_0xeb19('0x52')]=_0x18d09a;return _0x8cc959;})[_0xeb19('0x1e')](respondWithFilteredResult(_0xcd583c,_0x20c8de))[_0xeb19('0x53')](handleError(_0xcd583c,null));};exports['show']=function(_0x160e13,_0x4fc7a7){var _0x11b856={'raw':![],'where':{'id':_0x160e13[_0xeb19('0x54')]['id']}},_0x4704ff={};_0x4704ff['model']=_[_0xeb19('0x40')](db['FreshdeskAccount']['rawAttributes']);_0x4704ff['query']=_[_0xeb19('0x40')](_0x160e13[_0xeb19('0x42')]);_0x4704ff[_0xeb19('0x41')]=_[_0xeb19('0x43')](_0x4704ff[_0xeb19('0x3f')],_0x4704ff['query']);_0x11b856['attributes']=_['intersection'](_0x4704ff[_0xeb19('0x3f')],qs['fields'](_0x160e13[_0xeb19('0x42')][_0xeb19('0x44')]));_0x11b856['attributes']=_0x11b856['attributes'][_0xeb19('0x55')]?_0x11b856[_0xeb19('0x45')]:_0x4704ff[_0xeb19('0x3f')];if(_0x160e13['query'][_0xeb19('0x56')]){_0x11b856['include']=[{'all':!![]}];}_0x11b856=_['merge']({},_0x11b856,_0x160e13['options']);return db[_0xeb19('0x3a')][_0xeb19('0x57')](_0x11b856)['then'](handleEntityNotFound(_0x4fc7a7,null))[_0xeb19('0x1e')](respondWithResult(_0x4fc7a7,null))[_0xeb19('0x53')](handleError(_0x4fc7a7,null));};exports[_0xeb19('0x58')]=function(_0x530908,_0xd6842d){return db[_0xeb19('0x3a')]['create'](_0x530908[_0xeb19('0x59')],{})[_0xeb19('0x1e')](respondWithResult(_0xd6842d,0xc9))[_0xeb19('0x53')](handleError(_0xd6842d,null));};exports['update']=function(_0x36d602,_0x47500f){if(_0x36d602[_0xeb19('0x59')]['id']){delete _0x36d602['body']['id'];}return db[_0xeb19('0x3a')]['find']({'where':{'id':_0x36d602[_0xeb19('0x54')]['id']}})['then'](handleEntityNotFound(_0x47500f,null))[_0xeb19('0x1e')](saveUpdates(_0x36d602[_0xeb19('0x59')],null))[_0xeb19('0x1e')](respondWithResult(_0x47500f,null))['catch'](handleError(_0x47500f,null));};exports[_0xeb19('0x34')]=function(_0x4fade9,_0x54e1bf){return db['FreshdeskAccount'][_0xeb19('0x57')]({'where':{'id':_0x4fade9['params']['id']}})[_0xeb19('0x1e')](handleEntityNotFound(_0x54e1bf,null))[_0xeb19('0x1e')](removeEntity(_0x54e1bf,null))[_0xeb19('0x53')](handleError(_0x54e1bf,null));};exports[_0xeb19('0x5a')]=function(_0x134eae,_0x5069a9,_0x2c9c9d){var _0x5e75ce={};var _0x257201={};var _0x192364;var _0xaa77f1;return db['FreshdeskAccount'][_0xeb19('0x5b')]({'where':{'id':_0x134eae[_0xeb19('0x54')]['id']}})['then'](handleEntityNotFound(_0x5069a9,null))['then'](function(_0x2acce5){if(_0x2acce5){_0x192364=_0x2acce5;_0x257201[_0xeb19('0x3f')]=_[_0xeb19('0x40')](db[_0xeb19('0x5c')]['rawAttributes']);_0x257201['query']=_['keys'](_0x134eae['query']);_0x257201[_0xeb19('0x41')]=_['intersection'](_0x257201['model'],_0x257201[_0xeb19('0x42')]);_0x5e75ce[_0xeb19('0x45')]=_[_0xeb19('0x43')](_0x257201[_0xeb19('0x3f')],qs[_0xeb19('0x44')](_0x134eae[_0xeb19('0x42')]['fields']));_0x5e75ce['attributes']=_0x5e75ce[_0xeb19('0x45')][_0xeb19('0x55')]?_0x5e75ce[_0xeb19('0x45')]:_0x257201[_0xeb19('0x3f')];_0x5e75ce[_0xeb19('0x49')]=qs[_0xeb19('0x4a')](_0x134eae['query']['sort']);_0x5e75ce[_0xeb19('0x4d')]=qs['filters'](_['pick'](_0x134eae[_0xeb19('0x42')],_0x257201[_0xeb19('0x41')]));if(_0x134eae[_0xeb19('0x42')][_0xeb19('0x4c')]){_0x5e75ce[_0xeb19('0x4d')]=_[_0xeb19('0x4e')](_0x5e75ce['where'],{'$or':_[_0xeb19('0x39')](_0x5e75ce[_0xeb19('0x45')],function(_0x26c309){var _0x1f4f73={};_0x1f4f73[_0x26c309]={'$like':'%'+_0x134eae[_0xeb19('0x42')][_0xeb19('0x4c')]+'%'};return _0x1f4f73;})});}_0x5e75ce=_['merge']({},_0x5e75ce,_0x134eae[_0xeb19('0x50')]);return _0x192364[_0xeb19('0x5a')](_0x5e75ce);}})['then'](function(_0x5e3c60){if(_0x5e3c60){_0xaa77f1=_0x5e3c60[_0xeb19('0x55')];if(!_0x134eae[_0xeb19('0x42')][_0xeb19('0x46')](_0xeb19('0x47'))){_0x5e75ce['limit']=qs['limit'](_0x134eae[_0xeb19('0x42')]['limit']);_0x5e75ce['offset']=qs['offset'](_0x134eae['query'][_0xeb19('0x2d')]);}return _0x192364['getConfigurations'](_0x5e75ce);}})[_0xeb19('0x1e')](function(_0x163db3){if(_0x163db3){return _0x163db3?{'count':_0xaa77f1,'rows':_0x163db3}:null;}})['then'](respondWithResult(_0x5069a9,null))[_0xeb19('0x53')](handleError(_0x5069a9,null));};exports['addConfiguration']=function(_0x5eb8d8,_0x5d79d2,_0x451d6f){if(_0x5eb8d8[_0xeb19('0x59')]['id']){delete _0x5eb8d8[_0xeb19('0x59')]['id'];}return db[_0xeb19('0x3a')][_0xeb19('0x5b')]({'where':{'id':_0x5eb8d8['params']['id']}})[_0xeb19('0x1e')](handleEntityNotFound(_0x5d79d2,null))[_0xeb19('0x1e')](function(_0x1a3675){if(_0x1a3675){_0x5eb8d8[_0xeb19('0x59')][_0xeb19('0x5d')]=_0x1a3675['id'];_0x5eb8d8[_0xeb19('0x59')][_0xeb19('0x5e')]=integrations[_0xeb19('0x5f')](_0x5eb8d8['body'][_0xeb19('0x60')],_0x5eb8d8['body']['type']);_0x5eb8d8[_0xeb19('0x59')][_0xeb19('0x61')]=integrations[_0xeb19('0x62')](_0x5eb8d8['body'][_0xeb19('0x60')],_0x5eb8d8[_0xeb19('0x59')][_0xeb19('0x3d')]);return db['FreshdeskConfiguration']['create'](_0x5eb8d8['body'],{'include':[{'model':db[_0xeb19('0x63')],'as':'Subjects'},{'model':db[_0xeb19('0x63')],'as':_0xeb19('0x61')}]});}return null;})[_0xeb19('0x1e')](respondWithResult(_0x5d79d2,null))[_0xeb19('0x53')](handleError(_0x5d79d2,null));};exports['getFields']=function(_0x3da89e,_0xd3b61c,_0xea47a3){var _0x88f2b4='';return db[_0xeb19('0x3a')][_0xeb19('0x5b')]({'where':{'id':_0x3da89e[_0xeb19('0x54')]['id']},'attributes':['id',_0xeb19('0x64'),_0xeb19('0x65')]})[_0xeb19('0x1e')](handleEntityNotFound(_0xd3b61c,null))[_0xeb19('0x1e')](function(_0x2933e5){if(_0x2933e5){_0x88f2b4=_0x2933e5[_0xeb19('0x64')];var _0xe6246c=_0x88f2b4[_0xeb19('0x66')](-0x1);if(_0xe6246c==='/'){_0x88f2b4=_0x88f2b4[_0xeb19('0x67')](0x0,_0x88f2b4['lastIndexOf'](_0xe6246c));}return rp({'method':'GET','uri':util[_0xeb19('0x68')](_0xeb19('0x69'),_0x88f2b4,_0xeb19('0x6a')),'headers':{'Authorization':util[_0xeb19('0x68')](_0xeb19('0x6b'),new Buffer(util[_0xeb19('0x68')](_0xeb19('0x6c'),_0x2933e5['apiKey']))[_0xeb19('0x6d')]('base64'))},'json':!![]});}})['then'](function(_0x1ebdee){if(_0x1ebdee){var _0x1960a8=[_0xeb19('0x6e'),_0xeb19('0x6f'),_0xeb19('0x70'),'description',_0xeb19('0x29'),'priority','group',_0xeb19('0x71'),'ticket_type',_0xeb19('0x72'),'company'];_['remove'](_0x1ebdee,function(_0x5ad8ef){return _0x1960a8[_0xeb19('0x73')](_0x5ad8ef[_0xeb19('0x36')])||!_0x5ad8ef['default']&&_0x5ad8ef[_0xeb19('0x3d')]!==_0xeb19('0x74')&&_0x5ad8ef[_0xeb19('0x3d')]!==_0xeb19('0x75');});return{'count':_0x1ebdee[_0xeb19('0x55')],'rows':_[_0xeb19('0x39')](_0x1ebdee,function(_0x6d4c00){return{'id':_0x6d4c00[_0xeb19('0x36')],'name':_0x6d4c00[_0xeb19('0x76')],'custom':!_0x6d4c00['default'],'options':_0x6d4c00[_0xeb19('0x77')]?_[_0xeb19('0x39')](_0x6d4c00['choices'],function(_0x597eb3){return{'name':_[_0xeb19('0x78')](_0x597eb3),'value':_0x597eb3};}):[]};})};}})[_0xeb19('0x1e')](respondWithResult(_0xd3b61c,null))[_0xeb19('0x53')](function(_0x523807){var _0x35695b=_0x3da89e[_0xeb19('0x42')][_0xeb19('0x79')]?0x1f4:_0x523807[_0xeb19('0x7a')]||0x1f4;logger[_0xeb19('0x24')](_0xeb19('0x7b'),_0xeb19('0x7c'),_0x35695b,JSON['stringify'](_0x523807));delete _0x523807[_0xeb19('0x36')];if(_0x35695b===0x191){_0x35695b=0x190;}_0xd3b61c[_0xeb19('0x29')](_0x35695b)[_0xeb19('0x37')](_0x3da89e[_0xeb19('0x42')][_0xeb19('0x79')]?{'message':'Wrong\x20credentials','statusCode':_0x523807[_0xeb19('0x7a')]}:_0x523807);});};