[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 _0xbced=['rawAttributes','fieldName','key','model','map','name','keys','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','type','VIRTUAL','options','then','includeAll','include','rows','catch','show','params','ServicenowConfiguration','find','body','getFields','findOne','ServicenowField','length','getSubjects','getDescriptions','eml-format','rimraf','bluebird','path','to-csv','ejs','fs-extra','lodash','crypto','desk.js','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','undefined','limit','count','offset','set','Content-Range','apply','save','update','index'];(function(_0x3c2b91,_0x5dd910){var _0x519192=function(_0x1a5f9a){while(--_0x1a5f9a){_0x3c2b91['push'](_0x3c2b91['shift']());}};_0x519192(++_0x5dd910);}(_0xbced,0x185));var _0xdbce=function(_0x5c5d9b,_0x2fbfb1){_0x5c5d9b=_0x5c5d9b-0x0;var _0x40ca79=_0xbced[_0x5c5d9b];return _0x40ca79;};'use strict';var emlformat=require(_0xdbce('0x0'));var rimraf=require(_0xdbce('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0xdbce('0x2'));var Mustache=require('mustache');var util=require('util');var path=require(_0xdbce('0x3'));var sox=require('sox');var csv=require(_0xdbce('0x4'));var ejs=require(_0xdbce('0x5'));var fs=require('fs');var fs_extra=require(_0xdbce('0x6'));var _=require(_0xdbce('0x7'));var squel=require('squel');var crypto=require(_0xdbce('0x8'));var jsforce=require('jsforce');var deskjs=require(_0xdbce('0x9'));var toCsv=require(_0xdbce('0x4'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0xdbce('0xa'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xdbce('0xb'));var logger=require(_0xdbce('0xc'))('api');var utils=require(_0xdbce('0xd'));var config=require(_0xdbce('0xe'));var licenseUtil=require(_0xdbce('0xf'));var db=require(_0xdbce('0x10'))['db'];function respondWithStatusCode(_0x192370,_0x25a895){_0x25a895=_0x25a895||0xcc;return function(_0x5cdce0){if(_0x5cdce0){return _0x192370[_0xdbce('0x11')](_0x25a895);}return _0x192370[_0xdbce('0x12')](_0x25a895)[_0xdbce('0x13')]();};}function respondWithResult(_0x2dbb42,_0x293fe8){_0x293fe8=_0x293fe8||0xc8;return function(_0x46342b){if(_0x46342b){return _0x2dbb42['status'](_0x293fe8)[_0xdbce('0x14')](_0x46342b);}};}function respondWithFilteredResult(_0x1bf427,_0x2ca6f0){return function(_0x56a716){if(_0x56a716){var _0x1302ca=typeof _0x2ca6f0['offset']===_0xdbce('0x15')&&typeof _0x2ca6f0[_0xdbce('0x16')]===_0xdbce('0x15');var _0x2eb063=_0x56a716[_0xdbce('0x17')];var _0x913359=_0x1302ca?0x0:_0x2ca6f0[_0xdbce('0x18')];var _0x26f44b=_0x1302ca?_0x56a716[_0xdbce('0x17')]:_0x2ca6f0[_0xdbce('0x18')]+_0x2ca6f0[_0xdbce('0x16')];var _0x5cee36;if(_0x26f44b>=_0x2eb063){_0x26f44b=_0x2eb063;_0x5cee36=0xc8;}else{_0x5cee36=0xce;}_0x1bf427['status'](_0x5cee36);return _0x1bf427[_0xdbce('0x19')](_0xdbce('0x1a'),_0x913359+'-'+_0x26f44b+'/'+_0x2eb063)[_0xdbce('0x14')](_0x56a716);}return null;};}function patchUpdates(_0x3361ea){return function(_0x4da8e4){try{jsonpatch[_0xdbce('0x1b')](_0x4da8e4,_0x3361ea,!![]);}catch(_0x56c3d7){return BPromise['reject'](_0x56c3d7);}return _0x4da8e4[_0xdbce('0x1c')]();};}function saveUpdates(_0x26d4e5,_0x2349fb){return function(_0x1b2bc5){if(_0x1b2bc5){return _0x1b2bc5[_0xdbce('0x1d')](_0x26d4e5)['then'](function(_0x151b84){return _0x151b84;});}return null;};}function removeEntity(_0x5ace02,_0x309fd4){return function(_0x2a69d8){if(_0x2a69d8){return _0x2a69d8['destroy']()['then'](function(){_0x5ace02['status'](0xcc)[_0xdbce('0x13')]();});}};}function handleEntityNotFound(_0x5bc57e,_0x24564a){return function(_0x348e99){if(!_0x348e99){_0x5bc57e[_0xdbce('0x11')](0x194);}return _0x348e99;};}function handleError(_0x464413,_0x33fcfe){_0x33fcfe=_0x33fcfe||0x1f4;return function(_0x39f864){logger['error'](_0x39f864['stack']);if(_0x39f864['name']){delete _0x39f864['name'];}_0x464413[_0xdbce('0x12')](_0x33fcfe)['send'](_0x39f864);};}exports[_0xdbce('0x1e')]=function(_0x40c3fb,_0x30a766){var _0xcc6bef={},_0x27ce51={},_0x5b83e8={'count':0x0,'rows':[]};var _0x4ce881=_['map'](db['ServicenowConfiguration'][_0xdbce('0x1f')],function(_0x407e75){return{'name':_0x407e75[_0xdbce('0x20')],'type':_0x407e75['type'][_0xdbce('0x21')]};});_0x27ce51[_0xdbce('0x22')]=_[_0xdbce('0x23')](_0x4ce881,_0xdbce('0x24'));_0x27ce51['query']=_[_0xdbce('0x25')](_0x40c3fb[_0xdbce('0x26')]);_0x27ce51[_0xdbce('0x27')]=_[_0xdbce('0x28')](_0x27ce51[_0xdbce('0x22')],_0x27ce51[_0xdbce('0x26')]);_0xcc6bef[_0xdbce('0x29')]=_[_0xdbce('0x28')](_0x27ce51[_0xdbce('0x22')],qs[_0xdbce('0x2a')](_0x40c3fb[_0xdbce('0x26')][_0xdbce('0x2a')]));_0xcc6bef[_0xdbce('0x29')]=_0xcc6bef[_0xdbce('0x29')]['length']?_0xcc6bef[_0xdbce('0x29')]:_0x27ce51[_0xdbce('0x22')];if(!_0x40c3fb['query'][_0xdbce('0x2b')](_0xdbce('0x2c'))){_0xcc6bef[_0xdbce('0x16')]=qs[_0xdbce('0x16')](_0x40c3fb[_0xdbce('0x26')]['limit']);_0xcc6bef[_0xdbce('0x18')]=qs[_0xdbce('0x18')](_0x40c3fb[_0xdbce('0x26')]['offset']);}_0xcc6bef[_0xdbce('0x2d')]=qs[_0xdbce('0x2e')](_0x40c3fb[_0xdbce('0x26')]['sort']);_0xcc6bef[_0xdbce('0x2f')]=qs[_0xdbce('0x27')](_[_0xdbce('0x30')](_0x40c3fb['query'],_0x27ce51[_0xdbce('0x27')]),_0x4ce881);if(_0x40c3fb[_0xdbce('0x26')][_0xdbce('0x31')]){_0xcc6bef[_0xdbce('0x2f')]=_[_0xdbce('0x32')](_0xcc6bef['where'],{'$or':_[_0xdbce('0x23')](_0x4ce881,function(_0x3dad68){if(_0x3dad68[_0xdbce('0x33')]!==_0xdbce('0x34')){var _0x3998f5={};_0x3998f5[_0x3dad68[_0xdbce('0x24')]]={'$like':'%'+_0x40c3fb[_0xdbce('0x26')][_0xdbce('0x31')]+'%'};return _0x3998f5;}})});}_0xcc6bef=_[_0xdbce('0x32')]({},_0xcc6bef,_0x40c3fb[_0xdbce('0x35')]);var _0x229db6={'where':_0xcc6bef[_0xdbce('0x2f')]};return db['ServicenowConfiguration'][_0xdbce('0x17')](_0x229db6)[_0xdbce('0x36')](function(_0x7b478b){_0x5b83e8['count']=_0x7b478b;if(_0x40c3fb[_0xdbce('0x26')][_0xdbce('0x37')]){_0xcc6bef[_0xdbce('0x38')]=[{'all':!![]}];}return db['ServicenowConfiguration']['findAll'](_0xcc6bef);})[_0xdbce('0x36')](function(_0x4d7fca){_0x5b83e8[_0xdbce('0x39')]=_0x4d7fca;return _0x5b83e8;})[_0xdbce('0x36')](respondWithFilteredResult(_0x30a766,_0xcc6bef))[_0xdbce('0x3a')](handleError(_0x30a766,null));};exports[_0xdbce('0x3b')]=function(_0x2aef7b,_0x4a76f8){var _0x3ba60d={'raw':![],'where':{'id':_0x2aef7b[_0xdbce('0x3c')]['id']}},_0x568303={};_0x568303[_0xdbce('0x22')]=_[_0xdbce('0x25')](db['ServicenowConfiguration'][_0xdbce('0x1f')]);_0x568303[_0xdbce('0x26')]=_[_0xdbce('0x25')](_0x2aef7b[_0xdbce('0x26')]);_0x568303[_0xdbce('0x27')]=_[_0xdbce('0x28')](_0x568303[_0xdbce('0x22')],_0x568303[_0xdbce('0x26')]);_0x3ba60d[_0xdbce('0x29')]=_[_0xdbce('0x28')](_0x568303[_0xdbce('0x22')],qs[_0xdbce('0x2a')](_0x2aef7b[_0xdbce('0x26')]['fields']));_0x3ba60d[_0xdbce('0x29')]=_0x3ba60d[_0xdbce('0x29')]['length']?_0x3ba60d['attributes']:_0x568303[_0xdbce('0x22')];if(_0x2aef7b[_0xdbce('0x26')][_0xdbce('0x37')]){_0x3ba60d['include']=[{'all':!![]}];}_0x3ba60d=_[_0xdbce('0x32')]({},_0x3ba60d,_0x2aef7b[_0xdbce('0x35')]);return db[_0xdbce('0x3d')][_0xdbce('0x3e')](_0x3ba60d)[_0xdbce('0x36')](handleEntityNotFound(_0x4a76f8,null))['then'](respondWithResult(_0x4a76f8,null))[_0xdbce('0x3a')](handleError(_0x4a76f8,null));};exports['create']=function(_0x2f0d40,_0x170049){return db[_0xdbce('0x3d')]['create'](_0x2f0d40[_0xdbce('0x3f')],{})[_0xdbce('0x36')](respondWithResult(_0x170049,0xc9))['catch'](handleError(_0x170049,null));};exports['update']=function(_0x25abaa,_0x1019ec){if(_0x25abaa[_0xdbce('0x3f')]['id']){delete _0x25abaa[_0xdbce('0x3f')]['id'];}return db['ServicenowConfiguration']['find']({'where':{'id':_0x25abaa['params']['id']}})[_0xdbce('0x36')](handleEntityNotFound(_0x1019ec,null))[_0xdbce('0x36')](saveUpdates(_0x25abaa[_0xdbce('0x3f')],null))[_0xdbce('0x36')](respondWithResult(_0x1019ec,null))[_0xdbce('0x3a')](handleError(_0x1019ec,null));};exports['destroy']=function(_0x3a3eb3,_0x3213be){return db[_0xdbce('0x3d')][_0xdbce('0x3e')]({'where':{'id':_0x3a3eb3['params']['id']}})['then'](handleEntityNotFound(_0x3213be,null))[_0xdbce('0x36')](removeEntity(_0x3213be,null))[_0xdbce('0x3a')](handleError(_0x3213be,null));};exports[_0xdbce('0x40')]=function(_0x407ab7,_0x57f1d0,_0x395243){var _0x316d3a={};var _0xf89ce={};var _0x3462fd;var _0x2f66c9;return db[_0xdbce('0x3d')][_0xdbce('0x41')]({'where':{'id':_0x407ab7['params']['id']}})[_0xdbce('0x36')](handleEntityNotFound(_0x57f1d0,null))[_0xdbce('0x36')](function(_0x26d2ca){if(_0x26d2ca){_0x3462fd=_0x26d2ca;_0xf89ce[_0xdbce('0x22')]=_[_0xdbce('0x25')](db[_0xdbce('0x42')]['rawAttributes']);_0xf89ce[_0xdbce('0x26')]=_[_0xdbce('0x25')](_0x407ab7[_0xdbce('0x26')]);_0xf89ce[_0xdbce('0x27')]=_['intersection'](_0xf89ce[_0xdbce('0x22')],_0xf89ce[_0xdbce('0x26')]);_0x316d3a[_0xdbce('0x29')]=_['intersection'](_0xf89ce[_0xdbce('0x22')],qs[_0xdbce('0x2a')](_0x407ab7[_0xdbce('0x26')][_0xdbce('0x2a')]));_0x316d3a[_0xdbce('0x29')]=_0x316d3a[_0xdbce('0x29')][_0xdbce('0x43')]?_0x316d3a[_0xdbce('0x29')]:_0xf89ce[_0xdbce('0x22')];_0x316d3a['order']=qs[_0xdbce('0x2e')](_0x407ab7['query'][_0xdbce('0x2e')]);_0x316d3a[_0xdbce('0x2f')]=qs[_0xdbce('0x27')](_[_0xdbce('0x30')](_0x407ab7[_0xdbce('0x26')],_0xf89ce['filters']));if(_0x407ab7['query']['filter']){_0x316d3a[_0xdbce('0x2f')]=_[_0xdbce('0x32')](_0x316d3a['where'],{'$or':_['map'](_0x316d3a[_0xdbce('0x29')],function(_0x1a8953){var _0x46420f={};_0x46420f[_0x1a8953]={'$like':'%'+_0x407ab7[_0xdbce('0x26')][_0xdbce('0x31')]+'%'};return _0x46420f;})});}_0x316d3a=_[_0xdbce('0x32')]({},_0x316d3a,_0x407ab7[_0xdbce('0x35')]);return _0x3462fd['getFields'](_0x316d3a);}})[_0xdbce('0x36')](function(_0x475843){if(_0x475843){_0x2f66c9=_0x475843[_0xdbce('0x43')];if(!_0x407ab7['query']['hasOwnProperty'](_0xdbce('0x2c'))){_0x316d3a['limit']=qs['limit'](_0x407ab7[_0xdbce('0x26')]['limit']);_0x316d3a[_0xdbce('0x18')]=qs[_0xdbce('0x18')](_0x407ab7[_0xdbce('0x26')]['offset']);}return _0x3462fd[_0xdbce('0x40')](_0x316d3a);}})['then'](function(_0x134614){if(_0x134614){return _0x134614?{'count':_0x2f66c9,'rows':_0x134614}:null;}})[_0xdbce('0x36')](respondWithResult(_0x57f1d0,null))[_0xdbce('0x3a')](handleError(_0x57f1d0,null));};exports[_0xdbce('0x44')]=function(_0x59d467,_0x565ef3,_0x2d22ac){var _0x5b6ed2={};var _0xd5edac={};var _0x1e041a;var _0x5bfd07;return db[_0xdbce('0x3d')]['findOne']({'where':{'id':_0x59d467[_0xdbce('0x3c')]['id']}})['then'](handleEntityNotFound(_0x565ef3,null))[_0xdbce('0x36')](function(_0x18a79a){if(_0x18a79a){_0x1e041a=_0x18a79a;_0xd5edac[_0xdbce('0x22')]=_[_0xdbce('0x25')](db[_0xdbce('0x42')][_0xdbce('0x1f')]);_0xd5edac['query']=_['keys'](_0x59d467[_0xdbce('0x26')]);_0xd5edac[_0xdbce('0x27')]=_[_0xdbce('0x28')](_0xd5edac[_0xdbce('0x22')],_0xd5edac[_0xdbce('0x26')]);_0x5b6ed2[_0xdbce('0x29')]=_[_0xdbce('0x28')](_0xd5edac[_0xdbce('0x22')],qs['fields'](_0x59d467['query']['fields']));_0x5b6ed2[_0xdbce('0x29')]=_0x5b6ed2[_0xdbce('0x29')][_0xdbce('0x43')]?_0x5b6ed2[_0xdbce('0x29')]:_0xd5edac['model'];_0x5b6ed2[_0xdbce('0x2d')]=qs[_0xdbce('0x2e')](_0x59d467[_0xdbce('0x26')][_0xdbce('0x2e')]);_0x5b6ed2[_0xdbce('0x2f')]=qs[_0xdbce('0x27')](_[_0xdbce('0x30')](_0x59d467[_0xdbce('0x26')],_0xd5edac[_0xdbce('0x27')]));if(_0x59d467[_0xdbce('0x26')][_0xdbce('0x31')]){_0x5b6ed2['where']=_[_0xdbce('0x32')](_0x5b6ed2[_0xdbce('0x2f')],{'$or':_['map'](_0x5b6ed2[_0xdbce('0x29')],function(_0x1fa1ba){var _0x19d7a7={};_0x19d7a7[_0x1fa1ba]={'$like':'%'+_0x59d467['query'][_0xdbce('0x31')]+'%'};return _0x19d7a7;})});}_0x5b6ed2=_['merge']({},_0x5b6ed2,_0x59d467[_0xdbce('0x35')]);return _0x1e041a[_0xdbce('0x44')](_0x5b6ed2);}})[_0xdbce('0x36')](function(_0x2887ec){if(_0x2887ec){_0x5bfd07=_0x2887ec[_0xdbce('0x43')];if(!_0x59d467['query'][_0xdbce('0x2b')](_0xdbce('0x2c'))){_0x5b6ed2[_0xdbce('0x16')]=qs['limit'](_0x59d467[_0xdbce('0x26')]['limit']);_0x5b6ed2[_0xdbce('0x18')]=qs[_0xdbce('0x18')](_0x59d467[_0xdbce('0x26')][_0xdbce('0x18')]);}return _0x1e041a['getSubjects'](_0x5b6ed2);}})[_0xdbce('0x36')](function(_0xcb7e39){if(_0xcb7e39){return _0xcb7e39?{'count':_0x5bfd07,'rows':_0xcb7e39}:null;}})[_0xdbce('0x36')](respondWithResult(_0x565ef3,null))['catch'](handleError(_0x565ef3,null));};exports['getDescriptions']=function(_0x30b48e,_0x469d21,_0x176a30){var _0x54c768={};var _0x343a52={};var _0x5f09af;var _0x24ce94;return db['ServicenowConfiguration'][_0xdbce('0x41')]({'where':{'id':_0x30b48e['params']['id']}})[_0xdbce('0x36')](handleEntityNotFound(_0x469d21,null))[_0xdbce('0x36')](function(_0x2e5d1f){if(_0x2e5d1f){_0x5f09af=_0x2e5d1f;_0x343a52[_0xdbce('0x22')]=_[_0xdbce('0x25')](db['ServicenowField'][_0xdbce('0x1f')]);_0x343a52[_0xdbce('0x26')]=_[_0xdbce('0x25')](_0x30b48e[_0xdbce('0x26')]);_0x343a52['filters']=_[_0xdbce('0x28')](_0x343a52[_0xdbce('0x22')],_0x343a52[_0xdbce('0x26')]);_0x54c768['attributes']=_[_0xdbce('0x28')](_0x343a52['model'],qs['fields'](_0x30b48e[_0xdbce('0x26')][_0xdbce('0x2a')]));_0x54c768[_0xdbce('0x29')]=_0x54c768[_0xdbce('0x29')][_0xdbce('0x43')]?_0x54c768['attributes']:_0x343a52['model'];_0x54c768[_0xdbce('0x2d')]=qs['sort'](_0x30b48e['query'][_0xdbce('0x2e')]);_0x54c768[_0xdbce('0x2f')]=qs['filters'](_[_0xdbce('0x30')](_0x30b48e['query'],_0x343a52['filters']));if(_0x30b48e[_0xdbce('0x26')][_0xdbce('0x31')]){_0x54c768['where']=_[_0xdbce('0x32')](_0x54c768[_0xdbce('0x2f')],{'$or':_[_0xdbce('0x23')](_0x54c768[_0xdbce('0x29')],function(_0x4a5c3e){var _0x57ab5b={};_0x57ab5b[_0x4a5c3e]={'$like':'%'+_0x30b48e[_0xdbce('0x26')]['filter']+'%'};return _0x57ab5b;})});}_0x54c768=_[_0xdbce('0x32')]({},_0x54c768,_0x30b48e['options']);return _0x5f09af[_0xdbce('0x45')](_0x54c768);}})[_0xdbce('0x36')](function(_0x417536){if(_0x417536){_0x24ce94=_0x417536['length'];if(!_0x30b48e[_0xdbce('0x26')]['hasOwnProperty'](_0xdbce('0x2c'))){_0x54c768[_0xdbce('0x16')]=qs['limit'](_0x30b48e[_0xdbce('0x26')][_0xdbce('0x16')]);_0x54c768[_0xdbce('0x18')]=qs[_0xdbce('0x18')](_0x30b48e[_0xdbce('0x26')]['offset']);}return _0x5f09af['getDescriptions'](_0x54c768);}})['then'](function(_0x25b45f){if(_0x25b45f){return _0x25b45f?{'count':_0x24ce94,'rows':_0x25b45f}:null;}})[_0xdbce('0x36')](respondWithResult(_0x469d21,null))[_0xdbce('0x3a')](handleError(_0x469d21,null));};