server/api/intServicenowConfiguration/intServicenowConfiguration.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 _0xc77c=['options','include','findAll','catch','rawAttributes','includeAll','create','body','params','find','getFields','findOne','ServicenowField','length','pick','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','offset','undefined','count','limit','Content-Range','reject','save','then','destroy','name','send','map','ServicenowConfiguration','fieldName','type','model','query','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','filter','merge'];(function(_0x49d6e9,_0x2e0615){var _0x11a53b=function(_0x777676){while(--_0x777676){_0x49d6e9['push'](_0x49d6e9['shift']());}};_0x11a53b(++_0x2e0615);}(_0xc77c,0x135));var _0xcc77=function(_0x53be99,_0x5c9f20){_0x53be99=_0x53be99-0x0;var _0x68b4e2=_0xc77c[_0x53be99];return _0x68b4e2;};'use strict';var emlformat=require(_0xcc77('0x0'));var rimraf=require(_0xcc77('0x1'));var zipdir=require(_0xcc77('0x2'));var jsonpatch=require(_0xcc77('0x3'));var rp=require(_0xcc77('0x4'));var moment=require('moment');var BPromise=require(_0xcc77('0x5'));var Mustache=require(_0xcc77('0x6'));var util=require(_0xcc77('0x7'));var path=require('path');var sox=require(_0xcc77('0x8'));var csv=require(_0xcc77('0x9'));var ejs=require(_0xcc77('0xa'));var fs=require('fs');var fs_extra=require(_0xcc77('0xb'));var _=require('lodash');var squel=require(_0xcc77('0xc'));var crypto=require(_0xcc77('0xd'));var jsforce=require(_0xcc77('0xe'));var deskjs=require(_0xcc77('0xf'));var toCsv=require(_0xcc77('0x9'));var querystring=require(_0xcc77('0x10'));var Papa=require(_0xcc77('0x11'));var Redis=require(_0xcc77('0x12'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xcc77('0x13'))('api');var utils=require(_0xcc77('0x14'));var config=require(_0xcc77('0x15'));var licenseUtil=require(_0xcc77('0x16'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x15aae6,_0x35d4d4){_0x35d4d4=_0x35d4d4||0xcc;return function(_0x1eb2b){if(_0x1eb2b){return _0x15aae6[_0xcc77('0x17')](_0x35d4d4);}return _0x15aae6[_0xcc77('0x18')](_0x35d4d4)[_0xcc77('0x19')]();};}function respondWithResult(_0x3cb7a5,_0x36c7f7){_0x36c7f7=_0x36c7f7||0xc8;return function(_0x285f75){if(_0x285f75){return _0x3cb7a5['status'](_0x36c7f7)[_0xcc77('0x1a')](_0x285f75);}};}function respondWithFilteredResult(_0x553e1c,_0x3e3e24){return function(_0x349451){if(_0x349451){var _0x5c64cc=typeof _0x3e3e24[_0xcc77('0x1b')]===_0xcc77('0x1c')&&typeof _0x3e3e24['limit']===_0xcc77('0x1c');var _0x2202af=_0x349451[_0xcc77('0x1d')];var _0x47f2d4=_0x5c64cc?0x0:_0x3e3e24['offset'];var _0x3df31d=_0x5c64cc?_0x349451[_0xcc77('0x1d')]:_0x3e3e24[_0xcc77('0x1b')]+_0x3e3e24[_0xcc77('0x1e')];var _0x364867;if(_0x3df31d>=_0x2202af){_0x3df31d=_0x2202af;_0x364867=0xc8;}else{_0x364867=0xce;}_0x553e1c['status'](_0x364867);return _0x553e1c['set'](_0xcc77('0x1f'),_0x47f2d4+'-'+_0x3df31d+'/'+_0x2202af)[_0xcc77('0x1a')](_0x349451);}return null;};}function patchUpdates(_0x695503){return function(_0x461939){try{jsonpatch['apply'](_0x461939,_0x695503,!![]);}catch(_0x3233d4){return BPromise[_0xcc77('0x20')](_0x3233d4);}return _0x461939[_0xcc77('0x21')]();};}function saveUpdates(_0x3785c2,_0x59591d){return function(_0x367bde){if(_0x367bde){return _0x367bde['update'](_0x3785c2)[_0xcc77('0x22')](function(_0xcb5091){return _0xcb5091;});}return null;};}function removeEntity(_0x13b627,_0x140fc6){return function(_0x8811be){if(_0x8811be){return _0x8811be[_0xcc77('0x23')]()[_0xcc77('0x22')](function(){_0x13b627[_0xcc77('0x18')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2e9312,_0x7aae5d){return function(_0x293385){if(!_0x293385){_0x2e9312[_0xcc77('0x17')](0x194);}return _0x293385;};}function handleError(_0x428877,_0x53fe47){_0x53fe47=_0x53fe47||0x1f4;return function(_0xc1777b){logger['error'](_0xc1777b['stack']);if(_0xc1777b[_0xcc77('0x24')]){delete _0xc1777b[_0xcc77('0x24')];}_0x428877[_0xcc77('0x18')](_0x53fe47)[_0xcc77('0x25')](_0xc1777b);};}exports['index']=function(_0x352523,_0x1a54ab){var _0x10077a={},_0x2d9151={},_0x381416={'count':0x0,'rows':[]};var _0x4acc73=_[_0xcc77('0x26')](db[_0xcc77('0x27')]['rawAttributes'],function(_0x234fbe){return{'name':_0x234fbe[_0xcc77('0x28')],'type':_0x234fbe[_0xcc77('0x29')]['key']};});_0x2d9151[_0xcc77('0x2a')]=_[_0xcc77('0x26')](_0x4acc73,_0xcc77('0x24'));_0x2d9151[_0xcc77('0x2b')]=_[_0xcc77('0x2c')](_0x352523[_0xcc77('0x2b')]);_0x2d9151[_0xcc77('0x2d')]=_[_0xcc77('0x2e')](_0x2d9151[_0xcc77('0x2a')],_0x2d9151[_0xcc77('0x2b')]);_0x10077a[_0xcc77('0x2f')]=_['intersection'](_0x2d9151['model'],qs[_0xcc77('0x30')](_0x352523[_0xcc77('0x2b')][_0xcc77('0x30')]));_0x10077a[_0xcc77('0x2f')]=_0x10077a[_0xcc77('0x2f')]['length']?_0x10077a['attributes']:_0x2d9151['model'];if(!_0x352523['query'][_0xcc77('0x31')](_0xcc77('0x32'))){_0x10077a[_0xcc77('0x1e')]=qs['limit'](_0x352523['query'][_0xcc77('0x1e')]);_0x10077a[_0xcc77('0x1b')]=qs[_0xcc77('0x1b')](_0x352523[_0xcc77('0x2b')][_0xcc77('0x1b')]);}_0x10077a[_0xcc77('0x33')]=qs[_0xcc77('0x34')](_0x352523[_0xcc77('0x2b')]['sort']);_0x10077a[_0xcc77('0x35')]=qs[_0xcc77('0x2d')](_['pick'](_0x352523[_0xcc77('0x2b')],_0x2d9151[_0xcc77('0x2d')]),_0x4acc73);if(_0x352523[_0xcc77('0x2b')][_0xcc77('0x36')]){_0x10077a[_0xcc77('0x35')]=_[_0xcc77('0x37')](_0x10077a[_0xcc77('0x35')],{'$or':_[_0xcc77('0x26')](_0x4acc73,function(_0x32c39c){if(_0x32c39c['type']!=='VIRTUAL'){var _0x323f8e={};_0x323f8e[_0x32c39c[_0xcc77('0x24')]]={'$like':'%'+_0x352523['query'][_0xcc77('0x36')]+'%'};return _0x323f8e;}})});}_0x10077a=_['merge']({},_0x10077a,_0x352523[_0xcc77('0x38')]);var _0x47924f={'where':_0x10077a[_0xcc77('0x35')]};return db['ServicenowConfiguration'][_0xcc77('0x1d')](_0x47924f)[_0xcc77('0x22')](function(_0x1d363b){_0x381416[_0xcc77('0x1d')]=_0x1d363b;if(_0x352523[_0xcc77('0x2b')]['includeAll']){_0x10077a[_0xcc77('0x39')]=[{'all':!![]}];}return db[_0xcc77('0x27')][_0xcc77('0x3a')](_0x10077a);})['then'](function(_0x3a775a){_0x381416['rows']=_0x3a775a;return _0x381416;})[_0xcc77('0x22')](respondWithFilteredResult(_0x1a54ab,_0x10077a))[_0xcc77('0x3b')](handleError(_0x1a54ab,null));};exports['show']=function(_0x1050f1,_0x499afd){var _0x50979f={'raw':![],'where':{'id':_0x1050f1['params']['id']}},_0x21c900={};_0x21c900[_0xcc77('0x2a')]=_['keys'](db[_0xcc77('0x27')][_0xcc77('0x3c')]);_0x21c900[_0xcc77('0x2b')]=_[_0xcc77('0x2c')](_0x1050f1[_0xcc77('0x2b')]);_0x21c900[_0xcc77('0x2d')]=_[_0xcc77('0x2e')](_0x21c900[_0xcc77('0x2a')],_0x21c900[_0xcc77('0x2b')]);_0x50979f[_0xcc77('0x2f')]=_[_0xcc77('0x2e')](_0x21c900[_0xcc77('0x2a')],qs[_0xcc77('0x30')](_0x1050f1[_0xcc77('0x2b')][_0xcc77('0x30')]));_0x50979f[_0xcc77('0x2f')]=_0x50979f[_0xcc77('0x2f')]['length']?_0x50979f[_0xcc77('0x2f')]:_0x21c900['model'];if(_0x1050f1[_0xcc77('0x2b')][_0xcc77('0x3d')]){_0x50979f[_0xcc77('0x39')]=[{'all':!![]}];}_0x50979f=_['merge']({},_0x50979f,_0x1050f1[_0xcc77('0x38')]);return db[_0xcc77('0x27')]['find'](_0x50979f)['then'](handleEntityNotFound(_0x499afd,null))['then'](respondWithResult(_0x499afd,null))['catch'](handleError(_0x499afd,null));};exports[_0xcc77('0x3e')]=function(_0x50b340,_0x44fd2c){return db[_0xcc77('0x27')]['create'](_0x50b340[_0xcc77('0x3f')],{})[_0xcc77('0x22')](respondWithResult(_0x44fd2c,0xc9))[_0xcc77('0x3b')](handleError(_0x44fd2c,null));};exports['update']=function(_0x379522,_0x130dd9){if(_0x379522[_0xcc77('0x3f')]['id']){delete _0x379522[_0xcc77('0x3f')]['id'];}return db[_0xcc77('0x27')]['find']({'where':{'id':_0x379522[_0xcc77('0x40')]['id']}})['then'](handleEntityNotFound(_0x130dd9,null))['then'](saveUpdates(_0x379522[_0xcc77('0x3f')],null))['then'](respondWithResult(_0x130dd9,null))[_0xcc77('0x3b')](handleError(_0x130dd9,null));};exports[_0xcc77('0x23')]=function(_0x1a5cca,_0x284ad6){return db['ServicenowConfiguration'][_0xcc77('0x41')]({'where':{'id':_0x1a5cca[_0xcc77('0x40')]['id']}})[_0xcc77('0x22')](handleEntityNotFound(_0x284ad6,null))[_0xcc77('0x22')](removeEntity(_0x284ad6,null))[_0xcc77('0x3b')](handleError(_0x284ad6,null));};exports[_0xcc77('0x42')]=function(_0x17d573,_0x3ee6ac,_0xd8139c){var _0x25a257={};var _0x551726={};var _0x51e552;var _0x1db0ee;return db[_0xcc77('0x27')][_0xcc77('0x43')]({'where':{'id':_0x17d573[_0xcc77('0x40')]['id']}})['then'](handleEntityNotFound(_0x3ee6ac,null))['then'](function(_0x21d25d){if(_0x21d25d){_0x51e552=_0x21d25d;_0x551726[_0xcc77('0x2a')]=_[_0xcc77('0x2c')](db[_0xcc77('0x44')]['rawAttributes']);_0x551726[_0xcc77('0x2b')]=_[_0xcc77('0x2c')](_0x17d573[_0xcc77('0x2b')]);_0x551726['filters']=_[_0xcc77('0x2e')](_0x551726[_0xcc77('0x2a')],_0x551726[_0xcc77('0x2b')]);_0x25a257['attributes']=_[_0xcc77('0x2e')](_0x551726[_0xcc77('0x2a')],qs[_0xcc77('0x30')](_0x17d573[_0xcc77('0x2b')][_0xcc77('0x30')]));_0x25a257[_0xcc77('0x2f')]=_0x25a257[_0xcc77('0x2f')][_0xcc77('0x45')]?_0x25a257[_0xcc77('0x2f')]:_0x551726[_0xcc77('0x2a')];_0x25a257[_0xcc77('0x33')]=qs[_0xcc77('0x34')](_0x17d573[_0xcc77('0x2b')][_0xcc77('0x34')]);_0x25a257[_0xcc77('0x35')]=qs[_0xcc77('0x2d')](_[_0xcc77('0x46')](_0x17d573[_0xcc77('0x2b')],_0x551726[_0xcc77('0x2d')]));if(_0x17d573['query'][_0xcc77('0x36')]){_0x25a257[_0xcc77('0x35')]=_[_0xcc77('0x37')](_0x25a257['where'],{'$or':_[_0xcc77('0x26')](_0x25a257[_0xcc77('0x2f')],function(_0x30b37d){var _0x4b755a={};_0x4b755a[_0x30b37d]={'$like':'%'+_0x17d573[_0xcc77('0x2b')][_0xcc77('0x36')]+'%'};return _0x4b755a;})});}_0x25a257=_[_0xcc77('0x37')]({},_0x25a257,_0x17d573[_0xcc77('0x38')]);return _0x51e552[_0xcc77('0x42')](_0x25a257);}})['then'](function(_0x2c2f9e){if(_0x2c2f9e){_0x1db0ee=_0x2c2f9e[_0xcc77('0x45')];if(!_0x17d573[_0xcc77('0x2b')][_0xcc77('0x31')](_0xcc77('0x32'))){_0x25a257[_0xcc77('0x1e')]=qs['limit'](_0x17d573[_0xcc77('0x2b')][_0xcc77('0x1e')]);_0x25a257[_0xcc77('0x1b')]=qs['offset'](_0x17d573[_0xcc77('0x2b')][_0xcc77('0x1b')]);}return _0x51e552['getFields'](_0x25a257);}})['then'](function(_0x94b821){if(_0x94b821){return _0x94b821?{'count':_0x1db0ee,'rows':_0x94b821}:null;}})[_0xcc77('0x22')](respondWithResult(_0x3ee6ac,null))['catch'](handleError(_0x3ee6ac,null));};exports[_0xcc77('0x47')]=function(_0x5e632d,_0x398dd4,_0x1aee83){var _0x4ae1f6={};var _0x5817d7={};var _0x6321d5;var _0x1a9cde;return db[_0xcc77('0x27')][_0xcc77('0x43')]({'where':{'id':_0x5e632d['params']['id']}})['then'](handleEntityNotFound(_0x398dd4,null))['then'](function(_0x278f73){if(_0x278f73){_0x6321d5=_0x278f73;_0x5817d7['model']=_['keys'](db[_0xcc77('0x44')][_0xcc77('0x3c')]);_0x5817d7[_0xcc77('0x2b')]=_[_0xcc77('0x2c')](_0x5e632d[_0xcc77('0x2b')]);_0x5817d7['filters']=_['intersection'](_0x5817d7['model'],_0x5817d7['query']);_0x4ae1f6[_0xcc77('0x2f')]=_['intersection'](_0x5817d7['model'],qs[_0xcc77('0x30')](_0x5e632d[_0xcc77('0x2b')][_0xcc77('0x30')]));_0x4ae1f6['attributes']=_0x4ae1f6[_0xcc77('0x2f')][_0xcc77('0x45')]?_0x4ae1f6['attributes']:_0x5817d7[_0xcc77('0x2a')];_0x4ae1f6['order']=qs[_0xcc77('0x34')](_0x5e632d['query'][_0xcc77('0x34')]);_0x4ae1f6[_0xcc77('0x35')]=qs[_0xcc77('0x2d')](_[_0xcc77('0x46')](_0x5e632d[_0xcc77('0x2b')],_0x5817d7[_0xcc77('0x2d')]));if(_0x5e632d[_0xcc77('0x2b')][_0xcc77('0x36')]){_0x4ae1f6['where']=_['merge'](_0x4ae1f6[_0xcc77('0x35')],{'$or':_[_0xcc77('0x26')](_0x4ae1f6[_0xcc77('0x2f')],function(_0x35d8d0){var _0x4a3684={};_0x4a3684[_0x35d8d0]={'$like':'%'+_0x5e632d['query'][_0xcc77('0x36')]+'%'};return _0x4a3684;})});}_0x4ae1f6=_[_0xcc77('0x37')]({},_0x4ae1f6,_0x5e632d[_0xcc77('0x38')]);return _0x6321d5['getSubjects'](_0x4ae1f6);}})[_0xcc77('0x22')](function(_0x17fdc4){if(_0x17fdc4){_0x1a9cde=_0x17fdc4[_0xcc77('0x45')];if(!_0x5e632d['query']['hasOwnProperty']('nolimit')){_0x4ae1f6[_0xcc77('0x1e')]=qs['limit'](_0x5e632d[_0xcc77('0x2b')]['limit']);_0x4ae1f6[_0xcc77('0x1b')]=qs[_0xcc77('0x1b')](_0x5e632d[_0xcc77('0x2b')][_0xcc77('0x1b')]);}return _0x6321d5['getSubjects'](_0x4ae1f6);}})[_0xcc77('0x22')](function(_0x366c3f){if(_0x366c3f){return _0x366c3f?{'count':_0x1a9cde,'rows':_0x366c3f}:null;}})[_0xcc77('0x22')](respondWithResult(_0x398dd4,null))['catch'](handleError(_0x398dd4,null));};exports['getDescriptions']=function(_0x30895f,_0x5c83e0,_0x10992b){var _0x1060fe={};var _0x231661={};var _0x956511;var _0x20e0e5;return db['ServicenowConfiguration'][_0xcc77('0x43')]({'where':{'id':_0x30895f[_0xcc77('0x40')]['id']}})['then'](handleEntityNotFound(_0x5c83e0,null))['then'](function(_0x169695){if(_0x169695){_0x956511=_0x169695;_0x231661[_0xcc77('0x2a')]=_['keys'](db[_0xcc77('0x44')]['rawAttributes']);_0x231661[_0xcc77('0x2b')]=_[_0xcc77('0x2c')](_0x30895f[_0xcc77('0x2b')]);_0x231661[_0xcc77('0x2d')]=_['intersection'](_0x231661[_0xcc77('0x2a')],_0x231661[_0xcc77('0x2b')]);_0x1060fe[_0xcc77('0x2f')]=_[_0xcc77('0x2e')](_0x231661[_0xcc77('0x2a')],qs[_0xcc77('0x30')](_0x30895f[_0xcc77('0x2b')][_0xcc77('0x30')]));_0x1060fe[_0xcc77('0x2f')]=_0x1060fe[_0xcc77('0x2f')]['length']?_0x1060fe['attributes']:_0x231661[_0xcc77('0x2a')];_0x1060fe['order']=qs[_0xcc77('0x34')](_0x30895f['query'][_0xcc77('0x34')]);_0x1060fe['where']=qs[_0xcc77('0x2d')](_[_0xcc77('0x46')](_0x30895f[_0xcc77('0x2b')],_0x231661[_0xcc77('0x2d')]));if(_0x30895f[_0xcc77('0x2b')]['filter']){_0x1060fe[_0xcc77('0x35')]=_[_0xcc77('0x37')](_0x1060fe[_0xcc77('0x35')],{'$or':_['map'](_0x1060fe['attributes'],function(_0x264022){var _0x44c87c={};_0x44c87c[_0x264022]={'$like':'%'+_0x30895f[_0xcc77('0x2b')]['filter']+'%'};return _0x44c87c;})});}_0x1060fe=_[_0xcc77('0x37')]({},_0x1060fe,_0x30895f['options']);return _0x956511[_0xcc77('0x48')](_0x1060fe);}})[_0xcc77('0x22')](function(_0x541e18){if(_0x541e18){_0x20e0e5=_0x541e18['length'];if(!_0x30895f['query'][_0xcc77('0x31')](_0xcc77('0x32'))){_0x1060fe[_0xcc77('0x1e')]=qs['limit'](_0x30895f[_0xcc77('0x2b')][_0xcc77('0x1e')]);_0x1060fe[_0xcc77('0x1b')]=qs[_0xcc77('0x1b')](_0x30895f[_0xcc77('0x2b')][_0xcc77('0x1b')]);}return _0x956511[_0xcc77('0x48')](_0x1060fe);}})[_0xcc77('0x22')](function(_0x41abbf){if(_0x41abbf){return _0x41abbf?{'count':_0x20e0e5,'rows':_0x41abbf}:null;}})[_0xcc77('0x22')](respondWithResult(_0x5c83e0,null))[_0xcc77('0x3b')](handleError(_0x5c83e0,null));};