dd5a17b716269d0ea827ecdd9171242c57b05d8d
[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 _0x7217=['Basic\x20%s','%s:X','toString','base64','requester','subject','agent','description','priority','source','ticket_type','group','remove','includes','default','custom_text','custom_dropdown','label','capitalize','statusCode','Wrong\x20credentials','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','../../components/integrations/configuration','client','http','test','ValidationError','The\x20password\x20must\x20be\x20at\x20least\x208\x20characters\x20long\x20and\x20have\x201\x20lowercase\x20character,\x201\x20uppercase\x20character,\x201\x20number\x20and\x201\x20special\x20character\x20~!@#$%^&-_=+[{]}.','then','info','request\x20sent','debug','FreshdeskAccount,\x20%s,\x20%s,\x20%s','stringify','error','code','FreshdeskAccount,\x20%s,\x20%s','message','result','sendStatus','status','end','json','offset','set','Content-Range','apply','reject','save','destroy','stack','name','send','fieldName','type','key','model','keys','query','intersection','fields','attributes','length','hasOwnProperty','limit','order','sort','where','filters','pick','merge','map','VIRTUAL','options','FreshdeskAccount','include','findAll','catch','params','rawAttributes','includeAll','find','create','body','update','getConfigurations','FreshdeskConfiguration','filter','nolimit','findOne','AccountId','Subjects','getSubjects','Descriptions','getDescriptions','FreshdeskField','getFields','remoteUri','apiKey','slice','substring','lastIndexOf','format','%s/%s','api/v2/ticket_fields'];(function(_0x21c23e,_0x1d33e3){var _0xa7b7e2=function(_0x6ac2a8){while(--_0x6ac2a8){_0x21c23e['push'](_0x21c23e['shift']());}};_0xa7b7e2(++_0x1d33e3);}(_0x7217,0x19e));var _0x7721=function(_0x2763f2,_0x416af8){_0x2763f2=_0x2763f2-0x0;var _0x3ef471=_0x7217[_0x2763f2];return _0x3ef471;};'use strict';var pdf=require(_0x7721('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x7721('0x1'));var zipdir=require(_0x7721('0x2'));var jsonpatch=require(_0x7721('0x3'));var rp=require(_0x7721('0x4'));var moment=require(_0x7721('0x5'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x7721('0x6'));var path=require(_0x7721('0x7'));var sox=require(_0x7721('0x8'));var csv=require(_0x7721('0x9'));var ejs=require(_0x7721('0xa'));var fs=require('fs');var _=require(_0x7721('0xb'));var squel=require(_0x7721('0xc'));var crypto=require(_0x7721('0xd'));var jsforce=require(_0x7721('0xe'));var deskjs=require(_0x7721('0xf'));var toCsv=require(_0x7721('0x9'));var querystring=require(_0x7721('0x10'));var Papa=require(_0x7721('0x11'));var Redis=require(_0x7721('0x12'));var authService=require(_0x7721('0x13'));var qs=require('../../components/parsers/qs');var as=require(_0x7721('0x14'));var hardwareService=require(_0x7721('0x15'));var logger=require(_0x7721('0x16'))(_0x7721('0x17'));var utils=require(_0x7721('0x18'));var config=require(_0x7721('0x19'));var db=require(_0x7721('0x1a'))['db'];var integrations=require(_0x7721('0x1b'));var jayson=require('jayson/promise');var client=jayson[_0x7721('0x1c')][_0x7721('0x1d')]({'port':0x232a});function checkPasswordPattern(_0x57ff6d,_0x109900,_0x30da54){if(_0x30da54){var _0x3f01c5=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x3f01c5[_0x7721('0x1e')](_0x109900)){return _0x57ff6d;}else{throw new db['Sequelize'][(_0x7721('0x1f'))](_0x7721('0x20'));}}else{return _0x57ff6d;}}function respondWithRpcPromise(_0x534f1b,_0x4e199a,_0x4b183e,_0x5ed54){return new BPromise(function(_0x25a628,_0x3cc909){var _0x32550d=_0x5ed54||client;return _0x32550d['request'](_0x534f1b,_0x4b183e)[_0x7721('0x21')](function(_0x54a838){logger[_0x7721('0x22')]('FreshdeskAccount,\x20%s,\x20%s',_0x4e199a,_0x7721('0x23'));logger[_0x7721('0x24')](_0x7721('0x25'),_0x4e199a,_0x7721('0x23'),JSON[_0x7721('0x26')](_0x54a838));if(_0x54a838[_0x7721('0x27')]){if(_0x54a838[_0x7721('0x27')][_0x7721('0x28')]===0x1f4){logger[_0x7721('0x27')](_0x7721('0x29'),_0x4e199a,_0x54a838['error'][_0x7721('0x2a')]);return _0x3cc909(_0x54a838[_0x7721('0x27')][_0x7721('0x2a')]);}logger[_0x7721('0x27')]('FreshdeskAccount,\x20%s,\x20%s',_0x4e199a,_0x54a838[_0x7721('0x27')]['message']);return _0x25a628(_0x54a838[_0x7721('0x27')][_0x7721('0x2a')]);}else{logger[_0x7721('0x22')](_0x7721('0x29'),_0x4e199a,_0x7721('0x23'));_0x25a628(_0x54a838[_0x7721('0x2b')][_0x7721('0x2a')]);}})['catch'](function(_0x216f20){logger[_0x7721('0x27')](_0x7721('0x29'),_0x4e199a,_0x216f20);_0x3cc909(_0x216f20);});});}function respondWithStatusCode(_0x1f67c7,_0x40d550){_0x40d550=_0x40d550||0xcc;return function(_0x16355a){if(_0x16355a){return _0x1f67c7[_0x7721('0x2c')](_0x40d550);}return _0x1f67c7[_0x7721('0x2d')](_0x40d550)[_0x7721('0x2e')]();};}function respondWithResult(_0x52316e,_0x258ddf){_0x258ddf=_0x258ddf||0xc8;return function(_0x5b0551){if(_0x5b0551){return _0x52316e['status'](_0x258ddf)[_0x7721('0x2f')](_0x5b0551);}};}function respondWithFilteredResult(_0x343c19,_0x53c904){return function(_0x158d98){if(_0x158d98){var _0x1ea4d=_0x158d98['count'],_0x37b9f0=_0x53c904[_0x7721('0x30')],_0xd7d703=_0x53c904[_0x7721('0x30')]+_0x53c904['limit'],_0x1da2d8;if(_0xd7d703>=_0x1ea4d){_0xd7d703=_0x1ea4d;_0x1da2d8=0xc8;}else{_0x1da2d8=0xce;}_0x343c19['status'](_0x1da2d8);return _0x343c19[_0x7721('0x31')](_0x7721('0x32'),_0x37b9f0+'-'+_0xd7d703+'/'+_0x1ea4d)['json'](_0x158d98);}return null;};}function patchUpdates(_0x46f772){return function(_0x4651b5){try{jsonpatch[_0x7721('0x33')](_0x4651b5,_0x46f772,!![]);}catch(_0x58d54b){return BPromise[_0x7721('0x34')](_0x58d54b);}return _0x4651b5[_0x7721('0x35')]();};}function saveUpdates(_0x1492d4,_0x3f15e2){return function(_0xc0f3c4){if(_0xc0f3c4){return _0xc0f3c4['update'](_0x1492d4)[_0x7721('0x21')](function(_0x3e4e56){return _0x3e4e56;});}return null;};}function removeEntity(_0xb2386d,_0x5c5b33){return function(_0x35de7a){if(_0x35de7a){return _0x35de7a[_0x7721('0x36')]()['then'](function(){_0xb2386d[_0x7721('0x2d')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2d6ba0,_0x326c50){return function(_0x19d082){if(!_0x19d082){_0x2d6ba0[_0x7721('0x2c')](0x194);}return _0x19d082;};}function handleError(_0x1c84c0,_0x13c635){_0x13c635=_0x13c635||0x1f4;return function(_0x2f1fe0){logger[_0x7721('0x27')](_0x2f1fe0[_0x7721('0x37')]);if(_0x2f1fe0[_0x7721('0x38')]){delete _0x2f1fe0[_0x7721('0x38')];}_0x1c84c0['status'](_0x13c635)[_0x7721('0x39')](_0x2f1fe0);};}exports['index']=function(_0x212384,_0x35614c){var _0x7942f7={},_0x1d03de={},_0x3968f3={'count':0x0,'rows':[]};var _0x378ba5=_['map'](db['FreshdeskAccount']['rawAttributes'],function(_0x539560){return{'name':_0x539560[_0x7721('0x3a')],'type':_0x539560[_0x7721('0x3b')][_0x7721('0x3c')]};});_0x1d03de[_0x7721('0x3d')]=_['map'](_0x378ba5,_0x7721('0x38'));_0x1d03de['query']=_[_0x7721('0x3e')](_0x212384[_0x7721('0x3f')]);_0x1d03de['filters']=_[_0x7721('0x40')](_0x1d03de[_0x7721('0x3d')],_0x1d03de['query']);_0x7942f7['attributes']=_[_0x7721('0x40')](_0x1d03de[_0x7721('0x3d')],qs[_0x7721('0x41')](_0x212384[_0x7721('0x3f')]['fields']));_0x7942f7[_0x7721('0x42')]=_0x7942f7[_0x7721('0x42')][_0x7721('0x43')]?_0x7942f7[_0x7721('0x42')]:_0x1d03de[_0x7721('0x3d')];if(!_0x212384['query'][_0x7721('0x44')]('nolimit')){_0x7942f7[_0x7721('0x45')]=qs['limit'](_0x212384[_0x7721('0x3f')][_0x7721('0x45')]);_0x7942f7[_0x7721('0x30')]=qs['offset'](_0x212384[_0x7721('0x3f')][_0x7721('0x30')]);}_0x7942f7[_0x7721('0x46')]=qs['sort'](_0x212384[_0x7721('0x3f')][_0x7721('0x47')]);_0x7942f7[_0x7721('0x48')]=qs[_0x7721('0x49')](_[_0x7721('0x4a')](_0x212384[_0x7721('0x3f')],_0x1d03de[_0x7721('0x49')]),_0x378ba5);if(_0x212384['query']['filter']){_0x7942f7[_0x7721('0x48')]=_[_0x7721('0x4b')](_0x7942f7[_0x7721('0x48')],{'$or':_[_0x7721('0x4c')](_0x378ba5,function(_0x335145){if(_0x335145[_0x7721('0x3b')]!==_0x7721('0x4d')){var _0x2966fe={};_0x2966fe[_0x335145[_0x7721('0x38')]]={'$like':'%'+_0x212384[_0x7721('0x3f')]['filter']+'%'};return _0x2966fe;}})});}_0x7942f7=_['merge']({},_0x7942f7,_0x212384[_0x7721('0x4e')]);var _0x6a4664={'where':_0x7942f7[_0x7721('0x48')]};return db[_0x7721('0x4f')]['count'](_0x6a4664)[_0x7721('0x21')](function(_0x2d5a88){_0x3968f3['count']=_0x2d5a88;if(_0x212384[_0x7721('0x3f')]['includeAll']){_0x7942f7[_0x7721('0x50')]=[{'all':!![]}];}return db['FreshdeskAccount'][_0x7721('0x51')](_0x7942f7);})[_0x7721('0x21')](function(_0xf17c40){_0x3968f3['rows']=_0xf17c40;return _0x3968f3;})[_0x7721('0x21')](respondWithFilteredResult(_0x35614c,_0x7942f7))[_0x7721('0x52')](handleError(_0x35614c,null));};exports['show']=function(_0x223d93,_0x1196c2){var _0xf88e8c={'raw':![],'where':{'id':_0x223d93[_0x7721('0x53')]['id']}},_0x5c4078={};_0x5c4078['model']=_[_0x7721('0x3e')](db[_0x7721('0x4f')][_0x7721('0x54')]);_0x5c4078[_0x7721('0x3f')]=_[_0x7721('0x3e')](_0x223d93[_0x7721('0x3f')]);_0x5c4078[_0x7721('0x49')]=_[_0x7721('0x40')](_0x5c4078[_0x7721('0x3d')],_0x5c4078[_0x7721('0x3f')]);_0xf88e8c[_0x7721('0x42')]=_[_0x7721('0x40')](_0x5c4078[_0x7721('0x3d')],qs[_0x7721('0x41')](_0x223d93[_0x7721('0x3f')]['fields']));_0xf88e8c[_0x7721('0x42')]=_0xf88e8c[_0x7721('0x42')][_0x7721('0x43')]?_0xf88e8c[_0x7721('0x42')]:_0x5c4078[_0x7721('0x3d')];if(_0x223d93[_0x7721('0x3f')][_0x7721('0x55')]){_0xf88e8c['include']=[{'all':!![]}];}_0xf88e8c=_[_0x7721('0x4b')]({},_0xf88e8c,_0x223d93[_0x7721('0x4e')]);return db[_0x7721('0x4f')][_0x7721('0x56')](_0xf88e8c)[_0x7721('0x21')](handleEntityNotFound(_0x1196c2,null))[_0x7721('0x21')](respondWithResult(_0x1196c2,null))[_0x7721('0x52')](handleError(_0x1196c2,null));};exports[_0x7721('0x57')]=function(_0x11b300,_0x3b968d){return db[_0x7721('0x4f')]['create'](_0x11b300[_0x7721('0x58')],{})[_0x7721('0x21')](respondWithResult(_0x3b968d,0xc9))[_0x7721('0x52')](handleError(_0x3b968d,null));};exports[_0x7721('0x59')]=function(_0x15ed3b,_0x3e7918){if(_0x15ed3b[_0x7721('0x58')]['id']){delete _0x15ed3b[_0x7721('0x58')]['id'];}return db[_0x7721('0x4f')][_0x7721('0x56')]({'where':{'id':_0x15ed3b[_0x7721('0x53')]['id']}})[_0x7721('0x21')](handleEntityNotFound(_0x3e7918,null))[_0x7721('0x21')](saveUpdates(_0x15ed3b[_0x7721('0x58')],null))[_0x7721('0x21')](respondWithResult(_0x3e7918,null))['catch'](handleError(_0x3e7918,null));};exports['destroy']=function(_0x4e112e,_0x885a3a){return db['FreshdeskAccount']['find']({'where':{'id':_0x4e112e['params']['id']}})['then'](handleEntityNotFound(_0x885a3a,null))[_0x7721('0x21')](removeEntity(_0x885a3a,null))[_0x7721('0x52')](handleError(_0x885a3a,null));};exports[_0x7721('0x5a')]=function(_0x5343a1,_0x5181d7,_0x5925b7){var _0x51a3a2={};var _0x484b8e={};var _0x24d1dc;var _0x4f0d38;return db['FreshdeskAccount']['findOne']({'where':{'id':_0x5343a1[_0x7721('0x53')]['id']}})[_0x7721('0x21')](handleEntityNotFound(_0x5181d7,null))[_0x7721('0x21')](function(_0x4a94c8){if(_0x4a94c8){_0x24d1dc=_0x4a94c8;_0x484b8e[_0x7721('0x3d')]=_[_0x7721('0x3e')](db[_0x7721('0x5b')][_0x7721('0x54')]);_0x484b8e[_0x7721('0x3f')]=_[_0x7721('0x3e')](_0x5343a1[_0x7721('0x3f')]);_0x484b8e[_0x7721('0x49')]=_[_0x7721('0x40')](_0x484b8e[_0x7721('0x3d')],_0x484b8e[_0x7721('0x3f')]);_0x51a3a2[_0x7721('0x42')]=_[_0x7721('0x40')](_0x484b8e[_0x7721('0x3d')],qs[_0x7721('0x41')](_0x5343a1['query'][_0x7721('0x41')]));_0x51a3a2[_0x7721('0x42')]=_0x51a3a2[_0x7721('0x42')][_0x7721('0x43')]?_0x51a3a2['attributes']:_0x484b8e[_0x7721('0x3d')];_0x51a3a2[_0x7721('0x46')]=qs['sort'](_0x5343a1[_0x7721('0x3f')]['sort']);_0x51a3a2[_0x7721('0x48')]=qs[_0x7721('0x49')](_[_0x7721('0x4a')](_0x5343a1[_0x7721('0x3f')],_0x484b8e[_0x7721('0x49')]));if(_0x5343a1[_0x7721('0x3f')][_0x7721('0x5c')]){_0x51a3a2[_0x7721('0x48')]=_[_0x7721('0x4b')](_0x51a3a2['where'],{'$or':_[_0x7721('0x4c')](_0x51a3a2[_0x7721('0x42')],function(_0x112033){var _0x3a11e2={};_0x3a11e2[_0x112033]={'$like':'%'+_0x5343a1[_0x7721('0x3f')][_0x7721('0x5c')]+'%'};return _0x3a11e2;})});}_0x51a3a2=_[_0x7721('0x4b')]({},_0x51a3a2,_0x5343a1['options']);return _0x24d1dc[_0x7721('0x5a')](_0x51a3a2);}})[_0x7721('0x21')](function(_0x53c918){if(_0x53c918){_0x4f0d38=_0x53c918[_0x7721('0x43')];if(!_0x5343a1['query'][_0x7721('0x44')](_0x7721('0x5d'))){_0x51a3a2[_0x7721('0x45')]=qs[_0x7721('0x45')](_0x5343a1[_0x7721('0x3f')][_0x7721('0x45')]);_0x51a3a2[_0x7721('0x30')]=qs['offset'](_0x5343a1[_0x7721('0x3f')][_0x7721('0x30')]);}return _0x24d1dc[_0x7721('0x5a')](_0x51a3a2);}})['then'](function(_0x5cef5a){if(_0x5cef5a){return _0x5cef5a?{'count':_0x4f0d38,'rows':_0x5cef5a}:null;}})['then'](respondWithResult(_0x5181d7,null))['catch'](handleError(_0x5181d7,null));};exports['addConfiguration']=function(_0x1fc5f7,_0x2645dd,_0x580473){if(_0x1fc5f7[_0x7721('0x58')]['id']){delete _0x1fc5f7[_0x7721('0x58')]['id'];}return db[_0x7721('0x4f')][_0x7721('0x5e')]({'where':{'id':_0x1fc5f7['params']['id']}})[_0x7721('0x21')](handleEntityNotFound(_0x2645dd,null))[_0x7721('0x21')](function(_0x322afc){if(_0x322afc){_0x1fc5f7[_0x7721('0x58')][_0x7721('0x5f')]=_0x322afc['id'];_0x1fc5f7['body'][_0x7721('0x60')]=integrations[_0x7721('0x61')](_0x1fc5f7[_0x7721('0x58')]['channel'],_0x1fc5f7['body'][_0x7721('0x3b')]);_0x1fc5f7[_0x7721('0x58')][_0x7721('0x62')]=integrations[_0x7721('0x63')](_0x1fc5f7[_0x7721('0x58')]['channel'],_0x1fc5f7['body'][_0x7721('0x3b')]);return db[_0x7721('0x5b')][_0x7721('0x57')](_0x1fc5f7[_0x7721('0x58')],{'include':[{'model':db[_0x7721('0x64')],'as':_0x7721('0x60')},{'model':db[_0x7721('0x64')],'as':'Descriptions'}]});}return null;})[_0x7721('0x21')](respondWithResult(_0x2645dd,null))[_0x7721('0x52')](handleError(_0x2645dd,null));};exports[_0x7721('0x65')]=function(_0x5e85d9,_0xdc60ee,_0x1a53d6){var _0xdcd3e0='';return db[_0x7721('0x4f')]['findOne']({'where':{'id':_0x5e85d9['params']['id']},'attributes':['id',_0x7721('0x66'),_0x7721('0x67')]})[_0x7721('0x21')](handleEntityNotFound(_0xdc60ee,null))[_0x7721('0x21')](function(_0x3605cb){if(_0x3605cb){_0xdcd3e0=_0x3605cb[_0x7721('0x66')];var _0x59e80c=_0xdcd3e0[_0x7721('0x68')](-0x1);if(_0x59e80c==='/'){_0xdcd3e0=_0xdcd3e0[_0x7721('0x69')](0x0,_0xdcd3e0[_0x7721('0x6a')](_0x59e80c));}return rp({'method':'GET','uri':util[_0x7721('0x6b')](_0x7721('0x6c'),_0xdcd3e0,_0x7721('0x6d')),'headers':{'Authorization':util[_0x7721('0x6b')](_0x7721('0x6e'),new Buffer(util['format'](_0x7721('0x6f'),_0x3605cb['apiKey']))[_0x7721('0x70')](_0x7721('0x71')))},'json':!![]});}})[_0x7721('0x21')](function(_0x7f0598){if(_0x7f0598){var _0x963dbe=[_0x7721('0x72'),_0x7721('0x73'),_0x7721('0x74'),_0x7721('0x75'),_0x7721('0x2d'),_0x7721('0x76'),'group',_0x7721('0x77'),_0x7721('0x78'),_0x7721('0x79'),'company'];_[_0x7721('0x7a')](_0x7f0598,function(_0x26b2cc){return _0x963dbe[_0x7721('0x7b')](_0x26b2cc[_0x7721('0x38')])||!_0x26b2cc[_0x7721('0x7c')]&&_0x26b2cc['type']!==_0x7721('0x7d')&&_0x26b2cc[_0x7721('0x3b')]!==_0x7721('0x7e');});return{'count':_0x7f0598[_0x7721('0x43')],'rows':_[_0x7721('0x4c')](_0x7f0598,function(_0x51f3d7){return{'id':_0x51f3d7['name'],'name':_0x51f3d7[_0x7721('0x7f')],'custom':!_0x51f3d7[_0x7721('0x7c')],'options':_0x51f3d7['choices']?_[_0x7721('0x4c')](_0x51f3d7['choices'],function(_0x453792){return{'name':_[_0x7721('0x80')](_0x453792),'value':_0x453792};}):[]};})};}})['then'](respondWithResult(_0xdc60ee,null))[_0x7721('0x52')](function(_0x5209e1){var _0x56069f=_0x5e85d9['query'][_0x7721('0x1e')]?0x1f4:_0x5209e1[_0x7721('0x81')]||0x1f4;logger[_0x7721('0x27')]('getFields,\x20%s,\x20%s,\x20%s','getFields',_0x56069f,JSON['stringify'](_0x5209e1));delete _0x5209e1[_0x7721('0x38')];if(_0x56069f===0x191){_0x56069f=0x190;}_0xdc60ee[_0x7721('0x2d')](_0x56069f)[_0x7721('0x39')](_0x5e85d9[_0x7721('0x3f')][_0x7721('0x1e')]?{'message':_0x7721('0x82'),'statusCode':_0x5209e1['statusCode']}:_0x5209e1);});};