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 _0xf4ef=['jsforce','desk.js','querystring','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../components/integrations/configuration','jayson/promise','client','http','request','then','FreshdeskAccount,\x20%s,\x20%s','debug','FreshdeskAccount,\x20%s,\x20%s,\x20%s','request\x20sent','error','code','message','info','result','catch','sendStatus','status','json','count','offset','set','Content-Range','reject','save','destroy','end','stack','name','send','index','map','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','sort','where','pick','filter','VIRTUAL','merge','options','FreshdeskAccount','includeAll','include','show','params','find','create','body','getConfigurations','findOne','order','addConfiguration','AccountId','Subjects','channel','Descriptions','getDescriptions','FreshdeskConfiguration','FreshdeskField','getFields','remoteUri','apiKey','substring','GET','format','%s/%s','api/v2/ticket_fields','Basic\x20%s','%s:X','toString','requester','subject','agent','description','priority','group','source','ticket_type','company','remove','includes','default','custom_text','custom_dropdown','label','capitalize','test','statusCode','getFields,\x20%s,\x20%s,\x20%s','html-pdf','eml-format','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','lodash','squel'];(function(_0xec1289,_0x4fa82b){var _0x3e223c=function(_0x9752ec){while(--_0x9752ec){_0xec1289['push'](_0xec1289['shift']());}};_0x3e223c(++_0x4fa82b);}(_0xf4ef,0x71));var _0xff4e=function(_0xe2c95e,_0x3e6545){_0xe2c95e=_0xe2c95e-0x0;var _0x42ce6f=_0xf4ef[_0xe2c95e];return _0x42ce6f;};'use strict';var pdf=require(_0xff4e('0x0'));var emlformat=require(_0xff4e('0x1'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xff4e('0x2'));var rp=require(_0xff4e('0x3'));var moment=require(_0xff4e('0x4'));var BPromise=require(_0xff4e('0x5'));var Mustache=require('mustache');var util=require(_0xff4e('0x6'));var path=require(_0xff4e('0x7'));var sox=require(_0xff4e('0x8'));var csv=require(_0xff4e('0x9'));var ejs=require(_0xff4e('0xa'));var fs=require('fs');var _=require(_0xff4e('0xb'));var squel=require(_0xff4e('0xc'));var crypto=require('crypto');var jsforce=require(_0xff4e('0xd'));var deskjs=require(_0xff4e('0xe'));var toCsv=require(_0xff4e('0x9'));var querystring=require(_0xff4e('0xf'));var Papa=require('papaparse');var Redis=require(_0xff4e('0x10'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0xff4e('0x11'));var hardwareService=require(_0xff4e('0x12'));var logger=require('../../config/logger')(_0xff4e('0x13'));var utils=require(_0xff4e('0x14'));var config=require(_0xff4e('0x15'));var licenseUtil=require(_0xff4e('0x16'));var db=require('../../mysqldb')['db'];var integrations=require(_0xff4e('0x17'));var jayson=require(_0xff4e('0x18'));var client=jayson[_0xff4e('0x19')][_0xff4e('0x1a')]({'port':0x232a});function respondWithRpcPromise(_0x3a00d7,_0x59a9ff,_0x1db6e,_0x1ab30a){return new BPromise(function(_0x42159b,_0x5e7849){var _0x24712a=_0x1ab30a||client;return _0x24712a[_0xff4e('0x1b')](_0x3a00d7,_0x1db6e)[_0xff4e('0x1c')](function(_0x5bfb7f){logger['info'](_0xff4e('0x1d'),_0x59a9ff,'request\x20sent');logger[_0xff4e('0x1e')](_0xff4e('0x1f'),_0x59a9ff,_0xff4e('0x20'),JSON['stringify'](_0x5bfb7f));if(_0x5bfb7f[_0xff4e('0x21')]){if(_0x5bfb7f[_0xff4e('0x21')][_0xff4e('0x22')]===0x1f4){logger[_0xff4e('0x21')]('FreshdeskAccount,\x20%s,\x20%s',_0x59a9ff,_0x5bfb7f[_0xff4e('0x21')][_0xff4e('0x23')]);return _0x5e7849(_0x5bfb7f[_0xff4e('0x21')][_0xff4e('0x23')]);}logger['error'](_0xff4e('0x1d'),_0x59a9ff,_0x5bfb7f[_0xff4e('0x21')][_0xff4e('0x23')]);return _0x42159b(_0x5bfb7f[_0xff4e('0x21')][_0xff4e('0x23')]);}else{logger[_0xff4e('0x24')]('FreshdeskAccount,\x20%s,\x20%s',_0x59a9ff,_0xff4e('0x20'));_0x42159b(_0x5bfb7f[_0xff4e('0x25')][_0xff4e('0x23')]);}})[_0xff4e('0x26')](function(_0x1c2523){logger[_0xff4e('0x21')](_0xff4e('0x1d'),_0x59a9ff,_0x1c2523);_0x5e7849(_0x1c2523);});});}function respondWithStatusCode(_0x21393b,_0x4fa44d){_0x4fa44d=_0x4fa44d||0xcc;return function(_0x17430a){if(_0x17430a){return _0x21393b[_0xff4e('0x27')](_0x4fa44d);}return _0x21393b[_0xff4e('0x28')](_0x4fa44d)['end']();};}function respondWithResult(_0x48eb58,_0xf53886){_0xf53886=_0xf53886||0xc8;return function(_0x6b5076){if(_0x6b5076){return _0x48eb58['status'](_0xf53886)[_0xff4e('0x29')](_0x6b5076);}};}function respondWithFilteredResult(_0x3150c4,_0x1e2eab){return function(_0x1eb132){if(_0x1eb132){var _0x40fb04=_0x1eb132[_0xff4e('0x2a')],_0x52fca7=_0x1e2eab[_0xff4e('0x2b')],_0x31a701=_0x1e2eab[_0xff4e('0x2b')]+_0x1e2eab['limit'],_0x31c465;if(_0x31a701>=_0x40fb04){_0x31a701=_0x40fb04;_0x31c465=0xc8;}else{_0x31c465=0xce;}_0x3150c4[_0xff4e('0x28')](_0x31c465);return _0x3150c4[_0xff4e('0x2c')](_0xff4e('0x2d'),_0x52fca7+'-'+_0x31a701+'/'+_0x40fb04)[_0xff4e('0x29')](_0x1eb132);}return null;};}function patchUpdates(_0x384ae7){return function(_0x2343bd){try{jsonpatch['apply'](_0x2343bd,_0x384ae7,!![]);}catch(_0xfc5cd8){return BPromise[_0xff4e('0x2e')](_0xfc5cd8);}return _0x2343bd[_0xff4e('0x2f')]();};}function saveUpdates(_0x58f732,_0x5e4d41){return function(_0x3a7bee){if(_0x3a7bee){return _0x3a7bee['update'](_0x58f732)[_0xff4e('0x1c')](function(_0x47fc92){return _0x47fc92;});}return null;};}function removeEntity(_0x30da82,_0x3ea5e7){return function(_0x2f7816){if(_0x2f7816){return _0x2f7816[_0xff4e('0x30')]()[_0xff4e('0x1c')](function(){_0x30da82[_0xff4e('0x28')](0xcc)[_0xff4e('0x31')]();});}};}function handleEntityNotFound(_0x375c47,_0x456d09){return function(_0x5ccbf4){if(!_0x5ccbf4){_0x375c47[_0xff4e('0x27')](0x194);}return _0x5ccbf4;};}function handleError(_0x3bb96e,_0x4e3895){_0x4e3895=_0x4e3895||0x1f4;return function(_0x3b876c){logger[_0xff4e('0x21')](_0x3b876c[_0xff4e('0x32')]);if(_0x3b876c[_0xff4e('0x33')]){delete _0x3b876c[_0xff4e('0x33')];}_0x3bb96e['status'](_0x4e3895)[_0xff4e('0x34')](_0x3b876c);};}exports[_0xff4e('0x35')]=function(_0x2fec42,_0x2c4efb){var _0x4c8017={},_0x2c0fe8={},_0x19de3a={'count':0x0,'rows':[]};var _0xcf1b13=_[_0xff4e('0x36')](db['FreshdeskAccount'][_0xff4e('0x37')],function(_0x15c9d6){return{'name':_0x15c9d6[_0xff4e('0x38')],'type':_0x15c9d6[_0xff4e('0x39')][_0xff4e('0x3a')]};});_0x2c0fe8[_0xff4e('0x3b')]=_[_0xff4e('0x36')](_0xcf1b13,_0xff4e('0x33'));_0x2c0fe8[_0xff4e('0x3c')]=_[_0xff4e('0x3d')](_0x2fec42['query']);_0x2c0fe8[_0xff4e('0x3e')]=_[_0xff4e('0x3f')](_0x2c0fe8[_0xff4e('0x3b')],_0x2c0fe8[_0xff4e('0x3c')]);_0x4c8017[_0xff4e('0x40')]=_[_0xff4e('0x3f')](_0x2c0fe8['model'],qs['fields'](_0x2fec42[_0xff4e('0x3c')][_0xff4e('0x41')]));_0x4c8017[_0xff4e('0x40')]=_0x4c8017[_0xff4e('0x40')][_0xff4e('0x42')]?_0x4c8017['attributes']:_0x2c0fe8['model'];if(!_0x2fec42[_0xff4e('0x3c')][_0xff4e('0x43')](_0xff4e('0x44'))){_0x4c8017[_0xff4e('0x45')]=qs[_0xff4e('0x45')](_0x2fec42['query']['limit']);_0x4c8017[_0xff4e('0x2b')]=qs['offset'](_0x2fec42['query']['offset']);}_0x4c8017['order']=qs[_0xff4e('0x46')](_0x2fec42[_0xff4e('0x3c')][_0xff4e('0x46')]);_0x4c8017[_0xff4e('0x47')]=qs[_0xff4e('0x3e')](_[_0xff4e('0x48')](_0x2fec42['query'],_0x2c0fe8[_0xff4e('0x3e')]),_0xcf1b13);if(_0x2fec42[_0xff4e('0x3c')][_0xff4e('0x49')]){_0x4c8017[_0xff4e('0x47')]=_['merge'](_0x4c8017[_0xff4e('0x47')],{'$or':_[_0xff4e('0x36')](_0xcf1b13,function(_0x125964){if(_0x125964[_0xff4e('0x39')]!==_0xff4e('0x4a')){var _0x4e30b7={};_0x4e30b7[_0x125964[_0xff4e('0x33')]]={'$like':'%'+_0x2fec42['query']['filter']+'%'};return _0x4e30b7;}})});}_0x4c8017=_[_0xff4e('0x4b')]({},_0x4c8017,_0x2fec42[_0xff4e('0x4c')]);var _0x512e2e={'where':_0x4c8017['where']};return db[_0xff4e('0x4d')][_0xff4e('0x2a')](_0x512e2e)[_0xff4e('0x1c')](function(_0x2b1aa1){_0x19de3a[_0xff4e('0x2a')]=_0x2b1aa1;if(_0x2fec42[_0xff4e('0x3c')][_0xff4e('0x4e')]){_0x4c8017[_0xff4e('0x4f')]=[{'all':!![]}];}return db['FreshdeskAccount']['findAll'](_0x4c8017);})[_0xff4e('0x1c')](function(_0x342ba0){_0x19de3a['rows']=_0x342ba0;return _0x19de3a;})['then'](respondWithFilteredResult(_0x2c4efb,_0x4c8017))[_0xff4e('0x26')](handleError(_0x2c4efb,null));};exports[_0xff4e('0x50')]=function(_0x39c46e,_0x5e9051){var _0x8a084={'raw':![],'where':{'id':_0x39c46e[_0xff4e('0x51')]['id']}},_0x3e93da={};_0x3e93da[_0xff4e('0x3b')]=_[_0xff4e('0x3d')](db[_0xff4e('0x4d')][_0xff4e('0x37')]);_0x3e93da[_0xff4e('0x3c')]=_['keys'](_0x39c46e[_0xff4e('0x3c')]);_0x3e93da[_0xff4e('0x3e')]=_['intersection'](_0x3e93da['model'],_0x3e93da[_0xff4e('0x3c')]);_0x8a084[_0xff4e('0x40')]=_[_0xff4e('0x3f')](_0x3e93da[_0xff4e('0x3b')],qs[_0xff4e('0x41')](_0x39c46e[_0xff4e('0x3c')]['fields']));_0x8a084[_0xff4e('0x40')]=_0x8a084[_0xff4e('0x40')]['length']?_0x8a084[_0xff4e('0x40')]:_0x3e93da[_0xff4e('0x3b')];if(_0x39c46e[_0xff4e('0x3c')][_0xff4e('0x4e')]){_0x8a084['include']=[{'all':!![]}];}_0x8a084=_['merge']({},_0x8a084,_0x39c46e[_0xff4e('0x4c')]);return db['FreshdeskAccount'][_0xff4e('0x52')](_0x8a084)[_0xff4e('0x1c')](handleEntityNotFound(_0x5e9051,null))[_0xff4e('0x1c')](respondWithResult(_0x5e9051,null))[_0xff4e('0x26')](handleError(_0x5e9051,null));};exports[_0xff4e('0x53')]=function(_0x2e687b,_0x15a1b1){return db[_0xff4e('0x4d')][_0xff4e('0x53')](_0x2e687b[_0xff4e('0x54')],{})[_0xff4e('0x1c')](respondWithResult(_0x15a1b1,0xc9))[_0xff4e('0x26')](handleError(_0x15a1b1,null));};exports['update']=function(_0x43a165,_0x5d18af){if(_0x43a165[_0xff4e('0x54')]['id']){delete _0x43a165[_0xff4e('0x54')]['id'];}return db['FreshdeskAccount'][_0xff4e('0x52')]({'where':{'id':_0x43a165['params']['id']}})[_0xff4e('0x1c')](handleEntityNotFound(_0x5d18af,null))[_0xff4e('0x1c')](saveUpdates(_0x43a165['body'],null))['then'](respondWithResult(_0x5d18af,null))[_0xff4e('0x26')](handleError(_0x5d18af,null));};exports[_0xff4e('0x30')]=function(_0x5f572f,_0x28c915){return db[_0xff4e('0x4d')][_0xff4e('0x52')]({'where':{'id':_0x5f572f[_0xff4e('0x51')]['id']}})[_0xff4e('0x1c')](handleEntityNotFound(_0x28c915,null))['then'](removeEntity(_0x28c915,null))[_0xff4e('0x26')](handleError(_0x28c915,null));};exports[_0xff4e('0x55')]=function(_0x4d7325,_0x12ab2c,_0x2f0af1){var _0x5e4b84={};var _0x298787={};var _0x5005cb;var _0x3f87a8;return db[_0xff4e('0x4d')][_0xff4e('0x56')]({'where':{'id':_0x4d7325[_0xff4e('0x51')]['id']}})[_0xff4e('0x1c')](handleEntityNotFound(_0x12ab2c,null))[_0xff4e('0x1c')](function(_0x27ff45){if(_0x27ff45){_0x5005cb=_0x27ff45;_0x298787['model']=_['keys'](db['FreshdeskConfiguration']['rawAttributes']);_0x298787[_0xff4e('0x3c')]=_[_0xff4e('0x3d')](_0x4d7325[_0xff4e('0x3c')]);_0x298787[_0xff4e('0x3e')]=_[_0xff4e('0x3f')](_0x298787[_0xff4e('0x3b')],_0x298787['query']);_0x5e4b84[_0xff4e('0x40')]=_[_0xff4e('0x3f')](_0x298787[_0xff4e('0x3b')],qs[_0xff4e('0x41')](_0x4d7325[_0xff4e('0x3c')]['fields']));_0x5e4b84['attributes']=_0x5e4b84[_0xff4e('0x40')][_0xff4e('0x42')]?_0x5e4b84[_0xff4e('0x40')]:_0x298787[_0xff4e('0x3b')];_0x5e4b84[_0xff4e('0x57')]=qs[_0xff4e('0x46')](_0x4d7325['query']['sort']);_0x5e4b84[_0xff4e('0x47')]=qs['filters'](_[_0xff4e('0x48')](_0x4d7325[_0xff4e('0x3c')],_0x298787[_0xff4e('0x3e')]));if(_0x4d7325[_0xff4e('0x3c')][_0xff4e('0x49')]){_0x5e4b84[_0xff4e('0x47')]=_['merge'](_0x5e4b84[_0xff4e('0x47')],{'$or':_['map'](_0x5e4b84[_0xff4e('0x40')],function(_0x306a9e){var _0x4d41a0={};_0x4d41a0[_0x306a9e]={'$like':'%'+_0x4d7325['query']['filter']+'%'};return _0x4d41a0;})});}_0x5e4b84=_[_0xff4e('0x4b')]({},_0x5e4b84,_0x4d7325[_0xff4e('0x4c')]);return _0x5005cb[_0xff4e('0x55')](_0x5e4b84);}})[_0xff4e('0x1c')](function(_0x58ca0c){if(_0x58ca0c){_0x3f87a8=_0x58ca0c[_0xff4e('0x42')];if(!_0x4d7325['query'][_0xff4e('0x43')](_0xff4e('0x44'))){_0x5e4b84[_0xff4e('0x45')]=qs[_0xff4e('0x45')](_0x4d7325[_0xff4e('0x3c')][_0xff4e('0x45')]);_0x5e4b84['offset']=qs[_0xff4e('0x2b')](_0x4d7325[_0xff4e('0x3c')][_0xff4e('0x2b')]);}return _0x5005cb[_0xff4e('0x55')](_0x5e4b84);}})['then'](function(_0x57be9c){if(_0x57be9c){return _0x57be9c?{'count':_0x3f87a8,'rows':_0x57be9c}:null;}})[_0xff4e('0x1c')](respondWithResult(_0x12ab2c,null))[_0xff4e('0x26')](handleError(_0x12ab2c,null));};exports[_0xff4e('0x58')]=function(_0x2dc8a9,_0x419b9a,_0x15bd94){if(_0x2dc8a9[_0xff4e('0x54')]['id']){delete _0x2dc8a9[_0xff4e('0x54')]['id'];}return db[_0xff4e('0x4d')]['findOne']({'where':{'id':_0x2dc8a9[_0xff4e('0x51')]['id']}})[_0xff4e('0x1c')](handleEntityNotFound(_0x419b9a,null))[_0xff4e('0x1c')](function(_0x318690){if(_0x318690){_0x2dc8a9[_0xff4e('0x54')][_0xff4e('0x59')]=_0x318690['id'];_0x2dc8a9[_0xff4e('0x54')][_0xff4e('0x5a')]=integrations['getSubjects'](_0x2dc8a9[_0xff4e('0x54')][_0xff4e('0x5b')],_0x2dc8a9[_0xff4e('0x54')][_0xff4e('0x39')]);_0x2dc8a9[_0xff4e('0x54')][_0xff4e('0x5c')]=integrations[_0xff4e('0x5d')](_0x2dc8a9[_0xff4e('0x54')][_0xff4e('0x5b')],_0x2dc8a9[_0xff4e('0x54')][_0xff4e('0x39')]);return db[_0xff4e('0x5e')]['create'](_0x2dc8a9[_0xff4e('0x54')],{'include':[{'model':db[_0xff4e('0x5f')],'as':_0xff4e('0x5a')},{'model':db['FreshdeskField'],'as':'Descriptions'}]});}return null;})[_0xff4e('0x1c')](respondWithResult(_0x419b9a,null))['catch'](handleError(_0x419b9a,null));};exports[_0xff4e('0x60')]=function(_0x4f758a,_0x550981,_0x3b069e){var _0x5540a4='';return db[_0xff4e('0x4d')][_0xff4e('0x56')]({'where':{'id':_0x4f758a['params']['id']},'attributes':['id',_0xff4e('0x61'),_0xff4e('0x62')]})[_0xff4e('0x1c')](handleEntityNotFound(_0x550981,null))['then'](function(_0x563750){if(_0x563750){_0x5540a4=_0x563750[_0xff4e('0x61')];var _0x1c38d4=_0x5540a4['slice'](-0x1);if(_0x1c38d4==='/'){_0x5540a4=_0x5540a4[_0xff4e('0x63')](0x0,_0x5540a4['lastIndexOf'](_0x1c38d4));}return rp({'method':_0xff4e('0x64'),'uri':util[_0xff4e('0x65')](_0xff4e('0x66'),_0x5540a4,_0xff4e('0x67')),'headers':{'Authorization':util['format'](_0xff4e('0x68'),new Buffer(util[_0xff4e('0x65')](_0xff4e('0x69'),_0x563750['apiKey']))[_0xff4e('0x6a')]('base64'))},'json':!![]});}})[_0xff4e('0x1c')](function(_0x2d0bb5){if(_0x2d0bb5){var _0x3a35a2=[_0xff4e('0x6b'),_0xff4e('0x6c'),_0xff4e('0x6d'),_0xff4e('0x6e'),_0xff4e('0x28'),_0xff4e('0x6f'),_0xff4e('0x70'),_0xff4e('0x71'),_0xff4e('0x72'),_0xff4e('0x70'),_0xff4e('0x73')];_[_0xff4e('0x74')](_0x2d0bb5,function(_0x49cecc){return _0x3a35a2[_0xff4e('0x75')](_0x49cecc['name'])||!_0x49cecc[_0xff4e('0x76')]&&_0x49cecc[_0xff4e('0x39')]!==_0xff4e('0x77')&&_0x49cecc[_0xff4e('0x39')]!==_0xff4e('0x78');});return{'count':_0x2d0bb5['length'],'rows':_[_0xff4e('0x36')](_0x2d0bb5,function(_0x2b7199){return{'id':_0x2b7199['name'],'name':_0x2b7199[_0xff4e('0x79')],'custom':!_0x2b7199[_0xff4e('0x76')],'options':_0x2b7199['choices']?_[_0xff4e('0x36')](_0x2b7199['choices'],function(_0x3f67fd){return{'name':_[_0xff4e('0x7a')](_0x3f67fd),'value':_0x3f67fd};}):[]};})};}})[_0xff4e('0x1c')](respondWithResult(_0x550981,null))[_0xff4e('0x26')](function(_0x7027c0){var _0x307021=_0x4f758a[_0xff4e('0x3c')][_0xff4e('0x7b')]?0x1f4:_0x7027c0[_0xff4e('0x7c')]||0x1f4;logger[_0xff4e('0x21')](_0xff4e('0x7d'),_0xff4e('0x60'),_0x307021,JSON['stringify'](_0x7027c0));delete _0x7027c0[_0xff4e('0x33')];if(_0x307021===0x191){_0x307021=0x190;}_0x550981[_0xff4e('0x28')](_0x307021)['send'](_0x4f758a['query'][_0xff4e('0x7b')]?{'message':'Wrong\x20credentials','statusCode':_0x7027c0[_0xff4e('0x7c')]}:_0x7027c0);});};