90f07c51d9d3d937ac8cba4895e3a459f6f89551
[motion2.git] / 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 _0x5ecb=['reject','save','update','then','end','name','send','map','fieldName','type','key','keys','query','filters','intersection','model','fields','attributes','hasOwnProperty','sort','where','pick','filter','merge','VIRTUAL','includeAll','include','ServicenowConfiguration','findAll','catch','show','rawAttributes','options','find','create','body','params','destroy','getFields','ServicenowField','length','order','nolimit','findOne','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','ejs','fs-extra','lodash','squel','to-csv','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','limit','count','apply'];(function(_0x12b662,_0x424f39){var _0x1e01f6=function(_0x52d663){while(--_0x52d663){_0x12b662['push'](_0x12b662['shift']());}};_0x1e01f6(++_0x424f39);}(_0x5ecb,0x115));var _0xb5ec=function(_0x484e36,_0x4482d8){_0x484e36=_0x484e36-0x0;var _0xafc85d=_0x5ecb[_0x484e36];return _0xafc85d;};'use strict';var emlformat=require(_0xb5ec('0x0'));var rimraf=require(_0xb5ec('0x1'));var zipdir=require(_0xb5ec('0x2'));var jsonpatch=require(_0xb5ec('0x3'));var rp=require(_0xb5ec('0x4'));var moment=require(_0xb5ec('0x5'));var BPromise=require(_0xb5ec('0x6'));var Mustache=require(_0xb5ec('0x7'));var util=require('util');var path=require(_0xb5ec('0x8'));var sox=require(_0xb5ec('0x9'));var csv=require('to-csv');var ejs=require(_0xb5ec('0xa'));var fs=require('fs');var fs_extra=require(_0xb5ec('0xb'));var _=require(_0xb5ec('0xc'));var squel=require(_0xb5ec('0xd'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xb5ec('0xe'));var querystring=require(_0xb5ec('0xf'));var Papa=require(_0xb5ec('0x10'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0xb5ec('0x11'));var as=require(_0xb5ec('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xb5ec('0x13'));var utils=require('../../config/utils');var config=require(_0xb5ec('0x14'));var licenseUtil=require(_0xb5ec('0x15'));var db=require(_0xb5ec('0x16'))['db'];function respondWithStatusCode(_0x43925b,_0xe661a){_0xe661a=_0xe661a||0xcc;return function(_0x5df5e3){if(_0x5df5e3){return _0x43925b[_0xb5ec('0x17')](_0xe661a);}return _0x43925b[_0xb5ec('0x18')](_0xe661a)['end']();};}function respondWithResult(_0x52747f,_0x48062f){_0x48062f=_0x48062f||0xc8;return function(_0x2ae6bf){if(_0x2ae6bf){return _0x52747f['status'](_0x48062f)[_0xb5ec('0x19')](_0x2ae6bf);}};}function respondWithFilteredResult(_0x3fa0b3,_0x59ffeb){return function(_0x339fd6){if(_0x339fd6){var _0x235a78=typeof _0x59ffeb[_0xb5ec('0x1a')]===_0xb5ec('0x1b')&&typeof _0x59ffeb[_0xb5ec('0x1c')]===_0xb5ec('0x1b');var _0x45fb57=_0x339fd6[_0xb5ec('0x1d')];var _0x57b051=_0x235a78?0x0:_0x59ffeb[_0xb5ec('0x1a')];var _0x3c3849=_0x235a78?_0x339fd6['count']:_0x59ffeb['offset']+_0x59ffeb[_0xb5ec('0x1c')];var _0x4addc4;if(_0x3c3849>=_0x45fb57){_0x3c3849=_0x45fb57;_0x4addc4=0xc8;}else{_0x4addc4=0xce;}_0x3fa0b3[_0xb5ec('0x18')](_0x4addc4);return _0x3fa0b3['set']('Content-Range',_0x57b051+'-'+_0x3c3849+'/'+_0x45fb57)[_0xb5ec('0x19')](_0x339fd6);}return null;};}function patchUpdates(_0x5de367){return function(_0x4f8755){try{jsonpatch[_0xb5ec('0x1e')](_0x4f8755,_0x5de367,!![]);}catch(_0x522ff0){return BPromise[_0xb5ec('0x1f')](_0x522ff0);}return _0x4f8755[_0xb5ec('0x20')]();};}function saveUpdates(_0x201baf,_0x1dfd9b){return function(_0x4f3ff2){if(_0x4f3ff2){return _0x4f3ff2[_0xb5ec('0x21')](_0x201baf)[_0xb5ec('0x22')](function(_0x45a209){return _0x45a209;});}return null;};}function removeEntity(_0x537a91,_0x5e411a){return function(_0x568c29){if(_0x568c29){return _0x568c29['destroy']()[_0xb5ec('0x22')](function(){_0x537a91[_0xb5ec('0x18')](0xcc)[_0xb5ec('0x23')]();});}};}function handleEntityNotFound(_0x4f8042,_0x54febc){return function(_0x265677){if(!_0x265677){_0x4f8042[_0xb5ec('0x17')](0x194);}return _0x265677;};}function handleError(_0x41b104,_0xb938d4){_0xb938d4=_0xb938d4||0x1f4;return function(_0x80ea9e){logger['error'](_0x80ea9e['stack']);if(_0x80ea9e['name']){delete _0x80ea9e[_0xb5ec('0x24')];}_0x41b104['status'](_0xb938d4)[_0xb5ec('0x25')](_0x80ea9e);};}exports['index']=function(_0x4478fd,_0x5c09da){var _0x4ebcac={},_0x3f3946={},_0x4cbfd4={'count':0x0,'rows':[]};var _0x591322=_[_0xb5ec('0x26')](db['ServicenowConfiguration']['rawAttributes'],function(_0xe5ae1e){return{'name':_0xe5ae1e[_0xb5ec('0x27')],'type':_0xe5ae1e[_0xb5ec('0x28')][_0xb5ec('0x29')]};});_0x3f3946['model']=_[_0xb5ec('0x26')](_0x591322,_0xb5ec('0x24'));_0x3f3946['query']=_[_0xb5ec('0x2a')](_0x4478fd[_0xb5ec('0x2b')]);_0x3f3946[_0xb5ec('0x2c')]=_[_0xb5ec('0x2d')](_0x3f3946[_0xb5ec('0x2e')],_0x3f3946[_0xb5ec('0x2b')]);_0x4ebcac['attributes']=_['intersection'](_0x3f3946[_0xb5ec('0x2e')],qs[_0xb5ec('0x2f')](_0x4478fd['query'][_0xb5ec('0x2f')]));_0x4ebcac['attributes']=_0x4ebcac[_0xb5ec('0x30')]['length']?_0x4ebcac[_0xb5ec('0x30')]:_0x3f3946[_0xb5ec('0x2e')];if(!_0x4478fd[_0xb5ec('0x2b')][_0xb5ec('0x31')]('nolimit')){_0x4ebcac[_0xb5ec('0x1c')]=qs[_0xb5ec('0x1c')](_0x4478fd[_0xb5ec('0x2b')][_0xb5ec('0x1c')]);_0x4ebcac['offset']=qs[_0xb5ec('0x1a')](_0x4478fd[_0xb5ec('0x2b')][_0xb5ec('0x1a')]);}_0x4ebcac['order']=qs[_0xb5ec('0x32')](_0x4478fd['query']['sort']);_0x4ebcac[_0xb5ec('0x33')]=qs[_0xb5ec('0x2c')](_[_0xb5ec('0x34')](_0x4478fd[_0xb5ec('0x2b')],_0x3f3946['filters']),_0x591322);if(_0x4478fd[_0xb5ec('0x2b')][_0xb5ec('0x35')]){_0x4ebcac['where']=_[_0xb5ec('0x36')](_0x4ebcac[_0xb5ec('0x33')],{'$or':_[_0xb5ec('0x26')](_0x591322,function(_0x4d9504){if(_0x4d9504[_0xb5ec('0x28')]!==_0xb5ec('0x37')){var _0x57cfe6={};_0x57cfe6[_0x4d9504[_0xb5ec('0x24')]]={'$like':'%'+_0x4478fd[_0xb5ec('0x2b')][_0xb5ec('0x35')]+'%'};return _0x57cfe6;}})});}_0x4ebcac=_[_0xb5ec('0x36')]({},_0x4ebcac,_0x4478fd['options']);var _0x2cfa77={'where':_0x4ebcac[_0xb5ec('0x33')]};return db['ServicenowConfiguration'][_0xb5ec('0x1d')](_0x2cfa77)['then'](function(_0xdb2898){_0x4cbfd4[_0xb5ec('0x1d')]=_0xdb2898;if(_0x4478fd[_0xb5ec('0x2b')][_0xb5ec('0x38')]){_0x4ebcac[_0xb5ec('0x39')]=[{'all':!![]}];}return db[_0xb5ec('0x3a')][_0xb5ec('0x3b')](_0x4ebcac);})['then'](function(_0x337ebd){_0x4cbfd4['rows']=_0x337ebd;return _0x4cbfd4;})['then'](respondWithFilteredResult(_0x5c09da,_0x4ebcac))[_0xb5ec('0x3c')](handleError(_0x5c09da,null));};exports[_0xb5ec('0x3d')]=function(_0x33930b,_0x4c400d){var _0x4f9be6={'raw':![],'where':{'id':_0x33930b['params']['id']}},_0x1732c2={};_0x1732c2[_0xb5ec('0x2e')]=_[_0xb5ec('0x2a')](db[_0xb5ec('0x3a')][_0xb5ec('0x3e')]);_0x1732c2[_0xb5ec('0x2b')]=_[_0xb5ec('0x2a')](_0x33930b['query']);_0x1732c2[_0xb5ec('0x2c')]=_['intersection'](_0x1732c2[_0xb5ec('0x2e')],_0x1732c2['query']);_0x4f9be6['attributes']=_[_0xb5ec('0x2d')](_0x1732c2[_0xb5ec('0x2e')],qs['fields'](_0x33930b[_0xb5ec('0x2b')][_0xb5ec('0x2f')]));_0x4f9be6[_0xb5ec('0x30')]=_0x4f9be6[_0xb5ec('0x30')]['length']?_0x4f9be6[_0xb5ec('0x30')]:_0x1732c2[_0xb5ec('0x2e')];if(_0x33930b[_0xb5ec('0x2b')]['includeAll']){_0x4f9be6[_0xb5ec('0x39')]=[{'all':!![]}];}_0x4f9be6=_[_0xb5ec('0x36')]({},_0x4f9be6,_0x33930b[_0xb5ec('0x3f')]);return db[_0xb5ec('0x3a')][_0xb5ec('0x40')](_0x4f9be6)[_0xb5ec('0x22')](handleEntityNotFound(_0x4c400d,null))[_0xb5ec('0x22')](respondWithResult(_0x4c400d,null))[_0xb5ec('0x3c')](handleError(_0x4c400d,null));};exports[_0xb5ec('0x41')]=function(_0xb9a207,_0x45c3e3){return db[_0xb5ec('0x3a')][_0xb5ec('0x41')](_0xb9a207[_0xb5ec('0x42')],{})[_0xb5ec('0x22')](respondWithResult(_0x45c3e3,0xc9))[_0xb5ec('0x3c')](handleError(_0x45c3e3,null));};exports[_0xb5ec('0x21')]=function(_0x3db4de,_0x44a614){if(_0x3db4de[_0xb5ec('0x42')]['id']){delete _0x3db4de['body']['id'];}return db[_0xb5ec('0x3a')][_0xb5ec('0x40')]({'where':{'id':_0x3db4de[_0xb5ec('0x43')]['id']}})[_0xb5ec('0x22')](handleEntityNotFound(_0x44a614,null))[_0xb5ec('0x22')](saveUpdates(_0x3db4de[_0xb5ec('0x42')],null))[_0xb5ec('0x22')](respondWithResult(_0x44a614,null))['catch'](handleError(_0x44a614,null));};exports[_0xb5ec('0x44')]=function(_0x547fd5,_0x15ee13){return db[_0xb5ec('0x3a')][_0xb5ec('0x40')]({'where':{'id':_0x547fd5[_0xb5ec('0x43')]['id']}})[_0xb5ec('0x22')](handleEntityNotFound(_0x15ee13,null))[_0xb5ec('0x22')](removeEntity(_0x15ee13,null))[_0xb5ec('0x3c')](handleError(_0x15ee13,null));};exports[_0xb5ec('0x45')]=function(_0x1cc93a,_0x53b2af,_0x4ac0cc){var _0x4f1a7e={};var _0x41a9a4={};var _0x2be5a7;var _0x16025f;return db[_0xb5ec('0x3a')]['findOne']({'where':{'id':_0x1cc93a[_0xb5ec('0x43')]['id']}})['then'](handleEntityNotFound(_0x53b2af,null))[_0xb5ec('0x22')](function(_0x5025e2){if(_0x5025e2){_0x2be5a7=_0x5025e2;_0x41a9a4[_0xb5ec('0x2e')]=_['keys'](db[_0xb5ec('0x46')][_0xb5ec('0x3e')]);_0x41a9a4[_0xb5ec('0x2b')]=_['keys'](_0x1cc93a['query']);_0x41a9a4[_0xb5ec('0x2c')]=_['intersection'](_0x41a9a4[_0xb5ec('0x2e')],_0x41a9a4['query']);_0x4f1a7e[_0xb5ec('0x30')]=_[_0xb5ec('0x2d')](_0x41a9a4[_0xb5ec('0x2e')],qs[_0xb5ec('0x2f')](_0x1cc93a['query'][_0xb5ec('0x2f')]));_0x4f1a7e[_0xb5ec('0x30')]=_0x4f1a7e['attributes'][_0xb5ec('0x47')]?_0x4f1a7e['attributes']:_0x41a9a4[_0xb5ec('0x2e')];_0x4f1a7e[_0xb5ec('0x48')]=qs[_0xb5ec('0x32')](_0x1cc93a[_0xb5ec('0x2b')][_0xb5ec('0x32')]);_0x4f1a7e['where']=qs['filters'](_['pick'](_0x1cc93a[_0xb5ec('0x2b')],_0x41a9a4['filters']));if(_0x1cc93a[_0xb5ec('0x2b')][_0xb5ec('0x35')]){_0x4f1a7e[_0xb5ec('0x33')]=_[_0xb5ec('0x36')](_0x4f1a7e[_0xb5ec('0x33')],{'$or':_[_0xb5ec('0x26')](_0x4f1a7e['attributes'],function(_0x4f4938){var _0x4549b5={};_0x4549b5[_0x4f4938]={'$like':'%'+_0x1cc93a[_0xb5ec('0x2b')]['filter']+'%'};return _0x4549b5;})});}_0x4f1a7e=_[_0xb5ec('0x36')]({},_0x4f1a7e,_0x1cc93a[_0xb5ec('0x3f')]);return _0x2be5a7[_0xb5ec('0x45')](_0x4f1a7e);}})[_0xb5ec('0x22')](function(_0x58a60b){if(_0x58a60b){_0x16025f=_0x58a60b[_0xb5ec('0x47')];if(!_0x1cc93a[_0xb5ec('0x2b')][_0xb5ec('0x31')](_0xb5ec('0x49'))){_0x4f1a7e['limit']=qs[_0xb5ec('0x1c')](_0x1cc93a[_0xb5ec('0x2b')][_0xb5ec('0x1c')]);_0x4f1a7e['offset']=qs[_0xb5ec('0x1a')](_0x1cc93a[_0xb5ec('0x2b')][_0xb5ec('0x1a')]);}return _0x2be5a7[_0xb5ec('0x45')](_0x4f1a7e);}})[_0xb5ec('0x22')](function(_0xcc8766){if(_0xcc8766){return _0xcc8766?{'count':_0x16025f,'rows':_0xcc8766}:null;}})[_0xb5ec('0x22')](respondWithResult(_0x53b2af,null))['catch'](handleError(_0x53b2af,null));};exports['getSubjects']=function(_0x3b67d3,_0x11fc24,_0x269903){var _0x292efd={};var _0x4cc2a0={};var _0x45256c;var _0x5dbb2a;return db[_0xb5ec('0x3a')][_0xb5ec('0x4a')]({'where':{'id':_0x3b67d3['params']['id']}})[_0xb5ec('0x22')](handleEntityNotFound(_0x11fc24,null))['then'](function(_0x2955e6){if(_0x2955e6){_0x45256c=_0x2955e6;_0x4cc2a0[_0xb5ec('0x2e')]=_['keys'](db[_0xb5ec('0x46')]['rawAttributes']);_0x4cc2a0[_0xb5ec('0x2b')]=_['keys'](_0x3b67d3['query']);_0x4cc2a0[_0xb5ec('0x2c')]=_[_0xb5ec('0x2d')](_0x4cc2a0[_0xb5ec('0x2e')],_0x4cc2a0[_0xb5ec('0x2b')]);_0x292efd['attributes']=_[_0xb5ec('0x2d')](_0x4cc2a0[_0xb5ec('0x2e')],qs[_0xb5ec('0x2f')](_0x3b67d3[_0xb5ec('0x2b')][_0xb5ec('0x2f')]));_0x292efd[_0xb5ec('0x30')]=_0x292efd[_0xb5ec('0x30')][_0xb5ec('0x47')]?_0x292efd['attributes']:_0x4cc2a0[_0xb5ec('0x2e')];_0x292efd[_0xb5ec('0x48')]=qs[_0xb5ec('0x32')](_0x3b67d3[_0xb5ec('0x2b')][_0xb5ec('0x32')]);_0x292efd[_0xb5ec('0x33')]=qs[_0xb5ec('0x2c')](_[_0xb5ec('0x34')](_0x3b67d3['query'],_0x4cc2a0[_0xb5ec('0x2c')]));if(_0x3b67d3['query'][_0xb5ec('0x35')]){_0x292efd[_0xb5ec('0x33')]=_['merge'](_0x292efd[_0xb5ec('0x33')],{'$or':_[_0xb5ec('0x26')](_0x292efd['attributes'],function(_0x30b357){var _0x2fe07d={};_0x2fe07d[_0x30b357]={'$like':'%'+_0x3b67d3[_0xb5ec('0x2b')]['filter']+'%'};return _0x2fe07d;})});}_0x292efd=_['merge']({},_0x292efd,_0x3b67d3['options']);return _0x45256c[_0xb5ec('0x4b')](_0x292efd);}})['then'](function(_0x2eb0fe){if(_0x2eb0fe){_0x5dbb2a=_0x2eb0fe[_0xb5ec('0x47')];if(!_0x3b67d3['query'][_0xb5ec('0x31')](_0xb5ec('0x49'))){_0x292efd[_0xb5ec('0x1c')]=qs['limit'](_0x3b67d3[_0xb5ec('0x2b')][_0xb5ec('0x1c')]);_0x292efd[_0xb5ec('0x1a')]=qs[_0xb5ec('0x1a')](_0x3b67d3[_0xb5ec('0x2b')][_0xb5ec('0x1a')]);}return _0x45256c[_0xb5ec('0x4b')](_0x292efd);}})[_0xb5ec('0x22')](function(_0x52fafd){if(_0x52fafd){return _0x52fafd?{'count':_0x5dbb2a,'rows':_0x52fafd}:null;}})['then'](respondWithResult(_0x11fc24,null))['catch'](handleError(_0x11fc24,null));};exports['getDescriptions']=function(_0x10755e,_0x599c2d,_0x3fe146){var _0x3e8ce7={};var _0x39a450={};var _0x11f8fa;var _0x5a5727;return db['ServicenowConfiguration'][_0xb5ec('0x4a')]({'where':{'id':_0x10755e[_0xb5ec('0x43')]['id']}})[_0xb5ec('0x22')](handleEntityNotFound(_0x599c2d,null))['then'](function(_0x562e86){if(_0x562e86){_0x11f8fa=_0x562e86;_0x39a450['model']=_[_0xb5ec('0x2a')](db['ServicenowField'][_0xb5ec('0x3e')]);_0x39a450['query']=_[_0xb5ec('0x2a')](_0x10755e[_0xb5ec('0x2b')]);_0x39a450[_0xb5ec('0x2c')]=_[_0xb5ec('0x2d')](_0x39a450[_0xb5ec('0x2e')],_0x39a450[_0xb5ec('0x2b')]);_0x3e8ce7[_0xb5ec('0x30')]=_[_0xb5ec('0x2d')](_0x39a450['model'],qs[_0xb5ec('0x2f')](_0x10755e[_0xb5ec('0x2b')]['fields']));_0x3e8ce7[_0xb5ec('0x30')]=_0x3e8ce7['attributes'][_0xb5ec('0x47')]?_0x3e8ce7[_0xb5ec('0x30')]:_0x39a450[_0xb5ec('0x2e')];_0x3e8ce7['order']=qs['sort'](_0x10755e[_0xb5ec('0x2b')][_0xb5ec('0x32')]);_0x3e8ce7[_0xb5ec('0x33')]=qs['filters'](_[_0xb5ec('0x34')](_0x10755e[_0xb5ec('0x2b')],_0x39a450[_0xb5ec('0x2c')]));if(_0x10755e[_0xb5ec('0x2b')][_0xb5ec('0x35')]){_0x3e8ce7[_0xb5ec('0x33')]=_[_0xb5ec('0x36')](_0x3e8ce7[_0xb5ec('0x33')],{'$or':_['map'](_0x3e8ce7[_0xb5ec('0x30')],function(_0x93617e){var _0x27d137={};_0x27d137[_0x93617e]={'$like':'%'+_0x10755e[_0xb5ec('0x2b')][_0xb5ec('0x35')]+'%'};return _0x27d137;})});}_0x3e8ce7=_[_0xb5ec('0x36')]({},_0x3e8ce7,_0x10755e[_0xb5ec('0x3f')]);return _0x11f8fa[_0xb5ec('0x4c')](_0x3e8ce7);}})['then'](function(_0x179170){if(_0x179170){_0x5a5727=_0x179170[_0xb5ec('0x47')];if(!_0x10755e[_0xb5ec('0x2b')][_0xb5ec('0x31')](_0xb5ec('0x49'))){_0x3e8ce7[_0xb5ec('0x1c')]=qs[_0xb5ec('0x1c')](_0x10755e[_0xb5ec('0x2b')]['limit']);_0x3e8ce7['offset']=qs['offset'](_0x10755e[_0xb5ec('0x2b')]['offset']);}return _0x11f8fa[_0xb5ec('0x4c')](_0x3e8ce7);}})[_0xb5ec('0x22')](function(_0x40268a){if(_0x40268a){return _0x40268a?{'count':_0x5a5727,'rows':_0x40268a}:null;}})[_0xb5ec('0x22')](respondWithResult(_0x599c2d,null))[_0xb5ec('0x3c')](handleError(_0x599c2d,null));};