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 _0x8841=['jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','status','end','json','limit','undefined','count','offset','set','Content-Range','apply','save','update','then','destroy','sendStatus','error','stack','name','send','map','ServicenowConfiguration','rawAttributes','fieldName','model','keys','query','intersection','attributes','fields','hasOwnProperty','sort','filters','filter','where','merge','type','VIRTUAL','options','findAll','catch','show','length','includeAll','include','find','create','body','getFields','findOne','ServicenowField','order','nolimit','getSubjects','params','pick','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','path','sox','to-csv','fs-extra','lodash','crypto'];(function(_0x28b7a2,_0x40aa58){var _0x404e08=function(_0x5e2894){while(--_0x5e2894){_0x28b7a2['push'](_0x28b7a2['shift']());}};_0x404e08(++_0x40aa58);}(_0x8841,0xe6));var _0x1884=function(_0x511198,_0x11c658){_0x511198=_0x511198-0x0;var _0x5b2a9=_0x8841[_0x511198];return _0x5b2a9;};'use strict';var emlformat=require(_0x1884('0x0'));var rimraf=require(_0x1884('0x1'));var zipdir=require(_0x1884('0x2'));var jsonpatch=require(_0x1884('0x3'));var rp=require('request-promise');var moment=require(_0x1884('0x4'));var BPromise=require(_0x1884('0x5'));var Mustache=require(_0x1884('0x6'));var util=require('util');var path=require(_0x1884('0x7'));var sox=require(_0x1884('0x8'));var csv=require(_0x1884('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x1884('0xa'));var _=require(_0x1884('0xb'));var squel=require('squel');var crypto=require(_0x1884('0xc'));var jsforce=require(_0x1884('0xd'));var deskjs=require(_0x1884('0xe'));var toCsv=require(_0x1884('0x9'));var querystring=require('querystring');var Papa=require(_0x1884('0xf'));var Redis=require(_0x1884('0x10'));var authService=require(_0x1884('0x11'));var qs=require(_0x1884('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x1884('0x13'));var logger=require(_0x1884('0x14'))(_0x1884('0x15'));var utils=require(_0x1884('0x16'));var config=require(_0x1884('0x17'));var licenseUtil=require(_0x1884('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x1bf440,_0x833551){_0x833551=_0x833551||0xcc;return function(_0x4f15f8){if(_0x4f15f8){return _0x1bf440['sendStatus'](_0x833551);}return _0x1bf440[_0x1884('0x19')](_0x833551)[_0x1884('0x1a')]();};}function respondWithResult(_0x4b29ef,_0x2e81fa){_0x2e81fa=_0x2e81fa||0xc8;return function(_0x11139d){if(_0x11139d){return _0x4b29ef[_0x1884('0x19')](_0x2e81fa)[_0x1884('0x1b')](_0x11139d);}};}function respondWithFilteredResult(_0x17a5cb,_0x38365b){return function(_0xe25ce8){if(_0xe25ce8){var _0x36455c=typeof _0x38365b['offset']==='undefined'&&typeof _0x38365b[_0x1884('0x1c')]===_0x1884('0x1d');var _0x4a4e3a=_0xe25ce8[_0x1884('0x1e')];var _0x466606=_0x36455c?0x0:_0x38365b[_0x1884('0x1f')];var _0x3d004e=_0x36455c?_0xe25ce8[_0x1884('0x1e')]:_0x38365b['offset']+_0x38365b['limit'];var _0x1628cf;if(_0x3d004e>=_0x4a4e3a){_0x3d004e=_0x4a4e3a;_0x1628cf=0xc8;}else{_0x1628cf=0xce;}_0x17a5cb[_0x1884('0x19')](_0x1628cf);return _0x17a5cb[_0x1884('0x20')](_0x1884('0x21'),_0x466606+'-'+_0x3d004e+'/'+_0x4a4e3a)['json'](_0xe25ce8);}return null;};}function patchUpdates(_0x5ea5c9){return function(_0x5c1245){try{jsonpatch[_0x1884('0x22')](_0x5c1245,_0x5ea5c9,!![]);}catch(_0x288692){return BPromise['reject'](_0x288692);}return _0x5c1245[_0x1884('0x23')]();};}function saveUpdates(_0x299140,_0x20a282){return function(_0x35563e){if(_0x35563e){return _0x35563e[_0x1884('0x24')](_0x299140)[_0x1884('0x25')](function(_0x4f925e){return _0x4f925e;});}return null;};}function removeEntity(_0x2b2e8d,_0x537efc){return function(_0x4d0174){if(_0x4d0174){return _0x4d0174[_0x1884('0x26')]()[_0x1884('0x25')](function(){_0x2b2e8d['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x44d78d,_0x128b66){return function(_0x4d25b9){if(!_0x4d25b9){_0x44d78d[_0x1884('0x27')](0x194);}return _0x4d25b9;};}function handleError(_0x3d2120,_0x35950c){_0x35950c=_0x35950c||0x1f4;return function(_0x386106){logger[_0x1884('0x28')](_0x386106[_0x1884('0x29')]);if(_0x386106[_0x1884('0x2a')]){delete _0x386106[_0x1884('0x2a')];}_0x3d2120[_0x1884('0x19')](_0x35950c)[_0x1884('0x2b')](_0x386106);};}exports['index']=function(_0x230af1,_0x59a7ae){var _0x3ccde2={},_0x53b7e7={},_0x59fdb8={'count':0x0,'rows':[]};var _0x8f0ac1=_[_0x1884('0x2c')](db[_0x1884('0x2d')][_0x1884('0x2e')],function(_0x12727d){return{'name':_0x12727d[_0x1884('0x2f')],'type':_0x12727d['type']['key']};});_0x53b7e7[_0x1884('0x30')]=_[_0x1884('0x2c')](_0x8f0ac1,'name');_0x53b7e7['query']=_[_0x1884('0x31')](_0x230af1[_0x1884('0x32')]);_0x53b7e7['filters']=_[_0x1884('0x33')](_0x53b7e7[_0x1884('0x30')],_0x53b7e7[_0x1884('0x32')]);_0x3ccde2[_0x1884('0x34')]=_[_0x1884('0x33')](_0x53b7e7[_0x1884('0x30')],qs['fields'](_0x230af1['query'][_0x1884('0x35')]));_0x3ccde2[_0x1884('0x34')]=_0x3ccde2[_0x1884('0x34')]['length']?_0x3ccde2[_0x1884('0x34')]:_0x53b7e7[_0x1884('0x30')];if(!_0x230af1[_0x1884('0x32')][_0x1884('0x36')]('nolimit')){_0x3ccde2['limit']=qs['limit'](_0x230af1['query'][_0x1884('0x1c')]);_0x3ccde2['offset']=qs[_0x1884('0x1f')](_0x230af1[_0x1884('0x32')]['offset']);}_0x3ccde2['order']=qs[_0x1884('0x37')](_0x230af1['query'][_0x1884('0x37')]);_0x3ccde2['where']=qs[_0x1884('0x38')](_['pick'](_0x230af1[_0x1884('0x32')],_0x53b7e7[_0x1884('0x38')]),_0x8f0ac1);if(_0x230af1[_0x1884('0x32')][_0x1884('0x39')]){_0x3ccde2[_0x1884('0x3a')]=_[_0x1884('0x3b')](_0x3ccde2['where'],{'$or':_[_0x1884('0x2c')](_0x8f0ac1,function(_0x2393a2){if(_0x2393a2[_0x1884('0x3c')]!==_0x1884('0x3d')){var _0x32e8d3={};_0x32e8d3[_0x2393a2['name']]={'$like':'%'+_0x230af1[_0x1884('0x32')][_0x1884('0x39')]+'%'};return _0x32e8d3;}})});}_0x3ccde2=_[_0x1884('0x3b')]({},_0x3ccde2,_0x230af1[_0x1884('0x3e')]);var _0xf29f0={'where':_0x3ccde2['where']};return db['ServicenowConfiguration'][_0x1884('0x1e')](_0xf29f0)[_0x1884('0x25')](function(_0x184697){_0x59fdb8['count']=_0x184697;if(_0x230af1[_0x1884('0x32')]['includeAll']){_0x3ccde2['include']=[{'all':!![]}];}return db[_0x1884('0x2d')][_0x1884('0x3f')](_0x3ccde2);})[_0x1884('0x25')](function(_0x69af9){_0x59fdb8['rows']=_0x69af9;return _0x59fdb8;})['then'](respondWithFilteredResult(_0x59a7ae,_0x3ccde2))[_0x1884('0x40')](handleError(_0x59a7ae,null));};exports[_0x1884('0x41')]=function(_0x4f5de0,_0xb27ec2){var _0xe4de2b={'raw':![],'where':{'id':_0x4f5de0['params']['id']}},_0x556c47={};_0x556c47[_0x1884('0x30')]=_[_0x1884('0x31')](db[_0x1884('0x2d')][_0x1884('0x2e')]);_0x556c47[_0x1884('0x32')]=_[_0x1884('0x31')](_0x4f5de0[_0x1884('0x32')]);_0x556c47['filters']=_[_0x1884('0x33')](_0x556c47['model'],_0x556c47[_0x1884('0x32')]);_0xe4de2b[_0x1884('0x34')]=_['intersection'](_0x556c47[_0x1884('0x30')],qs[_0x1884('0x35')](_0x4f5de0[_0x1884('0x32')]['fields']));_0xe4de2b[_0x1884('0x34')]=_0xe4de2b['attributes'][_0x1884('0x42')]?_0xe4de2b[_0x1884('0x34')]:_0x556c47[_0x1884('0x30')];if(_0x4f5de0[_0x1884('0x32')][_0x1884('0x43')]){_0xe4de2b[_0x1884('0x44')]=[{'all':!![]}];}_0xe4de2b=_[_0x1884('0x3b')]({},_0xe4de2b,_0x4f5de0[_0x1884('0x3e')]);return db['ServicenowConfiguration'][_0x1884('0x45')](_0xe4de2b)[_0x1884('0x25')](handleEntityNotFound(_0xb27ec2,null))['then'](respondWithResult(_0xb27ec2,null))[_0x1884('0x40')](handleError(_0xb27ec2,null));};exports['create']=function(_0x294fcb,_0x19b038){return db['ServicenowConfiguration'][_0x1884('0x46')](_0x294fcb[_0x1884('0x47')],{})[_0x1884('0x25')](respondWithResult(_0x19b038,0xc9))[_0x1884('0x40')](handleError(_0x19b038,null));};exports[_0x1884('0x24')]=function(_0x5eda71,_0x301721){if(_0x5eda71[_0x1884('0x47')]['id']){delete _0x5eda71[_0x1884('0x47')]['id'];}return db[_0x1884('0x2d')][_0x1884('0x45')]({'where':{'id':_0x5eda71['params']['id']}})['then'](handleEntityNotFound(_0x301721,null))[_0x1884('0x25')](saveUpdates(_0x5eda71[_0x1884('0x47')],null))[_0x1884('0x25')](respondWithResult(_0x301721,null))[_0x1884('0x40')](handleError(_0x301721,null));};exports[_0x1884('0x26')]=function(_0x34d8b8,_0x1ffe6e){return db['ServicenowConfiguration']['find']({'where':{'id':_0x34d8b8['params']['id']}})[_0x1884('0x25')](handleEntityNotFound(_0x1ffe6e,null))[_0x1884('0x25')](removeEntity(_0x1ffe6e,null))[_0x1884('0x40')](handleError(_0x1ffe6e,null));};exports[_0x1884('0x48')]=function(_0x11c258,_0x1950ec,_0x583970){var _0x24aa10={};var _0x146fdf={};var _0x39d8b7;var _0x36068b;return db[_0x1884('0x2d')][_0x1884('0x49')]({'where':{'id':_0x11c258['params']['id']}})['then'](handleEntityNotFound(_0x1950ec,null))['then'](function(_0x35debf){if(_0x35debf){_0x39d8b7=_0x35debf;_0x146fdf[_0x1884('0x30')]=_[_0x1884('0x31')](db[_0x1884('0x4a')][_0x1884('0x2e')]);_0x146fdf[_0x1884('0x32')]=_[_0x1884('0x31')](_0x11c258[_0x1884('0x32')]);_0x146fdf[_0x1884('0x38')]=_[_0x1884('0x33')](_0x146fdf[_0x1884('0x30')],_0x146fdf[_0x1884('0x32')]);_0x24aa10[_0x1884('0x34')]=_['intersection'](_0x146fdf['model'],qs['fields'](_0x11c258['query']['fields']));_0x24aa10[_0x1884('0x34')]=_0x24aa10['attributes'][_0x1884('0x42')]?_0x24aa10[_0x1884('0x34')]:_0x146fdf['model'];_0x24aa10[_0x1884('0x4b')]=qs['sort'](_0x11c258[_0x1884('0x32')][_0x1884('0x37')]);_0x24aa10[_0x1884('0x3a')]=qs[_0x1884('0x38')](_['pick'](_0x11c258[_0x1884('0x32')],_0x146fdf[_0x1884('0x38')]));if(_0x11c258[_0x1884('0x32')][_0x1884('0x39')]){_0x24aa10[_0x1884('0x3a')]=_[_0x1884('0x3b')](_0x24aa10[_0x1884('0x3a')],{'$or':_[_0x1884('0x2c')](_0x24aa10[_0x1884('0x34')],function(_0x36c1c9){var _0x293f6d={};_0x293f6d[_0x36c1c9]={'$like':'%'+_0x11c258['query'][_0x1884('0x39')]+'%'};return _0x293f6d;})});}_0x24aa10=_[_0x1884('0x3b')]({},_0x24aa10,_0x11c258[_0x1884('0x3e')]);return _0x39d8b7[_0x1884('0x48')](_0x24aa10);}})['then'](function(_0x3002c9){if(_0x3002c9){_0x36068b=_0x3002c9[_0x1884('0x42')];if(!_0x11c258[_0x1884('0x32')][_0x1884('0x36')](_0x1884('0x4c'))){_0x24aa10[_0x1884('0x1c')]=qs[_0x1884('0x1c')](_0x11c258[_0x1884('0x32')][_0x1884('0x1c')]);_0x24aa10[_0x1884('0x1f')]=qs[_0x1884('0x1f')](_0x11c258[_0x1884('0x32')][_0x1884('0x1f')]);}return _0x39d8b7['getFields'](_0x24aa10);}})[_0x1884('0x25')](function(_0x2f8873){if(_0x2f8873){return _0x2f8873?{'count':_0x36068b,'rows':_0x2f8873}:null;}})['then'](respondWithResult(_0x1950ec,null))[_0x1884('0x40')](handleError(_0x1950ec,null));};exports[_0x1884('0x4d')]=function(_0x3cfc53,_0x25a4df,_0x229c77){var _0x519516={};var _0x5c9f69={};var _0x1ba6cc;var _0x19ba40;return db[_0x1884('0x2d')][_0x1884('0x49')]({'where':{'id':_0x3cfc53[_0x1884('0x4e')]['id']}})[_0x1884('0x25')](handleEntityNotFound(_0x25a4df,null))[_0x1884('0x25')](function(_0x6a6791){if(_0x6a6791){_0x1ba6cc=_0x6a6791;_0x5c9f69['model']=_[_0x1884('0x31')](db[_0x1884('0x4a')][_0x1884('0x2e')]);_0x5c9f69[_0x1884('0x32')]=_[_0x1884('0x31')](_0x3cfc53[_0x1884('0x32')]);_0x5c9f69[_0x1884('0x38')]=_[_0x1884('0x33')](_0x5c9f69[_0x1884('0x30')],_0x5c9f69[_0x1884('0x32')]);_0x519516[_0x1884('0x34')]=_[_0x1884('0x33')](_0x5c9f69[_0x1884('0x30')],qs[_0x1884('0x35')](_0x3cfc53[_0x1884('0x32')][_0x1884('0x35')]));_0x519516[_0x1884('0x34')]=_0x519516[_0x1884('0x34')][_0x1884('0x42')]?_0x519516[_0x1884('0x34')]:_0x5c9f69['model'];_0x519516['order']=qs['sort'](_0x3cfc53[_0x1884('0x32')][_0x1884('0x37')]);_0x519516[_0x1884('0x3a')]=qs[_0x1884('0x38')](_[_0x1884('0x4f')](_0x3cfc53[_0x1884('0x32')],_0x5c9f69[_0x1884('0x38')]));if(_0x3cfc53[_0x1884('0x32')][_0x1884('0x39')]){_0x519516[_0x1884('0x3a')]=_[_0x1884('0x3b')](_0x519516[_0x1884('0x3a')],{'$or':_[_0x1884('0x2c')](_0x519516[_0x1884('0x34')],function(_0x303ad9){var _0x364ebc={};_0x364ebc[_0x303ad9]={'$like':'%'+_0x3cfc53[_0x1884('0x32')][_0x1884('0x39')]+'%'};return _0x364ebc;})});}_0x519516=_[_0x1884('0x3b')]({},_0x519516,_0x3cfc53[_0x1884('0x3e')]);return _0x1ba6cc[_0x1884('0x4d')](_0x519516);}})['then'](function(_0x3bb2d2){if(_0x3bb2d2){_0x19ba40=_0x3bb2d2[_0x1884('0x42')];if(!_0x3cfc53['query'][_0x1884('0x36')](_0x1884('0x4c'))){_0x519516[_0x1884('0x1c')]=qs[_0x1884('0x1c')](_0x3cfc53['query'][_0x1884('0x1c')]);_0x519516['offset']=qs['offset'](_0x3cfc53[_0x1884('0x32')][_0x1884('0x1f')]);}return _0x1ba6cc[_0x1884('0x4d')](_0x519516);}})[_0x1884('0x25')](function(_0x227052){if(_0x227052){return _0x227052?{'count':_0x19ba40,'rows':_0x227052}:null;}})[_0x1884('0x25')](respondWithResult(_0x25a4df,null))[_0x1884('0x40')](handleError(_0x25a4df,null));};exports['getDescriptions']=function(_0x5a87ee,_0x262c6c,_0x18ec63){var _0x4435fc={};var _0x1634e4={};var _0x808170;var _0x54d9f6;return db[_0x1884('0x2d')]['findOne']({'where':{'id':_0x5a87ee[_0x1884('0x4e')]['id']}})['then'](handleEntityNotFound(_0x262c6c,null))[_0x1884('0x25')](function(_0x45166){if(_0x45166){_0x808170=_0x45166;_0x1634e4['model']=_[_0x1884('0x31')](db[_0x1884('0x4a')][_0x1884('0x2e')]);_0x1634e4[_0x1884('0x32')]=_[_0x1884('0x31')](_0x5a87ee[_0x1884('0x32')]);_0x1634e4[_0x1884('0x38')]=_[_0x1884('0x33')](_0x1634e4[_0x1884('0x30')],_0x1634e4[_0x1884('0x32')]);_0x4435fc[_0x1884('0x34')]=_[_0x1884('0x33')](_0x1634e4[_0x1884('0x30')],qs[_0x1884('0x35')](_0x5a87ee[_0x1884('0x32')][_0x1884('0x35')]));_0x4435fc[_0x1884('0x34')]=_0x4435fc[_0x1884('0x34')][_0x1884('0x42')]?_0x4435fc[_0x1884('0x34')]:_0x1634e4['model'];_0x4435fc[_0x1884('0x4b')]=qs[_0x1884('0x37')](_0x5a87ee['query']['sort']);_0x4435fc[_0x1884('0x3a')]=qs['filters'](_[_0x1884('0x4f')](_0x5a87ee[_0x1884('0x32')],_0x1634e4[_0x1884('0x38')]));if(_0x5a87ee[_0x1884('0x32')]['filter']){_0x4435fc[_0x1884('0x3a')]=_[_0x1884('0x3b')](_0x4435fc[_0x1884('0x3a')],{'$or':_['map'](_0x4435fc['attributes'],function(_0x21d236){var _0x4962d3={};_0x4962d3[_0x21d236]={'$like':'%'+_0x5a87ee['query'][_0x1884('0x39')]+'%'};return _0x4962d3;})});}_0x4435fc=_[_0x1884('0x3b')]({},_0x4435fc,_0x5a87ee[_0x1884('0x3e')]);return _0x808170[_0x1884('0x50')](_0x4435fc);}})[_0x1884('0x25')](function(_0x3eb9ae){if(_0x3eb9ae){_0x54d9f6=_0x3eb9ae[_0x1884('0x42')];if(!_0x5a87ee['query'][_0x1884('0x36')](_0x1884('0x4c'))){_0x4435fc[_0x1884('0x1c')]=qs[_0x1884('0x1c')](_0x5a87ee[_0x1884('0x32')][_0x1884('0x1c')]);_0x4435fc[_0x1884('0x1f')]=qs[_0x1884('0x1f')](_0x5a87ee[_0x1884('0x32')][_0x1884('0x1f')]);}return _0x808170[_0x1884('0x50')](_0x4435fc);}})['then'](function(_0x563da8){if(_0x563da8){return _0x563da8?{'count':_0x54d9f6,'rows':_0x563da8}:null;}})['then'](respondWithResult(_0x262c6c,null))[_0x1884('0x40')](handleError(_0x262c6c,null));};