[motion2.git] / server / api / intServicenowConfiguration / intServicenowConfiguration.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0x00e2=['rows','catch','params','keys','rawAttributes','include','find','create','body','getFields','findOne','ServicenowField','order','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','status','end','json','undefined','count','offset','limit','set','Content-Range','save','update','then','destroy','sendStatus','stack','name','send','index','map','ServicenowConfiguration','fieldName','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','pick','where','merge','type','VIRTUAL','filter','options','includeAll','findAll'];(function(_0x179b53,_0x31f6fe){var _0x38a146=function(_0x33f0c2){while(--_0x33f0c2){_0x179b53['push'](_0x179b53['shift']());}};_0x38a146(++_0x31f6fe);}(_0x00e2,0xb3));var _0x200e=function(_0x2302a1,_0x4bc33d){_0x2302a1=_0x2302a1-0x0;var _0x413cae=_0x00e2[_0x2302a1];return _0x413cae;};'use strict';var emlformat=require(_0x200e('0x0'));var rimraf=require(_0x200e('0x1'));var zipdir=require(_0x200e('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x200e('0x3'));var moment=require(_0x200e('0x4'));var BPromise=require(_0x200e('0x5'));var Mustache=require(_0x200e('0x6'));var util=require(_0x200e('0x7'));var path=require(_0x200e('0x8'));var sox=require(_0x200e('0x9'));var csv=require(_0x200e('0xa'));var ejs=require(_0x200e('0xb'));var fs=require('fs');var fs_extra=require(_0x200e('0xc'));var _=require(_0x200e('0xd'));var squel=require(_0x200e('0xe'));var crypto=require('crypto');var jsforce=require(_0x200e('0xf'));var deskjs=require(_0x200e('0x10'));var toCsv=require(_0x200e('0xa'));var querystring=require(_0x200e('0x11'));var Papa=require(_0x200e('0x12'));var Redis=require(_0x200e('0x13'));var authService=require(_0x200e('0x14'));var qs=require(_0x200e('0x15'));var as=require(_0x200e('0x16'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x200e('0x17'))(_0x200e('0x18'));var utils=require('../../config/utils');var config=require(_0x200e('0x19'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x37e00a,_0x330fe3){_0x330fe3=_0x330fe3||0xcc;return function(_0x3877a9){if(_0x3877a9){return _0x37e00a['sendStatus'](_0x330fe3);}return _0x37e00a[_0x200e('0x1a')](_0x330fe3)[_0x200e('0x1b')]();};}function respondWithResult(_0x600444,_0x1521d4){_0x1521d4=_0x1521d4||0xc8;return function(_0x50c3a9){if(_0x50c3a9){return _0x600444[_0x200e('0x1a')](_0x1521d4)[_0x200e('0x1c')](_0x50c3a9);}};}function respondWithFilteredResult(_0x33443e,_0x42ecc2){return function(_0x2b28fc){if(_0x2b28fc){var _0x1a059e=typeof _0x42ecc2['offset']===_0x200e('0x1d')&&typeof _0x42ecc2['limit']===_0x200e('0x1d');var _0x183741=_0x2b28fc[_0x200e('0x1e')];var _0x406566=_0x1a059e?0x0:_0x42ecc2[_0x200e('0x1f')];var _0x2c73fc=_0x1a059e?_0x2b28fc[_0x200e('0x1e')]:_0x42ecc2['offset']+_0x42ecc2[_0x200e('0x20')];var _0x268abf;if(_0x2c73fc>=_0x183741){_0x2c73fc=_0x183741;_0x268abf=0xc8;}else{_0x268abf=0xce;}_0x33443e['status'](_0x268abf);return _0x33443e[_0x200e('0x21')](_0x200e('0x22'),_0x406566+'-'+_0x2c73fc+'/'+_0x183741)[_0x200e('0x1c')](_0x2b28fc);}return null;};}function patchUpdates(_0x59519b){return function(_0x1a7f02){try{jsonpatch['apply'](_0x1a7f02,_0x59519b,!![]);}catch(_0x21ff79){return BPromise['reject'](_0x21ff79);}return _0x1a7f02[_0x200e('0x23')]();};}function saveUpdates(_0x438fe9,_0x3542d3){return function(_0x286246){if(_0x286246){return _0x286246[_0x200e('0x24')](_0x438fe9)[_0x200e('0x25')](function(_0x54d3f9){return _0x54d3f9;});}return null;};}function removeEntity(_0x551964,_0x13bc59){return function(_0x4769af){if(_0x4769af){return _0x4769af[_0x200e('0x26')]()['then'](function(){_0x551964[_0x200e('0x1a')](0xcc)['end']();});}};}function handleEntityNotFound(_0x5d0b68,_0xa6acb4){return function(_0x338cf5){if(!_0x338cf5){_0x5d0b68[_0x200e('0x27')](0x194);}return _0x338cf5;};}function handleError(_0x2c44c0,_0x549cb4){_0x549cb4=_0x549cb4||0x1f4;return function(_0xd7586c){logger['error'](_0xd7586c[_0x200e('0x28')]);if(_0xd7586c[_0x200e('0x29')]){delete _0xd7586c['name'];}_0x2c44c0[_0x200e('0x1a')](_0x549cb4)[_0x200e('0x2a')](_0xd7586c);};}exports[_0x200e('0x2b')]=function(_0x2dfc59,_0x175a86){var _0x463f7c={},_0x1d50e3={},_0xb83811={'count':0x0,'rows':[]};var _0x1b1626=_[_0x200e('0x2c')](db[_0x200e('0x2d')]['rawAttributes'],function(_0xc42510){return{'name':_0xc42510[_0x200e('0x2e')],'type':_0xc42510['type'][_0x200e('0x2f')]};});_0x1d50e3[_0x200e('0x30')]=_['map'](_0x1b1626,_0x200e('0x29'));_0x1d50e3[_0x200e('0x31')]=_['keys'](_0x2dfc59[_0x200e('0x31')]);_0x1d50e3[_0x200e('0x32')]=_[_0x200e('0x33')](_0x1d50e3[_0x200e('0x30')],_0x1d50e3[_0x200e('0x31')]);_0x463f7c[_0x200e('0x34')]=_[_0x200e('0x33')](_0x1d50e3[_0x200e('0x30')],qs[_0x200e('0x35')](_0x2dfc59[_0x200e('0x31')][_0x200e('0x35')]));_0x463f7c[_0x200e('0x34')]=_0x463f7c[_0x200e('0x34')][_0x200e('0x36')]?_0x463f7c[_0x200e('0x34')]:_0x1d50e3[_0x200e('0x30')];if(!_0x2dfc59[_0x200e('0x31')][_0x200e('0x37')](_0x200e('0x38'))){_0x463f7c['limit']=qs[_0x200e('0x20')](_0x2dfc59[_0x200e('0x31')][_0x200e('0x20')]);_0x463f7c['offset']=qs[_0x200e('0x1f')](_0x2dfc59[_0x200e('0x31')]['offset']);}_0x463f7c['order']=qs['sort'](_0x2dfc59['query'][_0x200e('0x39')]);_0x463f7c['where']=qs[_0x200e('0x32')](_[_0x200e('0x3a')](_0x2dfc59['query'],_0x1d50e3[_0x200e('0x32')]),_0x1b1626);if(_0x2dfc59[_0x200e('0x31')]['filter']){_0x463f7c[_0x200e('0x3b')]=_[_0x200e('0x3c')](_0x463f7c['where'],{'$or':_[_0x200e('0x2c')](_0x1b1626,function(_0x1ba274){if(_0x1ba274[_0x200e('0x3d')]!==_0x200e('0x3e')){var _0x3af174={};_0x3af174[_0x1ba274[_0x200e('0x29')]]={'$like':'%'+_0x2dfc59[_0x200e('0x31')][_0x200e('0x3f')]+'%'};return _0x3af174;}})});}_0x463f7c=_[_0x200e('0x3c')]({},_0x463f7c,_0x2dfc59[_0x200e('0x40')]);var _0xb868c6={'where':_0x463f7c[_0x200e('0x3b')]};return db['ServicenowConfiguration']['count'](_0xb868c6)[_0x200e('0x25')](function(_0xd34af3){_0xb83811['count']=_0xd34af3;if(_0x2dfc59[_0x200e('0x31')][_0x200e('0x41')]){_0x463f7c['include']=[{'all':!![]}];}return db['ServicenowConfiguration'][_0x200e('0x42')](_0x463f7c);})[_0x200e('0x25')](function(_0x1d5b80){_0xb83811[_0x200e('0x43')]=_0x1d5b80;return _0xb83811;})[_0x200e('0x25')](respondWithFilteredResult(_0x175a86,_0x463f7c))[_0x200e('0x44')](handleError(_0x175a86,null));};exports['show']=function(_0x2cc3e0,_0x1f23b0){var _0xb015b3={'raw':![],'where':{'id':_0x2cc3e0[_0x200e('0x45')]['id']}},_0x3b68c4={};_0x3b68c4[_0x200e('0x30')]=_[_0x200e('0x46')](db[_0x200e('0x2d')][_0x200e('0x47')]);_0x3b68c4[_0x200e('0x31')]=_[_0x200e('0x46')](_0x2cc3e0[_0x200e('0x31')]);_0x3b68c4[_0x200e('0x32')]=_[_0x200e('0x33')](_0x3b68c4[_0x200e('0x30')],_0x3b68c4[_0x200e('0x31')]);_0xb015b3[_0x200e('0x34')]=_[_0x200e('0x33')](_0x3b68c4[_0x200e('0x30')],qs[_0x200e('0x35')](_0x2cc3e0[_0x200e('0x31')]['fields']));_0xb015b3[_0x200e('0x34')]=_0xb015b3[_0x200e('0x34')][_0x200e('0x36')]?_0xb015b3[_0x200e('0x34')]:_0x3b68c4[_0x200e('0x30')];if(_0x2cc3e0['query'][_0x200e('0x41')]){_0xb015b3[_0x200e('0x48')]=[{'all':!![]}];}_0xb015b3=_[_0x200e('0x3c')]({},_0xb015b3,_0x2cc3e0['options']);return db[_0x200e('0x2d')][_0x200e('0x49')](_0xb015b3)['then'](handleEntityNotFound(_0x1f23b0,null))[_0x200e('0x25')](respondWithResult(_0x1f23b0,null))[_0x200e('0x44')](handleError(_0x1f23b0,null));};exports[_0x200e('0x4a')]=function(_0x320604,_0x2a11d8){return db[_0x200e('0x2d')][_0x200e('0x4a')](_0x320604['body'],{})[_0x200e('0x25')](respondWithResult(_0x2a11d8,0xc9))[_0x200e('0x44')](handleError(_0x2a11d8,null));};exports[_0x200e('0x24')]=function(_0x5554a2,_0x173af9){if(_0x5554a2[_0x200e('0x4b')]['id']){delete _0x5554a2[_0x200e('0x4b')]['id'];}return db[_0x200e('0x2d')][_0x200e('0x49')]({'where':{'id':_0x5554a2[_0x200e('0x45')]['id']}})[_0x200e('0x25')](handleEntityNotFound(_0x173af9,null))[_0x200e('0x25')](saveUpdates(_0x5554a2[_0x200e('0x4b')],null))[_0x200e('0x25')](respondWithResult(_0x173af9,null))[_0x200e('0x44')](handleError(_0x173af9,null));};exports[_0x200e('0x26')]=function(_0x5e6ec3,_0x4ede58){return db['ServicenowConfiguration'][_0x200e('0x49')]({'where':{'id':_0x5e6ec3[_0x200e('0x45')]['id']}})[_0x200e('0x25')](handleEntityNotFound(_0x4ede58,null))['then'](removeEntity(_0x4ede58,null))[_0x200e('0x44')](handleError(_0x4ede58,null));};exports[_0x200e('0x4c')]=function(_0x578920,_0x280164,_0x322415){var _0x500f43={};var _0x44159f={};var _0x135f4b;var _0x4c74ba;return db[_0x200e('0x2d')][_0x200e('0x4d')]({'where':{'id':_0x578920[_0x200e('0x45')]['id']}})[_0x200e('0x25')](handleEntityNotFound(_0x280164,null))[_0x200e('0x25')](function(_0x399f94){if(_0x399f94){_0x135f4b=_0x399f94;_0x44159f[_0x200e('0x30')]=_[_0x200e('0x46')](db[_0x200e('0x4e')][_0x200e('0x47')]);_0x44159f[_0x200e('0x31')]=_[_0x200e('0x46')](_0x578920[_0x200e('0x31')]);_0x44159f[_0x200e('0x32')]=_[_0x200e('0x33')](_0x44159f[_0x200e('0x30')],_0x44159f['query']);_0x500f43[_0x200e('0x34')]=_['intersection'](_0x44159f[_0x200e('0x30')],qs['fields'](_0x578920['query']['fields']));_0x500f43[_0x200e('0x34')]=_0x500f43[_0x200e('0x34')][_0x200e('0x36')]?_0x500f43[_0x200e('0x34')]:_0x44159f[_0x200e('0x30')];_0x500f43[_0x200e('0x4f')]=qs[_0x200e('0x39')](_0x578920[_0x200e('0x31')][_0x200e('0x39')]);_0x500f43[_0x200e('0x3b')]=qs[_0x200e('0x32')](_[_0x200e('0x3a')](_0x578920['query'],_0x44159f[_0x200e('0x32')]));if(_0x578920[_0x200e('0x31')][_0x200e('0x3f')]){_0x500f43[_0x200e('0x3b')]=_['merge'](_0x500f43[_0x200e('0x3b')],{'$or':_[_0x200e('0x2c')](_0x500f43['attributes'],function(_0x5f0e3a){var _0x3bdd00={};_0x3bdd00[_0x5f0e3a]={'$like':'%'+_0x578920[_0x200e('0x31')][_0x200e('0x3f')]+'%'};return _0x3bdd00;})});}_0x500f43=_[_0x200e('0x3c')]({},_0x500f43,_0x578920['options']);return _0x135f4b[_0x200e('0x4c')](_0x500f43);}})['then'](function(_0x37ce51){if(_0x37ce51){_0x4c74ba=_0x37ce51[_0x200e('0x36')];if(!_0x578920[_0x200e('0x31')][_0x200e('0x37')](_0x200e('0x38'))){_0x500f43['limit']=qs[_0x200e('0x20')](_0x578920['query']['limit']);_0x500f43[_0x200e('0x1f')]=qs['offset'](_0x578920[_0x200e('0x31')][_0x200e('0x1f')]);}return _0x135f4b['getFields'](_0x500f43);}})[_0x200e('0x25')](function(_0x4e9ba6){if(_0x4e9ba6){return _0x4e9ba6?{'count':_0x4c74ba,'rows':_0x4e9ba6}:null;}})[_0x200e('0x25')](respondWithResult(_0x280164,null))[_0x200e('0x44')](handleError(_0x280164,null));};exports['getSubjects']=function(_0x103ea5,_0x26c3c4,_0x1a220b){var _0x1d3e7b={};var _0x4ef1fd={};var _0x4e55ce;var _0x2d07b8;return db[_0x200e('0x2d')][_0x200e('0x4d')]({'where':{'id':_0x103ea5['params']['id']}})[_0x200e('0x25')](handleEntityNotFound(_0x26c3c4,null))[_0x200e('0x25')](function(_0x2c72de){if(_0x2c72de){_0x4e55ce=_0x2c72de;_0x4ef1fd['model']=_['keys'](db[_0x200e('0x4e')][_0x200e('0x47')]);_0x4ef1fd[_0x200e('0x31')]=_['keys'](_0x103ea5[_0x200e('0x31')]);_0x4ef1fd['filters']=_['intersection'](_0x4ef1fd[_0x200e('0x30')],_0x4ef1fd[_0x200e('0x31')]);_0x1d3e7b[_0x200e('0x34')]=_[_0x200e('0x33')](_0x4ef1fd['model'],qs['fields'](_0x103ea5[_0x200e('0x31')][_0x200e('0x35')]));_0x1d3e7b[_0x200e('0x34')]=_0x1d3e7b[_0x200e('0x34')][_0x200e('0x36')]?_0x1d3e7b['attributes']:_0x4ef1fd[_0x200e('0x30')];_0x1d3e7b['order']=qs[_0x200e('0x39')](_0x103ea5['query'][_0x200e('0x39')]);_0x1d3e7b[_0x200e('0x3b')]=qs[_0x200e('0x32')](_[_0x200e('0x3a')](_0x103ea5[_0x200e('0x31')],_0x4ef1fd[_0x200e('0x32')]));if(_0x103ea5[_0x200e('0x31')]['filter']){_0x1d3e7b['where']=_['merge'](_0x1d3e7b['where'],{'$or':_['map'](_0x1d3e7b['attributes'],function(_0x4d989d){var _0x471114={};_0x471114[_0x4d989d]={'$like':'%'+_0x103ea5[_0x200e('0x31')][_0x200e('0x3f')]+'%'};return _0x471114;})});}_0x1d3e7b=_[_0x200e('0x3c')]({},_0x1d3e7b,_0x103ea5['options']);return _0x4e55ce[_0x200e('0x50')](_0x1d3e7b);}})[_0x200e('0x25')](function(_0x27f737){if(_0x27f737){_0x2d07b8=_0x27f737[_0x200e('0x36')];if(!_0x103ea5[_0x200e('0x31')][_0x200e('0x37')](_0x200e('0x38'))){_0x1d3e7b[_0x200e('0x20')]=qs[_0x200e('0x20')](_0x103ea5['query']['limit']);_0x1d3e7b[_0x200e('0x1f')]=qs[_0x200e('0x1f')](_0x103ea5[_0x200e('0x31')][_0x200e('0x1f')]);}return _0x4e55ce[_0x200e('0x50')](_0x1d3e7b);}})['then'](function(_0x5affde){if(_0x5affde){return _0x5affde?{'count':_0x2d07b8,'rows':_0x5affde}:null;}})['then'](respondWithResult(_0x26c3c4,null))[_0x200e('0x44')](handleError(_0x26c3c4,null));};exports[_0x200e('0x51')]=function(_0x5ca35b,_0x1cf962,_0xce766d){var _0x3a48eb={};var _0xb378db={};var _0x4c34ca;var _0x940535;return db[_0x200e('0x2d')][_0x200e('0x4d')]({'where':{'id':_0x5ca35b[_0x200e('0x45')]['id']}})['then'](handleEntityNotFound(_0x1cf962,null))[_0x200e('0x25')](function(_0x4a0496){if(_0x4a0496){_0x4c34ca=_0x4a0496;_0xb378db[_0x200e('0x30')]=_[_0x200e('0x46')](db[_0x200e('0x4e')][_0x200e('0x47')]);_0xb378db['query']=_[_0x200e('0x46')](_0x5ca35b[_0x200e('0x31')]);_0xb378db[_0x200e('0x32')]=_[_0x200e('0x33')](_0xb378db[_0x200e('0x30')],_0xb378db['query']);_0x3a48eb[_0x200e('0x34')]=_[_0x200e('0x33')](_0xb378db[_0x200e('0x30')],qs['fields'](_0x5ca35b[_0x200e('0x31')]['fields']));_0x3a48eb[_0x200e('0x34')]=_0x3a48eb['attributes'][_0x200e('0x36')]?_0x3a48eb[_0x200e('0x34')]:_0xb378db[_0x200e('0x30')];_0x3a48eb[_0x200e('0x4f')]=qs[_0x200e('0x39')](_0x5ca35b[_0x200e('0x31')][_0x200e('0x39')]);_0x3a48eb[_0x200e('0x3b')]=qs[_0x200e('0x32')](_['pick'](_0x5ca35b[_0x200e('0x31')],_0xb378db[_0x200e('0x32')]));if(_0x5ca35b[_0x200e('0x31')][_0x200e('0x3f')]){_0x3a48eb[_0x200e('0x3b')]=_[_0x200e('0x3c')](_0x3a48eb[_0x200e('0x3b')],{'$or':_[_0x200e('0x2c')](_0x3a48eb['attributes'],function(_0x3fb864){var _0x4bf386={};_0x4bf386[_0x3fb864]={'$like':'%'+_0x5ca35b[_0x200e('0x31')][_0x200e('0x3f')]+'%'};return _0x4bf386;})});}_0x3a48eb=_['merge']({},_0x3a48eb,_0x5ca35b[_0x200e('0x40')]);return _0x4c34ca[_0x200e('0x51')](_0x3a48eb);}})[_0x200e('0x25')](function(_0x6730c8){if(_0x6730c8){_0x940535=_0x6730c8[_0x200e('0x36')];if(!_0x5ca35b[_0x200e('0x31')][_0x200e('0x37')]('nolimit')){_0x3a48eb[_0x200e('0x20')]=qs['limit'](_0x5ca35b[_0x200e('0x31')]['limit']);_0x3a48eb['offset']=qs[_0x200e('0x1f')](_0x5ca35b['query'][_0x200e('0x1f')]);}return _0x4c34ca[_0x200e('0x51')](_0x3a48eb);}})[_0x200e('0x25')](function(_0x2dc298){if(_0x2dc298){return _0x2dc298?{'count':_0x940535,'rows':_0x2dc298}:null;}})[_0x200e('0x25')](respondWithResult(_0x1cf962,null))[_0x200e('0x44')](handleError(_0x1cf962,null));};