[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 _0xe3a9=['rimraf','fast-json-patch','request-promise','moment','mustache','util','path','to-csv','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/license/util','sendStatus','json','offset','undefined','count','limit','set','Content-Range','apply','reject','save','then','destroy','end','error','stack','name','status','send','index','map','ServicenowConfiguration','rawAttributes','fieldName','type','key','model','keys','filters','intersection','query','attributes','fields','hasOwnProperty','order','sort','where','VIRTUAL','filter','options','include','findAll','rows','catch','length','includeAll','merge','find','create','update','body','params','getFields','findOne','ServicenowField','pick','getSubjects','getDescriptions','nolimit'];(function(_0x67b075,_0x43557d){var _0x39d030=function(_0x4f25e1){while(--_0x4f25e1){_0x67b075['push'](_0x67b075['shift']());}};_0x39d030(++_0x43557d);}(_0xe3a9,0xa2));var _0x9e3a=function(_0x15797a,_0x16274f){_0x15797a=_0x15797a-0x0;var _0x3e2618=_0xe3a9[_0x15797a];return _0x3e2618;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x9e3a('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x9e3a('0x1'));var rp=require(_0x9e3a('0x2'));var moment=require(_0x9e3a('0x3'));var BPromise=require('bluebird');var Mustache=require(_0x9e3a('0x4'));var util=require(_0x9e3a('0x5'));var path=require(_0x9e3a('0x6'));var sox=require('sox');var csv=require(_0x9e3a('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x9e3a('0x8'));var _=require('lodash');var squel=require(_0x9e3a('0x9'));var crypto=require(_0x9e3a('0xa'));var jsforce=require(_0x9e3a('0xb'));var deskjs=require(_0x9e3a('0xc'));var toCsv=require(_0x9e3a('0x7'));var querystring=require(_0x9e3a('0xd'));var Papa=require(_0x9e3a('0xe'));var Redis=require(_0x9e3a('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x9e3a('0x10'));var as=require(_0x9e3a('0x11'));var hardwareService=require(_0x9e3a('0x12'));var logger=require(_0x9e3a('0x13'))('api');var utils=require(_0x9e3a('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x9e3a('0x15'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x34c384,_0x58976d){_0x58976d=_0x58976d||0xcc;return function(_0x527ad8){if(_0x527ad8){return _0x34c384[_0x9e3a('0x16')](_0x58976d);}return _0x34c384['status'](_0x58976d)['end']();};}function respondWithResult(_0x31ef32,_0x36df46){_0x36df46=_0x36df46||0xc8;return function(_0x13e67b){if(_0x13e67b){return _0x31ef32['status'](_0x36df46)[_0x9e3a('0x17')](_0x13e67b);}};}function respondWithFilteredResult(_0x1d0048,_0x488e7a){return function(_0x4c5512){if(_0x4c5512){var _0x4fbded=typeof _0x488e7a[_0x9e3a('0x18')]===_0x9e3a('0x19')&&typeof _0x488e7a['limit']===_0x9e3a('0x19');var _0x481da9=_0x4c5512['count'];var _0x4687b4=_0x4fbded?0x0:_0x488e7a[_0x9e3a('0x18')];var _0x9b0a23=_0x4fbded?_0x4c5512[_0x9e3a('0x1a')]:_0x488e7a[_0x9e3a('0x18')]+_0x488e7a[_0x9e3a('0x1b')];var _0xeaaaa5;if(_0x9b0a23>=_0x481da9){_0x9b0a23=_0x481da9;_0xeaaaa5=0xc8;}else{_0xeaaaa5=0xce;}_0x1d0048['status'](_0xeaaaa5);return _0x1d0048[_0x9e3a('0x1c')](_0x9e3a('0x1d'),_0x4687b4+'-'+_0x9b0a23+'/'+_0x481da9)[_0x9e3a('0x17')](_0x4c5512);}return null;};}function patchUpdates(_0x43afee){return function(_0x28b6eb){try{jsonpatch[_0x9e3a('0x1e')](_0x28b6eb,_0x43afee,!![]);}catch(_0x1a979a){return BPromise[_0x9e3a('0x1f')](_0x1a979a);}return _0x28b6eb[_0x9e3a('0x20')]();};}function saveUpdates(_0x41bc10,_0xad4d3b){return function(_0xf3b331){if(_0xf3b331){return _0xf3b331['update'](_0x41bc10)[_0x9e3a('0x21')](function(_0x45d627){return _0x45d627;});}return null;};}function removeEntity(_0x2e35d5,_0x4224e1){return function(_0x495234){if(_0x495234){return _0x495234[_0x9e3a('0x22')]()[_0x9e3a('0x21')](function(){_0x2e35d5['status'](0xcc)[_0x9e3a('0x23')]();});}};}function handleEntityNotFound(_0x15bb8c,_0x556f7f){return function(_0x5591ca){if(!_0x5591ca){_0x15bb8c[_0x9e3a('0x16')](0x194);}return _0x5591ca;};}function handleError(_0x67d676,_0x2e627c){_0x2e627c=_0x2e627c||0x1f4;return function(_0xfc2bb){logger[_0x9e3a('0x24')](_0xfc2bb[_0x9e3a('0x25')]);if(_0xfc2bb['name']){delete _0xfc2bb[_0x9e3a('0x26')];}_0x67d676[_0x9e3a('0x27')](_0x2e627c)[_0x9e3a('0x28')](_0xfc2bb);};}exports[_0x9e3a('0x29')]=function(_0x558ffa,_0x294963){var _0x3b9571={},_0x4ad5c0={},_0x5bdfe8={'count':0x0,'rows':[]};var _0x4055a1=_[_0x9e3a('0x2a')](db[_0x9e3a('0x2b')][_0x9e3a('0x2c')],function(_0x54f3c4){return{'name':_0x54f3c4[_0x9e3a('0x2d')],'type':_0x54f3c4[_0x9e3a('0x2e')][_0x9e3a('0x2f')]};});_0x4ad5c0[_0x9e3a('0x30')]=_['map'](_0x4055a1,_0x9e3a('0x26'));_0x4ad5c0['query']=_[_0x9e3a('0x31')](_0x558ffa['query']);_0x4ad5c0[_0x9e3a('0x32')]=_[_0x9e3a('0x33')](_0x4ad5c0[_0x9e3a('0x30')],_0x4ad5c0[_0x9e3a('0x34')]);_0x3b9571[_0x9e3a('0x35')]=_[_0x9e3a('0x33')](_0x4ad5c0[_0x9e3a('0x30')],qs[_0x9e3a('0x36')](_0x558ffa['query'][_0x9e3a('0x36')]));_0x3b9571[_0x9e3a('0x35')]=_0x3b9571[_0x9e3a('0x35')]['length']?_0x3b9571['attributes']:_0x4ad5c0[_0x9e3a('0x30')];if(!_0x558ffa[_0x9e3a('0x34')][_0x9e3a('0x37')]('nolimit')){_0x3b9571[_0x9e3a('0x1b')]=qs[_0x9e3a('0x1b')](_0x558ffa[_0x9e3a('0x34')][_0x9e3a('0x1b')]);_0x3b9571[_0x9e3a('0x18')]=qs[_0x9e3a('0x18')](_0x558ffa[_0x9e3a('0x34')]['offset']);}_0x3b9571[_0x9e3a('0x38')]=qs[_0x9e3a('0x39')](_0x558ffa[_0x9e3a('0x34')]['sort']);_0x3b9571[_0x9e3a('0x3a')]=qs['filters'](_['pick'](_0x558ffa['query'],_0x4ad5c0[_0x9e3a('0x32')]),_0x4055a1);if(_0x558ffa[_0x9e3a('0x34')]['filter']){_0x3b9571[_0x9e3a('0x3a')]=_['merge'](_0x3b9571[_0x9e3a('0x3a')],{'$or':_['map'](_0x4055a1,function(_0x3a1cc1){if(_0x3a1cc1[_0x9e3a('0x2e')]!==_0x9e3a('0x3b')){var _0xf63a2d={};_0xf63a2d[_0x3a1cc1[_0x9e3a('0x26')]]={'$like':'%'+_0x558ffa[_0x9e3a('0x34')][_0x9e3a('0x3c')]+'%'};return _0xf63a2d;}})});}_0x3b9571=_['merge']({},_0x3b9571,_0x558ffa[_0x9e3a('0x3d')]);var _0x16fe17={'where':_0x3b9571['where']};return db[_0x9e3a('0x2b')]['count'](_0x16fe17)[_0x9e3a('0x21')](function(_0x59753a){_0x5bdfe8['count']=_0x59753a;if(_0x558ffa['query']['includeAll']){_0x3b9571[_0x9e3a('0x3e')]=[{'all':!![]}];}return db[_0x9e3a('0x2b')][_0x9e3a('0x3f')](_0x3b9571);})[_0x9e3a('0x21')](function(_0x380729){_0x5bdfe8[_0x9e3a('0x40')]=_0x380729;return _0x5bdfe8;})['then'](respondWithFilteredResult(_0x294963,_0x3b9571))[_0x9e3a('0x41')](handleError(_0x294963,null));};exports['show']=function(_0x3393f1,_0xa8d892){var _0x4ae55c={'raw':![],'where':{'id':_0x3393f1['params']['id']}},_0x4199ff={};_0x4199ff[_0x9e3a('0x30')]=_['keys'](db[_0x9e3a('0x2b')]['rawAttributes']);_0x4199ff[_0x9e3a('0x34')]=_[_0x9e3a('0x31')](_0x3393f1[_0x9e3a('0x34')]);_0x4199ff[_0x9e3a('0x32')]=_[_0x9e3a('0x33')](_0x4199ff[_0x9e3a('0x30')],_0x4199ff[_0x9e3a('0x34')]);_0x4ae55c[_0x9e3a('0x35')]=_['intersection'](_0x4199ff[_0x9e3a('0x30')],qs['fields'](_0x3393f1['query']['fields']));_0x4ae55c[_0x9e3a('0x35')]=_0x4ae55c[_0x9e3a('0x35')][_0x9e3a('0x42')]?_0x4ae55c[_0x9e3a('0x35')]:_0x4199ff[_0x9e3a('0x30')];if(_0x3393f1['query'][_0x9e3a('0x43')]){_0x4ae55c[_0x9e3a('0x3e')]=[{'all':!![]}];}_0x4ae55c=_[_0x9e3a('0x44')]({},_0x4ae55c,_0x3393f1['options']);return db[_0x9e3a('0x2b')][_0x9e3a('0x45')](_0x4ae55c)[_0x9e3a('0x21')](handleEntityNotFound(_0xa8d892,null))['then'](respondWithResult(_0xa8d892,null))[_0x9e3a('0x41')](handleError(_0xa8d892,null));};exports[_0x9e3a('0x46')]=function(_0x43fe9f,_0x1a3f22){return db[_0x9e3a('0x2b')][_0x9e3a('0x46')](_0x43fe9f['body'],{})[_0x9e3a('0x21')](respondWithResult(_0x1a3f22,0xc9))[_0x9e3a('0x41')](handleError(_0x1a3f22,null));};exports[_0x9e3a('0x47')]=function(_0x18e5f7,_0xe6c519){if(_0x18e5f7[_0x9e3a('0x48')]['id']){delete _0x18e5f7['body']['id'];}return db[_0x9e3a('0x2b')]['find']({'where':{'id':_0x18e5f7[_0x9e3a('0x49')]['id']}})[_0x9e3a('0x21')](handleEntityNotFound(_0xe6c519,null))[_0x9e3a('0x21')](saveUpdates(_0x18e5f7[_0x9e3a('0x48')],null))['then'](respondWithResult(_0xe6c519,null))[_0x9e3a('0x41')](handleError(_0xe6c519,null));};exports[_0x9e3a('0x22')]=function(_0x10010a,_0x1295f2){return db[_0x9e3a('0x2b')][_0x9e3a('0x45')]({'where':{'id':_0x10010a['params']['id']}})[_0x9e3a('0x21')](handleEntityNotFound(_0x1295f2,null))[_0x9e3a('0x21')](removeEntity(_0x1295f2,null))['catch'](handleError(_0x1295f2,null));};exports[_0x9e3a('0x4a')]=function(_0x28dbda,_0x529971,_0x3ebca6){var _0x518922={};var _0x467ad9={};var _0xdcf8e6;var _0x2970a7;return db[_0x9e3a('0x2b')][_0x9e3a('0x4b')]({'where':{'id':_0x28dbda[_0x9e3a('0x49')]['id']}})[_0x9e3a('0x21')](handleEntityNotFound(_0x529971,null))['then'](function(_0x7366cc){if(_0x7366cc){_0xdcf8e6=_0x7366cc;_0x467ad9[_0x9e3a('0x30')]=_[_0x9e3a('0x31')](db[_0x9e3a('0x4c')][_0x9e3a('0x2c')]);_0x467ad9[_0x9e3a('0x34')]=_[_0x9e3a('0x31')](_0x28dbda[_0x9e3a('0x34')]);_0x467ad9['filters']=_[_0x9e3a('0x33')](_0x467ad9[_0x9e3a('0x30')],_0x467ad9[_0x9e3a('0x34')]);_0x518922['attributes']=_[_0x9e3a('0x33')](_0x467ad9['model'],qs[_0x9e3a('0x36')](_0x28dbda['query'][_0x9e3a('0x36')]));_0x518922[_0x9e3a('0x35')]=_0x518922['attributes'][_0x9e3a('0x42')]?_0x518922[_0x9e3a('0x35')]:_0x467ad9[_0x9e3a('0x30')];_0x518922[_0x9e3a('0x38')]=qs[_0x9e3a('0x39')](_0x28dbda[_0x9e3a('0x34')][_0x9e3a('0x39')]);_0x518922[_0x9e3a('0x3a')]=qs[_0x9e3a('0x32')](_[_0x9e3a('0x4d')](_0x28dbda['query'],_0x467ad9['filters']));if(_0x28dbda[_0x9e3a('0x34')][_0x9e3a('0x3c')]){_0x518922[_0x9e3a('0x3a')]=_[_0x9e3a('0x44')](_0x518922[_0x9e3a('0x3a')],{'$or':_[_0x9e3a('0x2a')](_0x518922['attributes'],function(_0x424232){var _0x2a5518={};_0x2a5518[_0x424232]={'$like':'%'+_0x28dbda[_0x9e3a('0x34')][_0x9e3a('0x3c')]+'%'};return _0x2a5518;})});}_0x518922=_['merge']({},_0x518922,_0x28dbda[_0x9e3a('0x3d')]);return _0xdcf8e6[_0x9e3a('0x4a')](_0x518922);}})[_0x9e3a('0x21')](function(_0x1c4cb3){if(_0x1c4cb3){_0x2970a7=_0x1c4cb3[_0x9e3a('0x42')];if(!_0x28dbda[_0x9e3a('0x34')][_0x9e3a('0x37')]('nolimit')){_0x518922[_0x9e3a('0x1b')]=qs[_0x9e3a('0x1b')](_0x28dbda['query']['limit']);_0x518922['offset']=qs[_0x9e3a('0x18')](_0x28dbda[_0x9e3a('0x34')]['offset']);}return _0xdcf8e6[_0x9e3a('0x4a')](_0x518922);}})[_0x9e3a('0x21')](function(_0x161199){if(_0x161199){return _0x161199?{'count':_0x2970a7,'rows':_0x161199}:null;}})[_0x9e3a('0x21')](respondWithResult(_0x529971,null))['catch'](handleError(_0x529971,null));};exports['getSubjects']=function(_0x5425a9,_0x3e36c6,_0x1584b7){var _0x20e4a5={};var _0x82c25c={};var _0x1e99bd;var _0x34631f;return db[_0x9e3a('0x2b')][_0x9e3a('0x4b')]({'where':{'id':_0x5425a9['params']['id']}})[_0x9e3a('0x21')](handleEntityNotFound(_0x3e36c6,null))[_0x9e3a('0x21')](function(_0x1150f5){if(_0x1150f5){_0x1e99bd=_0x1150f5;_0x82c25c[_0x9e3a('0x30')]=_[_0x9e3a('0x31')](db[_0x9e3a('0x4c')][_0x9e3a('0x2c')]);_0x82c25c[_0x9e3a('0x34')]=_[_0x9e3a('0x31')](_0x5425a9[_0x9e3a('0x34')]);_0x82c25c['filters']=_['intersection'](_0x82c25c[_0x9e3a('0x30')],_0x82c25c['query']);_0x20e4a5[_0x9e3a('0x35')]=_['intersection'](_0x82c25c[_0x9e3a('0x30')],qs['fields'](_0x5425a9[_0x9e3a('0x34')][_0x9e3a('0x36')]));_0x20e4a5[_0x9e3a('0x35')]=_0x20e4a5[_0x9e3a('0x35')]['length']?_0x20e4a5[_0x9e3a('0x35')]:_0x82c25c[_0x9e3a('0x30')];_0x20e4a5['order']=qs['sort'](_0x5425a9[_0x9e3a('0x34')][_0x9e3a('0x39')]);_0x20e4a5[_0x9e3a('0x3a')]=qs[_0x9e3a('0x32')](_[_0x9e3a('0x4d')](_0x5425a9[_0x9e3a('0x34')],_0x82c25c[_0x9e3a('0x32')]));if(_0x5425a9[_0x9e3a('0x34')][_0x9e3a('0x3c')]){_0x20e4a5[_0x9e3a('0x3a')]=_[_0x9e3a('0x44')](_0x20e4a5[_0x9e3a('0x3a')],{'$or':_['map'](_0x20e4a5[_0x9e3a('0x35')],function(_0x4e9ac8){var _0x100081={};_0x100081[_0x4e9ac8]={'$like':'%'+_0x5425a9['query'][_0x9e3a('0x3c')]+'%'};return _0x100081;})});}_0x20e4a5=_[_0x9e3a('0x44')]({},_0x20e4a5,_0x5425a9[_0x9e3a('0x3d')]);return _0x1e99bd[_0x9e3a('0x4e')](_0x20e4a5);}})['then'](function(_0x21e513){if(_0x21e513){_0x34631f=_0x21e513[_0x9e3a('0x42')];if(!_0x5425a9[_0x9e3a('0x34')][_0x9e3a('0x37')]('nolimit')){_0x20e4a5[_0x9e3a('0x1b')]=qs[_0x9e3a('0x1b')](_0x5425a9[_0x9e3a('0x34')][_0x9e3a('0x1b')]);_0x20e4a5['offset']=qs[_0x9e3a('0x18')](_0x5425a9[_0x9e3a('0x34')][_0x9e3a('0x18')]);}return _0x1e99bd['getSubjects'](_0x20e4a5);}})['then'](function(_0x5c4793){if(_0x5c4793){return _0x5c4793?{'count':_0x34631f,'rows':_0x5c4793}:null;}})['then'](respondWithResult(_0x3e36c6,null))[_0x9e3a('0x41')](handleError(_0x3e36c6,null));};exports[_0x9e3a('0x4f')]=function(_0x329a3c,_0x259b7f,_0x1f1436){var _0x215125={};var _0x4cf495={};var _0x52411f;var _0x50ee21;return db[_0x9e3a('0x2b')][_0x9e3a('0x4b')]({'where':{'id':_0x329a3c[_0x9e3a('0x49')]['id']}})[_0x9e3a('0x21')](handleEntityNotFound(_0x259b7f,null))['then'](function(_0x4805f5){if(_0x4805f5){_0x52411f=_0x4805f5;_0x4cf495['model']=_[_0x9e3a('0x31')](db[_0x9e3a('0x4c')][_0x9e3a('0x2c')]);_0x4cf495[_0x9e3a('0x34')]=_[_0x9e3a('0x31')](_0x329a3c[_0x9e3a('0x34')]);_0x4cf495['filters']=_[_0x9e3a('0x33')](_0x4cf495['model'],_0x4cf495['query']);_0x215125[_0x9e3a('0x35')]=_['intersection'](_0x4cf495['model'],qs[_0x9e3a('0x36')](_0x329a3c['query'][_0x9e3a('0x36')]));_0x215125[_0x9e3a('0x35')]=_0x215125[_0x9e3a('0x35')][_0x9e3a('0x42')]?_0x215125[_0x9e3a('0x35')]:_0x4cf495[_0x9e3a('0x30')];_0x215125[_0x9e3a('0x38')]=qs[_0x9e3a('0x39')](_0x329a3c[_0x9e3a('0x34')]['sort']);_0x215125[_0x9e3a('0x3a')]=qs[_0x9e3a('0x32')](_[_0x9e3a('0x4d')](_0x329a3c['query'],_0x4cf495['filters']));if(_0x329a3c[_0x9e3a('0x34')][_0x9e3a('0x3c')]){_0x215125[_0x9e3a('0x3a')]=_['merge'](_0x215125[_0x9e3a('0x3a')],{'$or':_[_0x9e3a('0x2a')](_0x215125[_0x9e3a('0x35')],function(_0x260780){var _0x343988={};_0x343988[_0x260780]={'$like':'%'+_0x329a3c['query'][_0x9e3a('0x3c')]+'%'};return _0x343988;})});}_0x215125=_['merge']({},_0x215125,_0x329a3c[_0x9e3a('0x3d')]);return _0x52411f[_0x9e3a('0x4f')](_0x215125);}})[_0x9e3a('0x21')](function(_0x21b6ba){if(_0x21b6ba){_0x50ee21=_0x21b6ba[_0x9e3a('0x42')];if(!_0x329a3c[_0x9e3a('0x34')][_0x9e3a('0x37')](_0x9e3a('0x50'))){_0x215125[_0x9e3a('0x1b')]=qs['limit'](_0x329a3c[_0x9e3a('0x34')][_0x9e3a('0x1b')]);_0x215125[_0x9e3a('0x18')]=qs[_0x9e3a('0x18')](_0x329a3c['query'][_0x9e3a('0x18')]);}return _0x52411f[_0x9e3a('0x4f')](_0x215125);}})[_0x9e3a('0x21')](function(_0x5dac87){if(_0x5dac87){return _0x5dac87?{'count':_0x50ee21,'rows':_0x5dac87}:null;}})[_0x9e3a('0x21')](respondWithResult(_0x259b7f,null))[_0x9e3a('0x41')](handleError(_0x259b7f,null));};