Built motion from commit (unavailable).|2.4.18
[motion2.git] / server / api / intZendeskAccount / intZendeskAccount.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 _0x6907=['squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','jayson/promise','client','test','Sequelize','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~!@#$%^&-_=+[{]}.','request','then','info','ZendeskAccount,\x20%s,\x20%s','ZendeskAccount,\x20%s,\x20%s,\x20%s','request\x20sent','stringify','error','code','message','result','catch','status','end','count','offset','limit','apply','save','update','destroy','sendStatus','stack','name','send','index','map','ZendeskAccount','rawAttributes','fieldName','type','key','model','query','keys','filters','attributes','intersection','fields','hasOwnProperty','order','sort','where','pick','filter','VIRTUAL','merge','options','includeAll','findAll','rows','show','params','include','find','create','body','findOne','ZendeskConfiguration','length','getConfigurations','addConfiguration','AccountId','Subjects','getSubjects','channel','getDescriptions','ZendeskField','Descriptions','getFields','username','token','authType','remoteUri','substring','password','headers','format','%s:%s','toString','%s/token:%s','base64','Unknown\x20authentication\x20type','subject','description','group','assignee','ticket_fields','includes','position','system_field_options','custom_field_options','statusCode','getFields,\x20%s,\x20%s,\x20%s','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','util','path','sox','to-csv','ejs','lodash'];(function(_0x4ee881,_0x10ddc8){var _0x305f48=function(_0x5303d5){while(--_0x5303d5){_0x4ee881['push'](_0x4ee881['shift']());}};_0x305f48(++_0x10ddc8);}(_0x6907,0x1ec));var _0x7690=function(_0x586f38,_0x5835e5){_0x586f38=_0x586f38-0x0;var _0xb025f9=_0x6907[_0x586f38];return _0xb025f9;};'use strict';var pdf=require(_0x7690('0x0'));var emlformat=require(_0x7690('0x1'));var rimraf=require(_0x7690('0x2'));var zipdir=require(_0x7690('0x3'));var jsonpatch=require(_0x7690('0x4'));var rp=require(_0x7690('0x5'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x7690('0x6'));var path=require(_0x7690('0x7'));var sox=require(_0x7690('0x8'));var csv=require(_0x7690('0x9'));var ejs=require(_0x7690('0xa'));var fs=require('fs');var _=require(_0x7690('0xb'));var squel=require(_0x7690('0xc'));var crypto=require(_0x7690('0xd'));var jsforce=require(_0x7690('0xe'));var deskjs=require(_0x7690('0xf'));var toCsv=require(_0x7690('0x9'));var querystring=require(_0x7690('0x10'));var Papa=require(_0x7690('0x11'));var Redis=require(_0x7690('0x12'));var authService=require(_0x7690('0x13'));var qs=require('../../components/parsers/qs');var as=require(_0x7690('0x14'));var hardwareService=require(_0x7690('0x15'));var logger=require(_0x7690('0x16'))(_0x7690('0x17'));var utils=require(_0x7690('0x18'));var config=require('../../config/environment');var db=require(_0x7690('0x19'))['db'];var integrations=require('../../components/integrations/configuration');var jayson=require(_0x7690('0x1a'));var client=jayson[_0x7690('0x1b')]['http']({'port':0x232a});function checkPasswordPattern(_0x5bc7f6,_0x37f3e1,_0x530b59){if(_0x530b59){var _0x2cc641=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x2cc641[_0x7690('0x1c')](_0x37f3e1)){return _0x5bc7f6;}else{throw new db[(_0x7690('0x1d'))][(_0x7690('0x1e'))](_0x7690('0x1f'));}}else{return _0x5bc7f6;}}function respondWithRpcPromise(_0x2c8142,_0x324907,_0x5aca7c,_0x4e4078){return new BPromise(function(_0x2328bd,_0x1e0ef7){var _0x89beab=_0x4e4078||client;return _0x89beab[_0x7690('0x20')](_0x2c8142,_0x5aca7c)[_0x7690('0x21')](function(_0x42f556){logger[_0x7690('0x22')](_0x7690('0x23'),_0x324907,'request\x20sent');logger['debug'](_0x7690('0x24'),_0x324907,_0x7690('0x25'),JSON[_0x7690('0x26')](_0x42f556));if(_0x42f556[_0x7690('0x27')]){if(_0x42f556['error'][_0x7690('0x28')]===0x1f4){logger[_0x7690('0x27')]('ZendeskAccount,\x20%s,\x20%s',_0x324907,_0x42f556[_0x7690('0x27')][_0x7690('0x29')]);return _0x1e0ef7(_0x42f556[_0x7690('0x27')][_0x7690('0x29')]);}logger['error'](_0x7690('0x23'),_0x324907,_0x42f556[_0x7690('0x27')]['message']);return _0x2328bd(_0x42f556[_0x7690('0x27')][_0x7690('0x29')]);}else{logger[_0x7690('0x22')](_0x7690('0x23'),_0x324907,'request\x20sent');_0x2328bd(_0x42f556[_0x7690('0x2a')][_0x7690('0x29')]);}})[_0x7690('0x2b')](function(_0x1f3493){logger[_0x7690('0x27')](_0x7690('0x23'),_0x324907,_0x1f3493);_0x1e0ef7(_0x1f3493);});});}function respondWithStatusCode(_0x3a149d,_0x52af63){_0x52af63=_0x52af63||0xcc;return function(_0x42dc8a){if(_0x42dc8a){return _0x3a149d['sendStatus'](_0x52af63);}return _0x3a149d[_0x7690('0x2c')](_0x52af63)[_0x7690('0x2d')]();};}function respondWithResult(_0x32ddf1,_0xbe14d6){_0xbe14d6=_0xbe14d6||0xc8;return function(_0x390545){if(_0x390545){return _0x32ddf1[_0x7690('0x2c')](_0xbe14d6)['json'](_0x390545);}};}function respondWithFilteredResult(_0x30a594,_0xcaf82c){return function(_0x563b2c){if(_0x563b2c){var _0x1847f8=_0x563b2c[_0x7690('0x2e')],_0x51bd54=_0xcaf82c[_0x7690('0x2f')],_0x5ce834=_0xcaf82c[_0x7690('0x2f')]+_0xcaf82c[_0x7690('0x30')],_0x366386;if(_0x5ce834>=_0x1847f8){_0x5ce834=_0x1847f8;_0x366386=0xc8;}else{_0x366386=0xce;}_0x30a594[_0x7690('0x2c')](_0x366386);return _0x30a594['set']('Content-Range',_0x51bd54+'-'+_0x5ce834+'/'+_0x1847f8)['json'](_0x563b2c);}return null;};}function patchUpdates(_0x1f0431){return function(_0x550294){try{jsonpatch[_0x7690('0x31')](_0x550294,_0x1f0431,!![]);}catch(_0x29afdd){return BPromise['reject'](_0x29afdd);}return _0x550294[_0x7690('0x32')]();};}function saveUpdates(_0x2963f1,_0x23011a){return function(_0xa5b5fe){if(_0xa5b5fe){return _0xa5b5fe[_0x7690('0x33')](_0x2963f1)[_0x7690('0x21')](function(_0x51bef6){return _0x51bef6;});}return null;};}function removeEntity(_0x1b71f4,_0x595f1d){return function(_0x247e5f){if(_0x247e5f){return _0x247e5f[_0x7690('0x34')]()[_0x7690('0x21')](function(){_0x1b71f4[_0x7690('0x2c')](0xcc)[_0x7690('0x2d')]();});}};}function handleEntityNotFound(_0x3b4959,_0x1bc48d){return function(_0x564b2f){if(!_0x564b2f){_0x3b4959[_0x7690('0x35')](0x194);}return _0x564b2f;};}function handleError(_0x3054b4,_0x2c4122){_0x2c4122=_0x2c4122||0x1f4;return function(_0x1a8192){logger[_0x7690('0x27')](_0x1a8192[_0x7690('0x36')]);if(_0x1a8192[_0x7690('0x37')]){delete _0x1a8192['name'];}_0x3054b4[_0x7690('0x2c')](_0x2c4122)[_0x7690('0x38')](_0x1a8192);};}exports[_0x7690('0x39')]=function(_0x4c564c,_0x4e3366){var _0x58bc87={},_0x28608b={},_0x256389={'count':0x0,'rows':[]};var _0x1cffa2=_[_0x7690('0x3a')](db[_0x7690('0x3b')][_0x7690('0x3c')],function(_0x188a92){return{'name':_0x188a92[_0x7690('0x3d')],'type':_0x188a92[_0x7690('0x3e')][_0x7690('0x3f')]};});_0x28608b[_0x7690('0x40')]=_[_0x7690('0x3a')](_0x1cffa2,_0x7690('0x37'));_0x28608b[_0x7690('0x41')]=_[_0x7690('0x42')](_0x4c564c[_0x7690('0x41')]);_0x28608b[_0x7690('0x43')]=_['intersection'](_0x28608b[_0x7690('0x40')],_0x28608b[_0x7690('0x41')]);_0x58bc87[_0x7690('0x44')]=_[_0x7690('0x45')](_0x28608b['model'],qs['fields'](_0x4c564c[_0x7690('0x41')][_0x7690('0x46')]));_0x58bc87['attributes']=_0x58bc87[_0x7690('0x44')]['length']?_0x58bc87['attributes']:_0x28608b['model'];if(!_0x4c564c[_0x7690('0x41')][_0x7690('0x47')]('nolimit')){_0x58bc87[_0x7690('0x30')]=qs[_0x7690('0x30')](_0x4c564c[_0x7690('0x41')][_0x7690('0x30')]);_0x58bc87[_0x7690('0x2f')]=qs[_0x7690('0x2f')](_0x4c564c[_0x7690('0x41')][_0x7690('0x2f')]);}_0x58bc87[_0x7690('0x48')]=qs['sort'](_0x4c564c['query'][_0x7690('0x49')]);_0x58bc87[_0x7690('0x4a')]=qs[_0x7690('0x43')](_[_0x7690('0x4b')](_0x4c564c['query'],_0x28608b[_0x7690('0x43')]));if(_0x4c564c[_0x7690('0x41')][_0x7690('0x4c')]){_0x58bc87[_0x7690('0x4a')]=_['merge'](_0x58bc87['where'],{'$or':_[_0x7690('0x3a')](_0x1cffa2,function(_0xba6247){if(_0xba6247['type']!==_0x7690('0x4d')){var _0x16f851={};_0x16f851[_0xba6247[_0x7690('0x37')]]={'$like':'%'+_0x4c564c[_0x7690('0x41')][_0x7690('0x4c')]+'%'};return _0x16f851;}})});}_0x58bc87=_[_0x7690('0x4e')]({},_0x58bc87,_0x4c564c[_0x7690('0x4f')]);var _0x2e0f75={'where':_0x58bc87[_0x7690('0x4a')]};return db[_0x7690('0x3b')][_0x7690('0x2e')](_0x2e0f75)[_0x7690('0x21')](function(_0x219a97){_0x256389['count']=_0x219a97;if(_0x4c564c[_0x7690('0x41')][_0x7690('0x50')]){_0x58bc87['include']=[{'all':!![]}];}return db['ZendeskAccount'][_0x7690('0x51')](_0x58bc87);})[_0x7690('0x21')](function(_0x46793a){_0x256389[_0x7690('0x52')]=_0x46793a;return _0x256389;})[_0x7690('0x21')](respondWithFilteredResult(_0x4e3366,_0x58bc87))[_0x7690('0x2b')](handleError(_0x4e3366,null));};exports[_0x7690('0x53')]=function(_0x2d6df9,_0xa52c05){var _0x1c823c={'raw':![],'where':{'id':_0x2d6df9[_0x7690('0x54')]['id']}},_0xb877ac={};_0xb877ac[_0x7690('0x40')]=_['keys'](db[_0x7690('0x3b')][_0x7690('0x3c')]);_0xb877ac[_0x7690('0x41')]=_[_0x7690('0x42')](_0x2d6df9['query']);_0xb877ac[_0x7690('0x43')]=_['intersection'](_0xb877ac[_0x7690('0x40')],_0xb877ac['query']);_0x1c823c[_0x7690('0x44')]=_[_0x7690('0x45')](_0xb877ac[_0x7690('0x40')],qs[_0x7690('0x46')](_0x2d6df9['query'][_0x7690('0x46')]));_0x1c823c[_0x7690('0x44')]=_0x1c823c[_0x7690('0x44')]['length']?_0x1c823c[_0x7690('0x44')]:_0xb877ac[_0x7690('0x40')];if(_0x2d6df9[_0x7690('0x41')]['includeAll']){_0x1c823c[_0x7690('0x55')]=[{'all':!![]}];}_0x1c823c=_[_0x7690('0x4e')]({},_0x1c823c,_0x2d6df9[_0x7690('0x4f')]);return db[_0x7690('0x3b')][_0x7690('0x56')](_0x1c823c)[_0x7690('0x21')](handleEntityNotFound(_0xa52c05,null))[_0x7690('0x21')](respondWithResult(_0xa52c05,null))[_0x7690('0x2b')](handleError(_0xa52c05,null));};exports[_0x7690('0x57')]=function(_0x30bb4a,_0x5c120e){return db[_0x7690('0x3b')][_0x7690('0x57')](_0x30bb4a[_0x7690('0x58')],{})['then'](respondWithResult(_0x5c120e,0xc9))[_0x7690('0x2b')](handleError(_0x5c120e,null));};exports[_0x7690('0x33')]=function(_0x2c933e,_0x23875e){if(_0x2c933e[_0x7690('0x58')]['id']){delete _0x2c933e['body']['id'];}return db['ZendeskAccount'][_0x7690('0x56')]({'where':{'id':_0x2c933e[_0x7690('0x54')]['id']}})['then'](handleEntityNotFound(_0x23875e,null))[_0x7690('0x21')](saveUpdates(_0x2c933e[_0x7690('0x58')],null))[_0x7690('0x21')](respondWithResult(_0x23875e,null))[_0x7690('0x2b')](handleError(_0x23875e,null));};exports[_0x7690('0x34')]=function(_0x909a7f,_0x9ed587){return db[_0x7690('0x3b')]['find']({'where':{'id':_0x909a7f[_0x7690('0x54')]['id']}})[_0x7690('0x21')](handleEntityNotFound(_0x9ed587,null))[_0x7690('0x21')](removeEntity(_0x9ed587,null))['catch'](handleError(_0x9ed587,null));};exports['getConfigurations']=function(_0x213275,_0x40bc8a,_0x366c83){var _0x56f007={};var _0x5cb96c={};var _0x1fc232;var _0x2cb4a2;return db[_0x7690('0x3b')][_0x7690('0x59')]({'where':{'id':_0x213275[_0x7690('0x54')]['id']}})[_0x7690('0x21')](handleEntityNotFound(_0x40bc8a,null))[_0x7690('0x21')](function(_0x2b4ca1){if(_0x2b4ca1){_0x1fc232=_0x2b4ca1;_0x5cb96c['model']=_[_0x7690('0x42')](db[_0x7690('0x5a')][_0x7690('0x3c')]);_0x5cb96c['query']=_[_0x7690('0x42')](_0x213275[_0x7690('0x41')]);_0x5cb96c[_0x7690('0x43')]=_[_0x7690('0x45')](_0x5cb96c[_0x7690('0x40')],_0x5cb96c['query']);_0x56f007[_0x7690('0x44')]=_[_0x7690('0x45')](_0x5cb96c[_0x7690('0x40')],qs[_0x7690('0x46')](_0x213275['query'][_0x7690('0x46')]));_0x56f007[_0x7690('0x44')]=_0x56f007[_0x7690('0x44')][_0x7690('0x5b')]?_0x56f007[_0x7690('0x44')]:_0x5cb96c[_0x7690('0x40')];_0x56f007[_0x7690('0x48')]=qs[_0x7690('0x49')](_0x213275[_0x7690('0x41')][_0x7690('0x49')]);_0x56f007[_0x7690('0x4a')]=qs['filters'](_[_0x7690('0x4b')](_0x213275[_0x7690('0x41')],_0x5cb96c['filters']));if(_0x213275[_0x7690('0x41')]['filter']){_0x56f007['where']=_[_0x7690('0x4e')](_0x56f007[_0x7690('0x4a')],{'$or':_[_0x7690('0x3a')](_0x56f007['attributes'],function(_0x2a4f40){var _0x269072={};_0x269072[_0x2a4f40]={'$like':'%'+_0x213275['query'][_0x7690('0x4c')]+'%'};return _0x269072;})});}_0x56f007=_[_0x7690('0x4e')]({},_0x56f007,_0x213275['options']);return _0x1fc232[_0x7690('0x5c')](_0x56f007);}})[_0x7690('0x21')](function(_0x10ccc4){if(_0x10ccc4){_0x2cb4a2=_0x10ccc4[_0x7690('0x5b')];if(!_0x213275['query'][_0x7690('0x47')]('nolimit')){_0x56f007[_0x7690('0x30')]=qs['limit'](_0x213275[_0x7690('0x41')]['limit']);_0x56f007[_0x7690('0x2f')]=qs['offset'](_0x213275[_0x7690('0x41')][_0x7690('0x2f')]);}return _0x1fc232[_0x7690('0x5c')](_0x56f007);}})['then'](function(_0x770af2){if(_0x770af2){return _0x770af2?{'count':_0x2cb4a2,'rows':_0x770af2}:null;}})['then'](respondWithResult(_0x40bc8a,null))[_0x7690('0x2b')](handleError(_0x40bc8a,null));};exports[_0x7690('0x5d')]=function(_0x5e7dfa,_0x323984,_0x202ba1){if(_0x5e7dfa[_0x7690('0x58')]['id']){delete _0x5e7dfa[_0x7690('0x58')]['id'];}return db[_0x7690('0x3b')]['findOne']({'where':{'id':_0x5e7dfa['params']['id']}})[_0x7690('0x21')](handleEntityNotFound(_0x323984,null))[_0x7690('0x21')](function(_0x485a63){if(_0x485a63){_0x5e7dfa[_0x7690('0x58')][_0x7690('0x5e')]=_0x485a63['id'];_0x5e7dfa['body'][_0x7690('0x5f')]=integrations[_0x7690('0x60')](_0x5e7dfa[_0x7690('0x58')][_0x7690('0x61')],_0x5e7dfa[_0x7690('0x58')]['type']);_0x5e7dfa[_0x7690('0x58')]['Descriptions']=integrations[_0x7690('0x62')](_0x5e7dfa[_0x7690('0x58')][_0x7690('0x61')],_0x5e7dfa[_0x7690('0x58')][_0x7690('0x3e')]);return db[_0x7690('0x5a')][_0x7690('0x57')](_0x5e7dfa[_0x7690('0x58')],{'include':[{'model':db[_0x7690('0x63')],'as':_0x7690('0x5f')},{'model':db[_0x7690('0x63')],'as':_0x7690('0x64')}]});}return null;})[_0x7690('0x21')](respondWithResult(_0x323984,null))[_0x7690('0x2b')](handleError(_0x323984,null));};exports[_0x7690('0x65')]=function(_0x934b1b,_0x43b9ff,_0x109496){var _0x4a9960='';return db['ZendeskAccount'][_0x7690('0x59')]({'where':{'id':_0x934b1b[_0x7690('0x54')]['id']},'attributes':['id',_0x7690('0x66'),'password',_0x7690('0x67'),_0x7690('0x68'),_0x7690('0x69')]})['then'](handleEntityNotFound(_0x43b9ff,null))[_0x7690('0x21')](function(_0x42d5d0){if(_0x42d5d0){_0x4a9960=_0x42d5d0[_0x7690('0x69')];var _0x778e89=_0x4a9960['slice'](-0x1);if(_0x778e89==='/'){_0x4a9960=_0x4a9960[_0x7690('0x6a')](0x0,_0x4a9960['lastIndexOf'](_0x778e89));}var _0x974ea0={'method':'GET','uri':util['format']('%s/%s',_0x4a9960,'ticket_fields'),'json':!![]};switch(_0x42d5d0['authType']){case _0x7690('0x6b'):_0x974ea0[_0x7690('0x6c')]={'Authorization':util[_0x7690('0x6d')]('Basic\x20%s',new Buffer(util[_0x7690('0x6d')](_0x7690('0x6e'),_0x42d5d0[_0x7690('0x66')],_0x42d5d0[_0x7690('0x6b')]))[_0x7690('0x6f')]('base64'))};break;case _0x7690('0x67'):_0x974ea0['headers']={'Authorization':util['format']('Basic\x20%s',new Buffer(util['format'](_0x7690('0x70'),_0x42d5d0['username'],_0x42d5d0['token']))[_0x7690('0x6f')](_0x7690('0x71')))};break;default:throw new db[(_0x7690('0x1d'))][(_0x7690('0x1e'))](_0x7690('0x72'));}return rp(_0x974ea0);}})[_0x7690('0x21')](function(_0x4924a6){if(_0x4924a6){var _0x27fb6b=[_0x7690('0x73'),_0x7690('0x74'),_0x7690('0x75'),_0x7690('0x76')];_['remove'](_0x4924a6[_0x7690('0x77')],function(_0x17ae42){return _0x27fb6b[_0x7690('0x78')](_0x17ae42[_0x7690('0x3e')]);});return{'count':_0x4924a6[_0x7690('0x77')]['length'],'rows':_['map'](_0x4924a6['ticket_fields'],function(_0x37f9f3){return{'id':_0x37f9f3['id'],'name':_0x37f9f3[_0x7690('0x79')]>0x7?_0x37f9f3['title']:_0x37f9f3[_0x7690('0x3e')],'custom':_0x37f9f3[_0x7690('0x79')]>0x7?!![]:![],'options':_0x37f9f3[_0x7690('0x7a')]?_0x37f9f3[_0x7690('0x7a')]:_0x37f9f3['custom_field_options']?_0x37f9f3[_0x7690('0x7b')]:[]};})};}})[_0x7690('0x21')](respondWithResult(_0x43b9ff,null))[_0x7690('0x2b')](function(_0x25009b){var _0x1d0d30=_0x934b1b['query'][_0x7690('0x1c')]?0x1f4:_0x25009b[_0x7690('0x7c')]||0x1f4;logger[_0x7690('0x27')](_0x7690('0x7d'),_0x7690('0x65'),_0x1d0d30,JSON['stringify'](_0x25009b));delete _0x25009b[_0x7690('0x37')];if(_0x1d0d30===0x191){_0x1d0d30=0x190;}_0x43b9ff[_0x7690('0x2c')](_0x1d0d30)[_0x7690('0x38')](_0x934b1b[_0x7690('0x41')][_0x7690('0x1c')]?{'message':'Wrong\x20credentials','statusCode':_0x25009b[_0x7690('0x7c')]}:_0x25009b);});};