Built motion from commit 9d0783e6.|2.6.13
[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 _0x9e5e=['Basic\x20%s','%s:X','apiKey','toString','agent','description','priority','group','source','ticket_type','remove','includes','default','custom_dropdown','label','choices','capitalize','statusCode','getFields,\x20%s,\x20%s,\x20%s','send','test','Wrong\x20credentials','eml-format','rimraf','fast-json-patch','request-promise','moment','mustache','path','sox','fs-extra','lodash','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../mysqldb','../../components/integrations/configuration','sendStatus','status','end','json','offset','undefined','limit','count','set','apply','reject','save','update','then','destroy','error','stack','name','index','map','rawAttributes','fieldName','type','model','query','keys','filters','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','FreshdeskAccount','include','rows','catch','show','params','attributes','includeAll','find','create','body','getConfigurations','FreshdeskConfiguration','addConfiguration','findOne','AccountId','Subjects','getSubjects','channel','FreshdeskField','Descriptions','getFields','remoteUri','slice','substring','lastIndexOf','GET','%s/%s','api/v2/ticket_fields','format'];(function(_0x14add3,_0x13ce8d){var _0x4a174f=function(_0x2b3ed7){while(--_0x2b3ed7){_0x14add3['push'](_0x14add3['shift']());}};_0x4a174f(++_0x13ce8d);}(_0x9e5e,0x1e2));var _0xe9e5=function(_0x725b8e,_0xc22b48){_0x725b8e=_0x725b8e-0x0;var _0x43ac45=_0x9e5e[_0x725b8e];return _0x43ac45;};'use strict';var emlformat=require(_0xe9e5('0x0'));var rimraf=require(_0xe9e5('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xe9e5('0x2'));var rp=require(_0xe9e5('0x3'));var moment=require(_0xe9e5('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xe9e5('0x5'));var util=require('util');var path=require(_0xe9e5('0x6'));var sox=require(_0xe9e5('0x7'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xe9e5('0x8'));var _=require(_0xe9e5('0x9'));var squel=require('squel');var crypto=require(_0xe9e5('0xa'));var jsforce=require(_0xe9e5('0xb'));var deskjs=require(_0xe9e5('0xc'));var toCsv=require(_0xe9e5('0xd'));var querystring=require(_0xe9e5('0xe'));var Papa=require(_0xe9e5('0xf'));var Redis=require(_0xe9e5('0x10'));var authService=require(_0xe9e5('0x11'));var qs=require(_0xe9e5('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xe9e5('0x13'));var logger=require(_0xe9e5('0x14'))('api');var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0xe9e5('0x15'))['db'];var integrations=require(_0xe9e5('0x16'));function respondWithStatusCode(_0x42dcba,_0x272b49){_0x272b49=_0x272b49||0xcc;return function(_0x269ac4){if(_0x269ac4){return _0x42dcba[_0xe9e5('0x17')](_0x272b49);}return _0x42dcba[_0xe9e5('0x18')](_0x272b49)[_0xe9e5('0x19')]();};}function respondWithResult(_0x3097da,_0xfe19e8){_0xfe19e8=_0xfe19e8||0xc8;return function(_0x5c901a){if(_0x5c901a){return _0x3097da[_0xe9e5('0x18')](_0xfe19e8)[_0xe9e5('0x1a')](_0x5c901a);}};}function respondWithFilteredResult(_0x35c830,_0x3f0990){return function(_0x17990d){if(_0x17990d){var _0x695c52=typeof _0x3f0990[_0xe9e5('0x1b')]===_0xe9e5('0x1c')&&typeof _0x3f0990[_0xe9e5('0x1d')]===_0xe9e5('0x1c');var _0x4d779e=_0x17990d[_0xe9e5('0x1e')];var _0x30550=_0x695c52?0x0:_0x3f0990[_0xe9e5('0x1b')];var _0x3ad9f9=_0x695c52?_0x17990d[_0xe9e5('0x1e')]:_0x3f0990[_0xe9e5('0x1b')]+_0x3f0990[_0xe9e5('0x1d')];var _0x44e60d;if(_0x3ad9f9>=_0x4d779e){_0x3ad9f9=_0x4d779e;_0x44e60d=0xc8;}else{_0x44e60d=0xce;}_0x35c830[_0xe9e5('0x18')](_0x44e60d);return _0x35c830[_0xe9e5('0x1f')]('Content-Range',_0x30550+'-'+_0x3ad9f9+'/'+_0x4d779e)['json'](_0x17990d);}return null;};}function patchUpdates(_0x559d10){return function(_0x106b21){try{jsonpatch[_0xe9e5('0x20')](_0x106b21,_0x559d10,!![]);}catch(_0x2935a4){return BPromise[_0xe9e5('0x21')](_0x2935a4);}return _0x106b21[_0xe9e5('0x22')]();};}function saveUpdates(_0xb2a983,_0x22d394){return function(_0x15db4b){if(_0x15db4b){return _0x15db4b[_0xe9e5('0x23')](_0xb2a983)[_0xe9e5('0x24')](function(_0x1b9d2f){return _0x1b9d2f;});}return null;};}function removeEntity(_0x4c0fb9,_0x252fdc){return function(_0x579d9a){if(_0x579d9a){return _0x579d9a[_0xe9e5('0x25')]()['then'](function(){_0x4c0fb9[_0xe9e5('0x18')](0xcc)['end']();});}};}function handleEntityNotFound(_0x5ac8fc,_0x5e84dc){return function(_0xf88884){if(!_0xf88884){_0x5ac8fc[_0xe9e5('0x17')](0x194);}return _0xf88884;};}function handleError(_0x338076,_0x327cb2){_0x327cb2=_0x327cb2||0x1f4;return function(_0x3fcab2){logger[_0xe9e5('0x26')](_0x3fcab2[_0xe9e5('0x27')]);if(_0x3fcab2[_0xe9e5('0x28')]){delete _0x3fcab2[_0xe9e5('0x28')];}_0x338076[_0xe9e5('0x18')](_0x327cb2)['send'](_0x3fcab2);};}exports[_0xe9e5('0x29')]=function(_0x56f728,_0xe7d11e){var _0x18969d={},_0x554bcb={},_0x4161e9={'count':0x0,'rows':[]};var _0x881d0d=_[_0xe9e5('0x2a')](db['FreshdeskAccount'][_0xe9e5('0x2b')],function(_0x5d0593){return{'name':_0x5d0593[_0xe9e5('0x2c')],'type':_0x5d0593[_0xe9e5('0x2d')]['key']};});_0x554bcb[_0xe9e5('0x2e')]=_[_0xe9e5('0x2a')](_0x881d0d,'name');_0x554bcb[_0xe9e5('0x2f')]=_[_0xe9e5('0x30')](_0x56f728[_0xe9e5('0x2f')]);_0x554bcb[_0xe9e5('0x31')]=_[_0xe9e5('0x32')](_0x554bcb[_0xe9e5('0x2e')],_0x554bcb['query']);_0x18969d['attributes']=_[_0xe9e5('0x32')](_0x554bcb[_0xe9e5('0x2e')],qs['fields'](_0x56f728[_0xe9e5('0x2f')][_0xe9e5('0x33')]));_0x18969d['attributes']=_0x18969d['attributes'][_0xe9e5('0x34')]?_0x18969d['attributes']:_0x554bcb['model'];if(!_0x56f728[_0xe9e5('0x2f')][_0xe9e5('0x35')](_0xe9e5('0x36'))){_0x18969d[_0xe9e5('0x1d')]=qs[_0xe9e5('0x1d')](_0x56f728[_0xe9e5('0x2f')][_0xe9e5('0x1d')]);_0x18969d[_0xe9e5('0x1b')]=qs[_0xe9e5('0x1b')](_0x56f728[_0xe9e5('0x2f')][_0xe9e5('0x1b')]);}_0x18969d[_0xe9e5('0x37')]=qs[_0xe9e5('0x38')](_0x56f728['query'][_0xe9e5('0x38')]);_0x18969d[_0xe9e5('0x39')]=qs[_0xe9e5('0x31')](_[_0xe9e5('0x3a')](_0x56f728[_0xe9e5('0x2f')],_0x554bcb[_0xe9e5('0x31')]),_0x881d0d);if(_0x56f728['query'][_0xe9e5('0x3b')]){_0x18969d[_0xe9e5('0x39')]=_[_0xe9e5('0x3c')](_0x18969d['where'],{'$or':_[_0xe9e5('0x2a')](_0x881d0d,function(_0x352903){if(_0x352903[_0xe9e5('0x2d')]!==_0xe9e5('0x3d')){var _0x3353d6={};_0x3353d6[_0x352903[_0xe9e5('0x28')]]={'$like':'%'+_0x56f728[_0xe9e5('0x2f')]['filter']+'%'};return _0x3353d6;}})});}_0x18969d=_['merge']({},_0x18969d,_0x56f728[_0xe9e5('0x3e')]);var _0x304571={'where':_0x18969d[_0xe9e5('0x39')]};return db[_0xe9e5('0x3f')][_0xe9e5('0x1e')](_0x304571)['then'](function(_0x2c44eb){_0x4161e9['count']=_0x2c44eb;if(_0x56f728[_0xe9e5('0x2f')]['includeAll']){_0x18969d[_0xe9e5('0x40')]=[{'all':!![]}];}return db[_0xe9e5('0x3f')]['findAll'](_0x18969d);})[_0xe9e5('0x24')](function(_0x47c5ea){_0x4161e9[_0xe9e5('0x41')]=_0x47c5ea;return _0x4161e9;})[_0xe9e5('0x24')](respondWithFilteredResult(_0xe7d11e,_0x18969d))[_0xe9e5('0x42')](handleError(_0xe7d11e,null));};exports[_0xe9e5('0x43')]=function(_0x10572d,_0x2bc934){var _0x1601fd={'raw':![],'where':{'id':_0x10572d[_0xe9e5('0x44')]['id']}},_0x147741={};_0x147741[_0xe9e5('0x2e')]=_[_0xe9e5('0x30')](db['FreshdeskAccount'][_0xe9e5('0x2b')]);_0x147741[_0xe9e5('0x2f')]=_[_0xe9e5('0x30')](_0x10572d[_0xe9e5('0x2f')]);_0x147741['filters']=_['intersection'](_0x147741[_0xe9e5('0x2e')],_0x147741['query']);_0x1601fd[_0xe9e5('0x45')]=_[_0xe9e5('0x32')](_0x147741[_0xe9e5('0x2e')],qs[_0xe9e5('0x33')](_0x10572d[_0xe9e5('0x2f')]['fields']));_0x1601fd[_0xe9e5('0x45')]=_0x1601fd['attributes']['length']?_0x1601fd['attributes']:_0x147741[_0xe9e5('0x2e')];if(_0x10572d[_0xe9e5('0x2f')][_0xe9e5('0x46')]){_0x1601fd[_0xe9e5('0x40')]=[{'all':!![]}];}_0x1601fd=_[_0xe9e5('0x3c')]({},_0x1601fd,_0x10572d[_0xe9e5('0x3e')]);return db[_0xe9e5('0x3f')][_0xe9e5('0x47')](_0x1601fd)['then'](handleEntityNotFound(_0x2bc934,null))[_0xe9e5('0x24')](respondWithResult(_0x2bc934,null))[_0xe9e5('0x42')](handleError(_0x2bc934,null));};exports[_0xe9e5('0x48')]=function(_0x441839,_0x2b785e){return db[_0xe9e5('0x3f')][_0xe9e5('0x48')](_0x441839['body'],{})['then'](respondWithResult(_0x2b785e,0xc9))[_0xe9e5('0x42')](handleError(_0x2b785e,null));};exports['update']=function(_0x1dc5cf,_0x20be8f){if(_0x1dc5cf[_0xe9e5('0x49')]['id']){delete _0x1dc5cf['body']['id'];}return db[_0xe9e5('0x3f')][_0xe9e5('0x47')]({'where':{'id':_0x1dc5cf[_0xe9e5('0x44')]['id']}})[_0xe9e5('0x24')](handleEntityNotFound(_0x20be8f,null))['then'](saveUpdates(_0x1dc5cf[_0xe9e5('0x49')],null))[_0xe9e5('0x24')](respondWithResult(_0x20be8f,null))[_0xe9e5('0x42')](handleError(_0x20be8f,null));};exports[_0xe9e5('0x25')]=function(_0x3f532d,_0x23cee5){return db[_0xe9e5('0x3f')][_0xe9e5('0x47')]({'where':{'id':_0x3f532d[_0xe9e5('0x44')]['id']}})['then'](handleEntityNotFound(_0x23cee5,null))['then'](removeEntity(_0x23cee5,null))[_0xe9e5('0x42')](handleError(_0x23cee5,null));};exports[_0xe9e5('0x4a')]=function(_0x275022,_0x3b673d,_0x219f73){var _0x19ad88={};var _0x42ce27={};var _0x28439f;var _0x47d74b;return db['FreshdeskAccount']['findOne']({'where':{'id':_0x275022[_0xe9e5('0x44')]['id']}})[_0xe9e5('0x24')](handleEntityNotFound(_0x3b673d,null))[_0xe9e5('0x24')](function(_0x198ce0){if(_0x198ce0){_0x28439f=_0x198ce0;_0x42ce27[_0xe9e5('0x2e')]=_[_0xe9e5('0x30')](db[_0xe9e5('0x4b')]['rawAttributes']);_0x42ce27[_0xe9e5('0x2f')]=_['keys'](_0x275022[_0xe9e5('0x2f')]);_0x42ce27[_0xe9e5('0x31')]=_[_0xe9e5('0x32')](_0x42ce27['model'],_0x42ce27[_0xe9e5('0x2f')]);_0x19ad88[_0xe9e5('0x45')]=_['intersection'](_0x42ce27['model'],qs[_0xe9e5('0x33')](_0x275022[_0xe9e5('0x2f')][_0xe9e5('0x33')]));_0x19ad88[_0xe9e5('0x45')]=_0x19ad88[_0xe9e5('0x45')][_0xe9e5('0x34')]?_0x19ad88[_0xe9e5('0x45')]:_0x42ce27['model'];_0x19ad88[_0xe9e5('0x37')]=qs[_0xe9e5('0x38')](_0x275022[_0xe9e5('0x2f')]['sort']);_0x19ad88[_0xe9e5('0x39')]=qs[_0xe9e5('0x31')](_['pick'](_0x275022[_0xe9e5('0x2f')],_0x42ce27[_0xe9e5('0x31')]));if(_0x275022[_0xe9e5('0x2f')]['filter']){_0x19ad88[_0xe9e5('0x39')]=_[_0xe9e5('0x3c')](_0x19ad88[_0xe9e5('0x39')],{'$or':_[_0xe9e5('0x2a')](_0x19ad88[_0xe9e5('0x45')],function(_0x33ea59){var _0x10b48b={};_0x10b48b[_0x33ea59]={'$like':'%'+_0x275022[_0xe9e5('0x2f')]['filter']+'%'};return _0x10b48b;})});}_0x19ad88=_['merge']({},_0x19ad88,_0x275022[_0xe9e5('0x3e')]);return _0x28439f[_0xe9e5('0x4a')](_0x19ad88);}})[_0xe9e5('0x24')](function(_0x24e116){if(_0x24e116){_0x47d74b=_0x24e116[_0xe9e5('0x34')];if(!_0x275022[_0xe9e5('0x2f')][_0xe9e5('0x35')]('nolimit')){_0x19ad88[_0xe9e5('0x1d')]=qs[_0xe9e5('0x1d')](_0x275022[_0xe9e5('0x2f')][_0xe9e5('0x1d')]);_0x19ad88['offset']=qs['offset'](_0x275022[_0xe9e5('0x2f')][_0xe9e5('0x1b')]);}return _0x28439f[_0xe9e5('0x4a')](_0x19ad88);}})['then'](function(_0x49d6bb){if(_0x49d6bb){return _0x49d6bb?{'count':_0x47d74b,'rows':_0x49d6bb}:null;}})['then'](respondWithResult(_0x3b673d,null))[_0xe9e5('0x42')](handleError(_0x3b673d,null));};exports[_0xe9e5('0x4c')]=function(_0x335685,_0x19bcd6,_0x2da8ad){if(_0x335685[_0xe9e5('0x49')]['id']){delete _0x335685[_0xe9e5('0x49')]['id'];}return db['FreshdeskAccount'][_0xe9e5('0x4d')]({'where':{'id':_0x335685['params']['id']}})['then'](handleEntityNotFound(_0x19bcd6,null))[_0xe9e5('0x24')](function(_0x1e3373){if(_0x1e3373){_0x335685[_0xe9e5('0x49')][_0xe9e5('0x4e')]=_0x1e3373['id'];_0x335685[_0xe9e5('0x49')][_0xe9e5('0x4f')]=integrations[_0xe9e5('0x50')](_0x335685[_0xe9e5('0x49')][_0xe9e5('0x51')],_0x335685['body'][_0xe9e5('0x2d')]);_0x335685[_0xe9e5('0x49')]['Descriptions']=integrations['getDescriptions'](_0x335685[_0xe9e5('0x49')][_0xe9e5('0x51')],_0x335685[_0xe9e5('0x49')][_0xe9e5('0x2d')]);return db[_0xe9e5('0x4b')][_0xe9e5('0x48')](_0x335685[_0xe9e5('0x49')],{'include':[{'model':db['FreshdeskField'],'as':_0xe9e5('0x4f')},{'model':db[_0xe9e5('0x52')],'as':_0xe9e5('0x53')}]});}return null;})[_0xe9e5('0x24')](respondWithResult(_0x19bcd6,null))[_0xe9e5('0x42')](handleError(_0x19bcd6,null));};exports[_0xe9e5('0x54')]=function(_0x15d799,_0x17dcb9,_0x3f655c){var _0x54ba7e='';return db[_0xe9e5('0x3f')]['findOne']({'where':{'id':_0x15d799['params']['id']},'attributes':['id',_0xe9e5('0x55'),'apiKey']})[_0xe9e5('0x24')](handleEntityNotFound(_0x17dcb9,null))[_0xe9e5('0x24')](function(_0x4aa632){if(_0x4aa632){_0x54ba7e=_0x4aa632[_0xe9e5('0x55')];var _0x50ee97=_0x54ba7e[_0xe9e5('0x56')](-0x1);if(_0x50ee97==='/'){_0x54ba7e=_0x54ba7e[_0xe9e5('0x57')](0x0,_0x54ba7e[_0xe9e5('0x58')](_0x50ee97));}return rp({'method':_0xe9e5('0x59'),'uri':util['format'](_0xe9e5('0x5a'),_0x54ba7e,_0xe9e5('0x5b')),'headers':{'Authorization':util[_0xe9e5('0x5c')](_0xe9e5('0x5d'),new Buffer(util['format'](_0xe9e5('0x5e'),_0x4aa632[_0xe9e5('0x5f')]))[_0xe9e5('0x60')]('base64'))},'json':!![]});}})[_0xe9e5('0x24')](function(_0x3b89b2){if(_0x3b89b2){var _0x59c87e=['requester','subject',_0xe9e5('0x61'),_0xe9e5('0x62'),'status',_0xe9e5('0x63'),_0xe9e5('0x64'),_0xe9e5('0x65'),_0xe9e5('0x66'),_0xe9e5('0x64'),'company'];_[_0xe9e5('0x67')](_0x3b89b2,function(_0x500f14){return _0x59c87e[_0xe9e5('0x68')](_0x500f14[_0xe9e5('0x28')])||!_0x500f14[_0xe9e5('0x69')]&&_0x500f14[_0xe9e5('0x2d')]!=='custom_text'&&_0x500f14[_0xe9e5('0x2d')]!==_0xe9e5('0x6a');});return{'count':_0x3b89b2['length'],'rows':_['map'](_0x3b89b2,function(_0x272f6d){return{'id':_0x272f6d[_0xe9e5('0x28')],'name':_0x272f6d[_0xe9e5('0x6b')],'custom':!_0x272f6d[_0xe9e5('0x69')],'options':_0x272f6d['choices']?_[_0xe9e5('0x2a')](_0x272f6d[_0xe9e5('0x6c')],function(_0x2e8bdf){return{'name':_[_0xe9e5('0x6d')](_0x2e8bdf),'value':_0x2e8bdf};}):[]};})};}})[_0xe9e5('0x24')](respondWithResult(_0x17dcb9,null))[_0xe9e5('0x42')](function(_0x26b885){var _0x58302a=_0x15d799[_0xe9e5('0x2f')]['test']?0x1f4:_0x26b885[_0xe9e5('0x6e')]||0x1f4;logger['error'](_0xe9e5('0x6f'),_0xe9e5('0x54'),_0x58302a,JSON['stringify'](_0x26b885));delete _0x26b885[_0xe9e5('0x28')];if(_0x58302a===0x191){_0x58302a=0x190;}_0x17dcb9[_0xe9e5('0x18')](_0x58302a)[_0xe9e5('0x70')](_0x15d799['query'][_0xe9e5('0x71')]?{'message':_0xe9e5('0x72'),'statusCode':_0x26b885[_0xe9e5('0x6e')]}:_0x26b885);});};